YMMV The The Las Last Si t Six Mon x Months ths Prison Life - - PowerPoint PPT Presentation

▶
ymmv the the las last si t six mon x months ths prison
SMART_READER_LITE
LIVE PREVIEW

YMMV The The Las Last Si t Six Mon x Months ths Prison Life - - PowerPoint PPT Presentation

Sep 08, 2023 496 likes •953 views

OLTP on NVM: YMMV The The Las Last Si t Six Mon x Months ths Prison Life GOOD EVIL NVM OLTP DRAM SSD/HDD Ov Overv erview iew OL OLTP TP Wo Workl rkloads oads In Inte tel NV l NVM M Em Emul ulat

slide-1
SLIDE 1

OLTP on NVM:

YMMV

slide-2
SLIDE 2

The The Las Last Si t Six Mon x Months ths

slide-3
SLIDE 3
slide-4
SLIDE 4
slide-5
SLIDE 5
slide-6
SLIDE 6
slide-7
SLIDE 7

Prison Life

GOOD EVIL

slide-8
SLIDE 8

NVM OLTP

DRAM SSD/HDD

slide-9
SLIDE 9

Ov Overv erview iew

slide-10
SLIDE 10

OL OLTP TP Wo Workl rkloads

  • ads
  • –

– –

slide-11
SLIDE 11

In Inte tel NV l NVM M Em Emul ulat ator

  • r
  • –

–

slide-12
SLIDE 12

NU NUMA MA In Inte terf rface ace – NVM NVM-Only Only

slide-13
SLIDE 13

PM PMFS FS In Inte terf rface ace – DR DRAM AM+NVM +NVM

slide-14
SLIDE 14

DB DBMS MS Ar Archi chitect tectures ures

slide-15
SLIDE 15

Di Disk sk-oriented

  • riented DB

DBMS MS

  • –

–

slide-16
SLIDE 16
slide-17
SLIDE 17

Me Memo mory ry-orient

  • riented

ed DB DBMS MS

  • –

– –

slide-18
SLIDE 18
slide-19
SLIDE 19

Ex Experi periment mental al Ev Eval aluat uation ion

  • –

– –

slide-20
SLIDE 20

Ev Eval aluat uated ed Sy Syst stems ems

  • –

–

  • –

–

slide-21
SLIDE 21

YC YCSB SB // //

→
slide-22
SLIDE 22

YC YCSB SB // //

→
slide-23
SLIDE 23

YC YCSB SB // //

→
slide-24
SLIDE 24

YC YCSB SB // //

→
slide-25
SLIDE 25

Di Disc scuss ussion ion

slide-26
SLIDE 26

Database Research @

CMU

slide-27
SLIDE 27

Da Data tabase base Re Resear search ch @ CMU CMU

slide-28
SLIDE 28

N-STORE

slide-29
SLIDE 29

N-St Store

  • re
  • –

– –

slide-30
SLIDE 30

N-St Store

  • re – Sh

Shado adow w Pa Pagi ging ng

Shadow Page Table

1 2 3 4

Master Page Table

1 2 3 4

DB Root

X X X

X

slide-31
SLIDE 31

H-STORE

slide-32
SLIDE 32

H-St Store

  • re + An

+ Anti ti-Cachi Caching ng

slide-33
SLIDE 33
slide-34
SLIDE 34

H-St Store

  • re + An

+ Anti ti-Cachi Caching ng

slide-35
SLIDE 35

ThomasDB

slide-36
SLIDE 36

Th Thom

  • masDB

asDB

slide-37
SLIDE 37

Th Thom

  • masDB

asDB – Da Data ta Ma Mart rts

UDF UDF

⨝

Update! Materialized View
slide-38
SLIDE 38

Th Thom

  • masDB

asDB – Pr Prel elimi iminary nary Re Resul sults ts

slide-39
SLIDE 39

MongoDB

slide-40
SLIDE 40

Di Dist stri ributed buted Do Docum cument ent Da Data tabase base De Desi sign gn

  • –

– –

slide-41
SLIDE 41

Vi Vigi gila lante nte DB DBA

slide-42
SLIDE 42

Su Summ mmary ary

slide-43
SLIDE 43

END

slide-44
SLIDE 44