Patent ID: 7970742
Filing Date: 2011-06-28
Classification: G06F

Abstract:
1. An index object in a relational database management system, the relational database system being implemented using a data storage device and a processor that has access thereto and the index object comprising: an index organized table that is stored in the data storage device and manipulated by the processor, the index organized table containing a B+ index for a time period table object that is stored in the data storage device and manipulated by the processor, the time period table object having one or more time period columns from whose values in the time period table object's rows periods of time are determinable and the index object having leaf nodes which index the rows of the time period table object by the periods of time, the periods of time having a range of sizes and the index organized table including a row for each leaf node in the index and columns including the row for a given leaf node having the index organized table employs representations of open-ended time intervals, the open-ended time intervals beginning with start time values to index a set of current rows.