Updated sample and metadata models for Data Vault generation and virtualisation
After a bit of a pause in working on the weblog and technology (caused by an extended period of high pressure in the day job) I am once again working on some changes in the various concepts I’m writing about on this site. Recently I was made aware of this great little tool that supports easy creation and sharing of simple data models: Quick Database Diagrams (‘QuickDBD’). The tool is 100% online and can be found at https://www.quickdatabasediagrams.com/. Today I have converted the existing sample ERwin models on this new platform. It’s really useful – have a look.
One of the reasons for this effort is that ERwin does not provide a Community Edition anymore (boo!). The only option is a trial which lasts one month and requires re-registration every time. But stepping away from ERwin is really a blessing in disguise, as having a web-version of the models available makes updating and sharing a lot easier too. This allows for some closer collaboration as well with whoever is interested. So it’s all for the best.
I’ve moved the following models to the new QuickDBD platform:
- Sample source system model
- Staging Area sample model
- Persistent Staging Area sample model
- Data Vault sample model
- Presentation Layer (e.g. PITs, Data Marts) sample model
These are the sample models you can use for trying out the Virtual Enterprise Data Warehouse application, I use these for regression testing. The example setup page for the Virtual EDW software has been updated as well to reflect this.