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

▶

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

Jul 26, 2023 97 likes •404 views

Improving Query Performance THE REAL WORLD OF THE DATABASE in Data Warehouses ADMINISTRATOR Business Intelligence Journal 06 Unisphere Research 15 Perception Action Model Planning

SLIDE 1

SLIDE 2

▪ ▪

➢

▪

➢

THE REAL WORLD OF THE DATABASE ADMINISTRATOR

Unisphere Research 15

Improving Query Performance in Data Warehouses

Business Intelligence Journal 06

SLIDE 3

▪

➢ ➢

▪

➢ ➢ ➢

SLIDE 4

Perception Action Model Planning

SLIDE 5

Perception Action Model Planning

SLIDE 6

SLIDE 7

▪

Prediction Horizon Prediction Interval

1. Good Accuracy

2. Major Patterns
3. Cost vs. Accuracy

SLIDE 8

▪ ▪ ▪

Cyclic (Diurnal) Growth and Spike

SLIDE 9

Query-based Workload Forecasting for Self-Driving Database Management Systems

SIGMOD 18

SQL SQL SQL Forecasts

SLIDE 10

▪ ▪

Millions → Thousands

SLIDE 11

▪

➢ ➢ ➢

SLIDE 12

SLIDE 13

A few large clusters exhibit major patterns

SLIDE 14

▪

➢ ➢

▪

LR+RNN has the best average accuracy

SLIDE 15

SLIDE 16

SLIDE 17

SLIDE 18

▪ ▪ ▪

➢ ➢

SLIDE 19

25%

SLIDE 20

▪ ▪

➢ built ➢ building Deployment Benefit/Penalty

Traditionally estimated by human

SLIDE 21

Perception Action Model Planning

SLIDE 22

▪

SLIDE 23

▪

SLIDE 24

▪ ▪

➢

SLIDE 25

Perception Action Model Planning

SLIDE 26

▪

➢

▪

➢ ➢

SLIDE 27

▪

SLIDE 28

▪ ▪ ▪ ▪ ▪

SLIDE 29