Wednesday, May 25, 2016

Dataware Housing Concept

Data warehousing concept is a process of collecting, organizing, and managing data from different data sources to create and provide useful business insights. 

The main features of a data warehouse are as below:

  • Subject Oriented- A data-ware house provides information about subject (area) of organization. like sales, marketing etc.
  • Integrated- A data warehouse integrates data from different heterogeneous sources. They should not have naming conflicts and differences between values of measures.
  • Non-Volatile- Non-volatile means, data should not be removed over the time. because data is used for analysis purpose.
  • Time Variant- Data in data warehouse changes with time. It stores more data as time passes.

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.