data warehouse

(redirected from Datawarehousing)
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.
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

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.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
It can also be used in the home office for data backup, secondary storage and in various business applications including video conference recording, datawarehousing and medical imaging.
"Sybase has made significant achievements in the datawarehousing space last year thanks to Sybase IQ and the momentum seems to be going stronger and stronger every year," said Hisham Malak, Channel & Marketing Manager, Sybase Products Middle East.
Coda -Intelligence provides users with a low cost route to CPM and datawarehousing. The solution enables organisations to monitor, analyse and report on performance at every level of a business.
Ardent Software Inc, the Westboro, Massachusetts-based datawarehousing development tools company, yesterday launched a new software package which it claims will enable users to extract SAP R/3 data and integrate it more easily with data from other sources.
Despite disappointing overall second quarter results with a net loss of $7.6m (CI No 3,712), Ardent recorded datawarehousing revenue up 357% on the previous year to $16m and Boehm says he's expecting revenue for the sector to increase by a factor of three or four again this year.
It was also revealed that both types of company have not installed the technologies necessary to run a successful CRM project, such as e-commerce capabilities, interactive web sites or datawarehousing, and are instead reliant on field sales forces, sales points, call centres and the Internet as their major channels of interaction.
Application development services - its Build segment - focuses on customer relationship management, datawarehousing, custom development and web-based technology.
USWeb/CKS is also seeking to enter the lucrative customer relationship management market with a practice that builds and integrates datawarehousing applications through to sales force automation and bill payment systems.
Guinness will use Acta's datawarehousing, purchased at an undisclosed price, to gain a global perspective on its assets and supply chain.