Seminar: Self-Tuning Databases

Organizational

Lecturer: Gunter Saake, Eike Schallehn, Ingolf Geist
Time: Wed. 11:15
Location: G29 - 128

Topic: Self-Tuning Databases

Selfoptimizing database systems are one of the most exciting areas of interest in current database research. One of the reasons is the growing volume and the dynamics of data which have to be administered. There are also new application fields like "knowledge discovery in databases", which accomplishes several tasks of analysis at the same time on the data. That makes a manual optimization, for example the access paths (indices, etc..), ever more difficult. A solution for this is the automatic adaptation of system parameters, which is called Self-Tuning.


More Recent Readings

We are trying to keep this Web site up to date with links to publications published during or after the seminar.

Topics of the seminar

19.11.2003

Martin Erxleben

State-of-the-Art

Robert Müller

Projects from Microsoft & IBM

[1], [2], [3], [4], [5], [6]
     

26.11.2003

Marcel Giard

Index Selection tools in Microsoft SQL Server and IBM DB2

     

03.12.2003

Robert Rübner

Automated Selection of Materialized Views and Indexes for SQL Databases

Andreas Winter

An Evolutionary Approach to Materialized Views Selection in a Data Warehouse Environment

[9]
     

10.12.2003

Rainer Habrecht

Runtime Statistics - Self-tuning Histograms

[10], [11], [12], [13], [14]

Anja Hildebrandt

---  
     

14.01.2004

Mathias Körbs

Data-Placement

[15]

Thomas Heutling

Data-Placement - Physical Database Design for Data Warehouse

[16], [17]
     

21.01.2004

Andre Riedel

Memory Managment - Goal-Oriented Buffer Management Revisited

[18]

Sangeetha Sivaprakasam

Memory Management for Data Servers

[18], [19]
     

28.01.2004

Stefan Gerdelbracht

The COMFORT - Automatic Tuning Project

[20]

Lakshmi Dhevi Baskar

Towards a Self-tuning - RISC-Style Database System

[20], [21]


References:

[1] David Lomet, Roger Barga, Surajit Chaudhuri, Paul Larson:
„The Microsoft Database Research Group"
[2]
[3]
Surajit Chaudhuri, Vivek R. Narasayya:
“AutoAdmin 'What-if' Index Analysis Utility”
[4]
Guy M. Lohmann, Sam S. Lightstone:
"SMART: Making DB2 (more) Autonomic"
[5] Sam S. Lightstone, Guy M. Lohmann, Danny Zilio:
"Toward Autonomic COmputing with DB2 Universal Database"
[6]
[7]

G. Lohman, G. Valentin, D. Zilio, M. Zuliani, A Skelly:
"DB2 Advisor: An optimizer smart enough to recommend its own indexes"

[8] Baralis, Paraboschi, Teniente:
"Materialized View Selection in a Multidimensional Database"
[9] Chuan Zhang, Xin Yao, Jian Yang:
"An Evolutionary Approach to Materialized Views Selection in a Data Warehouse Environment"
[10] Ashraf Aboulnaga, Surajit Chaudhuri:
"Self-tuning histograms: building histograms without looking at data"
[11] Nicolas Bruno, Surajit Chaudhuri, Luis Gravano:
"STHoles: a multidimensional workload-aware histogram"
[12] Chung-Min Chen, Nick Roussopoulos:
"Adaptive selectivity estimation using query feedback"
[13] M. Muralikrishna, David J. DeWitt:
"Equi-depth histograms for estimating selectivity factors for multi-dimensional queries"
[14] Viswanath Poosala, Yannis E. Ioannidis:
"Selectivity estimation without the attribute value independence assumption"
[15] S. Agrawal, S. Chaudhuri, A. Das, V. Narasayya:
"Automating layout of relational databases"
[16] W. J. Labio, D. Quass, B. Adelberg:
"Physical database design for data warehouse"
[17] W. J. Labio, D. Quass, B. Adelberg:
"Physical database design for data darehouse – the vis problem. Technical Report"
[18] K. P. Brown, M. J. Carey, M. Livny:
"Goal-Oriented Buffer Management Revisited"
[19] Chen,C.M.,Roussopoulos:
"Adaptive database buffer allocation using query feedback"
[20] G.Weikum, C.Hasse, A.Moenkeberg, P.Zabback:
"The COMFORT Automatic Tuning Project"
[21] A.Geppert, K.R.Dittrich:
"Towards New Construction Paradigm For Persistent Systems"

 

authors of page: Stefan Gerdelbracht, Thomas Heutling
Page last modified: 11/25/2024 20:02:40