Open AccessResearch on Search Optimization Based on Oracle Database
Author(s) -
Huanmei Wu,
Caijun Cheng
Publication year - 2020
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1648/4/042047
Subject(s) - computer science , oracle , database , physical data model , database tuning , view , oracle unified method , sql , database design , query optimization , database model , relational database , stability (learning theory) , database schema , relational database management system , data mining , information retrieval , query by example , web search query , search engine , software engineering , machine learning
With the continuous progress of human civilization, the whole society has accelerated the process of informatization. With the continuous enrichment of social life, a large number of information data are produced every day. In order to meet the information needs of financial, administrative and other fields, Oracle database technology is applied, and its efficient and accurate data query features give powerful help to all walks of life. However, with the increasing amount of information, the structure of Oracle database system becomes more complex and chaotic, and even has a serious impact on the stability of the database. In order to improve the stability of Oracle database and further improve the performance of data search, this paper studies the optimization of search based on Oracle database. This paper mainly studies the optimization scheme of the physical layer and software layer of Oracle system, and optimizes the SQL statement after adjusting the hardware structure of the system. Through the simulation, it is found that the stability of database and the response time and accuracy of search query can be improved by improving the structure of database server and optimizing SQL statements.