A+ A A-

How to load easy some data vault test data

  • Geschrieben von Dirk Lerner
  • Zugriffe: 228

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.

High-performance Data Vault

  • Geschrieben von Dirk Lerner
  • Zugriffe: 1979
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.

Soziale Netze

Super Charge y DW

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

DB2 for Linux on S/390

e-Business Intelligence: Leveraging DB2 for Linux on S/390

Im Jahr 2001 hatte ich die große Chance an einem Redbook bei IBM mitzuschreiben. Was für eine tolle Sache! Ich habe nicht lange überlegt, sondern sofort zugestimmt. Das Thema war, die...

Agile DWH

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

Das war eine professionelle Präsentation und der Inhalt war sehr gut! - 2. DDVUG

Cognizant Javid Amerian
Danke für den guten Vortrag beim TDWI zum Thema Data Vault! - TDWI Conference MUC 2014

LAS GmbH Martin Engler

Javier Bardem

"Es posible que el éxito te lleve a sitios a los que no quieres ir. Depende de ti seguir hacia adelante o ser fiel a tus raíces.
Möglicherweise bringt dich der Erfolg dorthin, wo du nicht sein willst. Es hängt von dir ab, ob du weitergehst oder deinen Wurzeln treu bleibst."
- Javier Bardem (*1969), spanischer Schauspieler -

Integrated DH

The Integrated Data Hub, The Next Generation Data Warehouse: The Smartest Way To Deal With The Data Integration Challenges

Meine Tweets

DV_Modeling @srobijns Wow, have fun!
06:09PM May 25
DV_Modeling @RonaldDamhof I'll do :-)
05:06PM May 25
DV_Modeling @RonaldDamhof sigh, another cliffhanger... Ronald, we need a long session housekeeping cliffhangers
04:19PM May 25
DV_Modeling Greetings to all at the #WWDVC at Vermont! Guys have fun and tweet! I'll follow the Tweettimeline! // @dlinstedt
01:16PM May 25

Hans Hultgren

This book is a great addition to the IP for the new age of data warehousing and information management.

Sign In or Create Account