Query on Company Domain Schema
Query 1
Original query: select *
from Manager
where level > 20
Optimized query: empty query (inchoerent class)
Query 2
Original query: select *
from Storage
where category = "B4" and
managed_by.level < 10 and
for all X in stock :
X.item.risk > 15
Optimized query: select *
from SStorage as S
where category = "B4" and
for all X in S.stock :
(X.item in
(select U
from SMaterial as U
where U.risk > 15)) and
S.managed_by in ( select T
from TManager as T
where T.level < 10 and
T.salary < 60001)
Query 3
Original query: select *
from Storage
where category = "B4" and
for all X in stock : X.item in
(select y
from SMaterial y )
Optimized query: select *
from SStorage as S
where category = "B4" and
for all X in S.stock :
(X.item in (select y from SMaterial as y)) and
S.managed_by in TManager
Query 4
Original query: select *
from Material
where risk >= 10 and
risk <= 50
Optimized query: select *
from SMaterial as S
where risk > 9 and
risk < 51
ODB Tools