Workload | Queries | Performance approach |
---|---|---|
Ad-hoc data exploration | Unpredictable | Filtering and Sampling |
Dynamic dashboards and BI | Predictable | Aggregate Aware Caching |
Datasets for data science or 3rd party integration | Fully known | Materialization |
Massive data transformation (ELT in Honeydew) | Batch | Entity Caching |