Data restoration method and apparatus

A data and database technology, applied in the database field, can solve problems such as low recovery efficiency and achieve the effect of improving efficiency

Active Publication Date: 2017-07-21
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF5 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when a large number of DML operations are performed between the time point that needs to be restored and the current moment, it is necessary to execute the anti-DML operation corresponding to each DML operation one by one, and the recovery efficiency is very low

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
  • Data restoration method and apparatus
  • Data restoration method and apparatus
  • Data restoration method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0029] Such as figure 1 As shown, when the server is processing the structured query language (Structured Query Language, SQL) statement requested by the user, the parser (parser) 11 parses the SQL statement into an internal data structure recognized by the database, and the rewriter (rewrite) 12 converts the parser Generated data structures for optimization by the optimizer. Then the optimizer (optimizer) 13 generates an optimal execution plan from the d...

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 embodiment of the invention provides a data restoration method and apparatus. The method comprises the following steps: obtaining a restoration time point input by a lessee; determining at least one second timestamp between the restoration time point and a current time point in at least one first timestamp in a first buffer area, wherein each first timestamp in the at least one first timestamp corresponds to a first reverse data manipulation language DML operation, and the first reverse DML operation is a reverse DML operation after at least one second reverse DML operation is merged; and executing the at least one first reverse DML operation in one to one correspondence with the at least one second timestamp reversely and sequentially according to a time sequence. According to the data restoration method and apparatus provided by the embodiment of the invention, the timestamp corresponding to the simplified reverse DML operation that needs to be executed for data restoration according to the restoration time of the lessee, and the simplified reverse DML operation corresponding to the timestamp is executed to improve the data restoration efficiency in a multi-lessee data table sharing scene.

Description

technical field [0001] The present invention relates to the database field, and more specifically, to a data recovery method and device in the database field. Background technique [0002] In a cloud computing environment, the database supports multi-tenancy. Tenant information isolation can be achieved by using separate servers for different tenants, using different databases on the same server for different tenants, and using the same database for different tenants. For tenants with a small amount of data, in order to reduce maintenance costs, multiple tenants use the same database to store data, and the multiple tenants share data tables. [0003] In order to avoid affecting other tenants in the database when returning a tenant's misoperation, an independent database access account can be established for each tenant when multiple tenants share a data table. The server records all data manipulation language (Data Manipulation Language, DML) operations of each tenant on a...

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/1458G06F2201/835
Inventor 杨春锌熊亮春王伟
Owner HUAWEI CLOUD COMPUTING TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap