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

A data query and database technology, applied in the field of big data, can solve the problems of complicated query process and the inability of business departments to analyze business data.

Pending Publication Date: 2020-01-07
PING AN TECH (SHENZHEN) CO LTD
View PDF0 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and related device for realizing data interactive query between heterogeneous databases
  • Method and related device for realizing data interactive query between heterogeneous databases
  • Method and related device for realizing data interactive query between heterogeneous databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0039] figure 1 It is a schematic diagram of an implementation environment involved in this application shown according to an exemplary embodiment. like figure 1 As shown, the implementation environment includes a query client 100 and a query server 200 .

[0040]Wherein, a wired or wireless network connection is pre-established between the query client 100 and the query server 200 to rea...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/27G06F16/242G06F16/28
CPCG06F16/27G06F16/2433G06F16/283
Inventor 倪程伟汪涛
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap