Performance Analysis for CRUD Operations in Relational Databases from Java Programs Using Hibernate
Alexandru-Marius Bonteanu, Cătălin Tudose, Ana Magdalena Anghel · 2023
Data is information or a collection of information about something. Almost every application nowadays needs to persist data so that they can keep track of their state in case of any trouble that might appear. Databases are the main piece of an application for persisting data and they can be of two types: SQL or NoSQL. SQL (Structured Query Language) is a query language used to create, read, update, or delete (CRUD operations) the information in most relational databases. Data is structured in a set of tables in the relational database model, with rows as entries and columns as specific attributes of the entry. Over the years, new relational database management systems appeared. A comparison between some of the most used relational database management systems tied to a Java application using Hibernate is worth analyzing in the given context. The evaluation is done on timing for each CRUD operation by using Java Microbenchmark Harness, because these are the most used operations, for thousands and hundreds of thousands of entries. Depending on the majority type of operation, switching the database management system might help.