Intelligent backup and restore system
AssigneeDatiphy Inc.
InventorYeejang James Lin
Life of this patent
Estimating the term…
Abstract
A system allows smart backup and restore of databases. The system identifies a database affected by a database operation recorded by a database event record, identifies a database operation time recorded by the database event record, and requests to restore the database to a version backed up prior to the database operation time.
Claims10
A method, for restoring a database, performed by an apparatus comprising a control unit, a storage unit, and a database modification unit, the method comprising the steps of:
- receiving, received by a network interface unit, an audit policy wherein change requests and database change commands are retrieved according to the audit policy;
- matching each database change, received by a network interface unit, to a change request, the change request results in one or more database change;
- matching each change request, received by a network interface unit, to one or more database command;
- determining, by the control unit, if there is any unmatched change request or database command;
- identifying, by the control unit, for at least one unmatched database change command, a database affected by the unmatched database change command recorded by a database event record;
- identifying, by the control unit, a database operation time recorded by the database event record;
- and
- restoring, by the database modification unit, the database to a version backed up prior to the database operation time.
A non-transitory computer readable medium on which is stored a computer program for restoring database, the computer program comprising computer instructions that when executed by a computing device causes the computing device to perform the steps for:
- receiving an audit policy wherein change requests and database change commands are retrieved according to the audit policy;
- matching each database change to a change request, wherein the change request results in one or more database change;
- matching each change request to one or more database commands;
- determining if there is any unmatched change request or database command;
- identifying, for at least one unmatched database change command, a database affected by the unmatched change command recorded by a database event record;
- identifying a database change command issued time recorded by the database event record;
- and
- restoring the database to a version backed up prior to the database change command issued time.
Dependencies are inferred from the claim text.