View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001100CaseTalk ModelerGeneration (SQL, XML, etc)public2016-10-13 10:192021-10-30 11:14
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityfeatureReproducibilityN/A
Status assignedResolutionopen 
Target VersionFuture 
Summary0001100: Support Data Vault Physical Model Generation
DescriptionData Vault (and or Anchor Modeling) should be easily derivable from a fact based model. Some investigation has been presented in the past. Investigate and build such a transformation would benefit the fact based domain ánd the dwh domain from a single model.
TagsNo tags attached.
CaseTalk Edition

Relationships

related to 0003154 resolvedBCP Software Data Vault coloring scheme 
related to 0003189 assignedBCP Software Allow GLR to split UC's 
parent of 0000461 assignedBCP Software Split OTFT into two 
parent of 0000101 closedBCP Software Generate artificial keys for database tables 
Not all the children of this issue are yet resolved or closed.

Activities

BCP Software

BCP Software

2016-10-13 10:22

administrator   ~0000665

Marco Engelbart (HAN) presented a transformation sequence for both DataVault and AnchorModeling based upon FCO-IM, at the DMZ 2015. This presentation could be used as a starting point. More DataVault experts need to join the talk to discuss if further fine tuning needs to be added.
BCP Software

BCP Software

2016-10-28 12:40

administrator   ~0000677

Rob Arntz also did a talk on this subject.
BCP Software

BCP Software

2019-05-17 14:59

administrator   ~0001439

https://nl.wikipedia.org/wiki/Data_Vault
BCP Software

BCP Software

2019-06-28 17:35

administrator   ~0001464

A snapshot of a partial data vault model showing the required storage functions.
datavault.png (814,381 bytes)
BCP Software

BCP Software

2020-10-24 16:20

administrator   ~0001795

Just added a preliminary set of sql views to extract Hubs, Links and Satellites from the IG. Based upon ObjectTypes, FactTypes with UC's, Reducable ObjectTypes etc.

Issue History

Date Modified Username Field Change
2016-10-13 10:19 BCP Software New Issue
2016-10-13 10:19 BCP Software Status new => assigned
2016-10-13 10:19 BCP Software Assigned To => BCP Software
2016-10-13 10:22 BCP Software Note Added: 0000665
2016-10-28 12:40 BCP Software Note Added: 0000677
2019-05-17 14:59 BCP Software Note Added: 0001439
2019-06-28 17:35 BCP Software File Added: datavault.png
2019-06-28 17:35 BCP Software Note Added: 0001464
2019-08-21 10:17 BCP Software Relationship added parent of 0000461
2019-08-21 10:30 BCP Software Relationship added parent of 0000101
2020-10-24 16:20 BCP Software Note Added: 0001795
2021-10-05 14:13 BCP Software Relationship added related to 0003154
2021-10-30 11:14 BCP Software Relationship added related to 0003189