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

首頁 > 開發(fā) > 綜合 > 正文

Relation Algebra

2024-07-21 02:06:08
字體:
供稿:網(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(表格跟見上篇文章)
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]中國最大的web開發(fā)資源網(wǎng)站及技術(shù)社區(qū),
發(fā)表評論 共有條評論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 竹溪县| 乐平市| 太仆寺旗| 秀山| 鄂托克前旗| 延安市| 昭平县| 密山市| 藁城市| 同江市| 香河县| 桐城市| 海城市| 无极县| 青神县| 柳州市| 龙岩市| 张家川| 德保县| 正镶白旗| 宁蒗| 石屏县| 宝清县| 广元市| 安国市| 鸡东县| 崇礼县| 绥芬河市| 保定市| 乐昌市| 宜兰市| 晋宁县| 五峰| 阿拉尔市| 芷江| 政和县| 长宁县| 汉川市| 崇州市| 贡觉县| 林芝县|