发明名称 |
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 dro p, 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 t he dropped table drop. The restored and rolled forward dropped table data is written to a flat file. Th e flat file data is loaded into a recreated table in the current table space to recover the dropped table.</ SDOAB>
|
申请公布号 |
CA2279028(C) |
申请公布日期 |
2002.09.10 |
申请号 |
CA19992279028 |
申请日期 |
1999.07.29 |
申请人 |
IBM CANADA LIMITED-IBM CANADA LIMITEE |
发明人 |
ZHENG, ROGER LUO Q.;WINER, MICHAEL J.;HURAS, MATTHEW A.;MCINNIS, DALE M.;OFER, EFFI |
分类号 |
G06F12/00;G06F17/00;G06F17/30;(IPC1-7):G06F17/30 |
主分类号 |
G06F12/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|