发明名称 |
Dropped database table recovery |
摘要 |
A database management system having a dropped table recovery flag. If the dropped table recovery flag is on at the time that a table is dropped, an entry will be made in a dropped table history file. The dropped table history file contains a timestamp of the time of table drop, a unique dropped table identifier, and table definition information. The system includes a command to permit the table-space of a dropped table to be restored and rolled forward to the point of the dropped table drop. The restored and rolled forward dropped table data is written to a flat file. The flat file data is loaded into a recreated table in the current table space to recover the dropped table.
|
申请公布号 |
US6684225(B1) |
申请公布日期 |
2004.01.27 |
申请号 |
US20000626673 |
申请日期 |
2000.07.27 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
HURAS MATTHEW ALBERT;MCINNIS DALE M.;OFER EFFI;WINER MICHAEL J.;ZHENG ROGER LUO Q. |
分类号 |
G06F12/00;G06F17/00;G06F17/30;(IPC1-7):G06F12/00 |
主分类号 |
G06F12/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|