Method and apparatus for performing real-time update transactions between a database system and remote database clients

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.

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.