PQR: Predicting query execution times for autonomous workload management

5th International Conference on Autonomic Computing, ICAC 2008

Volumn , Issue , 2008, Pages 13-22

  Gupta, Chetan ^a   Mehta, Abhay ^a   Dayal, Umeshwar ^a  

^a HEWLETT PACKARD LABORATORIES   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ADMINISTRATIVE DATA PROCESSING; ARTIFICIAL INTELLIGENCE; COMPUTER NETWORKS; DATABASE SYSTEMS; FORECASTING; LARGE SCALE SYSTEMS; ROBOT LEARNING; VECTORS; WAREHOUSES;

AUTONOMIC COMPUTING; EXECUTION TIME; INTERNATIONAL CONFERENCES; MACHINE-LEARNING;

DATA WAREHOUSES;

EID: 51649089144     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICAC.2008.12     Document Type: Conference Paper

References (19)

1. BEZ Systems Inc., "BEZPlus for NCR Teradata and Oracle environments on MPP machines", http://www.bez.com/software.htm, 1999.
2. R. Eberhard, "DB2 Estimator for Windows", http://www.software. ibm.com/data/db2/os390/estimate, 1999.
3. M. Garth, "Modelling parallel architectures", http://www.metron.co.uk/papers.htm#PARA, 1996.
4. A. Ghosh, J. Parikh, V. Sengar and J. Haritsa, "Plan Selection based on Query Clustering", Proc. of 28th Intl. Conf. on Very Large Data Bases (VLDB), August 2002.
5. G. Graefe, "Query Evaluation Techniques for Large Databases", ACM Computing Surveys, June 1993, ACM Press.
6. C-W Hsu and C-J. Lin, "A comparison of methods for multiclass support vector machines", IEEE Trans. on Neural Networks, 113:415(425), 2002.
7. M. A. Iverson, F. Ozguner and G. J. Follen. "Run-time statistical estimation of task execution times for heterogeneous distributed computing", Proc. of 5th IEEE International Symposium on High Performance Distributed Computing, 1996. Volume, Issue, 6-9 Aug. 1996 Page(s):263-270
8. S. Krompass, D. Gmach, A. Scholz, S. Seltzsam, and A. Kemper "Quality of Service Enabled Database Applications", Service Oriented Computing - ICSOC 2006: Fourth International Conference on Service Oriented Computing, Dec. 4-7, 2006, Chicago, Illinois, USA
9. V. Markl, G. M. Lohman, and V. Raman, "LEO: An autonomic query optimizer for DB2", IBM Systems Journal, Autonomic Computing, 42 (1), 2003.
10. Platinum Technology, "Proactive performance engineering", http://www.softool.com/products/ppewhite.htm, 1999.
11. J. R. Quinlan, "C4.5: Programs for Machine Learning", Morgan Kauffman Publishers, San Mateo, California, 1993.
12. E. E. K. Raatikainen, "Cluster Analysis and Workload Classification", Performance Evaluation Review, Vol. 20 (4), May 1993, 24-30.
13. S. Salza and R. Tomasso, "Performance Modeling of parallel database systems", Informatica 22, 1998, 127-139.
14. SES Inc., "Solutions for information systems performance", http://www.ses.com/Solution/IS.html, 1999.
15. M. Stillger, G. Lohman, V. Markl, and M. Kandil, "LEO-DB2's Learning Optimizer", Proc. of the 27th International Conference on Very Large Databases (Sept. 2001), pp. 19-28.
16. N. Tomov, E. Dempster, M. H Williams, A. Burger, H. Taylor, P. J. King and P. Broughton, "Analytical response time estimation in parallel relational database systems", Parallel Comput. 30, 2 (Feb. 2004), 249-283
17. G. Weikum, C. Hasse, A. Moenkeberg and P. Zabback: "Self-tuning Database Technology and Information Systems: from Wishful Thinking to Viable Engineering", Proc. 28th VLDB, Hong Kong, 2002.
18. I. H. Witten and E. Frank, "Data Mining: Practical machine learning tools and techniques", 2nd Edition, Morgan Kaufmann, San Francisco, 2005.
19. P. Shivam, S. Babu and J. S. Chase, "Learning application models for utility resource planning", Proc. ICAC 06, June 06, 255-264.