System for aggregating data and a method for providing the same
First Claim
Patent Images
1. A system for aggregating data from a plurality of operational databases, comprising:
- a data store storing a collection of pre-defined extraction scripts, each of said pre-defined extraction scripts identifying data available for extraction from a separate one of a plurality of operational database products, said extraction scripts including parameters for specifying which of said data to extract; and
a data warehouse server coupled to a set of operational databases corresponding to a first subset of said operational database products, said data warehouse server retrieving a database schema from each of the operational databases in the first subset of operational database products and, if the pre-defined extraction scripts and the database schemas are the same, executing a second subset of said pre-defined extraction scripts corresponding to said first subset of operational database products to extract, merge, transform and load said specified data from said operational databases into a multidimensional database.
1 Assignment
0 Petitions
Accused Products
Abstract
A system for aggregating data from a plurality of operational databases, and a method for providing the same, are provided. The system includes a data store storing a collection of pre-defined extraction scripts. The extraction scripts identify data available for extraction from a plurality of operational database products, and including parameters for specifying which of the data to extract. A data warehouse server executes the extraction scripts to extract, merge, transform and load the specified data from the plurality of operational databases into a multidimensional database.
-
Citations
30 Claims
-
1. A system for aggregating data from a plurality of operational databases, comprising:
-
a data store storing a collection of pre-defined extraction scripts, each of said pre-defined extraction scripts identifying data available for extraction from a separate one of a plurality of operational database products, said extraction scripts including parameters for specifying which of said data to extract; and a data warehouse server coupled to a set of operational databases corresponding to a first subset of said operational database products, said data warehouse server retrieving a database schema from each of the operational databases in the first subset of operational database products and, if the pre-defined extraction scripts and the database schemas are the same, executing a second subset of said pre-defined extraction scripts corresponding to said first subset of operational database products to extract, merge, transform and load said specified data from said operational databases into a multidimensional database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method for providing a system for aggregating data from a plurality of operational databases via a data warehouse server, comprising:
-
providing a collection of pre-defined extraction scripts, each of said pre-defined extraction scripts identifying data available for extraction from a separate one of a plurality of operational database products, said extraction scripts including parameters for specifying which of said data to extract; retrieving a database schema from each of plurality of operational database products and, if the pre-defined extraction scripts and the database schemas are the same; executing a first subset of said pre-defined extraction scripts corresponding to a second subset of said operational database products, said second subset of said operational database products corresponding to a set of operational databases coupled to a data warehouse server, to extract, merge, transform and load said specified data from said operational databases into a multidimensional database. - View Dependent Claims (10, 11, 12, 13, 14, 15)
-
-
16. A system for aggregating data from a plurality of operational databases, comprising:
-
a data store storing a collection of pre-defined scripts identifying configuration information for said system, each of said scripts corresponding to one of a plurality of operational database products, said scripts including parameters for modifying said configuration information; and a data warehouse server coupled to a set of operational databases corresponding to a first subset of said operational database products, said data warehouse server retrieving a database schema from each of the operational databases in the first subset of operational database products and, if the pre-defined extraction scripts and the database schemas are the same, executing a second subset of said scripts corresponding to said first subset of said operational database products to extract, merge, transform and load data from said operational databases in accordance with said configuration information to generate a multidimensional database. - View Dependent Claims (17, 18, 19, 20, 21, 22, 23, 24, 25)
-
-
26. A method for aggregating data from a plurality of operational databases via a data warehouse server, comprising:
-
providing a collection of pre-defined scripts identifying configuration information for said system, each of said pre-defined scripts corresponding to one of a plurality of operational database products, said scripts including parameters for modifying said configuration information; retrieving a database schema from each of plurality of operational database products; and, if the pre-defined extraction scripts and the database schemas are the same, then executing a first subset of said scripts corresponding to a second subset of said operational database products, said second subset of said operational database products corresponding to a set of operational databases coupled to a data warehouse server, to extract, merge, transform and load data from said operational databases in accordance with said configuration information to generate a multidimensional database. - View Dependent Claims (27, 28, 29, 30)
-
Specification