Analysis on the Optimization Technology of Oracle Relational Data Base

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 user's 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.