连接操作在SIMFS和EXT4上的性能比较

发布时间：2018-06-22 05:57

本文选题：连接操作 + 内存文件系统　；参考：《计算机科学》2016年06期

【摘要】：连接操作是关系数据库系统中最基本、最昂贵的操作,对数据库性能有巨大的影响。由于连接表存放在文件系统中,因此文件系统的性能对连接操作的性能有决定性的影响。不同文件系统的连接操作性能测试对数据库研究有重要意义,但目前相关测试较少。首先对比分析了新型内存文件系统SIMFS(Sustainable In-Memory File System)的数据读写路径与磁盘文件系统EXT4(Fourth Extended File System)I/O路径等方面的差异;然后设计实验测试了不同文件系统对连接操作的影响,其中对SIMFS和EXT4分别设置了不同的数据读写块大小和I/O块大小等测试指标。实验表明,连接操作在SIMFS和EXT4上的性能优化、块大小影响、性能提升瓶颈、硬件约束等方面均存在明显差异。在实验结果比较分析的基础上,给出了针对新型内存文件系统连接操作的优化建议。
[Abstract]:Connection operation is the most basic and expensive operation in relational database system, which has great influence on database performance. Because the join table is stored in the file system, the performance of the file system has a decisive effect on the performance of the join operation. The connection performance test of different file systems is very important to database research, but there are few related tests at present. The differences between the data read-write path of the new memory file system SIMFS (Sustainable In-Memory File system) and the I / O path of the disk file system EXT4 (fourth extended File system) are analyzed, and the effects of different file systems on the connection operation are designed and tested. For SIMFS and EXT4, different data read / write block size and I / O block size are set respectively. The experimental results show that the performance optimization of connection operation on SIMFS and EXT4, the influence of block size, the bottleneck of performance enhancement, and hardware constraints are obvious differences. Based on the comparison and analysis of the experimental results, the optimization suggestions for the connection operation of the new memory file system are given.
【作者单位】：重庆大学计算机学院;信息物理社会可信服务计算教育部重点实验室;
【基金】：“863”国家高技术研究发展计划(2013AA013202,2015AA015304) 国家自然科学基金项目(61472052,61173014)资助
【分类号】：TP333

【相似文献】