Abstract
We study, in the context of object/relational mapping tools, the problem of describing mappings between inheritance hierarchies and relational schemas. To this end, we introduce a novel mapping model, called M2ORM2 + HIE, and investigate its mapping capabilities. We first show that M2ORM2 + HIE subsumes three well-know basic representation strategies for mapping a hierarchy to relations. We then show that M2ORM2 + HIE also allows expressing further mappings, e.g., where the three basic strategies are applied independently to different parts of a multi-level hierarchy. We describe the semantics of M2ORM2 + HIE in term of how CRUD (i.e., Create, Read, Update, and Delete) operations on objects (in a hierarchy) can be translated into operations over a corresponding relational database. We also investigate correctness conditions.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Ambler, S.W.: Agile Database Techniques. Wiley Publishing, Chichester (2003)
Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design, an Entity-Relationship Approach. Benjamin-Cummings (1992)
Bernstein, P.A., Halevy, A.Y., Pottinger, R.A.: A vision for the management of complex models. ACM Sigmod Record 29(4), 55–63 (2000)
Booch, G., Rumbaugh, J., Jacobson, I.: The Unified Modeling Language User Guide. Addison-Wesley, Reading (1999)
Cabibbo, L., Porcelli, R.: M2ORM2: A Model for the Transparent Management of Relationally Persistent Objects. In: International Workshop on Database Programming Languages (DBPL), pp. 166–178 (2003)
Cabibbo, L.: Objects Meet Relations: On the Transparent Management of Persistent Objects. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 429–445. Springer, Heidelberg (2004)
Cattell, R.G.G., et al.: The Object Data Standard: ODMG 3.0. Morgan Kaufmann, San Francisco (2000)
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison-Wesley, Reading (2003)
Fowler, M.: Patterns of Enterprise Application Architecture. Addison-Wesley, Reading (2003)
Hibernate, http://www.hibernate.org/
Java Data Objects, http://www.jdocentral.com
Keller, W.: Mapping Objects to Tables: A Pattern Language. In: European Pattern Languages of Programming Conference, EuroPLoP (1997)
Microsoft ObjectSpaces, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/objectspaces.asp
Object Architects. Patterns for Object/Relational Mapping and Access Layers, http://www.objectarchitects.de/ObjectArchitects/orpatterns/
ObJect relational Bridge, http://db.apache.org/ojb/
Oracle AS TopLink, http://otn.oracle.com/products/ias/toplink/
Orenstein, J.A.: Supporting retrievals and updates in an object/relational mapping system. IEEE Bull. on Data Engineering 20(1), 50–54 (1999)
Roman, E.: Mastering Enterprise JavaBeans. Wiley Publishing, Chichester (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Cabibbo, L., Carosi, A. (2005). Managing Inheritance Hierarchies in Object/Relational Mapping Tools. In: Pastor, O., Falcão e Cunha, J. (eds) Advanced Information Systems Engineering. CAiSE 2005. Lecture Notes in Computer Science, vol 3520. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11431855_11
Download citation
DOI: https://doi.org/10.1007/11431855_11
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-26095-0
Online ISBN: 978-3-540-32127-9
eBook Packages: Computer ScienceComputer Science (R0)