SYSTEMS AND METHODS FOR MULTI-SOURCE DATA-WAREHOUSING

摘要

Preferred embodiments of the invention provide systems and methods for improving the speed and efficiency of a data warehouse. The invention enables the loading of data from different data sources into a common data warehouse structure. Preferred embodiments include an ETL process is modified to perform a joined indexing operation which reduces the number of lookup requests required. Further embodiments contemplate a date dimension and hierarchical data structure which improve operation speed.

主权项

1. A data warehousing system for storing data from a plurality of data sources comprising:
a first data source; a second data source; a data transfer system having a first transfer process that transfers data from the first data source and a second transfer process that transfers data from the second data source; and a data storage device connected to the data transfer system, the storage device receiving data from the first data source with the first transfer process and receiving data from the second data source with the second transfer process.