Implementing Relational Operators (cont)
So far, have considered ...
- scanning (e.g.
select * from R)
With file structures ...
- heap file ... tuples added to any page which has space
- sorted file ... tuples arranged in file in key order
- hash file ... tuples placed in pages using hash function
Now ...
- sorting (e.g.
select * from R order by x)
- projection (e.g.
select x,y from R)
- selection (e.g.
select * from R where Cond)
and
- indexes ... search trees based on pages/keys
- signatures ... bit-strings which "summarize" tuples
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}