Computer network system for building, synchronising and/or operating a second database from/with a first database, and procedures for it

• US 7,707,177 B2
• Filed: 03/28/2006
• Issued: 04/27/2010
• Est. Priority Date: 03/31/2005
• Status: Active Grant

• Current Assignee: UBS Business Solutions AG (UBS Ag)
• Original Assignee: UBS Ag
• Inventors: Loacker, Hansbeat, Bank, Marcel
• Primary Examiner(s): Breene, John E
• Assistant Examiner(s): Bullock, Joshua
• Application Number:
  US11/390,099
• Publication Number:
  US 20060222161A1
• Time in Patent Office: 1,491 Days
• Field of Search: 707/200
• US Class Current: 707/617
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A computer network system for building and/or synchronising a second database based on a first database. Accesses by work units are carried out on the first database from an application workstation, to generate, change or delete contents of the database. A first server and second server interconnected via a data connection guide and maintain the first database and a second database, respectively. The accesses take place using an encapsulation module that receives and decomposes the work units into one or more messages, enters the messages in the first database and sends the messages to the second database. A coexistence controller places change messages sent by the first database in a coexistence database, determines whether all messages of a transaction have been transmitted, determines application program elements for which changes are relevant, if all of the messages of the transaction have been transmitted, and reads out the placed change messages in a correct order.

Claims

1. A computer network system configured to perform one or more of building a second database from a first database and synchronizing a second database with a first database, the computer network system comprising:

a first server configured to administer and maintain the first database, wherein the first database is operable to be accessed by one or more transaction-related work units;

a second server configured to administer and maintain the second database, the first and second servers being mutually connected through at least one data connection; and

a coexistence controller that is configured to;

place change messages sent by the first database in a coexistence database;

determine whether all messages belonging to a transaction have been transmitted;

determine application program elements for which changes are relevant, if all of the messages belonging to the transaction have been transmitted;

read out the change messages stored in the coexistence database in a correct order; and

forward the read-out change messages to at least one of the second database and other application programs,

wherein each change message contains one or more of;

content of the first database that is to be changed or generated; and

changed or generated content of the first database, wherein each change message is stored in the at least one of the first and second database.

2. The computer network system according to claim 1, further comprising:

an encapsulation module that is configured to perform functions including;

receiving work units that specify changes to the first database,

decomposing the work units into a plurality of messages, and

transferring the plurality of messages to a transfer database; and

a monitor software module that is configured to transmit content of the transfer database to the second database.

3. The computer network system according to claim 2, wherein the encapsulation module is configured to perform the functions when a predetermined parameter is reached, and wherein the monitor software module is configured to transmit the content of the transfer database when the predetermined parameter is reached, wherein the predefined parameter is one of a predefined time and a predefined quantity of data.

4. The computer network system according to claim 2, wherein the content of the transfer database is transmitted as a closed batch transport file to the second database.

5. The computer network system according to claim 2, wherein the coexistence controller functions as a controller of the second database, and wherein the content of the transfer database is transmitted to the controller of the second database.

6. The computer network system according to claim 1, wherein, for every database or application program that receives data from the first database, the coexistence controller feeds data to a coexistence element program module that is configured to synchronize the data for the relevant database or application program in order to carry out changes corresponding to change messages belonging to a relevant work unit.

7. The computer network system according to claim 1, wherein the coexistence controller is configured to take from tables information that specifies contents to be supplied for each of a plurality of coexistence element programs.

8. The computer network system according to claim 1, further comprising a two-dimensional table, wherein the coexistence controller is configured to read the two dimensional table, and wherein the table comprises a row for each coexistence element program module, and a column for each change message.

9. The computer network system according to claim 8, further comprising a three-dimensional table readable by the coexistence controller, wherein the three-dimensional table includes a two-dimensional sub-table for each database or application program for which there is a coexistence element program module, wherein the two-dimensional sub-table includes a column that identifies the database or application program by name, and wherein the two-dimensional sub-table comprises a row for each attribute that is transmitted in the change message, wherein a first value entered in the row indicates that the database or application program is not affected by this attribute of the message, and a second value indicates that the database or application program is affected by this attribute of the message.

10. The computer network system according to claim 1, wherein the coexistence controller is configured to transmit messages belonging to a work unit to appropriate coexistence element program modules, wherein the messages are processed further, the appropriate coexistence element program modules being configured to perform one or more of:

setting an OK flag in a table after successful further processing by an appropriate coexistence element program; and

entering a NOK flag together with a name of the appropriate coexistence element program in an error processing table, so that the messages are available for at least one of display, reprocessing, and error correction.

11. The computer network system according to claim 1, wherein the coexistence controller is configured to reprocess or error correct a message that has not been successfully further processed by coexistence element programs by one of:

sending the message to an appropriate coexistence element program for renewed further processing;

redelivering the message from the first database to the appropriate coexistence element program for renewed further processing; and

deleting the message from the second database.

12. The computer network system according to claim 1, wherein the accesses by the work units to the first database take place by means of an encapsulation module that is configured to:

receive the work units;

decompose each work unit into one or more messages;

enter each message of the one or more messages in the first database; and

send each message to the second database.

13. The computer network system according to claim 2, wherein the encapsulation module program is configured to carry out accesses by application software programs and other programs that change the first database, wherein the computer network system is configured to direct change commands of the application software or other programs to the encapsulation module program, whereby the encapsulation module carries out the accesses to the first database.

14. The computer network system according to claim 2, wherein the encapsulation module program is configured to test whether it is more efficient either to send, from the first database to the second database by means of individual functions, changed entries resulting from the application of the work unit to the first database, or to send, from the first database to the second database by means of individual messages, changed entries resulting from application of the work unit to the first database.

15. The computer network system of claim 14, wherein the encapsulation module is configured to determine whether it is more efficient based upon one or more of a transmission duration, a transmission quantity, and processing cost in the context of the second database.

16. The computer network system according to claim 2, wherein the encapsulation module is configured to provide the messages with a first identifier that identifies each message before the each message is sent by the encapsulation module program to the second database, wherein the encapsulation module program is configured to fetch the first identifier from a central unit that forms the first identifier as at least one of a time stamp and serial number.

17. The computer network system according to claim 1, wherein each change message contains one or more of:

a code for an action to be carried out;

content of the first database that is to be changed or generated; and

changed or generated content of the first database.

18. The computer network system according to claim 2, wherein the encapsulation module program is configured to store a number corresponding to an amount of messages into which a work unit is decomposed, to store a first identifier in a termination message, and to send said number and first identifier to the second database.

19. The computer network system according to claim 18, wherein the encapsulation module program is configured to put change messages to be sent and the termination message into an output wait queue, from which the computer network system is configured to send the change and termination messages to an input wait queue of the coexistence controller.

20. The computer network system according to claim 2, wherein the encapsulation module program is configured to control its functions using reference data.

21. The computer network system according to claim 20, wherein the reference data controls the encapsulation module so as to perform one or more of:

changing the first database and sending one or more messages to the second database.

22. The computer network system according to claim 1, further comprising a software program component that is configured such that, in the case of a transaction initiated from an application workstation on the first database, a sister transaction is capable of being called up on the second database and vice versa, wherein, from the point of view of the application workstation, the sister transaction on the second database behaves analogously to its counterpart on the first database.

23. The computer network system according to claim 2, wherein in the case of database-entry-oriented synchronization by a transaction of the first database, changed entries are transmitted by the encapsulation module to the coexistence controller, wherein the coexistence controller calls up coexistence utility programs of the coexistence element of the second database environment, wherein one or more of the entries and changes of the first database are brought into a second database environment, and wherein after a change of the second database entries, the coexistence controller calls up the one or more of the coexistence elements and the coexistence utility programs of the application software programs, which contain the adaptation rules that specify adaptation from one or more of the first to the second database and to the application software programs in the second database environment.

24. A computer-supported method for building or synchronizing, in a computer network system, a second database based on a first database, comprising:

administering and maintaining the first database using a first server;

administering and maintaining the second database using a second server;

providing an access to the first database for one or more transaction-related work units received from a workstation, wherein the first database is operable to change according to change messages of the one or more transaction-related work units;

placing the change messages sent by the first database in a coexistence database;

determining whether all messages belonging to a transaction have been transmitted;

determining application program elements for which changes are relevant, if all of the messages belonging to the transaction have been transmitted;

reading out the change messages stored in the coexistence database in a correct order; and

forwarding the read-out change messages to at least one of the second database and other application programs,

wherein each change message contains one or more of;

content of the first database that is to be changed or generated; and

changed or generated content of the first database, wherein each change message is stored in the at least one of the first and second database.

25. The computer-supported method according to claim 24, further comprising, when a predetermined parameter is reached:

decomposing, using an encapsulation module program of the computer network system, each work unit coming from a batch processing into corresponding messages, and writing the messages to a transfer database;

transmitting, using a monitor software module, the content of the transfer database to the second database.

26. The computer-supported method according to claim 24, further comprising:

feeding, using a coexistence controller, data to a coexistence element program module for every database or application program that receives data from the first database, and

synchronizing, using the coexistence element program, module data for the relevant database or application program specifically and carrying out changes corresponding to messages belonging to a work unit in an input wait queue in the second database or application program, or in the database that is associated with the relevant application program.

27. The computer-supported method according to claim 24, further comprising creating a two-dimensional table readable by a coexistence controller, wherein the table comprises a row for each coexistence element program module, and a column for each change message.

28. The computer-supported method according to claim 27, further comprising creating a three-dimensional table readable by the coexistence controller, wherein the three-dimensional table includes a two-dimensional sub-table for each database or application program for which there is a coexistence element program module, wherein the two-dimensional sub-table includes a column that identifies the database or application program by name, and wherein the two-dimensional sub-table comprises a row for each attribute which is transmitted in the change message, wherein a first value entered in the row indicates that the database or application program is not affected by this attribute of the message, and a second value indicates that the database or application program is affected by this attribute of the message.

29. The computer-supported method according to claim 25, further comprising:

receiving, at the encapsulation module program, one of an application software program and other program directed to the first database; and

carrying out the access to the first database using the encapsulation software module.

30. The computer-supported method according to claim 25, further comprising testing, using the encapsulation module program, whether it is more efficient either to send, from the first database to the second database, changed entries resulting from the application of the work unit to the first database by means of individual functions, or to send, from the first database to the second database, changed entries resulting from application of the work unit to the first database by means of individual messages.

31. A computer-readable storage medium operable on a computer of a computer network system to perform the steps of:

administering and maintaining a first database using a first server;

administering and maintaining a second database using a second server;

providing an access to the first database for one or more transaction-related work units received from a workstation, wherein the first database is operable to change according to change messages of the one or more transaction-related work units;

placing the change messages sent by the first database in a coexistence database;

determining whether all messages belonging to a transaction have been transmitted;

determining application program elements for which changes are relevant, if all of the messages belonging to the transaction have been transmitted;

reading out the change messages stored in the coexistence database in a correct order; and

forwarding the read out change messages to at least one of the second database and other application programs,

wherein each change message contains one or more of;

content of the first database that is to be changed or generated; and

changed or generated content of the first database, wherein each change message is stored in the at least one of the first and second database.