Data query method and device, equipment and storage medium

A data query and equipment technology, applied in the direction of electrical digital data processing, special data processing applications, digital data information retrieval, etc., can solve problems such as the influence of database performance overhead and the influence of query efficiency on the order of arrangement, so as to reduce the impact of performance overhead and improve The effect of data query efficiency

Active Publication Date: 2020-08-07
SHANGHAI DAMENG DATABASE
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the existing databases that implement the UNION ALL function implement the SETUA operator, they generally schedule each sub-plan of SETUA serially, because the SETUA operator will return data to the parent operator when obtaining a batch of data from the left child operator , therefore, when the execution time of different child plans is quite different, the query efficiency of the SQL statement containing UNION ALL is affected by the arrangement order of the child plans
In addition, when the SETUA operator obtains the data sent by the sub-plan and sends it to the upper-level operator, it needs to copy the data once in the memory buffer of the operator, which has a great impact on the performance overhead of the database in a distributed environment.

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
  • Data query method and device, equipment and storage medium
  • Data query method and device, equipment and storage medium
  • Data query method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0035] figure 2 It is a flow chart of a data query method provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of realizing union set operation in a distributed database. The method can be executed by a data query device, and the device can use hardware and / or software, see figure 2 , the embodiment of the present invention may generally include the following steps:

[0036] Step 101, determine at least one sub-execution plan corresponding to the SQL query statement.

[0037] Among them, the SQL query statement is a database query and programming language, which is used to access data and query, update and manage database systems. The sub-execution plan may be a query plan executed by each node in the distributed database, and the sub-execution plans jointly realize the query target of the SQL query statement. Each sub-execution plan can be implemented by a database instance, and multiple database instances can jointly execute a sub...

Embodiment 2

[0047] image 3 It is a flow chart of a data query method provided by Embodiment 2 of the present invention. The embodiment of the present invention is based on the above-mentioned embodiment, and the sub-execution plan is adjusted through the positional relationship of the union set operator in the sub-execution plan. , see image 3 , the data query method of the embodiment of the present invention includes:

[0048] Step 201, receiving an SQL query statement input by a user.

[0049] The embodiment of the present invention is applicable to a distributed database system. A user logs in to a node of the distributed database system. This node may be a specially designated node in the distributed database system, or any node in the distributed database. This node is responsible for receiving user The SQL query statement.

[0050] Step 202, generating an execution plan after performing syntax analysis and semantic analysis on the SQL query statement.

[0051] Specifically, pe...

Embodiment 3

[0079] Figure 8 It is a schematic structural diagram of a data query device provided in Embodiment 3 of the present invention, which can execute the data query method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method. The device can be implemented by software and / or hardware, and specifically includes: a plan determination module 301 , a plan adjustment module 302 and a data query module 303 .

[0080] The plan determination module 301 is configured to determine at least one sub-execution plan corresponding to the SQL query statement.

[0081] A plan adjustment module 302, configured to adjust each of the sub-execution plans according to the union set operator.

[0082] The data query module 303 is configured to send each of the adjusted sub-execution plans to the execution nodes for execution to realize data query.

[0083] In the embodiment of the present invention, the sub-executi...

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 discloses a data query method and device, equipment and a storage medium. The method comprises the following steps: determining at least one sub-execution plan corresponding to an SQL query statement; adjusting each sub-execution plan according to a union set operator; and sending the adjusted sub-execution plan to an execution node for execution so as to realize data query. According to the embodiment of the invention, the sub-execution plan is adjusted based on the union set operator, the query waiting time and the memory copying frequency caused by union set operation are reduced, the data query efficiency is improved, and the user experience is improved.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer application technology, and in particular, to a data query method, device, device and storage medium. Background technique [0002] The union set operation UNION ALL in the database structured query language (Structured Query Language, SQL) statement, this operation is used to combine the query results of each SQL statement query branch and return, UNION ALL will not generate union data for any processing. [0003] When realizing the function of union set operation UNION ALL in the existing database management system, a special operator is generally defined to realize the related functions of UNION ALL. For example, the operator of union set operation UNION ALL is set as SETUA, namely Use the SETUA operator to implement the UNION ALL union set operation function in the user SQL statement. However, when the existing databases that implement the UNION ALL function implement the SE...

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
IPC IPC(8): G06F16/2453G06F16/2455
CPCG06F16/24544G06F16/24558Y02D10/00
Inventor 宋鑫韩朱忠
Owner SHANGHAI DAMENG DATABASE
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