Towards cost-effective storage provisioning for DBMSs

Proceedings of the VLDB Endowment

Volumn 5, Issue 4, 2011, Pages 274-285

  Zhang, Ning ^a   Tatemura, Junichi ^b   Patel, Jignesh M ^a   Hacig̈um̈uş, Hakan ^b  

^a University of Wisconsin Madison   (United States)

^b NEC LABORATORIES AMERICA   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

COMPUTER ARCHITECTURE; COST EFFECTIVENESS; COSTS; DATABASE SYSTEMS; HARD DISK STORAGE;

COST-EFFECTIVE STORAGES; DATA CENTERS; HARD DISK DRIVE; HARDWARE COST; ON-MACHINES; PROCESSING ARCHITECTURES; QUERY OPTIMIZATION; RE SOURCES;

DIGITAL STORAGE;

EID: 84863769347     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/2095686.2095687     Document Type: Article

References (27)

1. Database test suite. http://osdldbt.sourceforge.net/.
2. Oracle sparc supercluster with t3-4 servers, tpc-c 5.11.0, retrieved on 19-may-2011. http://www.tpc.org/results/individual results/Oracle/Oracle SPARC SuperCluster with T3-4s TPC-C ES 120210.pdf.
3. Towards cost-effective storage provisioning for DBMSs: Addendum - extended version. http://pages.cs.wisc.edu/~nzhang/pubs/vldb extended.pdf.
4. SQL azure service level agreement (SLA), retrieved on october 27, 2010. http://go.microsoft.com/fwlink/?LinkId=159706.
5. D. Agrawal, D. Ganesan, R. K. Sitaraman, Y. Diao, and S. Singh. Lazy-adaptive tree: An optimized index structure for flash devices. PVLDB, 2(1):361-372, 2009.
6. S. Agrawal, E. Chu, and V. R. Narasayya. Automatic physical design tuning: workload as a sequence. In SIGMOD Conference, pages 683-694, 2006.
7. N. Bobroff, A. Kochut, and K. A. Beaty. Dynamic placement of virtual machines for managing SLA violations. In Integrated Network Management, pages 119-128, 2007.
8. N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In SIGMOD Conference, pages 227-238, 2005.
9. N. Bruno and S. Chaudhuri. An online approach to physical design tuning. In ICDE, pages 826-835, 2007.
10. 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, 2(2):1318-1329, 2009.
11. M. Canim, G. A. Mihaila, B. Bhattacharjee, K. A. Ross, and C. A. Lang. SSD bufferpool extensions for database systems. PVLDB, 3(2), 2010.
12. S. Chaisiri, B.-S. Lee, and D. Niyato. Optimal virtual machine placement across multiple cloud providers. In APSCC, pages 103-110, 2009.
13. S. Chaudhuri and V. R. Narasayya. Self-tuning database systems: A decade of progress. In VLDB, pages 3-14, 2007.
14. G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: amazon's highly available key-value store. In SOSP, pages 205-220, 2007.
15. G. Graefe. The five-minute rule twenty years later, and how flash memory changes the rules. In DaMoN, page 6, 2007.
16. J. R. Hamilton. Cooperative expendable micro-slice servers (cems): Low cost, low power servers for internet-scale services. In CIDR, 2009.
17. C. Hyser, B. McKee, R. Gardner, and B. J. Watson. Autonomic virtual machine placement in the data center. HPL-2007-189, 2008.
18. I. Koltsidas and S. Viglas. Flashing up the storage layer. PVLDB, 1(1):514-525, 2008.
19. S.-W. Lee and B. Moon. Design of flash-based DBMS: an in-page logging approach. In SIGMOD Conference, 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 Conference, pages 1075-1086, 2008.
21. Y. Li, B. He, J. Yang, Q. Luo, and K. Yi. Tree indexing on solid state drives. PVLDB, 3(1):1195-1206, 2010.
22. O. Ozmen, K. Salem, J. Schindler, and S. Daniel. Workload-aware storage layout for database systems. In SIGMOD Conference, pages 939-950, 2010.
23. M. Polte, J. Simsa, and G. Gibson. Enabling enterprise solid state disks performance. In Workshop on Integrating Solid-state Memory into the Storage Hierarchy, 2009.
24. K. A. Ross. Modeling the performance of algorithms on flash memory devices. In DaMoN, pages 11-16, 2008.
25. M. A. Shah, S. Harizopoulos, J. L. Wiener, and G. Graefe. Fast scans and joins using flash drives. In DaMoN, pages 17-24, 2008.
26. A. A. Soror, U. F. Minhas, A. Aboulnaga, K. Salem, P. Kokosielis, and S. Kamath. Automatic virtual machine configuration for database workloads. In SIGMOD Conference, pages 953-966, 2008.
27. D. Tsirogiannis, S. Harizopoulos, M. A. Shah, J. L. Wiener, and G. Graefe. Query processing techniques for solid state drives. In SIGMOD Conference, pages 59-72, 2009.