Rewrites:Operation Introduction
•Schema: (pid determines
cid)
–Category
(pid, cid, details)
–Sales(tid,
date, store, pid, amount)
•Trees:
Join
groupBy(cid)
Sum(amount)
Scan(Sales)
Filter(store
IN
{CA,WA})
Category
Filter (…)
Join
groupBy(cid)
Sum(amount)
Scan(Sales)
Filter(store IN
{CA,WA})
Category
Filter (…)
groupBy(pid)
Sum(amount)
