燃料信息数据库性能的优化方法研究

发布时间：2018-12-18 14:31

【摘要】：数据库技术是计算机数据处理与信息管理系统的核心,随着数据库使用领域和规模的不断扩大,数据库系统的性能问题也越来越严重,保证数据库应用系统正常高效运行是一项重大的挑战。因此,对于提高应用系统的运行效率,数据库性能优化的研究具有非常重要的意义。在分析了数据库性能优化的国内外研究现状之后,针对燃料信息系统长期运行可能出现的性能问题,提出了两类数据库性能调整与优化的方案。第一类方案是调整数据库内存参数,通过分析数据库的访问方式以及缓存对SQL语句执行的影响,选择需要调整的内存参数,对内存参数和数据库性能建立数学模型,采用二次曲线拟合,使用贪心算法依次求出每个参数的最优值,通过局部最优求解全局最优。第二类方案是对可能需要分区的表进行分区,依据表中数据的存储特性选择分区方法,根据表的结构以及表上的查询特性制定能提高数据库性能的表分区策略,并通过程序实现了表的分区。设计并实现了一款数据库性能监控系统,以折线图的形式实时展示数据库的四种性能信息。通过图形化界面支持数据库内存参数的调整,使用程序来进行数学建模并且求解局部最优的内存参数值。系统实现了表分区,支持批量的表分区操作,并按照制定的分区策略推荐给用户适合所有适合分区的表。
[Abstract]:Database technology is the core of computer data processing and information management system. With the continuous expansion of the field and scale of database use, the performance of database system becomes more and more serious. It is a great challenge to ensure the normal and efficient operation of database application system. Therefore, the research of database performance optimization is of great significance to improve the efficiency of application system. After analyzing the research status of database performance optimization at home and abroad, two kinds of database performance adjustment and optimization schemes are put forward in view of the possible performance problems in the long run of fuel information system. The first scheme is to adjust the memory parameters of the database. By analyzing the access mode of the database and the effect of the cache on the execution of SQL statements, the memory parameters that need to be adjusted are selected, and the mathematical model of the memory parameters and the performance of the database is established. By using quadratic curve fitting and greedy algorithm, the optimal value of each parameter is obtained in turn, and the global optimum is solved by local optimization. The second scheme is to partition tables that may need partitioning. According to the storage characteristics of data in the table, the partitioning method is selected. According to the structure of the table and the query characteristics on the table, the table partitioning strategy can improve the performance of the database. And through the program to achieve the partition of the table. A database performance monitoring system is designed and implemented. Four kinds of database performance information are displayed in the form of broken line graph. The adjustment of database memory parameters is supported by graphical interface, and the program is used to model and solve the local optimal memory parameters. The system implements table partitioning, supports batch table partitioning operations, and recommends all tables suitable for partitioning according to the partitioning policy.
【学位授予单位】：华中科技大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.13

【参考文献】