Skip to main content
Article
Direct Physical Data Vault Design
ComSys
  • Dragoljub Krneta, Lanaco Information Technologies
  • Vladan Jovanovic, Georgia Southern University
  • Zoran Marjanović, Faculty of Organizational Sciences
Document Type
Article
Publication Date
6-1-2014
DOI
10.2298/CSIS130523034K
Disciplines
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.
Citation Information
Dragoljub Krneta, Vladan Jovanovic and Zoran Marjanović. "Direct Physical Data Vault Design" ComSys Vol. 11 Iss. 2 (2014)
Available at: http://works.bepress.com/vladan-jovanovic/3/