Adaptive and automated index selection in RDBMS

Autor:	Martin R. Frank, Shamkant B. Navathe, Edward Omiecinski
Rok vydání:	2005
Předmět:	Index (economics) Relational database management system Test query Computer science Integrated database Sample (statistics) Database administrator Workload Data mining computer.software_genre computer Index selection
Zdroj:	Advances in Database Technology — EDBT '92 ISBN: 3540552707 EDBT
DOI:	10.1007/bfb0032437
Popis:	We present a novel approach for a tool that assists the database administrator in designing an index configuration for a relational database system. A new methodology for collecting usage statistics at run time is developed which lets the optimizer estimate query execution costs for alternative index configurations. Defining the workload specification required by existing index design tools may be very complex for a large integrated database system. Our tool automatically derives the workload statistics. These statistics are then used to efficiently compute an index configuration. Execution of a prototype of the tool against a sample database demonstrates that the proposed index configuration is reasonably close to the optimum for test query sets.
Databáze:	OpenAIRE
Externí odkaz:	https://explore.openaire.eu/search/publication?articleId=doi_________::2e15d2d855f0187d2c2cfb6c26b2c279 https://doi.org/10.1007/bfb0032437 Zobrazit plný text záznamu