title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ ÑÑÐµÐ´ÑÑÐ² Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ñ Ð¡Ð£ÐÐ Oracle Ð½Ð° Ð¡Ð£ÐÐ PostgreSQL
title: Ð¼Ð°Ð³Ð¸ÑÑÐµÑÑÐºÐ°Ñ Ð´Ð¸ÑÑÐµÑÑÐ°ÑÐ¸Ñ
titleType: Subtitle
Creators: name: ÐÐ°Ð½Ð°ÐºÐ¾Ð²Ð°, ÐÐ°Ð»Ð¸Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2016
Subjects: ÐÐ°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
ÐÐ½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ñ
Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ
ÑÐ¸ÑÑÐµÐ¼Ð° ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ
data migration
database management system

description: Ð¢ÐµÐ¼Ð° Ð¼Ð°Ð³Ð¸ÑÑÐµÑÑÐºÐ¾Ð¹ Ð´Ð¸ÑÑÐµÑÑÐ°ÑÐ¸Ð¸ ÑÐ²ÑÐ·Ð°Ð½Ð° Ñ ÑÐ°ÐºÐ¸Ð¼ ÑÑÑÐ´Ð¾ÐµÐ¼ÐºÐ¸Ð¼ Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð¼, ÐºÐ°Ðº Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ñ Ñ Ð¾Ð´Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð´ÑÑÐ³ÑÑ. ÐÑÐ½Ð¾Ð²Ð½Ð¾Ð¹ ÑÐµÐ»ÑÑ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ ÑÑÐ¾Ð³Ð¾ Ð¿ÑÐ¾ÑÐµÑÑÐ° Ð¼ÐµÐ¶Ð´Ñ Oracle Ð¸ PostgreSQL. Ð Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÐµ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ð°ÑÐ¸ÐºÐ¸ Ð¸ ÑÑÐµÐ´ÑÑÐ² Ð¿Ð¾ÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ñ Ð¡Ð£ÐÐ Oracle Ð½Ð° PostgreSQL. Ð Ð°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÐµ ÑÑÐµÐ´ÑÑÐ²Ð° ÑÐµÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð¾Ð¿Ð¸ÑÐ°Ð½Ñ Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐµ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ñ Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ð¹. ÐÑÐ¾Ð¸Ð·Ð²ÐµÐ´ÐµÐ½Ð° ÑÐ¸ÑÑÐµÐ¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐµÐ¹, ÐºÐ¾ÑÐ¾ÑÑÐµ Ð¸Ð¼ÐµÑÑ ÑÐ°Ð·Ð»Ð¸ÑÐ¸Ñ Ð² ÑÐ¸Ð½ÑÐ°ÐºÑÐ¸ÑÐµ Ð¸Ð»Ð¸ Ð¸Ð½Ð¾Ð¹ Ð¿ÑÐ¸Ð½ÑÐ¸Ð¿ ÑÐ°Ð±Ð¾ÑÑ Ð² ÑÑÐ¸Ñ ÑÐ¸ÑÑÐµÐ¼Ð°Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ, Ð² Ð¸ÑÐ¾Ð³Ðµ ÑÐµÐ³Ð¾ Ð¿Ð¾Ð»ÑÑÐµÐ½ ÑÑÑÑÐºÑÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÐ¹ ÑÐ¿Ð¸ÑÐ¾Ðº, ÑÐ¾Ð´ÐµÑÐ¶Ð°ÑÐ¸Ð¹ ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÐ¸Ñ Ð´ÐµÑÐ°Ð»ÐµÐ¹ Ð´Ð»Ñ Ð´Ð²ÑÑ Ð¡Ð£ÐÐ. ÐÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¾ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾Ðµ ÑÐµÑÐµÐ½Ð¸Ðµ Ð´Ð°Ð½Ð½Ð¾Ð¹ Ð·Ð°Ð´Ð°ÑÐ¸, Ð° ÑÐ°ÐºÐ¶Ðµ Ð¾Ð¿Ð¸ÑÐ°Ð½ Ð¼ÐµÑÐ¾Ð´ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð´Ð»Ñ SQL Ð¸ PL/SQL Ð¾Ð±ÑÐµÐºÑÐ¾Ð². Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð¾ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ðµ ÑÑÐµÐ´ÑÑÐ²Ð¾, ÐºÐ¾ÑÐ¾ÑÐ¾Ðµ Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°ÑÑ Ð¿ÑÐ¾ÑÐµÑÑ Ð¿ÐµÑÐµÐ½Ð¾ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¼ÐµÐ¶Ð´Ñ Oracle Ð¸ PostgreSQL.
description: Master's thesis associated with time-consuming process, such as migration from one database management system to another. The main purpose of thesis is to automatize this process between Oracle Database and PostgreSQL. Analysis of problems and tools of porting data from Oracle to PostgreSQL has been fetch. The modern facilities of data migration problem solutions have been consider, and main features of existing applications have been described. Systematization of opportunities that have differences in syntax or principle of these database management systems has been produced. Eventually structured list, that contains a comparative analysis of these items for two databases has been made. Possible solutions of this problem have been suggested, as well as the migration method has been described for SQL and PL/SQL objects. Software tool that allows automatizing the process of transferring data between Oracle and PostgreSQL has been developed.