data warehouse

(redirected from Data warehouses)
Also found in: Medical, Wikipedia.

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 ?
As a method to improve the sharing and storing of client information in data warehouses, data mining is now beginning to make advances into these systems.
Netezza is the market-leading provider of enterprise-class data warehouse appliances that deliver breakthrough performance and ease-of-use at a fraction of the cost of traditional data warehouses.
Physicians are just beginning to learn that insurers have been building data warehouses of claims data for years and are now using those databases to determine which physicians and provider organizations to contract with in new, more "selective" preferred provider networks.
As a result, many data warehouses fail to address the key tenets of data warehousing and are simply unable to consistently meet the needs of business users.
NCR's Teradata[R] data warehouses, ATMs, retail systems, self-service solutions and IT services provide Relationship Technology[TM] that maximizes the value of customer interactions and helps organizations create a stronger competitive position.
The new release includes an enhanced user interface with an Office 2007 look and feel, providing users with a familiar interface for developing data warehouses.
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.
Teradata has at least a two-year lead over its competitors because we are on a relentless path to improve data warehouse performance for our customers," said Randy Lea, vice president, Teradata product and services marketing.
amp; LONDON -- Online seminar to highlight best practices for eliminating the complexity of enterprise data warehouse development and maintenance throughout business change

Full browser ?