Log in


Look Back Over DMZ

I was at the Data Modeling Zone Europe 2016 in Berlin as a speaker. It was the 4th Data Modeling Zone in Europe and in my opinion one of the best per the conference program and the interesting and awesome chats with other speakers and attendees. This year’s venue was the Abion Hotel in Berlin, situated next to the Spreebogen and for this a great environment around the venue.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 388
Discuss a data model

DMZ Europe 2016

This year’s European Data Modeling Zone (DMZ) will take place at the wonderful German capital Berlin and I’m very happy to be again speaker at this great event! This year I’ll speak about how to start with a conceptual model, using a logical model and finally how to model the physical Data Vault. During this session we will do some exercises (no, no push-ups!!) to bring our brains up and running about modeling.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 390

Data Vault on EXASOL - Modeling and Implementation

On July 15, Mathias Brink and I ran a webinar about Data Vault on EXASOL, modeling and implementation. The webinar started with an overview of the concepts of Data Vault Modeling and how Data Vault Modeling enables agile development cycles. Afterwards, we showed a demo that transformed the TPC-H data model into a Data Vault data model and how you can then query the data out of the Data Vault data model. The results were then compared with the original queries of the TPC-H.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 1450

Generating large example data with TPC-H

Several times I had the need for some large data sets to do some Data Vault tests at customer site, writing a blogpost, doing a demo or a webinar and many more. And sometimes I need data to do performance or data usage tests on different databases. Due to my work together with EXASOL I focused on the TPC-H tool DBGen to generate gigabytes of data.

To share my experience with DBGen generating large data sets I wrote this blogpost as a step by step instruction.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 888


  • Data Vault
  • Agile EDW
  • Conferences
  • Trainings
  • Bücher
  • Other
  • TDWI Roundtable

    Blogposts around the TDWI Roundtable Frankfurt.

  • Data Architecture
  • FOM

    Fact-Oriented Modeling (FOM) stands for a family of fact-oriented conceptual modeling methods. FOM facilitates easier communication about the conceptual model between the modeler and the domain expert by verbalization of concrete examples in the language of the domain expert, a design process as a guide for creating the model and the focus on elementary facts. The most popular methods in this family are Cognition Enhanced Natural Language Information Analysis Method (CogNIAM), Second Generation Object Role Modeling (ORM 2) and Fully Communication Oriented Information Modeling (FCO-IM).

  • General Modeling



Mostly Cloudy

Humidity: 59%

Wind: 6.44 km/h

  • 21 Sep 2017 19°C 6°C
  • 22 Sep 2017 19°C 6°C