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:

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.

 
Roelant Vos

Roelant Vos

You may also like...

1 Response

  1. When I try to access these resources, QuickDBD returns an error stating “login or higher permissions are required” – even when I’m logged in to QuickDBD. Maybe you could host the schema code on, for example, GitHub?

     

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.