Lecture 15. Self-Managing DBMS Technology: The AutoAdmin Experience

 

Readings:

No readings for this class. This class is a guest lecture.

 

Speaker:

Dr. Surajit Chaudhuri from Microsoft Research

Dr. Surajit Chaudhuri leads the Data Management and Exploration Group at Microsoft Research. His areas of interest include self-tuning database systems, query optimization, data cleaning and other tools for data integration, understanding synergy between IR and DBMS. As his work outside of database research, he led the development of CMT, a conference management service hosted by Microsoft Research since 1999 for the academic community. Surajit has a PhD from Stanford University and is an ACM Fellow. He was awarded the SIGMOD Contributions Award in 2004 and the VLDB 10-year Best paper award in 2007.

Abstract:

The cost of ownership of any commercial database system is significant. The AutoAdmin project at Microsoft Research was initiated (well before the term Autonomic Computing became a buzzword) to develop techniques to reduce the overhead of database administration. Our goal was to make it easier to monitor the server and develop self-tuning techniques for performance management. The technology from this project has been incorporated in the Microsoft SQL Server 2005 (and earlier releases - SQL Server 7.0 and SQL Server 2000). This talk will take a look at some of the past research results and discuss challenges and opportunities in self-tuning DBMS research.

 

Lecture notes:

lecture15.pdf

 

Additional resources: