Bmc Software, Inc.

Richard Wayne Cline

Thomas G Price

William J Pothoff

Stanley James Dee

Michel Laviolette

John Grady Sullivan

Methods, devices and systems to make compressed backup copies of in-use compressed database indices are described. In general, an 'oldest' time at which index pages in working memory had been updated is identified. Compressed index pages may be directly copied without the need to bring them into working memory or uncompressing them. The identified 'oldest' time is then associated with the compressed backup copy. In some embodiments, an entire compressed backup copy may be associated with a single point in time (e.g., the identified &#x201c;oldest&#x201d; time). In other embodiments, a compressed backup copy may be associated with multiple points in time (e.g., one time for each portion of the compressed index that is being backed-up). Compressed indices copied in accordance with the invention may be used during restore operations to reconstruct database indices using the identified &#x201c;oldest&#x201d; time and database log files.

Copying compressed pages without uncompressing the compressed pages

In one aspect, a computer-implemented method for ensuring a source database (e.g., target space or index space) has correct version information before a migration includes executing, using at least one processor, instructions recorded on a computer-readable storage medium. The instructions include determining whether a table has been changed since a most recent alter of the table, performing an update on the table when it is determined that the table has not been changed since the most recent alter, and performing a rollback on the table after the update. The method may also include creating an image copy of the data in the source database and refreshing data in a target database with the image copy of the data in the source database. The method may also include automatically repairing the target database when the version information of the target does not correspond with the version information for the source.

Systems and methods for migrating database data

Unobtrusive copies of actively used compressed indices

In one general aspect, a computer-implemented method for migrating data from a source database to a target database includes a computer-implemented method that includes executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium. The method includes ensuring that the source database has correct version information, creating an image copy of the data in the source database, and collecting metadata describing the source database. The metadata may include information used to verify that the target database is compatible with the source database, to automatically translate object identifiers, and to avert the migration if no data has changed in the source and the target databases (e.g., table and index spaces) since a previous migration. The method may further include refreshing the data in the target database using the image copy after determining that the source database and the target database are compatible.

Methods and systems for providing access to spaces in a database during a recovery process affecting the database. Spaces in the database that are affected by the recovery process are identified and I/O requests sent to a media manager associated with the database are intercepted. If the I/O request is for a read operation to a space affected by the recovery process and the corresponding page has been recovered, the data in the page may be read. If the page has not been recovered, the read operation may be held in a cache until the recovery utility indicates that the page has been recovered. If the I/O request is for a write operation to a space affected by the recovery process, the data may be written to a cache.

Growing community of inventors

Austin, TX, United States of America

Richard Wayne Cline