Microsoft SQL Hekaton – Towards Large Scale Use of PM for In-memory Databases

This talk uses the example of Hekaton (Sql Server in-memory database engine) to break down the opportunity areas for non-volatile memory in the database space. I will focus on three areas: (i) logging – and how byte addressable NVM can help there in a way that block mode cannot, (ii) high-availability which is impacted by the choice of the logging scheme and (iii) checkpointing which is modified in a fundamental way to allow the database to take advantage of byte-addressable NVM.This talk uses the example of Hekaton (Sql Server in-memory database engine) to break down the opportunity areas for non-volatile memory in the database space. I will focus on three areas: (i) logging – and how byte addressable NVM can help there in a way that block mode cannot, (ii) high-availability which is impacted by the choice of the logging scheme and (iii) checkpointing which is modified in a fundamental way to allow the database to take advantage of byte-addressable NVM.