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

Query processing method and device

A processing method and query request technology, which is applied in the database field, can solve problems such as waste of system resources, low query request processing efficiency, and large storage capacity, and achieve the effect of improving efficiency

Active Publication Date: 2017-02-08
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, since the storage capacity of the parallel database is usually relatively large, the database re-executes the user's query request, resulting in low processing efficiency of the query request and waste of system resources.

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 processing method and device
  • Query processing method and device
  • Query processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067] In order to make the objectives, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be described clearly and completely in conjunction with the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention. Not all examples. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0068] figure 1 It is a flowchart of Embodiment 1 of the query processing method of the present invention. Such as figure 1 As shown, the method of this embodiment may include:

[0069] S101. Send the first step information for executing the client query request to each data node in the system.

[0070] Specifically, the control node may generate execution plan steps according to the client's query request, and before each step ...

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

Provided are a query processing method and device. The method includes: sending first step information about executing a query request of a client to each data node in a system; receiving a failure message sent by at least one data node, the failure message being used for representing that the execution of the first step has failed or is abnormal; according to preset recoverable information, determining a second step for executing the query request, the second step being a starting step for re-executing the query request, and the recoverable information comprising a step without the need of being re-executed when re-executing the query request; and sending second step information to each data node. The query processing method and device provided in the embodiments of the present invention can improve the efficiency of query processing of a parallel database.

Description

Technical field [0001] The embodiment of the present invention relates to database technology, in particular to a query processing method and device. Background technique [0002] Parallel database is a data management technology that speeds up data query processing by evenly distributing data on multiple data nodes and executing queries in parallel on multiple data nodes. Parallel databases are mainly used for mass data storage. As the number of data nodes increases, the probability of abnormalities in query processing is higher. [0003] In the prior art, if an exception occurs in the process of executing a user's query request in a parallel database, the control node that controls each data node to perform the query operation abandons the query processing being performed by the database. After the error correction processing ends, the control node restarts Control each data node to execute the user's query request. [0004] However, because the storage capacity of a parallel dat...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F11/1402
Inventor 曹莉吴向阳
Owner HUAWEI CLOUD COMPUTING TECH CO LTD
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