数据库复习

interpreter 解释器
compiler 编译器
Query 查询
evaluation 计算
Polynomial 多项式
duplicate rows 双行
arity 数量 r, s must have the same arity (same number of attributes)
compatible 相容的 The attribute domains must be compatible

Cartesian-Product 笛卡儿积
disjoint 不相交的
Assume that attributes of r(R) and s(S) are disjoint.
If attributes of r(R) and s(S) are not disjoint, then renaming must be used

select:
project: 
union: 
set difference: –
cartesian product: x
rename: 

Set intersection 
Natural join
Division 
Assignment 

avg: average value
min: minimum value
max: maximum value
sum: sum of values
count: number of values

outer join : An extension of the join operation that avoids loss of information
duplicate elimination and grouping 重复消除和分组

predicate 断言，宣布
clause 从句
• The select clause list the attributes desired in the result of a query
case insensitive 大小写不敏感
the elimination of duplicates 消除重复
asterisk 星号
ascending order 升序
descending order 降序
例 : order by amount desc, loan_number asc

Duplicate semantics 重复的语义
union, intersect, and except
  

Deposit （银行的）储户

Having Function
predicates in the having clause are applied after the formation of groups whereas predicates in the where clause are applied before forming groups

update account
set balance = case
when balance <= 10000 then balance *1.05
else balance * 1.06
end