Method and apparatus for performing real-time update transactions between a database system and remote database clients
First Claim
1. A method for performing an update transaction in a database system, the method comprising:
- sending to a plurality of remote database clients an update request to update data in a database system, the update request comprising a first checksum value and an Updateable Column Data Set (UCDS), the first checksum value corresponding to a state of the data to be updated in the database system as of the time of the update request, the UCDS corresponding to the data to be updated and any database cells associated with the data to be updated;
responsive to sending the update request to the plurality of remote database clients, receiving a reply from a remote database client, the reply including a new value for the data to be updated in the database system and the first checksum value corresponding to the state of the data to be updated in the database system as of the time of the update request;
determining whether the first checksum value matches a second checksum value corresponding to the state of the data to be updated in the database system as of the time that the database system received the reply; and
responsive to the first checksum value matching the second checksum value, updating the data to be updated in the database system with the new value for the data to be updated, otherwise rejecting the reply.
1 Assignment
0 Petitions
Accused Products
Abstract
A method for performing an update transaction in a database system that includes sending to a remote database client an update request to update data in a database system, in which the update request comprises a first checksum value corresponding to a state of the data in the database system as of the time of the update request. The method further includes receiving a reply from the remote database client that includes a new value for the data in the database system and the first checksum value. The method further includes determining whether the first checksum value matches a second checksum value corresponding to the state of the data in the database system as of the time that the database system received the reply, and if the first checksum value matches the second checksum value, the data in the database system is updated with the new value for the data.
18 Citations
15 Claims
-
1. A method for performing an update transaction in a database system, the method comprising:
-
sending to a plurality of remote database clients an update request to update data in a database system, the update request comprising a first checksum value and an Updateable Column Data Set (UCDS), the first checksum value corresponding to a state of the data to be updated in the database system as of the time of the update request, the UCDS corresponding to the data to be updated and any database cells associated with the data to be updated; responsive to sending the update request to the plurality of remote database clients, receiving a reply from a remote database client, the reply including a new value for the data to be updated in the database system and the first checksum value corresponding to the state of the data to be updated in the database system as of the time of the update request; determining whether the first checksum value matches a second checksum value corresponding to the state of the data to be updated in the database system as of the time that the database system received the reply; and responsive to the first checksum value matching the second checksum value, updating the data to be updated in the database system with the new value for the data to be updated, otherwise rejecting the reply. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A computer readable medium with program instructions for performing real-time update transactions between a database system and remote database clients, the program instructions comprising instructions for:
-
sending to a plurality of remote database clients an update request to update data in a database system, the update request comprising a first checksum value and an Updateable Column Data Set (UCDS), the first checksum value corresponding to a state of the data to be updated in the database system as of the time of the update request, the UCDS corresponding to the data to be updated and any database cells associated with the data to be updated; responsive to sending the update request to the plurality of remote database clients, receiving a reply from a remote database client, the reply including a new value for the data to be updated in the database system and the first checksum value corresponding to the state of the data to be updated in the database system as of the time of the update request; determining whether the first checksum value matches a second checksum value corresponding to the state of the data to be updated in the database system as of the time that the database system received the reply; and responsive to the first checksum value matching the second checksum value, updating the data to be updated in the database system with the new value for the data to be updated, otherwise rejecting the reply. - View Dependent Claims (7, 8, 9, 10)
-
-
11. A system comprising:
-
a database system configured to send to a plurality of remote database clients an update request to update data in the database system, the update request comprising a first checksum value and an Updateable Column Data Set (UCDS), the first checksum value corresponding to a state of the data to be updated in the database system as of the time of the update request, the UCDS corresponding to the data to be updated and any database cells associated with the data to be updated; responsive to a remote database client receiving one of the plurality of the update requests, the remote database client being configured send to the database system a reply to the one update request, the reply including a new value for the data to be updated in the database system and the first checksum value corresponding to the state of the data to be updated in the database system as of the time of the update request; wherein the database system is further configured to determine whether the first checksum value matches a second checksum value corresponding to the state of the data to be updated in the database system as of the time that the database system received the reply, and wherein responsive to the first checksum value matching the second checksum value, the database system is configure to update the data to be updated in the database system with the new value for the data to be updated, otherwise the database system is configured to reject the reply. - View Dependent Claims (12, 13, 14, 15)
-
Specification