Science Fair Project Encyclopedia
A data warehouse is a data store (database) which is built out of separate internal and/or external data sources where the data is integrated in a consistent manner.
The data is typically a record of an enterprise's past transactional and operational activities.
Periodically, one imports data from enterprise resource planning (ERP) systems and other related business software systems into the data warehouse for further processing. It is common practice to "stage" data prior to merging it into a data warehouse. In this sense, to "stage data" means to queue it for preprocessing, usually with an ETL tool. The preprocessing program reads the staged data (often a business's primary OLTP databases), performs qualitative preprocessing or filtering (including denormalization, if deemed necessary), and writes it into the warehouse.
Online analytical processing (OLAP) is a mode of computational analysis often used in data warehouses; conversely, online transaction processing (OLTP) is more suitable for current, normal business operations.
- Data mining
- Data mart
- Document warehouse
- Executive information system
- Information technology
- Business intelligence
- Business performance management
- Extract, transform, load
- SearchCRM.com Original daily breaking news, white papers, expert advice, webcasts, product reviews and more on data warehousing.
- Data Warehouse Information and Tools
- Directory of Data Warehouse, Data Mart, Data Mining, and Decision Support Resources
- searchDatabase.com "The term was coined by W. H. Inmon. IBM sometimes uses the term 'information warehouse.'"
- Data.com "Online version of the magazine: networking products and services."
The contents of this article is licensed from www.wikipedia.org under the GNU Free Documentation License. Click here to see the transparent copy and copyright details