data warehouse

Typically, a data warehouse is housed on an enterprise mainframe server. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted and organized on the data warehouse database for use by analytical applications and user queries. Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access, but does not generally start from the point-of-view of the end user or knowledge worker who may need access to specialized, sometimes local databases. The latter idea is known as the data mart.

Applications of data warehouses include data mining, Web mining, and decision support systems (DSS).

Learn more about SQL Server Business Intelligence (BI) and Data Warehousing

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

FILE EXTENSION AND FILE FORMAT LIST File Extension and File Format List: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

RELATED CONTENT Planning a Data Warehouse Few publications on the data warehouse deal with the substance of the planning process. They almost make it seem like you can pick a subject area,... Data warehouse administration: TCO 'rules of thumb' The cost of a data warehouse varies based on the DBMS selected. This white paper examines the administration costs of implementing and supporting a... Calculating ROI for business intelligence projects Sponsoring a business intelligence project? You'll want to have a look at this white paper, offering a complete outline of the process needed to...

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary data mining  (SearchSQLServer.com) Data mining is the analysis of data for relationships that have not previously been discovered. For example, the sales records for a particular brand... data preprocessing  (SearchSQLServer.com)