WortmarkeTEDAMOH

Log in

Follow Up Data Vault EXASOL Webinar

In July 2016 Mathias Brink and I had given a webinar how to implement Data Vault on a EXASOL database. Read more about in my previous blogpost or watch the recording on Youtube.

Afterward I became a lot of questions per our webinar. I’ll now answer all questions I got till today. If you have further more questions feel free to ask via my contact page,via Twitter, or write a comment right here.

  • Geschrieben von Dirk Lerner
  • Zugriffe: 5766
FCO-IM Example

FCO-IM at TDWI Roundtable

FCO-IM - Data Modeling by Example

Do You want to visit a presentation about Fully Communication Oriented Information Modeling (FCO-IM) in Frankfurt?
I’m very proud that we, the board of the TDWI Roundtable FFM, could win Marco Wobben to speak about FCO-IM. In my opinion, it’s one of the most powerful technique for building conceptual information models. And the best is, that such models can be automatically transformed into ERM, UML, Relational or Dimensional models and much more. So we can gain more wisdom in data modeling at all.

But, what is information modeling? Information modeling is making a model of the language used to communicate about some specific domain of business in a more or less fixed way. This involved not only the words used but also typical phrases and patterns that combine these words into meaningful standard statements about the domain [3].

  • Geschrieben von Dirk Lerner
  • Zugriffe: 4180
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: 2105

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: 2171

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: 10722
  • 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.

  • Data Modeling Tools
  • Data Modeling Certification