计算机与现代化Issue(5):10-13,4.DOI:10.3969/j.issn.1006-2475.2012.05.004
一种基于多连接属性划分的查询优化算法
A Query Optimization Algorithm Based on Multiple Join Attribute
摘要
Abstract
Database query operation is the most common operation. Because the data in a distributed database is distributed and redundant, query optimization study of a distributed database is one of the core issues. In order to improve the efficiency of distributed database queries, the paper analyzes and discusses the common implementation strategy based on the direct-join, and presents an improved direct-join query optimization strategy for the distributed database applications for multi-table joins when there are multiple connection properties. Improved algorithm improves query execution parallelism, reduces the query processing time and improves the query efficiency.关键词
分布式数据库/直接连接/查询优化/多连接属性/算法Key words
distributed database/ direct-join/ query optimization/ multiple join properties/ algorithm分类
信息技术与安全科学引用本文复制引用
褚龙现,申远..一种基于多连接属性划分的查询优化算法[J].计算机与现代化,2012,(5):10-13,4.基金项目
河南省教育厅自然科学研究计划项目(2010C520010) (2010C520010)