Fast database replication

• US 7,788,224 B2
• Filed: 09/14/2004
• Issued: 08/31/2010
• Est. Priority Date: 10/08/2003
• Status: Active Grant

• Current Assignee: Alcatel SA (Nokia Corporation)
• Original Assignee: Alcatel SA (Nokia Corporation)
• Inventors: Richter, Stefan, Streichhahn, Frank, Wittrich, Michael, Dehnel, Jan, Fleck, Andreas
• Primary Examiner(s): Lu; Kuen S
• Assistant Examiner(s): Yen; Syling
• Application Number:
  US10/939,882
• Publication Number:
  US 20050080825A1
• Time in Patent Office: 2,177 Days
• Field of Search: 707/201, 707/102, 707/204, 707/10, 707/3, 707/610, 707/640, 707/674, 707/690, 707/822, 707/828, 707/661, 707/623, 700/3, 709/226, 709/219, 709/230, 709/218, 709/203, 379/220.01
• US Class Current: 707/623
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

The invention relates to a method for updating a remote data base with sets of data of a master data base system. The sets of data are forwarded to an intermediate data base, and the intermediate data base and the remote data base system are coupled by means of a synchronisation protocol. The protocol ensures, that the remote data base is reliably updated, wherein said master data base and said intermediate data base are logically independent data bases each part of a unique data base system controlled by a unique data base management, and also to master data base system therefore.

Claims

1. A method for updating a remote data base with sets of data of a master data base, the method comprising:

forwarding said sets of data from the master data base to an intermediate data base; and

forwarding said sets of data from the intermediate data base to the remote data base,

wherein the intermediate data base and the remote data base are coupled by a synchronization protocol,

wherein said synchronization protocol ensures that the remote data base is reliably updated,

wherein said master data base and said intermediate data base are logically independent data bases, each part of a data base system controlled by a data base management,

wherein the master data base stores additional sets of data not stored in the intermediate data base,

wherein the master data base stores said sets of data according to a first data model, and the intermediate data base stores said sets of data according to a second data model,

wherein an object update of the master data base and the intermediate data base is executed within a single transaction in which a single commit is executed over the master data base and the intermediate data base,

wherein the master data base and the intermediate data base each comprise logically independent sections, and

wherein the logically independent sections comprise at least one of a first section storing a fixed number telephone portability information, a second section storing a local number portability type information, and a third section storing a geographical number portability type information, and a fourth section storing a mobile number portability type information.

2. A method according to claim 1, wherein the data sets of the data base system are identified to be part of the master data base or the intermediate data base by a data base identifier.

3. The method according to claim 1, wherein the data base system administers a first replication queue with entries of identifiers of changed objects, wherein a remote data base system, comprising the remote data base, reads the entries of the first replication queue, takes the read entries into a second replication queue in the remote data base system and copies the changed objects into the remote data base.

4. The method according to claim 3, wherein a cache updater, running on the remote data base system reads the second replication queue in the remote data base system and copies the changes into a client cache of a corresponding application process.

5. The method according to claim 4, wherein said sets of data are forwarded from the intermediate data base to a plurality of remote data base systems, each comprising a corresponding remote data base, and wherein an entry in the first replication queue in the data base system is cleared, if all of the plurality of remote data base systems have taken over the entry.

6. The method according to claim 1, wherein the unique data base management comprises a data backup, data restoration and roll forward archives of both the master data base and the intermediate data base at the same time.

7. A method according to claim 1, wherein an object update of both the master data base and the intermediate data base are executed within a single transaction.

8. The method according to claim 1, wherein a data base adapter converts data from the master data base to the intermediate data base, hiding details of the mapping between both the corresponding data models.

9. The method according to claim 1, wherein a data base scheduler executes received update requests by initiating a transfer of data from the master data base to the intermediate data base at predefined time points.

10. The method according to claim 1, wherein message objects are created, which contains information about changed attributes of data base objects, wherein these message objects are moved to a first replication queue, wherein a remote data base system comprising the remote data base reads the entries of the first replication queue, takes said entries into a second replication queue on the remote data base system and maps the attribute values to the corresponding mirror data base object.

11. The method according to claim 1, wherein the master data base and the intermediate data base are within a single physical data base.

12. The method according to claim 11, wherein the single physical data base is partitioned into the logically independent sections, and wherein for each of the master data base and the intermediate data base, the logically independent sections store telephone number portability information.

13. The method according to claim 12, wherein for each type of the telephone number portability information, a separate logically independent section from the plurality of logically independent sections is provided, wherein said each type of the telephone number portability information comprises the fixed number portability type information, the local number portability type information, the geographical number portability type information, and the mobile number portability type information, and wherein the single physical data base is a data base of a telecommunications service provider.

14. The method according to claim 1, wherein the data base management comprises an agent managing both the master data base and the intermediate data base and wherein, the agent executes the single commit request over both the master data base and the intermediate data base.

15. The method according to claim 1, wherein a single file system is provided for both the master data base and the intermediate data base.

16. The method according to claim 1, further comprising:

converting said sets of data from the first data model of the master data base, to the second data model of the intermediate data base, prior to forwarding said sets of data from the intermediate data base to the remote data base.

17. The method according to claim 1, wherein the first data model is optimized for provisioning.

18. The method according to claim 1, wherein the second data model is optimized for high speed access.

19. The method according to claim 1, wherein the data base management reads and writes data from and to the master data base and comprises data manipulation logic that performs syntactical checks and maintenance of corresponding structures for object navigation.

20. The method according to claim 19, wherein the data manipulation logical performs semantic and consistency checks.

21. A master data base system comprising:

means for transferring, using a processor, sets of data to an intermediate data base; and

means for controlling a master data base of said master data base system and said intermediate data base,

wherein said intermediate data base and a remote data base system comprise protocol means for performing a synchronization protocol, said synchronization protocol ensuring that the remote data base is reliably updated,

wherein said master data base and said intermediate data base are logically independent data bases each part of a unique data base system,

wherein the master data base stores additional sets of data not stored in the intermediate data base,

wherein the master data base stores said sets of data according to a first data model, the intermediate data base stores said sets of data according to a second data model,

wherein an object update of the master data base and the intermediate data base is executed within a single transaction in which a single commit is executed over the master data base and the intermediate data base,

wherein the master data base and the intermediate data base each comprise logically independent sections, and

wherein the logically independent sections comprise at least one of a first section storing a fixed number telephone portability information, a second section storing a local number portability type information, and a third section storing a geographical number portability type information, and a fourth section storing a mobile number portability type information.

22. The method according to claim 21, wherein the control means reads and writes data from and to the master data base and comprises data manipulation logic that performs syntactical checks and maintenance of corresponding structures for object navigation.

23. The method according to claim 22, wherein the data manipulation logical performs semantic and consistency checks.