| 基于视图机制和分组统计实现 SQL 中全称量词的转换 |
| |
| 引用本文： | 杨艳,赵雪琴.基于视图机制和分组统计实现 SQL 中全称量词的转换[J].电脑与微电子技术,2014(11):42-43,52. |
| |
| 作者姓名： | 杨艳 赵雪琴 |
| |
| 作者单位： | [1]中原工学院,郑州450007 [2]郑州大学西亚斯国际学院,新郑451150 |
| |
| 摘 要： | SQL语言不支持全称量词，当查询涉及“全部”语义时，需要将全称量词等价转换为存在量词，转换及量词的使用都是难点，需要有相关的逻辑推理及思维能力，从而使程序员难以理解。基于视图机制和分组统计来实现对全称量词的对应语义的转换，思路清晰，容易掌握。
|
| 关 键 词： | 全称量词 等价转换 视图 分组统计 |
Implementation of Transformation of Universal Quantifier in SQL Based on View Mechanism and Statistical Analysis |
| |
| Authors: | YANG Yan ZHAO Xue-qin |
| |
| Affiliation: | 1. Zhongyuan University of Technology, Zhengzhou 450052; 2. College of Sias International, Zhengzhou University, Xinzheng 451150) |
| |
| Abstract: | SQL language does not support universal quantifier. When a query involves ＂all＂ semantics, it is necessary to transform the universal quantifier into the existential quantifier, which is equivalent. It is difficuh to use conversion and quantifiers, It needs some relevant logic reasoning and thinking ability. Thus it is difficult for programmer to understand them. Based on the view and statistical analysis to realize the replacement of the semantic correspondence of the universal quantifier. It is clarity of thought and it is easy to master. |
| |
| Keywords: | Universal Quantifier Equivalent Transformation View Statistical Analysis |
| 本文献已被 维普 等数据库收录！ |
