Real-time database update transaction with disconnected relational database clients
First Claim
1. A method for performing real-time update transactions between a database and disconnected database clients, comprising the steps of:
- (a) sending an update request for a data from a database system to a client, wherein the update request comprises a timestamp for the data, wherein the timestamp indicates a last time the data was changed, wherein the client is disconnected from the database system;
(b) receiving an update and the timestamp for the data from the disconnected database client;
(c) determining if the received timestamp matches a current timestamp for the data; and
(d) updating the data according to the received update, if the timestamp of the received update matches the current timestamp for the data, wherein the client is disconnected from the database during the updating.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for performing real-time database update transactions with disconnected database clients includes a disconnected client server (DCS) and disconnected client extensions (DCE). The DCS formats the database cell, its key, any associated database cells, and a timestamp and sends them to a disconnected database client by email. The timestamp indicates the last time the database cell or associated database cells was changed. The disconnected database client sends a reply email with the update of the database cell and the timestamp. Upon receipt of the reply email, the DCS compares the received timestamp to a current timestamp for the database cell. If they match, then the database cell is updated according to the received update. If they do not match, then the update is based on outdated information and is rejected. In this manner, reliable real-time update transactions are provided between a disconnected database client and the database.
10 Citations
34 Claims
-
1. A method for performing real-time update transactions between a database and disconnected database clients, comprising the steps of:
-
(a) sending an update request for a data from a database system to a client, wherein the update request comprises a timestamp for the data, wherein the timestamp indicates a last time the data was changed, wherein the client is disconnected from the database system;
(b) receiving an update and the timestamp for the data from the disconnected database client;
(c) determining if the received timestamp matches a current timestamp for the data; and
(d) updating the data according to the received update, if the timestamp of the received update matches the current timestamp for the data, wherein the client is disconnected from the database during the updating. - View Dependent Claims (2, 3, 4, 5, 6, 7, 10, 11, 12, 13)
-
-
8. (canceled)
-
9. (canceled)
-
14. A method for performing real-time update transactions between a database and disconnected database clients, comprising the steps of:
-
(a) creating a UCDS and a STCV by the database, wherein the UCDS comprises a database cell and associated database cells, wherein the STCV comprises a timestamp and a checksum for the UCDS, wherein the timestamp indicates a last time the database cell or the associated database cells was changed;
(b) receiving by a DCS a message to request an update of the database cell;
(c) sending the email request to the disconnected database client, wherein the email request comprises the database cell and the associated database cells, a key for the UCDS, and the STCV at a time the email request was created;
(d) receiving a reply email from the disconnected database client by the DCS, wherein the reply email comprises the update of the database cell and the STCV;
(e) determining if the STCV in the reply email matches a current STCV of the UCDS by the DCS;
(f) sending the update of the database cell to the database, if the STCV in the reply email matches a current STCV of the UCDS; and
(g) updating the database cell and the current STCV according to the update by the database, wherein the client is disconnected from the database during the updating.
-
-
15. A computer readable medium with program instructions for performing real-time update transactions between a database and disconnected database clients, comprising the instructions for:
-
(a) sending an update request for a data cell from a database system to a client, wherein the update request comprises a timestamp for the data, wherein the timestamp indicates a last time the data was changed at a time the update request was created, wherein the client is disconnected from the database system;
(b) receiving an update and the timestamp for the data from the disconnected database client;
(c) determining if the received timestamp matches a current timestamp for the data; and
(d) updating the data according to the received update, if the timestamp of the received update matches the current timestamp for the data, wherein the client is disconnected from the database during the updating. - View Dependent Claims (16, 17, 18, 19, 20, 21, 24, 25, 26, 27)
-
-
22. (canceled)
-
23. (canceled)
-
28. A computer readable medium with program instructions for performing real-time update transactions between a database and disconnected database clients, comprising the instructions for:
-
(a) creating a UCDS and a STCV by the database, wherein the UCDS comprises a database cell and associated database cells, wherein the STCV comprises a timestamp and a checksum for the UCDS, wherein the timestamp indicates a last time the database cell or the associated database cells was changed;
(b) receiving by a DCS a message to request an update of the database cell;
(c) sending the email request to the disconnected database client, wherein the email request comprises the database cell and the associated database cell, a key for the UCDS, and the STCV at a time the email request was created;
(d) receiving a reply email from the disconnected database client by the DCS, wherein the reply email comprises the update of the database cell and the STCV;
(e) determining if the STCV in the reply email matches a current STCV of the UCDS by the DCS;
(f) sending the update of the database cell to the database, if the STCV in the reply email matches a current STCV of the UCDS; and
(g) updating the database cell and the current STCV according to the update by the database, wherein the client is disconnected from the database during the updating.
-
-
29. A system, comprising:
-
a database, comprising disconnected client extensions (DCE), wherein the database utilizes the DCE;
to create an UCDS comprising a data, to create a timestamp for the UCDS, wherein the timestamp indicates a last time the data was changed, and to update the data and the timestamp when an update is received from the database server; and
the database server, comprising a disconnected client server (DCS), wherein the DCS sends an update request comprising the data and the timestamp to a client, wherein the client is disconnected from the database server, wherein the DCS receives the update and the timestamp from the update request from the disconnected database client, wherein the DCS sends the received update to the database if the received timestamp matches a current timestamp for the UCDS, wherein the data is updated by the database according to the update, wherein the client is disconnected from the database during the update. - View Dependent Claims (32)
-
-
30. (canceled)
-
31. (canceled)
-
33. (canceled)
-
34. A database server, comprising:
-
a connection to a database, the database comprising a UCDS, the UCDS comprising a data; and
a DCS, wherein the DCS creates an update request for the data, wherein the update request comprises the data, a key for the UCDS, and a timestamp, wherein the timestamp indicates a last time the data was changed, wherein the DCS receives an update for the data from a client, wherein the update comprises the timestamp from the update request, wherein the client is disconnected from the database server, wherein the DCS sends the received update to the database if the received timestamp matches a current timestamp for the data, wherein the data is updated according to the update, wherein the client is disconnected from the database server during the update.
-
Specification