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

• US 7,890,460 B2
• Filed: 06/29/2007
• Issued: 02/15/2011
• Est. Priority Date: 07/01/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wilmot, Gerald J.
• Primary Examiner(s): Rones; Charles
• Assistant Examiner(s): Chojnacki; Mellissa M
• Application Number:
  US11/771,503
• Publication Number:
  US 20080016125A1
• Time in Patent Office: 1,327 Days
• Field of Search: 707/612
• US Class Current: 707/612
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

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.

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.

2. The method of claim 1, wherein the remote database client and the database system communicate via an email server.

3. The method of claim 2, wherein each of the update request and the reply is comprised in an email.

4. The method of claim 3, wherein the remote database client is a cellular phone.

5. The method of claim 3, wherein the remote database client is a personal digital assistant (PDA).

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.

7. The computer readable medium of claim 6, wherein the remote database client and the database system communicate via an email server.

8. The computer readable medium of claim 7, wherein each of the update request and the reply is comprised in an email.

9. The computer readable medium of claim 8, wherein the remote database client is a cellular phone.

10. The computer readable medium of claim 8, wherein the remote database client is a personal digital assistant (PDA).

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.

12. The system of claim 11, wherein the remote database client and the database system communicate via an email server.

13. The system of claim 12, wherein each of the update request and the reply is comprised in an email.

14. The system of claim 13, wherein the remote database client is a cellular phone.

15. The system of claim 13, wherein the remote database client is a personal digital assistant (PDA).