System and method for database persistence of transaction logs
AssigneeOracle International Corporation
InventorsWeijun Tian, Paul Parkinson
Life of this patent
Estimating the term…
Abstract
A system and method for database persistence of transaction logs (TLOGs). Embodiments of the invention allow an administrator to configure their system to associate one or more Java Database Connectivity (JDBC) TLOG stores with a data source or database instead of a file system, for use in storing the primary TLOG. This provides an opportunity to exploit the high availability features of a database system; improve handling of disaster recovery scenarios, such as cross-site recovery using database replication; and alleviate the need for third-party distributed file system components, together with their cost and complexity.
Claims9
A system for database persistence of transaction logs, comprising:
- an application server acting as a transaction manager and including one or more applications and a data source or database that can be configured to interface with a Java Database Connectivity (JDBC) persistent store;
- wherein an administrative console or another configuration means can be used by an administrator to associate one or more JDBC transaction log (TLOG) stores with the data source or database configured previously;
- and
- wherein during processing of a transaction involving one or more transaction resources/servers primary, the primary TLOG information associated with the transaction is persistently stored to the configured JDBC TLOG store at the data source or database.
A method for database persistence of transaction logs, comprising the steps of:
- providing an application server acting as a transaction manager and including one or more applications and a data source or database that can be configured to interface with a Java Database Connectivity (JDBC) persistent store;
- wherein an administrative console or another configuration means can be used by an administrator to associate one or more JDBC transaction log (TLOG) stores with the data source or database configured previously;
- and
- wherein during processing of a transaction involving one or more transaction resources/servers primary, the primary TLOG information associated with the transaction is persistently stored to the configured JDBC TLOG store at the data source or database.
A non-transitory computer readable storage medium, including instructions stored thereon, which when read and executed by one or more computers, cause the one or more computers to perform the steps comprising:
- providing an application server acting as a transaction manager and including one or more applications and a data source or database that can be configured to interface with a Java Database Connectivity (JDBC) persistent store;
- wherein an administrative console or another configuration means can be used by an administrator to associate one or more JDBC transaction log (TLOG) stores with the data source or database configured previously;
- and
- wherein during processing of a transaction involving one or more transaction resources/servers primary, the primary TLOG information associated with the transaction is persistently stored to the configured JDBC TLOG store at the data source or database.
Dependencies are inferred from the claim text.