Toward autonomic computing with DB2 universal database

ABSTRACT

As the cost of both hardware and software falls due to technological advancements and economies of scale, the cost of ownership for database applications is increasingly dominated by the cost of people to manage them. Databases are growing rapidly in scale and complexity, while skilled database administrators (DBAs) are becoming rarer and more expensive. This paper describes the self-managing or autonomic technology in IBM's DB2 Universal Database® for UNIX and Windows to illustrate how self-managing technology can reduce complexity, helping to reduce the total cost of ownership (TCO) of DBMSs and improve system performance.

REFERENCES

• 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: Kurt P. Brown , Manish Mehta , Michael J. Carey , Miron Livny, Towards Automated Performance Tuning for Complex Workloads, Proceedings of the 20th International Conference on Very Large Data Bases, p.72-84, September 12-15, 1994
• 4: Gerhard Weikum , Christof Hasse , Axel Mönkeberg , Peter Zabback, The COMFORT automatic tuning project, Information Systems, v.19 n.5, p.381-432, July 1994 [doi>10.1016/0306-4379(94)90004-3]
• 5: Alan Skelley, DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes, Proceedings of the 16th International Conference on Data Engineering, p.101, February 28-March 03, 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 , Vivek R. Narasayya, Automated Selection of Materialized Views and Indexes in SQL Databases, Proceedings of the 26th International Conference on Very Large Data Bases, p.496-505, September 10-14, 2000
• 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: Martin R. Frank , Edward Omiecinski , Shamkant B. Navathe, Adaptive and Automated Index Selection in RDBMS, Proceedings of the 3rd International Conference on Extending Database Technology: Advances in Database Technology, p.277-292, March 23-27, 1992
• 10: Himanshu Gupta , Venky Harinarayan , Anand Rajaraman , Jeffrey D. Ullman, Index Selection for OLAP, Proceedings of the Thirteenth International Conference on Data Engineering, p.208-219, April 07-11, 1997
• 11: Avi Silberschatz , Stan Zdonik, Strategic directions in database systems—breaking out of the box, ACM Computing Surveys (CSUR), v.28 n.4, p.764-778, Dec. 1996 [doi>10.1145/242223.242295]
• 12: Surajit Chaudhuri , Vivek Narasayya, AutoAdmin “what-if” index analysis utility, Proceedings of the 1998 ACM SIGMOD international conference on Management of data, p.367-378, June 01-04, 1998, Seattle, Washington, United States
• 13: Surajit Chaudhuri , Vivek Narasayya, Microsoft index turning wizard for SQL Server 7.0, Proceedings of the 1998 ACM SIGMOD international conference on Management of data, p.553-554, June 01-04, 1998, Seattle, Washington, United States
• 14: S. Finkelstein , M. Schkolnick , P. Tiberio, Physical database design for relational databases, ACM Transactions on Database Systems (TODS), v.13 n.1, p.91-128, March 1988 [doi>10.1145/42201.42205]
• 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.quest.com/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: Hamid Pirahesh , Joseph M. Hellerstein , Waqar Hasan, Extensible/rule based query rewrite optimization in Starburst, Proceedings of the 1992 ACM SIGMOD international conference on Management of data, p.39-48, June 02-05, 1992, San Diego, California, United States
• 23: Hamid Pirahesh , T. Y. Cliff Leung , Waqar Hasan, A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS, Proceedings of the Thirteenth International Conference on Data Engineering, p.391-400, April 07-11, 1997
• 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: Markos Zaharioudakis , Roberta Cochrane , George Lapis , Hamid Pirahesh , Monica Urata, Answering complex SQL queries using automatic summary tables, Proceedings of the 2000 ACM SIGMOD international conference on Management of data, p.105-116, May 15-18, 2000, Dallas, Texas, United States
• 26: Daniel Zilio , Sam Lightstone , Kelly Lyons , Guy Lohman, Self-managing technology in IBM DB2 universal database, Proceedings of the tenth international conference on Information and knowledge management, October 05-10, 2001, Atlanta, Georgia, USA [doi>10.1145/502585.502682]
• 27: Michael Stillger , Guy M. Lohman , Volker Markl , Mokhtar Kandil, LEO - DB2's LEarning Optimizer, Proceedings of the 27th International Conference on Very Large Data Bases, p.19-28, September 11-14, 2001
• 28: Wolfgang Lehner , Roberta Cochrane , Hamid Pirahesh , Markos Zaharioudakis, fAST Refresh using Mass Query Optimization, Proceedings of the 17th International Conference on Data Engineering, p.391-398, April 02-06, 2001
• 29: Jun Rao , Chun Zhang , Nimrod Megiddo , Guy Lohman, Automating physical database design in a parallel database, Proceedings of the 2002 ACM SIGMOD international conference on Management of data, June 03-06, 2002, Madison, Wisconsin [doi>10.1145/564691.564757]