Modeling slowly changing dimensions in ORM

Authors:
Ron McFadyen
Affiliations:
Department of Mechanical and Manufacturing Engineering, University of Manitoba, Winnipeg, MB, Canada
Venue:
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Year:
2011

Citing 14
Cited 0

Building the data warehouse

Building the data warehouse
Data warehouse design solutions

Data warehouse design solutions
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
YAM2: a multidimensional conceptual model extending UML

Information Systems
SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
A conceptual model for multidimensional data

APCCM '08 Proceedings of the fifth Asia-Pacific conference on Conceptual Modelling - Volume 79
Information Modeling and Relational Databases

Information Modeling and Relational Databases
Temporal Modeling and ORM

OTM '08 Proceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS
Formal Semantics of Dynamic Rules in ORM

OTM '08 Proceedings of the OTM Confederated International Workshops and Posters on On the Move to Meaningful Internet Systems: 2008 Workshops: ADI, AWeSoMe, COMBEK, EI2N, IWSSA, MONET, OnToContent + QSI, ORM, PerSys, RDDS, SEMELS, and SWWS
Reduction Transformations in ORM

OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I
Using object role modeling for effective in-house decision support systems

OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems
Using ORM-Based models as a foundation for a data quality firewall in an advanced generation data warehouse

OTM'06 Proceedings of the 2006 international conference on On the Move to Meaningful Internet Systems: AWeSOMe, CAMS, COMINF, IS, KSinBIT, MIOS-CIAO, MONET - Volume Part II
Evolution of a dynamic multidimensional denormalization meta model using object role modeling

OTM'06 Proceedings of the 2006 international conference on On the Move to Meaningful Internet Systems: AWeSOMe, CAMS, COMINF, IS, KSinBIT, MIOS-CIAO, MONET - Volume Part II
Modeling dynamic rules in ORM

OTM'06 Proceedings of the 2006 international conference on On the Move to Meaningful Internet Systems: AWeSOMe, CAMS, COMINF, IS, KSinBIT, MIOS-CIAO, MONET - Volume Part II

Quantified Score

Hi-index	0.00

Visualization

Abstract

A data warehouse is a subject oriented, integrated, non-volatile, and time variant collection of data in support of management's decisions. Dimensional modeling is a design technique used extensively in the design and construction of data warehouses. To account for different requirements there are several standard variations designers may utilize in their dimensional designs such as outriggers, bridge tables, mini-dimensions, slowly changing dimension techniques, etc. Our focus in this paper is on the representation of the dimensional schema as an ORM schema where slowly changing dimension techniques Types 1 and 2 are used. We examine the nature of the ORM schema - its objects, roles, constraints, rules and transactions.