Abstract
This paper proposes extensions to the Object-Role Modeling approach to support schema transformations that eliminate unneeded columns that may arise from standard relational mapping procedures. A “unique where true” variant of the external uniqueness constraint is introduced to allow roles spanned by such constraints to occur in unary fact types. This constraint is exploited to enable graphic portrayal of a new corollary to a schema transformation pattern that occurs in many business domains. An alternative transformation is introduced to optimize the same pattern, and then generalized to cater for more complex cases. The relational mapping algorithm is extended to cater for the new results, with the option of retaining the original patterns for conceptual discussion, with the transforms being applied internally in a preprocessing phase. The procedures are being implemented in NORMA, an open-source tool supporting the ORM 2 version of fact-oriented modeling.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bakema, G., Zwart, J., van der Lek, H.: Fully Communication Oriented Information Modelling, Ten Hagen Stam, The Netherlands (2000)
Batini, C., Ceri, S., Navathe, S.: Conceptual Database Design: an entity-relationship approach, Benjamin/Cummings, Redwood City (1992)
Chen, P.P.: The entity-relationship model—towards a unified view of data. ACM Transactions on Database Systems 1(1), 9–36 (1976)
Curland, M., Halpin, T.: Model Driven Development with NORMA. In: Proc. 40th Int. Conf. on System Sciences (HICSS-40). CD-ROM, p. 10. IEEE Computer Society, Los Alamitos (2007)
De Troyer, O.: On Data Schema Transformations, PhD thesis, University of Tilburg (KUB), Tilburg, The Netherlands (1993)
Halpin, T.: A Logical Analysis of Information Systems: static aspects of the data-oriented perspective, doctoral dissertation, University of Queensland (1989)
Halpin, T., Proper, H.: Database schema transformation and optimization. In: Papazoglou, M.M.P. (ed.) ER 1995 and OOER 1995. LNCS, vol. 1021, pp. 191–203. Springer, Heidelberg (1995)
Halpin, T.: Information Modeling and Relational Databases. Morgan Kaufmann, San Francisco (2001)
Halpin, T.: Business Rule Verbalization, Information Systems Technology and its Applications. In: Doroshenko, A., Halpin, T., Liddle, S., Mayr, H. (eds.) Proc. ISTA-2004, Salt Lake City. Lec. Notes in Informatics, vol. P-48, pp. 39–52 (2004)
Halpin, T.: Constraints on Conceptual Join Paths. In: Krogstie, J., Halpin, T., Siau, K. (eds.) Information Modeling Methods and Methodologies, pp. 258–277. Idea Pub. Hershey (2005)
Halpin, T.: Information Modeling in UML and ORM: a Comparison. In: Encyclopedia of Inf. Science and Tech. vol. 3, pp. 1471–1475. Khosrow-Pour, Idea Pub. Hershey (2005)
Halpin, T.: ORM 2. In: Meersman, R., Tari, Z., Herrero, P. (eds.) On the Move to Meaningful Internet Systems 2005: OTM 2005 Workshops. LNCS, vol. 3762, pp. 676–687. Springer, Heidelberg (2005)
Halpin, T.: Subtyping Revisited. In: Pernici, B., Gulla, J. (eds.) Proc. CAiSE 2007 Workshops, vol. 1, pp. 131–141. Tapir Academic Press (2007)
Halpin, T.: Fact-Oriented Modeling: Past, Present and Future. In: Krogstie, J., Opdahl, A., Brinkkemper, S. (eds.) Conceptual Modelling in Inf. Sys. Eng. pp. 19–38. Springer, Heidelberg (2007)
ter Hofstede, A.H.M.: Information Modelling in Data Intensive Domains, PhD thesis, University of Nijmegen (1993)
ter Hofstede, A.H.M., Proper, H.A., van der Weide, T.P: Formal definition of a conceptual language for the description and manipulation of information models. Information Systems 18(7), 489–523 (1993)
Object Management Group, UML 2.0 Superstructure Specification (2003) Online at, http://www.omg.org/uml
Wintraecken, J.: The NIAM Information Analysis Method: Theory and Practice, Kluwer, Deventer, The Netherlands (1990)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Halpin, T., Carver, A., Owen, K.M. (2007). Reduction Transformations in ORM. In: Meersman, R., Tari, Z., Herrero, P. (eds) On the Move to Meaningful Internet Systems 2007: OTM 2007 Workshops. OTM 2007. Lecture Notes in Computer Science, vol 4805. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-76888-3_92
Download citation
DOI: https://doi.org/10.1007/978-3-540-76888-3_92
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-76887-6
Online ISBN: 978-3-540-76888-3
eBook Packages: Computer ScienceComputer Science (R0)