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 FAQ: Troubleshooting SQL Server Reporting Services Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel. What's new in SQL Server 2008 Reporting Services? New features in SQL Server 2008 Reporting Services mean improved charting and increased memory. Learn more about SSRS performance upgrades in SQL... SQL Server 2008 Integration Services delivers new features SQL Server Integration Services (SSIS) 2008 has three new and exciting features to improve performance. Learn about SSIS 2008 data profiling, data...

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