Pages

28 February 2016

DWH: What is Data warehouse ?

What is Data warehouse ?
      A Data warehouse is a repositary which stores integrated information for querying and analysis purpose. It has data collected from multiple heterogeneous source system.
According to Bill Inmon who is also known as" Father of Data warehouse", Data warehouse should be :
  • Subject Oriented : It helps in synthesizing data as per the subjects.
  • Time Variant : It stores data over a period of time.
  • Integrated : It integrates data from multiple source system.
  • Non Volatile : Data in Data warehouse is never deleted.