{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,5,2]],"date-time":"2023-05-02T23:32:10Z","timestamp":1683070330615},"reference-count":39,"publisher":"Association for Computing Machinery (ACM)","issue":"1","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Database Syst."],"published-print":{"date-parts":[[2010,2]]},"abstract":"Virtual machine monitors are becoming popular tools for the deployment of database management systems and other enterprise software. In this article, we consider a common resource consolidation scenario in which several database management system instances, each running in a separate virtual machine, are sharing a common pool of physical computing resources. We address the problem of optimizing the performance of these database management systems by controlling the configurations of the virtual machines in which they run. These virtual machine configurations determine how the shared physical resources will be allocated to the different database system instances. We introduce a virtualization design advisor that uses information about the anticipated workloads of each of the database systems to recommend workload-specific configurations offline. Furthermore, runtime information collected after the deployment of the recommended configurations can be used to refine the recommendation and to handle changes in the workload. To estimate the effect of a particular resource allocation on workload performance, we use the query optimizer in a new what-if mode. We have implemented our approach using both PostgreSQL and DB2, and we have experimentally evaluated its effectiveness using DSS and OLTP workloads.<\/jats:p>","DOI":"10.1145\/1670243.1670250","type":"journal-article","created":{"date-parts":[[2010,2,16]],"date-time":"2010-02-16T20:51:06Z","timestamp":1266353466000},"page":"1-47","update-policy":"http:\/\/dx.doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":37,"title":["Automatic virtual machine configuration for database workloads"],"prefix":"10.1145","volume":"35","author":[{"given":"Ahmed A.","family":"Soror","sequence":"first","affiliation":[{"name":"University of Waterloo, Ontario"}]},{"given":"Umar Farooq","family":"Minhas","sequence":"additional","affiliation":[{"name":"University of Waterloo, Ontario"}]},{"given":"Ashraf","family":"Aboulnaga","sequence":"additional","affiliation":[{"name":"University of Waterloo, Ontario"}]},{"given":"Kenneth","family":"Salem","sequence":"additional","affiliation":[{"name":"University of Waterloo, Ontario"}]},{"given":"Peter","family":"Kokosielis","sequence":"additional","affiliation":[{"name":"IBM Toronto Lab, Toronto, Canada"}]},{"given":"Sunil","family":"Kamath","sequence":"additional","affiliation":[{"name":"IBM Toronto Lab, Toronto, Canada"}]}],"member":"320","published-online":{"date-parts":[[2008,2,15]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE).","author":"Agrawal R.","unstructured":"Agrawal , R. , Chaudhuri , S. , Das , A. , and Narasayya , V. R . 2003. Automating layout of relational databases . In Proceedings of the International Conference on Data Engineering (ICDE). Agrawal, R., Chaudhuri, S., Das, A., and Narasayya, V. R. 2003. Automating layout of relational databases. In Proceedings of the International Conference on Data Engineering (ICDE)."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/945445.945462"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICAC.2005.50"},{"key":"e_1_2_1_4_1","volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB).","author":"Carey M. J.","unstructured":"Carey , M. J. , Jauhari , R. , and Livny , M . 1989. Priority in DBMS resource scheduling . In Proceedings of the International Conference on Very Large Data Bases (VLDB). Carey, M. J., Jauhari, R., and Livny, M. 1989. Priority in DBMS resource scheduling. In Proceedings of the International Conference on Very Large Data Bases (VLDB)."},{"key":"e_1_2_1_5_1","volume-title":"Proceedings of the Symposium on Networked Systems Design and Implementation (NSDI).","author":"Clark C.","unstructured":"Clark , C. , Fraser , K. , Hand , S. , Hansen , J. G. , Jul , E. , Limpach , C. , Pratt , I. , and Warfield , A . 2005. Live migration of virtual machines . In Proceedings of the Symposium on Networked Systems Design and Implementation (NSDI). Clark, C., Fraser, K., Hand, S., Hansen, J. G., Jul, E., Limpach, C., Pratt, I., and Warfield, A. 2005. Live migration of virtual machines. In Proceedings of the Symposium on Networked Systems Design and Implementation (NSDI)."},{"key":"e_1_2_1_6_1","volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB).","author":"Dageville B.","unstructured":"Dageville , B. and Za\u00eft , M . 2002. SQL memory management in Oracle9i . In Proceedings of the International Conference on Very Large Data Bases (VLDB). Dageville, B. and Za\u00eft, M. 2002. SQL memory management in Oracle9i. In Proceedings of the International Conference on Very Large Data Bases (VLDB)."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223845"},{"key":"e_1_2_1_8_1","unstructured":"DBT3. OSDL Database Test Suite 3. http:\/\/sourceforge.net\/projects\/osdldbt. DBT3. OSDL Database Test Suite 3. http:\/\/sourceforge.net\/projects\/osdldbt."},{"key":"e_1_2_1_9_1","volume-title":"Proceedings of the Conference on Innovative Data Systems Research (CIDR).","author":"Dias K.","unstructured":"Dias , K. , Ramacher , M. , Shaft , U. , Venkataramani , V. , and Wood , G . 2005. Automatic performance diagnosis and tuning in Oracle . In Proceedings of the Conference on Innovative Data Systems Research (CIDR). Dias, K., Ramacher, M., Shaft, U., Venkataramani, V., and Wood, G. 2005. Automatic performance diagnosis and tuning in Oracle. In Proceedings of the Conference on Innovative Data Systems Research (CIDR)."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233352"},{"key":"e_1_2_1_11_1","volume-title":"Virtualization with KVM. Linux J","author":"Habib I.","year":"2008","unstructured":"Habib , I. 2008. Virtualization with KVM. Linux J . 2008 , 166. Habib, I. 2008. Virtualization with KVM. Linux J. 2008, 166."},{"key":"e_1_2_1_12_1","unstructured":"IBM Corporation. 2006. IBM DB2 v9 performance guide. ftp:\/\/ftp.software.ibm.com\/ps\/products\/db2\/info\/vr9\/pdf\/letter\/en_US\/db2d3e90.pdf IBM Corporation. 2006. IBM DB2 v9 performance guide. ftp:\/\/ftp.software.ibm.com\/ps\/products\/db2\/info\/vr9\/pdf\/letter\/en_US\/db2d3e90.pdf"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/1135777.1135865"},{"key":"e_1_2_1_14_1","volume-title":"Proceedings of the IEEE\/IFIP Network Operations and Management Symposium (NOMS).","author":"Khanna G.","unstructured":"Khanna , G. , Beaty , K. , Kar , G. , and Kochut , A . 2006. Application performance management in virtualized server environments . In Proceedings of the IEEE\/IFIP Network Operations and Management Symposium (NOMS). Khanna, G., Beaty, K., Kar, G., and Kochut, A. 2006. Application performance management in virtualized server environments. In Proceedings of the IEEE\/IFIP Network Operations and Management Symposium (NOMS)."},{"key":"e_1_2_1_15_1","volume-title":"Proceedings of the IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS).","author":"Liu F.","unstructured":"Liu , F. , Zhao , Y. , Wang , W. , and Makaroff , D . 2004. Database server workload characterization in an E-Commerce environment . In Proceedings of the IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS). Liu, F., Zhao, Y., Wang, W., and Makaroff, D. 2004. Database server workload characterization in an E-Commerce environment. In Proceedings of the IEEE International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunication Systems (MASCOTS)."},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1228268.1228270"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.5555\/648313.755390"},{"key":"e_1_2_1_18_1","volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB).","author":"Mehta M.","year":"1993","unstructured":"Mehta , M. and DeWitt , D. J. 1993 . Dynamic memory allocation for multiple-query workloads . In Proceedings of the International Conference on Very Large Data Bases (VLDB). Mehta, M. and DeWitt, D. J. 1993. Dynamic memory allocation for multiple-query workloads. In Proceedings of the International Conference on Very Large Data Bases (VLDB)."},{"key":"e_1_2_1_19_1","unstructured":"Microsoft Corporation. 2008. Microsoft Windows server 2008 R2 hyper-V. http:\/\/www.microsoft.com\/windowsserver2008\/en\/us\/hyperv-main.aspx. Microsoft Corporation. 2008. Microsoft Windows server 2008 R2 hyper-V. http:\/\/www.microsoft.com\/windowsserver2008\/en\/us\/hyperv-main.aspx."},{"key":"e_1_2_1_20_1","unstructured":"Microsoft Corporation. 2009. Virtualization case studies: Consolidation. http:\/\/www.microsoft.com\/virtualization\/casestudies\/consolidation\/default.mspx. Microsoft Corporation. 2009. Virtualization case studies: Consolidation. http:\/\/www.microsoft.com\/virtualization\/casestudies\/consolidation\/default.mspx."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.5555\/1097871.1098137"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/CCGRID.2009.84"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2005.176"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICAC.2006.1662376"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247612"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2005.173"},{"key":"e_1_2_1_27_1","volume-title":"Proceedings of the Workshop on Self-Managing Database Systems (SMDB).","author":"Soror A. A.","unstructured":"Soror , A. A. , Aboulnaga , A. , and Salem , K . 2007. Database virtualization: A new frontier for database tuning and physical design . In Proceedings of the Workshop on Self-Managing Database Systems (SMDB). Soror, A. A., Aboulnaga, A., and Salem, K. 2007. Database virtualization: A new frontier for database tuning and physical design. In Proceedings of the Workshop on Self-Managing Database Systems (SMDB)."},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376711"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/1341312.1341329"},{"key":"e_1_2_1_30_1","volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB).","author":"Storm A. J.","unstructured":"Storm , A. J. , Garcia-Arellano , C. , Lightstone , S. , Diao , Y. , and Surendra , M . 2006. Adaptive self-tuning memory in DB2 . In Proceedings of the International Conference on Very Large Data Bases (VLDB). Storm, A. J., Garcia-Arellano, C., Lightstone, S., Diao, Y., and Surendra, M. 2006. Adaptive self-tuning memory in DB2. In Proceedings of the International Conference on Very Large Data Bases (VLDB)."},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1242572.1242618"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICAC.2005.65"},{"key":"e_1_2_1_33_1","unstructured":"VMware. VMware. http:\/\/www.vmware.com\/. VMware. VMware. http:\/\/www.vmware.com\/."},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2007.11.719"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICAC.2007.6"},{"key":"e_1_2_1_36_1","volume-title":"Virtualbox: bits and bytes masquerading as machines. Linux J","author":"Watson J.","year":"2008","unstructured":"Watson , J. 2008. Virtualbox: bits and bytes masquerading as machines. Linux J . 2008 , 166. Watson, J. 2008. Virtualbox: bits and bytes masquerading as machines. Linux J. 2008, 166."},{"key":"e_1_2_1_37_1","volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB).","author":"Weikum G.","unstructured":"Weikum , G. , M\u00f6nkeberg , A. , Hasse , C. , and Zabback , P . 2002. Self-Tuning database technology and information services: From wishful thinking to viable engineering . In Proceedings of the International Conference on Very Large Data Bases (VLDB). Weikum, G., M\u00f6nkeberg, A., Hasse, C., and Zabback, P. 2002. Self-Tuning database technology and information services: From wishful thinking to viable engineering. In Proceedings of the International Conference on Very Large Data Bases (VLDB)."},{"key":"e_1_2_1_38_1","unstructured":"XenSource. XenSource. http:\/\/www.xensource.com\/. XenSource. XenSource. http:\/\/www.xensource.com\/."},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1109\/32.129222"}],"container-title":["ACM Transactions on Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1670243.1670250","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,29]],"date-time":"2022-12-29T09:38:33Z","timestamp":1672306713000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1670243.1670250"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2008,2,15]]},"references-count":39,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2010,2]]}},"alternative-id":["10.1145\/1670243.1670250"],"URL":"https:\/\/doi.org\/10.1145\/1670243.1670250","relation":{},"ISSN":["0362-5915","1557-4644"],"issn-type":[{"value":"0362-5915","type":"print"},{"value":"1557-4644","type":"electronic"}],"subject":[],"published":{"date-parts":[[2008,2,15]]},"assertion":[{"value":"2008-10-01","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2009-10-01","order":1,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2008-02-15","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}