Enhanced reporting system

• US 9,305,034 B2
• Filed: 10/30/2013
• Issued: 04/05/2016
• Est. Priority Date: 10/30/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Kemmler, Andreas, Kamenz, Torsten
• Primary Examiner(s): Ly, Anh
• Application Number:
  US14/067,187
• Publication Number:
  US 20150120785A1
• Time in Patent Office: 888 Days
• Field of Search: 707/803, 707/736, 707/E17.045
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A system receives database tables from a plurality of computer systems. Each of the database tables is associated with a particular computer system. Each particular computer system is associated with a particular schema. The database tables are stored in a computer storage device according to the particular schema of the computer system with which each database table is associated. Database views are created and stored. Each of the views is associated with a particular schema. A configuration table according to the particular schemas of each of the computer systems is generated. The configuration table is displayed on a display device. A selection of one or more schemas is received from the display on the computer display device. The database view from one of the selected database schemas is used as a template to generate a view for all of the selected schemas.

Claims

1. A system comprising:

a computer processor operable to;

receive a plurality of database tables from a plurality of computer systems, wherein each of the plurality of database tables is associated with a particular computer system, wherein each particular computer system is associated with a particular schema, and wherein the plurality of computer systems comprises enterprise resource planning (ERP) systems of a customer of a software vendor;

store each of the plurality of database tables in a computer storage device according to the particular schema of the computer system with which each database table is associated, wherein the computer storage device comprises an in-memory database of the software vendor;

create a plurality of database views and store the plurality of database views in the computer storage device, wherein each of the plurality of views is associated with a particular schema;

generate a configuration table according to the particular schemas of each of the plurality of computer systems;

display the configuration table of the particular schemas of each of the plurality of computer systems on a computer display device;

receive a selection of one or more schemas from the display on the computer display device; and

use a database view from one of the selected database schemas as a template to generate a view for all of the selected schemas;

thereby replicating the ERP systems of the customer to different schemas in the in-memory database of the software vendor.

2. The system of claim 1, wherein the computer processor is operable to generate the plurality of database views using a database query statement.

3. The system of claim 2, wherein the computer processor is operable to generate the view for all the selected schemas by using database query statements based on the database view associated with the selected database schema.

4. The system of claim 3, wherein the database query statements are SQL query statements.

5. The system of claim 1, wherein the computer processor is operable to receive input for regenerating entries in the configuration table.

6. The system of claim 1, wherein the computer processor is operable to use the database view from one of the selected database schemas as a template to generate a view of the selected schemas by modifying the view so that the view is capable of accessing additional database tables in the identified schemas.

7. The system of claim 1, wherein a particular database schema is associated with more than one client;

and wherein the computer processor is operable to receive an identification from a user of one or more clients to use in the generation of the view of the selected schemas.

8. The system of claim 7, wherein the computer processor is operable to receive an indication from the user that the one or more clients are to be unified and treated as a same client;

and to receive an indication from the user that the one or more clients are to be kept separate and treated as separate clients.

9. A process comprising:

receiving into a computer processor a plurality of database tables from a plurality of computer systems, wherein each of the plurality of database tables is associated with a particular computer system, ˜

wherein each particular computer system is associated with a particular schema, and wherein the plurality of computer systems comprises enterprise resource planning (ERP) systems of a customer of a software vendor;

storing each of the plurality of database tables in a computer storage device according to the particular schema of the computer system with which each database table is associated, wherein the computer storage device comprises an in-memory database of the software vendor;

creating using the computer processor a plurality of database views and storing the plurality of database views in the computer storage device, wherein each of the plurality of views is associated with a particular schema;

generating using the computer processor a configuration table according to the particular schemas of each of the plurality of computer systems;

displaying the configuration table of the particular schemas of each of the plurality of computer systems on a computer display device;

receiving into the computer processor a selection of one or more schemas from the display on the computer display device; and

using a database view from one of the selected database schemas as a template to generate a view for all of the selected schemas;

thereby replicating the ERP systems of the customer to different schemas in the in-memory database of the software vendor.

10. The process of claim 9, comprising generating the plurality of database views using a database query statement and generating the view for all the selected schemas by using database query statements based on the database view associated with the selected database schema.

11. The process of claim 9, comprising regenerating entries in the configuration table.

12. The process of claim 9, comprising using the database view from one of the selected database schemas as a template to generate a view of the selected schemas by modifying the view so that the view is capable of accessing additional database tables in the identified schemas.

13. The process of claim 9, wherein a particular database schema is associated with more than one client;

and comprising receiving an identification from a user of one or more clients to use in the generation of the view of the selected schemas;

receiving an indication from the user that the one or more clients are to be unified and treated as a same client; and

receiving an indication from the user that the one or more clients are to be kept separate and treated as separate clients.

14. A computer readable medium comprising instructions that when executed by a client execute a process comprising:

receiving into a computer processor a plurality of database tables from a plurality of computer systems, wherein each of the plurality of database tables is associated with a particular computer system, wherein each particular computer system is associated with a particular schema, and wherein the plurality of computer systems comprises enterprise resource planning (ERP) systems of a customer of a software vendor;

storing each of the plurality of database tables in a computer storage device according to the particular schema of the computer system with which each database table is associated, wherein the computer storage device comprises an in-memory database of the software vendor;

creating using the computer processor a plurality of database views and storing the plurality of database views in the computer storage device, wherein each of the plurality of views is associated with a particular schema;

generating using the computer processor a configuration table according to the particular schemas of each of the plurality of computer systems;

displaying the configuration table of the particular schemas of each of the plurality of computer system on a computer display device;

receiving into the computer processor a selection of one or more schemas from the display on the computer display device; and

using a database view from one of the selected database schemas as a template to generate a view for all of the selected schemas;

thereby replicating the ERP systems of the customer to different schemas in the in-memory database of the software vendor.

15. The computer readable medium of claim 14, comprising instructions for generating the plurality of database views using a database query statement and generating the view for all the selected schemas by using database query statements based on the database view associated with the selected database schema.

16. The computer readable medium of claim 14, comprising instructions for regenerating entries in the configuration table.

17. The computer readable medium of claim 14, comprising instructions for using the database view from one of the selected database schemas as a template to generate a view of the selected schemas by modifying the view so that the view is capable of accessing additional database tables in the identified schemas.

18. The computer readable medium of claim 14, wherein a particular database schema is associated with more than one client;

and comprising instructions for receiving an identification from a user of one or more clients to use in the generation of the view of the selected schemas;

instructions for receiving an indication from the user that the one or more clients are to be unified and treated as a same client; and

instructions for receiving an indication from the user that the one or more clients are to be kept separate and treated as separate clients.