BULK INITIAL DOWNLOAD OF MOBILE DATABASES

• US 20120158828A1
• Filed: 10/18/2011
• Published: 06/21/2012
• Est. Priority Date: 12/21/2010
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Ireland, Evan, Donahue, Brett, Zhang, Guo-ping, He, Xiong
• Granted Patent: US 10,102,242 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 16/2393 Updating materialised views

Abstract

A system, method, and computer program product are provided for handling bulk initial downloads of databases to mobile devices. Rather than straining the resources of a mobile device to recreate the database locally, a server can construct the database to the mobile device'"'"'s requirements at the server by impersonating the mobile device. The server can then send the database, compressed and over an encrypted session, to the mobile device. The mobile device can then decrypt and uncompress the pages received, and then encrypt them using a local key for secure storage on a local storage device.

Claims

1. A method comprising:

receiving a subscription request from a client;

impersonating the client to generate a temporary database file based on the subscription request; and

transmitting the temporary database file to the client.

2. The method of claim 1, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

generating contents of the temporary database file based on contents of the subscription request.

3. The method of claim 1, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

generating contents of the temporary database file specific to the client.

4. The method of claim 1, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

selecting a bulk download program compatible with the client; and

generating the temporary database file using the bulk download program.

5. The method of claim 1, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

determining that a bulk download program compatible with the client does not exist;

invoking a code generator to generate a compatible bulk download program emulating code for use on the client; and

generating the temporary database file using the compatible bulk download program.

6. A computer-readable storage device having computer-executable instructions stored thereon that, if executed by a computing device, cause the computing device to perform operations comprising:

receiving a subscription request from a client;

impersonating the client to generate a temporary database file based on the subscription request; and

transmitting the temporary database file to the client.

7. The computer-readable storage device of claim 6, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

generating contents of the temporary database file based on contents of the subscription request.

8. The computer-readable storage device of claim 6, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

generating contents of the temporary database file specific to the client.

9. The computer-readable storage device of claim 6, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

selecting a bulk download program compatible with the client; and

generating the temporary database file using the bulk download program.

10. The computer-readable storage device of claim 6, wherein impersonating the client to generate a temporary database file based on the subscription request comprises:

determining that a bulk download program compatible with the client does not exist;

invoking a code generator to generate a compatible bulk download program emulating code for use on the client; and

generating the temporary database file using the compatible bulk download program.

11. A system comprising:

a memory configured to store modules comprising;

a receiving module configured to receive a subscription request from a client,

an impersonating module configured to impersonate the client to generate a temporary database file based on the subscription request, and

a transmitting module configured to transmit the temporary database file to the client; and

one or more processors configured to process the modules.

12. The system of claim 11, wherein the impersonating module is further configured to:

generate contents of the temporary database file based on contents of the subscription request.

13. The system of claim 11, wherein the impersonating module is further configured to:

generate contents of the temporary database file specific to the client.

14. The system of claim 11, wherein the impersonating module is further configured to:

select a bulk download program compatible with the client; and

generate the temporary database file using the bulk download program.

15. The system of claim 11, wherein the impersonating module is further configured to:

determine that a bulk download program compatible with the client does not exist;

invoke a code generator to generate a compatible bulk download program emulating code for use on the client; and

generate the temporary database file using the compatible bulk download program.

16. A method comprising:

transmitting a subscription request to a server;

receiving a page of a database file based on the subscription request;

encrypting the page of the database file; and

writing the encrypted page of the database file to a storage device.

17. The method of claim 16, wherein encrypting the page of the database file comprises:

encrypting the page of the database file using a client-specific database encryption key.

18. The method of claim 16, wherein the page of the database file is encrypted, further comprising:

decrypting the page of the database file using a negotiated session key.

19. A computer-readable storage device having computer-executable instructions stored thereon that, if executed by a computing device, cause the computing device to perform operations comprising:

transmitting a subscription request to a server;

receiving a page of a database file based on the subscription request;

encrypting the page of the database file; and

writing the encrypted page of the database file to a storage device.

20. The computer-readable storage device of claim 19, wherein encrypting the page of the database file comprises:

encrypting the page of the database file using a client-specific database encryption key.

21. The computer-readable storage device of claim 19, wherein the page of the database file is encrypted, the operations further comprising:

decrypting the page of the database file using a negotiated session key.

22. A system comprising:

a memory configured to store modules comprising;

a transmitting module configured to transmit a subscription request to a server,

a receiving module configured to receive a page of a database file based on the subscription request,

an encrypting module configured to encrypt the page of the database file, and

a writing module configured to write the encrypted page of the database file to a storage device; and

one or more processors configured to process the modules.

23. The system of claim 22, wherein the encrypting module is further configured to:

encrypt the page of the database file using a client-specific database encryption key.

24. The system of claim 22, wherein the page of the database file is encrypted, further comprising:

a decrypting module configured to decrypt the page of the database file using a negotiated session key.