Skip to main content
SpringerLink
Log in
Book cover

OTM Confederated International Conferences "On the Move to Meaningful Internet Systems"

OTM 2011: On the Move to Meaningful Internet Systems: OTM 2011 Workshops pp 298–308Cite as

Modeling Slowly Changing Dimensions in ORM

  • Conference paper

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 7046))

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Inmon, W.: Building the data warehouse. QED Technical Pub. Group (1992)

    Google Scholar 

  2. Kimball, R., Ross, M., Becker, B., Mundy, J., Thornthwaite, W.: The Kimball Group Reader. John Wiley & Sons (2010)

    Google Scholar 

  3. Halpin, T., Morgan, T.: Information Modeling and Relational Databases. Morgan Kaufmann Publishers (2008)

    Google Scholar 

  4. Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The data warehouse lifecycle toolkit. John Wiley & Sons (1998)

    Google Scholar 

  5. Adamson, C., Venerable, M.: Data warehouse design solutions. John Wiley & Sons (1998)

    Google Scholar 

  6. Mundy, J., Thornthwaite, W., Kimball, R.: The Microsoft data warehouse toolkit. John Wiley & Sons (2006)

    Google Scholar 

  7. Song, I.Y., Khare, R., Dai, B.: SAMSTAR: a semi-automated lexical method for generating star schemas from an entity-relationship diagram. In: Proceedings DOLAP 2007. ACM, New York (2007)

    Google Scholar 

  8. Abello, A., Samos, J., Saltor, F.: Yam2: A multidimensional conceptual model extending UML. Information Systems 31(6), 541–567 (2006)

    Article  Google Scholar 

  9. Kamble, A.: A Conceptual Model for Multidimensional Data. In: Asia-Pacific Conference on Conceptual Modelling - APCCM, pp. 29–38 (2008)

    Google Scholar 

  10. Moody, D., Kortink, M.: From ER models to dimensional models: bridging the gap between OLTP and OLAP design. Business Intelligence Journal 8(3) (2003)

    Google Scholar 

  11. Moody, D., Kortink, M.: From ER Models to Dimensional Models II: Advanced Design Issues. Business Intelligence Journal 8(4) (2003)

    Google Scholar 

  12. Payne, R.: MORM: a fact-oriented conceptual modeling approach to designing data warehouses and OLAP applications. MSc Thesis, University of British Columbia (2003), https://circle.ubc.ca/handle/2429/15349

  13. Piprani, B.: Using ORM-Based Models as a Foundation for a Data Quality Firewall in an Advanced Generation Data Warehouse. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2006 Workshops. LNCS, vol. 4278, pp. 1148–1159. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  14. Pierson, E.J., dela Cruz, N.: Using Object Role Modeling for Effective In-House Decision Support Systems. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2005. LNCS, vol. 3762, pp. 636–645. Springer, Heidelberg (2005)

    Chapter  Google Scholar 

  15. Hansen, J., dela Cruz, N.: Evolution of a Dynamic Multidimensional Denormalization Meta Model Using Object Role Modeling. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2006 Workshops. LNCS, vol. 4278, pp. 1160–1169. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  16. Halpin, T., Carver, A., Owen, K.: Reduction Transformations in ORM. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2007, Part I. LNCS, vol. 4805, pp. 699–708. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

  17. Halpin, T.: Temporal Modeling and ORM. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2008. LNCS, vol. 5333, pp. 688–698. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  18. de Brock, E.: Transactions in ORM. In: Halpin, T., Krogstie, J., Nurcan, S., Proper, E., Schmidt, R., Soffer, P., Ukor, R. (eds.) Enterprise, Business-Process and Information Systems Modeling. LNBIP, vol. 29, pp. 291–301. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  19. Balsters, H., Carver, A., Halpin, T., Morgan, T.: Modeling Dynamic Rules in ORM. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2006 Workshops. LNCS, vol. 4278, pp. 1201–1210. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  20. Balsters, H., Halpin, T.: Formal Semantics of Dynamic Rules in ORM. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2008. LNCS, vol. 5333, pp. 699–708. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  21. Microsoft Corporation, http://msdn.microsoft.com/en-us/library/ms141715.aspx

  22. Oracle Corporation, http://download.oracle.com/docs/cd/E10926_01/doc/owb.101/b12151/apascd.htm

  23. Embarcadero Technologies, http://docs.embarcadero.com/products/er_studio/erstudio8.0/erstudio802/ERStudioUserGuide.pdf

  24. van Griethuysen, J. (ed.): ISO Technical Report on Concepts and Terminology for the Conceptual Schema and the Information Base. ISO/TR 9007:1987, International Standards Organization, Geneva (1987)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Winnipeg, Winnipeg, Manitoba, Canada

    Ron McFadyen

Authors
  1. Ron McFadyen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. STAR Lab, Vrije Universiteit Brussel (VUB), Bldg G/10, Pleinlaan 2, 1050, Brussel, Belgium

    Robert Meersman

  2. DEBII, Curtin University of Technology, Technology Park, De Laeter Way, 6102, Bentley, WA, Australia

    Tharam Dillon

  3. Facultad de Informática, Universidad Politécnica de Madrid, Campus de Montegancedo S/N, 28660, Boadilla del Monte, Madrid, Spain

    Pilar Herrero

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

McFadyen, R. (2011). Modeling Slowly Changing Dimensions in ORM. In: Meersman, R., Dillon, T., Herrero, P. (eds) On the Move to Meaningful Internet Systems: OTM 2011 Workshops. OTM 2011. Lecture Notes in Computer Science, vol 7046. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25126-9_41

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-25126-9_41

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-25125-2

  • Online ISBN: 978-3-642-25126-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation