Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for data manipulation and data recovery in distributed database

A database and distributed technology, applied in the field of distributed databases, can solve problems such as many interference results, long failure time of distributed databases, rough search conditions, etc.

Pending Publication Date: 2022-05-17
CHINA TELECOM CLOUD TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In a distributed database environment, the database administrator (DBA) cannot quickly locate the specific physical node of the underlying database where the wrong statement is executed and the specific statement information executed
[0005] In addition, due to the rough search conditions supported by binlog2sql, there are too many interference results, and manual operation is prone to data omission or misselection, resulting in secondary pollution of data
[0006] In addition, because the distributed database involves multiple underlying databases, in order to restore the data in the distributed database, it is necessary to perform corresponding recovery operations in each underlying database, which is time-consuming, which will lead to overtime of the distributed database. long downtime

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
  • Method for data manipulation and data recovery in distributed database
  • Method for data manipulation and data recovery in distributed database
  • Method for data manipulation and data recovery in distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The following detailed description is made with reference to the accompanying drawings, and is provided to assist in a comprehensive understanding of various example embodiments of the present disclosure. The following description includes various details to aid in understanding, but these are to be regarded as examples only and not for the purpose of limiting the disclosure, which is defined by the appended claims and their equivalents. Words and phrases used in the following description are used only to enable a clear and consistent understanding of the present disclosure. In addition, descriptions of well-known structures, functions, and configurations may be omitted for clarity and conciseness. Those of ordinary skill in the art will recognize that various changes and modifications of the examples described herein can be made without departing from the spirit and scope of the disclosure.

[0022] figure 1 A block diagram of a system for implementing the present in...

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 relates to a method for recovering data in a distributed database, which comprises the following steps of: operating keywords in command statements according to the data; the method comprises the following steps: determining a data manipulation command to execute a flash-back operation, fingerprint information corresponding to the data manipulation command and routing information for routing to a bottom data storage database involved in the data manipulation command through a search server; according to the fingerprint information corresponding to the data manipulation command to be subjected to the flash-back operation, determining an operation log event containing the fingerprint information in each underlying data storage database pointed by the routing information; generating a reverse statement of the transactional statement according to the transactional statement contained in the operation log event; and executing the reverse statement in an underlying data storage database.

Description

technical field [0001] The present disclosure relates generally to distributed databases, and more particularly to data manipulation and data recovery in distributed databases. Background technique [0002] In a distributed database, there is a possibility that data in the distributed database needs to be restored. For example, when a certain data manipulation command is a misoperation, the user may wish to restore the data in the distributed database to the state before the misoperation. [0003] A distributed database usually consists of multiple underlying databases. Most of the existing recovery tools support data recovery of a single underlying database. For example, binlog2sql, a commonly used data recovery tool in the industry, generates reverse statements by serially parsing the binary log files of the underlying database, and finds out matching error statements through manual comparison. [0004] In a distributed database environment, the database administrator (...

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): G06F16/27G06F16/2455G06F11/14
CPCG06F16/27G06F16/2455G06F11/1458
Inventor 钟小燕
Owner CHINA TELECOM CLOUD TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com