Method to reorganize an index file without sorting by changing the physical order of pages to match the logical order determined from the index structure

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5408654
SERIAL NO

07889454

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A method for reorganizing database index files without performing a conventional sort operation. The index file uses a balanced tree structure, with the logical order of the entries in each page being maintained by the database program. In the reorganizing method the logical order of the leaf pages is determined. A logical order buffer is developed which correlates the logical order to the physical order. This buffer is transposed to a physical order to logical order buffer. A large buffer is set aside in memory and the index file is read sequentially. As each physical page is read, it is placed in its logical position in the large memory buffer. When the large buffer is filled, the pages are sequentially written to a new index file, with the various tree pages being developed in the fly. When the writing operation is completed, the old index file is removed and the new, ordered index file is used.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
BMC SOFTWARE INC2103 CITYWEST BLVD HOUSTON TX 77042

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Barry, Richard E Houston, TX 11 191

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation