Patent EP0702497A2 successfully refreshed from Google Patents.
← Back to Patent Explorer
EP0702497A2 Expired / Lapsed EP ⏱️ 0.0 years remaining

A method and system for updating replicated databases in telecommunication networks

Assignee: AT&T Inc
•
Filing: 1995-09-06
•
Granted: —
•
Expires: 2015-09-06
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A method and system for updating a replicated database in a foreign and home telecommunication network system to improve call setup time and system availability in a foreign region for roaming customers is disclosed. Customer records are updated in a visitor database contained in a foreign region within the signaling system of foreign telecommunications network. Information concerning the updated database record is transmitted from the visitor database through the signaling network of a home country to a home database which contains the replicated version of the visitor database record in the foreign region. A field is added to the database record corresponding to a version number of the database record so as to identify the record referenced by queries of calls in progress. The home database record at the home country is changed to reflect changes in the visitor database at the foreign region by using the version number sequence 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 database record.

Inventors

  • 👤 Kin K. Leung

Bibliographic Details

Application Number —
Jurisdiction EP
Data Source google_patents
Last Synchronized 2026-11-01 15:23
CPC Classifications
H; H04; H04W; H04W8/00; H04W8/02; H04W8/08; G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; H04Q; H04Q3/00; H04Q3/0016; H04Q3/0029; H04Q3/42; H04Q3/54; H04Q3/545; H04Q3/54508; H04Q3/54516; H04Q2213/00; H04Q2213/1305; H04Q2213/13098; H04Q2213/13103; H04Q2213/13109; H04Q2213/13176; H04Q2213/13376; H04Q2213/13513; H04Q2213/13532; H04Q2213/13547; H04W8/30

Claims Analysis

Total Claims: 29
Claim 1
Independent Claim 211 words
A method for updating a replicated database in foreign and home telecommunication network systems to improve call setup time and system availability in a foreign region for roaming customers comprising the steps of updating the customer record in a visitor database contained in a foreign region within the signalling system of a foreign telecommunication network, wherein the telecommunications network includes a call transport system with switches for forwarding calls from a local foreign station through the call transport system to a destination, transmitting information concerning the updated database record from the visitor database through the signaling network of a home telecommunication system to a home database which contains the replicated version of the visitor database record in the foreign region, 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 home database record at the home country to reflect changes in the visitor database at the foreign region by using the version number sequence, 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 28 words
The method according to claim 1 including launching queries to the home database when calls are originated from the home country to network customers in the foreign region.
Claim 3
Dependent Claim 24 words
The method according to claim 1 including launching queries to the visitor database when calls are originated from the foreign region to a customer.
Claim 4
Dependent Claim 29 words
The method according to claim 3 including directing the query to the home database for accessing the customer record if the customer is not roaming in a foreign region.
Claim 5
Dependent Claim 25 words
The method according to claim 1 including the step of removing records from the visitor database when the associated network customers leave the foreign region.
Claim 6
Dependent Claim 49 words
The method according to claim 1 including committing the updated record of the visitor and home 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 visitor and home databases respectively.
Claim 7
Dependent Claim 31 words
The method according to claim 1 including sending an acknowledgement from the home database back to the visitor database when an updated database record has been processed within the home database.
Claim 8
Dependent Claim 43 words
The method according to claim 1 including the step of maintaining current location information in the visitor database for highly mobile customers traveling in the foreign region and maintaining an identifier in the home database directing calls to the visitor database for queries.
Claim 9
Dependent Claim 31 words
The method according to claim 8 including the step of maintaining the identifier in the home database directing the calls to the visitor database for querys on a per customer basis.
Claim 10
Dependent Claim 43 words
The method according to claim 1 including maintaining multiple versions of records in the home and visitor 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 32 words
The method according to claim 1 including deleting the previous database record version at all database sites after completing the processing of all calls querying the previous version of the database record.
Claim 12
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 13
Dependent Claim 35 words
The method according to claim 12 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 14
Dependent Claim 19 words
The method according to claim 13 including deleting the previous obsolete database record when the call counter is zero.
Claim 15
Dependent Claim 23 words
The method according to claim 1 including the step of verifying the updated database record in the visitor site database for data inconsistency.
Claim 16
Dependent Claim 24 words
The method according to claim 1 wherein the call transport system of the foreign region includes a wireless phone network and wired phoned network.
Claim 17
Independent Claim 179 words
A system for updating replicated database in foreign and home telecommunication network systems to improve call setup time and system availability in a foreign region for roaming customers comprising a foreign telecommunication system situated in a foreign region and having a call transport system and switches for forwarding calls from a telecommunication station through the call transport system to a destination, a signaling system operatively connected to the foreign call transport system, and including a visitor database within the signaling system containing customer records for call routing and other signaling functions, a home telecommunication system having a home signaling system and home database, said visitor database being connected to said home signaling system, means for updating a customer record in the visitor database, means for transmitting information concerning the updated database record through the home signaling network to the home database containing the previous version of the database record, and means responsive to the completion of all calls querying the previous version of both the visitor and home database record for deleting the previous version of the database record.
Claim 18
Dependent Claim 30 words
The system according to claim 17 including means for launching queries to the home database when calls are originated from the home country to network customers in the foreign region.
Claim 19
Dependent Claim 27 words
The system according to claim 17 including means for launching queries to the visitor database when calls are originated form the foreign region to a network customer.
Claim 20
Dependent Claim 42 words
The system according to claim 17 including means for maintaining current location information in the visitor database for highly mobile customers traveling in a foreign region, and an identifier contained within the home database directing calls to the visitor database for queries.
Claim 21
Dependent Claim 37 words
The system according to claim 17 including storage means for recording updated record activity at the visitor and home databases after the updated database record has been processed and committed at the visitor and home databases respectively.
Claim 22
Dependent Claim 33 words
The system according to claim 17 including means for sending an acknowledgement from the home database back to the visitor database after an updated database record has been processed within the home database.
Claim 23
Dependent Claim 46 words
The system according to claim 17 including means for maintaining multiple versions of customer records in the visitor and home 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 24
Dependent Claim 35 words
The system according to claim 17 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 25
Dependent Claim 26 words
The system according to claim 24 including means for updating the records in the home database by the version number sequence of the updated database records.
Claim 26
Dependent Claim 32 words
The system according to claim 17 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 27
Dependent Claim 39 words
The system according to claim 26 including means for incrementing the call counter field by one if a new call references to it, and means for decrementing the call counter field by one when a call setup is completed.
Claim 28
Dependent Claim 20 words
The system according to claim 27 including means for deleting the previous database record when the call counter is zero.
Claim 29
Dependent Claim 25 words
The system according to claim 17 wherein said call transport system of the foreign region 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.

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag