Method and system for online reorganization of databases

Details Method and system for online reorganization of databases Method and system for online reorganization of databases

2006-10-03

2006-10-03

Le, Uyen (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07117229

ABSTRACT:
A system and method for online reorganization of an existing database that occurs while read and update activity of the existing database continues. The system and method comprise unloading the existing database, reloading the existing database directly to a shadow database, building shadow database indexes, creating a first intermediary image copy of the existing database, analyzing the existing database, capturing updates for the existing database, applying the captured updates to the shadow database, taking the existing database offline, finalizing the shadow database with any remaining updates, creating a final image copy, comparing the existing database and the finalized shadow database, and placing the finalized shadow database online.

REFERENCES:
patent: 6070170 (2000-05-01), Friske et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6460048 (2002-10-01), Teng et al.
patent: 2002/0065792 (2002-05-01), Bonner et al.
Lakhamraju et al, “On-line reorganization in object databases”, ACM 2000, pp. 58-69.

Affiliated with

Also associated with

Rating

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

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3717861