上海市垃圾物流管理平台数据库优化策略的设计与实现

发布时间：2018-10-30 13:18

【摘要】：随着互联网应用和计算机信息系统的不断发展，数据库的应用范围越来越广泛。伴随着数据库规模不断地扩大，业务复杂程度不断地增加，数据库系统的性能问题越来越突出，对数据库性能进行优化也变得十分重要。本文根据上海市垃圾物流管理平台的运行状况，，结合MySQL优化技术，对数据库性能问题进行了深入分析，寻找出了造成性能降低的各种原因。根据分析出的问题原因，提出了具体的数据库优化策略。本文作者的主要研究内容和创新点概述如下： 1）分表技术的应用研究。分析了数据库分表的两种方案及其适用场景，根据系统中大数据表的特点，采用了水平分表的方案。 2）服务器配置优化的应用研究。硬件方面，在分析了不同磁盘阵列的原理和应用场景之后，采用RAID10的磁盘阵列策略。软件方面，通过改善服务器配置，提高数据库的并发性处理能力和缓存命中率。 3）SQL语句及索引优化的应用研究。在分析了SQL语句和索引优化的基本方法后，针对系统中的慢查询语句进行了优化。 4）Hibernate优化的应用研究。分析了J2EE系统中主流的持久层框架Hibernate的缓存机制，并提出了提升Hibernate缓存利用率的方法。 5）数据库备份恢复策略的应用研究。根据应用系统特性，研究设计了基于Linux定时任务机制的自动备份策略。本文的研究工作已经完成，提出的数据库优化策略在实践中得到了实际检验。实践结果表明，本文提出的优化策略对于关系型数据库性能优化方面具有积极的借鉴意义。
[Abstract]:With the development of Internet and computer information system, the application of database is more and more extensive. With the expansion of database scale and the increase of business complexity, the performance problem of database system becomes more and more serious, so it is very important to optimize database performance. According to the running situation of the garbage logistics management platform in Shanghai and the MySQL optimization technology, this paper makes a deep analysis of the database performance problems, and finds out the various causes of the performance degradation. According to the analysis of the causes of the problems, a specific database optimization strategy is put forward. The main research contents and innovations of this paper are summarized as follows: 1) the applied research of tabular technology. In this paper, two schemes and their applicable scenarios are analyzed. According to the characteristics of large data table in the system, the scheme of horizontal table is adopted. 2) the application research of server configuration optimization. In the aspect of hardware, after analyzing the principle and application scenario of different disk array, RAID10's disk array strategy is adopted. Software, through improving server configuration, improve database concurrency processing ability and cache hit rate. 3) the application research of SQL statement and index optimization. After analyzing the basic methods of SQL and index optimization, the slow query statements in the system are optimized. 4) the application of Hibernate optimization. This paper analyzes the caching mechanism of Hibernate, the mainstream persistence layer framework in J2EE system, and puts forward a method to improve the utilization rate of Hibernate cache. 5) Research on the application of database backup recovery strategy. According to the characteristics of the application system, an automatic backup strategy based on Linux timing task mechanism is designed. The research work in this paper has been completed, and the proposed database optimization strategy has been tested in practice. The practical results show that the proposed optimization strategy has positive reference significance for the performance optimization of relational database.
【学位授予单位】：东华大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.13

【相似文献】