Data Model Transformations- Relational to Dimensional

Document Type

Article

Publication Date

2014

Publication Title

Issues in Information Systems

ISSN

1529-7314

Abstract

The paper extends the Conceptual Dimensional Fact Model to support the modeling of data marts by formalizing patterns of graph transformations from a relational data base schema to a data mart schema, and by standardizing all visual representations using the Idef1X standard notation and a single supporting case tool. The proposed modeling and automation approach has the potential to significantly speed up prototyping, improve quality of design documentation, and allow verification by developers and validation by users.

Share

COinS