Migration of Banking Payment Services from Oracle DBMS to PostgreSQL DBMS

Student: Karachik Emil

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Year of Graduation: 2024

Due to Oracle's withdrawal from the Russian Federation market, many companies have encountered problems in using the technology giant's software, including the Oracle Database management system. This forced companies to look for analogs of products already in use and start the process of migrating to them. One of the main competitors of Oracle Database is the freely distributed and open source PostgreSQL DBMS. This paper discusses the main differences between these two systems, their main advantages and disadvantages, as well as the process of migration to a PostgreSQL database. The paper describes the main problems encountered in the process of database migration, compares the performance of services when using both systems, and proposes methods for optimizing the PostgreSQL database.

Student Theses at HSE must be completed in accordance with the University Rules and regulations specified by each educational programme.

Summaries of all theses must be published and made freely available on the HSE website.

The full text of a thesis can be published in open access on the HSE website only if the authoring student (copyright holder) agrees, or, if the thesis was written by a team of students, if all the co-authors (copyright holders) agree. After a thesis is published on the HSE website, it obtains the status of an online publication.

Student theses are objects of copyright and their use is subject to limitations in accordance with the Russian Federation’s law on intellectual property.

In the event that a thesis is quoted or otherwise used, reference to the author’s name and the source of quotation is required.

Search all student theses