First page Back Continue Last page Overview Graphics
Analysis Sub-Patterns
Secret Sauce
- Summarize all Facts for an Entity
- In SQL this is the amazing
- SELECT SUM(...) FROM ... GROUP BY ...
Several Patterns
- One-level Summary
- SELECT d, SUM(f) FROM join GROUP BY d
- Subset Selection
- SELECT d, SUM(f) FROM join WHERE subset GROUP BY d
- Multi-Dimension Summary (a/k/a Pivot Table)
- SELECT d, e, SUM(f) FROM join GROUP BY d, e