Ca, Inc.

Computer Associates Think, Inc.

Brian J Marshall

Mark D Henderson

Timothy Bruce

Roger J Rogala

Wendy A Webster

Donald F Metzner

Milton I Bailey

Peter J Dres

A method comprises storing a partitioned database comprising a plurality of partitions, wherein each of the plurality of partitions comprises a respective set of data records. The method continues by storing at least one secondary index associated with each of the plurality of partitions. The method continues by taking offline each of the plurality of partitions. The method continues by unloading data records from each of the plurality of partitions. The method continues by loading the data records into the partitioned database. The method continues by, in conjunction with loading the data records, modifying the at least one secondary index. The modification of the at least one secondary index comprises determining a partition identifier and a memory address associated with a particular data record loaded into the partitioned database. The modification of the at least one secondary index further comprises storing the determined partition identifier and the determined memory address in the at least one secondary index.

System and method for rebuilding indices for partitioned databases

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.

Method and apparatus for database unloading

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.

Method and system for online reorganization of databases

Growing community of inventors

Napa, CA, United States of America

Brian J Marshall