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 How to process SQL Server 2005 Analysis Services for data availability SQL Server 2005 Analysis Services offers data availability options for processing cube partitions. Learn how to decrease SQL memory, CPU and disk use... Export SQL Server data to an Excel file using SSIS and Visual Studio Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to... Five steps to event handlers in SQL Server Integration Services (SSIS) Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event...

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