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).

Read more about data warehouse: - SearchCRM.com has information about the use of data warehouses in customer relationship management.

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

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Ensuring high availability of SSAS databases In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on... Building a data warehousing and BI solution In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the... An overview of SQL Server Report Builder 2.0 In this chapter excerpt from "Learning SQL Server 2008 Reporting Services", find out about the interface details and controls available in Report...

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary comma-separated values file  (SearchSQLServer.com) data aggregation  (SearchSQLServer.com)