Enhanced reporting system

• US 10,114,822 B2
• Filed: 07/31/2013
• Issued: 10/30/2018
• Est. Priority Date: 07/31/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kamenz, Torsten, Kemmler, Andreas
• Primary Examiner(s): Willoughby, Alicia M
• Application Number:
  US13/955,772
• Publication Number:
  US 20150039638A1
• Time in Patent Office: 1,917 Days
• Field of Search: None
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

A computer system includes a first database system that includes a plurality of tables, and a second database system that includes a subset of the tables in the first database system. The system identifies a plurality of reports that are currently generated using the second database system. The system also identifies a plurality of reports that are not currently generated using the second database system, but that are capable of being generated using the second database system, and displays a list of these reports on a computer display device. In an embodiment, the system further replicates one or more tables that are required for generation of additional reports from the first database system to the second database system.

Claims

1. A system comprising:

a computer processor;

a first database system coupled to the computer processor, the first database system comprising a plurality of tables; and

a second database system coupled to the computer processor, the second database system comprising a subset of the tables in the first database system;

wherein the computer processor is operable to identify a plurality of reports that are currently generated using the second database system;

wherein the computer processor is operable to automatically identify without user input a plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

wherein the computer processor is operable to display on a computer display device a list of the plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

wherein the computer processor is operable to receive input from a user selecting one or more of the plurality of reports, generate the selected reports, and display the generated reports on a computer display device;

wherein the computer processor is operable to receive input identifying an additional report to be generated, the additional report to be generated requiring one or more tables that are not on the second database system;

wherein the computer processor is operable to identify the one or more tables that are not on the second database system and that are needed to generate the additional report;

wherein the computer processor is operable to determine the size of each of the one or more tables that are not on the second database system and that are needed to generate the additional report;

wherein the computer processor is operable to display on the computer display device a list of the one or more tables and the size of the one or more tables that are not on the second database system and that are needed to generate the additional report; and

wherein the computer processor is operable to display a list of a plurality of additional reports that are currently not generated using the second database system sorted by number of additional tables that are required to generate the additional report and size of additional tables needed to generate the additional report.

2. The system of claim 1, wherein the computer processor is operable to create the second database system by transmitting the subset of tables from the first database system to the second database system.

3. The system of claim 2, wherein the transfer of the subset of tables from the first database system to the second database system is executed in real time when a need arises on the second database system for the subset of tables.

4. The system of claim 1, wherein the second database system comprises an in-memory database system.

5. The system of claim 1, wherein the computer processor is operable to:

generate a first list of the plurality of reports currently generated using the second database system;

generate a second list of the plurality of reports that are capable of being generated using the second database system;

compare the first list to the second list; and

display on the computer display device a third list comprising reports that appear on the second list but that do not appear on the first list.

6. The system of claim 5, wherein the computer processor is operable to receive input from a user selecting one or more of the reports from the third list;

generate the selected reports; and

display the generated reports to the user.

7. The system of claim 5, wherein a report is capable of being generated using the second database system based on a presence of all tables required for the generation of the report capable of being generated already being present on the second database system, the all tables already being present on the second database system because the all tables are used for generation of one or more of the reports currently being generated.

8. The system of claim 1, wherein the currently generated reports and the reports capable of generation are associated with a particular user.

9. The system of claim 1, wherein the computer processor is operable to transfer one or more tables required for generation of the additional reports from the first database system to the second database system.

10. A process comprising:

identifying a plurality of reports that are currently generated using a second database system,

wherein the second database system comprises a subset of tables from a first database system comprising a plurality of tables;

identifying a plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

displaying on a computer display device a list of the plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

receiving input from a user selecting one or more of the plurality of reports, generating the selected reports, and displaying the generated reports on a computer display device;

receiving input identifying an additional report to be generated, the additional report to be generated requiring one or more tables that are not on the second database system;

identifying the one or more tables that are not on the second database system and that are needed to generate the additional report;

determining the size of each of the one or more tables that are not on the second database system and that are needed to generate the additional report;

displaying on the computer display device a list of the one or more tables and the size of the one or more tables that are not on the second database system and that are needed to generate the additional report; and

displaying a list of a plurality of additional reports that are currently not generated using the second database system sorted by number of additional tables that are required to generate the additional report and size of additional tables needed to generate the additional report.

11. The process of claim 10, wherein the second database system comprises and in-memory database system.

12. The process of claim 10, comprising:

generating a first list of the plurality of reports currently generated using the second database system;

generating a second list of the plurality of reports that are capable of being generated using the second database system;

comparing the first list to the second list; and

displaying on the computer display device a third list comprising reports that appear on the second list but that do not appear on the first list.

13. The process of claim 12, comprising:

receiving input from a user selecting one or more of the reports from the third list;

generating the selected reports; and

displaying the generated reports to the user.

14. The process of claim 10, comprising:

receiving an input indicating one or more additional reports to generate; and

transferring one or more tables required for generation of the additional reports from a first database system to the second database system.

15. A non-transitory computer readable medium comprising instructions that when executed by a processor execute a process comprising:

identifying a plurality of reports that are currently generated using a second database system,

wherein the second database system comprises a subset of tables from a first database system comprising a plurality of tables;

identifying a plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

displaying on a computer display device a list of the plurality of reports that are not currently generated using the second database system but that are capable of being generated using the second database system;

receiving input from a user selecting one or more of the plurality of reports, generating the selected reports, and displaying the generated reports on a computer display device;

receiving input identifying an additional report to be generated, the additional report to be generated requiring one or more tables that are not on the second database system;

identifying the one or more tables that are not on the second database system and that are needed to generate the additional report;

determining the size of each of the one or more tables that are not on the second database system and that are needed to generate the additional report;

displaying on the computer display device a list of the one or more tables and the size of the one or more tables that are not on the second database system and that are needed to generate the additional report; and

displaying a list of a plurality of additional reports that are currently not generated using the second database system sorted by number of additional tables that are required to generate the additional report and size of additional tables needed to generate the additional report.