Online autoadmin: (physical design tuning)

ABSTRACT

Existing solutions for the automated physical design problem require explicit invocations of tuning tools and critically depend on DBAs gathering representative workloads manually. In this demonstration, we show an alternative approach to the physical design problem. Specifically, we demonstrate a novel monitoring/tuning DBMS component that we prototyped in Microsoft SQL Server 2005 as a server-side extension. This component is always-on and continuously modifies the current physical design reacting to varying workload or data characteristics. Our solution imposes low overhead and takes into account storage constraints, update statements, and the cost to create physical structures.

REFERENCES

• 1: S. Agrawal et al. Database Tuning Advisor for Microsoft SQL Server 2005.
• 2: N. Bruno and S. Chaudhuri. Physical design refinement: The "Merge-Reduce" approach. In In Proceedings of EDBT, 2006.
• 3: N. Bruno and S. Chaudhuri. An online approach to physical design tuning. In In Proceedings of ICDE, 2007.
• 4: B. Dageville et al. Automatic SQL Tuning in Oracle 10g. In In Proceedings of VLDB, 2004.
• 5: D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In In Proceedings of VLDB, 2004.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.2 Physical Design
          Subjects: Access methods

General Terms:
Algorithms, Design

Keywords:
continuous tuning, online algorithms, physical design