Improving Query Performance THE REAL WORLD OF THE DATABASE - PowerPoint PPT Presentation

▪ ▪ ➢ ▪ ➢ Improving Query Performance THE REAL WORLD OF THE DATABASE in Data Warehouses ADMINISTRATOR Business Intelligence Journal 06 Unisphere Research 15

▪ ➢ ➢ ▪ ➢ ➢ ➢

Perception Action Model Planning

Perception Action Model Planning

▪ Prediction Horizon 1. Good Accuracy 2. Major Patterns 3. Cost vs. Accuracy Prediction Interval

▪ ▪ ▪ Cyclic (Diurnal) Growth and Spike

SQL SQL SQL Forecasts Query-based Workload Forecasting for Self-Driving Database Management Systems SIGMOD 18

▪ ▪ Millions → Thousands

▪ ➢ ➢ ➢

A few large clusters exhibit major patterns

▪ ➢ ➢ ▪ LR+RNN has the best average accuracy

▪ ▪ ▪ ➢ ➢

25%

▪ ▪ ➢ built ➢ building Benefit/Penalty Deployment Traditionally estimated by human

Perception Action Model Planning

▪

▪

▪ ▪ ➢

Perception Action Model Planning

▪ ➢ ▪ ➢ ➢ 26

▪ 27

▪ ▪ ▪ ▪ ▪