Data backup method and device, server and storage medium
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0003] The invention provides a data backup method, device, server and sto...
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.