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 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. We showcase a Shore-MT based prototype of the above approach, operating on real Flash hardware. During the demonstration we allow the users to interact with the system and gain hands-on experience under different demonstration scenarios.
| Author of HS Reutlingen | Petrov, Ilia |
|---|---|
| DOI: | https://doi.org/10.1109/ICDE.2017.184 |
| ISBN: | 978-1-5090-6543-1 |
| Published in: | ICDE 2017 : 2017 IEEE 33rd International Conference on Data Engineering : 19-22 April 2017, San Diego, California, USA |
| Publisher: | IEEE |
| Place of publication: | Piscataway, NJ |
| Document Type: | Conference proceeding |
| Language: | English |
| Publication year: | 2017 |
| Page Number: | 2 |
| First Page: | 1375 |
| Last Page: | 1376 |
| DDC classes: | 004 Informatik |
| Open access?: | Nein |
| Licence (German): |  In Copyright - Urheberrechtlich geschützt |
