Database query plan optimization system and method

A query plan and database technology, applied in the database field, can solve problems such as inaccurate query and inefficiency, and achieve the effects of improving efficiency, reducing costs, and ensuring reliability

Inactive Publication Date: 2013-02-13
浙江图讯科技股份有限公司
View PDF3 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

While the database records are being refreshed, the continuously updated statistical data is used to optimize the query plan; however, the ascending and descending operations of some stored data are often faster than the updating of the statistical data. At thi

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 plan optimization system and method
  • Database query plan optimization system and method
  • Database query plan optimization system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] Embodiment 1: as figure 1 As shown, a system for optimizing a database query plan includes: a database, a statistical database, a query optimizer, a query component, and a query plan optimization component; the query plan optimization component includes a listening component and an adjustment component; the described The monitoring component detects changes in the database, and the adjustment component submits a query based on the intermediate process to update the statistical database according to the feedback information of the monitoring component. The query optimizer builds a query plan based on the statistical database and completes the query plan through the query component.

[0031] The monitoring component includes an ascending order monitoring component and a descending order monitoring component; the adjusting component includes an upper limit monitor, a lower limit monitor, and a statistical adjuster.

[0032] like figure 2 As shown, a method for optimizing...

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 database technologies and specifically relates to a database query plan optimization system and method. The system comprises a database, a statistical database, a query optimizer, a query assembly and a query plan optimization assembly, wherein the query plan optimization assembly comprises a monitoring component and an adjusting component; the monitoring component is used for detecting the changes of the database; the adjusting component is used for submitting a query based on a middle process according to feedback information of the monitoring component and completing the updating of the statistical database; and the query optimizer is used for constructing a query plan according to the statistical database and finishing the query plan by virtue of the query assembly. The database query plan optimization system and method have the beneficial effects of reducing the cost for executing the plan, avoiding time-consuming data scanning, timely updating statistical data, preventing query contents exceeding a known range, improving accuracy of cardinality estimation so as to improve query efficiency, allowing the optimized query plan to be executed, and ensuring the reliability, accuracy and high efficiency of the query plan.

Description

technical field [0001] The invention relates to database technology, in particular to a system and method for optimizing database query plan. Background technique [0002] In current computer applications, especially in aspects such as libraries and financial industries, the amount of various data is increasing rapidly. In the face of massive data, how to find the optimal result in the database in the shortest time is the focus of data query. [0003] In a relational database system, the optimizer is a module that constructs a query plan, mainly used to determine how the query is executed, and the query cardinality estimation plays an important role in the query optimization process: inaccurate cardinality estimation can lead to suboptimal The plan is selected, and the execution efficiency between the suboptimal and the optimal plan may differ by several orders of magnitude. Due to the large amount of data in the database, the query process works on the data itself, which ...

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): G06F17/30
Inventor 陈明新杨俊杰王斌
Owner 浙江图讯科技股份有限公司
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