Oracle relational database as the research object

the efficiency of performance optimization analysis. Firstly

the main part of SQL database query statement function

using the MathSQL statement to adjust the thought

the reasoning machine

knowledge base and rule base on database query function adjustment; based on the knowledge stored

a problem with the SQL statement. Applying the inference engine will ask The title statement is compared with the statement in the knowledge base

and the performance of the SQL statement is judged. Secondly

the ant optimization theory is used to optimize the query function of SQL statements

and the artificial ant optimization starting point is set according to the users query requirements

and the ant selects the target path according to the distribution of the statement. Leave pheromone and realize pheromone update process

make ants form the shortest path of query SQL statement in the course of moving

so as to achieve the purpose of optimizing database. The efficiency of database operation is improved by optimizing and adjusting the method in this paper.