Key Difference between Relational & OLAP Reporting – SQL Circuit

Key Difference between Relational & OLAP Reporting

FeatureRelationalOLAP
Data AccessGeneralized access
1) Relational table(s)
2) Transactional or Summary Table(s)
Multi-dimensional (cross-tab) presentation only
1) Dimensions & Measures
2) Summarized Data
PresentationMulti-dimensional and Tabular ReportingMulti-dimensional only
Performance OptimizationPre-summarization requiredRollups are pre-summarized (e.g., monthly data, dimension totals)
Analysis CapabilitySimple
1) Sum
2) Average
3) Count
Advanced Analysis
1) Trending
2) Rankings
3) Exceptions
Drill Down1) Add columns for detail;
2) hierarchy depends on data model)
3) drill to transactions
1) Hierarchical (parent/child)
2) drill to another dimension
3) drill to relational detail
SpeedDepends on query and summarizationFast access due to aggregated storage

Leave a Reply

Your email address will not be published. Required fields are marked *