[1]王能斌,朱强.关于MicroSQL查询等价的若干定理及查询变换优化策略[J].东南大学学报(自然科学版),1986,16(5):44-53.[doi:10.3969/j.issn.1001-0505.1986.05.006]
 Wang Nengbin,Zhu Qiang.Some Theorems Relating to the Equivalence of Micro SQL Query Statements and Optimization via Query Transformation[J].Journal of Southeast University (Natural Science Edition),1986,16(5):44-53.[doi:10.3969/j.issn.1001-0505.1986.05.006]
点击复制

关于MicroSQL查询等价的若干定理及查询变换优化策略()
分享到:

《东南大学学报(自然科学版)》[ISSN:1001-0505/CN:32-1178/N]

卷:
16
期数:
1986年第5期
页码:
44-53
栏目:
本刊信息
出版日期:
1986-09-20

文章信息/Info

Title:
Some Theorems Relating to the Equivalence of Micro SQL Query Statements and Optimization via Query Transformation
作者:
王能斌朱强
南京工学院计算机科学与工程系
Author(s):
Wang Nengbin Zhu Qiang
Department of Computer Science Engineering
关键词:
计算机软件 关系数据库 查询语言 查询优化 等价变换
Keywords:
computer software relational database query language query optimization equivalence transformation
分类号:
+
DOI:
10.3969/j.issn.1001-0505.1986.05.006
摘要:
Micro SQL是微机关系数据库管理系统NITDB采用的数据语言。为了进行查询优化,本文对Kim W.的思想加以推广,从理论上提出了若干关于Micro SQL查询的等价定理,并把一些结果运用到NITDB中,从而为NITDB提供了一种查询变换优化措施,提高了查询效率。
Abstract:
Micro SQL is a data language used in NITDB, a relationai DBMS on microcomputer. In order to optimize queries, some theorems relating to the equivalence of Micro SQL query statements are given in this paper by extending the idea presented in the paper of Kim W. Some of the results have been used in NITDB and an optimization strategy via query transformation was developed in NITDB to make query processing more efficient.

相似文献/References:

[1]邓小鹏,周志鹏,李启明,等.地铁工程Near-miss知识库构建[J].东南大学学报(自然科学版),2010,40(5):1103.[doi:10.3969/j.issn.1001-0505.2010.05.042]
 Deng Xiaopeng,Zhou Zhipeng,Li Qiming,et al.Foundation of Near-miss knowledge base for metro projects[J].Journal of Southeast University (Natural Science Edition),2010,40(5):1103.[doi:10.3969/j.issn.1001-0505.2010.05.042]
[2]周翔,金远平.用于关系数据库关键词查询的基于划分的候选网络生成算法[J].东南大学学报(自然科学版),2012,42(4):609.[doi:10.3969/j.issn.1001-0505.2012.04.006]
 Zhou Xiang,Jin Yuanping.A partition-based candidate network generation algorithm for keyword search on relational databases[J].Journal of Southeast University (Natural Science Edition),2012,42(5):609.[doi:10.3969/j.issn.1001-0505.2012.04.006]
[3]王能斌,孙明江,朱强.一种关系DBMS数据更改功能的实现策略[J].东南大学学报(自然科学版),1987,17(6):27.[doi:10.3969/j.issn.1001-0505.1987.06.003]
 Wang Nengbin Sun Mingjiang Zhu Qiang (Department of Computer Science and Engineering).A Method of Implementing Data Modification in a Relational DBMS[J].Journal of Southeast University (Natural Science Edition),1987,17(5):27.[doi:10.3969/j.issn.1001-0505.1987.06.003]

更新日期/Last Update: 2013-05-01