国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 開(kāi)發(fā) > 綜合 > 正文

Relation Algebra

2024-07-21 02:39:40
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友
分兩大類:
1。SET-THEORETIC OperaTIONS

NAME                              SYMBOL        KEYBOARD FORM              CHE
UNION                                                        UNION                                 并                                         INTERSECT                                                                                              交
DIFFERENCE                        -                        MINUS                             差
//前三類是要條件的,就像矩陣運(yùn)算一樣
條件:大概意思是 狗只能跟狗比,不能跟貓比
PRODUCT                             *                      TIMES                                笛卡兒積 
2。
NATIVE RELATIONAL OPERATIONS

PROJECT                           R[]                            R[]                                  取其中幾列
SELECT                              R WHERE C            R WHERE C                  就像SQL中的select  * from C 一樣
JOIN                                                                    JOIN                             合并:所有“共有列”一樣的record才保留
DIVISION                           /                                DIVIDBY                      除以
//  If the table R is defined by R = T*S,then it is true that T = R DIVIDBY S.

EXAMPLE 2.96(表格跟見(jiàn)上篇文章)
0 := ORDERS    --alias
GET cids of customers who order all products that anybody orders.This is division again,and the divisor,the list of “all” products,must be projected from ORDERS rather than PRODUCTS.
0[cid,pid]/0[pid]

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 江都市| 桐柏县| 彰化市| 南靖县| 绥江县| 岑溪市| 平原县| 于田县| 新田县| 乌鲁木齐县| 江阴市| 嘉兴市| 石棉县| 德江县| 盐津县| 武汉市| 长垣县| 绥棱县| 沿河| 社旗县| 玛纳斯县| 隆昌县| 宁蒗| 蛟河市| 永仁县| 西林县| 道孚县| 稷山县| 喀喇沁旗| 海林市| 新津县| 平果县| 远安县| 襄垣县| 庆城县| 井冈山市| 榕江县| 横山县| 民权县| 兖州市| 玉龙|