Abstract
A data set is a collection of information about something. Almost every application nowadays needs data persistence to maintain track of its status in the event of a problem. Databases are the primary component of an application for storing data and can be of two types: SQL or NoSQL. SQL (Structured Query Language) is a query language used in most relational databases to create, read, update, and delete entries (CRUD operations). In the relational database model, data is organized in a collection of tables, with rows as entries and columns as a specific property of the entry. New relational database management systems have emerged over time. From this perspective, a comparison of some of the most popular relational database management systems linked to a Java application using Hibernate is worthwhile. The time for each CRUD action is evaluated since they are the most often utilized operations for thousands and hundreds of thousands of entries. Depending on the bulk of operations, changing the database management system may be beneficial.
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
Keith, M., Schnicarol, M.: Pro JPA 2, Object-relational mapping, pp. 69–106. Apress (2009)
Truică, C.O., Boicea, A., Trifan, I.: CRUD operations in MongoDB. In: International Conference on Advanced Computer Science and Electronics Information. Atlantis Press, Beijing (2013)
Truică, C.O., Rădulescu, F., Boicea, A., Bucur, I.: Performance evaluation for CRUD operations in asynchronously replicated document oriented database. In: Conference on Control Systems and Computer Science. Bucharest (2015)
Sumathi, S., Esakkirajan, S.: Fundamentals of Relational Database Management Systems. Springer, Heidelberg (2007)
Atzeni, P., De Antonellis, V.: Relational Database Theory. Benjamin-Cummings Publishing Co., Inc. (1993)
Yousaf, H.: Performance evaluation of Java object-relational mapping tools (2012)
Ismail Hossain, M.M.: Oracle, MySQL, PostgreSQL, SQLite, SQL Server: performance based competitive analysis (2019)
Zmaranda, D., Pop-Fele, L., Gyorödi, C., Gyorödi, R.: Performance comparison of CRUD methods using NET object relational mappers: a case study. Int. J. Adv. Comput. Sci. Appl. 55–65 (2020)
Arnold, K.: The Java Programming Language. Addison Wesley Professional (2005)
Tudose, C.: Java Persistence with Spring Data and Hibernate. Manning (2022)
Tudose, C., Odubăşteanu, C.: Object-relational mapping using JPA, Hibernate and Spring Data JPA. In: Conference on Control Systems and Computer Science, Bucharest (2021)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Bonteanu, AM., Tudose, C. (2023). Multi-platform Performance Analysis for CRUD Operations in Relational Databases from Java Programs Using Hibernate. In: Hsu, CH., Xu, M., Cao, H., Baghban, H., Shawkat Ali, A.B.M. (eds) Big Data Intelligence and Computing. DataCom 2022. Lecture Notes in Computer Science, vol 13864. Springer, Singapore. https://doi.org/10.1007/978-981-99-2233-8_20
Download citation
DOI: https://doi.org/10.1007/978-981-99-2233-8_20
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-99-2232-1
Online ISBN: 978-981-99-2233-8
eBook Packages: Computer ScienceComputer Science (R0)