System and method for database query optimization

A query optimization and database technology, applied in the field of database query, can solve the problems of manpower consumption, optimization effect depends on, unable to obtain effective guarantee, etc., to achieve the effect of ensuring optimization effect, reducing query time, and improving query efficiency

Inactive Publication Date: 2017-07-04
WUHAN LUOJIA WEIYE TECH CO LTD
View PDF8 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But the existing query optimization mainly adopts manual tuning, the database management system provides some adjustable resource parameters to the database administrator, and the database administrator adjusts these resource parameters according to experience and current load characteristics, so as to achieve the purpose of query optimization; It requires manpower, and the optimization effect depends on the experience of the database administrator, and cannot be effectively guaranteed

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
  • System and method for database query optimization
  • System and method for database query optimization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0055] Such as figure 1 As shown, a database query optimization system described in Embodiment 1 of the present invention includes a select syntax optimization module, a join syntax optimization module, a where clause optimization module and an aggregation function optimization module;

[0056] The select syntax optimization module is used to inquire whether the sql statement to be optimized includes select* syntax; if yes, replace * in the select* syntax with the query target field according to the query requirements of the sql statement to be optimized, Then drive the join syntax optimization module to work; if not, directly drive the join syntax optimization module to work;

[0057] The join syntax optimization ...

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 a system and method for database query optimization. The system comprises a select grammar optimization module, a join grammar optimization module, a where clause optimization module and an aggregate function optimization module. The invention has the beneficial effects that the database query optimization system is provided; a sql statement with long query time and low query efficiency is re-written; an index is established for columns which need to be screened or sequenced and are related to the sql statement; dynamic self-adjustment and self-optimization of the sql statement can be achieved; optimization effects can be ensured; query results are not influenced after optimization; query time is effectively reduced; and query efficiency is increased.

Description

technical field [0001] The invention relates to the technical field of database query, in particular to a database query optimization system and method. Background technique [0002] With the development of information technology and Internet technology, enterprise information systems are increasingly involved in enterprise management. Efficiently managing large amounts of data is critical to most computer applications. Database management system is a system software that allows single or multiple users to manage and manipulate large amounts of data conveniently and effectively. As a standard tool for data processing and management, it has gradually become the foundation and core of modern information systems. In order to make the information system run stably and efficiently in various fields, one of the most important aspects is to ensure the access performance of the database. But at the moment when the amount of information and data is increasing rapidly, the data tran...

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/2228G06F16/2433G06F16/24537
Inventor 彭凯李俊峰马威
Owner WUHAN LUOJIA WEIYE 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