Sharing data on mobile devices
First Claim
1. A method for retrieving data from a central database for a mobile device, comprising:
- receiving, at the central database, an update request message for the data from a user at the mobile device, wherein the update request message comprises a node identification and an application identification, wherein the node identification identifies the mobile device and the application identification identifies a database application hosted by the central database;
accessing an application schema in the central database using the application identification, wherein the application schema defines tables of the database application and relationships between the tables of the database application;
determining a first partition of the application schema based on the user, wherein the first partition includes a set of rows in the application schema that belong to the user;
identifying a set of data changes in a history of operations based on the first partition and a point in time, wherein the history of operations is stored in the central database, and the identified set of data changes describe one or more data changes made to the application schema for the user after the point in time;
determining a second partition of the history of operations based on a data change in the identified set of data changes for the first partition, wherein the second partition identifies a set of nodes affected by the data change;
in response to determining the mobile device is in the set of nodes of the second partition, determining a set of rows in the application schema corresponding to the data change;
identifying a set of operations associated with the determined set of rows in the application schema corresponding to the data change;
determining the set of operations is small enough to be included in an update response message; and
transmitting the update response message to the mobile device to synchronize the data at the central database with the mobile device, wherein the update response message includes the determined set of operations.
1 Assignment
0 Petitions
Accused Products
Abstract
System, methods and articles of manufacture for replicating relational data on multiple nodes. An embodiment comprises receiving an update request message from a node, wherein the update request message comprises a node identification and an application identification, accessing an application schema based on the application identification, identifying a partition residing in the application schema based on the node identification, accessing a server schema, identifying a second partition residing in the server schema based on the application identification, determining at least one data change stored in the second partition that changes data associated with the first partition, retrieving at least one data change from the second partition, formatting data change in an update response message, and transmitting the update response message to the node.
-
Citations
31 Claims
-
1. A method for retrieving data from a central database for a mobile device, comprising:
-
receiving, at the central database, an update request message for the data from a user at the mobile device, wherein the update request message comprises a node identification and an application identification, wherein the node identification identifies the mobile device and the application identification identifies a database application hosted by the central database; accessing an application schema in the central database using the application identification, wherein the application schema defines tables of the database application and relationships between the tables of the database application; determining a first partition of the application schema based on the user, wherein the first partition includes a set of rows in the application schema that belong to the user; identifying a set of data changes in a history of operations based on the first partition and a point in time, wherein the history of operations is stored in the central database, and the identified set of data changes describe one or more data changes made to the application schema for the user after the point in time; determining a second partition of the history of operations based on a data change in the identified set of data changes for the first partition, wherein the second partition identifies a set of nodes affected by the data change; in response to determining the mobile device is in the set of nodes of the second partition, determining a set of rows in the application schema corresponding to the data change; identifying a set of operations associated with the determined set of rows in the application schema corresponding to the data change; determining the set of operations is small enough to be included in an update response message; and transmitting the update response message to the mobile device to synchronize the data at the central database with the mobile device, wherein the update response message includes the determined set of operations. - View Dependent Claims (2, 3, 4, 5, 6, 18, 19, 20, 21, 22, 23, 24, 25, 28, 29, 30, 31)
-
-
7. A central server system for replicating data to a mobile device, comprising:
- a central database;
a receiver, configured to receive an update request message from a user at the mobile device, wherein the update request message comprises a node identification and an application identification, wherein the node identification identifies the mobile device and the application identification identifies a database application hosted by the central database; a memory, configured to store an application schema and a history of operations, wherein the application schema defines tables of the database application and relationships between the tables of the database application, and the history of operations describe data changes made to the application schema; a processor, configured to;
determine a first partition of the application schema based on the user, wherein the first partition includes a set of rows in the application schema that belong to the user;identifying a set of data changes in the history of operations based on the first partition and a point in time, wherein the identified set of data changes describe one or more data changes made to the application schema for the user after the point in time; determine a second partition of the history of operations based on a data change in the identified set of data changes for the first partition, wherein the second partition identifies a set of nodes affected by the data change; in response to determining the mobile device is in the set of nodes of the second partition, determining a set of rows in the application schema corresponding to the data change; identifying a set of operations associated with the determined set of rows in the application schema corresponding to the data change; determining the set of operations is small enough to be included in an update response message; and a transmitter, configured to transmit the update response message to the mobile device to synchronize the data at the central database with the mobile device, wherein the update response message includes the determined set of operations. - View Dependent Claims (8, 9, 10, 11, 26, 27)
- a central database;
-
12. An article of manufacture including a non-transitory computer-readable storage medium having instructions stored thereon that, when executed by a computing device, cause said computing device to perform operations comprising:
-
receiving an update request message for data from a user at a mobile device, wherein the update request message comprises a node identification and an application identification, wherein the node identification identifies the mobile device and the application identification identifies a database application hosted by a central database; accessing an application schema in the central database using the application identification, wherein the application schema defines tables of the database application and relationships between the tables of the database application; determining a first partition of the application schema based on the user, wherein the first partition includes a set of rows in the application schema that belong to the user; identifying a set of data changes in a history of operations based on the first partition and a point in time, wherein the history of operations is stored in the central database, and the identified set of data changes describe one or more data changes made to the application schema for the user after the point in time; determining a second partition of the history of operations based on a data change in the identified set of data changes for the first partition, wherein the second partition identifies a set of nodes affected by the data change; in response to determining the mobile device is in the set of nodes of the second partition, determining a set of rows in the application schema corresponding to the data change; identifying a set of operations associated with the determined set of rows in the application schema corresponding to the data change; determining the set of operations is small enough to be included in an update response message; and transmitting the update response message to the mobile device to synchronize the data at the central database with the mobile device, wherein the update response message includes the determined set of operations. - View Dependent Claims (13, 14, 15, 16, 17)
-
Specification