Remote duplicate database facility with database replication support for online DDL operations

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5745753
SERIAL NO

08377881

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A local computer system has a local database, application programs that modify the local database, and a transaction manager that stores audit records in a local audit trail reflecting those application program modifications to the local database. A remotely located computer system has a backup database. A remote data duplication facility (RDF) maintains virtual synchronization of the backup database with the local database. The RDF includes an extractor process executed by the local computer system, and a receiver process and a plurality of updater processes executed by the remote computer system. The extractor process extracts audit records from the local audit trail and transmits those records to the receiver process. The receiver distributes the received audit records to a plurality of image trail files in the remote computer system for processing by updater processes, which initiate redo operations of database modifications denoted in at least a subset of the audit records against the backup database. A catalog manager on the local computer system performs online database restructurings while application programs continue to modify the database. The transaction manager stores a Stop Updaters audit record in the local audit trail when each online database restructuring successfully completes. The extractor process transmits the Stop Updaters audit record to the remote computer system and the receiver process moves a copy of each received Stop Updaters audit record into all of the image trails. Finally, each updater process stops execution when it reads a Stop Updaters audit record in its assigned image trail file.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Mosher, Jr Malcolm Los Gatos, CA 13 1029

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation