← Back to Patent Explorer
US6779002B1 Expired / Lapsed US ⏱️ 0.0 years remaining

Computer software framework and method for synchronizing data across multiple databases

Assignee: Sprint Communications Co LP
•
Filing: 2000-06-13
•
Granted: 2004-08-17
•
Expires: 2020-06-13
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract 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.

Inventors

  • 👤 James G. Mwaura

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-29 20:15
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/275; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942; Y10S707/99944; Y10S707/99945; Y10S707/99951; Y10S707/99952; Y10S707/99954

Claims Analysis

Total Claims: 15
Claim 1
Independent Claim 115 words
A data synchronization framework, comprising: a plurality of data synchronization service objects connected to a corresponding plurality of underlying databases, each or the data synchronization service objects having a method to send an outgoing synchronization message to the corresponding database and a method to retrieve an incoming synchronization message from the corresponding database; and a message handler object having a method for persisting relevant information contained in the incoming data synchronization message to the underlying databases in response to a persistence request from the synchronization service objects such that common data is synchronized between the databases, wherein sending and receiving of messages between databases occur at a database layer in contrast to an application layer.
Claim 2
Dependent Claim 115 words
A data synchronization framework, comprising: a plurality of data synchronization service objects connected to a corresponding plurality of underlying databases, each or the data synchronization service objects having a method to send an outgoing synchronization message to the corresponding database and a method to retrieve an incoming synchronization message from the corresponding database; and a message handler object having a method for persisting relevant information contained in the incoming data synchronization message to the underlying databases in response to a persistence request from the synchronization service objects such that common data is synchronized between the databases, wherein sending and receiving of messages between databases occur at a database layer in contrast to an application layer.
Claim 3
Dependent Claim 24 words
The framework of claim 1 wherein at least one of the databases is a relational database having an inbox queue and an outbox queue.
Claim 4
Dependent Claim 25 words
The framework of claim 2 further comprising an inbox queue monitor which monitors the inbox queue and retrieves any incoming data synchronization messages contained therein.
Claim 5
Dependent Claim 17 words
The framework of claim 3 wherein the data synchronization message is in the form of an object.
Claim 6
Dependent Claim 17 words
The framework of claim 4 further comprising a message factory for assembling the data synchronization message object.
Claim 7
Dependent Claim 21 words
The framework of claim 5 further comprising a message mapper to populate the data synchronization message object with the relevant information.
Claim 8
Independent Claim 158 words
A method for synchronizing data, comprising: (a) instantiating a first data synchronization service object and a second data synchronization service object, the first data synchronization service object being connected to a first database and the second data synchronization service object being connected to a second database; (b) sending a data synchronization message containing relevant information from the first data synchronization service object to an outbox queue on the first database; (c) propagating the data synchronization message from the outbox queue on the first database to an inbox queue on the second database; (d) receiving the data synchronization message from the inbox queue on the second database to the second data synchronization object; and (e) persisting the relevant information in the second database such that common data is synchronized between the first and second databases, wherein the sending and receiving of messages between the first and second databases occur at a database layer in contrast to an application layer.
Claim 9
Independent Claim 158 words
A method for synchronizing data, comprising: (a) instantiating a first data synchronization service object and a second data synchronization service object, the first data synchronization service object being connected to a first database and the second data synchronization service object being connected to a second database; (b) sending a data synchronization message containing relevant information from the first data synchronization service object to an outbox queue on the first database; (c) propagating the data synchronization message from the outbox queue on the first database to an inbox queue on the second database; (d) receiving the data synchronization message from the inbox queue on the second database to the second data synchronization object; and (e) persisting the relevant information in the second database such that common data is synchronized between the first and second databases, wherein the sending and receiving of messages between the first and second databases occur at a database layer in contrast to an application layer.
Claim 10
Dependent Claim 34 words
The method of claim 7 further comprising the step of deconstructing the data synchronization message from an object to a string prior to its being propagated from the outbox queue on the first database.
Claim 11
Dependent Claim 24 words
The method of claim 7 further comprising monitoring the inbox queue on the second database to detect the presence of a data synchronization message.
Claim 12
Dependent Claim 31 words
The method of claim 9 further comprising the step of assembling a data synchronization message object from a string after its being received by the inbox queue on the second database.
Claim 13
Dependent Claim 18 words
The method of claim 10 wherein a message factory is used to assemble the data synchronized message object.
Claim 14
Dependent Claim 20 words
The method of claim 11 further comprising the step of populating the data synchronization message object with the relevant information.
Claim 15
Dependent Claim 21 words
The method of claim 12 wherein a message handler object is used to persist the relevant information to the second database.

References Cited (Backward Citations)

US5542078A Cited
US6088717A Cited
US5944783A Cited
US20030055929A1 Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2007-08-17 2008-02-16 2008-08-17 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2011-08-17 2012-02-16 2012-08-17 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2015-08-17 2016-02-16 2016-08-17 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag