Log in
updated 7:50 AM, Jun 26, 2020 Europe/Berlin
A+ A A-


Global Data Summit

I am very pleased to be speaking at the Global Data Summit in Golden, Colorodo this year. I am talking about one of my favorite topics: Temporal data in the data warehouse, especially in connection with data vault and dimensional modeling. The title is:

Bitemporal modeling for the Agile Data Warehouse

The talk is a 5x5 presentation, that is 5 slides in 5 minutes. Afterwards, the participants have the opportunity to discuss the topic intensively with me in a 90-minute whiteboard session.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 2163

Fact-Oriented Modeling (FOM) - Family, History and Differences

Months ago I talked to Stephan Volkmann, the student I mentor, about possibilities to write a seminar paper. One suggestion was to write about Information Modeling, namely FCO-IM, ORM2 and NIAM, siblings of the Fact-Orietented Modeling (FOM) family. In my opinion, FOM is the most powerful technique for building conceptual information models, as I wrote in a previous blogpost.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 3506

FastChangeCo - A Fictitious Company

The company FastChangeCo is a fictitious company I developed in 2015 to illustrate problems, challenges and opportunities our customer had in their projects. I used FastChangeCo successfully during my talks, workshops, trainings, coaching and projects.

FastChangeCo is a company founded in the early 20th century. Today, we would say it was a Start Up. The founder, Mr. Fast, had great ideas for building assembly lines which came up in the early 20th century used by Ford and others. During the following decades his company grew to become a big player in the nineties of the last century.
Nowadays, FastChangeCo has thousands of employees and thousands of products in different industries and billions of revenue.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 4394

Data Model Scorecard

Objective review and data quality goals of data models

Did you ever ask yourself which score your data model would achieve? Could you imagine  90%, 95% or even 100% across 10 categories of objective criteria?


Either way, if you answered with “no” or “yes”, recommend using something to test the quality of your data model(s). For years there have been methods to test and ensure quality in software development, like ISTQB, IEEE, RUP, ITIL, COBIT and many more. In data warehouse projects I observed test methods testing everything: loading processes (ETL), data quality, organizational processes, security, …
But data models? Never! But why?

  • Geschrieben von Dirk Lerner
  • Zugriffe: 3921


  • 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
  • Bitemporal Data

    If everything would happen at the same time, there would be no need to store historic data. We, the consumers of data, would know each and everything at the same instant. Beside all the other philosophical impacts, if time wouldn’t exists, is data still necessary?

    (Un)fortunately time exists and data architects, data modelers and developers have to deal with it in the world of information technology.

    In this category about temporal data I will collect all my blogposts about this fancy topic.