Safely and Efficiently Updating References During On-line Reorganization
Safely and Efficiently Updating References During On-line Reorganization
复制标题
在线重组期间安全高效地更新参考文献
DOI：
--
复制
发表时间：
1998
期刊：
影响因子：
--
通讯作者：
B. Salzberg
中科院分区：
文献类型：
--
作者：
Chendong Zou;B. Salzberg
随着当今对关键任务数据库的持续可用性的需求，在线重组是必要的。在本文中，我们提出了一个新的在线重组算法，推迟二次索引更新和捎带他们与用户事务。除了显著降低总I/O成本外，该算法还确保几乎所有数据库始终可用，并且重组是可中断和可重启的。我们相信，本文提出的技术可以用于提高正常的数据库更新性能。
With today’s demands for continuous availability of mission-critical databases, on-line reorganization is a necessity. In this paper we present a new on-Iine reorganization algorithm which defers secondary index updates and piggybacks them with user transactions. In addition to the significant reduction of the total I/O cost, the algorithm also assures that almost all the database is available all of the time and that the reorganization is interruptible and restartable. We believe that the technique presented in this paper could be used for improving normal database update performance as well.