Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Continuous data protection method and system for a database

A data protection and database technology, applied in the database field, can solve problems such as data loss and slow recovery time, reduce backup costs, speed up retrieval, and eliminate misoperations

Active Publication Date: 2019-10-22
UCLOUD TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the recovery time of this method is also slow, and only the database at a specific snapshot time can be retrieved, rather than the database before the failure, so it may cause unnecessary data loss for users

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Continuous data protection method and system for a database
  • Continuous data protection method and system for a database
  • Continuous data protection method and system for a database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to make the purpose and technical solutions of the embodiments of the present invention more clear, the technical solutions of the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiments of the present invention. Apparently, the described embodiments are some, not all, embodiments of the present invention. Based on the described embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0047] According to an embodiment of the present invention, an embodiment of a continuous data protection method for a database is provided. It should be noted that the steps shown in the flow chart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, Also, although a logical order is shown in the ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention particularly relates to a continuous data protection method and system for a database, equipment and a medium. The database comprises a first database and a second database; the first database is visible to users, the second database is invisible to a user, the second database delays copying of the first database, the first database is a first database at a first time, the second database is a first database at a second time, and the second time is delayed by a predetermined time period than the first time, and the method comprises the following steps: receiving an instruction ofretrieving the first database at a third time; updating the second database according to the instruction of retrieving the first database at the third time, wherein the updated second database is thefirst database at the third time, and the third time is between the first time and the second time; and switching the updated second database to be visible to the user, or switching the updated second database to be a new first database. According to the method, the purpose of continuous data protection can be achieved under the scene of misoperation of the database or damage of the database.

Description

technical field [0001] The invention relates to the database field, in particular to a database continuous data protection method, system, equipment and medium. Background technique [0002] At present, in the case of database misoperation or database damage, in order to retrieve the previous database, the industry usually adopts the following three methods: [0003] The first is to perform a full cold backup of the database, combined with incremental logs, and retrieve the previous database through a rollback operation. However, this method needs to update the backup database from the full cold standby time to the time before the failure occurs, and the recovery time is relatively slow. [0004] The second is to flash back the database through the reverse operation to retrieve the previous database. However, this method has restrictions on the operation type of the database. For example, if the operation type of the database is a DDL operation, since the DDL operation doe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14
CPCG06F11/1448
Inventor 罗成对宋志强丁顺
Owner UCLOUD TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products