System and method for providing database content on a client device

• US 9,942,342 B2
• Filed: 06/08/2015
• Issued: 04/10/2018
• Est. Priority Date: 06/09/2014
• Status: Active Grant

• Current Assignee: ServiceNow Incorporated
• Original Assignee: SkyGiraffe, Inc. (ServiceNow Incorporated)
• Inventors: Braun, Itay, Hecht, Boaz
• Primary Examiner(s): NGUYEN, TU T
• Application Number:
  US14/733,337
• Publication Number:
  US 20150358424A1
• Time in Patent Office: 1,037 Days
• Field of Search: 709219
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: H04L 67/1004 Server selection for load balancing
• CPC Class Codes: H04L 67/56 Provisioning of proxy services store-and-forward switching systems in data switching networks H04L12/54

Abstract

A system and method for providing content for display from data sources on a client device are provided. The method includes receiving, by a distribution server, a report identifier associated with a report and a request for information, wherein the information is requested based on the report; determining by the distribution server at least a data source, the at least a data source storing at least a portion of the information; requesting access from the integration server to the at least a data source to retrieve the at least a portion of the information; and sending from the distribution server to the client device, the at least a portion of the information, wherein the at least a portion of information is utilized in the report. In an embodiment, the data sources are accessible by an integration server.

Claims

1. A computerized method for providing content for display from data sources on a client device, wherein the data sources are accessible by an integration server, comprising:

receiving, by a distribution server, a report identifier associated with a report and a request for information, wherein the information is requested based on the report and wherein the received report identifier includes a report version number;

determining by the distribution server at least a data source, the at least a data source storing at least a portion of the information;

requesting access from the integration server to the at least a data source to retrieve the at least a portion of the information, wherein the integration server is connected to the distribution server;

sending from the distribution server to the client device, the at least a portion of the information, wherein the at least a portion of information is utilized in the report;

determining a corresponding report identifier stored on the distribution server; and

sending, to the client device, an updated report upon determination that the received report version number does not match a report version number of the corresponding report identifier.

2. The computerized method of claim 1, further comprising:

receiving, from an administrator device, an authorization for the client device to receive a new report and a new report identifier associated with the new report.

3. The computerized method of claim 1, further comprising:

determining a bandwidth between the client device and the distribution server; and

optimizing, based on the bandwidth, the sending of the at least a portion of the information.

4. The computerized method of claim 1, further comprising:

receiving, from the client device, a request to update data in the at least a data source.

5. The computerized method of claim 1, wherein each of the at least a data source is any of:

a relational database, a non-relational database, a web service, a list of comma-separated values (CSVs), and an image cache.

6. The computerized method of claim 1, further comprising:

sending, to the client device, an instruction to delete the report and the associated report identifier.

7. The computerized method of claim 1, further comprising:

determining, based on a threshold, whether the at least a portion of information is frequently accessed; and

upon determining that the at least a portion of information is frequently accessed, storing, by the distribution server, the at least a portion of information.

8. A non-transitory computer readable medium having stored thereon instructions for causing one or more processing units to execute a method for providing content for display from data sources on a client device, wherein the data sources are accessible by an integration server, the method comprising:

receiving, by a distribution server, a report identifier associated with a report and a request for information, wherein the information is requested based on the report and wherein the received report identifier includes a report version number;

determining by the distribution server at least a data source, the at least a data source storing at least a portion of the information;

requesting access from the integration server to the at least a data source to retrieve the at least a portion of the information, wherein the integration server is connected to the distribution server;

sending from the distribution server to the client device, the at least a portion of the information, wherein the at least a portion of information is utilized in the report;

determining a corresponding report identifier stored on the distribution server; and

sending, to the client device, an updated report upon determination that the received report version number does not match a report version number of the corresponding report identifier.

9. A system for providing content from data sources on a client device, comprising:

a distribution server for providing the content from the data sources;

a processing unit; and

a memory, the memory containing instructions that, when executed by the processing unit, configure the system to;

receive a report identifier associated with a report and a request for information, wherein the information is requested based on the report and wherein the report identifier includes a report version number;

determine by the distribution server at least a data source, the at least a data source storing at least a portion of the information;

request access from an integration server to the at least a data source to retrieve the at least a portion of the information, wherein the integration server is connected to the distribution server;

send to the client device, the at least a portion of the information, wherein the at least a portion of information is utilized in the report;

determine a corresponding report identifier stored on the system; and

send, to the client device, an updated report upon determination that the received report version number does not match a report version number of the corresponding report identifier.

10. The system of claim 9, wherein the system is further configured to:

receive, from an administrator device, an authorization for the client device to receive a new report and a new report identifier associated with the new report.

11. The system of claim 9, wherein the system is further configured to:

determine a bandwidth between the client device and the system; and

optimize, based on the bandwidth, the sending of the at least a portion of the information.

12. The system of claim 9, wherein the system is further configured to:

receive, from the client device, a request to update data in the at least a data source.

13. The system of claim 9, wherein each of the at least a data source is any of:

a relational database, a non-relational database, a web service, a list of comma-separated values (CSVs), and an image cache.

14. The system of claim 9, wherein the system is further configured to:

send, to the client device, an instruction to delete the report and the associated report identifier.

15. The system of claim 9, wherein the system is further configured to:

determine, based on a threshold, whether the at least a portion of information is frequently accessed; and

upon determining that the at least a portion of information is frequently accessed, store, by the system, the at least a portion of information.