Comparison of PostgreSQL and Oracle database performance on the example of Spring-Boot application when processing large amounts of data

The thesis is a research of the efficiency and capability of utilizing technologies with a primary focus on the Spring-Boot framework and Oracle and PostgreSQL databases, all in the context of processing Big Data.

The research includes a thorough analysis of these technologies, an assessment of their strengths and weaknesses, and a comparative assessment of their performance and usability in processing large amounts of data.

In the thesis, we aim to address the following research questions:

a) What is Big Data? b) Does the data ingestion speed differ between Oracle and PostgreSQL databases when dealing with an infinite data stream? c) What are the reasons for the performance difference between databases in processing large volumes of data? č) Are Oracle and PostgreSQL the most suitable databases for an infinite data stream?

To this end, we first defined the basic theory, which included: dissecting the Spring-Boot framework, examining the Java programming language and Spring-Boot framework features, as well as their pros and cons.

We also examined the Oracle and PostgreSQL databases, conducting a thorough analysis of each database’s characteristics, advantages, and disadvantages, ultimately leading to a comparative evaluation. Additionally, we introduced the Docker platform and the concept of Big Data.

We developed an application using the Spring-Boot framework. We conducted an analysis of the application specifications, presented the development environment, as well as the application development process, using the Spring-Boot framework, and the process of creating a data model in Oracle and PostgreSQL databases.

Following the application development presentation, we conducted measurements performing an empirical analysis of the results from the Oracle and PostgreSQL databases. Speed measurements were meticulously recorded and analysed, providing valuable insights into the efficiency and performance of both database systems.

The findings from the measurement phase, as well as those from the theoretical research, served as the basis for confirming or refuting the hypotheses set forth in the thesis.

In the concluding section of the thesis, we summarized the findings from the theoretical and empirical parts of the research.