COMPUTER SOFTWARE FRAMEWORK AND METHOD FOR SYNCHRONIZING DATA ACROSS MULTIPLE DATABASES

The present invention discloses a computer software framework and method for synchronizing data across multiple databases. The present invention discloses a method for synchronizing data, which comprises instantiating a first data synchronization service object and a second data synchronization object. The first data synchronization service object is connected to a first datastore, and the second data synchronization service object is connected to a second datastore. A data synchronization message containing relevant information is sent from the first data synchronization service object to an outbox queue on the first datastore. The data synchronization message is propagated from the outbox queue on the first datastore to an inbox queue on the second datastore. The data synchronization message is received from the inbox queue on the second datastore to the second data synchronization object, and the relevant information is persisted in the second datastore. The present invention further discloses a data synchronization framework, which comprises a data synchronization service object connected to an underlying datastore. The data synchronization service object contains a method to send an outgoing synchronization message to the datastore and further contains a method to retrieve an incoming synchronization message from the datastore. The data synchronization framework further comprises a persistence component for persisting relevant information contained in the retrieved incoming data synchronization message to the underlying datastore in response to a persistence request from the synchronization service object. In a preferred embodiment, the datastore is a relational database having an inbox queue and an outbox queue.