On-demand multi-version data dictionary to support distributed applications

Patent 7287034 Issued on October 23, 2007. Estimated Expiration Date:

May 8, 2023. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.

Abstract Claims Description Full Text

Patent References

Method for providing data availability in a transaction-oriented system during restart after a failure Patent #: 5333303
Issued on: 07/26/1994
Inventor: Mohan

Inventors

Assignee

Oracle International Corporation

Application

No. 10431604 filed on 05/08/2003

US Classes:

707/101, Manipulating data structure (e.g., compression, compaction, compilation)714/20, Plural recovery data sets containing set interrelation data (e.g., time values or log record numbers)707/100, DATABASE SCHEMA OR DATA STRUCTURE707/203Version management

Examiners

Primary: Mizrahi, Diane D.

Attorney, Agent or Firm

Bingham McCutchen LLP

International Class

G06F 17/30

Abstract

A method, system, and computer program product for transmitting a redo stream from a database to one or more distributed database systems, upon which applications that process the redo stream are implemented, and which maintains the data dictionaries by replicating the multiple versions of the schema objects to data dictionaries in the distributed database systems. A method of maintaining a multi-version data dictionary includes generating a logical redo stream, inserting procedure calls to be used to populate the multi-version data dictionary into the generated logical redo stream, transmitting the logical redo stream to the multi-version data dictionary, and executing the procedure calls at the multi-version data dictionary to populate the multi-version data dictionary.