| 分布式数据库分片关系变换查询优化 |
| |
| 引用本文： | 陈晓明.分布式数据库分片关系变换查询优化[J].电子设计工程,2011,19(8):44-46. |
| |
| 作者姓名： | 陈晓明 |
| |
| 作者单位： | 广东司法警官职业学院,广东广州,510520 |
| |
| 摘 要： | 基于分布式查询的概念和优化要求,结合实际的信息管理系统分片查询的实践,描述分布式数据库分片查询时建立、查询对关系表达式的等价变换实现查询的优化方法.通过建立查询优化树,研究典型教务管理系统数据库分片查询优化的关系变换方法,验证分片条件与查询选择条件优化查询树的片段,获得减少操作以达到查询优化效果,导出分片查询优化的一种...
|
| 关 键 词： | 分布式数据库 等价变换 查询 优化 |
Query optimization of distribute database division on relations transformation |
| |
| CHEN Xiao-ming.Query optimization of distribute database division on relations transformation[J].Electronic Design Engineering,2011,19(8):44-46. |
| |
| Authors: | CHEN Xiao-ming |
| |
| Affiliation: | CHEN Xiao-ming(Guangdong Justice Police Vocational College,Guangzhou 510520,China) |
| |
| Abstract: | Based on the concepts and optimize requirements of distributed queries,combined with the practice of distributed query of information management systems,this article described a query optimization method which was realized by building and querying equivalent transformation to relation expression in distribute database division.Through establishing a query optimizer tree,this paper researched the relation transformation of division query optimiaztion in typical educational administration management system database,validated query optimizer tree division by query and distribute,optimized effects of query optimization by reducing operation,and exported a method of query optimization of distribute. |
| |
| Keywords: | distribute database equivalent transformation query optimization |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
