摘要
本文提出使用表分区技术来提高海量地质数据查询速度,在介绍表分区工作原理的基础上,给出了常用的两种表分区技术—范围分区和列表分区,并以新疆塔里木盆地的测井数据作为原始数据,分别进行常规表和分区表的查询测试,范围分区表和列表分区表比常规表查询效率分别提高了30%和26%。结果表明,在访问海量地质数据时使用表分区技术能缩短搜索时间、有效组织数据并合理利用磁盘空间,从而达到优化性能的目的。
The authors proposed to use the technology of table partition to improve the speed of inquiring data. On the foundation of introducing the work principle of table partition, it was given the two usual table partitioning technology-range partition and list partition. Carrying on the search test separately to conventional table and partition table used logging data from Xinjiang Tarim Basin as the original data. Comparing range partition table and list partition table with conventional table, the search efficiency increases 30 percent and 26 percent, respectively. The results imply that using the technology of table partition can reduce the search time, organize the data effectively and make use of the disc space reasonably, so as to achieve the purpose of optimizing capability as accessing the massive geological data.
出处
《世界地质》
CAS
CSCD
2008年第1期100-104,共5页
World Geology
基金
"金土工程"子项目"我国石油
煤炭
铁矿
钾盐矿产资源潜力数据库建设(JTXM-DW-KZ4)
塔里木盆地重要蒸发岩坳陷成盐及油气生储条件研究(41005050002)
国土资源部大调查专项(1212010633901)
关键词
海量地质数据
性能优化
范围分区
列表分区
massive geological data
performance optimization
range partition
list partition
