MARK ARNOLD GAPONOFF
Pilots at 86 Ave, Mercer Island, WA
License number
Washington A4614494
Issued Date
Jan 2017
Expiration Date
Jan 2019
Category
Airmen
Type
Authorized Aircraft Instructor
Address
Address
4657 86Th Ave SE, Mercer Island, WA 98040
Professional information
Efficient Indexing Of Hierarchical Relational Database Records
US Patent:
2005019, Sep 8, 2005
Filed:
Feb 10, 2005
Appl. No.:
11/056379
Inventors:
Mark Gaponoff - Mercer Island WA, US
International Classification:
G06F007/00
US Classification:
707003000
Abstract:
According to various embodiments, systems, and methods, a sorting construct (TREE_SORT) is generated to efficiently traverse hierarchical data structures in relational databases. A TREE_SORT construct is generated by transforming a value that represents the sequential order of a given node relative to its siblings (Peer_Sequence) to a left-justified string of a given width. A TREE_SORT value for the parent of a given node is prepended to the left of the generated substring of the transformed Peer_Sequence value. As a result, a sorting construct of the parent node sorts before sorting constructs of child nodes.