基于查询优化的并行数据库自动数据划分设计

AUTOMATING DATABASE DESIGN OF PDBMS BASED ON OPTIMIZER

课题是通过开发一个支持数据并行处理的中间件 ,将机群并行计算机各节点上的单机版IBMDB2数据库联系起来 ,并行工作 ,以获得接近并行数据库的性能 .本文对并行数据库系统中数据的自动划分进行了大胆的尝试 ,建立了一个基于DB2查询优化程序的自动划分工具 ,以减轻数据库管理员的负担 ,避免初始数据倾斜 。

This research project wish to develop a middleware, which can support data parallel process of a number of IBM DB2 systems. Then obtains performance close to PDBMS.In this paper, we also attempt to the automated data partition for PDBMS. We established a tool based on the DB2 inquiry optimization program, which can relase the burden of DBA and avoids the initial data skew, had certain innovation.