COLUMBIA UNIVERSITY COMS 6113

Overview

Administrivia

Observations

Some Background

Characterization of OLTP Settings

Hardware trends change performance

Storage Manager Primer

Life of a xact

Looking Glass Experiment

Involved vs simple xacts

Where does the cost go in a classic database for a simple query?

H-store

Original H-store proposal was before looking glass paper

Skeleton wase same, some things changed

Recovery (replication options)

Costs are now in distributed Transactions

Hekaton Sketch

Integrated with SQLServer, language keywords to create in-mem tables

Index is interesting.

Transactions

So what does this mean

Modern databases contain multiple specialized databases

    (SQLServer
      [hekaton OLTP database])

    (DB2) -- (BLU)


    (Spark
      (sparksql OLAP database)
      (spark graph))   --- Impala

Tiny bit of distributed transactions

Remind about Time scales

Simple query

When can you avoid coordination?

Clarify Consistency vs Coordination