Automatic method and system for realizing database SQL optimization execution based on artificial intelligence

An automated system and artificial intelligence technology, applied in database indexing, neural learning methods, structured data retrieval, etc., can solve the problems of SQL execution efficiency not achieving good results, waste of resources, unable to achieve the expected optimization efficiency, etc. The effect of SQL execution efficiency and improving SQL writing ability

Pending Publication Date: 2021-10-15
上海沄熹科技有限公司
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical task of the present invention is to provide an automatic method and system for realizing database SQL optimization execution based on artificial intelligence, so as to solve the problem that the technical methods existing in the prior art cannot achieve the expected optimization efficiency and the optimized SQL execution efficiency of the prior art method is not high enough. To achieve better results, while causing a waste of 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
  • Automatic method and system for realizing database SQL optimization execution based on artificial intelligence

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0083] The automatic method of realizing database SQL optimization execution based on artificial intelligence of the present invention, this method is to optimize the SQL statement of database table structure and execution according to different database types and rules by artificial intelligence; Specifically as follows:

[0084] S1. Complete the optimization training of SQL statements through artificial intelligence machine learning algorithms, and obtain SQL statements with perfect performance;

[0085] S2. Collect the optimized SQL statements, give regular feedback reports, compare the source SQL statements with the final optimized SQL statements, and give optimization analysis results at the same time.

[0086] In this embodiment, the database table structure optimization method includes the following contents:

[0087] ①. The minimum data type to which the stored data is adjusted;

[0088] ②. Use simple data types;

[0089] ③, the field is not null;

[0090] ④. Reduce...

Embodiment 2

[0116] The automatic system for implementing database SQL optimization based on artificial intelligence of the present invention, the system includes,

[0117] The acquisition unit is used to implement SQL optimization methods and rules through artificial intelligence, and to produce a large amount of data to obtain perfect SQL optimization statements through deep learning and machine learning;

[0118] The optimization unit is used to process the database table structure and SQL according to the neural network model and the evolutionary algorithm to obtain optimized results.

[0119] Preferably, the optimization unit includes,

[0120] Obtaining a module for obtaining a syntax tree structure through a parser;

[0121] Extraction module 1, used to extract table relationships;

[0122] Extraction module 2, used to extract join, where, group and order condition fields;

[0123] The third extraction module is used to extract the table structure information involved in SQL;

...

Embodiment 3

[0140] The embodiment of the present invention also provides a computer-readable storage medium, wherein a plurality of instructions are stored, and the instructions are loaded by the processor, so that the processor executes the automation of database SQL optimization execution based on artificial intelligence in any embodiment of the present invention method. Specifically, a system or device equipped with a storage medium may be provided, on which a software program code for realizing the functions of any of the above embodiments is stored, and the computer (or CPU or MPU of the system or device) ) to read and execute the program code stored in the storage medium.

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 an automatic method and system for realizing database SQL optimization execution based on artificial intelligence, belongs to the technical field of operation and maintenance monitoring, and aims to solve the technical problems that an existing technical method in the prior art cannot achieve expected optimization efficiency and the SQL execution efficiency after optimization of the existing technical method does not achieve a better effect, meanwhile, causes a waste of resources is caused. The method comprises the steps of optimizing a database table structure and an executed SQL statement according to different database types and rules through artificial intelligence; the method specifically comprises the following steps: S1, completing SQL statement optimization training through an artificial intelligence machine learning algorithm to obtain SQL statements with perfect performance; S2, recording the optimized SQL statements, feeding back a report regularly, comparing a source SQL statement and a final optimized SQL statement, and giving an optimization analysis result at the same time.

Description

technical field [0001] The invention relates to the technical field of operation and maintenance monitoring, in particular to an automatic method and system for realizing optimal execution of database SQL based on artificial intelligence. Background technique [0002] With the advent of the era of big data and artificial intelligence, there are more and more database applications, the amount of data processed is gradually increasing, the system is becoming more and more intelligent, and the business logic processed is more complex. According to personal habits and understanding of actual business, the style of SQL written is different, and there is a big gap in SQL execution efficiency. [0003] In the prior art, only query SQL is optimized, such as avoiding full table scan when writing SQL, and establishing indexes for corresponding fields when using where conditions; existing SQL optimization methods rely on manually set rules and specifications. In the era of big data, t...

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): G06F16/242G06F16/2453G06F16/22G06N3/04G06N3/08
CPCG06F16/2433G06F16/2454G06F16/2282G06N3/04G06N3/08
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