Brian P Marshall

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.

US Patent:

8417664, Apr 9, 2013

Filed:

May 16, 2005

Appl. No.:

11/130977

Inventors:

Brian J. Marshall - Napa CA, US
Mark D. Henderson - Thousand Oaks CA, US

Assignee:

CA, Inc. - Islandia NY

International Classification:

G06F 7/00
G06F 17/30
G06F 12/00

US Classification:

707602, 707809, 707829

Abstract:

A method for unloading a database includes copying a data set in physical sequence from a database to a data space and unloading the data set in hierarchical sequence from the data space.

US Patent:

20070282878, Dec 6, 2007

Filed:

May 30, 2006

Appl. No.:

11/444030

Inventors:

Brian J. Marshall - Napa CA, US

International Classification:

G06F 7/00

US Classification:

707101

Abstract:

A method for reorganizing a database comprises receiving at least one update to a first database. The method continues by generating a copy of the first database. The method continues by generating a shadow database, wherein the shadow database represents a reorganized version of the first database and is based at least in part on the copy of the first database. The method continues by applying the at least one update to the shadow database. The method concludes by replacing the first database with the shadow database.