Transaction Management for Flash-based Database Systems*

[Abstract]

Owing to their superiority in access latency and energy consumption, flash memory drives have recently become a competitive alternative to magnetic hard disks as secondary storage. Consequently, flash-based database systems have been receiving increasing attention from the research community in the past few years. In this project, we plan to investigate a number of optimization techniques for transaction management in flash-based database systems by exploiting the characteristics of flash memory drives (such as out-of-place updates and page reprogramming).

[Relevant Publications]

  1. S. Gao, J. Xu, T. Haerder, B. He, B. Choi, and H. Hu. "PCMLogging: Optimizing Transaction Logging and Recovery Performance with PCM." IEEE Transactions on Knowledge and Data Engineering (TKDE), accepted to appear, 2015.
  2. S. T. On, S. Gao, B. He, M. Wu, Q. Luo, and J. Xu. "FD-Buffer: A Cost-Based Adaptive Buffer Replacement Algorithm for Flash Memory Devices." IEEE Transactions on Computers (TC), 63(9): 2288-2301, September 2014.
  3. Y. Li, S. T. On, J. Xu, B. Choi, H. Hu. "Optimizing Non-Indexed Join Processing in Flash Storage-Based Systems." IEEE Transactions on Computers (TC), 62(7): 1417-1431, July 2013.
  4. S. T. On, J. Xu, B. Choi, H. Hu, and B. He. "Flag Commit: Supporting Efficient Transaction Recovery in Flash-based DBMSs." IEEE Transactions on Knowledge and Data Engineering (TKDE), 24(9): 1624-1639, September 2012.
  5. S. Gao, J. Xu, B. He, B. Choi, and H. Hu. "PCMLogging: Reducing Transaction Logging Overhead with PCM." Proc. the 20th ACM Conference on Information and Knowledge Management (ACM CIKM '11), Glasgow, Scotland, UK, October 2011.
  6. Y. Li, J. Xu, B. Choi, and H. Hu. "StableBuffer: Optimizing Write Performance for DBMS Applications on Flash Devices." Proc. the 19th ACM International Conference on Information and Knowledge Man agement (CIKM '10), Toronto, Canada, October 2010.

* This project is supported by the Research Grants Council (RGC), Hong Kong SAR, China under Project No. HKBU211510. For further information, please contact Jianliang Xu.