Research On Performance And Optimization Of Tax Application System Based On Oracle Database

With the increasing number of database users, the database has become an increasingly large scale. Database application system appears more and more problems, which the user concerned about most is the response of the system. The situation is more serious for the tax department because it produces large amounts of data almost every day. To improve the performance of database systems becomes necessary. In order to solve the problem, different aspects of database performance optimization are studied in this thesis.Firstly, the thesis introduces relevant research background and database performance optimization of the overall structure. Secondly, the thesis describes the concept of performance tuning and optimization, performance evaluation and optimization of several key aspects of the database. And then a weight calculation method based on event processing rates is proposed. Finally, the system which is called China Taxation Administration Information System is optimized in practice. And the SQL statement adjustment, Oracle memory parameter tuning and disk partition adjustment are taken as the main research. Combined with Oracle database experience, the thesis makes depth analysis and study of the adjustment and optimization, summarizes the general Oracle database application system performance optimization method by comparing data before and after optimization. At the same time the method can also provide a method of theoretical study guide.Conclusions and future work prospects are proposed in the end of the thesis. Database performance tuning and optimization is a system project and involves a number of levels.It should be overall arrangement and analyzed,through which can users not only take a method with good application value to guarantee the stability and availability of databases, but also save costs, improve the whole system performance.