Database query optimization method, medium and equipment

A data query and optimization method technology, applied in the field of database query, can solve problems such as slow query speed, inability to execute operators, and inability to allocate computing resources by operators

Inactive Publication Date: 2018-11-23
SHENZHEN AUDAQUE DATA TECH
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the prior art, when in the concurrent state, the corresponding operators cannot be executed according to the optimal operation sequence, and reasonable computing resources cannot be allocated to the operators, resulting in slow query speed

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
  • Database query optimization method, medium and equipment
  • Database query optimization method, medium and equipment

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0029] Please refer to figure 1 , figure 1 It is a flow chart of a database query optimization method provided in a specific embodiment of the present invention. The database query optimization method provided in this embodiment includes:

[0030] Step S101: Obtain the data query statement input by the user.

[0031] Step S102: Generate a directed acyclic graph with the operators as nodes according to the dependency relationship of each operator in the data query statement.

[0032] Step S103: According to the directed acyclic graph, determine the operation sequence of the operators and the processor that executes each of the operators.

[0033] Step S104: Query corresponding data according to the determined operation sequence and the processor.

[0034] The present invention is suitable for computers to process SQL query statements concurrently, that is, when the amount of relational data is greater than the number of concurrent computers.

[0035] By obtaining the data q...

no. 2 example

[0056] In the above-mentioned first embodiment, a method for optimizing database query is provided. In combination with the above-mentioned first embodiment, the second embodiment of the present invention provides a computer-readable storage medium on which a computer program is stored. When executed by the processor, the database query optimization method provided by the above-mentioned first embodiment is realized.

[0057] It can be seen from the above technical solution that the computer-readable storage medium provided by this embodiment can obtain the data query statement input by the user under the control of the processor, and then generate equivalent The directed acyclic graph with the operator as the node, and then according to the directed acyclic graph, the operation sequence of the operator and the corresponding execution processor can be determined. Finally, according to the allocated processor and the operation sequence, the corresponding data. By determining t...

no. 3 example

[0059] In combination with the database query optimization method provided in the first embodiment, the present invention also provides a database query optimization device, including: a memory, a processor, and a computer program stored in the memory and operable on the processor. When the processor executes the program, the database query optimization method provided by the first embodiment above is implemented.

[0060] It can be known from the above technical solution that the computer device provided by this embodiment can generate equivalent directed The acyclic graph, and then according to the directed acyclic graph, can determine the operation sequence of the operator and the corresponding execution processor. Finally, the corresponding data can be queried according to the allocated processor and operation sequence. By determining the most reasonable operation sequence and processor, the speed of data query can be improved in the state of data concurrency, thereby opti...

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 database query optimization method, a medium and equipment. The method comprises the following steps of: obtaining a data query statement input by a user; generating a directed acyclic graph taking operators in the data query statement as nodes according to a dependency relationship of the operators; determining an operation sequence of the operators and a processor for executing each operators according to the directed acyclic graph; and querying corresponding data according to the determined operation sequence and the processor. According to the method, the most reasonable operation sequence and processor are determined, so that the data query speed can be improved under a data concurrent state, and then the data query process is optimized.

Description

technical field [0001] The invention relates to the technical field of database query, in particular to an optimization method, medium and equipment for database query. Background technique [0002] With the continuous development of informatization, in various fields, data is showing an explosive growth trend. When querying data, it often encounters multiple concurrent situations. In the prior art, when in a concurrent state, the corresponding operators cannot be executed according to the optimal operation sequence, and reasonable computing resources cannot be allocated to the operators, resulting in a slow query speed. Contents of the invention [0003] Aiming at the defects in the prior art, the present invention provides an optimization method, medium and equipment for database query, which can improve the speed of data query and further optimize the data query process under the state of data concurrency. [0004] In a first aspect, the present invention provides a me...

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
Inventor 于文渊于海龙贾西贝
Owner SHENZHEN AUDAQUE DATA 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