{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,18]],"date-time":"2025-11-18T12:16:47Z","timestamp":1763468207932},"reference-count":27,"publisher":"Association for Computing Machinery (ACM)","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2011,12]]},"abstract":"<jats:p>Data center operators face a bewildering set of choices when considering how to provision resources on machines with complex I\/O subsystems. Modern I\/O subsystems often have a rich mix of fast, high performing, but expensive SSDs sitting alongside with cheaper but relatively slower (for random accesses) traditional hard disk drives. The data center operators need to determine how to provision the I\/O resources for specific workloads so as to abide by existing Service Level Agreements (SLAs), while minimizing the total operating cost (TOC) of running the workload, where the TOC includes the amortized hardware costs and the run time energy costs. The focus of this paper is on introducing this new problem of TOC-based storage allocation, cast in a framework that is compatible with traditional DBMS query optimization and query processing architecture. We also present a heuristic-based solution to this problem, called DOT. We have implemented DOT in PostgreSQL, and experiments using TPC-H and TPC-C demonstrate significant TOC reduction by DOT in various settings.<\/jats:p>","DOI":"10.14778\/2095686.2095687","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"274-285","source":"Crossref","is-referenced-by-count":12,"title":["Towards cost-effective storage provisioning for DBMSs"],"prefix":"10.14778","volume":"5","author":[{"given":"Ning","family":"Zhang","sequence":"first","affiliation":[{"name":"University of Wisconsin-Madison"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Junichi","family":"Tatemura","sequence":"additional","affiliation":[{"name":"NEC Laboratories America"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jignesh M.","family":"Patel","sequence":"additional","affiliation":[{"name":"University of Wisconsin-Madison"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hakan","family":"Hacig\u00fcm\u00fc\u015f","sequence":"additional","affiliation":[{"name":"NEC Laboratories America"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2011,12]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Database test suite. http:\/\/osdldbt.sourceforge.net\/.  Database test suite. http:\/\/osdldbt.sourceforge.net\/."},{"key":"e_1_2_1_2_1","unstructured":"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.  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."},{"key":"e_1_2_1_3_1","unstructured":"Towards cost-effective storage provisioning for DBMSs: Addendum - extended version. http:\/\/pages.cs.wisc.edu\/~nzhang\/pubs\/vldb_extended.pdf.   Towards cost-effective storage provisioning for DBMSs: Addendum - extended version. http:\/\/pages.cs.wisc.edu\/~nzhang\/pubs\/vldb_extended.pdf."},{"key":"e_1_2_1_4_1","volume-title":"retrieved on october 27","author":"SQL","year":"2010","unstructured":"SQL azure service level agreement (SLA) , retrieved on october 27 , 2010 . http:\/\/go.microsoft.com\/fwlink\/?LinkId=159706. SQL azure service level agreement (SLA), retrieved on october 27, 2010. http:\/\/go.microsoft.com\/fwlink\/?LinkId=159706."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687669"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142549"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1109\/INM.2007.374776"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066184"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367928"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687557"},{"key":"e_1_2_1_11_1","volume-title":"SSD bufferpool extensions for database systems. PVLDB, 3(2)","author":"Canim M.","year":"2010","unstructured":"M. Canim , G. A. Mihaila , B. Bhattacharjee , K. A. Ross , and C. A. Lang . SSD bufferpool extensions for database systems. PVLDB, 3(2) , 2010 . M. Canim, G. A. Mihaila, B. Bhattacharjee, K. A. Ross, and C. A. Lang. SSD bufferpool extensions for database systems. PVLDB, 3(2), 2010."},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/APSCC.2009.5394134"},{"key":"e_1_2_1_13_1","first-page":"3","volume-title":"VLDB","author":"Chaudhuri S.","year":"2007","unstructured":"S. Chaudhuri and V. R. Narasayya . Self-tuning database systems: A decade of progress . In VLDB , pages 3 -- 14 , 2007 . S. Chaudhuri and V. R. Narasayya. Self-tuning database systems: A decade of progress. In VLDB, pages 3--14, 2007."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/1294261.1294281"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1363189.1363198"},{"key":"e_1_2_1_16_1","volume-title":"CIDR","author":"Hamilton J. R.","year":"2009","unstructured":"J. R. Hamilton . Cooperative expendable micro-slice servers (cems): Low cost, low power servers for internet-scale services . In CIDR , 2009 . J. R. Hamilton. Cooperative expendable micro-slice servers (cems): Low cost, low power servers for internet-scale services. In CIDR, 2009."},{"key":"e_1_2_1_17_1","volume-title":"Autonomic virtual machine placement in the data center. HPL-2007-189","author":"Hyser C.","year":"2008","unstructured":"C. Hyser , B. McKee , R. Gardner , and B. J. Watson . Autonomic virtual machine placement in the data center. HPL-2007-189 , 2008 . C. Hyser, B. McKee, R. Gardner, and B. J. Watson. Autonomic virtual machine placement in the data center. HPL-2007-189, 2008."},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453913"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247488"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376723"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920990"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807268"},{"key":"e_1_2_1_23_1","volume-title":"Workshop on Integrating Solid-state Memory into the Storage Hierarchy","author":"Polte M.","year":"2009","unstructured":"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 . 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."},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1457150.1457153"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1457150.1457154"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376711"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559854"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2095686.2095687","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T09:45:55Z","timestamp":1672220755000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2095686.2095687"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2011,12]]},"references-count":27,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2011,12]]}},"alternative-id":["10.14778\/2095686.2095687"],"URL":"https:\/\/doi.org\/10.14778\/2095686.2095687","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2011,12]]}}}