Full Article: PDF
Scientific Object Identifier: http://s-o-i.org/1.1/TAS-05-133-9
DOI: https://dx.doi.org/10.15863/TAS.2024.05.133.9
Language: Russian
Citation: Borganova, L. I., & Sabinin, O. Yu. (2024). Research on migration of software components between relational databases (using the example of migration from oracle to postgresql). ISJ Theoretical & Applied Science, 05 (133), 35-39. Soi: http://s-o-i.org/1.1/TAS-05-133-9 Doi: https://dx.doi.org/10.15863/TAS.2024.05.133.9 |
Pages: 35-39
Published: 30.05.2024
Abstract: In this article, the relevance of the transition to open database management systems is justified and the issue of migration between Oracle and PostgreSQL DBMS is considered. An overview of modern solutions for converting the code of software components written in the PL/SQL procedural language used in Oracle to PL/pgSQL used in PostgreSQL is conducted, and the stages of migration are analyzed. As a result, the algorithm of program migration between the two systems is described and the conversion processes of functions, procedures, triggers and packages are considered.
Key words: database management system, relational database, Oracle, PostgreSQL, migration of software components, migration of PL/SQL, PL/pgSQL.
|
