Star-join
Schema:
One large fact table (SALES)
Two dimension tables
Query:
SELECT *FROM sales, cust, partsWHERE sales.custid = cust.custidAND cust.state IN (‘CA’, ‘OR’, ‘WA’)AND sales.partid = parts.partidAND parts.color = ‘RED’
Previous slide
Next slide
Back to first slide
View graphic version