Dataware Housing Concept

Subject Oriented-

A data-ware house is a provide information about particular subject(area) of organization. like sales,marketing etc.

Integrated-

A dataware house integrate data from different heterogeneous sources. They should not have naming conflict and difference between value of measure.

Non-Volatile-

Non-volatile means, data should not be removed over the time. because data is used for analysis purpose.

Time Variant-

Data in dataware house changes with time. It store more data as time passes.

How to design a Data Warehouse?

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.