ENHANCED REPORTING SYSTEM
First Claim
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, and wherein each particular computer system is associated with a particular schema;
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;
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.
2 Assignments
0 Petitions
Accused Products
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.
-
Citations
20 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, and wherein each particular computer system is associated with a particular schema; 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; 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
11. 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, and wherein each particular computer system is associated with a particular schema; 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; 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. - View Dependent Claims (12, 13, 14, 15)
-
-
16. 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, and wherein each particular computer system is associated with a particular schema; 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; 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. - View Dependent Claims (17, 18, 19, 20)
-
Specification