Invention Grant
- Patent Title: Index compression in databases
- Patent Title (中): 数据库中的索引压缩
-
Application No.: US12258861Application Date: 2008-10-27
-
Publication No.: US09047330B2Publication Date: 2015-06-02
- Inventor: Daniel James Farrar , Peter Bumbulis , Nathan Michael Auch
- Applicant: Daniel James Farrar , Peter Bumbulis , Nathan Michael Auch
- Applicant Address: US CA Dublin
- Assignee: IANYWHERE SOLUTIONS, INC.
- Current Assignee: IANYWHERE SOLUTIONS, INC.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox P.L.L.C.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
Systems, methods and computer program products for compression of database indexes are described herein. A system embodiment includes a sequence determiner to scan a database index and to determine a start of a range and end of a range of consistently changing values in one or more index pages of said database index and an index updater to update said database index based on a sequence determined by said sequence determiner, while suspending writing of one or more values that lie within start of said range and end of said range of values. A method embodiment includes scanning an index, determining a pattern of changing values in one or more index pages of said index and selectively updating said index based on said determining step to minimize index insertions. The method embodiment further includes determining a start of a range of values and an end of said range of values in an index page, setting appropriate bits to identify said start of range of values and end of range of values, determining if an entry to be inserted can appended to at the end of said range of values, and compressing said index by suspending writing of one or more values that occur between said start of range of values and said end of range of values.
Public/Granted literature
- US20100114843A1 Index Compression In Databases Public/Granted day:2010-05-06
Information query