Performance prediction for concurrent database workloads

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2011, Pages 337-348

  Duggan, Jennie ^a   Cetintemel, Ugur ^a   Papaemmanouil, Olga ^b   Upfal, Eli ^a  

^a BROWN UNIVERSITY   (United States)

^b BRANDEIS UNIVERSITY   (United States)

Author keywords

concurrency; query performance prediction

Indexed keywords

DATA HANDLING; FORECASTING; INFORMATION MANAGEMENT; QUERY PROCESSING; SEARCH ENGINES;

'CURRENT; CONCURRENCY; DATA MANAGEMENT SYSTEM; DATABASE WORKLOAD; MULTI-TENANT DATABASE; PERFORMANCE; PERFORMANCE PREDICTION; PROCESSING ENVIRONMENTS; QUERY PERFORMANCE; QUERY-PERFORMANCE PREDICTIONS;

QUALITY OF SERVICE;

EID: 79960005600     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1989323.1989359     Document Type: Conference Paper

References (17)

1. M. Ahmad, A. Aboulnaga, S. Babu, and K. Munagala. Modeling and exploiting query interactions in database systems. In Proceeding of the 17th ACM conference on Information and knowledge management, CIKM '08, pages 183-192, New York, NY, USA, 2008. ACM.
2. M. Ahmad, A. Aboulnaga, S. Babu, and K. Munagala. Qshuffler: Getting the query mix right. Data Engineering, International Conference on, 0:1415-1417, 2008.
3. M. Ahmad, S. Duan, A. Aboulnaga, and S. Babu. Interaction-aware prediction of business intelligence workload completion times. Data Engineering, International Conference on, 0:413-416, 2010.
4. L. A. Barroso, K. Gharachorloo, and E. Bugnion. Memory system characterization of commercial workloads. In Proceedings of the 25th annual international symposium on Computer architecture, ISCA '98, pages 3-14, Washington, DC, USA, 1998. IEEE Computer Society.
5. M. Calzarossa and G. Serazzi. Workload characterization: A survey. In Proceedings of the IEEE, pages 1136-1150, 1993.
6. S. Chaudhuri, R. Kaushik, and R. Ramamurthy. When can we trust progress estimators for SQL queries? In Proceedings of the 2005 ACM SIGMOD international conference on Management of data, SIGMOD '05, pages 575-586, New York, NY, USA, 2005. ACM.
7. S. Chaudhuri, V. Narasayya, and R. Ramamurthy. Estimating progress of execution for sql queries. In Proceedings of the 2004 ACM SIGMOD international conference on Management of data, SIGMOD '04, pages 803-814, New York, NY, USA, 2004. ACM.
8. A. Ganapathi, H. Kuno, U. Dayal, J. L. Wiener, A. Fox, M. Jordan, and D. Patterson. Predicting multiple metrics for queries: Better decisions enabled by machine learning. In ICDE '09: Proceedings of the 2009 IEEE International Conference on Data Engineering, pages 592-603, Washington, DC, USA, 2009. IEEE Computer Society.
9. C. Gupta, A. Mehta, and U. Dayal. PQR: Predicting Query Execution Times for Autonomous Workload Management. Autonomic Computing, International Conference on, 0:13-22, 2008.
10. K. Keeton, D. A. Patterson, Y. Q. He, R. C. Raphael, and W. E. Baker. Performance characterization of a Quad Pentium Pro SMP using OLTP workloads. volume 26, pages 15-26, New York, NY, USA, April 1998. ACM.
11. J. L. Lo, L. A. Barroso, S. J. Eggers, K. Gharachorloo, H. M. Levy, and S. S. Parekh. An analysis of database workload performance on simultaneous multithreaded processors. SIGARCH. News, 26(3):39-50, 1998.
12. G. Luo, J. Naughton, and P. Yu. Multi-query sql progress indicators. In Y. Ioannidis, M. Scholl, J. Schmidt, F. Matthes, M. Hatzopoulos, K. Boehm, A. Kemper, T. Grust, and C. Boehm, editors, Advances in Database Technology - EDBT 2006, volume 3896 of Lecture Notes in Computer Science, pages 921-941. Springer Berlin / Heidelberg, 2006.
13. G. Luo, J. F. Naughton, C. J. Ellmann, and M. W. Watzke. Toward a progress indicator for database queries. In Proceedings of the 2004 ACM SIGMOD international conference on Management of data, SIGMOD '04, pages 791-802, New York, NY, USA, 2004. ACM.
14. A. Mehta, C. Gupta, and U. Dayal. BI batch manager: a system for managing batch workloads on enterprise data-warehouses. In Proceedings of the 11th international conference on Extending database technology: Advances in database technology, EDBT '08, pages 640-651, New York, NY, USA, 2008. ACM.
15. K. Morton, M. Balazinska, and D. Grossman. ParaTimer: a progress indicator for MapReduce DAGs. In Proceedings of the 2010 international conference on Management of data, SIGMOD '10, pages 507-518, New York, NY, USA, 2010. ACM.
16. C. Rasmussen. Gaussian processes in machine learning. In Advanced Lectures on Machine Learning, volume 3176, pages 63-71. Springer Berlin / Heidelberg, 2004.
17. P. Yu, M.-S. Chen, H.-U. Heiss, and S. Lee. On workload characterization of relational database environments. IEEE Transactions on Software Engineering, 18:347-355, 1992.