Enhanced reporting system

摘要

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.

主权项

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; anduse 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.