Data backup method and device based on parameterized configuration

Abstract

The invention discloses a data backup method and device based on parameterized configuration, and the method comprises the steps: obtaining the table name, data backup date, data backup interval period and data backup strategy of a data table to be backed up; querying each data table partition of the data table to be backed up according to a table name contained in the parameter configuration information; screening out data table partitions to be backed up from each data table partition of the data table to be backed up according to a data backup strategy contained in the parameter configuration information, and executing data backup operation on the data table partitions to be backed up; and generating a data backup date and a data backup strategy for executing the data backup operation on the data table to be backed up next time according to the data backup date and the data backup interval period of executing the data backup operation on the data table to be backed up this time. According to the method and the device, the backup data volume can be reduced so that the data redundancy is greatly reduced, and the time of a data backup process is shortened.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data backup method and device based on parameterized configuration. Background technique [0002] This section is intended to provide a background or context to embodiments of the invention that are recited in the claims. The descriptions herein are not admitted to be prior art by inclusion in this section. [0003] For most systems, there is a need for data backup. At present, for the backup of data table partitions, only backup by date is supported. For other partition methods, corresponding backup strategies need to be developed according to the specific partition methods. If the data table to be backed up is not partitioned by time, the data of each partition of the data table is usually backed up in full amount on a regular basis (for example, every day). This method leads to a large amount of redundancy in the backed up data , and the data backup process takes a long time. ...

AI Technical Summary

Problems solved by technology

[0005] In the embodiment of the present invention, a data backup method based on parameterized configuration is provided, which is used to solve the problem that in the prior art, each data table partition of the data table is regularly backed up with full data, there is data redundancy and the backup process takes a long time Problem, the method includes: obtaining parameter configuration information for performing data backup operations on the data table to be backed up, wherein the parameter configuration information includes the table name of the data table to be backed up, data backup date, data backup interval period and data backup strategy, data backup The policy is used to determine the data to be backed up in the data table to be backed up; query each data table partition of the data table to be backed up according to the table name contained in the parameter configuration information; Each data table partition of the data table screens out the data table partitions to be backed up, and performs data backup operations on the data table partitions to be backed up; according to the data backup date and data backup interval period of the data table to be backed up, the following data table is generated: The data backup date and data backup strategy for a data backup operation performed on the data table to be backed up

[0006] The embodiment of the present invention also provides a data backup device based on parameterized configuration, which is used to solve the problem of full data backup of each data table partition of the data table at regular intervals in the prior art, there is data redundancy and the backup process takes a long time Technical problem, the device includes: a parameter configuration information acquisition module, which is used to obtain parameter configuration information for performing a data backup operation on the data table to be backed up, wherein the parameter configuration information includes the table name of the data table to be backed up, the date of data backup, and the date of data backup. Interval period and data backup strategy, the data backup strategy is used to determine the data to be backed up in the data table to be backed up; the data table partition query module is used to query each data of the data table to be backed up according to the table name contained in the parameter configuration information Table partition; data backup module, used for filtering data table partitions to be backed up from each data table partition of the data table to be backed up according to the data backup strategy contained in the parameter configuration information, and performing data backup operations on the data table partitions to be backed up; The parameter configuration information update module is used to generate the data backup date and data backup strategy for the next data backup operation performed on the data table to be backed up according to the data backup date and the data backup interval cycle of the data backup operation performed on the data table to be backed up this time

[0007] The embodiment of the present invention also provides a computer device, which is used to solve the technical problems in the prior art that full data backup is regularly performed on each data table partition of the data table, there is data redundancy and the backup process takes a long time, the computer device It includes a memory, a processor, and a computer program stored on the memory and operable on the processor. When the processor executes the computer program, the above data backup method based on parameterized configuration is realized.

Images