[prev] 44 [next]

Mapping Rules (cont)

View example: assuming Employee(id,name,birthdate,salary)

-- view definition
create view OldEmps as
select * from Employees
where  birthdate < '01-01-1960';
-- view usage
select name from OldEmps;

yields

  • OldEmps  =  Select[birthdate<'01-01-1960'](Employees)
  • Projname(OldEmps)
    ⇒    Projname(Select[birthdate<'01-01-1960'](Employees))