Multi-data source association query method, system and device and storage medium

An associated query, multi-data source technology, applied in the field of data processing, can solve the problem of low efficiency of multi-data source associated query analysis, achieve the effect of fast memory reading and improve query analysis efficiency

Pending Publication Date: 2022-05-10
武汉达梦数据技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In view of this, the present application provides a method, system, device and storage medium for associative query of multiple data sources to solve the technical problem of low analysis efficiency of the existing multi-data source associative query

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
  • Multi-data source association query method, system and device and storage medium
  • Multi-data source association query method, system and device and storage medium
  • Multi-data source association query method, system and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] Preferred embodiments of the application are described in detail below in conjunction with the accompanying drawings, wherein the drawings constitute a part of the application and together with the embodiments of the application are used to explain the principles of the application and are not intended to limit the scope of the application.

[0041] In the description of the present application, "plurality" means two or more, unless otherwise specifically defined.

[0042] Reference herein to an "embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the present application. The occurrences of this phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is understood explicitly and implicitly by those skilled in the art that the ...

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 relates to a multi-data-source association query method, system and device and a storage medium, and the method comprises the steps: obtaining a plurality of target data sources, and pre-analyzing the maximum data volume generated when the plurality of target data sources are to be queried; judging whether the remaining amount of the running memory meets the maximum data volume or not, and if yes, taking the running memory as a to-be-queried data interface; and obtaining to-be-queried field information, and performing matching query on the to-be-queried field information and the plurality of target data sources through the to-be-queried data interface to obtain a linked table query result. According to the method and the device, the maximum data volume of the to-be-queried target data sources is analyzed, and if the current running memory margin meets the operation space requirement, calculation and analysis can be directly performed in the running memory, so that the association query efficiency of the multiple data sources can be improved.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a method, system, device and storage medium for associative query of multiple data sources. Background technique [0002] At present, there are more and more big data applications, which not only provide convenience for people's life, but also improve the efficiency of all walks of life. However, due to historical reasons or the limitations of data collection, many data are stored in different media with different formats and types, which makes data utilization inconvenient. If a system wants to obtain data in different media for correlation analysis, there are often certain difficulties. The usual method is to synchronize the data in the database and unify the data to be used into one database. Unifying the structure through ETL leads to low efficiency in relational query analysis of different data sources. Contents of the invention [0003] In view of ...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F16/27G06F16/2455G06F16/22
CPCG06F16/24549G06F16/24569G06F16/24558G06F16/25G06F16/27
Inventor 张永强刘志红赵寅
Owner 武汉达梦数据技术有限公司
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