What is a data warehouse? [closed]

Question

I was asked by a customer what the term "data warehouse" really means.

I thought about ETL, details of the data model, differences to NoSQL, Clouds, 'normal' DBMS, MDM (Master Data Management) etc. but wasn't able to describe the term in a few words to him... (In fact I did some talking and left him un-illuminated.)

How can "data warehouse" described in 1-3 (or a bit more) sentences?

Answer 1

For non technical guys the best is to describe it as "Huge ammount of data stored in a specialized computer system. Data is usually related to some specific domain and whole system is designed to be fast and optimized for some special tasks. Data stored in data warehouses are mostly used for analysis or in decision making processes."

Not sure if this is enough:) There is a lot of references to this subject in the Internet but if somebody asked me for a quick definition I would use something similiar to that I wrote above.

Answer 2

From wiki:

A data warehouse is a repository of an organization's electronically stored data, designed to facilitate reporting and analysis 1.

This definition of the data warehouse focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform and load data into the repository, and tools to manage and retrieve metadata.