采用达梦数据库分区优化技术的实验设计

Experimental Design Using Dameng Database Partition Optimization Technology

在分析数据库系统性能评价指标的基础上,针对磁盘I/O访问这一主要性能评价指标,对数据库分区技术及几种分区类型进行了简要介绍,并简要介绍了数据库分区技术适用的业务场景。在简要介绍国产化达梦数据库的优势后,通过采用达梦数据库进行实验,对比分析了在大数据量场景下,采用和不采用数据库分区技术时的数据库查询响应时间,验证了采用数据库分区技术能够有效提升数据库系统性能。

Based on the analysis of the performance evaluation indicators of the database system,the database partition technology and several types of partition types,as well as the applicable business scenarios of the database partition technology are briefly introduced aiming at the main performance evaluation indicator of disk I/O access.After introducing the advantages of the domestic Dameng database,the experiment conducted by using the Dameng database is used to compare and analyze the database query response time with or without the database partition technology in the big data volume scenario,which verifies the use of the database partition technology can effectively improve the performance of the database system.