WortmarkeTEDAMOH

Log in

EXASOL

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

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

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

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

  • Dirk Lerner, is a well experienced consultant for Data Vault, Data Architecture and Data Design.  As a pioneer for Data Vault in Germany he published various publications, is an international speaker at conferences and author of this blog. Whatch him live on stage! For more videos have a look at Dirks YouTube Channel!

    You can book Dirk for your conference or event to speak.

    Data Natives conference, October 2016, Berlin

    Data, Data, Metadata - DNA of Data Architecture?


     

    Webinar with EXASOL, July 2016

    In July 2016 Mathias Brink and I had given a webinar how to implement Data Vault on a EXASOL database. Watch the recording of the webinar!

     

     

    TDWI Conference, June 2015, Munich

    Data Design - A love Story

     

     

    Vielen Dank für die sehr interessanten Videos. Sie und Herr Wiener sind wirklich zwei krasse Gegensätze, die sich ganz wunderbar ergänzen!Christian Moewes, BOSCH

     

     

    Data Design - A love Strory (Graphical Recording explained)

     

     

    If you are interested of the Graphical Recording Handout send me a short note and I'll send it to you as soon as possible!

     

2°C

Darmstadt-Dieburg

Mostly Cloudy

Humidity: 87%

Wind: 6.44 km/h

  • 03 Jan 2019 2°C -3°C
  • 04 Jan 2019 3°C 0°C