Instant recovery for main-memory databases

Research output: Contribution to conferencesPaperContributedpeer-review

Contributors

  • Ismail Oukid - , TUD Dresden University of Technology, SAP Research (Author)
  • Wolfgang Lehner - , Chair of Databases (Author)
  • Thomas Kissinger - , Chair of Databases (Author)
  • Thomas Willhalm - , Intel Corporation (Author)
  • Peter Bumbulis - , SAP Research (Author)

Abstract

With the emergence of new hardware technologies, new opportunities arise and existing database architectures have to be rethought to fully exploit them. In particular, recovery mechanisms of current main-memory database systems are tuned to efficiently work on block-oriented, high-latency storage devices. These devices create a bottleneck during transaction processing. In this paper, we investigate the opportunities given by the upcoming Storage Class Memory (SCM) technology for database system recovery mechanisms. In contrast to traditional block-oriented devices, SCM is byte-addressable and offers a latency close to that of DRAM. We propose a novel main-memory database architecture that directly operates in SCM, eliminates the need for logging mechanisms, and provides a way to trade recovery time with the overall query performance. We implemented these concepts in our prototype SOFORT. Our evaluation shows that we are able to achieve instant recovery of the DBMS while removing the need for transaction rollbacks after failure.

Details

Original languageEnglish
Publication statusPublished - 2015
Peer-reviewedYes

Conference

Title7th Biennial Conference on Innovative Data Systems Research, CIDR 2015
Duration4 - 7 January 2015
CityAsilomar
CountryUnited States of America

External IDs

ORCID /0000-0001-8107-2775/work/199215559

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis