|
Published Articles >> Table of Contents >> Abstract
21st International Conference on Data Engineering Workshops (ICDEW'05)
p. 1216
Towards Indexing Schemes for Self-Tuning DBMS
Kai-Uwe Sattler, TU Ilmenau, Germany
Eike Schallehn, University of Magdeburg, Germany
Ingolf Geist, University of Magdeburg, Germany
Full Article Text:
 
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.296
Send link to a friend
| Abstract |
|
Index tuning as part of database tuning is the task of selecting
and creating indexes with the goal of reducing query
processing times. However, in dynamic environments with
various ad-hoc queries it is difficult to identify potentially
useful indexes in advance. In this paper, based on previous
research regarding automatic index creation at runtime
we point out the need for new indexing schemes suitable for
self-tuning. Based on problems with previous approaches
we describe the key concepts, which are sparse and partial
indexing, usage-balanced instead of data-balanced structures,
and dynamic resource assignment. We illustrate the
approach by a simple index structure, which provides adaptability
as well as improved access characteristics. Furthermore,
we will outline key tasks to introduce according concepts
in future DBMS.
|
 Additional Information
|
Citation:
Kai-Uwe Sattler, Eike Schallehn, Ingolf Geist,
"Towards Indexing Schemes for Self-Tuning DBMS,"
icdew,
p. 1216,
21st International Conference on Data Engineering Workshops (ICDEW'05),
2005
|
|
