Toward autonomic computing with DB2 universal database

SIGMOD Record

Volumn 31, Issue 3, 2002, Pages 55-61

  Lightstone, Sam S ^a   Lohman, Guy ^b   Zilio, Danny ^a  

^a IBM CANADA LTD   (Canada)

^b Almaden Research Laboratory   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ALGORITHMS; COMPUTATIONAL COMPLEXITY; COMPUTER HARDWARE; COMPUTER SOFTWARE; COSTS; INFORMATION TECHNOLOGY; MAINTENANCE; WAREHOUSES;

DATABASE ADMINISTRATORS (DBA); SELF-MANAGING TECHNOLOGY; TOTAL COST OF OWNERSHIP (TCO);

RELATIONAL DATABASE SYSTEMS;

EID: 2542579372     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/601858.601873     Document Type: Review

References (29)

1. S. Chaudhuri, E. Christensen, G. Graefe, V. Narasayya, and M. Zwilling. "Self-Tuning Technology in Microsoft SQL Server," IEEE Data Engineering Bulletin, 22(2) June 1999, pp. 20-26.
2. B. Schiefer and G. Valentin. "DB2 Universal Database Performance Tuning," IEEE Data Engineering Bulletin 22(2) June 1999, pp. 12-19.
3. K. Brown, M. Mehta, M. Carey, and M. Livny. "Towards Automated Performance Tuning for Complex Workloads," Proceedings, 20th International Conference on Very Large Databases, Santiago, Chile, 1994.
4. G. Weikum, C. Hasse, A. Moenkeberg, and P. Zabback. "The COMFORT Automatic Tuning Project," Information Systems, 19(5), 1994.
5. G. Lohman, G. Valentin, D. Zilio, M. Zuliani, A Skelly, "DB2 Advisor: An optimizer smart enough to recommend its own indexes," Proceedings, 16th IEEE Conference on Data Engineering, San Diego, CA, 2000.
6. D.H. Brown Associates, "DB2 UDB vs. Oracle8i: Total Cost of Ownership," D.H. Brown Associates, Inc., Port Chester, NY., December 2000.
7. Sanjay Agrawal, Surajit Chaudhuri, and Vivek R. Narasayya. "Automated Selection of Materialized Views and Indexes for SQL Databases," Proceedings, 26th International Conference on Very Large Databases, 2000, pp. 496-505.
8. P. Bernstein, M. Brodie, S. Ceri, D. DeWitt, M. Franklin, H. Garcia-Molina, J. Gray, J. Held, J. Hellerstein, H.V. Jagadish, M. Lesk, D. Maier, J. Naughton, H. Pirahesh, M. Stonebraker, and J. Ullman, "The Asilomar Report on Database Research" September, 1998. http://www.acm.org/ sigs/sigmod/record/issues/9812/asilomar.html
9. M. R. Frank, E. R. Omiecinski, S. B. Navathe, "Adaptive and Automated Index Selection in RDBMS," International Conf. on Extending Database Technology, Vienna, Austria, 1992, pp. 277-292.
10. H. Gupta, V. Harinarayan, A. Rajaraman, J. D. Ullman, "Index Selection for OLAP," Proceedings, International Conference on Data Engineering, Birmingham, U.K., April 1997, pp. 208-219.
11. A. Silberschatz, S. Zdonik, et al, "Strategic Directions in Database Systems - Breaking out of the Box," ACM Computing Surveys, 28(4), December 1996.
12. S. Chaudhuri, V. Narasayya, "AutoAdmin 'What-if' Index Analysis Utility," Proceedings, 1998 ACM SIGMOD Conference, Seattle 1998, pp. 367-378.
13. S. Chaudhuri, V. Narasayya, "Microsoft Index Tuning Wizard for SQL Server 7.0," Proceedings, 1998 ACM SIGMOD Conference, Seattle 1998, pp. 553-554.
14. S. Finkelstein, M. Schkolnick, P. Tiberio, "Physical Database Design for Relational Databases," ACM Transactions on Database Systems, 13(1), March 1988, pp. 91-128.
15. "Database Cost of Ownership Study," The Aberdeen Group 1998. http://relay.bvk.co.yu/progress/aberdeen/aberdeen.htm
16. R. Winter, K. Auerbach, "The Big Time: The 1998 Winter VLDB Survey Program winners are bigger, better, and overwhelmingly relational," Intelligent Enterprise Programming and Design Online, http://www.dbpd.com/vault/ 9808win.html
17. P. Horn, "Autonomic Computing: IBM's Perspective on the State of Information Technology", http://www.ibm.com/research/autonomic, International Business Machines, Armonk, NY, 2001
18. "Quest software central for DB2" http://www.questcom/ quest_central/db2/
19. BMCSoftware, Products and Services, SmartDBA. http://www.bmc.com/ddm/ index.html
20. DGI Achieving Breaktrough Results for DB2, http://www.breakthroughdb2. com/
21. Computer Associates, Enterprise Management, http://www3.ca.com/Solutions/ Solution.asp?ID=335
22. H. Pirahesh, J. M. Hellerstein, W. Hasan, "Extensible/Rule Based Query Rewrite Optimization in Starburst", Procs. 1992 ACM SIGMOD Conference, 1992, pp. 39-48.
23. H. Pirahesh, T. Y. C. Leung, W. Hasan, "A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS", Procs. 1997 IEEE Intl. Conf. On Data Engineering, 1997, pp. 391-400.
24. P. Gassner, G. M. Lohman, K. B. Schiefer, Y. Wang. "Query Optimization in the IBM DB2 Family", IEEE Data Engineering Bulletin 16(4), 1993, pp. 4-18.
25. M. Zaharioudakis, R. Cochrane, G. Lapis, Hamid Pirahesh, M. Urata, "Answering Complex SQL Queries Using Automatic Summary Tables", Procs. 2000 ACM SIGMOD Conference, 2000, pp. 105-116.
26. D. C. Zilio, S. Lightstone, K. A. Lyons, G. M. Lohman, "Self-Managing Technology in IBM DB2 Universal Database", Procs. Of 2001 CIKM, 2000, pp. 541-543.
27. M. Stillger, G. M. Lohman, V. Markl, M. Kandil, "LEO - DB2's LEarning Optimizer", Procs. 27th Intl. Conf. On Very Large Databases, Rome, Italy, 2001, pp. 19-28.
28. W. Lehner, R. Cochrane, H. Pirahesh, M. Zaharioudakis, "fAST Refresh using Mass Query Optimization", Procs. 2001 IEEE Intl. Conf. On Data Engineering, 2001, pp. 391-398.
29. J. Rao, C. Zhang, G. Lohman, N. Megiddo, "Automating Physical Database Design in a Parallel Database System", Proc. 2002 ACM SIGMOD Intl. Conf. On Management of Data, Madison, WI, 2002 (to appear).