Real Time Data 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.

1 . A computer-implemented method for hybrid replication of a database, the method comprising the steps of:
 (A) determining if a database transaction is a transaction that adds new data to the database or updates data on the database;   (B) for a database transaction that updates data in the database, updating the data locally and replicating the data to the replicated database asynchronously;   (C) for a database transaction that adds new data, adding the new data locally and replicating the data to the replicated database synchronously; and   (E) wherein the method steps are implemented in a computer software program stored in computer memory and executed by a computer processor.   
     
     
         2 . The method of  claim 1  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. 
     
     
         3 . The method of  claim 1  wherein the replicated database is associated with another computer system located remotely from the at least one processor. 
     
     
         4 . The method of  claim 1  wherein the replicated database holds radar information that is updated using hybrid replication. 
     
     
         5 . The method of  claim 1  wherein the step of replicating the data synchronously determines if the replication was successful, and if not successful, then retrying the replication “N” times. 
     
     
         6 . An article of manufacture comprising a replication mechanism stored on a computer recordable media that when executed by a computer processor performs the steps of:
 (A) determining if a database transaction is a transaction that adds new data to the database or updates data on the database;   (B) for a database transaction that updates data in the database, updating the data locally and replicating the data to the replicated database asynchronously;   (C) for a database transaction that adds new data, adding the new data locally and replicating the data to the replicated database synchronously; and   (D) wherein the method steps are implemented in a computer software program stored in computer memory and executed by a computer processor.   
     
     
         7 . The article of manufacture of  claim 6  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. 
     
     
         8 . The article of manufacture of  claim 6  wherein the replicated database is associated with another computer system located remotely from the at least one processor. 
     
     
         9 . The article of manufacture of  claim 6  wherein the replicated database holds radar information that is updated using hybrid replication. 
     
     
         10 . The article of manufacture of  claim 6  wherein the step of replicating the data synchronously determines if the replication was successful, and if not successful, then retrying the replication “N” times.