首页    期刊浏览 2024年09月21日 星期六
登录注册

文章基本信息

  • 标题:A direct approach to physical Data Vault design
  • 本地全文:下载
  • 作者:Krneta Dragoljub ; Jovanović Vladan ; Marjanović Zoran
  • 期刊名称:Computer Science and Information Systems
  • 印刷版ISSN:1820-0214
  • 电子版ISSN:2406-1018
  • 出版年度:2014
  • 页码:34-34
  • DOI:10.2298/CSIS130523034K
  • 出版社:ComSIS Consortium
  • 摘要:

    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.

  • 关键词:enterprise data warehouse; system of records; design automation; data vault model
国家哲学社会科学文献中心版权所有