Academia
Diploma thesis 2024Software EngineeringDocker · Java · masovni podatki

Comparison of PostgreSQL and Oracle Database Performance in a Spring Boot Application for Processing Large Data Volumes

The research encompasses a thorough analysis of these technologies, an assessment of their advantages and disadvantages, and a comparative evaluation of their performance and usability in processing large data volumes.

Gregor PreskerRačunalništvo in informatika · module Programsko inženirstvo · supervisor mag. Ervin Schaff · defence september 2024
In brief

The project in five facts.

AuthorGregor Presker
Supervisormag. Ervin Schaff
ModuleSoftware EngineeringComputer Science and Informatics
Employer / clientAcademia
Year2024september 2024
About the project

Challenge, approach and results.

The diploma thesis investigates the efficiency and performance of technology use, with central emphasis on the Spring Boot framework and Oracle and PostgreSQL databases, in the context of processing massive data. The research encompasses a thorough analysis of these technologies, an assessment of their advantages and disadvantages, and a comparative evaluation of their performance and usability in processing large data volumes. Following the presentation of the application development, measurements were conducted, where an empirical analysis of Oracle and PostgreSQL database results was performed. Speed measurements were meticulously recorded and analysed, which provided valuable insight into the efficiency and performance of both database systems.

Problem

The diploma thesis investigates the efficiency and performance of technology use, with central emphasis on the Spring Boot framework and Oracle and PostgreSQL databases, in the context of processing massive data.

Solution and Method

The research encompasses a thorough analysis of these technologies, an assessment of their advantages and disadvantages, and a comparative evaluation of their performance and usability in processing large data volumes. In the diploma thesis, the aim was set to answer the following research questions: a) What is Big Data? b) Does the speed of inputting an infinite data stream differ with the Oracle database compared to the PostgreSQL database? c) What are the reasons for the difference in database performance when processing larger data volumes? d) Are Oracle and PostgreSQL the most suitable databases for an infinite data stream?

For this purpose, the basic theory was first defined, which included: analysis of the Spring Boot framework, examination of the Java programming language and Spring Boot framework functions and its advantages and disadvantages, examination of Oracle and PostgreSQL databases. Each database was thoroughly analysed, covering its characteristics, advantages and disadvantages, ultimately leading to a comparative assessment. The Docker platform and the concept of Big Data were also presented.

An application was developed using the Spring Boot framework. An analysis of application specifications was made, the development environment was presented, the procedure for developing the application with the Spring Boot framework and the procedure for creating the data model in Oracle and PostgreSQL databases were presented.

Results

Following the presentation of the application development, measurements were conducted, where an empirical analysis of Oracle and PostgreSQL database results was performed. Speed measurements were meticulously recorded and analysed, which provided valuable insight into the efficiency and performance of both database systems. The findings from the measurement phase as well as findings from the theory served as the basis for confirming or rejecting the hypotheses set in the diploma thesis.

In the concluding part of the diploma thesis, the findings from the theoretical and empirical parts of the diploma work were summarised.

Monitoring database server performance
Diploma thesis

Full text

PDF of the diploma thesis (public).

Diploma thesis (PDF) ↓
Related

Module, programme and stories.

Module Programsko inženirstvo

Your diploma project for a real company.

A diploma thesis at Academia solves a challenge from a company – often the one where you do your 800 hours of placement. Read about the Programsko inženirstvo module or book a consultation.

800 hoursof placement in a company
97 %of graduates employed
Module Programsko inženirstvo →Apply 2027/28All diploma projects
Before you go

We will send you the curriculum, the study path and your funding and scholarship options.

No calls, no spam. One e-mail with everything you need to decide, and an invitation to a lecture.

By sending the form you agree that Academia may contact you by e-mail or phone. Privacy · unsubscribe at any time.