Milton I Bailey

US Patent:

7117229, Oct 3, 2006

Filed:

May 31, 2002

Appl. No.:

10/159613

Inventors:

Brian J. Marshall - Napa CA, US
Mark D. Henderson - Thousand Oaks CA, US
Milton I. Bailey - Carrollton TX, US
Timothy R. Bruce - Carrollton TX, US
Roger J. Rogala - Napa CA, US
Wendy A. Webster - Boulder CO, US
Donald F. Metzner - Lyons CO, US
Peter J. Dres - Soquel CA, US

Assignee:

Computer Associates Think, Inc. - Islandia NY

International Classification:

G06F 17/00

US Classification:

707200, 707202, 707204, 707206

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.