A Study on Performance Analysis of Structural Deterioration for RDBMS
A Study on Performance Analysis of Structural Deterioration for RDBMS
复制标题
RDBMS结构恶化性能分析研究
DOI：
10.1109/icde.2005.175
复制
发表时间：
2005
期刊：
影响因子：
--
通讯作者：
M. Kitsuregawa
中科院分区：
文献类型：
--
作者：
T. Hoshino;K. Goda;M. Kitsuregawa
我们的研究集中在DBMS的自主数据库重组。重组可以抵消表空间中的结构性恶化，从而恢复性能。数据更新导致的结构恶化是不可避免的，因此重组是数据库管理中的一项重要任务。目前，对于管理者是否应该进行重组，只有模糊的去组织化指标。在本文中，我们考虑的IO行为内存储和澄清之间的因果关系的结构恶化和性能恶化的水平。我们提出了一种方法来定量检测重组触发器的性能恶化，并评估它与实证测试研究。
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.