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 Tips for tuning SQL Server 2005 to improve reporting performance There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific... Parent-child dimensions in SQL Server 2005 with Analysis Services MDX Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using... Troubleshoot Web service issues in SQL Server 2005 Reporting Services Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations.

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