Definition

data warehouse

This definition is part of our Essential Guide: Cloud data warehouse guide: Using Redshift, rival platforms

A data warehouse is a federated repository for all the data that an enterprise's various business systems collect. The repository may be physical or logical.

Data warehousing emphasizes the capture of data from diverse sources for useful analysis and access, but does not generally start from the point-of-view of the end user who may need access to specialized, sometimes local databases. The latter idea is known as the data mart.

There are two approaches to data warehousing, top down and bottom up. The top down approach spins off data marts for specific groups of users after the complete data warehouse has been created. The bottom up approach builds the data marts first and then combines them into a single, all-encompassing data warehouse.

Typically, a data warehouse is housed on an enterprise mainframe server or increasingly, in the cloud. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted for use by analytical applications and user queries.

The term data warehouse was coined by William H. Inmon, who is known as the Father of Data Warehousing. Inmon described a data warehouse as being a subject-oriented, integrated, time-variant and nonvolatile collection of data that supports management's decision-making process.

This was last updated in February 2015

Continue Reading About data warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Join the conversation

4 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Hello, I am a BCA graduate, I am planning to do Data Warehouse course. Now my queation is I am eligible for this course or I should do PG. If PG needed mean MCA, MBA or MBA IT. Pls sugest me. Thanks, Barani
Cancel
(Data Warehousing) is type of relational data base system specially designed for query analysis processing rather than transactional processing.
1. The DWH systems are also called as Historical Db’s, Read only Db’s, Integrated Db’s, Decision Supporting System, Executive info System, Business Info System. if someone need more help visit to https://www.ziuby.com/Data-Warehouse#bdautofocus

Ziuby
Thanks & Regards.
Cancel
How does it benefit organizations?

Cancel
If we are asked to provide data to a data warehouse for a specified customer, what is our legal obligation, if any, in protecting that data and its uses?
Cancel

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close