title: ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° ÑÐ¸ÑÑÐµÐ¼Ñ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½Ñ Ð¼ÐµÐ¶Ð´Ñ ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½ÑÐ¼Ð¸ Ð¡Ð£ÐÐ (Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ñ OracLe Ð² PostgreSQL)
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: The research and development of a prototype system for migrating software components between relational DBMSs (using the example of migration from Oracle to PostgreSQL)
Creators: name: ÐÐ¾ÑÐ³Ð°Ð½Ð¾Ð²Ð°, ÐÐ¸Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: ÐÐ°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½Ñ
ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
migration of software components
relational database

description: ÐÐ°Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° ÑÐ¸ÑÑÐµÐ¼Ñ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½Ñ Ð¼ÐµÐ¶Ð´Ñ Ð¡Ð£ÐÐ Oracle Ð¸ Ð¡Ð£ÐÐ PostgreSQL. Ð ÑÐ¾Ð´Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð° Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½Ð° Ð°ÐºÑÑÐ°Ð»ÑÐ½Ð¾ÑÑÑ Ð¿ÐµÑÐµÑÐ¾Ð´Ð° Ð² Ð¾ÑÐºÑÑÑÑÐµ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ. ÐÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð¾Ð±Ð·Ð¾Ñ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐµÐ¹ Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð¸Ñ ÐºÐ¾Ð´Ð° Ð½Ð° Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÐ·ÑÐºÐ°Ñ PL/SQL Ð² Ð¡Ð£ÐÐ Oracle Ð¸ PL/pgSQL Ð² Ð¡Ð£ÐÐ PostgreSQL, Ð¸ Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð´Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð¾Ð±Ð·Ð¾ÑÐ° Ð¿ÑÐ¾Ð°Ð½Ð°Ð»Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ñ ÑÑÐ¾Ð´ÑÑÐ²Ð° Ð¸ ÑÐ°Ð·Ð»Ð¸ÑÐ¸Ñ Ð¼ÐµÐ¶Ð´Ñ Ð´Ð²ÑÐ¼Ñ ÑÐ¸ÑÑÐµÐ¼Ð°Ð¼Ð¸. Ð¢Ð°ÐºÐ¶Ðµ Ð±ÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð¾Ð±Ð·Ð¾Ñ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÑ ÑÐµÑÐµÐ½Ð¸Ð¹ Ð¿Ð¾ ÐºÐ¾Ð½Ð²ÐµÑÑÐ°ÑÐ¸Ð¸ Ñ Ð¿Ð¾ÑÐ»ÐµÐ´ÑÑÑÐµÐ¹ ÑÐ¾ÑÐ¼ÑÐ»Ð¸ÑÐ¾Ð²ÐºÐ¾Ð¹ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ð¹ Ðº ÑÐ°Ð·ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÐµÐ¼Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ðµ. ÐÑÐ» Ð¾Ð±Ð¾ÑÐ½Ð¾Ð²Ð°Ð½ Ð²ÑÐ±Ð¾Ñ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ°Ð»ÑÐ½Ð¾Ð³Ð¾ ÑÑÐµÐ´ÑÑÐ²Ð°. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð±ÑÐ» ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÐºÐ¾Ð¼Ð¿Ð¾Ð½ÐµÐ½Ñ Ð¼ÐµÐ¶Ð´Ñ Ð¡Ð£ÐÐ Oracle Ð¸ Ð¡Ð£ÐÐ PostgreSQL, Ð¾ÑÐ²Ð°ÑÑÐ²Ð°ÑÑÐ¸Ð¹ Ð¿ÑÐ¾ÑÐµÑÑÑ ÐºÐ¾Ð½Ð²ÐµÑÑÐ°ÑÐ¸Ð¸ ÑÑÐ½ÐºÑÐ¸Ð¹, Ð¿ÑÐ¾ÑÐµÐ´ÑÑ, ÑÑÐ¸Ð³Ð³ÐµÑÐ¾Ð² Ð¸ Ð¿Ð°ÐºÐµÑÐ¾Ð², Ð¸ Ð±ÑÐ»Ð° Ð¿ÑÐ¾Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð° ÑÐ°Ð±Ð¾ÑÐ¾ÑÐ¿Ð¾ÑÐ¾Ð±Ð½Ð¾ÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° ÑÐ¸ÑÑÐµÐ¼Ñ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸.
description: This work is devoted to the research and development of a prototype system for migrating software components between Oracle DBMS and PostgreSQL DBMS. During the research, the relevance of transitioning to open database management systems was justified. A review of the coding features in the PL/SQL programming language in Oracle DBMS and PL/pgSQL in PostgreSQL DBMS was conducted, and based on this review, the similarities and differences between the two systems were analyzed. Additionally, an overview of current conversion solutions was carried out, followed by the formulation of requirements for the developed system. The choice of tool for development was justified. As a result, an algorithm for migrating software components between Oracle DBMS and PostgreSQL DBMS was implemented, covering the conversion processes of functions, procedures, triggers and packages, and the operability of the developed prototype of the migration system was demonstrated.