US5937343A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and system for updating replicated databases in a telecommunication network system
Assignee: AT&T Inc
•
Filing: 1994-09-13
•
Granted: 1999-08-10
•
Expires: 2014-09-13
Abstract
Abstract A method and system of the present invention updates a replicated database of a telecommunications network system. A call transport system forwards calls from a local telephone station to a destination. A signaling system is operatively connected to the call transport system and includes primary site databases containing customer records for call routing and other signaling functions and at least one secondary site database containing the customer records of the primary site database. Both primary and secondary site databases maintain multiple versions of the same customer record so that queries of a call can use a version number to access the corresponding version of the record in the same database for consistent routing and other signaling information. A customer record is updated in the primary site database and that information is transmitted through the signaling network to the secondary site database containing the replicated version of the record. The records are then updated according to the sequence of the version number. The processing of all calls querying the previous version of the primary and secondary site database record is completed before the previous version of the database record is deleted.
Inventors
- 👤 Kin K. Leung
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 14:10
CPC Classifications
H; H04; H04W; H04W8/00; H04W8/02; G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; H04Q; H04Q3/00; H04Q3/0016; H04Q3/0062; H04Q2213/00; H04Q2213/13547; H04W24/00; H04W24/04
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
243 words
A method for updating a replicated database in a telephone network system to improve call setup time and system availability comprising the steps of updating a customer database record contained in a primary database at a primary site within a signaling system of a telephone network, wherein the telephone network includes a call transport system with switches for forwarding calls from a local telephone station through the call transport system to a destination, transmitting information concerning an updated database record in the primary database through the signaling system to at least one secondary database at a secondary site which contains a replicated version of the database record in the primary database, adding a field to the updated database record corresponding to a version number sequence of the database record so as to identify versions of the database records referred by queries of calls in progress, changing the database record in the secondary database to reflect changes in the primary database by using the version number sequence of updated database records, while maintaining at all database sites an older version of the database record that has been updated for query access until after completing the processing of all previous calls querying the older version of the database record, and retransmitting information concerning the updated database record to the secondary database if the primary site does not receive an acknowledgement of processing completion from the secondary site prior to the expiration of a time-out period.
Claim 2
Independent Claim
243 words
A method for updating a replicated database in a telephone network system to improve call setup time and system availability comprising the steps of updating a customer database record contained in a primary database at a primary site within a signaling system of a telephone network, wherein the telephone network includes a call transport system with switches for forwarding calls from a local telephone station through the call transport system to a destination, transmitting information concerning an updated database record in the primary database through the signaling system to at least one secondary database at a secondary site which contains a replicated version of the database record in the primary database, adding a field to the updated database record corresponding to a version number sequence of the database record so as to identify versions of the database records referred by queries of calls in progress, changing the database record in the secondary database to reflect changes in the primary database by using the version number sequence of updated database records, while maintaining at all database sites an older version of the database record that has been updated for query access until after completing the processing of all previous calls querying the older version of the database record, and retransmitting information concerning the updated database record to the secondary database if the primary site does not receive an acknowledgement of processing completion from the secondary site prior to the expiration of a time-out period.
Claim 3
Dependent Claim
53 words
The method according to claim 1 including committing the updated database records contained in the databases at the primary and secondary sites by recording updated record activity in a log in a stable data storage area after the updated database records have been processed and committed at the primary and secondary sites respectively.
Claim 4
Dependent Claim
30 words
The method according to claim 1 including sending an acknowledgement from the secondary site to the primary site after an updated database record has been processed within the secondary database.
Claim 5
Dependent Claim
26 words
The method according to claim 1 including starting the time-out period when the primary site sends information concerning the updated database record to the secondary site.
Claim 6
Dependent Claim
45 words
The method according to claim 1 including sending an acknowledgment with a version number of the updated database record and the identification of the secondary database to the primary site, when information concerning the updated database record is received by the secondary site in duplication.
Claim 7
Dependent Claim
40 words
The method according to claim 1 including storing information concerning the updated database record for future processing at the secondary site, if processing of the information leads to a new version of the database record with an out-of-sequence version number.
Claim 8
Dependent Claim
19 words
The method according to claim 1 including discarding acknowledgments at the primary site, if they are received in duplication.
Claim 9
Dependent Claim
33 words
The method according to claim 1 including deleting a previous version of the database record at all sites after completing the processing of all calls querying the previous version of the database record.
Claim 10
Dependent Claim
44 words
The method according to claim 1 including maintaining multiple versions of database records at the primary and secondary sites so that queries for a call can access the same version of the associated record in the same database for consistent routing and signaling information.
Claim 11
Dependent Claim
34 words
The method according to claim 1 including adding a call counter field to the database record to indicate the number of ongoing calls whose queries have previously accessed that version of the database record.
Claim 12
Dependent Claim
41 words
The method according to claim 10 including incrementing the value in the call counter field by one if a new call references to it, and decrementing the value in the call counter field by one when a call setup is completed.
Claim 13
Dependent Claim
25 words
The method according to claim 11 including deleting the previous version of the database record when the value in the call counter field is zero.
Claim 14
Dependent Claim
23 words
The method according to claim 1 including the step of verifying the updated database record located at the primary site for data inconsistency.
Claim 15
Dependent Claim
21 words
The method according to claim 1 wherein the call transport system includes a wireless phone network and a wired phone network.
Claim 16
Independent Claim
193 words
A system for updating replicated databases in a telephone network system to improve call setup time and system availability comprising a call transport system having switches for forwarding calls from a local telephone station through the call transport system to a destination, a signaling system operatively connected to the call transport system, and including a primary database at a primary site within the signaling system containing customer database records for call routing and other signaling functions and at least one secondary database at a secondary site containing at least some of the customer database records of the primary database, means for updating a customer database record in the primary database, means for transmitting information concerning the updated customer database record through the signaling system to the secondary database containing a previous version of the database record that had been updated in the primary database, means responsive to the completion of all calls querying the previous version of both primary and secondary database records for deleting the previous version of the database record, and means for updating the database records in the secondary database by a version number sequence of the updated database records.
Claim 17
Independent Claim
193 words
A system for updating replicated databases in a telephone network system to improve call setup time and system availability comprising a call transport system having switches for forwarding calls from a local telephone station through the call transport system to a destination, a signaling system operatively connected to the call transport system, and including a primary database at a primary site within the signaling system containing customer database records for call routing and other signaling functions and at least one secondary database at a secondary site containing at least some of the customer database records of the primary database, means for updating a customer database record in the primary database, means for transmitting information concerning the updated customer database record through the signaling system to the secondary database containing a previous version of the database record that had been updated in the primary database, means responsive to the completion of all calls querying the previous version of both primary and secondary database records for deleting the previous version of the database record, and means for updating the database records in the secondary database by a version number sequence of the updated database records.
Claim 18
Dependent Claim
28 words
The system according to claim 15 including storage means for recording database record activity after the updated database record has been processed at the primary and secondary sites.
Claim 19
Dependent Claim
32 words
The system according to claim 15 including means for sending an acknowledgement from the secondary site to the primary site after an updated database record has been processed within the secondary database.
Claim 20
Dependent Claim
47 words
The system according to claim 15 including means for maintaining multiple versions of customer database records in the primary and secondary databases so that queries for a call can access the same version of the associated record in the same database for consistent routing and signaling information.
Claim 21
Dependent Claim
38 words
The system according to claim 15 wherein each updated database record includes an identifying field corresponding to a version number of the database record so as to identify the database record referenced by queries of calls in progress.
Claim 22
Dependent Claim
33 words
The system according to claim 15 wherein each database record includes a call counter field for indicating the number of ongoing calls whose queries have previously accessed that version of the database record.
Claim 23
Dependent Claim
45 words
The system according to claim 20 including means for incrementing the value in the call counter field by one if a new call references to it, and means for decrementing the value in the call counter field by one when a call setup is completed.
Claim 24
Dependent Claim
27 words
The system according to claim 21 including means for deleting the previous version of the database record when the value in the call counter field is zero.
Claim 25
Dependent Claim
21 words
The system according to claim 15 wherein said call transport system includes a wireless phone network and a wired phone network.
References Cited (Backward Citations)
US3835260A
Cited
WO1984002023A1
Cited
EP0217351A2
Cited
US4714996A
Cited
WO1989005551A1
Cited
EP0366341A2
Cited
US5097499A
Cited
US5243645A
Cited
US5218716A
Cited
US5475689A
Cited
US5185742A
Cited
US5311572A
Cited
US5280612A
Cited
US5423068A
Cited
US5341410A
Cited
US5353335A
Cited
WO1994004006A1
Cited
US5594942A
Cited
US5668862A
Cited
US5781855A
Cited
US5539924A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-08-09 | 2003-02-08 | 2003-08-10 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-08-09 | 2007-02-08 | 2007-08-10 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-08-09 | 2011-02-08 | 2011-08-10 | $7700.00 | Window Closed / Lapsed |