Method and apparatus for building index of source data

Details Method and apparatus for building index of source data Method and apparatus for building index of source data

2011-04-26

2011-04-26

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S741000, C707S796000, C707S803000, C707S830000, C707SE17014, C707SE17019, C707SE17032, C707SE17049, C707S999100, C707S999102

Reexamination Certificate

active

07933927

ABSTRACT:
An online index building operation is disclosed for building an index from source data with minimal loss of availability to the source data. The source data can be maintained in a relational database system, such as in a tablespace of a DB2® environment. The disclosed operation creates a consistent image of the source data as of a point-in-time and creates an index from the consistent image. Then, the disclosed operation repeats the acts of making the image consistent as of a subsequent point-in-time and updating the index to reflect the subsequent consistent image until substantially caught up with the current changes to the source data. If not caught up, the disclosed operation continues unless it is falling behind at which point the operation terminates. If it is caught up, the disclosed operation locks access to the source data, updates the image to reflect any final changes, updates the index, and allows access to the index.

REFERENCES:
patent: 5603024 (1997-02-01), Goldring
patent: 6618794 (2003-09-01), Sicola et al.

Affiliated with

Also associated with

Rating

Method and apparatus for building index of source data 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 apparatus for building index of source data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for building index of source data will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2682405