Abstract
With the development of flash technologies, flash disks have become an alternative to hard disk as external storage media. Because of the unique characteristics of flash disks such as fast random read access and out-place update, shadow paging technology can be adopted to support transaction recovery in flash-based DBMS. Inspired by shadow paging and logging, we propose a new transaction commit model named MixSL which can be used in databases built on MLC flash disks. Based on MixSL, we detail normal processing, garbage collection and recovery. For improving system performance and raising the utilization ratio of flash disks, we extend MixSL to support group commit. Our performance evaluation based on the TPC-C benchmark shows that MixSL outperforms the state-of-the-art recovery protocols.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Gray, J., Fitzgerald, B.: Flash disk opportunity for server applications. Queue 6(4), 18–23 (2008)
Mohan, C., Haderle, D., Lindsay, B., Pirahesh, H., Schwarz, P.: ARIES: A transaction recovery method supporting fine-granularity locking and partial rollbacks using write-ahead logging. ACM Trans. Database System 17(1), 94–162 (1992)
Ramakrishnan, R., Gehrke, J.: Database Management Systems. McGraw-Hill (2003)
Chung, T.-S., Park, D.-J., Park, S., Lee, D.-H., Lee, S.-W., Song, H.-J.: A survey of Flash Transalation Layer. Journal of Systems Architecture - Embedded Systems Design(JSA) 55(5-6), 332–343 (2009)
Bouganim, L., Jónsson, B.T., Bonnet, P.: uFLIP: Understanding flash IO patterns. In: Proceedings of CIDR (2009)
Ma, D., Feng, J., Li, G.: LazyFTL: A Page-level Flash Translation Layer Optimized for NAND Flash Memory. In: Proceedings of ACM SIGMOD 2011 (2011)
Lee, S.-W., Moon, B.: Design of flash-based DBMS: An in-page logging approach. In: Proceedings of ACM SIGMOD (2007)
Debnath, B., Sengupta, S., Li, J.: FlashStore: High throughput persistent key-value store. In: Proceedings of VLDB (2010)
Agrawal, D., Ganesan, D., Sitaraman, R., Diao, Y.: Lazy-adaptive tree: An optimized index structure for flash devices. In: Proceedings of VLDB (2009)
Ou, Y., Härder, T., Jin, P.: CFDC: a flash-aware replacement policy for database buffer management. In: Proceedings of DaMoN (2009)
Tsirogiannis, D., Harizopoulos, S., Shah, M.A., Wiener, J.L., Graefe, G.: Query processing techniques for solid state drives. In: Proceedings of SIGMOD (2009)
Prabhakaran, V., Rodeheffer, T.L., Zhou, L.: Transactional flash. In: Proceedings of the 8th USENIX Symposium on Operating Systems Design and Implementation (OSDI 2008), San Diego, CA, USA (2008)
Wu, C.-H., Kuo, T.-W., Chang, L.-P.: Efficient initialization and crash recovery for log-based file systems over flash memory. In: Proceedings of the ACM Symposium on Applied Computing, SAC 2006 (2006)
On, S.T., Xu, J., Choi, B., Hu, H., He, B.: Flag Commit: Supporting Efficient Transaction Recovery in Flash-based DBMSs. IEEE Transactions on Knowledge and Data Engineering (2011)
Bernstein, P.A., Hadzilacos, V., Goodman, N.: Concurrecy Control and Recovery in Database Systems. Addison Wesley (1987)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fan, Y., Meng, X. (2013). MixSL: An Efficient Transaction Recovery Model in Flash-Based DBMS. In: Wang, J., Xiong, H., Ishikawa, Y., Xu, J., Zhou, J. (eds) Web-Age Information Management. WAIM 2013. Lecture Notes in Computer Science, vol 7923. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38562-9_40
Download citation
DOI: https://doi.org/10.1007/978-3-642-38562-9_40
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38561-2
Online ISBN: 978-3-642-38562-9
eBook Packages: Computer ScienceComputer Science (R0)