title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÑÐµÐ´ÑÑÐ² Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ NoSQL Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of software tools for migrating NoSQL databases to PostgreSQL
Creators: name: ÐÐ³ÑÐµÐ½ ÐÐ½Ñ Ð¢ÑÐ°Ð½
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Nosql Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
Postgresql
Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ
ÑÐµÐ»Ð¾ÑÑÐ½Ð¾ÑÑÑ Ð´Ð°Ð½Ð½ÑÑ
etl
Nosql databases
database migration
data integrity

description: ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¾ÑÐºÑÑÐ²Ð°ÐµÑÑÑ Ð°Ð½Ð°Ð»Ð¸Ð·Ð¾Ð¼ Ð¼Ð¾Ð´ÐµÐ»ÐµÐ¹ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ NoSQL Ð¸ PostgreSQL, Ñ Ð°ÐºÑÐµÐ½ÑÐ¾Ð¼ Ð½Ð° Ð¸Ñ ÑÐ½Ð¸ÐºÐ°Ð»ÑÐ½ÑÐµ Ð¾ÑÐ¾Ð±ÐµÐ½Ð½Ð¾ÑÑÐ¸ Ð¸ ÑÑÐµÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ. ÐÐ°Ð»ÐµÐµ ÑÐ°ÑÑÐ¼Ð°ÑÑÐ¸Ð²Ð°ÑÑÑÑ Ð¿ÑÐ¾ÑÐµÑÑ Ð¸ Ð¼ÐµÑÐ¾Ð´Ð¾Ð»Ð¾Ð³Ð¸Ñ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð¸Ð· NoSQL Ð±Ð°Ð· Ð² PostgreSQL, Ð²ÑÑÐ²Ð»ÑÑÑÑÑ ÐºÐ»ÑÑÐµÐ²ÑÐµ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼Ñ Ð¸ Ð¿ÑÐµÐ´Ð»Ð°Ð³Ð°ÑÑÑÑ ÑÐµÑÐµÐ½Ð¸Ñ Ð´Ð»Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾Ð¹ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸. ÐÑÐ½Ð¾Ð²Ð½Ð°Ñ ÑÐ°ÑÑÑ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð²ÐºÐ»ÑÑÐ°ÐµÑ Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ, Ð¿ÑÐµÐ´Ð½Ð°Ð·Ð½Ð°ÑÐµÐ½Ð½Ð¾Ð³Ð¾ Ð´Ð»Ñ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ Ð¸ ÑÐ¿ÑÐ¾ÑÐµÐ½Ð¸Ñ Ð¿ÑÐ¾ÑÐµÑÑÐ° Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸. ÐÐºÐ»ÑÑÐµÐ½Ñ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ð¾Ð² Ð¸ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ¾Ð², ÐºÐ¾ÑÐ¾ÑÑÐµ Ð¾Ð±ÐµÑÐ¿ÐµÑÐ¸Ð²Ð°ÑÑ ÑÐµÐ»Ð¾ÑÑÐ½Ð¾ÑÑÑ Ð¸ ÑÐ¾Ð³Ð»Ð°ÑÐ¾Ð²Ð°Ð½Ð½Ð¾ÑÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð²Ð¾ Ð²ÑÐµÐ¼Ñ Ð¼Ð¸Ð³ÑÐ°ÑÐ¸Ð¸. ÐÐ°ÐºÐ¾Ð½ÐµÑ, Ð² ÑÐ°Ð±Ð¾ÑÐµ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÐµÐ½ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ½ÑÐ¹ ÑÑÐ°Ð¿ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ, Ð² ÑÐ°Ð¼ÐºÐ°Ñ ÐºÐ¾ÑÐ¾ÑÐ¾Ð³Ð¾ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ðµ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ðµ Ð¾ÑÐµÐ½Ð¸Ð²Ð°ÐµÑÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ ÑÐµÑÐ¸Ð¸ ÑÑÑÐ¾Ð³Ð¸Ñ ÑÐµÑÑÐ¾Ð² Ð´Ð»Ñ Ð¿Ð¾Ð´ÑÐ²ÐµÑÐ¶Ð´ÐµÐ½Ð¸Ñ ÐµÐ³Ð¾ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾ÑÑÐ¸, Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ¸ÑÑÑÑ ÑÐ¿Ð¾ÑÐ¾Ð±Ð½Ð¾ÑÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ Ð¼Ð¸Ð³ÑÐ¸ÑÐ¾Ð²Ð°ÑÑ Ð´Ð°Ð½Ð½ÑÐµ Ð¸Ð· ÑÐ°Ð·Ð»Ð¸ÑÐ½ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ NoSQL Ð½Ð° PostgreSQL, Ð¿ÑÐµÐ´Ð¾ÑÑÐ°Ð²Ð»ÑÑ Ð¿ÑÐ°ÐºÑÐ¸ÑÐµÑÐºÐ¾Ðµ ÑÐµÑÐµÐ½Ð¸Ðµ Ð´Ð»Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¹, Ð¶ÐµÐ»Ð°ÑÑÐ¸Ñ Ð¸Ð·Ð²Ð»ÐµÑÑ Ð²ÑÐ³Ð¾Ð´Ñ Ð¸Ð· Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ Ð¸ ÑÐ½Ð¸Ð²ÐµÑÑÐ°Ð»ÑÐ½Ð¾ÑÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ PostgreSQL Ð¿ÑÐµÐ´Ð»Ð°Ð³Ð°ÐµÑ.
description: The research begins with an analysis of NoSQL and PostgreSQL database models, emphasizing their unique features and areas of application. It then examines the process and methodology of migrating data from NoSQL databases to PostgreSQL, identifying key issues and proposing solutions for effective migration. The core of this study involves the design and implementation of software dedicated to automating and streamlining the migration process. This includes the development of algorithms and tools that ensure data integrity and consistency during migration. Finally, the thesis presents a comprehensive testing phase, wherein the developed software is evaluated through a series of rigorous tests to validate its functionality, performance, and reliability. The results demonstrate the softwares ability to efficiently migrate data from various NoSQL databases to PostgreSQL, providing a practical solution for companies looking to benefit from the reliability and versatility that PostgreSQL offers.