data warehouse

(redirected from Datawarehouse)
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 ?
Jose Manuel has always been a key supporter of the ABS Loan-level Initiative and was a driving force behind the European DataWarehouse from its conception.
ACI's Business Intelligence practice develops pre-built solutions & platforms for Enterprise Datawarehouse Solutions, Data Quality, Data Discovery Solutions, Master Data Management (MDM), Data Governance and BI Reporting Solutions that can be customized and integrated with client's systems.
Should the file fail the pre-validation process the tool will provide a report summarizing a sample of the error's encountered thus providing the firm with the ability to correct the errors prior to re-submitting the file to the European DataWarehouse.
PACK, or Extract Packaged Application Connection Kit, ($20,000) builds 'native' connectivity to the datawarehouse that not only pulls data, but pulls it with the security features and information structures and formats that it occupies within the datawarehouse.
Not to mention that they will also need to standardize the data to fit the ECB's asset-specific templates, validate the data content, and create and submit compiled XML files to the European DataWarehouse.
In addition, the human resources management system must be connected to the Datawarehouse BIS and the SCG payroll systems.
European DataWarehouse GmbH (ED) is pleased to announce today the successful completion of a private placement with fifteen key investors, consisting largely of global banks and institutions.
0 or Oracle datawarehouse and a series of 16 web-based analytic applications in one bundle.
BOSTON & LONDON -- The Market Group announced on Tuesday the selection of Sapient Global Markets, part of Sapient (NASDAQ: SAPE), to design and build the European DataWarehouse (ED).
European DataWarehouse (Management) Limited (ED) is pleased to announce today that it has appointed Perella Weinberg Partners to arrange a placement of its shares (the Placement).
The first for SAP R/3 and is claimed to shield datawarehouse developers from the complexity of R/3 source tables.
Enhanced Data Sharing across the Suite - An audience segment built in Adobe Discover or Adobe DataWarehouse can now be shared with SiteCatalyst and reports can be filtered by these segments.