Transmitting Critical Table Information in Databases

• US 20100309911A1
• Filed: 06/04/2009
• Published: 12/09/2010
• Est. Priority Date: 06/04/2009
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: International Business Machines Corporation
• Inventors: Eshwar, Bhavani Kumar
• Granted Patent: US 8,054,764 B2
• Time in Patent Office: Days
• US Class Current: 370/390
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: H04L 12/1859 adapted to provide push services, e.g. data channels
• CPC Class Codes: H04L 12/1895 for short real-time information, e.g. alarms, notifications, alerts, updates

Abstract

A method for sending information regarding an event in a critical table in a database. A receiver receives information regarding an event from a trigger corresponding to the event. The event may be one of an insert row, delete row or update row. Thereafter, a processor prepares one or more datagram packets containing the information regarding the event. Then, an event dispatcher sends the one or more datagram packets to a multicast group over a network. Finally, the multicast group forwards the datagram packets to a destination host device subscribed to the multicast group, without storing the datagrain packets.

Claims

1. A method for transmitting information relating to occurrence of an event in a critical table of a database, the method comprising:

preparing a data packet containing information regarding the event;

transmitting the data packets to a multicast group over a network; and

forwarding the data packets to a destination device subscribed to the multicast group, and the data packets not stored by the multicast group.

2. The method of claim 1, further comprising

receiving information regarding the event from a trigger generated on occurrence of the event in the critical table of the database.

3. The method of claim 2, wherein the event comprises at least one of an insert row event, a delete row event or an update row event.

4. The method of claim 2, wherein the critical tables are selected based on a business design of an application using the database.

5. The method of claim 1, wherein the information regarding the event includes a database table name, a primary key value, type of event and change in value of data in the database table.

6. The method of claim 2, wherein the receiving includes the trigger calling a user defined function (UDF) and passing the information regarding the event to the UDF, wherein the UDF invokes an event dispatcher to send the data packets.

7. The method of claim 6, wherein the UDF is a Java UDF.

8. The method of claim 7, wherein UDF is configured to invoke a helper class by passing the information regarding the event to the helper class, to send/transmit the data packets.

9. The method of claim 1, wherein preparing the datagram packets further comprises:

obtaining an event XML message template string corresponding to the event; and

creating the data packets using the event XML, message template string.

10. The method of claim 9, wherein the event XML message template string is generated by replacing placeholders in a template with the information regarding the event.

11. The method of claim 1, wherein transmitting the datagram packets further comprises:

creating a socket for sending the datagram packets over the network.

12. The method of claim 1, wherein the datagram packets are sent over low level network sockets.

13. The method of claim 1, wherein the forwarding the data packets includes pushing the data packets to the destination device subscribed to the multicast group after receiving the data packets at the multicast group.

14. The method of claim 1, wherein the multicast group is a broadcast group.

15. A system for transmitting information regarding occurrence of an event in a critical table of a database, wherein the event is at least one of an insert row event, a delete row event or update row event, the system comprising:

a receiver configured to receive information regarding the event from a trigger corresponding to the event in the database, wherein the information includes one or more of a database table name, a primary key value, type of event and change in value of data in the database table;

a processor configured to prepare one or more data packets containing the information regarding the event;

an event dispatcher configured to send the data packets to a multicast group over a network;

a multicast group module configured to forward the data packets to a destination host device subscribed to the multicast group, wherein the data packets are not stored by the multicast group; and

an event receiver configured to receive the data packets at the destination host device.

16. The system of claim 15, wherein critical tables in the database are selected based on business design of an application using the database.

17. The system of claim 15, wherein the event dispatcher is created using multicast libraries in Java.

18. The system of claim 15, wherein the event receiver is created using multicast libraries in Java.

19. The system of claim 15, wherein the event dispatcher sends the data packets over low level network sockets.

20. A storage medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus for transmitting information regarding occurrence of an event in a critical table of a database, wherein the event is at least one of an insert row event, a delete row event or update row event, comprising:

a receiver configured to receive information regarding the event from a trigger corresponding to the event in the database, wherein the information includes one or more of a database table name, a primary key value, type of event and change in value of data in the database table;

a processor configured to prepare one or more data packets containing the information regarding the event;

an event dispatcher configured to send the data packets to a multicast group over a network;

a multicast group module configured to forward the data packets to a destination host device subscribed to the multicast group, wherein the data packets are not stored by the multicast group; and

an event receiver configured to receive the data packets at the destination host device.