Turbocharging DBMS buffer pool using SSDs

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2011, Pages 1113-1124

  Do, Jaeyoung ^a   Zhang, Donghui ^b   Patel, Jignesh M ^a   DeWitt, David J ^b   Naughton, Jeffrey F ^a   Halverson, Alan ^b  

^a UNIVERSITY OF WISCONSIN MADISON   (United States)

^b MICROSOFT   (United States)

Author keywords

buffer pool; flash SSD

Indexed keywords

FLASH-BASED SSDS; HARD DISK STORAGE; LAKES;

BUFFER MANAGER; BUFFER POOL; DRIVE CONFIGURATIONS; EMPIRICAL EVALUATIONS; FLASH SOLID-STATE DRIVE; HARD DISK DRIVE; MULTIPLE SCALE FACTORS; PERFORMANCE; SQL SERVERS;

DATABASE SYSTEMS;

EID: 79959978267     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1989323.1989442     Document Type: Conference Paper

References (38)

1. D. Agrawal, D. Ganesan, R. K. Sitaraman, Y. Diao, and S. Singh. Lazy-Adaptive Tree: An Optimized Index Structure for Flash Devices. PVLDB, 2009.
2. R. Bitar. Deploying Hybrid Storage Pools with Sun Flash Technology and the Solaris ZFS File System. In Sun BluePrints Online, 2008.
3. B. Bhattacharjee, M. Canim, C. A. Lang, G. Mihaila, and K. A. Ross. Storage Class Memory Aware Data Management. In IEEE Data Engineering Bulletin, 33(4), 2010.
4. L. Bouganim, B. T. Jonsson, and P. Bonnet. uFLIP: Understanding Flash IO Patterns. In CIDR, 2009.
5. G. P. Copeland, W. Alexander, E. E. Boughter and T. W. Keller. Data Placement in Bubba. In SIGMOD, 1988.
6. M. Canim, B. Bhattacharjee, G. A. Mihaila, C. A. Lang, and K. A. Ross. An Object Placement Advisor for DB2 Using Solid State Storage. PVLDB, 2009.
7. M. Canim, G. A. Mihaila, B. Bhattacharjee, K. A. Ross, and C. A. Lang. SSD Bufferpool Extensions for Database Systems. In VLDB, 2010.
8. Computer World. HP offers SSDs in ProLiant server line, 2008. http://www.computerworld.com/s/article/9138209/HP-offers-SSDs-in-ProLiant- server-line
9. B. Dees. Native Command Queuing - Advanced Performance in Desktop Storage. IEEE Potentials, 2007.
10. J. Do and J. M. Patel. Join Processing for Flash SSDs: Remembering Past Lessons. In DaMoN, 2009.
11. EE Times. SSDs: Still not a 'Solid State' Business, 2010. http://www.eetimes.com/electronics-news/4206361/SSDs-Still-not-a-solid-state- business
12. J. Gray. Tape is Dead, Disk is Tape, Flash is Disk, RAM Locality is King, 2006. http://research.microsoft.com/en-us/um/people/gray/talks/Flash-is-Good. ppt
13. G. Graefe. The Five-Minute Rule Twenty Years Later, and How Flash Memory Changes the Rules. In DaMoN, 2007.
14. J. Gray and B. Fitzgerald. Flash Disk Opportunity for Server Applications. ACM Queue, 2008.
15. J. Gray and A. Reuter. Chapter 12: Advanced Transaction Manager Topics. In Transaction Processing: Concepts and Techniques, Morgan Kaufmann Publishers, 1993.
16. S. Hetzler. The Storage Chasm: Implications for the Future of HDD and Solid State Storage. IBM, 2009.
17. A. L. Holloway. Chapter 4: Extending the Buffer Pool with a Solid State Disk. In Adapting Database Storage for New Hardware, University of Wisconsin-Madison Ph.D. thesis, 2009.
18. Information Week. Google Plans to Use Intel SSD Storage in Servers, 2008. http://www.informationweek.com/news/storage/systems/showArticle.jhtml? articleID=207602745
19. Iometer. http://www.iometer.org
20. S.-H. Kim, D. Jung, J.-S. Kim, and S. Maeng. HeteroDrive: Re-shaping the Storage Access Pattern of OLTP workload using SSD. In IWSSPS, 2009.
21. I. Koltsidas and S. Viglas. Flashing Up the Storage Layer. PVLDB, 2008.
22. I. Koltsidas and S. Viglas. The Case for Flash-Aware Multi-Level Caching. Technical Report, University of Edinburgh, 2009. http://homepages.inf.ed.ac.uk/ s0679010/mfcache-TR.pdf
23. S.-W. Lee and B. Moon. Design of Flash-Based DBMS: An In-Page Logging Approach. In SIGMOD, 2007.
24. 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, 2008.
25. S. T. Leutenegger and D. M. Dias. A Modeling Study of the TPC-C Benchmark. In SIGMOD, 1993.
26. C. Li, K. Shen, and A. E. Papathanasiou. Competitive Prefetching for Concurrent Sequential I/O. In EuroSys, 2007.
27. Y. Li, B. He, R. J. Yang, Q. Luo, and K. Yi. Tree Indexing on Solid State Drives. PVLDB, 2010.
28. Microsoft SQL Server 2008 R2 Editions. http://www.microsoft.com/ sqlserver/2008/en/us/R2-editions.aspx
29. D. Narayanan, E. Thereska, A. Donnelly, S. Elnikety, and A. I. T. Rowstron. Migrating Server Storage to SSDs: Analysis of Tradeoffs. In EuroSys, 2009.
30. E. J. O'Neil, P. E. O'Neil, and G. Weikum. The LRU-K Page Replacement Algorithm for Database Disk Buffering. In SIGMOD, 1993.
31. Oracle Exadata. http://www.oracle.com/us/products/database/exadata.
32. M. Polte, J. Simsa, and G. Gibson. Enabling Enterprise Solid State Disks Performance. In WISH, 2009.
33. D. Tsirogiannis, S. Harizopoulos, M. A. Shah, J. L. Wiener, and G. Graefe. Query Processing Techniques for Solid State Drives. In SIGMOD, 2009.
34. Teradata. Virtual Storage. http://www.teradata.com/t/brochures/Teradata- Virtual-Storage-eb5944.
35. TPC Benchmark C (TPC-C). http://www.tpc.org/tpcc.
36. TPC Benchmark E (TPC-E). http://www.tpc.org/tpce.
37. TPC Benchmark H (TPC-H). http://www.tpc.org/tpch.
38. C.-H. Wu, T.-W. Kuo, and L.-P. Chang. An Efficient B-tree Layer Implementation for Flash-Memory Storage Systems. ACM TECS, 2007