Today i was going thourgh the learndatavault.com website to understand more about datavault modelling. It was very interesting and exiciting facts which i have pratically come accross during project implementations.
The major problems involved in maintaining a data warehouse clearly address and give flexibility to organization to maintain the datasets for a longer period of time.
Today Major problems with Datawarehouse's Designs:
1) Flexibility to modify
2) Fast Query processing
3) Maintaining the sanity of the datasets when business rules changes.
4) Processing huge volumes.( Star schemas has problem of summing up & 3 NF has problem of storage due to huge number of tables. Ex: Teradata FSLDM has hundred's of tables .. )
DataVault a simple Hub-Link-Satellite model provides a Genetic helix like structure which can adapt and modify it self for the changing business rules. This is an interesting design paradiagm which i would learn and further write on my blog with my understanding. Keep tuned.
Some reference for your readings: ( Also avaliable on the wiki page ).
http://prudenza.typepad.com/files/damhof_dbm0508_eng-1.pdf
The major problems involved in maintaining a data warehouse clearly address and give flexibility to organization to maintain the datasets for a longer period of time.
Today Major problems with Datawarehouse's Designs:
1) Flexibility to modify
2) Fast Query processing
3) Maintaining the sanity of the datasets when business rules changes.
4) Processing huge volumes.( Star schemas has problem of summing up & 3 NF has problem of storage due to huge number of tables. Ex: Teradata FSLDM has hundred's of tables .. )
DataVault a simple Hub-Link-Satellite model provides a Genetic helix like structure which can adapt and modify it self for the changing business rules. This is an interesting design paradiagm which i would learn and further write on my blog with my understanding. Keep tuned.
Some reference for your readings: ( Also avaliable on the wiki page ).
http://prudenza.typepad.com/files/damhof_dbm0508_eng-1.pdf
- Linstedt, Dan. "Data Vault Series 1 – Data Vault Overview". Data Vault Series. The Data Administration Newsletter. Retrieved 12 September 2011.
- Linstedt, Dan. "Data Vault Series 2 – Data Vault Components". Data Vault Series. The Data Administration Newsletter. Retrieved 12 September 2011.
- Linstedt, Dan. "Data Vault Series 3 – End Dates and Basic Joins". Data Vault Series. The Data Administration Newsletter. Retrieved 12 September 2011.
- Linstedt, Dan. "Data Vault Series 4 – Link Tables". Data Vault Series. The Data Administration Newsletter. Retrieved 12 September 2011.
- Linstedt, Dan. "Data Vault Series 5 – Loading Practices". Data Vault Series. The Data Administration Newsletter. Retrieved 12 September 2011.
- Kunenborg, Ronald. "Data Vault Rules v1.0.8 Cheat Sheet". Data Vault Rules. Grundsätzlich IT. Retrieved 26 September 2012. Cheat sheet reflecting the rules in v1.0.8 and additional clarification from the forums on the rules in v1.0.8.
- Linstedt, Dan. "Data Vault Modeling Specification v1.0.9". Data Vault Forum. Dan Linstedt. Retrieved 26 September 2012.
- Linstedt, Dan. "Data Vault Loading Specification v1.2". Dan Linstedt.com. Dan Linstedt. Retrieved 2014-01-03.
- Linstedt, Dan. "A short intro to #datavault 2.0". Dan Linstedt.com. Dan Linstedt. Retrieved 2014-01-03.
- Linstedt, Dan. "Data Vault 2.0 Being Announced". Dan Linstedt.com. Dan Linstedt. Retrieved 2014-01-03.
data modelling techniques promoted by Data Vault (DV) and Anchor Modelling (AM) approaches by Layman Learning - Data Modelling Training Online – LaymanLearning
ReplyDeleteMOB: +91-741-626-7887 - Website : www.laymanlearning.com || hr@laymanlearning.com ||
Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your site? My blog is in the exact same area of interest as yours and my visitors would truly benefit from some of the information you provide here. Please let me know if this ok with you. Thanks! pandas reset_index
ReplyDelete