Transmitting critical table information in databases
First Claim
1. A method for transmitting information relating to 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 method comprising:
- receiving 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;
preparing one or more data packets containing the information regarding the event;
sending the one or more data packets to a multicast group over a network;
forwarding the one or more data packets to a destination device subscribed to the multicast group without storing the one or more data packets by the multicast group; and
receiving the one or more data packets at the destination host device.
3 Assignments
0 Petitions
Accused Products
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 datagram packets.
-
Citations
19 Claims
-
1. A method for transmitting information relating to 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 method comprising:
-
receiving 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; preparing one or more data packets containing the information regarding the event; sending the one or more data packets to a multicast group over a network; forwarding the one or more data packets to a destination device subscribed to the multicast group without storing the one or more data packets by the multicast group; and receiving the one or more data packets at the destination host device. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. 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 in the critical table of the database; transmitting the data packet to a multicast group over a network; forwarding the data packet to a destination device subscribed to the multicast group without storing the data packet by the multicast group; receiving information regarding the event from a trigger generated on occurrence of the event in the critical table of the database, wherein the receiving the information 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. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. 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 source computing device 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, prepare one or more data packets containing the information regarding the event, and send the one or more data packets to a multicast group over a network; one or more multicast routers configured to forward the one or more data packets to a destination host device subscribed to the multicast group without storing the one or more data packets by the multicast group; and a destination host computing device configured to receive the one or more data packets at the destination host device. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A computer program product 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 computer program product comprising:
a computer readable storage memory having computer readable program code embodied therewith, the computer readable program code 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; prepare one or more data packets containing the information regarding the event; send the one or more data packets to a multicast group over a network; forward the one or more data packets to a destination host device subscribed to the multicast group without storing the one or more data packets by the multicast group; and receive the one or more data packets at the destination host device.
Specification