FlashLogging: Exploiting flash devices for synchronous logging performance

SIGMOD-PODS'09 - Proceedings of the International Conference on Management of Data and 28th Symposium on Principles of Database Systems

Volumn , Issue , 2009, Pages 73-86

  Chen, Shimin ^a  

^a INTEL CORPORATION   (United States)

Author keywords

Flash devices; Flashlogging; Near zero delay archival disk; Online transaction processing; Outlier detection and hiding; Recovery processing; Synchronous logging; Unconventional array organization

Indexed keywords

BACK-UP SERVERS; DATA PERSISTENCY; DISK ARRAY; DISK-BASED; FLASH DEVICES; FLASH DRIVES; MAGNETIC DISK; NEAR-ZERO-DELAY ARCHIVAL DISK; ONLINE TRANSACTION PROCESSING; OUTLIER DETECTION; RECOVERABILITY; RECOVERY PERFORMANCE; USB FLASH DRIVES; USB PORTS;

DATABASE SYSTEMS; DISKS (MACHINE COMPONENTS); DISKS (STRUCTURAL COMPONENTS); DRIVES; RECOVERY;

WELL LOGGING;

EID: 70849094136     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1559845.1559855     Document Type: Conference Paper

References (36)

1. T. Anderson, Y. Breitbart, H. F. Korth, and A. Wool. Replication, consistency, and practicality: are these mutually exclusive? In SIGMOD, pages 484-495, 1998.
2. R. S. Barga, S. Chen, and D. B. Lomet. Improving logging and recovery performance in phoenix/app. In ICDE, pages 486-497, 2004.
3. L. Bouganim, B. T. Jónsson, and P. Bonnet. uFLIP: Understanding flash io patterns. In CIDR, 2009.
4. Y. Breitbart, R. Komondoor, R. Rastogi, S. Seshadri, and A. Silberschatz. Update propagation protocols for replicated databates. In SIGMOD, pages 97-108, 1999.
5. A. M. Caulfield, L. M. Grupp, and S. Swanson. Gordon: using flash memory to build fast, power-efficient clusters for data-intensive applications. In ASPLOS, pages 217-228, 2009.
6. Chris Mellor. Faster usb 3.0 is coming. http://www.pcworld.com/article/ 137551/.
7. K. Daudjee and K. Salem. Lazy database replication ith snapshot isolation. In VLDB, pages 715-726, 2006.
8. E. N. Elnozahy, L. Alvisi, Y.-M. Wang, and D. B.Johnson. A survey of rollback-recovery protocols in message-passing systems. ACM Comput. Surv., 375-408, 2002.
9. E. Gal and S. Toledo. Algorithms and data structures for flash memories. ACM Comput. Surv., 138-163, 2005.
10. G. Graefe. The five-minute rule twenty years later. In DaMoN Workshop, 2007.
11. J. Gray, P. Helland, P. O'Neil, and D. Shasha. The dangers of replication and a solution. In SIGMOD, pages 173-182, 1996.
12. J. Gray and A. Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993.
13. S. Harizopoulos, D. J. Abadi, S. Madden, and M. Stonebraker. OLTP through the looking glass, and what we found there. In SIGMOD, pages 981-992, 2008.
14. J. L. Hennessy and D. A. Patterson. Computer Architecture, Fourth Edition: A Quantitative Approach. Morgan Kaufmann Publishers Inc., 2006.
15. Intel X25-M 80GB SATA Solid State Drive, Intel Ups The Ante. http://hothardware.com/Articles/Intel-X25M-80GB-SATA-Solid-State-Drive-Intel- Ups-The-Ante/?page=2.
16. Intel X25-M and X18-M Mainsteam SATA Solid State Drives. http://download.intel.com/design/flash/nand /mainstream/mainstream-sata-ssd- product-brief.pdf.
17. D. Kline and N. Pilaka. An overview of transactional logging in db2 universal database.http://www.ibm.com/developerworks/db2/library/techarticle/ 0301kline/0301kline.html.
18. I. Koltsidas and S. Viglas. Flashing up the storage layer. In VLDB, 2008.
19. S.-W. Lee and B. Moon. Design of flash-based dbms: an in-page logging approach. In SIGMOD, pages 55-66, 2007.
20. S.-W. Lee, B. Moon, C. Park, J.-M. Kim, and S.-W. Kim. A case for flash memory ssd in enterprise database applications. In SIGMOD, pages 1075-1086, 2008.
21. Y. Lin, B. Kemme, N.-M. Marta Pati and R. Jiménez-Peris. Middleware based data replication providing snapshot isolation. In SIGMOD, pages 419-430, 2005.
22. Microsoft Corp. Sql server 7.0, sql server 2000, and sql server 2005 logging and data storage algorithms. http://support.microsoft.com/kb/230785.
23. S. L. Min and E. H. Nam. Current trends in flash memory technology: invited paper. In ASP-DAC, pages 332-333, 2006.
24. S. Nath and P. Gibbons. Online maintenance of very large random samples on flash storage. In VLDB, 2008.
25. S. Nath and A. Kansal. Flashdb: dynamic self-tuning database for nand flash. In IPSN, pages 410-419, 2007.
26. E. B. Nightingale, K. Veeraraghavan, P. M. Chen, and J. Flinn. Rethink the sync. In OSDI, 2006.
27. Oracle Corp. Oracle database administrator's guide 10g release 1 (chapter 6. managing the redo log). Part Number B10739-01.
28. OSDL DBT2. http://sourceforge.net/projects/osdldbt.
29. V. Prabhakaran, T. L. Rodeheffer, and L. Zhou. Transactional flash. In OSDI, 2008.
30. K. Ross. Modeling the performance of algorithms on flash memory devices. In DaMoN Workshop, 2008.
31. Samsung Electronics. Onenand specification. http://www.samsung.com.
32. M. A. Shah, S. Harizopoulos, J. L. Wiener, and G. Graefe. Fast scans and joins using flash drives. In DaMoN Workshop, 2008.
33. M. Stonebraker, S. Madden, D. J. Abadi, S. Harizopoulos, N. Hachem, and P. Helland. The end of an architectural era (it's time for a complete rewrite). In VLDB, pages 1150-1160, 2007.
34. Transaction Processing Performance Council. TPC-C benchmark. http://www.tpc.org/tpcc/.
35. V. Vasudevan, J. Franklin, D. Andersen, A. Phanishayee, L. Tan, M. Kaminsky, and I. Moraru. Fawndamentally power-efficient clusters. In HotOS, 2009.
36. R. Wang, B. Salzberg, and D. B. Lomet. Log-based recovery for middleware servers. In SIGMOD, pages 425-436, 2007.