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

Multi-source data query method and system

A technology of multi-source data and query methods, applied in the database field, can solve the problems of inability to perform accurate query and reduce the effectiveness of data query, and achieve the effect of simplifying development and improving security.

Pending Publication Date: 2018-03-20
STATE GRID ZHEJIANG ELECTRIC POWER +2
View PDF6 Cites 40 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The current data query is mainly based on Structured Query Language (SQL), but the query process can only be carried out for one or a single database, and it is often impossible to accurately query cross-database data of various types and quantities. query, which reduces the effectiveness of data 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-source data query method and system
  • Multi-source data query method and system
  • Multi-source data query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] The present invention provides a query method for multi-source data. The query method is used to provide data access responses between the business application layer and the database, such as figure 1 As shown, the query method includes:

[0045] 11. Receive the data access request from the business application, forward the access request to the data access component, and the data access component extracts the transmission parameters in the access request, and judges the transmission parameters;

[0046] 12. When the judgment result shows that the data access is a cross-database data request, the data access component forwards the data access request to the distributed data query engine;

[0047] 13. Let the distributed data query engine connect to the multiple data sources corresponding to the data access request, obtain the query result corresponding to the data access request from the multiple data source, and forward the query result to the data access component, so...

Embodiment 2

[0066] The embodiment of the present application also provides a query system 2 for multi-source data, the query method is used to provide data access responses between the business application layer and the database, such as figure 2 As shown, the query system 2 includes:

[0067] The service access application program interface 21 is used to receive a data access request from a business application, forward the access request to the data access component, and the data access component extracts the transmission parameters in the access request, and judges the transmission parameters;

[0068] The JDBC HUB engine container module 22 is used to make the data access component forward the data access request to the distributed data query engine when the judgment result shows that the data access is a cross-database data request;

[0069] The application database driver layer 23 is used to connect the distributed data query engine to multiple data sources corresponding to the dat...

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 provides a multi-source data query method and system, and belongs to the field of database. The multi-source data query method includes the steps that a data access request of service application is received and forwarded to a data access assembly, and the data access assembly judges pass parameters in the access request; when the judgment result indicates that data access is a cross-database data request, the data access request is forwarded to a distributed data query engine; a multi-data source corresponding to the data access request is connected, and a query result corresponding to the data access request is obtained from the multi-data source and forwarded to the data access assembly, so that a data forwarding assembly directly transmits the query result to the serviceapplication. By building a logic database, direction connection between the service application and the database is isolated, and therefore data access safety is improved; abstract development serviceis provided, and data management and application development are simplified; correlated query between physical cross-database sheets is supported, and cross-database multi-source data query is achieved.

Description

technical field [0001] The invention belongs to the field of databases, in particular to a query method and system for multi-source data. Background technique [0002] With the continuous development of cloud computing and big data technology, the informatization level of the power industry, which is a national pillar industry, is also continuously improving. The core business systems and data centers have accumulated massive amounts of data. Therefore, how to effectively query and apply data has become It is an important topic in the research of electric power industry informatization. [0003] The current data query is mainly based on Structured Query Language (SQL), but the query process can only be carried out for one or a single database, and it is often impossible to accurately query cross-database data of various types and quantities. Query, thus reducing the effectiveness of data query. Contents of the invention [0004] In order to solve the shortcomings and def...

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): G06F17/30G06F21/54
CPCG06F16/2433G06F16/2452G06F16/2471G06F16/256G06F16/27G06F21/54
Inventor 王锋华钱仲文张旭东黄建平夏洪涛成敬周祝春捷陈俊方凌斌潘坚跃陈浩吕旭芬纪德良王仲锋王政
Owner STATE GRID ZHEJIANG ELECTRIC POWER
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