Offline access of data in mobile devices

• US 10,528,541 B2
• Filed: 12/13/2016
• Issued: 01/07/2020
• 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
• Primary Examiner(s): Alam, Uzma
• Application Number:
  US15/376,772
• Publication Number:
  US 20180167258A1
• Time in Patent Office: 1,120 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, at a mobile server, a request to access a document;

based on the request, automatically send, from the mobile server to a business intelligence (BI) platform, a plurality of requests to retrieve data packages corresponding to the document;

based on responses from the BI platform, receive and load, at the mobile server, the data packages, wherein the data packages comprise a workspace instance comprising graphical representation charts included in the document, metadata for visualization of the graphical representation charts from the document, global data mapping information for interpreting content of the document, and a document object including raw data values associated with the document, wherein the raw data values from the document objects are interpreted based on the global data mapping information;

convert the raw data values associated with the document into a first relational database management table, the global data mapping information into a second relational database management table, and the workspace instance with the metadata for visualization into a third relational database management table;

compress, at the mobile server, the first relational database management table, the second relation database management table, and the third relational database management table corresponding to the document to generate one or more compressed databases to be sent in compressed form to a mobile device; and

in response to the request to access the document, send, from the mobile server, the one or more compressed databases to a mobile device, wherein the mobile device is configured to store the one or more compressed databases, and wherein the mobile device is further configured to allow accessing the document from the one or more compressed databases 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 one or more compressed databases 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:

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 store as a new version of the document at the mobile device.

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

store the document at a cache memory in the mobile server when the document is associated with multiple requests received from 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:

retrieve the global data mapping information from the second relational database management table to interpret the content of the data packages, wherein the global data mapping information includes a mapping identifier, data type and length of data in the data packages.

6. 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 one or more compressed databases; and

send the one or more compressed databases from the mobile server to the mobile device in batches.

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

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

based on the request, automatically sending, from the mobile server to a business intelligence (BI) platform, a plurality of requests to retrieve data packages corresponding to the document;

based on responses from the BI platform, receiving and loading, at the mobile server, the data packages, wherein the data packages comprise a workspace instance comprising graphical representation charts included in the document, metadata for visualization of the graphical representation charts from the document, global data mapping information for interpreting content of the document, and a document object including raw data values associated with the document, wherein the raw data values from the document objects are interpreted based on the global data mapping information;

converting the raw data values associated with the document into a first relational database management table, the global data mapping information into a second relational database management table, and the workspace instance with the metadata for visualization into a third relational database management table;

compressing, at the mobile server, the first relational database management table, the second relation database management table, and the third relational database management table corresponding to the document to generate a one or more compressed databases to be sent in compressed form to a mobile device; and

in response to the request to access the document, sending, from the mobile server, the one or more compressed databases to a mobile device, wherein the mobile device is configured to store the one or more compressed databases, and wherein the mobile device is further configured to allow accessing the document from the one or more compressed databases stored in the mobile device without communicating with the mobile servers.

8. The method of claim 7, 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 one or more compressed databases stored in the mobile device, wherein the mobile device is not connected to the mobile server.

9. The method of claim 7, 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, fetch the document from the data repository associated with the mobile server to store as a new version of the document at the mobile device.

10. The method of claim 7, further comprising:

storing the document at a cache memory in the mobile server when the document is associated with multiple requests received from the mobile device.

11. The method of claim 7, further comprising:

retrieving the global data mapping information from the second relational database management table to interpret the content of the data packages, wherein the global data mapping information includes a mapping identifier, data type and length of data in the data packages.

12. The method of claim 7, further comprising:

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

sending the one or more compressed databases from the mobile server to the mobile device in batches.

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

a computer memory to store program code; and

at least one processor to execute the program code to;

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

based on the request, automatically send, from the mobile server to a business intelligence (BI) platform, a plurality of requests to retrieve data packages corresponding to the document;

based on responses from the BI platform, receive and load, at the mobile server, the data packages, wherein the data packages comprise a workspace instance comprising graphical representation charts included in the document, metadata for visualization of the graphical representation charts from the document, global data mapping information for interpreting content of the document, and a document object including raw data values associated with the document, wherein the raw data values from the document objects are interpreted based on the global data mapping information;

convert the raw data values associated with the document into a first relational database management table, the global data mapping information into a second relational database management table, and the workspace instance with the metadata for visualization into a third relational database management table;

compress, at the mobile server, the first relational database management table, the second relation database management table, and the third relational database management table corresponding to the document to generate one or more compressed databases to be sent in compressed form to a mobile device; and

in response to the request to access the document, send, from the mobile server, the one or more compressed databases to a mobile device, wherein the mobile device is configured to store the one or more compressed databases, and wherein the mobile device is further configured to allow accessing the document from the one or more compressed databases stored in the mobile device without communicating with the mobile server.

14. The system of claim 13, wherein the at least one 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 one or more compressed databases stored in the mobile device, wherein the mobile device is not connected to the mobile server.

15. The system of claim 13, wherein the at least one 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 store as a new version of the document at the mobile device.

16. The system of claim 13, wherein the at least one processor further executes the program code to:

retrieve the global data mapping information from the second relational database management table to interpret the content of the data packages, wherein the global data mapping information includes a mapping identifier, data type and length of data in the data packages.

17. The system of claim 13, wherein the at least one 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 one or more compressed databases; and

send the one or more compressed databases from the mobile server to the mobile device in batches.