Method and related device for realizing data interactive query between heterogeneous databases

Abstract

The invention discloses a method and a device for realizing data interactive query between heterogeneous databases, and relates to the technical field of big data. The method comprises the steps thata heterogeneous database system receives a data query request initiated by a query client through a set scheduling node; a query statement in the data query request is analyzed into a logic executionplan through a scheduling node, and the distributed processing is performed on the logic execution plan to obtain a plurality of sub-logic execution plans oriented to the heterogeneous database; statedetection is carried out on working nodes set by a heterogeneous database system, and sub-logic execution plans are correspondingly allocated to all the working nodes in an idle state, so that the working nodes execute data query of a heterogeneous database according to the allocated sub-logic execution plans; and the summarized result data is returned to the query client through the scheduling node after the working node returns the result data for executing the data query to the scheduling node for summarizing. According to the invention, efficient query of data between heterogeneous databases can be realized.

Description

technical field [0001] The present application relates to the field of big data technology, and in particular to a method and device, electronic equipment, and a computer-readable storage medium for realizing interactive query of data between heterogeneous databases. Background technique [0002] A heterogeneous database system is a collection of multiple related databases. Although the architectures of these databases are different from each other, data sharing and transparent access between databases can be realized. [0003] In existing implementations, due to the mutual correlation of data between heterogeneous databases, when performing data queries on heterogeneous database systems, the data in each heterogeneous database must first be imported into the same database through data exchange, and then The interactive data query between heterogeneous databases is carried out in this database, and the query process is very complicated. [0004] In actual business scenarios...

AI Technical Summary

Problems solved by technology

[0003] In existing implementations, due to the mutual correlation of data between heterogeneous databases, when performing data queries on heterogeneous database systems, the data in each heterogeneous database must first be imported into the same database through data exchange, and then Interactive data query between heterogeneous databases is performed in this database, and the query process is very complicated

[0004] In actual business scenarios, if the business department wants to analyze the data of multiple business systems deployed by the company, it needs the technical department to provide data exchange support, coupled with other processes such as information security approval, resulting in the inability of the business department to be efficient Analyze business data

Images