Wednesday, April 27, 2016

What is Data Warehouse?

A  data warehouse is a relational database which is used for reporting and data analysis. Data warehouse is a main component of BI.

Data warehouse can be defined under two main concept-

According to Bill Inmon-

A data warehouse is subject-oriented,integrated,time-variant and non-volatile collection of data in support of management's decision-making process.

According to Ralph Kimball-

A data warehouse is a copy of transaction data specifically structured for query and analysis.