Bill Inmon Data warehouse model and Development approach
Bill Inmon is called Father of Data warehouse concepts, he
is the first author to introduce the Data Warehouse, a computer generated data
also can be stored as Data warehouse and use for further analysis and decision
making.
Bill Inmon mainly concentrated to store data as a centralized
repository. Where all different systems data will be stored including history
and Data Access layers can access unique information with history.
Inmon's definition says that Data warehouse is Subject
Oriented, Non- Volatile, Integrated and Time variant collection of Data.
I got opportunity to
work on both the design patterns; I tried to compare what exactly real-time
difference between these two design patterns.
Bill Inmon’s model mainly suits for big industry, large data
cap, like Insurance, Banking, and Finance where huge data collection will be
there, daily basis; Almost 1 to 10 TB data collection daily, now here is a big
question, how to manage this much of big data; Multiple transactions by single
user, lots of history by single users, one user holds multiple accounts, actually
this is a very big challenge for companies to manage the data, coming from
different systems.
Bill Inmon’s model gives robust solution for all challenges,
where you can have master tables or we can call it as a repository tables.
Repository Tables or Master Tables are partially or fully normalized (depends of requirements), holding the subject oriented master data; a
Unique record with history, so you can easily and exactly track latest updates
and previous transactions.
Once we have all Master tables as a Repository, The Subject
Oriented data Marts will be created from master data with reports specific Lookup
tables. Which we can directly use for Reports, Data Visualization, data mining,
Analytics, Predictive reporting.
All this is called Business Intelligent, It helps for decision making to the higher
management.
Please leave your comments, suggestions
Thank you!
No comments:
Post a Comment