EP0702496A2
Expired / Lapsed
EP
⏱️ 0.0 years remaining
A method and system for updating replicated databases in a telecommunication network system
Assignee: AT&T Inc
•
Filing: 1995-09-06
•
Granted: —
•
Expires: 2015-09-06
Abstract
Abstract A method and system for updating a replicated database of a telecommunications network system is disclosed. The database in a network system improves cost, setup time and system availability. A call transport system has switches for forwarding calls from a local telephone station through the call transport system to a destination. A signaling system is operatively connected to the call transport system and includes a primary site databases within the signaling system 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 database 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 then information concerning the updated database record 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 are completed before the previous version of the database record is deleted.
Inventors
- 👤 Kin K. Leung
Bibliographic Details
Application Number
—
Jurisdiction
EP
Data Source
google_patents
Last Synchronized
2026-11-02 09:49
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
194 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 the customer record in a database contained in a primary site within the 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 the updated database record through the signaling network to at least one secondary site database which contains the replicated version of the primary site database record, adding a field to the database record corresponding to a version number of the database record so as to identify the versions of the records referred by queries of calls in progress, and changing the database record at the secondary site to reflect changes in the database at the primary site by using the version number sequence of the updated database records, while maintaining at all database sites the older version of the database record for query access until after completing the processing of all previous calls querying the version of the database record.
Claim 2
Dependent Claim
50 words
The method according to claim 1 including committing the updated record of the primary and secondary site databases by recording the updated record activity in a log in a stable data storage area after the updated database record has been processed and committed at the primary and secondary sites respectively.
Claim 3
Dependent Claim
33 words
The method according to claim 1 including sending an acknowledgement from the secondary site database back to the primary site database when an updated database record has been processed within the secondary site.
Claim 4
Dependent Claim
27 words
The method according to claim 1 including starting a time-out period when the primary site sends information concerning the updated database record to all secondary site databases.
Claim 5
Dependent Claim
41 words
The method according to claim 4 including the step of resending information concerning the updated record to the secondary site databases again if an acknowledgement of processing completion is not received from the site prior to the expiration of the timeout.
Claim 6
Dependent Claim
45 words
The method according to claim 1 including sending an acknowledgment with the version number of the associated record and the identification of the secondary site database to the primary site, when information concerning an 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 an updated database record for future processing at a secondary site, if processing of the information leads to a new version of the associated 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 the previous database record version at the all database sites after completing the processing of all calls querying the previous version of the database record.
Claim 10
Dependent Claim
43 words
The method according to claim 1 including maintaining multiple versions of 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 11
Dependent Claim
35 words
The method according to claim 1 including adding a field to the record corresponding to a call counter to indicate the number of ongoing calls whose queries have previously accessed that version of the record.
Claim 12
Dependent Claim
35 words
The method according to claim 11 including incrementing the call counter field by one if a new call references to it, and decrementing the call counter field by one when a call setup is completed.
Claim 13
Dependent Claim
21 words
The method according to claim 12 including deleting the previous version of the database record when the call counter is zero.
Claim 14
Dependent Claim
23 words
The method according to claim 1 including the step of verifying the updated database record in the primary site database 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
158 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 site database within the signaling system containing customer records for call routing and other signaling functions and at least one secondary site database containing at least some of the customer records of the primary site database, means for updating a customer record in the primary site database, means for transmitting information concerning the updated database record through the signaling network to the secondary site database containing the previous version of the database record, and 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.
Claim 17
Dependent Claim
28 words
The system according to claim 16 including storage means for recording updated record activity after the updated database record has been processed at the primary and secondary sites.
Claim 18
Dependent Claim
36 words
The system according to claim 16 including means for sending an acknowledgement from the secondary site database back to the primary site database after an updated database record has been processed within the secondary site database.
Claim 19
Dependent Claim
46 words
The system according to claim 16 including means for maintaining multiple versions of customer 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 20
Dependent Claim
35 words
The system according to claim 16 wherein each updated record includes an identifying field corresponding to a version number of the record so as to identify the record referenced by queries of calls in progress.
Claim 21
Dependent Claim
27 words
The system according to claim 20 including means for updating the records in the secondary site database by the version number sequence of the updated database records.
Claim 22
Dependent Claim
32 words
The system according to claim 16 wherein each updated record includes a call counter field for indicating the number of ongoing calls whose queries have previously accessed that version of the record.
Claim 23
Dependent Claim
35 words
The system according to claim 22 including means for incrementing the call counter field if a new call references to it, and means for decrementing the call counter field when a call setup is completed.
Claim 24
Dependent Claim
23 words
The system according to claim 23 including means for deleting the previous version of the database record when the call counter is zero.
Claim 25
Dependent Claim
21 words
The system according to claim 16 wherein said call transport system includes a wireless phone network and a wired phone network.
References Cited (Backward Citations)
No citation records indexed.
USPTO Annuity & Maintenance Windows
Maintenance schedule is calculated for granted US utility patents.