Abstract
The primordial part of realizing a computer system is conceptual modelling, which has met with great success in relational database design using an ER model. Unfortunately, with the development of the computer field, relational databases confronted shortcomings in their applications and the object-relational model became used more and more. The tools of presenting conceptual modelling do not support all new concepts introduced by such models and the syntax of the SQL4 language. This paper aims to survey the previous works and various proposals on how to create rules for designing the object-relational (O-R) database to indicate their strengths and limitations. The paper provides a comprehensive explanation and evaluation of the existing approaches and the possibility of transferring all data semantics and relationships. This work demonstrates the importance and difficulty of these guidelines and discusses many previous works in this field. This paper confirms that modern technologies and new databases play an important role in the success of software design.
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
Similar content being viewed by others
References
Ireland, C.J.: Object-relational impedance mismatch: a framework-based approach. Dissertation, The Open University (2011)
Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Pearson, Hoboken (2016)
Lord, C., Gupta, S.: The evolution of object-relational databases (2002)
Coronel,C., Morris, S.: Database Systems: Design, Implementation, and Management. Cengage Learning, Australia (2017)
Marcos, E., Vela, B., Cavero, J.M., Cáceres, P.: Aggregation and composition in object-relational database design. In: 5th Conference on Advances in Databases and Information Systems, pp. 195–209, September 2001
Keivani, N., Maatuk, A.M., Aljawarneh, S., Ali, M.A.: Towards the maturity of object-relational database technology: promises and reality. Int. J. Technol. Diffus. 6, 1–19 (2015). https://doi.org/10.4018/ijtd.2015100101
Dietrich, S.W., Urban, S.D.: An Advanced Course in Database Systems: Beyond Relational Databases. Pearson/Prentice Hall, Upper Saddle River (2005)
Castro, K.: Object-relational Data Model. https://www.tutori-alspoint.com/Object-relational-Data-Model. Accessed 25 Aug 2019
Golobisky, M.F., Vecchietti. A.: Mapping UML class diagrams into object-relational schemas. In: Proceedings of ASSE, vol. 1, pp. 65–79 (2005)
Auziņš, A., Eiduks, J., Vasiļevska, A., Dzenis, R.: Object-relational database structure model and structure optimisation. Appl. Comput. Syst. 23, 28–36 (2018). https://doi.org/10.2478/acss-2018-0004
Eder, J., Kanzian, S.: Logical design of generalizations in object-relational databases. In: ADBIS (Local Proceedings) (2004)
Marcos, E., Vela, B., Cavero, J.M.: A methodological approach for object-relational database design using UML. Informatik Forschung und Entwicklung 18, 152–164 (2004). https://doi.org/10.1007/s00450-004-0158-4
Vara, J.M., Vela, B., Cavero, J.M., Marcos, E.: Model transformation for object-relational database development. In: Proceedings of the 2007 ACM Symposium on Applied Computing (2007). https://doi.org/10.1145/1244002.1244222
Soumiya, A.E., Mohamed, B.: Converting UML class diagrams into temporal object relational database. Int. J. Electr. Comput. Eng. (IJECE) 7(5), 2823 (2017). https://doi.org/10.11591/ijece.v7i5.pp2823-2832
Wang, M.: Solving relational database problems with ORDBMS in an advanced database course. Inf. Syst. Educ. J. (ISEDJ) 9(4), 80–90 (2011)
Awang, M.K., Labadu, N.L., Campus, G.B.: Transforming object-oriented data model to relationaldata model. New Comput. Archit. Appl. 2(3), 402–409 (2012)
de Castro, T.R., de Souza, S.N.A., de Souza, L.S.: CASE tool for object-relational databasedesigns. In: 7th Iberian Conference on Information Systems and Technologies (CISTI 2012), pp. 1–6. IEEE, New York (2001)
Pardede, E., Rahayu, J.W., Taniar, D.: Mapping methods and query for aggregation and association in object-relational database using collection. In: International Conference on Information Technology: Coding and Computing, 2004 Proceedings ITCC, pp. 539–543. IEEE, New York (2004). https://doi.org/10.1109/itcc.2004.1286513
Eessaar, E.: On finding suitable designs for whole-part relationships in object-relational databases. Inf. Syst. Dev., 951–962 (2008). https://doi.org/10.1007/978-0-387-78578-3_28
Rombaldo, C.A., Alves Souza, S.N., Souza, L.S.: O-ODM framework for object-relational databases. Int. J. Interact. Multimed. Artif. Intell. 1(6), 29–35 (2012). https://doi.org/10.9781/ijimai.2012.164
Cabot, J., Gómez, C., Planas, E., Rodríguez, M.E.: Reverse engineering of OO constructsin object-relational database schemas. Jornadas de IngenierÃa del Software y Bases de Datos 20(49), 134 (2008)
Fouad, T., Mohamed, B.: Reverse engineering of object relational database. In: Proceedings of the 2018 International Conference on Software Engineering and Information Management, pp. 73–76. ACM (2018). https://doi.org/10.1145/3178461.3178481
Maatuk, A.M., Akhtar Ali, M., Aljawarneh, S.: Translating relational database schemas into object-based schemas: university case study. Recent Pat. Comput. Sci. Innov. Educ. Technol. E-Learn. Soc. Netw. 8(2), 122–132 (2015). https://doi.org/10.2174/2213275908666150710174102
Maatuk, A., Akhtar Ali, M., Rossiter, N.: Converting relational databases into object-relational databases. J. Object Technol. (JOT) 9(2), 145–161 (2010)
Maatuk, A.: Migrating relational databases into object-based and XML databases. Ph.D thesis, University of Northumbria, Newcastle, UK, September 2009
Maatuk, A., Akhtar Ali, M., Rossiter, N.: Semantic enrichment: the first phase of relational database migration. In: Proceedings of the 2008 International Conference on Systems, Computing Sciences and Software Engineering (SCSS), Bridgeport, USA, pp. 373–378 (2008)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG
About this paper
Cite this paper
Bohalfaya, H.M., Maatuk, A.M., Abdelnabi, E.A. (2024). Object-Relational Database Design Approaches: A Survey of Approaches and Techniques. In: Benmusa, T.A.T., Elbuni, M.S., Saleh, I.M., Ashur, A.S., Drawil, N.M., Ellabib, I.M. (eds) Information and Communications Technologies. ILCICT 2023. Communications in Computer and Information Science, vol 2097. Springer, Cham. https://doi.org/10.1007/978-3-031-62624-1_9
Download citation
DOI: https://doi.org/10.1007/978-3-031-62624-1_9
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-031-62623-4
Online ISBN: 978-3-031-62624-1
eBook Packages: Computer ScienceComputer Science (R0)