System of multi-table cross-database joint-query and realization method thereof

A joint query, cross-database multi-table technology, applied in the field of computer applications, can solve problems such as data asynchrony and data cannot be updated in time, achieve the effect of transparent upper-level operations, avoid data inconsistencies, and improve execution efficiency

Active Publication Date: 2018-01-19
G CLOUD TECH
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At this time, the data cannot be updated in time, causing the data to be out of sync; so the data can be shared is the best way to solve the above problems. All business systems use the same data source, which involves the problem of multi-table joint 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
  • System of multi-table cross-database joint-query and realization method thereof
  • System of multi-table cross-database joint-query and realization method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] See figure 1 As shown, the present invention is composed of a compiler, an SQL dialect optimizer, a data cache, a query device and a result set. The query statement is separated into the corresponding database dialect and standard SQL statement through the compiler, the corresponding query statement is executed, and the data is obtained locally by using the data cache. At the same time, if there is new data that needs to be stored in the data cache, the data will be saved in In the second-level cache, to improve the data hit rate.

[0030] If the queryer executes SQL and cannot find the data in the data cache, it will fetch the data from the database. The optimizer optimizes SQL to improve its execution efficiency, and finally executes SQL statements to query tables in different databases, the query results are stored in the data cache, and finally the query device executes the query statements to obtain the desired result set.

[0031] The detailed process of the who...

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 the field of computer application technology, and particularly to a system of multi-table cross-database joint-querying and a realization method thereof. The system comprisesa compiler, an SQL dialect optimizer, a data cache, a querier and a result set. Statements of querying tables of different databases are separated out through the compiler to form independent databasedialects, an SQL is optimized by the optimizer to improve execution efficiency thereof, finally, SQL statements are executed to respectively query the tables of the different databases, obtained query results are stored in the data cache, and finally, the query statements are executed by the querier to obtain the desired result set. Difference of the databases is masked in a whole process of thesystem, and the whole process is transparent for upper-layer operations. The system can be used in multi-table cross-database joint-data-querying of the databases.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a cross-database and multi-table joint query system and an implementation method thereof. Background technique [0002] With the continuous development of the Internet and computer application technology, the popularity of various application systems has led to a surge in data volume. The data of various application systems are independent, forming a large number of data islands. However, businesses need the support of various data. If the data cannot be shared, the data required by each business system needs to be copied to form multiple copies of data. At this time, the data cannot be updated in time, causing the data to be out of sync; therefore, data sharing is the best way to solve the above problems. All business systems use the same data source, which involves the problem of multi-table joint query. Therefore, the association and management of data in diffe...

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/30
CPCG06F16/24552G06F16/2456G06F16/20
Inventor 韩超季统凯
Owner G CLOUD TECH
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