Title :
A Study on Performance Analysis of Structural Deterioration for RDBMS
Author :
Hoshino, Takashi ; Goda, Kazuo ; Kitsuregawa, Masaru
Author_Institution :
Information Science and Technology,University of Tokyo
Abstract :
Our research focuses on autonomic database reorganization for DBMS. Reorganization counteracts structural deterioration in tablespaces to recover performance. Structural deterioration through data updates is inevitable, therefore reorganization is an essential task in database administration. At present, there are only vague metrics of disorganization for judging whether administrator should perform reorganization or not. In this paper, we consider IO behavior inside storage and clarify causal relationship between level of structural deterioration and that of performance deterioration. We propose a method to quantitatively detect performance deterioration for reorganization trigger, and evaluate it with empirical test studies.
Keywords :
Automatic control; Costs; Face detection; Humans; Information science; Job shop scheduling; Performance analysis; Solids; Spatial databases; Testing;
Conference_Titel :
Data Engineering Workshops, 2005. 21st International Conference on
Print_ISBN :
0-7695-2657-8
DOI :
10.1109/ICDE.2005.175