TY - GEN
T1 - Packing light
T2 - 2013 IEEE 29th International Conference on Data Engineering Workshops, ICDEW 2013
AU - Duggan, Jennie
AU - Chi, Yun
AU - Hacigumus, Hakan
AU - Zhu, Shenghuo
AU - Cetintemel, Ugur
PY - 2013
Y1 - 2013
N2 - We introduce a new learning-based solution for portable database workload performance prediction. The current state of the art addresses performance prediction for individual, static hardware configurations and thus cannot generalize to new platforms without additional training. In this work, we focus on analytical databases that might be deployed on different hardware configurations, possibly offered by various Infrastructureas-a-Service (IaaS) providers in the cloud. Enabling workload performance predictions that can be ported across hardware configurations and IaaS offerings could significantly help cloud users with their service-purchase decisions and cloud providers with their provisioning decisions. Our solution is based on collaborative filtering modeling and prediction. We applied it to lightweight workload fingerprints that model the characteristics and behavior of concurrent query workloads for carefully selected, abstract hardware configurations. Our preliminary results are derived from experiments with TPC-H and TPC-DS benchmarks on the Amazon and Rackspace clouds. They demonstrate that our techniques can predict analytical workload throughput values for diverse hardware platforms with low training overhead and within approximately 30% of the correct figure.
AB - We introduce a new learning-based solution for portable database workload performance prediction. The current state of the art addresses performance prediction for individual, static hardware configurations and thus cannot generalize to new platforms without additional training. In this work, we focus on analytical databases that might be deployed on different hardware configurations, possibly offered by various Infrastructureas-a-Service (IaaS) providers in the cloud. Enabling workload performance predictions that can be ported across hardware configurations and IaaS offerings could significantly help cloud users with their service-purchase decisions and cloud providers with their provisioning decisions. Our solution is based on collaborative filtering modeling and prediction. We applied it to lightweight workload fingerprints that model the characteristics and behavior of concurrent query workloads for carefully selected, abstract hardware configurations. Our preliminary results are derived from experiments with TPC-H and TPC-DS benchmarks on the Amazon and Rackspace clouds. They demonstrate that our techniques can predict analytical workload throughput values for diverse hardware platforms with low training overhead and within approximately 30% of the correct figure.
UR - http://www.scopus.com/inward/record.url?scp=84881416968&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=84881416968&partnerID=8YFLogxK
U2 - 10.1109/ICDEW.2013.6547460
DO - 10.1109/ICDEW.2013.6547460
M3 - Conference contribution
AN - SCOPUS:84881416968
SN - 9781467353021
T3 - Proceedings - International Conference on Data Engineering
SP - 258
EP - 265
BT - 2013 IEEE 29th International Conference on Data Engineering Workshops, ICDEW 2013
Y2 - 8 April 2013 through 11 April 2013
ER -