class="bi x0 y0 w1 h1"
class="bi x0 y0 w2 h2"
Member
Name
Age
Project
Office
Title
Office
Office
"Smith" "Gates 252"
"Jones" 28
"Lore"
Member
Project
Building
Room
"Gates" 252
&8 &10
&12
&13 &15
&19 &20
&6
Title
"Tsimmis"
&16
ProjectMember
Building
Room
"CIS" "411"
&17 &18

-Index Mgr
Query
Operators
Object
Manager
External Data
Manager
Query
Optimizer
Query Plan
Generator
Preprocessing
(Lorel to OQL)
Parsing
HTML GUI
Textual
Interface
API
Applications
Lore
System
Queries
class="bi x0 y0 w2 h2"
Select
(OA4 = TRUE)
Aggr
(Exists, OA3, OA4)
Scan
(OA0,"Member",OA1)
Scan

(Root,"DBGroup",OA0)
Join
From clause
From and Where clauses
Final Query Plan
Scan
(OA0,"Member",OA1)
Scan
(Root,"DBGroup",OA0)
Join
Join
Project
(OA7)
Aggr
(Count, OA6, OA7)
Scan
(OA1,"Publications",
OA6)
CreateSet
(OA4, OA5)
Scan
(OA1,"Name",OA4)
SetOp
(Union,OA5,
OA6, OA7)
Select
(OA3 = TRUE)
Aggr
(Exists, OA2, OA3)
Select

containing
all of Jim's
Publications
Fetched
"Jim"
120
"Data
Defined"
Physical ViewLogical View
Fetched
Data
"Pub_Fetch.o"
"Query
Defined"
"Keyword"
Name
Publications
Member
"Jim"
Name
Publications
Member
Quantum
Wrapper
Arg1
Type
Value
Arg2
Type
Query Label