High performance and agile Data Vault Modeling with EXASOL that gets you results – fast!

Data Vault Modeling is a modern approach adopted by organizations that want to design enterprise data warehouses for the long-term historical storage of data which flows in from multiple operational systems.

For them, this approach has many advantages:
    • Historical query results can be audited fast and reproduced with ease
    • Full data sets can be loaded extremely fast into the data warehouse
    • Short development cycles are now possible due to the data model’s extensibility

      Why Data Vault Modeling on typical databases doesn’t work

      Analyzing data directly on a Data Vault-modeled data warehouse inherently causes very complex SQL statements to be created and run. The reason for this is because data is distributed across many database tables. So, when you’re using a standard relational database, this inevitably leads to poor performance levels.

      To get around performance issues, a typical approach is to build data stores that are filled with data using complex ETL statements. But designing, optimizing and managing all of these data marts takes just too much time. Furthermore, such a workaround solution goes against what a Data Vault Modeling technique should give you, which is agility and flexibility.

      The solution: High Performance Data Vault with EXASOL

      But it doesn't need to be that way. Using EXASOL, your Data Vault Modeling will become much more agile and flexible than ever before.

      Simply define a logical view layer on top of your Data Vault data model which allows users to execute queries using a classic 3NF/star schema. Through intelligent optimization processes, queries on this view layer will run more efficiently based on the Data Vault model.

      That way, all the benefits that make up the data modeling with Data Vault remain in tact.  At the same time, the data model remains straightforward and not too complex. The result is a data warehouse that offers maximum performance both when running queries and when in the development phase. In addition, the overall complexity of the data warehouse is reduced by using a simple ETL process.

      With EXASOL you can now take advantage of the potential of Data Vault Modeling without sacrificing the benefits of modeling techniques and finding performance workarounds.

      Want to know more about the Data Vault Modeling approach? If so, get in contact with us today.

      References
      Accarda
      adidas
      ARZ
      Atheon Analytics
      Badoo
      BIScience
      Blue Yonder
      BOKU
      Cacau Show
      CCV
      COOP
      Dataforce
      datamobile
      Digital Alchemy
      Econda
      Fyber
      GfK Entertainment
      Gruner + Jahr
      IMS
      King
      Kreditech
      Medion
      myThings
      Olympus
      RatePAY
      Semikron
      sensalytics
      Sony Music
      Stayfriends
      Turtle Entertainment
      United Internet Dialog
      Voest Alpine
      Webtrekk
      wefi
      Wooga
      Wunderdata
      Xing
      Xplosion
      Zalando