Characteristic
features of Data Warehouse:
1.Subject
Oriented
2.Integrated
3.Nonvolatile
4.Time variant
Subject Oriented:The data
warehouses are designed as a Subject-oriented that are used to analyze the
business by top level management, or middle level management, or for a
individual department in an enterprise.
Integrated:Data
warehouse is an integrated database which contains the business information collected
from various operational data sources.
Time Variant:Data
warehouse is a time variant database which allows you to analyze and compare
the business with respect to various time periods (Year, Quarter, Month, Week,
Day) because which maintains historical data.
Non-Volatile:Data
warehouse is a non-volatile database. That means once the data entered into
data warehouse cannot change. It doesn’t reflect to the changes taken place in
operational database. Hence the data is static.
