发明名称 |
Interaction between application of a log and maintenance of a table that maps record identifiers during online reorganization of a database |
摘要 |
The present invention includes reorganization of a Database Management System (DBMS) The reorganization of the present invention is implemented by recording a first current Relative Byte Address (RBA) Then, data is copied from the old area in the table space to a new area in the table space in reorganized form. In the present invention, throughout most of reorganization a user maintains access to the DBMS's normal facilities to read and write to the old area. The DBMS uses its normal facilities to record writing, which occurs during reorganization, in,a log. The reorganization in accordance with the present invention reads the log (that has been written to during reorganization) and processes the log to the new area to bring the new area up to date. This process is performed with the use of a RID mapping table. Finally, at the end of reorganization, the user's access is switched from the old area to the new area.
|
申请公布号 |
US5721915(A) |
申请公布日期 |
1998.02.24 |
申请号 |
US19950457150 |
申请日期 |
1995.06.01 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
SOCKUT, GARY HOWARD;BEAVIN, THOMAS ABEL |
分类号 |
G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|