|
|
|
Almaden Institute
| |
Self-Tuning Database Systems: The AutoAdmin Experience
|
Abstract:
In 1996, we started the AutoAdmin project in Microsoft Research with
the dream of working towards self-tuning database systems. Our approach
led us to build in support for “what-if” scenarios in Microsoft SQL
Server. The results from the project led to index tuning wizard component
in Microsoft SQL Server that helped automate physical database design.
In this talk, we talk about our approach, summarize the experience
of the last 5 years, and also reflect on long term challenges that
we face as an industry in realizing the dream of self-tuning database
systems.
Surajit
Chaudhuri is a senior researcher and leads the Data Management,
Exploration and Mining Group at Microsoft Research http://research.microsoft.com/dmx.The
group is pursuing projects in self-tuning database systems (with
a focus on automated physical database design), data cleaning,
and rich query environment over relational, text and XML data.
His work on self-tuning database technology and data mining has
been incorporated in the Index Tuning Wizard and Analysis server
components of Microsoft SQL Server. He is on the editorial boards
of ACM Transactions on Database Systems and IEEE Transactions
on Knowledge and Data Engineering. Surajit did his Ph.D. from
Stanford University in 1991. Against his manager’s advice, Surajit
continues to work on the Microsoft Conference Management Tool
that he had built for automating conference management that has
now been used by several academic conferences using ACM SIGMOD,
ACM SIGCHI, ACM SIGKDD, and SOSP.
|
|
|
