Integrating Real-Time Messages with Data Vault 2.0

In our ongoing series, our CEO Michael Olschimke discusses a question from the audience:

"How to build efficient DV model for data that are some kind of events? We have huge application that is made of “independent” modules and each module generates logs/events that are specific for this module. On the top of each module events there is layer with some common event data.

Currently our input consists of 3 data sets described below (with the outlook for the next data sets from other modules to be loaded):

1.Data set (“EVENTS”) with common event information, including EVENT_ID
2. Data set (“MOBILE_INFO”) with detailed information about mobile device that triggered EVENT
3. Data set (“INV_WALLET”) with the information about customer investments that is populated on the different level of granularity (many rows for single EVENT).

We expect millions of rows in “EVENTS” data set every day."

Michael talks about Real-Time Messages.

Join the next live session: https://sfr.ee/friday
Ask questions via https://sfr.ee/dvfriday

Learn about Scalefree:
https://www.scalefree.com
Learn about Data Vault:
https://scalefree.com/blog
LinkedIn:
https://sfr.ee/vdviLh
Twitter:
  / scalefreecom  
Call us: +49 (511) 879 89342

#DataModeling #DVModel #EventDriven #HugeApplication #IndependentModules #LogEvents #CommonEventData #MobileDeviceInfo #CustomerInvestments #Granularity #MillionsOfRows #Efficiency #DataVault #Scalefree #DataWarehousing #DWH #EDW #BusinessIntelligence #BI #Data