Method and system for updating replicated databases in foreign and home telecommunication network systems for supporting global mobility of network customers

• US 5,913,160 A
• Filed: 09/13/1994
• Issued: 06/15/1999
• Est. Priority Date: 09/13/1994
• Status: Expired due to Fees

• Current Assignee: AT&T Corporation (AT&T, Inc.)
• Original Assignee: AT&T Corporation (AT&T, Inc.)
• Inventors: Leung, Kin K.
• Primary Examiner(s): CUMMING, WILLIAM D
• Application Number:
  US08/305,004
• Time in Patent Office: 1,736 Days
• Field of Search: 370/110.1, 379/59, 379/60, 379/113, 379/211, 379/237, 379/201, 455/403
• US Class Current: 455/403
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: H04Q 2213/1305 Software aspects
• CPC Class Codes: H04Q 2213/13098 Mobile subscriber
• CPC Class Codes: H04Q 2213/13103 Memory
• CPC Class Codes: H04Q 2213/13109 Initializing, personal profile
• CPC Class Codes: H04Q 2213/13176 Common channel signaling, CCS7
• CPC Class Codes: H04Q 2213/13376 Information service, downloading of information, 0800/0900 services
• CPC Class Codes: H04Q 2213/13513 UPT - personal as opposed to terminal mobility, inc. number portability
• CPC Class Codes: H04Q 2213/13532 mobile networks
• CPC Class Codes: H04Q 2213/13547 subscriber, e.g. profile, database, database access
• CPC Class Codes: H04Q 3/0029 Provisions for intelligent networking
• CPC Class Codes: H04Q 3/54516 Initialization, software or data downloading G06F9/445 takes precedence
• CPC Class Codes: H04W 8/08 Mobility data transfer
• CPC Class Codes: H04W 8/30 Network data restoration; Network data reliability; Network data fault tolerance

Abstract

A method and system of the present invention updates a replicated database in a foreign telecommunication network system situated in a foreign region and a home country telecommunication network system situated in a home country. The method and system improves call setup time and system availability in a foreign region for customers roaming outside their home country. 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 call querying the database record.

Claims

1. A method for updating a replicated database in a foreign telecommunication network system situated in a foreign region and a home country telecommunication network system situated in a home country so as to improve call setup time and system availability in a foreign region for customers roaming outside of their home country comprising the steps of

updating a customer database record in a visitor database contained in a foreign region within a signaling system of a foreign telecommunication network situated in the foreign region, wherein the foreign telecommunication 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 a signaling system of a home telecommunication network to a home database located in the home country which contains a replicated version of the database record in the visitor database,

adding a field to the database record corresponding to a version number of the database record so as to identify the version of the database record referred by queries of calls in progress,

changing the home database record to reflect changes in the visitor database by using the version number sequence, while maintaining at all database sites an older version of the database record for query access until after completing the processing of all previous calls querying the older version of the database record, and

directing the query to the home database for accessing the customer database record if the customer is not roaming in a foreign region.

2. The method according to claim 1 including launching queries to the home database when calls are originated from the home country to a customer in the foreign region.

3. The method according to claim 1 including launching queries to the visitor database when calls are originated from the foreign region to a customer.

4. The method according to claim 1 including the step of removing the customer database record from the visitor database when the associated customer leaves the foreign region.

5. The method according to claim 1 including committing the updated database record of the visitor and home databases by recording a record of update 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.

6. The method according to claim 1 including sending an acknowledgement from the home database to the visitor database when an updated database record has been processed within the home database.

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

8. The method according to claim 1 including the step of maintaining the identifier in the home database directing the calls to the visitor database for queries on a per customer basis.

9. The method according to claim 1 including maintaining multiple versions of the database records in the home and visitor databases so that queries for a call can access the same version of the database record in the same database for consistent routing and signaling information.

10. The method according to claim 1 including deleting the older version of the database record at all database sites after completing the processing of all calls querying the older version of the database record.

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

12. The method according to claim 11 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.

13. The method according to claim 12 including deleting the older version of the database record when the value in the call counter field is zero.

14. The method according to claim 1 including the step of verifying the updated database record in the visitor database for data consistency.

15. The method according to claim 1 wherein the call transport system of the foreign region includes a wireless phone network and a wired phone network.

16. A system for updating a replicated database in a foreign telecommunication network system situated in a foreign region and a home country telecommunication network system situated in a home country so as to improve call setup time and system availability in a foreign region for customers roaming outside their home country 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 database records for call routing and other signaling functions,

a home telecommunication system having a home signaling system and a home database, said visitor database being connected to said home signaling system,

means for updating a customer database record in the visitor database,

means for transmitting information concerning the updated database record through the home signaling network to the home database containing an older version of the database record,

means responsive to the completion of all calls querying the older version of both the visitor and home database record for deleting the older version of the database record, and

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 database record.

17. The system according to claim 16 including means for launching queries to the home database when calls are originated from the home country to a customer in the foreign region.

18. The system according to claim 16 including means for launching queries to the visitor database when calls are originated from the foreign region to a customer.

19. The system according to claim 16 including means for maintaining current location information in the visitor database for highly mobile customers traveling in the foreign region, and an identifier contained within the home database directing calls to the visitor database for queries.

20. The system according to claim 16 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.

21. The system according to claim 16 including means for sending an acknowledgement from the home database to the visitor database after an updated database record has been processed within the home database.

22. The system according to claim 16 including means for maintaining multiple versions of database records in the visitor and home databases so that queries for a call can access the same version of the database record in the same database for consistent routing and signaling information.

23. The system according to claim 16 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.

24. The system according to claim 23 including means for updating the database records in the home database by the version number sequence of the updated database records.

25. The system according to claim 16 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.

26. The system according to claim 25 including means for deleting the older version of the database record when the value in the call counter field is zero.

27. The system according to claim 16 wherein said call transport system of the foreign region includes a wireless phone network and a wired phone network.