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