Transactional In-Page Logging for multiversion read consistency and recovery
- 1 April 2011
- conference paper
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
Abstract
Recently, a new buffer and storage management strategy called In-Page Logging (IPL) has been proposed for database systems based on flash memory. Its main objective is to overcome the limitations of flash memory such as erase-before-write and asymmetric read/write speeds by storing changes made to a data page in a form of log records without overwriting the data page itself. Since it maintains a series of changes made to a data page separately from the original data page until they are merged, the IPL scheme provides unique opportunities to design light-weight transactional support for database systems. In this paper, we propose the transactional IPL (TIPL) scheme that takes advantage of the IPL log records to support multiversion read consistency and light-weight database recovery. Due to the dual use of IPL log records, namely, for snapshot isolation and fast recovery as well as flash-aware write optimization, TIPL achieves transactional support for flash memory database systems that minimizes the space and time overhead during normal database processing and shortens the database recovery time.Keywords
This publication has 18 references indexed in Scilit:
- FlashLoggingPublished by Association for Computing Machinery (ACM) ,2009
- A case for flash memory ssd in enterprise database applicationsPublished by Association for Computing Machinery (ACM) ,2008
- A log buffer-based flash translation layer using fully-associative sector translationACM Transactions on Embedded Computing Systems, 2007
- FlashDBPublished by Association for Computing Machinery (ACM) ,2007
- A critique of ANSI SQL isolation levelsPublished by Association for Computing Machinery (ACM) ,1995
- ARIESACM Transactions on Database Systems, 1992
- Implementing atomic actions on decentralized dataACM Transactions on Computer Systems, 1983
- Notes on data base operating systemsPublished by Springer Science and Business Media LLC ,1978
- Physical integrity in a large segmented databaseACM Transactions on Database Systems, 1977
- File structure design to facilitate on-line instantaneous updatingPublished by Association for Computing Machinery (ACM) ,1975