PPT Slide

Queries Over Row Types

• SQL's query constructs, extended with the ability to access these features (a la SQL3 plus sets)
  • User-defined functions in queries (w/late method binding)
  • Dereferencing of references (path expressions)
  • Queries over nested collections (table expressions)

• For example, find unexplainable discrepencies between employees' and managers' salaries:

select E.name, E.manager->name, display(E.photo)

from IBM_Emps E

where E.salary > E.department->manager->salary

and E.department->manager->age( ) > E.self->age( )

and not contains(E.job_description, "Java")

Previous slide

Next slide

Back to first slide

View graphic version