【作者】 杜海波；

【导师】 刘连浩；

【作者基本信息】 中南大学 ， 计算机系统结构， 2010， 硕士

【摘要】 随着数据库用户数量的不断增加,数据库的规模变得日益庞大,随之出现的数据库应用系统的问题也越来越多,其中用户最为关心的就是系统的响应问题,特别是对于税务部门,几乎每天都有大量数据产生,提高数据库系统的性能成为必要。正是为了解决这个问题,本文从不同方面对数据库性能优化进行了研究。首先论文从数据库性能调优的论文选题意义入手,介绍了相关研究背景以及数据库性能优化的整体架构；其次阐述了性能调整及优化的概念、相关性能评价指标以及数据库优化的几个主要方面,并提出了基于事件处理速率的权重计算方法；最后联系作者工作中的实际,对中国税收综合征收管理系统进行了优化实践,并将SQL语句调整、Oracle内存参数的调整以及分区技术作为主要研究的内容,结合Oracle数据库的使用经验对调优工作进行了深入分析和研究,并通过优化前后的数据对比总结出Oracle数据库应用系统一般情况下的性能优化方法,同时这些方法也可以对理论研究提供一定的方法指导。在论文的最后,提出了总结及对未来工作的展望,数据库性能调优工作是一项系统工程,它涉及层面较广,因此应统筹规划、全面分析整个系统,采取具有良好应用价值的方法来保障整个系统的高效运行,减少系统开销,提高应用系统的稳定性和可用性。更多还原

【Abstract】 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.更多还原