System for Aggregating Data and a Method for Providing the Same
AssigneeTrapeze Software Inc.
InventorsMatthew DODDS, Chacko Kattithara PAUL
Life of this patent
Estimating the term…
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.
Claims29
A system for aggregating data from a plurality of operational databases, comprising:
- a data store storing a collection of pre-defined extraction scripts identifying data available for extraction from a plurality of operational database products, said extraction scripts including parameters for specifying which of said data to extract;
- and
- a data warehouse server for executing said extraction scripts to extract, merge, transform and load said specified data from said plurality of operational databases into a multidimensional database.
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 identifying data available for extraction from a plurality of operational database products, said extraction scripts including parameters for specifying which of said data to extract;
- and
- executing a subset of said extraction scripts to extract, merge, transform and load said specified data from said plurality of operational databases into a multidimensional database.
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, said scripts including parameters for modifying said configuration information;
- and
- a data warehouse server for executing said scripts to extract, merge, transform and load data from said operational databases in accordance with said configuration information to generate a multidimensional database.
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, said scripts including parameters for modifying said configuration information;
- and
- executing a subset of said scripts to extract, merge, transform and load data from said operational databases in accordance with said configuration information to generate a multidimensional database.
Dependencies are inferred from the claim text.