Simultaneous transfer of database updates between multiple clients and a server

• US 20060047819A1
• Filed: 02/07/2005
• Published: 03/02/2006
• Est. Priority Date: 05/14/2004
• Status: Abandoned Application

• Current Assignee: CG4 Solutions, Inc.
• Original Assignee: CG4 Solutions, Inc.
• Inventors: Caddes, Scott Allen, Page, R. Kenin
• Application Number:
  US11/052,977
• Publication Number:
  US 20060047819A1
• Time in Patent Office: Days
• US Class Current: 709/227
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/04 specially adapted for terminals or networks with limited capabilities; specially adapted for terminal portability
• CPC Class Codes: H04L 67/60 Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources admission control or resource allocation H04L47/70
• CPC Class Codes: H04W 80/12 Application layer protocols, e.g. WAP [Wireless Application Protocol]

Abstract

The present invention relates to simultaneous transfer of database updates between multiple clients and a server. A plurality of (potentially limited resource) clients simultaneously establishes (e.g., TCP) connections to a server. Database updates are efficiently transferred between the server and each of the plurality of clients simultaneously. Server resources are utilized at the server to resolve any data conflicts such that the limited resources (e.g., system memory) of any clients are conserved. Clients that receive database updates overwrite existing client database with the received database updates. In preparation for receiving a database update, clients can empty a client database such that a received database update is more efficiently written into the client database.

Claims

1. At a server that is network connectable to a plurality of clients having limited system resources, a method for the server to simultaneously exchange data with at least two clients such that the clients can access and transfer data updates in a resource efficient manner, the method comprising:

an act of establishing a first connection to a first PDA;

an act of accessing a first data subset in a server database, the first data subset corresponding to the first PDA;

an act of initiating transfer of the first data subset to the first PDA over the first connection, the first data subset for updating a first client database at the first PDA;

an act of establishing a second connection to a second PDA, prior to the first connection being terminated;

an act of accessing a second data subset in the server database, the second data subset corresponding to the second PDA;

an act of initiating transfer of the second data subset to the second PDA over the second connection, the second data subset for updating a second client database at the second PDA; and

an act of transferring at least a portion of the first data subset and at least a portion of the second data subset essentially simultaneously.

2. The method as recited in claim 1, wherein the act of establishing a first connection to a first PDA comprises an act for establishing a first connection to a first PDA that is wirelessly connected to the network.

3. The method as recited in claim 1, wherein the act of establishing a first connection to a first client comprises an act for establishing a TCP connection to the first client.

4. The method as recited in claim 1, wherein the act of accessing a first data subset in a server database comprises an act of accessing a data subset that overlaps with one or more other data subsets.

5. The method as recited in claim 1, wherein the act of accessing a first data subset in a server database comprises an act of accessing a data subset including a data value that was updated by a different client.

6. The method as recited in claim 1, wherein act of initiating transfer of the first data subset to the first client over the first connection comprises an act of initiating transfer of database-update instructions to the first client.

7. The method as recited in claim 1, wherein act of initiating transfer of the first data subset to the first client over the first connection comprises an act of initiating transfer of the first data subset over a TCP connection.

8. The method as recited in claim 1, wherein act of initiating transfer of the first data subset to the first client over the first connection comprises an act of initiating transfer of processed data that has been formatted for use at the first client.

9. The method as recited in claim 1, wherein the act of establishing a second connection to a second client comprises an act for establishing a second connection to a PDA.

10. The method as recited in claim 1, wherein the act of establishing a first connection to a first client comprises an act for establishing a TCP connection to the second client.

11. The method as recited in claim 1, wherein the act of accessing a second data subset in a server database comprises an act of accessing a data subset that overlaps with one or more other data subsets.

12. The method as recited in claim 1, wherein the act of accessing a second data subset in a server database comprises an act of accessing a data subset including a data value that was updated by a different client.

13. The method as recited in claim 1, wherein act of initiating transfer of the second data subset to the second client over the second connection comprises an act of initiating transfer of database-update instructions to the second client.

14. The method as recited in claim 1, wherein act of initiating transfer of the second data subset to the second client over the second connection comprises an act of initiating transfer of the second data subset over a TCP connection.

15. The method as recited in claim 1, wherein act of initiating transfer of the second data subset to the second client over the second connection comprises an act of initiating transfer of processed data that has been formatted for use at the second client.

16. A method as recited in claim 1, further comprising:

an act of formatting the first data set for use at the first client such that the resources of the first client can be freed up for other processing.

17. The method as recited in claim 1, further comprising:

an act of formatting the second data set for use at the second client such that the resources of the second client can be freed up for other processing.

18. The method as recited in claim 1, wherein the act of transferring at least a portion of the first data subset and at least a portion of the second data subset essentially simultaneously comprises an act of transferring a portion of the first data subset over a first TCP connection and simultaneously transferring a portion of the second data subset over a second TCP connection such that the first and second clients are updated simultaneously.

19. At a client having limited system resources, the client being network connectable to a network along with one or more other clients and a server, a method for efficiently updating a client database at the client such that some of the client'"'"'s system memory is conserved, the method comprising:

an act of establishing a connection to the server;

an act of requesting a client database update from the server;

an act of receiving a current data subset for the client from the server, the current data subset being a subset of data contained in a server database at the server, the current data subset containing one or more current data values from the server database and being formatted for use at the client; and

an act of automatically replacing the client database with the current data subset, in response to receiving the current data subset.

20. The method as recited in claim 19, further comprising:

an act of detecting that a portion of the current data subset has been modified, subsequent to overwriting the prior data values; and

an act of transmitting the modified portion of the current data subset back to the server, in response to a specified event.

21. A method as defined in claims 20, further comprising an act of establishing a second connection to the server prior to transmitting the modified portion of the current data subset back to the server.

22. A method as defined in claims 20, wherein the modifications made to the current data subset on the client are transmitted back to the server as blocks of database update instructions.

23. A method as defined in claim 20, wherein the act of requesting a current data subset from the server comprises the act of requesting a specified subset of the database.

24. A method as defined in claim 19, wherein the act of automatically replacing the client database with the current data subset, in response to receiving the current data subset comprises an act of updating the client database to reflect the modifications made to the data included in the received current data subset, wherein the modified data overwrites the corresponding data in the client database without performing any checks related to the integrity of the data such that the database can be updated more efficiently.

25. At a client having limited system resources, the client being network connectable to a network along with one or more other clients and a server, a method for efficiently updating a client database at the client such that some of the client'"'"'s system memory is conserved, the method comprising:

an act of receiving a client database update;

an act of sending the client database update to the server;

an act of emptying the client database subsequent to sending the client database update in preparation for receiving updated client data;

an act of receiving an updated client data subset from the server;

an act of storing the updated client data subset in the client database.

26. The method as recited in claim 25, wherein the act of receiving a client database update comprises an act of receiving a client database update through an input device at a PDA.

27. The method as recited in claim 25, wherein the act of sending the client database update to the server comprises an act of establishing a TCP connection with the server.

28. The method as recited in claim 25, wherein the act of emptying the client database subsequent to sending the client database update in preparation for receiving updated client data comprises an act of removing a plurality of values from the client database.

29. The method as recited in claim 25, wherein the act of receiving an updated client data subset from the server comprises an act of receiving database-update instructions.

30. A computer program product for use at a server that is network connectable to a plurality of clients having limited system resources, the computer program product for implementing a method for the server to simultaneously exchange data with at least two clients such that the clients can access and transfer data updates in a resource efficient manner, the computer program product comprising one or more computer-readable media having stored thereon computer-executable instructions that, when executed by a processor, cause the server to perform the following:

establish a first connection to a first client;

access a first data subset in a server database, the first data subset corresponding to the first client;

initiate transfer of the first data subset to the first client over the first connection, the first data subset for updating a first client database at the first client;

establish a second connection to a second client, prior to the first connection being terminated;

access a second data subset in the server database, the second data subset corresponding to the second client;

initiate transfer of the second data subset to the second client over the second connection, the second data subset for updating a second client database at the second client; and

transfer at least a portion of the first data subset and at least a portion of the second data subset essentially simultaneously.

31. The computer program product as recited in claim 30, further computer-executable-instructions that, when executed by a processor, cause the server to format the first data set for use at the first client such that the resources of the first client can be freed up for other processing.

32. The computer program product as recited in claim 30, further computer-executable-instructions that, when executed by a processor, cause the server to format the second data set for use at the second client such that the resources of the second client can be freed up for other processing.

33. The computer program product as recited in claim 30, wherein computer-executable-instructions that, when executed, cause the server to transfer at least a portion of the first data subset and at least a portion of the second data subset essentially simultaneously comprise computer-executable-instructions that, when executed, cause the server to transfer a portion of the first data subset over a first TCP connection and simultaneously transfer a portion of the second data subset over a second TCP connection such that the first and second clients are updated simultaneously.

34. A computer program, product for use at a client having limited system resources, the client being network connectable to a network along with one or more other clients and a server, the computer program product for implementing a method for efficiently updating a client database at the client such that some of client'"'"'s system memory is conserved, the computer program product comprising one or more computer-readable media having stored thereon computer-executable instructions that, when executed by a processor, cause the client to perform the following establish a connection to the server;

request a client database update from the server;

receive a current data subset for the client from the server, the current data subset being a subset of data contained in a server database at the server, the current data subset containing one or more current data values from the server database and being formatted for use at the client; and

replace the client database with the current data subset, in response to receiving the current data subset.

35. The computer program product as recited in claim 34, further computer-executable-instructions that, when executed by a processor, cause the client to perform the following:

detect that a portion of the current data subset has been modified, subsequent to overwriting the prior data values; and

transmit the modified portion of the current data subset back to the server, in response to a specified event.

36. The computer program product as recited in claim 34, further computer-executable-instructions that, when executed by a processor, cause the client to establish a second connection to the server prior to transmitting the modified portion of the current data subset back to the server.

37. A computer program, product for use at a client having limited system resources, the client being network connectable to a network along with one or more other clients and a server, the computer program product for implementing a method for efficiently updating a client database at the client such that some of the client'"'"'s system memory is conserved, the computer program product comprising one or more computer-readable media having stored thereon computer-executable instructions that, when executed by a processor, cause the client to perform the following receive a client database update;

send the client database update to the server;

empty the client database subsequent to sending the client database update in preparation for receiving updated client data;

receive an updated client data subset from the server;

store the updated client data subset in the client database.

38. The computer program product as recited in claim 37, wherein computer-executable-instructions that, when executed, cause the client to receive a client database update comprise computer-executable-instructions that, when executed, cause the client to receive a client database update through an input device at a PDA.

39. The computer program product as recited in claim 37, wherein computer-executable-instructions that, when executed, cause the client to send the client database update to the server comprise computer-executable-instructions that, when executed, cause the client to establish a TCP connection with the server.

40. The computer program product as recited in claim 37, wherein computer-executable-instructions that, when executed, cause the client to empty the client database subsequent to sending the client database update in preparation for receiving updated client data comprise computer-executable-instructions that, when executed, cause the client to remove a plurality of values from the client database.

41. The computer program product as recited in claim 37, wherein computer-executable-instructions that, when executed, cause the client to receive an updated client data subset from the server comprise computer-executable-instructions that, when executed, cause the client to receive database-update instructions.