data warehouse

(redirected from Datawarehouse)
Also found in: Medical.

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 ?
The aim of this article has been to suggest basic datawarehouse testing activities as a final part of datawarehouse testing methodology.
Tesco has built on its staggeringly successful datawarehouse backed ClubCard service with 11 stores now participating in the Tesco Direct home shopping alternative.
LEAP" (Launch Execution AND Planning) will streamline functions for life sciences companies and the "Datawarehousing and BI Applications" practice Develops pre-built solutions & platforms for Enterprise Datawarehouse Solutions
Microsoft Albania, introduced the Datawarehouse system with usage examples as well as the Power BI - Reporting & Data visualization platform.
Sybase IQ enhances the performance of customers' existing DataWarehouse without needing to replace it or can be used as the main Data Warehouse engine.
Combining PowerCenter and PowerExchange functionality with the power of Bull's NovaScale and Escala servers is expected to extend data integration, migration and synchronisation and datawarehouse population for organisations.
Mientras que Dimensional Insight es una empresa con mas de 14 anos de experiencia en el desarrollo de soluciones de inteligencia de negocios para ambientes operacionales y Datawarehouse.
Ardent Software Inc, the Westboro, Massachusetts-based data warehousing development tools company, has released two products that enable users to accelerate implementations of PeopleSoft's enterprise performance management datawarehouse and then extract data in the form in which it was stored.
BOSTON -- Sapient Global Markets, part of Sapient (NASDAQ: SAPE), has today announced a new combination of services aimed specifically at helping companies meet requirements for communicating loan-level performance data to the European DataWarehouse under the European Central Bank's (ECB) ABS loan-level initiative.
Contract notice: Technical support for the information system / datawarehouse (uis).
0 or Oracle datawarehouse and a series of 16 web-based analytic applications in one bundle.