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 Change data capture in SQL Server 2008 improves BI reporting accuracy Improve BI reporting accuracy with SQL Server 2008 change data capture (CDC). Learn how this new BI feature provides near real-time data to your data... Manage traces in SQL Server 2005 Analysis Services with XMLA commands SQL Profiler monitors SQL Server 2005 Analysis Services. But if you must manage numerous instances of MSAS, use XMLA automated trace with create and... Tutorial: SQL Server 2005 Analysis Services Want to learn about Analysis Services 2005 in SQL Server? These tips outline helpful features and give examples of this BI tool's functionality.

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