发明名称 System and Method for Time Parameter Based Database Restoration
摘要 A system and method are provided for the recovery and restoration of software records of a database server to record iterations previous to the current state of the selected records. This action may be taken in order to overcome the consequences of database corruption. An event-time may be designated which is applied to select some or all of the earlier but most recent versions of each selected record. The system and method presented include a local target database for the purpose of recording software records to an archive, and may include a remote source database, from which records may be transmitted to the local target database. A restore command may be detected by the database server as sent from the remote source server, as received in an electronic message, as received via an electronics communications network, or as directly input. The local target database may have access to multiple iterations or versions of a software record including the original record version as stored in an archive, and may, upon instruction or command, revert to a previous iteration of a software record stored in the archive if corruption of later iterations is suspected. Alternatively or additionally, the local target database may not be restored with earlier versions of records but the remote source database may be restored with the selected record versions. The software records may optionally be updated in a batch method, or may alternatively be updated in real time, as the software records are created.
申请公布号 US2017075764(A1) 申请公布日期 2017.03.16
申请号 US201615139177 申请日期 2016.04.26
申请人 Banister Richard 发明人 Banister Richard
分类号 G06F11/14 主分类号 G06F11/14
代理机构 代理人
主权项 1. A method comprising: a. in a target database management system, maintaining the most recent versions of a plurality of records in a target database; b. archiving outdated versions of the plurality of records in an archive; c. receiving a command to select archived record versions as stored in the archive in relation to a specified restore time point, wherein each selected archived record version of each record has an associated version time point that is earlier than the restore time point and closest to the restore time point of all archived record versions of a same record; and d. applying the selected archived record versions to restore a restore database.
地址 Vista CA US