High-performance and agile data vault modeling with EXASOL that gets you results – fast!
Data vault modeling is designed to support enterprise data warehouses for the long-term historical storage of data that flows in from multiple operational systems.
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 complex SQL statements to be created and run. Why? 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 filled with data using complex ETL statements. But designing, optimizing and managing all of these data marts takes too much time. Also, such a workaround goes against what data vault modeling should give you: 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 embodies agility and flexibility.
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 intact. 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.
Webinar recording: Data vault modeling with EXASOL
Learn the concepts of data vault modeling and how data vault modeling enables agile development cycles and see a demo that will transform TPC-H benchmark results into a data vault model.