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

Logical data backup and rollback using incremental capture in a distributed database

A database and distributed technology, applied in the field of incremental data backup and rollback technology, can solve the problems of poor restoration time target, time-consuming labor, intensive and other problems, and achieve the effect of optimizing storage

Active Publication Date: 2011-08-03
MICROSOFT TECH LICENSING LLC
View PDF6 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Also, the restore time objective (RTO) is poor because any restore operation will require restoring the entire backup and then applying a series of transaction log backup files regardless of the size of the data involved
The process is time-consuming and labor-intensive, and backups are stored in a binary format that cannot be directly queried

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
  • Logical data backup and rollback using incremental capture in a distributed database
  • Logical data backup and rollback using incremental capture in a distributed database
  • Logical data backup and rollback using incremental capture in a distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The disclosed architecture provides the ability to efficiently capture "before mirror" (increment) data changes of data operations and change tracking information and then use these changes and information to efficiently roll back update / delete / insert operations. Before mirroring data is data that has been changed, but before that changed data is processed to overwrite production data. The storage space for incremental data is a fraction of the space used for full backups and transaction log backups. Furthermore, the time to roll back update / delete / insert operations from the data capture table is small relative to the time to restore from full and transaction log backups.

[0018] As used herein, a table is a logical relationship that employs a partition key that controls partitioning across servers and also employs a cluster key that controls the ordering of rows within a server. A table group is a collection of tables with the same partition key. A row group is a co...

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

Provided is an architecture that eliminates the need for on-disk full backups of data retaining only changes that have occurred, in a separate table. Thus, the architecture provides for incremental recovery of incremental changes in a relational database (e.g., SQL). The architecture provides improved recovery time and recovery point objectives. By using the incremental capture of changed data (e.g., in an XML format), the capability is provided to capture schema changes, query the incremental change data and efficiently restore user data to an earlier point-in-time state. Changes (e.g., insert, update and delete operations) are tracked (e.g., continuously) by a set of triggers and the incrementally captured changed rows are inserted in a data capture table (a differential change ''delta'' table) in a human-readable format (e.g., XML). Rollback is also provided.

Description

technical field [0001] The present invention relates to data backup and rollback technology, more specifically to incremental data backup and rollback technology. Background technique [0002] In large distributed database systems, traditional SQL (Structured Query Language) backup and restore can be used for data protection. However, there are still disadvantages. An on-disk copy of the backup of the full database is required, which requires as much storage as the database being backed up. In addition, periodic backups of transaction logs are required for a lower restore point objective (RPO). Furthermore, the restore time objective (RTO) is poor because any restore operation, regardless of the size of the data involved, will require restoring the entire backup and then applying a series of transaction log backup files. This process is time-consuming and labor-intensive, and backups are stored in a binary format that cannot be directly queried. Contents of the inventio...

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
IPC IPC(8): G06F17/30
CPCG06F17/30G06F16/00G06F2201/80G06F16/2358
Inventor H·H·胡吴中伟O·N·泽利格S·帕尔C·罗伯B·H·M·德尼L·诺维克N·R·埃利斯T·塔留斯
Owner MICROSOFT TECH LICENSING LLC
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