title: ÐÐµÑÐ¾Ð´ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ ÑÐµÑÐµÑÐ°ÑÐ¸Ð²Ð½ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ðº Ð³ÐµÑÐµÑÐ¾Ð³ÐµÐ½Ð½ÑÐ¼ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÐ¼ Ð±Ð°Ð·Ð°Ð¼ Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Method for executing a query to heterogeneous independent databases
Creators: name: Ð¦Ð°ÑÑÐºÐ¾Ð²Ð°, ÐÐ»ÐµÐºÑÐ°Ð½Ð´ÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: Ð³ÐµÑÐµÑÐ¾Ð³ÐµÐ½Ð½ÑÐµ Ð¡Ð£ÐÐ
Ð¼ÐµÑÐ°Ð´Ð°Ð½Ð½ÑÐµ
ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÐµ Ð·Ð°Ð¿ÑÐ¾ÑÑ
Ð´ÐµÐºÐ¾Ð¼Ð¿Ð¾Ð·Ð¸ÑÐ¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²
ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÐµ Ð¡Ð£ÐÐ
Ð¸Ð½ÑÐµÐ³ÑÐ°ÑÐ¸Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ
Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ° Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð²
Ð¡Ð£ÐÐ
Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
mySQL
Postgre SQL
SQLite
Python
heterogeneous DBMS
metadata
distributed queries
queries decomposition
distributed DBMS
databases integration
queries processing
DBMS
databases

description: Ð ÑÐ°Ð±Ð¾ÑÐµ ÑÐ°ÑÑÐ¼Ð¾ÑÑÐµÐ½Ñ Ð¼ÐµÑÐ¾Ð´Ñ, Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ñ, Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÐµ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð¸Ð½Ð°Ð¼Ð¸ÑÐµÑÐºÐ¸ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð´Ð°Ð½Ð½ÑÑ, Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½ Ð¼ÐµÑÐ¾Ð´ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ° Ðº Ð³ÐµÑÐµÑÐ¾Ð³ÐµÐ½Ð½ÑÐ¼ Ð½ÐµÐ·Ð°Ð²Ð¸ÑÐ¸Ð¼ÑÐ¼ Ð±Ð°Ð·Ð°Ð¼ Ð´Ð°Ð½Ð½ÑÑ. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¼ÐµÑÐ¾Ð´ Ð¸ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ðº Ð³ÐµÑÐµÑÐ¾Ð³ÐµÐ½Ð½ÑÐ¼ ÑÐ¸ÑÑÐµÐ¼Ð°Ð¼ Ð¸ Ð²ÑÐ±ÑÐ°Ð½Ñ ÑÑÐµÐ´ÑÑÐ²Ð° ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ Ð´Ð»Ñ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÑ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ðº Ð³ÐµÑÐµÑÐ¾Ð³ÐµÐ½Ð½ÑÐ¼ Ð±Ð°Ð·Ð°Ð¼ Ð´Ð°Ð½Ð½ÑÑ. ÐÐµÑÐ¾Ð´ ÑÐ¾ÑÑÐ¾Ð¸Ñ Ñ Ð¿ÑÐµÐ´Ð²Ð°ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾Ð¹ ÑÐ¸Ð»ÑÑÑÐ°ÑÐ¸ÐµÐ¹ Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° ÑÑÐ¾Ð²Ð½Ðµ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð¿Ð¾ÑÐ»ÐµÐ´ÑÑÑÐ¸Ð¼ Ð¾Ð±ÑÐµÐ´Ð¸Ð½ÐµÐ½Ð¸ÐµÐ¼ Ñ Ð¿Ð¾Ð²ÑÐ¾ÑÐ½ÑÑ ÑÐ¸Ð»ÑÑÑÐ°ÑÐ¸Ð¹ Ð¿ÐµÑÐµÐ´ Ð²ÑÐ²Ð¾Ð´Ð¾Ð¼. ÐÐ° ÑÐ·ÑÐºÐµ Python ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¼Ð°ÐºÐµÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ, Ð²ÑÐ¿Ð¾Ð»Ð½ÑÑÑÐµÐ³Ð¾ ÑÐ°ÑÐ¿ÑÐµÐ´ÐµÐ»ÐµÐ½Ð½ÑÐµ Ð·Ð°Ð¿ÑÐ¾ÑÑ Ðº Ð±Ð°Ð·Ð°Ð¼ Ð´Ð°Ð½Ð½ÑÑ ÑÑÐµÑ ÑÐ°ÑÐ¿ÑÐ¾ÑÑÑÐ°Ð½ÐµÐ½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼Ð°Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ: MySQL, Postgre SQL Ð¸ SQLite. ÐÐ°ÐºÐµÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð±ÑÐ» Ð¿Ð¾ÑÐ»ÐµÐ´Ð¾Ð²Ð°ÑÐµÐ»ÑÐ½Ð¾ Ð¿ÑÐ¾ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½ Ð¼Ð¾Ð´ÑÐ»ÑÐ½Ð¾, ÑÑÑÐ°ÑÐµÐ³Ð¸ÐµÐ¹ ÑÐµÑÐ½Ð¾Ð³Ð¾ ÑÑÐ¸ÐºÐ° Ð¸ Ð½Ð°Ð³ÑÑÐ·Ð¾ÑÐ½Ð¾, ÑÑÐ¾ Ð¿ÑÐ¾Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ¸ÑÐ¾Ð²Ð°Ð»Ð¾ ÑÐ°Ð±Ð¾ÑÐ¾ÑÐ¿Ð¾ÑÐ¾Ð±Ð½Ð¾ÑÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¸. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð² ÑÐµÐ¶Ð¸Ð¼Ð°Ñ Ñ Ð¸ Ð±ÐµÐ· Ð¿ÑÐµÐ´Ð²Ð°ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾Ð¹ ÑÐ¸Ð»ÑÑÑÐ°ÑÐ¸Ð¸ Ð¿Ð¾ÐºÐ°Ð·Ð°Ð»Ð¾ Ð½ÐµÐ¾Ð±ÑÐ¾Ð´Ð¸Ð¼Ð¾ÑÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð¿ÑÐµÐ´Ð²Ð°ÑÐ¸ÑÐµÐ»ÑÐ½Ð¾Ð¹ ÑÐ¸Ð»ÑÑÑÐ°ÑÐ¸Ð¸. ÐÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð½ÑÐ¹ Ð¼ÐµÑÐ¾Ð´ Ð¼Ð¾Ð¶ÐµÑ Ð±ÑÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½ Ð¿ÑÐ¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐµ ÑÑÐµÐ´ÑÑÐ² Ð¸Ð½ÑÐµÐ³ÑÐ°ÑÐ¸Ð¸ Ð½ÐµÐ·Ð°Ð²Ð¸ÑÐ¸Ð¼ÑÑ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ.
description: The paper considers methods, algorithms, software implementations of technology for storing dynamically distributed data, and implements a method for executing a query to heterogeneous independent databases. The method and algorithm for implementing queries to heterogeneous systems have been developed and means of implementing a program for executing distributed queries to heterogeneous databases have been selected. The method consists of pre-filtering data at the database level and then combining with re-filtering before output. In Python, a software layout has been developed that performs distributed queries on databases of three common database management systems: MySQL, Postgre SQL, and SQLite. The software layout has been consistently tested in a modular, black-box, and load fashion, demonstrating that the technology works. The study of performance in modes with and without pre-filtering showed the need for pre-filtering. The proposed method can be used in the development of tools for integrating independent databases.