Self-Driving Database Management System In-Memory Autonomous - - PowerPoint PPT Presentation

▶

May 02, 2023 11 likes •121 views

Self-Driving Database Management System In-Memory Autonomous Open-Source Rewrote storage + query execution. 2015 Kept Postgres frontend. Replaced Postgres frontend. 2016 Cobbled together replacements. Rewriting Postgres replacements.

SLIDE 1

Self-Driving Database Management System

In-Memory Autonomous Open-Source

SLIDE 2

Rewrote storage + query execution. Kept Postgres frontend.

2015

Replaced Postgres frontend. Cobbled together replacements.

2016

Rewriting Postgres replacements. We only use Postgres SQL parser. Decoupled networking from execution.

2017

SLIDE 3

Adaptive Storage

Change the layout of data over time based on how it is accessed.

Bridging the Archipelago Between Row-Stores and Column-Stores for Hybrid Workloads SIGMOD 2016

SLIDE 4 A B C D SELECT AVG(B) FROM myTable WHERE C < “yyy” UPDATE myTable SET A = 123, B = 456, C = 789 WHERE D = “xxx”

Cold Hot

SLIDE 5 A B C D A B C D SELECT AVG(B) FROM myTable WHERE C < “yyy” UPDATE myTable SET A = 123, B = 456, C = 789 WHERE D = “xxx” A B C D

Cold Hot

SLIDE 6

1600 1200 800 400 Execution Time (ms)

Sep-15 Sep-16 Sep-17 Sep-18 Sep-19 Sep-20

Scan Insert Insert Insert Insert Insert Insert Scan Scan Scan Scan Scan

Row Layout Column Layout Adaptive Layout

SLIDE 7

1600 1200 800 400 Execution Time (ms)

Sep-15 Sep-16 Sep-17 Sep-18 Sep-19 Sep-20

Scan Insert Insert Insert Insert Insert Insert Scan Scan Scan Scan Scan

Row Layout Column Layout Adaptive Layout

SLIDE 8

1600 1200 800 400 Execution Time (ms)

Sep-15 Sep-16 Sep-17 Sep-18 Sep-19 Sep-20

Scan Insert Insert Insert Insert Insert Insert Scan Scan Scan Scan Scan

Row Layout Column Layout Adaptive Layout

SLIDE 9

1600 1200 800 400 Execution Time (ms)

Sep-15 Sep-16 Sep-17 Sep-18 Sep-19 Sep-20

Scan Insert Insert Insert Insert Insert Insert Scan Scan Scan Scan Scan

Row Layout Column Layout Adaptive Layout

SLIDE 10

http://pelotondb.io

SLIDE 11

END