Basics

3/14/2016

Data Warehouse: Warehouse is the place where you keep all your material, if a person says it is his Warehouse it means it will have all varity of material that he wanted to store for future needs for his purpose of business. In our native language we call it as 'Godown'. Then what is Data Warehouse?

Data Warehouse is Data godown, is a system used for reporting and data analysis. Here data is being collected from different sources(sources like in from employees, users- facebook or google search engine, data from machines like satellites).  It is called central repository of integrated data from one or more disparate sources. As they store current and historical data, they also used for creating analytical reports and analysis.

So Data warehouse is two terms looks like ->  storage(collection) from different source + analysis of that data

https://en.wikipedia.org/wiki/Data_warehouse

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. They store current and historical data and are used for creating analytical reports for knowledge workers throughout the enterprise. 

Examples of reports could range from annual and quarterly comparisons and trends to detailed daily sales analysis.

The data stored in the warehouse is uploaded from the operational systems (such as marketing, sales, etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

http://searchsqlserver.techtarget.com/definition/data-warehouse

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.