Deferred maintenance of sparse join indexes

Details Deferred maintenance of sparse join indexes Deferred maintenance of sparse join indexes

2008-08-05

2011-10-04

Timblin, Robert (Department: 2167)

Data processing: database and file management or data structures

Data integrity

Index maintenance

C707S741000

Reexamination Certificate

active

08032503

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.

REFERENCES:
patent: 5758145 (1998-05-01), Bhargava et al.
patent: 5983215 (1999-11-01), Ross et al.
patent: 6122626 (2000-09-01), Brandsma
patent: 6345272 (2002-02-01), Witkowski et al.
patent: 6347253 (2002-02-01), Fujita et al.
patent: 6470331 (2002-10-01), Chen et al.
patent: 6505188 (2003-01-01), Ghazal et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6546402 (2003-04-01), Beyer et al.
patent: 6618720 (2003-09-01), On Au et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6732096 (2004-05-01), Au
patent: 6820095 (2004-11-01), Yeung et al.
patent: 6952692 (2005-10-01), Bhattiprolu et al.
patent: 6959313 (2005-10-01), Kapoor et al.
patent: 7092951 (2006-08-01), Luo et al.
How to use Oracle9i bitmap join indexes. Nov 12, 2002—Donald Burleson. http://www.dba-oracle.com/ar—builder—bitmap—join—idx.htm.
Blakeley, J.A.; Martin, N.L.; , “Join index, materialized view, and hybrid-hash join: a performance analysis,” Data Engineering, 1990. Proceedings. Sixth International Conference on , vol., No., pp. 256-263, Feb. 5-9, 1990 doi: 10.1109/ICDE.1990.113476.
Patrick Valduriez, Join indices, ACM Transactions on Database Systems (TODS), v.12 n.2, p. 218-246, Jun. 1987.
Rotem, D.; , “Spatial join indices,” Data Engineering, 1991. Proceedings. Seventh International Conference on , vol., No., pp. 500-509, Apr. 8-12, 1991 doi: 10.1109/ICDE.1991.131499 URL: http://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=131499&isnumber=3639.
“U.S. Appl. No. 12/186,173, Non Final Office Action mailed Dec. 8, 2010”, 19 pgs.
“U.S. Appl. No. 12/186,173, Response filed Mar. 8, 2011 to Non Final Office Action mailed Dec. 8, 2010”, 9 pgs.

Affiliated with

Also associated with

Rating

Deferred maintenance of sparse join indexes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Deferred maintenance of sparse join indexes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Deferred maintenance of sparse join indexes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4301657