Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

A multi-data source and driving system technology, applied in the computer field, can solve the problems of increasing the cost of database users, different data, etc., achieve the effect of fast and effective query results, reduce storage capacity, and improve query efficiency

Pending Publication Date: 2020-04-28
YONYOU NETWORK TECH
View PDF12 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, when querying multiple data sources, whether it is a single data source query or a multi-data source query, the connection drivers for different data sources are different, and the query structured query language statements are also inconsistent, and need to be adapted separately , which increases the cost to the database consumer
At the same time, the data returned after the query is also different, especially for non-big data development, how to integrate with the existing system poses a relatively big challenge

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] Such as figure 1 As shown, this embodiment provides a multi-data source query driving system 10 for querying at least one of multiple data sources, including: a data inventory module 100, a query module 500, an adapter 200 and a return type construction module 400 , wherein, the data inventory module 100 is suitable for providing a visual interface, taking stock of the data source information of the data source, and generating objects from the data source according to the data source information, and the query module 500 is suitable for inputting the data source type, structured query language (English name: Structured Query Language, referred to as SQL, is a database query and programming language, used for accessing data, querying, updating and managing relational database systems) statements and return file types, adapter 200 and data inventory module 100 and query module 500 respectively Signal connection, suitable for matching objects according to the data source t...

Embodiment 2

[0050] Such as figure 2 As shown, this embodiment provides a multi-data source query driving system 10. In addition to the technical features of the above-mentioned embodiments, this embodiment also includes the following technical features.

[0051] The multi-data source query driving system 10 also includes: a memory module 300 and an object relationship establishment module 600, wherein the memory module 300 is provided with multiple object types, and is respectively signal-connected with the adapter 200 and the return type construction module 400, and is suitable for receiving the adapter 200 outputs the query result, according to the query result, the query data is set to be stored in the corresponding object type, and the query result is output to the return type building module 400, the object relationship building module 600 is connected with the memory module 300 signal, and the memory module 300 There is a table object type, which is suitable for coupling and connec...

Embodiment 3

[0055] Such as image 3 As shown, this embodiment provides a multi-data source query driving system 10. In addition to the technical features of the above-mentioned embodiments, this embodiment also includes the following technical features.

[0056] The multi-data source query driving system 10 also includes: a weight calculation module 700, an object optimization module 800, and an object heat calculation module 900, wherein the weight calculation module 700 is connected to the memory module 300 by a signal, and is suitable for analyzing the query results according to the number of queries Set the weight of the contained object type, and the object optimization module 800 is connected with the signal of the weight calculation module 700, which is suitable for setting the maximum storage capacity of the memory, and according to the weight priority principle of the weight, the later objects are set to be stored in the disk, The object heat calculation module 900 is connected t...

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 query driving system, a method, a device and a storage medium, and the system comprises a data checking module which is suitable for providing a visual interface, checking data source information, and enabling a data source to generate an object; a query module which is suitable for inputting a data source type, a structured query language statement anda returned file type; an adapter which is in signal connection with the data inventory module and the query module, and is suitable for matching the object, the college object and the structured query language statement according to the type of the data source, generating a query result according to the type of the returned file and outputting the query result; and a return type construction module which is in signal connection with the adapter and is suitable for returning the type file according to the query result. The multi-data-source query driving method is realized by adopting a system, and the multi-data-source query driving device and the storage medium are used for operating the multi-data-source query driving method.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a multi-data source query driving system, method, device and storage medium. Background technique [0002] At present, when querying multiple data sources, whether it is a single data source query or a multi-data source query, the connection drivers for different data sources are different, and the query structured query language statements are also inconsistent, and need to be adapted separately , which increases the cost to the database user. At the same time, the data returned after the query is also different. Especially for non-big data development, how to integrate with existing systems poses a relatively big challenge. Contents of the invention [0003] The present invention aims to solve at least one of the above technical problems. [0004] Therefore, the first object of the present invention is to provide a multi-data source query driving system. [0005]...

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/903G06F16/9032
CPCG06F16/90335G06F16/9032
Inventor 曹志强
Owner YONYOU NETWORK TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com