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 ?
Global Data Warehouse Management Software Major Applications/End users: Factory Warehouse, Logistics Company, Retail Industry, Others
It is important to understand the differences and similarities between data warehouses, data marts, ODSs, and data lakes.
The NVRDW governance group adopted a model described by IBM (Ballard et al., 2014), separating the responsibilities of the entity hosting the data warehouse and the governing entity (board of directors).
The agility of the automated data warehouse is not limited to its ability to change in the warehouse development process, it can also handle changes in business requirements.
Correspondingly, data warehouses are designed to efficiently connect data elements that are generally used together.
The picture below shows the core components of the data warehouse as the central data repository (Figure 3).
In 2010, cost control and performance optimization became critical evaluation criteria and, consequently, the market has begun to accept a higher first cost in exchange for lower administrative and management costs over the life of the data warehouse.
"For instance, if they need 40 percent of prescriptions to be e-prescribed, this group finds out where in the data warehouse to get that information and how much e-prescribing versus printing is done now, so we have the numerator and denominator," Spencer says.
The advanced design of the platform means it excels equally well at workloads that are either central processing unit or I/O intensive, making it one of the most versatile data warehouse platforms in the industry.
According to Ralph Kimball, founder of Kimball University and well known thought leader in the field of data warehousing, "Our Data Warehouse Lifecycle in Depth course is relentlessly practical.
There are very few test cycles, which cover the system-triggered scenarios (Like billing, Valuation.) In data Warehouse, most of the testing is system triggered as per the scripts for ETT, the view refresh scripts etc.
have announced in conjunction with Sun Microsystems and BMMSoft, that Sybase IQ powers the world's largest data warehouse implemented in history, as noted in the independently audited report, "Sun Data Warehouse Reference Architecture for Structured and Unstructured Data," August 2007.

Full browser ?