Common spool files for maintaining join indexes
AssigneeNCR Corporation
InventorsGrace Kwan On Au, Chi Kim Hoang
Life of this patent
Estimating the term…
Abstract
The retrieval of data from a database in a computerized database management system is optimized through the use of a plurality of join indexed. The join indexes are defined for a table stored in the database. The join indexes are updated to reflect any updated records stored in the table, wherein one or more common joins are identified among the join indexes, each of the common joins are materialized only once in a common spool file, and the common spool file is used to materialize one or more rows for updating the join indexes.
Claims11
A method of optimizing retrieval of data from a database in a computerized database management system, comprising:
- (a) updating one or more records stored in a table in the database;
- and
- (b) updating a plurality of join indexes defined for the table to reflect the updated records stored in the table, wherein one or more common joins are identified among the join indexes, each of the common joins are materialized only once in a common spool file, and the common spool file is used to materialize one or more rows for updating the join indexes.
A computerized database management system for optimizing retrieval of data from a database, comprising:
- (a) logic, performed by the database management system, for:
- (1) updating one or more records stored in a table in the database;
- and
- (2) updating a plurality of join indexes defined for the table to reflect the updated records stored in the table, wherein one or more common joins are identified among the join indexes, each of the common joins are materialized only once in a common spool file, and the common spool file is used to materialize one or more rows for updating the join indexes.
An article of manufacture embodying logic for performing a method of optimizing retrieval of data from a database in a computerized database management system, the method comprising:
- (a) updating one or more records stored in a table in the database;
- and
- (b) updating a plurality of join indexes defined for the table to reflect the updated records stored in the table, wherein one or more common joins are identified among the join indexes, each of the common joins are materialized only once in a common spool file, and the common spool file is used to materialize one or more rows for updating the join indexes.
A data structure stored in a memory for use by a database management system executed by a computer, the data structure comprising a common spool file used to maintain a plurality of join indexes defined on at least one table stored in the database, wherein the plurality of join indexes are updated to reflect updated records stored in the table, by identifying one or more common joins among the join indexes, by materializing each of the common joins only once in the common spool file, and by using the common spool file to materialize one or more rows for updating the join indexes.
Dependencies are inferred from the claim text.