Data Model Transformations- Relational to Dimensional
Issues in Information Systems
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.
Jovanovic, Vladan, James Harris.
"Data Model Transformations- Relational to Dimensional."
Issues in Information Systems, 15 (1): 285-291.