Method and system for deferred maintenance of database indexes

Details Method and system for deferred maintenance of database indexes Method and system for deferred maintenance of database indexes

2011-05-17

2011-05-17

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Data integrity

Index maintenance

C707S820000

Reexamination Certificate

active

07945543

ABSTRACT:
Rectifying discrepancies between a table, from which a segment of data has been removed, and an index for the table may be deferred. Each entry in the index is sequentially analyzed to remove entries therefrom referring to any removed segment referenced in the starting location list. During this process, if a segment newly removed from the table is detected, then analysis of the index entries continues and an indicator is set that another segment has been removed. Analysis of the entries continues in a looping fashion until each entry has been assessed to determine if it makes a reference to any of the removed segments. If a query is received before rectification is complete then the query is amended by establishing search boundaries based so that the query does not produce any entries in the index referring to removed segments.

REFERENCES:
patent: 5551027 (1996-08-01), Choy et al.
patent: 5765168 (1998-06-01), Burrows
patent: 5842196 (1998-11-01), Agarwal et al.
patent: 5960194 (1999-09-01), Choy et al.
patent: 6026412 (2000-02-01), Sockut et al.
patent: 6272502 (2001-08-01), Lieuwen et al.
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6374263 (2002-04-01), Bunger et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6438562 (2002-08-01), Gupta et al.
patent: 6721739 (2004-04-01), Mende et al.
patent: 7181453 (2007-02-01), Ronstrom
patent: 7263536 (2007-08-01), Pederson
patent: 7308456 (2007-12-01), Friske et al.
patent: 7490084 (2009-02-01), Kothuri et al.
patent: 2005/0091180 (2005-04-01), Peleg et al.
Dan Hotka, A Closer Look at Oracle8i Data Block Internals, Published Feb. 9, 2001, pp. 1-8. www.informit.com.

Affiliated with

Also associated with

Rating

Method and system for deferred maintenance of database 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 Method and system for deferred maintenance of database indexes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for deferred maintenance of database indexes will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2637997