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.
- 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.]]Google Scholar
- B. Schiefer and G. Valentin. "DB2 Universal Database Performance Tuning," IEEE Data Engineering Bulletin 22(2) June 1999, pp. 12-19.]]Google Scholar
- 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.]] Google ScholarDigital Library
- G. Weikum, C. Hasse, A. Moenkeberg, and P. Zabback. "The COMFORT Automatic Tuning Project," Information Systems, 19(5), 1994.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- D.H. Brown Associates, "DB2 UDB vs. Oracle8i: Total Cost of Ownership," D.H. Brown Associates, Inc., Port Chester, NY., December 2000.]]Google Scholar
- 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.]] Google ScholarDigital Library
- 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]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- A. Silberschatz, S. Zdonik, et al, "Strategic Directions in Database Systems --- Breaking out of the Box," ACM Computing Surveys, 28(4), December 1996.]] Google ScholarDigital Library
- S. Chaudhuri, V. Narasayya, "AutoAdmin 'What-if' Index Analysis Utility," Proceedings, 1998 ACM SIGMOD Conference, Seattle 1998, pp. 367-378.]] Google ScholarDigital Library
- S. Chaudhuri, V. Narasayya, "Microsoft Index Tuning Wizard for SQL Server 7.0," Proceedings, 1998 ACM SIGMOD Conference, Seattle 1998, pp. 553-554.]] Google ScholarDigital Library
- S. Finkelstein, M. Schkolnick, P. Tiberio, "Physical Database Design for Relational Databases," ACM Transactions on Database Systems, 13(1), March 1988, pp. 91-128.]] Google ScholarDigital Library
- "Database Cost of Ownership Study," The Aberdeen Group 1998. http://relay.bvk.co.yu/progress/aberdeen/aberdeen.htm]]Google Scholar
- 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]]Google Scholar
- 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]]Google Scholar
- "Quest software central for DB2" http://www.quest.com/quest_central/db2/]]Google Scholar
- BMCSoftware, Products and Services, SmartDBA. http://www.bmc.com/ddm/index.html]]Google Scholar
- DGI Achieving Breaktrough Results for DB2, http://www.breakthroughdb2.com/]]Google Scholar
- Computer Associates, Enterprise Management, http://www3.ca.com/Solutions/Solution.asp?ID=335]]Google Scholar
- H. Pirahesh, J. M. Hellerstein, W. Hasan, "Extensible/Rule Based Query Rewrite Optimization in Starburst", Procs. 1992 ACM SIGMOD Conference, 1992, pp. 39-48.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- 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.]]Google Scholar
- 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.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- 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.]] Google ScholarDigital Library
- 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).]] Google ScholarDigital Library
Recommendations
Self-managing technology in IBM DB2 universal database
CIKM '01: Proceedings of the tenth international conference on Information and knowledge managementAs 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 ...
Autonomic features of the IBM DB2 universal database for linux, UNIX, and windows
Thevast majority of the world's structured data are now stored and managed by relational database management systems (RDBMSs). These systems provide powerful data management capabilities. However, as the power and functionality of these systems has ...
Comments