Data Warehouse characteristics set forth by Inmon:
Subject Oriented:Suppose you need to focus on your company's sales.So you better learn about company's sales data.Using this warehouse you can figure out "Who was the best customer for this year" or "Which item has been sold mostly this year"..Over all,Data warehouse in this case is defined by the matter of Subject.In this case,it is sales.
Integrated:Data warehouse is built from different source systems.Data should be maintained in a consistent format by eliminating all the discrepancies.Then it can be said as Integrated.
Non-Volatile:Once the data entered to the warehouse cannot be modified.Because that's what here to analyze the purpose.
Time Integrated:Analysts need a huge amount of data to identify the data patterns,business relationships.So it has to focus on change over time.
In general, fast query performance with high data throughput is the key to a successful data warehouse.
Subject Oriented:Suppose you need to focus on your company's sales.So you better learn about company's sales data.Using this warehouse you can figure out "Who was the best customer for this year" or "Which item has been sold mostly this year"..Over all,Data warehouse in this case is defined by the matter of Subject.In this case,it is sales.
Integrated:Data warehouse is built from different source systems.Data should be maintained in a consistent format by eliminating all the discrepancies.Then it can be said as Integrated.
Non-Volatile:Once the data entered to the warehouse cannot be modified.Because that's what here to analyze the purpose.
Time Integrated:Analysts need a huge amount of data to identify the data patterns,business relationships.So it has to focus on change over time.
In general, fast query performance with high data throughput is the key to a successful data warehouse.
No comments:
Post a Comment