05440730 is referenced by 132 patents and cites 11 patents.

A time index for temporal databases is provided which enables the retrieval of database object versions that are valid during specified time periods. Unlike prior access and retrieval structures, the present index is based on objects whose search values are time intervals rather than time points. A series of ordered indexing points is defined by the start and end of object version intervals and these points are used to build an indexing structure, which may take the form of a B.sup.+ -tree. Each leaf node entry of the B.sup.+ -tree represents an indexing point and has an associated bucket of pointers which identify all object versions that are valid at that time. Storage space is reduced by including only incremental change indicators in the buckets of non-leading leaf entries and calculating needed pointers from such indicators. The time index may be employed in multi-level structures with attribute indexes to greatly improve the efficiency of temporal search operations, such as aggregate functions and temporal selection, as well WHEN and JOIN operators.

Title
Time index access structure for temporal databases having concurrent multiple versions
Application Number
7/564881
Publication Number
5440730
Application Date
August 9, 1990
Publication Date
August 8, 1995
Inventor
Tzyh Jain G Wuu
Manalapan
NJ, US
Ramez A Elmasri
Houston
TX, US
Agent
Lionel N White
Leonard Charles Suchyta
Assignee
Bell Communications Research
NJ, US
IPC
G06F 15/40
View Original Source