data warehouse


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Acronyms, Wikipedia.
Related to data warehouse: data mining

data warehouse

[¦dad·ə ′wer‚hau̇s]
(computer science)
A large specialized database, holding perhaps hundreds of terabytes of data.
A database specifically structured for information access and reporting.

data warehouse

(database)
(Or corporate data warehouse, CDW) Any system for storing, retrieving and managing large amounts of data. Data warehouse software often includes sophisticated compression and hashing techniques for fast searches, as well as advanced filtering. A data warehouse is often a relational database containing a recent snapshot of corporate data and optimised for searching. Planners and researchers can use this database without worrying about slowing down day-to-day operations of the production database. The latter can be optimised for transaction processing (inserts and updates).

Compare data mart.

data warehouse

A database designed to support decision making in an organization. Data from the production databases are copied to the data warehouse so that queries can be performed without disturbing the performance or the stability of the production systems.

Data Marts
Data warehouses can become enormous with hundreds of gigabytes of transactions. As a result, subsets, known as "data marts," are often created for just one department or product line.

Updated at the End of a Period
Data warehouses are generally batch updated at the end of the day, week or some period. Its contents are typically historical and static and may also contain numerous summaries.

Operational Data Stores
The data warehouse is structured to support a variety of analyses, including elaborate queries on large amounts of data that can require extensive searching. When databases are set up for queries on daily transactions, they are often called "operational data stores" rather than data warehouses (see ODS). See OLAP, decision support system, EIS and BI software.
References in periodicals archive ?
Companies need to recognize the extent of people and organizational changes that the data warehouse will cause and proactively manage changes," Gohsler said.
Another way companies are using their data warehouses to make money is by tapping into their "Information Exhaust.
The data warehouse is a gold mine in which to find opportunities for clinical quality improvement.
The Norwich Union project is a great example of how data warehouses are increasingly being used to deliver operational applications as well as decision support.
The Netezza Performance Server[R] (NPS[R]) system is the market-leading data warehouse appliance built specifically to analyze terabytes of detailed data 10 to 100 times faster than existing data warehouse options, at half the cost.
Since it was established in 1984, Teradata Professional Services has offered thousands of consulting engagements to businesses, many of whom have been recognized throughout the industry for deploying world-class data warehouses.
The NPS system is the market-leading data warehouse appliance, built specifically to analyze terabytes of detailed data 10 to 100 times faster than existing data warehouse options, at half the cost.
Netezza's pioneering data warehouse appliance approach is uniquely suited to meeting the scalability challenges that companies are facing as their data and query complexity grows," said Ellen Rubin, vice president of marketing, Netezza.
amp; LONDON -- Online seminar to highlight best practices for eliminating the complexity of enterprise data warehouse development and maintenance throughout business change
To help ensure the success of these BI deployments, Business Objects (Nasdaq:BOBJ)(Euronext Paris ISIN code: FR0004026250 -- BOB), the world's leading provider of BI solutions, has partnered with the top enterprise data warehouse solution providers.
Increased Presence of Data Warehouse Appliances in Corporate Data Centers Attributed to Purpose-Built Architecture, Fast Query Performance, Ease of Implementation and Business Value