查询重写关系数据库查询优化技术  

Query Rewriting Relational Database Query Optimization Technology

作　　者：陈启才 

机构地区：[1]广西河池民族农业学校,宜山546300

出　　处：《电脑编程技巧与维护》2009年第4期40-42,共3页Computer Programming Skills & Maintenance

摘　　要：随着数据仓库技术应用越来越广泛,数据仓库中查询使用频率也越来越高,基于查询重写的关系数据库查询优化技术,通过视图重写、子查询合并、等价谓词替换、使用临时表、以及用集合运算UNION代替逻辑运算OR等技术的使用。本文详细讨论了数据库查询优化器中查询重写模块的设计与实现;探讨了XML、SQL语句等查询重写方法。With the data warehouse technology more and more extensive, data warehouse query is also getting higher and higher frequency of use, based on the query rewriting relational database query optimization technology, through the view rewritten subquery merging predicate equivalent replacement, the use of temporary tables, as well as a set to replace UNION operator OR logic operations such as the use of technology, this article discussed in detail the database query optimizer query rewrite module design and implementation of XML, SQL statements, such as query rewriting method.

关 键 词：查询重写 数据库 查询优化 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论] TP311[自动化与计算机技术—计算机科学与技术]