| In recent years, with the rapid development of tourism, the hotel service industry is also changing. Computer services and computer management has been widely used in the hotel industry. With the expansion of the hotel management system database scale, and the number of users and the mount of data of the system increase, so the hotel management system requires higher performance.Database optimization is an effective way to improve system performance and make full use of computer hardware and network equipment.This thesis is based on hotel management system development practices, analyzes how to adjust and optimize Oracle database in huge volume of data to make it in best performance. First analysis and research on the Oracle database performance adjust and optimizethe theoretical foundation and the key technologies, according to the existing problems in the actual use of the hotel management system, this thesis conducted in-depth analysis of these problems.then according to the theoretical of optimize and the problems in actual using,given the method of the Oracle database application system performance optimization which used in hotel managerment system.Mainly including the following four points:first database of the database parameter adjustment and optimization, Second, database input/output physical adjustments. Third optimize the database memory allocation fourth adjust and optimize the SQL query optimization. Finally analysis the experimental results, the experimental results show that these optimi zation methods are better.Through the contrast of actual operation, the operating efficiency of the system’s database which used in hotel managerment system has been greatly improved,the operating speed of the system’s database has been dramatically improved than before which has not optimizated,the operation of the hotel managerment system increase significantly.Thus the quality of hotel services has been further improved. |
PDF Full Text Request