Real time data replication

• US 8,364,636 B2
• Filed: 09/14/2009
• Issued: 01/29/2013
• Est. Priority Date: 09/14/2009
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Newport, William T., Stecher, John J.
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US12/558,898
• Publication Number:
  US 20110066592A1
• Time in Patent Office: 1,233 Days
• Field of Search: 707/612, 707/615, 707/637, 707/640
• US Class Current: 707/612
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A combination of synchronous and asynchronous replication of data is used to replicate a local database to a replicated database. The typical tradeoff between synchronous and asynchronous replication is optimized by using hybrid replication, which is to use synchronous replication for inserting new data and asynchronous replication for updating existing data. The combined use of synchronous and asynchronous in this manner provides an efficient replicated database where the replicated database can tolerate some delay in data updates but requires no data loss of new data.

Claims

1. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor having a local database;

a database replication mechanism that sends transactions to a replicated database using synchronous data replication and asynchronous data replication, where the database replication mechanism uses synchronous data replication to keep the replicated database updated with current information for transactions that add new data to the replicated database, and the database replication mechanism uses asynchronous data replication for transactions that update data in the replicated database, where the asynchronous data replication is updating at specified intervals with batches of data rather than when new data is present at the local database; and

wherein the transaction to add new data to the replicated database is a database INSERT operation and the asynchronous replication transaction to update data in the replicated database is a database UPDATE operation.

2. The apparatus of claim 1 wherein the replicated database is associated with another computer system located remotely from the at least one processor.

3. The apparatus of claim 1 wherein the replicated database holds radar information that is updated using hybrid replication.

4. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor having a local database;

a replicated database associated with another computer system located remotely from the at least one processor;

a database replication mechanism that sends transactions to the replicated database using synchronous data replication and asynchronous data replication, where the database replication mechanism uses synchronous data replication to keep the replicated database updated with current information for transactions that add new data to the replicated database, and the database replication mechanism uses asynchronous data replication for transactions that update data in the replicated database, where the asynchronous data replication is updating at specified intervals with batches of data rather than when new data is present at the local database; and

wherein the transaction to add new data to the replicated database is a database INSERT operation and the asynchronous replication transaction to update data in the replicated database is a database UPDATE operation.