Dropped database table recovery
US6684225B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 27, 2000 |
| Grant date | Jan 27, 2004 |
| Priority date | — |
| Expiry date | Aug 24, 2021 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.