75036

Автор(ы): 

Автор(ов): 

2

Параметры публикации

Тип публикации: 

Статья в журнале/сборнике

Название: 

Database Migration from ORACLE to PostgreSQL

Электронная публикация: 

Да

ISBN/ISSN: 

0361-7688

DOI: 

10.1134/S0361768823050055

Наименование источника: 

  • Programming and Computer Software

Обозначение и номер тома: 

Vol. 49 N 5

Город: 

  • Москва

Издательство: 

  • Springer

Год издания: 

2023

Страницы: 

455–463.
Аннотация
Methods of data transfer from the Oracle environment to the PostgreSQL environment with stageby- stage organization of actions and determination of the sequence of migration are considered. The main directions for the transformation of the structure of databases, data formats and executed objects are identified. Methods for converting stored procedures and triggers written in procedural languages (PL/SQL and PL/pgSQL) are specified. Software change on nodes directly connected (associated) with the database server and minimization of downtimes during migration are considered, which allows the transfer to be performed for geographically distributed and round-the-clock functioning objects. Examples of changing the speed of query execution before and after migration are given for systems of various types.

Библиографическая ссылка: 

Курако Е.А., Орлов В.Л. Database Migration from ORACLE to PostgreSQL // Programming and Computer Software. 2023. Vol. 49 N 5. С. 455–463.