Software of Computer, Telecommunications and Control Systems

Study decomposing and executing algorithms of data extraction queries in heterogeneous relationship database management systems

S. G. Popov, A. A. Purii

Peter the Great St. Petersburg Polytechnic University

Abstract: When working with independent databases, the problem of partial automation arises, which consists in the impossibility of obtaining data from independent databases with a previously unknown scheme. The problem consists of two aspects: the lack of semantic connection between independent databases, and the dynamics of the semantics of schemes. The goal is the development and study of algorithms for constructing integrated queries for data sampling to heterogeneous distributed database management systems. To test the functionality of the algorithms, software and database of databases, which provides the ability to access independent databases, as if they were a single DBMS, but without full replication of the merging databases.

Keywords: heterogeneous DBMS, metadata, distributed queries, queries decomposition, distributed DBMS, databases integration, queries processing, DBMS, databases.

UDC: 004.652.42, 004.657, 004.655.3:004.652.4

Received: 04.05.2019

DOI: 10.18721/JCSTCS.12205