Computer network system using encapsulation to decompose work units for synchronizing and operating a second database from a first database

• US 7,526,576 B2
• Filed: 03/29/2006
• Issued: 04/28/2009
• 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): LUU, LE HIEN
• Application Number:
  US11/391,224
• Publication Number:
  US 20060222162A1
• Time in Patent Office: 1,126 Days
• Field of Search: 709/248, 709/215, 707/204, 707/100, 703/28, 379/221.08, 705/7, 345/765
• US Class Current: 709/248
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

Computer network system for building and/or synchronising a second database from/with a first database, accesses by work units being carried out at least on the first database from at least one application workstation, to generate, change or delete contents of the database, with at least one first server to guide and maintain the first database, said server being connected to at least one application workstation, at least one second server to guide and maintain the second database, at least one data connection which connects the two servers, the accesses by the work units to the first database taking place by means of an encapsulation module, which is set up and programmed so that the work units are passed to it, work units which it accepts are decomposed into one or more messages, the messages are entered in the first database and the messages are sent to the second database.

Claims

1. Computer network system for building and/or synchronizing a second database (DB2) from/with a first database (DB1), accesses by work units (UOW) being carried out at least on the first database (DB1) from at least one application workstation, to generate, change or delete contents of the first database (DB1), with at least one first server (S1) to guide and maintain the first database (DB1), said server being connected to at least one application workstation, at least one second server (S2) to guide and maintain the second database (DB2), at least one data connection which connects the two servers (S1, S2 ), wherein the accesses by the work units (UOW) to the first database (DB1) take place by means of an encapsulation module (KM), which is set up and programmed so that the work units (UOW) are passed to it, work units (UOW) which it accepts are decomposed into one or more messages (M1 . . . Mn), the messages (M1 . . . Mn) are entered in the first database (DB1), and the messages (M1 . . . Mn) are sent to the second database (DB2).

2. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to carry out those accesses by application software programs and other programs which change the first database for them, these programs directing their change commands which are intended for the first database (DB1) to the encapsulation module program (KM), which carries out the actual accesses to the first database (DB1).

3. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to test whether it is more efficient, particularly regarding transmission duration and transmission quantity and/or processing cost in the context of the second database (DB2), either to send the changed entries resulting from the application of the work unit (UOW) to the first database (DB1) by means of individual functions (F1 . . . Fn) from the first database (DB1) to the second database (DB2), or to send the changed entries resulting from the application of the work unit(UOW) to the first database (DB1) by means of individual messages (M1 . . . Mn) from the first database (DB1) to the second database (DB2).

4. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to provide the messages (M1 . . . Mn) with a first identifier (B1) which identifies each message, before it is sent by the encapsulation module program (KM) to the second database (DB2).

5. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to fetch the first identifier (B1) from a central unit, which forms the first identifier as a time stamp or serial number.

6. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to store the number of messages (M1 . . . Mn) into which a work unit (UOW) is decomposed, and a first identifier (B1), in a termination message (ER), which the encapsulation module program (KM) then sends to the second database (DB2).

7. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to put the messages (M1 . . . Mn) to be sent and the termination message (ER) in an output wait queue (Qout), from which they are sent to an input wait queue (Qin) of a controller (HS) of the second database (DB2).

8. Computer network system according to claim 1, wherein the controller (HS) of the second database (DB2) is set up and programmed to read the messages (M1 . . . Mn) which are sent to it from the input wait queue (Qin), to test whether all the messages (M1 . . . Mn) belonging to one work unit (UOW) have arrived in the input wait queue (Qin), to carry out the appropriate changes in the second database (DB2) when all the messages (M1 . . . Mn) belonging to one work unit (UOW) have arrived in the input wait queue (Qin), and if required to distribute the corresponding changes or the messages (M1 . . . Mn) which contain them and belong to one work unit (UOW), depending on specified conditions, at least partly to other databases or application programs.

9. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed, depending on reaching a predefined parameter, to decompose work units (UOW) coming from a batch processing run into corresponding messages (M1 . . . Mn) and to write them to a transfer database (Q1), and a monitor software module, which is set up and programmed, after the predefined parameter is reached, to transmit the content of the transfer database (Q1) to the second database (DB2), is provided.

10. Computer network system according to claim 1, wherein the reference data controls the encapsulation module (KM) so that the first database (DB1) is changed, and/or one or more messages (M1 . . . Mn) are sent to the second database (DB2).

11. Computer network system according to claim 1, wherein the encapsulation module program (KM) is set up and programmed to record a proof of change for changes which have been carried out in the first database (DB1) and/or the second database (DB2).

12. Computer network system according to claim 1, wherein for functional. encapsulation, work units (UOW) are decomposed into a message (M1) in such a way that only a single message is sent if because of functional dependencies the change of a particular database attribute can trigger an unspecified number of changes of other database attributes and/or redundant data stocks have to be tracked.

13. Computer network system according to claim 1, wherein changes which are carried out in real time on the side of the first database use the encapsulation module of the first database (DB1) to synchronize changed entries of the first database (DB1) into the second database (DB2), the records being sent, on the side of the second database (DB2), to the main coexistence controller, which tracks the coexistence element programs and the corresponding application program elements in the context of the second database platform.

14. Computer-supported method for building and/or synchronizing a second database (DB2) from/with a first database (DB1), accesses by work units (UOW) being carried out at least on the first database (DB1) from at least one application workstation, to generate, change or delete contents of the first database (DB1), with guiding and maintaining the first database (DB1) with at least one first server (S1), which is connected to at least one application workstation, guiding and maintaining the second database (DB2) with at least one second server (S2), providing at least one data connection which connects the two servers (S1, S2), carrying out accesses by the work units (UOW) to the first database (DB1) by means of an encapsulation module (KM), to which the work units (UOW) are passed, which decomposes work units (UOW) which it accepts into one or more messages (M1 . . . Mn), which enters the messages (M1 . . . Mn) in the first database (DB1), and which sends the messages (M1 . . . Mn) to the second database (DB2).

15. Computer-supported method according to claim 14, wherein the encapsulation module program (KM) is set up and programmed to carry out those accesses by application software programs and other programs which change the first database for them, these programs directing their change commands which are intended for the first database (DB1) to the encapsulation module program (KM), which carries out the actual accesses to the first database (DB1).

16. Computer-supported method according to claim 14, wherein the encapsulation module program (KM) is set up and programmed to test whether it is more efficient, particularly regarding transmission duration and transmission quantity and/or processing cost in the context of the second database (DB2), either to send the changed entries resulting from the application of the work unit (UOW) to the first database (DB1) by means of individual functions (F1 . . . Fn) from the first database (DB1) to the second database (DB2), or to send the changed entries resulting from the application of the work unit UOW) to the first database (DB1) by means of individual messages (M1 . . . Mn) from the first database (DB1) to the second database (DB2).

17. Computer-supported method according to claim 14, wherein the encapsulation module program (KM) is set up and programmed to provide the messages (M1 . . . Mn) with a first identifier (B1) which identifies each message, before it is sent by the encapsulation module program (KM) to the second database (DB2).

18. Computer-supported method according to claim 14, wherein the encapsulation module program (KM) is set up and programmed to store the number of messages (M1 . . . Mn) into which a work unit (UOW) is decomposed, and a first identifier (B1), in a termination message (ER), which the encapsulation module program (KM) then sends to the second database (DB2).

19. Computer-supported method according to claim 14, wherein for functional en-capsulation, work units (UOW) are decomposed into a message (M1) in such a way that only a single message is sent if because of functional dependencies the change of a particular database attribute can trigger an unspecified number of changes of other database attributes and/or redundant data stocks have to be tracked.

20. Computer-supported method according to claim 14, wherein a software program component is provided by which, in the case of a transaction which is initiated from one application workstation on the first database (DB1), a sister transaction can be called up on the second database (DB2) and vice versa—

in which case, from the point of view of the application workstation, the sister transaction on the side of the second database (DB2) behaves analogously to its counterpart on the side of the first database (DB1).