WortmarkeTEDAMOH

Log in
updated 7:36 AM, May 6, 2020 Europe/Berlin
A+ A A-

Data Vault

  • High performance - Data Vault and Exasol

    You may have received an e-mail invitation from EXASOL or from ITGAIN inviting you to our forthcoming webinar, such as this:

    Do you have difficulty incorporating different data sources into your current database? Would you like an agile development environment? Or perhaps you are using Data Vault for data modeling and are facing performance issues?
    If so, then attend our free webinar entitled “Data Vault Modeling with EXASOL: High performance and agile data warehousing.” The 60-minute webinar takes place on July 15 from 10:00 to 11:00 am CEST.
  • High-performance Data Vault

    TPC-H benchmark data model

    Over the last few weeks, Mathias Brink and I have worked hard on the topic of Data Vault on EXASOL.

    Our (simple) question: How does EXASOL perform with Data Vault?

    First, we had to decide what kind of data to run performance tests against in order to get a feeling for the power of this combination. And we decided to use the well-known TPC-H benchmark created by the non-profit organisation TPC.

    Second, we built a (simple) Data Vault model and loaded 500 GB of data into the installed model.  And to be honest, it was not the best model. On top of it we built a virtual TPC-H data model to execute the TPC-H SQLs in order to analyse performance.

  • How to load easy some data vault test data

    Some time ago a customers asked me how to load easy and simple some (test)data into their database XYZ (chose the one of your choice and replace XYZ) to test their new developed Data Vault logistic processes.
    The point was: They don’t want to use all this ETL-tool and IT-processes overhead just to some small test in their own environment. If this this is well done from a data governance perspective? Well, that’s not part of this blogpost. Just do this kind of thingis only in your development environment.

  • Knowledge Base

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

  • Look Back Over TDWI 2016

    Last week in June I was at the TDWI Conference 2016 at Munich. ITGAIN, my employer, had as a platin sponsor a booth to present our products and services!



    In my point of view, it was another great TDWI conference at Munich with a lot of awesome people I could talk with - including an interesting discussion about data architecture with Mark (Madsen) and all the nonsense happening in the Big Data world.

  • Meetup – Data Vault Interest Group

    I reactivated my Meetup Data Vault Interest Group this week. Long time ago I was thinking about a table of fellow regulars to network with other, let’s call them Data Vaulters. It should be a relaxed get-together, no business driven presentation or even worse advertisement for XYZ tool, consulting or any flavor of Data Vault. The feedback of many people was that they want something different to the existing Business Intelligence Meetings. So, here it is!

  • Modeling the Agile Data Warehouse with Data Vault

    Dieses Buch ist ein MUSS für alle, die an Data Vault interessiert sind und auch für alle die sich für Business Intelligence und (Enterprise) Data Warehouse begeistern.
    Es ist aus meiner Sicht toll geschrieben: leicht verständlich und es sind alle Themen rund um Data Vault sehr gut erklärt.

  • Open-Data-Vault-Models

  • Presentations

  • Reflections on Data Natives conference, October 2016

    A conference for the data-driven generation!

    It’s late October 2016, an incredible crowd of young data-driven peeps are on their way to Berlin, looking forward to meet many other peeps with the same attitude at the Data Natives conference: Doing business with data or seeing a huge value in using data for the future. Besides the crowd I was not only impressed by the location but also by the amount of startups at the conference.

    The schedule for two days was full packed with talks and it wasn’t easy to choose between all these interesting topics. So I decided not to give myself too much pressure. Instead I cruised  through the program, and stumbled on some highlights.

  • Reflections on Global Data Summit 17

    This blog post will be a review of the Global Data Summit. But first I would like to lose a few sentences about the Advanced Data Vault & Ensemble Modelling meeting, organized by Hans Hultgren and Remco Broekmann. It is an event that brought together experienced data modelers from all over the world (New Zealand, South Africa, Europe and the USA) around Data Vault, Focal and Ensemble Logical Modeling (ELM). That sounds promising, doesn't it?

    Advanced Data Vault & Ensemble Modelling

    There were two interesting days with many topics around Data Vault and ELM, which were put up for discussion. The idea behind the meeting is to think further, e. g. where to go with Data Vault and ELM and what the participants can contribute from their own experiences. I personally find some of the points discussed very interesting and exciting and should be pursued further. With others I have to go into myself and continue researching. Most likely, I'll go into other blog posts on different topics, such as the discussion about concatenated key, partitioned links or how you can do without satellites on links. I will see.

  • Rüchschau 1. DDVUG

    Am Dienstag, den 24. Juni 2014, war es so weit! Wir haben uns, viele Data Vault Begeisterte, zum ersten Mal in Form einer User Group getroffen!DDVUG Dan Linstedt und das Star Schema Im Zuge der TDWI 2014 Konferenz hatten wir die Möglichkeit uns ebenfalls im MOC in München zu treffen. Danke hier auch an das ganze Team des TDWI.

    Super organisiert durch Christian Hädrich, war sogar Dan Linstedt als Ehrengast eingeladen. Sein Vortrag über die Entstehung von Data Vault war super anzuhören. Dieser soll in Kürze auf You Tube erscheinen. Wir sind gespannt.

  • Rückschau DMZ Europe 2014

    Die Data Modeling Zone Europe 2014 ist zu Ende. Es waren zwei ereignisreiche Tage mit großartigen Sprechern und einem vollen Programm. In vier Tracks referierten namhafte Sprecher wie Dan Linstedt, Ronald Damhof, Martijn Evers, Karen Lopez und Rich van der Lans über Themen der Datenmodellierung, Big Data oder auch Industrie Datenmodelle.

  • Success with bitemporal knowledge

    The first session at Data Modeling Zone Europe 2018 in Düsseldorf, was a session about bitemporal data by Dirk Lerner. The session was and is an extract from his current training Temporal Data in a Fast-Changing World, which is now available as open and private training [Link].

    At work I just started at a new customer and was part of the data warehouse team, who was assigned the task of building the Data Vault Data Warehouse. We were developing the Data Vault generator. At that point we used an end-date for the business time. I remember the complexity for updating the old records and the time for the server it costs to do this. Especially when you want to add rows in between. To load history, for example, from old sources.

    The training is led by Dirk in an interactive way.

  • Super Charge Your Data Warehouse

    Do You Know If Your Data Warehouse Flexible, Scalable, Secure and Will It Stand The Test Of Time And Avoid Being Part Of The Dreaded "Life Cycle"?

    The Data Vault took the Data Warehouse world by storm when it was released in 2001. Some of the world's largest and most complex data warehouse situations understood the value it gave especially with the capabilities of unlimited scaling, flexibility and security.

    Here is what industry leaders say about the Data Vault

    "The Data Vault is the optimal choice for modeling the EDW in the DW 2.0 framework"- Bill Inmon, The Father of Data Warehousing

    "The Data Vault is foundationally strong and an exceptionally scalable architecture" - Stephen Brobst, CTO, Teradata

    "The Data Vault should be considered as a potential standard for RDBMS-based analytic data management by organizations looking to achieve a high degree of flexibility, performance and openness" - Doug Laney, Deloitte Analytics Institute

    "I applaud Dan's contribution to the body of Business Intelligence and Data Warehousing knowledge and recommend this book be read by both data professionals and end users" - Howard Dresner, From the Foreword - Speaker, Author, Leading Research Analyst and Advisor

    You have in your hands the work, experience and testing of 2 decades of building data warehouses. The Data Vault model and methodology has proven itself in hundreds (perhaps thousands) of solutions in Insurance, Crime-Fighting, Defense, Retail, Finance, Banking, Power, Energy, Education, High-Tech and many more.

    Learn the techniques and implement them and learn how to build your Data Warehouse faster than you have ever done before while designing it to grow and scale no matter what you throw at it.

    Ready to "Super Charge Your Data Warehouse"?

    You can buy it here, at Dan Linstedts webpage.

  • TEDAMOH @ #TDWI - Let’s talk

    We, Stephan and myself, are looking forward to welcome you at the TDWI Conference at the MOC Munich from June 24th - 26th, 2019! Meet us at our booth, discuss bitemporal topics, data vault or data modeling at all with us and attend one of Dirk Lerner's lectures:

    • Model-driven decision making [Link], together with André Dörr and Mathias Brink
    • FBI at Bosch - a real journey through the depth of "data water" [Link], together with Marc Wiesner, Director Finance BI Competence Center, Robert Bosch GmbH
    • TEDAMOH Corporate Profile

      TEDAMOH setzt sich zusammen aus dem englischen ThE DAta MOdeling Hub und dem spanischen TE AMOzusammen.

      Das Erstere, die Datenmodellierung, ist im Data Warehousing und Business Intelligence von zentraler Bedeutung. Ohne dies kann ein zeitgemäßes Data Warehouse nicht funktionieren. Daher sind bei TEDAMOH die Datenmodellierung, mit Methoden wie Data Vault oder Fact Oriented Modeling, sowie Datenarchitekturen als zentrale Themen verankert!

      Das Letztere ist der Grund für all das hier: Weil wir es so gerne machen, aus Leidenschaft!

      ...Dirk Lerner, Founder

      TEDAMOH sind Menschen, die mit Spaß und Enthusiasmus gemeinsam im TEDAMOH ThinkTank über Datenmodellierung, temporale Daten oder Datenarchitekturen diskutieren, über Qualität sinnieren, neue Themen (wie das TEDAMOH ExMeX Framework) entwickeln und gerne auch ganz verrückte Sachen fabrizieren.

      In Freundschaft verbunden stehen wir für Aufrichtigkeit, Loyalität und Souveränität. Genauso, wie wir mit unseren Kunden und Partnern umgehen.

       

      TEDAMOH
      The Data Modeling Hub

       

    • The Hans Blog

    • The Integrated Data Hub

      The Smartest Way To Deal With The Data Integration Challenges

      Authored by Dario Mangano
      Edition: 1.0

      Data Warehouse projects fail.

      As an industry we have been battling with this phenomenon for decades. Though we have been getting better over the years, as an industry we still have a long way to go.

      Fortunately some people have found ways to beat the odds. By thinking out of the box, formulating new ideas, and creating new innovative approaches these people have each somehow unlocked the secrets of successful DW programs.