A case for flash memory ssd in enterprise database applications Export

@inproceedings{citeulike:3460060, abstract = {Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and temporary table spaces.}, address = {New York, NY, USA}, author = {Lee, Sang W. and Moon, Bongki and Park, Chanik and Kim, Jae M. and Kim, Sang W.}, booktitle = {SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data}, citeulike-article-id = {3460060}, citeulike-linkout-0 = {http://portal.acm.org/citation.cfm?id=1376723}, citeulike-linkout-1 = {http://dx.doi.org/10.1145/1376616.1376723}, doi = {10.1145/1376616.1376723}, isbn = {978-1-60558-102-6}, keywords = {database, ssd}, location = {Vancouver, Canada}, pages = {1075--1086}, posted-at = {2008-10-29 13:15:36}, priority = {2}, publisher = {ACM}, title = {A case for flash memory ssd in enterprise database applications}, url = {http://dx.doi.org/10.1145/1376616.1376723}, year = {2008} }

TY - CONF ID - citeulike:3460060 L3 - citeulike-article-id:3460060 N2 - Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and temporary table spaces. CY - Vancouver, Canada SN - 978-1-60558-102-6 AD - New York, NY, USA EP - 1086 TI - A case for flash memory ssd in enterprise database applications PB - ACM T2 - SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data SP - 1075 KW - database KW - ssd AU - Lee, Sang AU - Moon, Bongki AU - Park, Chanik AU - Kim, Jae AU - Kim, Sang PY - 2008/// UR - http://dx.doi.org/10.1145/1376616.1376723 ER -