Selective In-Place Appends for Real: Reducing Erases on Wear-prone DBMS Storage

In the present paper we demonstrate the novel technique to apply the recently proposed approach of In-Place Appends - overwrites on Flash without a prior erase operation. IPA can be applied selectively: only to DB-objects that have frequent and relatively small updates. To do so we couple IPA to the...

Full description

Saved in:
Bibliographic Details
Main Authors: Hardock, Sergey, Petrovy, Ilia, Gottstein, Robert, Buchmann, Alejandro
Format: Conference Proceeding
Language:English
Subjects:
Benchmark testing
Electronic mail
Graphical user interfaces
Hardware
Indexes
Throughput
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:In the present paper we demonstrate the novel technique to apply the recently proposed approach of In-Place Appends - overwrites on Flash without a prior erase operation. IPA can be applied selectively: only to DB-objects that have frequent and relatively small updates. To do so we couple IPA to the concept of NoFTL regions, allowing the DBA to place update-intensive DB-objects into special IPA-enabled regions. The decision about region configuration can be (semi-)automated by an advisor analyzing DB-log files in the background.
ISSN:2375-026X
DOI:10.1109/ICDE.2017.184