US5933837A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Apparatus and method for maintaining integrated data consistency across multiple databases
Assignee: AT&T Properties LLC
•
Filing: 1997-05-09
•
Granted: 1999-08-03
•
Expires: 2017-05-09
Abstract
Abstract A database network having a primary database and a plurality of heterogeneous subscribing databases for replicating data updates of the primary database in the heterogeneous subscribing databases includes a database engine connected to the primary database for capturing the data updates in the primary database, a query manager connected to the database engine for generating queries, where each of the queries is translated based on a specified format for each of the heterogeneous subscribing databases, and a data distributor connected to the query manager for distributing the translated queries to the heterogeneous subscribing databases.
Inventors
- 👤 Fen-Chung Kung
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 17:35
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2471; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/959; Y10S707/964; Y10S707/966; Y10S707/99931; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 16
Claim 1
Independent Claim
144 words
A database network having a primary database having a first format and a plurality of heterogenous subscribing databases, said heterogenous subscribing databases having formats different from said primary database, said heterogenous subscribing databases for replicating data updates of said primary database, said database network comprising: a database engine coupled to said primary database for capturing said data updates with said first format in said primary database; a query manager coupled to said database engine for generating at least one database update query using said data updates, said database update query being translated from said first format into a format for a corresponding heterogenous subscribing data base and forming a translated database update query based on a format for said heterogenous subscribing database and a data distributor coupled to said query manager for distributing said translated database update query to the corresponding heterogenous subscribing database.
Claim 2
Dependent Claim
144 words
A database network having a primary database having a first format and a plurality of heterogenous subscribing databases, said heterogenous subscribing databases having formats different from said primary database, said heterogenous subscribing databases for replicating data updates of said primary database, said database network comprising: a database engine coupled to said primary database for capturing said data updates with said first format in said primary database; a query manager coupled to said database engine for generating at least one database update query using said data updates, said database update query being translated from said first format into a format for a corresponding heterogenous subscribing data base and forming a translated database update query based on a format for said heterogenous subscribing database and a data distributor coupled to said query manager for distributing said translated database update query to the corresponding heterogenous subscribing database.
Claim 3
Dependent Claim
50 words
The database network in claim 1, further comprising: a subscription controller for verifying that at least one of said heterogenous subscribing databases needs said data updates; and said query manager for generating database update queries only for said at least one of said heterogenous subscribing databases that needs said updates.
Claim 4
Dependent Claim
22 words
The database network in claim, further comprising a synchronization manager coupled to said query manager for controlling said database update query distribution.
Claim 5
Dependent Claim
29 words
The database network in claim 3, further comprising a plurality of update queues coupled to said query manager for storing said database update queries generated from said query manager.
Claim 6
Dependent Claim
22 words
The database network in claim 4, further comprising a queue controller coupled to said update queues for prioritizing said queues in distribution.
Claim 7
Dependent Claim
42 words
The database network in claim 5, further comprising: a concurrence controller connected to said queue controller for opening distribution channels of said distributor; and said synchronization manager enables said concurrence controller only if said queues can be handled by said concurrence controller.
Claim 8
Dependent Claim
37 words
The database network in claim 3, further comprising: a response handler for verifying completion of said updates in said subscribing databases; and said synchronization manager for redistributing said queries if said updates in said subscribing databases fail.
Claim 9
Independent Claim
92 words
A method of replicating data updates of a primary database in a plurality of heterogenous subscribing databases in a database network having said primary database and said heterogenous subscribing databases, comprising: capturing said data updates in said primary database; generating database update queries from said data updates in said primary database, each of said database update queries being translated into a format compatible with said heterogenous subscribing databases based on a specified format for each of said heterogenous subscribing databases; and distributing said translated database update queries to said heterogenous subscribing databases.
Claim 10
Independent Claim
92 words
A method of replicating data updates of a primary database in a plurality of heterogenous subscribing databases in a database network having said primary database and said heterogenous subscribing databases, comprising: capturing said data updates in said primary database; generating database update queries from said data updates in said primary database, each of said database update queries being translated into a format compatible with said heterogenous subscribing databases based on a specified format for each of said heterogenous subscribing databases; and distributing said translated database update queries to said heterogenous subscribing databases.
Claim 11
Dependent Claim
42 words
The method in claim 8, further comprising the step of: verifying that at least one of said heterogenous subscribing databases needs said updates; and generating database update queries only for at least one of said subscribing heterogenous databases that need said update.
Claim 12
Dependent Claim
14 words
The method in claim 8, further comprising the step of controlling said query distribution.
Claim 13
Dependent Claim
20 words
The method in claim 10, further comprising the step of storing said database update queries generated from said query manager.
Claim 14
Dependent Claim
15 words
The method in claim 11, further comprising the step of prioritizing said queues in distribution.
Claim 15
Dependent Claim
32 words
The method in claim 12, further comprising the steps of: opening distribution channels of said distributor; and enabling said distribution channels only if said queues can be handled by said distribution channels.
Claim 16
Dependent Claim
31 words
The method in claim 10, further comprising the steps of: verifying completion of said updates in said subscribing databases; and redistributing said queries if said updates in said subscribing databases fail.
References Cited (Backward Citations)
US4714995A
Cited
US5452450A
Cited
US5432931A
Cited
US5806068A
Cited
US5596744A
Cited
US5542078A
Cited
US5634053A
Cited
US5870746A
Cited
US5794248A
Cited
US5794247A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-08-02 | 2003-02-01 | 2003-08-03 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-08-02 | 2007-02-01 | 2007-08-03 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-08-02 | 2011-02-01 | 2011-08-03 | $7700.00 | Window Closed / Lapsed |