What
is Data Warehousing?
-
Data
Warehousing is an OLAP database which stores current data and historical data.
It is a centralized proposed system and a decision making system which is used
by the organization to analyze their business.
-
According
to Inmon,
" A
Data Warehousing is a subject oriented, Integrated, Time Variant, Non Volatile
collection of data in support of management's decision making process ".
-
A
Data Warehousing is a relational database which is designed for Query and
Analysis rather than transaction processing. It usually contains historical
data derived from transaction data, but it can include data from other sources.
It separates
Analysis workload from transaction workload and Organization to consolidate the
data from several sources.
-
A
Data Warehouse is a copy of transaction data specifically structured for
querying and reporting.
No comments:
Post a Comment