数据库系统性能优化方法研究

发布时间：2018-03-08 04:05

本文选题：并发访问　切入点：查询优化　出处：《江西理工大学》2017年硕士论文　论文类型：学位论文

【摘要】：随着互联网技术和产业的高速发展,线上网络用户数量呈现井喷式增长,网络中的数据也越来越庞大,这使得对数据的管理也日趋重要。在现实生活中,大量的个人用户、互联网兴趣小组和新型互联网创业公司,普遍通过搭建轻量级的数据库应用系统融入新时代的网络世界。然而,系统在面对大量用户并发访问引发的数据库系统吞吐量增加以及I/O访问频繁等状况时,会导致系统过载、延迟增加甚至系统服务瘫痪的现象。目前用来优化轻量级数据库应用系统的方法普遍存在实现技术难度大、开发周期长等缺点。针对上述问题,为提高和改善轻量级数据库系统并发访问响应性能,在基于原有系统软件和硬件环境不变的情况下,本文围绕数据库系统性能优化方法,主要开展了以下研究工作:(1)对数据库系统性能优化技术进行了概述,在此基础上,根据程序的局部性原理和Cache的设计理念,结合正则表达式以及Java反射机制,提出了一种轻量级的关系数据优化访问算法,详细阐述了算法的提出背景、设计思想、算法描述和执行步骤。(2)在MySQL平台上对算法进行了实验,并对内存SQL查询与磁盘SQL查询的性能进行了比较。实验结果表明,在key值、索引字段和一般字段的并发查询测试中,针对轻量级的关系数据库系统,当处理大量在线网络用户并发查询访问时,本文所提出的算法具有更快的处理速度,能够保证在用户可接受的等待周期内完成查询响应。为轻量级数据库系统性能优化提供了一种重要的解决方案,具有一定的工程应用价值。
[Abstract]:With the rapid development of Internet technology and industry, the number of online network users is blowout, and the data in the network is becoming larger and larger, which makes the data management increasingly important. In real life, a large number of individual users, Internet interest groups and new Internet startups generally integrate into the new era's online world by building lightweight database applications. In the face of the increase of database system throughput caused by a large number of concurrent users and frequent I / O visits, the system will be overloaded. At present, the methods used to optimize the lightweight database application system have the disadvantages of high technical difficulty, long development period and so on. In order to improve the performance of concurrent access response of lightweight database system, based on the original system software and hardware environment, this paper focuses on the optimization method of database system performance. The following research work is carried out: (1) the performance optimization technology of database system is summarized. On this basis, according to the local principle of the program and the design idea of Cache, the regular expression and Java reflection mechanism are combined. A lightweight optimal access algorithm for relational data is proposed. The background, design idea, description and execution steps of the algorithm are described in detail. (2) the algorithm is tested on the MySQL platform. The performance of memory SQL query and disk SQL query is compared. The experimental results show that in the concurrent query test of key value, index field and general field, the performance of the lightweight relational database system is studied. When processing a large number of online network users concurrent query access, the algorithm proposed in this paper has a faster processing speed. It can ensure that the query response can be completed within the acceptable waiting period of the user. It provides an important solution for the performance optimization of lightweight database system and has certain engineering application value.
【学位授予单位】：江西理工大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.13

【参考文献】