利用表分区的大数据库优化方法

Partitioned table used in VLDB optimization

大数据库VLDB(Very Large Database)不仅仅是数据存储的总量大,而且表现在单个表结构记录条数过大。这些都给系统的性能、管理和扩展性带来了挑战。为解决大数据表所带来查询延迟及数据管理的问题,介绍了一种处理大型数据库中大数据表的表分区方法。具体介绍了表分区基本原理和实现方法,同时用具体的实例进行了测试,验证了表分区对数据管理和查询带来的效率提升。

Both gigabytes or terabytes storage and too much records in the individual tables for VLDB results in a challenge on performances, manageability and scalability. Therefore, the partitioned table optimization method was introduced in this paper. Design and implement processes were discussed and the optimization effect proved dramatic through a experimental instance.