Dropped database table recovery
CA 2279028 C · Owner: Winer, Michael J. · Inventors: Zheng, Roger Luo Q.; Mcinnis, Dale M.; Huras, Matthew A.
Overview
Its claims, description and drawings are in the Canadian Patents Database.
Open the CIPO recordAbstract From the Canadian patent
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.
Read the whole patent
Listed from its CIPO record in Patent Yard's archive of Canadian patents past their term. Its claims, description and drawings are in the CIPO record and on Google Patents, and the Claude kit works from them.
Why it's free to use
- Filed July 29, 1999 and granted September 10, 2002. A Canadian patent filed from October 1, 1989 lasts 20 years from filing, so its term ended July 29, 2019.
- A certificate of supplementary protection adds at most two years for a drug, so even that would have ended by July 29, 2021.
- We check Canadian rights only. A patent in its family in another country could still be in force: check its family on Google Patents.
Timeline
Timeline From CIPO dates
Sources & verification
Official CIPO records
Everything on this page comes from the CIPO record linked above. Contains information licensed under the Open Government Licence – Canada.