OFFLINE ACCESS OF DATA IN MOBILE DEVICES

• US 20180167258A1
• Filed: 12/13/2016
• Published: 06/14/2018
• Est. Priority Date: 12/13/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Radhakrishnan, Jagadish, Rana, Dharmesh, Setty, Swati Krishna, Krishnakumar, Arjun
• Granted Patent: US 10,528,541 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/903 Querying for retrieval from the web G06F16/953
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: H04L 41/024 using relational databases for representation of network management data, e.g. managing via structured query language [SQL]

Abstract

In offline access of data in mobile devices, a request to access a document is received at a mobile server. The document is fetched from a BI platform to the mobile server. Plurality of requests is sent from the mobile server to the BI platform to retrieve data packages from the BI platform. The data packages is converted to a plurality relational database management tables at the mobile server. The plurality of relational database management tables is compressed to a compressed database. The compressed database is sent to the mobile device and stored. A new request is received at the mobile device for operations on the document. Based on the new request, operations are performed on the document based on the compressed database stored in the mobile device, when the mobile device is not connected to the mobile server.

Claims

1. A non-transitory computer-readable medium to store instructions, which when executed by a computer, cause the computer to perform operations comprising:

receive a request to access a document at a mobile server;

fetch the document from a BI platform to the mobile server;

based on the request, automatically send a plurality of requests to retrieve data packages corresponding to the document, wherein the plurality of requests are sent from the mobile server to the BI platform;

compress the data packages corresponding to the document at the mobile server to generate a compressed database;

in response to the request to access the document, send the compressed database from the mobile server to the mobile device; and

access the document from the compressed database stored in the mobile device without communicating with the mobile server.

2. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

receive a new request at the mobile device for operations on the document; and

in response to the new request, perform operations on the document based on the compressed database stored in the mobile device, wherein the mobile device is not connected to the mobile server.

3. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

convert the data packages to a plurality of relational database management tables at the mobile server; and

compress the plurality of relational database management tables to generate the compressed database.

4. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

compare a timestamp associated with the document in the mobile device with a timestamp associated with the document in a data repository associated with the mobile server; and

upon determining that the timestamp associated with the document in the mobile device differs from the timestamp associated with the document in the data repository associated with the mobile server, fetch the document from the data repository associated with the mobile server to the mobile device.

5. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

fetch the document from a cache memory in the mobile server to the mobile device.

6. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

parse a flapping document to interpret contents of the data packages, wherein the mapping document includes a mapping identifier, data type and length of data in the data packages.

7. The computer-readable medium of claim 1, further comprises instructions which when executed by the computer further cause the computer to:

compress data in the data packages in one or more batches at the mobile server to generate the compressed database; and

send the compressed database from the mobile server to the mobile device in batches.

8. A computer-implemented method for offline access of data in mobile devices, the method comprising:

receiving a request to access a document at a mobile server;

fetching the document from a BI platform to the mobile server;

based on the request, automatically sending a plurality of requests to retrieve data packages corresponding to the document, wherein the plurality of requests are sent from the mobile server to the BI platform;

compressing the data packages corresponding to the document at the mobile server to generate a compressed database;

in response to the request to access the document, sending the compressed database from the mobile server to the mobile device; and

accessing the document from the compressed database stored in the mobile device without communicating with the mobile server.

9. The method of claim 8, further comprising:

receiving a new request at the mobile device for operations on the document; and

in response to the new request, performing operations on the document based on the compressed database stored in the mobile device, wherein the mobile device is not connected to the mobile server.

10. The method of claim 8, further comprising:

converting the data packages to a plurality of relational database management tables at the mobile server; and

compressing the plurality of relational database management tables to generate the compressed database.

11. The method of claim 8, further comprising:

comparing a timestamp associated with the document in the mobile device with a timestamp associated with the document in a data repository associated with the mobile server; and

upon determining that the timestamp associated with the document in the mobile device differs from the timestamp associated with the document in the data repository associated with the mobile server, fetching the document from the data repository associated with the mobile server to the mobile device.

12. The method of claim 8, further comprising:

fetching the document from a cache memory in the BI platform to the mobile server.

13. The method of claim 8, further comprising:

parsing a mapping document to interpret contents of the data packages, wherein the mapping document includes a mapping identifier, data type and length of data in the data packages.

14. The method of claim 8, further comprising:

compressing data in the data packages in one or more batches at the mobile server to generate the compressed database; and

sending the compressed database from the mobile server to the mobile device in batches.

15. A computer system for offline access of data in mobile devices, comprising:

a computer memory to store program code; and

a processor to execute the program code to;

receive a request to access a document at a mobile server;

fetch the document from a BI platform to the mobile server;

based on the request, automatically send a plurality of requests to retrieve data packages corresponding to the document, wherein the plurality of requests are sent from the mobile server to the BI platform;

compress the data packages corresponding to the document at the mobile server to generate a compressed database;

in response to the request to access the document, send the compressed database from the mobile server to the mobile device; and

access the document from the compressed database stored in the mobile device without communicating with the mobile server.

16. The system of claim 15, wherein the processor further executes the program code to:

receive a new request at the mobile device for operations on the document; and

in response to the new request, perform operations on the document based on the compressed database stored in the mobile device, wherein the mobile device is not connected to the mobile server.

17. The system of claim 15, wherein the processor further executes the program code to:

convert the data packages to a plurality of relational database management tables at the mobile server; and

compress the plurality of relational database management tables to the compressed database.

18. The system of claim 15, wherein the processor further executes the program code to:

compare a timestamp associated with the document in the mobile device with a timestamp associated with the document in a data repository associated with the mobile server; and

upon determining that the timestamp associated with the document in the mobile device differs from the timestamp associated with the document in the data repository associated with the mobile server, fetch the document from the data repository associated with the mobile server to the mobile device.

19. The system of claim 15, wherein the processor further executes the program code to:

parse a mapping document to interpret contents of the data packages, wherein the mapping document includes a mapping identifier, data type and length of data in the data packages.

20. The system of claim 15, wherein the processor further executes the program code to:

compress data in the data packages in one or more batches at the mobile server to generate the compressed database; and

send the compressed database from the mobile server to the mobile device in batches.