Abstract
In an object-oriented or object-relational database, an n-ary relationship among objects is normally represented in a relation that is separated from other properties of objects at the logical level. In order to use such a database, the user needs to know the structure of the database, especially what kind of relations and classes there are, how they are organized and related in order to manipulate and query object data. To make the logical level closer to the conceptual level so that the database is easier to use, we propose a novel approach that allows the user to represent n-ary relationships among objects in their class definitions so that the user can directly manipulate and query objects based on the class definitions, rather than explicitly join relations at the logical level. Based on the class definitions, the system can automatically generate the modified class/object relation definitions and the corresponding regular relation definition for the n-ary relationship at the physical level to reduce redundancy and convert data manipulation and query statements based at the logical level to ones at the physical level.
This work is supported by the National Natural Science Foundation of China under Grant No. 61202100 and China Scholarship Council under Grant No. [2013]3018.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Stonebraker, M., Moore, D., Brown, P. (eds.): Object Relational DBMSs: The Next Great Wave, 2nd edn. Morgan Kaufmann (1998)
Silberschatz, A., Korth, H.F., Sudarshan, S. (eds.): Database System Concepts, 6th edn. McGraw-Hill (2011)
Cattell, R., Barry, D., Berler, M., Eastman, J., Jordan, D., Russel, C., Schadow, O., Stanienda, T., Velez, F. (eds.): The Object Database Standard: ODMG 3.0. Morgan Kaufmann, Los Altos (2000)
Chen, P.P.: The entity-relationship model - toward a unified view of data. ACM Transaction On Database Systems (TODS) 1(1), 9–36 (1976)
Elmasri, R., Weeldreyer, J.A., Hevner, A.R.: The category concept: An extension to the entity-relationship model. Data & Knowledge Engineering 1(1), 75–116 (1985)
Halpin, T.A.: Comparing metamodels for er, orm and uml data models. In: Advanced Topics in Database Research, vol. 3, pp. 23–44 (2004)
Génova, G., Lloréns, J., Martínez, P.: The meaning of multiplicity of n-ary associations in uml. Software and System Modeling 1(2), 86–97 (2002)
Kim, W., Ballou, N., Chou, H.T., Garza, J.F., Woelk, D.: Features of the orion object-oriented database system. In: Object-Oriented Concepts, Databases, and Applications, pp. 251–282 (1989)
Dahchour, M., Pirotte, A.: The semantics of reifying n-ary relationships as classes. In: ICEIS, pp. 580–586 (2002)
Benchikha, F., Boufaïda, M., Seinturier, L.: Viewpoints: A framework for object oriented database modelling and distribution. Data Science Journal 4, 92–107 (2005)
Camps, R.: From ternary relationship to relational tables: A case against common beliefs. SIGMOD Record 31(2), 46–49 (2002)
Cuadra, D., Iglesias, A., Castro, E., Fernández, P.M.: Educational experiences detecting, using, and representing ternary relationships in database design. IEEE Transactions on Education 53(3), 358–364 (2010)
Liu, M., Hu, J.: Information networking model. In: Laender, A.H.F., Castano, S., Dayal, U., Casati, F., de Oliveira, J.P.M. (eds.) ER 2009. LNCS, vol. 5829, pp. 131–144. Springer, Heidelberg (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Hu, J., Chen, L., Qiu, S., Liu, M. (2014). A New Approach for N-ary Relationships in Object Databases. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds) Conceptual Modeling. ER 2014. Lecture Notes in Computer Science, vol 8824. Springer, Cham. https://doi.org/10.1007/978-3-319-12206-9_17
Download citation
DOI: https://doi.org/10.1007/978-3-319-12206-9_17
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-12205-2
Online ISBN: 978-3-319-12206-9
eBook Packages: Computer ScienceComputer Science (R0)