Composite active reports

Patent metadata

Field	Value
Publication number	US-9524322-B2
Application number	US-201314040354-A
Country	US
Kind code	B2
Filing date	Sep 27, 2013
Priority date	Jun 28, 2013
Publication date	Dec 20, 2016
Grant date	Dec 20, 2016

Abstract

Techniques for generating and processing composite active reports are provided. An active report is a report that can be displayed and interacted with at a client device even though the client device is not connected to a database from which data for the report originates. A composite active report is an active report that includes multiple reports embedded in the same file. Each report in a composite active report may be separately compressed to allow a client device to decompress a report on demand. A composite active report may include, for each report indicated in the composite active report, executable identification data that is used to retrieve, from a remote source, an executable that is used to generate, based on report data of the report, display data, which is displayed on a computer display of a client device.

First claim

What is claimed is:

1. A method comprising:
receiving, at a database system, a request to generate a composite report based on data stored in a database of the database system;
in response to receiving the request, for each report of a plurality of reports:
retrieving, from the database, report data for said each report;
storing the report data for said each report in a particular file;
storing, in the particular file, in association with the report data for said each report, executable identification data that identifies a location for a client device to retrieve, over a network, an executable that is to be executed by the client device that is remote relative to the database system and that is configured to process the report data of said each report to display user interface data for said each report;

wherein the particular file includes the report data for each report of the plurality of reports;
wherein the particular file is to be processed by the client device that is not connected to the database system;
wherein the method is performed by one or more computing devices.

2. The method of claim 1 , wherein storing the report data for said each report in the particular file comprises:
compressing first report data for a first report of the plurality of reports to generate first compressed report data;
storing the first compressed report data in the particular file;
compressing second report data for a second report of the plurality of reports to generate second compressed report data that is different than the first compressed report data;
storing the second compressed report data in the particular file.

3. The method of claim 1 , wherein storing the executable identification data comprises:
storing, in the particular file, in association with first report data for a first report of the plurality of reports, first executable identification data that identifies a location to retrieve a first executable that is configured to process the first report data;
storing, in the particular file, in association with second report data for a second report of the plurality of reports, second executable identification data that identifies a location to retrieve a second executable that is different than the first executable and that is configured to process the second report data.

4. The method of claim 1 , wherein:
the plurality of reports includes a first report that corresponds to a first database feature;
the plurality of reports includes a second report that corresponds to a second database feature that is different than the first database feature.

5. The method of claim 4 , wherein a particular report of the plurality of reports includes performance-related data regarding one or more of:
a plurality of monitored SQL executions, specific operations performed within a single monitored SQL execution, a plurality of database sessions, a plurality of SQL statements that use the most resources in the database, or a single SQL statement where the performance-related data includes two or more of resource usage, activity, execution plans, or monitored executions of the single SQL statement.

6. The method of claim 1 , further comprising:
in response to receiving the request, sending the particular file to a recipient indicated in the request.

7. A method comprising:
receiving, at a client device, a composite report that includes composite data about a plurality of reports, each of which corresponds to different report data that was retrieved from a database;
while the client device is not connected to the database, the client device:
analyzing the composite data in the composite report to identify, for each report of the plurality of reports, executable identification data that identifies a location to retrieve an executable that is used to process report data that corresponds to said each report;
retrieving, over a network, based on first executable identification data in the composite data, a first executable;
executing the first executable against first report data, in the composite report, that corresponds to a first report of the plurality of reports and that is associated with the first executable to generate first display data;
causing the first display data to be displayed on a display screen of the client device;
retrieving, over the network, based on second executable identification data in the composite data, a second executable;
executing the second executable against second report data, in the composite report, that corresponds to a second report of the plurality of reports and that is associated with the second executable to generate second display data;

causing the second display data to be displayed on the display screen of the client device.

8. The method of claim 7 , wherein the report data for each report of the plurality of reports is compressed prior to executing the first executable and the second executable.

9. The method of claim 8 , further comprising:
prior to executing the first executable, decompressing the first report data to generate decompressed first report data without decompressing the second report data to generate decompressed second report data;
after causing the first display data to be displayed, decompressing the second report data to generate the decompressed second report data.

10. The method of claim 7 , wherein:
analyzing the composite data comprises generating, at the client device, a set of mappings that includes at least a first mapping and a second mapping;
the first mapping associates the first report data with the first executable identification data;
the second mapping associates the second report data with the second executable identification data.

11. The method of claim 7 , wherein:
each report of the plurality of reports corresponds to a different database feature;
the first report of the plurality of reports includes performance information regarding one or more of:
a plurality of monitored SQL executions, specific operations performed within a single monitored SQL execution, a plurality of database sessions, a plurality of SQL statements that use the most resources in the database, or a single SQL statement where the performance information includes two or more of resource usage, activity, execution plans, or monitored executions of the single SQL statement.

12. The method of claim 7 , wherein:
the first report of the plurality of reports indicates first performance metrics that are associated with the database;
the second report of the plurality of reports indicates second performance metrics that are different than the first performance metrics and that are associated with the database.

13. The method of claim 7 , wherein retrieving the second executable is performed in response to receiving input that indicates user selection of the second report.

14. One or more computer-readable media storing instructions which, when executed by one or more processors, cause:
receiving, at a database system, a request to generate a composite report based on data stored in a database;
in response to receiving the request, for each report of a plurality of reports:
retrieving, from the database, report data for said each report;
storing the report data for said each report in a particular file;
storing, in the particular file, in association with the report data for said each report, executable identification data that identifies a location for a cleint device to retrieve, over a network, an executable that is to be executed by the client device that is remote relative to the database system and that is configured to process the report data of s

Assignees

• Oracle Int Corp

Inventors

• Yagoub Khaled
• Munir Abdul
• Grant Cecilia Gervasio
• Dias Karl
• Dageville Benoit

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F17/30554 Primary

  Physics · mapped topic