The ORM Foundation

Get the facts!

pdf Evolution of a Dynamic Multidimensional Denormalization Meta Model using Object-Role Modeling

Downloads: 35 File Size: 693.6kB
Posted By: admin Views: 2,303
Date Added: Tue, Nov 20 2007

Presentation of a paper by Joe Hansen ( and Necito dela Cruz (

Abstract: At Guidant, a Boston Scientific Company, systems that collect data in support of medical device clinical research trials must be capable of collecting large, dynamic sets of attributes that are often reused in later research activities. Their resultant design, based on conceptual analysis using Object-Role modeling (ORM) transforms each unique business fact into an instance in a highly normalized star schema structure with relational dimensions. When it becomes necessary to generate focused denormalized reporting structures from this star schema, hereafter referred to as minature data marts or simply "minimarts", the dynamic nature of these source attributes can present a mantenance challenge. Using ORM, we propose a meta model that supports the definition, creation and population of these denormalized reporting structures sourced from a multidimensional fact table that also leverages a hierarchical taxonomic classification of the subject domain. 

Paper available from: OTM Workshops 2006, LNCS 4278, pp. 1160-1169  Springer-Verlag Berlin Heidelberg   

Filed under: ,


No comments exist for this file.
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service