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

Data backup method and device, server and storage medium

A technology for data backup and backup tasks, applied in the database field

Active Publication Date: 2019-09-06
TENCENT TECH (SHENZHEN) CO LTD
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The invention provides a data backup method, device, server and storage medium, which can solve the problem of backup efficiency of full-state data

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 backup method and device, server and storage medium
  • Data backup method and device, server and storage medium
  • Data backup method and device, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0099] Example 1: The way of logical backup

[0100] BEGIN;

[0101] Set BACKUPNAME=' / usr / bak / my_first_backup_02' READVIEW FROM'20180109000000'TO'20180119000000'; / / Snapshot difference method for logical backup

[0102] BACKUP TYPE LO FROM my_table;

[0103] END;

example 2

[0104] Example 2: The way of physical backup

[0105] BEGIN;

[0106] Set BACKUPNAME=' / usr / bak / my_first_backup_04' READVIEW default; / / Physical backup based on regular transaction snapshots

[0107] BACKUP ALL; / / Backup the entire system, if it is to back up a certain table, it is like "BACKUP FROM my_table;"

[0108] END;

example 3

[0109] Example 3: How to mix backups

[0110] BEGIN;

[0111] Set BACKUPNAME=' / usr / bak / my_first_backup_04'READVIEW FROM'20180109000000'TO now(); / / Snapshot difference mode is used to do mixed backup, starting from the historical time '20180109000000', until all submitted data visible to this transaction Need to backup BACKUP FROM my_table01, my_table02, my_table03; / / Backup the specified three tables, or backup the entire system

[0112] Optionally, when backing up in the block backup mode, there are two situations for the data on the data block:

[0113] In the first case, there is no cross-page, and the qualified data on a certain data block can be stored in enough space on this page.

[0114] The second case, cross-page: the qualified data on a certain data block does not have enough space to store in this page, and there are subsequent pages.

[0115] Based on the above situation, for a data block, if it does not span pages, the page tail part in its data structure is sp...

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 discloses a data backup method and device, a server and a storage medium, and belongs to the technical field of databases. According to the embodiment of the invention, on the basis of the temporal database, the backup method based on the temporal data is put forward to take multiple flexible modes for data in any state in the full-state data to achieve backup, such as a logic mode or a physical mode and a logic and physical combination mode, and effective storage, safety and reliability of the temporal data are effectively guaranteed.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data backup method, device, server and storage medium. Background technique [0002] In data processing systems, especially OLAP (Online Analytical Processing, online real-time analysis) processing systems, data warehouses, big data analysis and other scenarios, it will involve storing a large amount of data in the database. Since the business may be continuously updated, a data item logically has version data corresponding to multiple states, so that the full state (current state, transition state, and historical state) data of a data item will be saved, which is convenient for system tracking Historical state data, fully exploit the value of data (any data has value, and historical state data cannot be lost). In order to ensure the data security of the above-mentioned multi-state data, it is necessary to back up the above-mentioned full-state data. However, the sharp incre...

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): G06F11/14
CPCG06F11/1458G06F2201/80G06F11/1451G06F11/1435G06F11/1461G06F11/1466G06F2201/84
Inventor 李海翔
Owner TENCENT TECH (SHENZHEN) 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

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

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