Query method for distributed deployed heterogeneous database

A data query and database technology, applied in the field of database query, can solve problems such as inability to cope with high load and high concurrency, slow efficiency, system crash, etc., to enhance stability and query efficiency, improve return speed, and solve high load and high Effects of concurrency problems

Active Publication Date: 2016-08-31
CNIS TECH CO LTD
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Aiming at the drawbacks of existing relational database query methods, which are slow in efficiency, easily lead to system crashes, and unable to cope with high load and high concurrency problems, the present invention provides a query method for distributed deployment of heterogeneous databases. The method includes:

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
  • Query method for distributed deployed heterogeneous database
  • Query method for distributed deployed heterogeneous database
  • Query method for distributed deployed heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] figure 1 It is a flowchart of a query method for a heterogeneous database distributed in an embodiment of the present invention; as figure 1 As shown, the method includes:

[0044] S1: Receive the database query request of the application;

[0045] The query request includes query information for obtaining query results from the heterogeneous database;

[0046] S2: Determine the query type of this database query according to the query information;

[0047] S3: Determine whether the query request is an initial request according to the query information;

[0048] Specifically, the database query request may be a request sent by the user through the application client to query data information, and the query information included may include at least one of the following or a combination thereof: keywords of the data to be queried, Question statement, query type (such as sorted query and non-sorted query), and initial request identification. Therefore, it can be judged...

Embodiment 2

[0055] On the basis of the first embodiment, the database query method provided in this embodiment may specifically include:

[0056] S6: Store the remaining query result sets in the result set into the cache.

[0057] On this basis, in this embodiment, after step S3 always judges whether the query request is an initial request based on the query information, it may specifically include:

[0058] S32 If the query request is not an initial request, obtain and send a preset number of query results from the cache according to the query type to the application program, and store the remaining query results in the cache.

[0059] Specifically, if the query request is not an initial request, the query request is determined as a "page turning" request, so as to obtain a preset number of query results from the cache according to the determined query type, and send them to the application program, At the same time, the remaining query results are stored in the cache.

Embodiment 3

[0061] In this embodiment, on the basis of Embodiment 1 and Embodiment 2, in step S5, according to the query type, a preset number of query results are obtained from the result set and sent to the application program, which may also specifically include:

[0062] S51: If the query type is a sorting query, sort all the query results in the result set according to preset rules, so as to obtain the preset number of query results from the result set according to the sorting results to the application program.

[0063] For example, the preset rule can be set as time order, similarity, location information and so on. Based on this feature, the data query results can better meet user requirements and improve the accuracy of data query.

[0064] Further, in step S51, after sorting all query results in the result set according to preset rules, so as to obtain the preset number of query results from the result set according to the sorting results to the application program, it may also...

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 query method for distributed deployed heterogeneous database. The query method includes the following steps: receiving a database query request of an application program; determining a query type of this database query according to query information; determining if the query request is a primary request or not according to the query information; starting up a first thread corresponding to each query module of a query module set if so, and allowing each first thread to call a query interface of the corresponding query module to query data according to the query type; dividing query results of all the first thread according to the query module to which the first threads belong, and determining a result set according the dividing result; and acquiring a preset number of query results from the result set and sending the preset number of query results to the application program according to the query type. The query method can solve the problem of high load and high concurrency of the conventional data query system, improve the return speed of the query results, and then enhance the stability and the query efficiency of the system.

Description

technical field [0001] The present invention relates to the technical field of database query, in particular to a query method for heterogeneous databases in distributed deployment. Background technique [0002] With the rapid development of the Internet, telecommunications, finance and other industries, the era of massive data has come, and the data volume of various businesses continues to grow, making the industrial application system need to process and store more and more data, and the requirements for system performance are also increasing. Just getting higher and higher. [0003] In this context, although there are many solutions for big data processing, such as hadoop, due to business needs, most traditional industry application systems still use relational databases. The existing single relational database can no longer meet the growing needs of various industries, so splitting data into multiple databases is an inevitable choice. However, when traditional industr...

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/2471
Inventor 付君辉李宏伟代宏伟
Owner CNIS TECH CO LTD
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