DocumentCode :
2160084
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
fYear :
2005
fDate :
05-08 April 2005
Firstpage :
1220
Lastpage :
1220
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;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering Workshops, 2005. 21st International Conference on
Print_ISBN :
0-7695-2657-8
Type :
conf
DOI :
10.1109/ICDE.2005.175
Filename :
1647837
Link To Document :
بازگشت