A Direct Approach to Physical Data Vault Design

Dragoljub Krneta1, Vladan Jovanović2 and Zoran Marjanović3

  1. Lanaco Information Technologies, Knjaza Milosa 15
    78000 Banja Luka, Bosnia and Herzegovina
    dragoljub.krneta@lanaco.com
  2. Georgia Southern University, 1500 IT Drive
    Statesboro, Georgia 30458, USA
    vladan@georgiasouthern.edu
  3. Faculty of Organizational Sciences, Jove Ilica 154
    11000 Belgrade, Serbia
    zoran.marjanovic@fon.rs

Abstract

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.

Key words

Enterprise data warehouse, system of records, design automation, Data Vault model

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS130523034K

Publication information

Volume 11, Issue 2 (June 2014)
Year of Publication: 2014
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Krneta, D., Jovanović, V., Marjanović, Z.: A Direct Approach to Physical Data Vault Design. Computer Science and Information Systems, Vol. 11, No. 2, 569–599. (2014), https://doi.org/10.2298/CSIS130523034K