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 ?
BusinessObjects XI fully supports the Netezza Performance Server(R) data warehouse appliance to deliver a BI solution with the high performance and ease of use required by enterprise customers.
The Netezza Performance Server system is the market-leading data warehouse appliance, built specifically to analyze terabytes of detailed data 10 to 50 times faster than existing data warehouse options, at half the cost.
DATAllegro C25e - high-capacity data warehouse appliance with encryption technology, 25 TB capacity and table scanning at 1/2 TB per minute ($900,000)
Typically, data warehouses have only been utilized by employees for simple query functions.
Until a health care organization invests in a data warehouse for integration of clinical, financial, and outcomes data, claims of commitment to quality improvement made by administration ought not to be taken seriously.
Working in tandem with Norwich Union, Teradata Professional Services provided the design and helped to implement the data warehouse and the disaster recovery solution.
The networking events also gave me and my team an opportunity to hear first-hand how our peers are using the Netezza data warehouse appliance to achieve tangible business success.
WhereScape RED also features support for Snowflake Schema, a data warehouse model that eliminates data redundancy by grouping dimension data into multiple tables instead of one large table.
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.
Because we look at the capability, integration of all data warehouse technology and their business processes, Teradata has discovered consistent issues that retard the profitability of companies.
Netezza today announced that it has been recognized by industry analyst firm IDC as the data warehouse appliance market leader in a new report titled, "Business Analytics Appliances are Here to Stay.