Deferred maintenance of sparse join indexes
First Claim
Patent Images
1. A method comprising:
- defining a snapshot join index from a join index table using a sparse condition in a join index definition;
comparing a new sparse condition of the snapshot join index with an old sparse condition, wherein the comparing identifies an incremental delta condition between the new sparse condition and the old sparse condition;
identifying rows in a base table as a function of the comparing; and
updating rows in the join index table as a function of the identified rows in the base table.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method include defining a snapshot join index using a sparse condition in a join index definition. A new sparse condition of the snapshot join index is compared with an old sparse condition. Rows in a base table are identified as a function of the comparing, and the join index table is updated using the identified rows.
-
Citations
21 Claims
-
1. A method comprising:
-
defining a snapshot join index from a join index table using a sparse condition in a join index definition; comparing a new sparse condition of the snapshot join index with an old sparse condition, wherein the comparing identifies an incremental delta condition between the new sparse condition and the old sparse condition; identifying rows in a base table as a function of the comparing; and updating rows in the join index table as a function of the identified rows in the base table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A tangible non-transitory computer readable medium having instructions stored thereon to cause a computer to implement a method comprising:
-
defining a snapshot join index from a join index table using a sparse condition in a join index definition; comparing a new sparse condition of the snapshot join index with an old sparse condition, wherein the comparing identifies an incremental delta condition between the new sparse condition and the old sparse condition; identifying rows in a base table as a function of the comparing; and updating rows in the join index table as a function of the identified rows in the base table. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A system comprising:
-
one or more processing units; one or more data storage units coupled to the one or more processors; one or more optimizers executing on the one or more processing units that are configured to; define a snapshot join index from a join index table using a sparse condition in a join index definition; compare a new sparse condition of the snapshot join index with an old sparse condition, wherein the comparing identifies an incremental delta condition between the new sparse condition and the old sparse condition; identify rows in a base table as a function of the compare; and update rows in the join index table as a function of the identified rows in the base table. - View Dependent Claims (18, 19, 20, 21)
-
Specification