Geodesic
A Direct Approach to Physical Data Vault Design
Computer Science and Information Systems, Tome 11 (2014) no. 2.

Voir la notice de l'article provenant de la source Computer Science and Information Systems website

The paper presents a novel agile approach to large scale design of enterprise data warehouses based on a Data Vault model. An original, simple and direct algorithm is defined for the incremental design of physical Data Vault type enterprise data warehouses, using source data meta-model and rules, and used in developing a prototype case tool for Data Vault design. This approach solves primary requirements for a system of record, that is, preservation of all source information, and fully addresses flexibility and scalability expectations. Our approach benefits from Data Vault dependencies minimizations and rapid loads opportunities enabling greatly simplified ETL transformations in a way not possible with traditional (i.e. non data vault based) data warehouse designs. The approach is illustrated using a realistic example from the healthcare domain.
Keywords: Enterprise data warehouse, system of records, design automation, Data Vault model 
@article{CSIS_2014_11_2_a8,
     author = {Dragoljub Krneta and Vladan Jovanovi\'c and Zoran Marjanovi\'c},
     title = {A {Direct} {Approach} to {Physical} {Data} {Vault} {Design}},
     journal = {Computer Science and Information Systems},
     publisher = {mathdoc},
     volume = {11},
     number = {2},
     year = {2014},
     url = {http://geodesic.mathdoc.fr/item/CSIS_2014_11_2_a8/}
}
TY  - JOUR
AU  - Dragoljub Krneta
AU  - Vladan Jovanović
AU  - Zoran Marjanović
TI  - A Direct Approach to Physical Data Vault Design
JO  - Computer Science and Information Systems
PY  - 2014
VL  - 11
IS  - 2
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/CSIS_2014_11_2_a8/
ID  - CSIS_2014_11_2_a8
ER  - 
%0 Journal Article
%A Dragoljub Krneta
%A Vladan Jovanović
%A Zoran Marjanović
%T A Direct Approach to Physical Data Vault Design
%J Computer Science and Information Systems
%D 2014
%V 11
%N 2
%I mathdoc
%U http://geodesic.mathdoc.fr/item/CSIS_2014_11_2_a8/
%F CSIS_2014_11_2_a8
Dragoljub Krneta; Vladan Jovanović; Zoran Marjanović. A Direct Approach to Physical Data Vault Design. Computer Science and Information Systems, Tome 11 (2014) no. 2. http://geodesic.mathdoc.fr/item/CSIS_2014_11_2_a8/