Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more