SQL Queries with Full Values
DOI:
CSTR:
Author:
Affiliation:

Clc Number:

Fund Project:

  • Article
  • |
  • Figures
  • |
  • Metrics
  • |
  • Reference
  • |
  • Related
  • |
  • Cited by
  • |
  • Materials
  • |
  • Comments
    Abstract:

    SQL phrases require the use of predicate NOT EXISTS to construct complicated nested query in order to express the full value meaning. Practitioners find it very difficult to write and easy to make errors. Tuple relational calculus can fully express such meaning. This paper uses examples to discuss and demonstrate trans formation rules when trans forming a tuple rel ational calculus expression to a SQL query, which is very helpful to SQL query learners.

    Reference
    Related
    Cited by
Get Citation

邢泉.含有全部值语义的SQL 查询.计算机系统应用,2010,19(1):169-170

Copy
Share
Article Metrics
  • Abstract:
  • PDF:
  • HTML:
  • Cited by:
History
  • Received:April 22,2009
  • Revised:
  • Adopted:
  • Online:
  • Published:
Article QR Code
You are the firstVisitors
Copyright: Institute of Software, Chinese Academy of Sciences Beijing ICP No. 05046678-3
Address:4# South Fourth Street, Zhongguancun,Haidian, Beijing,Postal Code:100190
Phone:010-62661041 Fax: Email:csa (a) iscas.ac.cn
Technical Support:Beijing Qinyun Technology Development Co., Ltd.

Beijing Public Network Security No. 11040202500063