data warehouse

(redirected from Datawarehousing)
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 ?
Global services include staff supplementation, large-scale software package implementation, e-commerce consulting, application maintenance and integration, PeopleSoft maintenance and post-implementation support, and datawarehousing solutions.
Informix is still looking to boost its datawarehousing product portfolio through acquisitions, even though it bought Red Brick Systems last December with that specific aim in mind.
Bharat Mistri, marketing director of the company's UK operation said the acquisition was in keeping with Hummingbird's overall strategy of moving increasingly into the datawarehousing market, a process which began last year with the acquisition of fellow Canadian company, Andyne Computing Ltd (CI No 3,321).
The TPC-D benchmark is a performance metric established by the Transaction Processing Council to demonstrate datawarehousing and decision support capabilities using a suite of business-oriented queries with concurrent updates.
Informatica's PowerMart suite will provide complementary data extraction, transformation and management capabilities within Microsoft's new Active DataWarehousing Framework (Active-DW).
Newtec's unique object-oriented MutiMart(TM) Enterprise Datawarehouse design provides the flexibility to grow and change with organizational needs over time, thus producing a custom Enterprise Datawarehousing Solution.
The Meta Group says that of 1,100 users it surveyed half will spend 10% of their IT budgets on datawarehousing for ERM (enterprise resource management), while nearly 40% plan to make to purchases in future.
Wal-Mart believes Amazon hired Dalzell and others to steal Wal-Mart's datawarehousing technology for use in Drugstore.
a leading provider of e-Business data integration and resiliency solutions, today announced that Datawarehousing.
Informix is now divided into three main divisions, the others being core database technology and datawarehousing.
Through expertise developed at a dedicated Centre of Excellence (CoE), we have successfully created a solution architecture and approach for web mining and datawarehousing," says Vivek Bhasin, general manager, business intelligence solutions of Wipro Technologies.
CURRENT ANALYSIS: "While perhaps not as widely known as some of its competitors, the QueryObject System utilizes its specialized and patent-pending data compression and indexing technology to efficiently and effectively store and distribute large volumes of data," said Mike Schiff, Director of DataWarehousing and Business Intelligence Strategies at Current Analysis.