CN102096669A - Data backup method and data backup device - Google Patents

Data backup method and data backup device Download PDF

Info

Publication number
CN102096669A
CN102096669A CN2009102137718A CN200910213771A CN102096669A CN 102096669 A CN102096669 A CN 102096669A CN 2009102137718 A CN2009102137718 A CN 2009102137718A CN 200910213771 A CN200910213771 A CN 200910213771A CN 102096669 A CN102096669 A CN 102096669A
Authority
CN
China
Prior art keywords
data
backup
information
table
associated
Prior art date
Application number
CN2009102137718A
Other languages
Chinese (zh)
Inventor
何锦辉
Original Assignee
深圳速浪数字技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 深圳速浪数字技术有限公司 filed Critical 深圳速浪数字技术有限公司
Priority to CN2009102137718A priority Critical patent/CN102096669A/en
Publication of CN102096669A publication Critical patent/CN102096669A/en

Links

Abstract

The embodiment of the invention provides a data backup method. The method comprises the following steps of: acquiring configuration information and configuration data information which are set by a user, wherein the configuration information comprises configuration identification information, backup type information, backup description information and data storage time information, and the configuration data information comprises data sheet name information and index information; acquiring a backup data sheet which is required to be backed up according to the configuration information and the configuration data information; acquiring associated information of the data sheet which is required to be backed up; acquiring an associated data sheet associated with the data sheet, which is required to be backed up, according to the associated information; and backing up the backed-up data sheet and the associated data sheet, and deleting the backed-up data sheet and the associated data sheet after backing up. Accordingly, the embodiment of the invention also provides a data backup device. By implementing the embodiment of the invention, user operation can be simplified, and the method and the device can be conveniently used by the user.

Description

一种数据备份方法和数据备份装置 A data backup method and data backup apparatus

技术领域 FIELD

[0001 ] 本发明涉及电信领域,尤其涉及一种数据备份方法和数据备份装置。 [0001] The present invention relates to the field of telecommunications, particularly to a data backup method and apparatus for data backup. 背景技术 Background technique

[0002] 为了简化数据库大表的管理,目前对数据库大表设置分区来管理。 [0002] In order to simplify the management of large database table, set the partition of the current database to manage large table. 分区其实就是将表分离在若干不同的数据文件上,用分而治之的方法来支撑无限膨胀的大表,给大表在物理一级的可管理性。 The partition table is actually separated in a number of different data files, to support the large table unlimited expansion method using a separatory rule, to a large table in physical manageability level. 将大表分割成较小的分区可以改善表的维护、备份、恢复、事务及查询性能。 The large table can be split into smaller partitions to improve the table of maintenance, backup, restore, transaction and query performance. 运营支撑系统(Operational Support System, OSS)数据库中存储了所有通话详单,如果按照100万用户的现场,详单表的数据量都是在“亿”级,使用Delete命令是无法删除的,因此所有详单表都是按照分区表的方式建立,按照通话时间的月份进行分区,也就是说我们看见的详单表在物理上是按照月份分开存放的,这样在查询、统计、数据库维护上都带来便利,但是新分区需要人工提前建立,否则影响应用正常运行,分区建立操作较为复杂,对用户的使用造成不便。 Operations support systems (Operational Support System, OSS) database stores all the details of a single call, according to one million users of the site, the amount of data a single detail of the table are in the "100 million" class, use the Delete command can not be deleted, so All the details of a single table in the manner of the partition table is created, partitioned by month of talk time, which means we see the details of a single table is physically stored separately by month, so the inquiry, the statistics, database maintenance are convenience, but the need to manually advance the establishment of a new partition, or affect the normal operation of applications, partition build more complex operations, the use of user inconvenience.

发明内容 SUMMARY

[0003] 鉴于现有技术存在的问题,本发明实施例提出一种数据备份方法和数据备份装置,可以简化用户的操作,方便用户使用。 [0003] In view of the problems of the prior art, the embodiment provides a data backup method and apparatus of the present invention, data backup, the user's operation can be simplified, user-friendly.

[0004] 为了解决上述技术问题,本发明实施例提出一种数据备份方法,包括: [0004] To solve the above problems, embodiments of the present invention provides a data backup method, comprising:

[0005] 获取用户设置的配置信息和配置数据信息,所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息, 索引信息; [0005] configuration information and configuration information of the user data set, the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration information includes data the data name information, the index information;

[0006] 根据所述配置信息和所述配置数据信息获取需要备份的备份数据表; [0006] The backup data table information and the configuration information acquiring data to be backed up according to the configuration;

[0007] 获取所述需要备份的数据表的关联信息; [0007] acquiring the related information table to be backed up;

[0008] 根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表; [0008] The associated information associated with the acquisition of the data to be backed up data table associated with the table;

[0009] 对所述备份数据表和所述关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表。 [0009] The backup data tables and the data tables associated with the backup, and deleting the backup data table and the associated data table after the backup.

[0010] 相应地,本发明实施示例还提出一种数据备份装置,用于存储用户设置的配置信息和配置数据信息的存储模块,还包括: [0010] Accordingly, exemplary embodiment of the present invention also provides a data backup device for storing configuration information set by the user and the data storage module configuration information, further comprising:

[0011] 配置信息获取模块,用于获取存储模块中用户设置的配置信息和配置数据信息, 所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息,索引信息; [0011] configuration information acquisition module for acquiring data configuration information and the configuration information storage module set by the user, the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration data information includes data name information, the index information;

[0012] 备份数据表获取模块,根据所述配置信息获取模块获取的配置信息和所述配置数据信息获取需要备份的备份数据表; [0012] Table backup data acquisition module obtains configuration information acquired based on the module configuration information and the configuration data table information obtaining backup data to be backed up;

[0013] 关联信息获取模块,获取所述备份数据表获取模块得到的备份的数据表的关联信息; [0013] The related information acquisition module to acquire the backup data of the backup information table for the associated modules obtained data table;

[0014] 关联数据表获取模块,根据所述关联信息获取模块获取的关联信息获取与所述需要备份的数据表相关联的关联数据表; [0014] The associated data table acquisition module, a related information obtaining module obtaining correlation Data Sheet associated with the need to back up according to the association information;

[0015] 备份模块,对所述备份数据表获取模块获取的备份数据表和所述关联数据表获取模块获取的关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表。 [0015] The backup module, the acquiring module acquires the backup data table and the data table associated with the backup data table associated data acquisition module acquires the backup table, and deletes the backup data and the associated data table after the backup table.

[0016] 实施本发明实施例,通过获取存储模块中用户设置的配置信息和配置数据信息, 根据所述配置信息和所述配置数据信息获取需要备份的备份数据表获取所述需要备份的数据表的关联信息;根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表;对所述备份数据表和所述关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表,即可自动实现数据表的备份删除,无须用户建立分区或人工干预,从而简化用户的操作,方便用户使用。 [0016] Example embodiment of the present invention, by acquiring configuration information and configuration data in the user setting information storage module, information and the configuration information according to the configuration data obtaining backup data to be backed up table to acquire the table data to be backed up association information; according to the data table associated with the association information obtaining the data to be backed up table associated therewith; the backup data table and the data table associated with backup and the backup data after deleting the backup table said table and associated data, can automatically delete the backup data table, the user need not create partitions or manual intervention, thereby simplifying the user's operation, user-friendly.

附图说明 BRIEF DESCRIPTION

[0017] 为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动性的前提下,还可以根据这些附图获得其他的附图。 [0017] In order to more clearly illustrate the technical solutions in the embodiments or the prior art embodiment of the present invention, briefly introduced hereinafter, embodiments are described below in the accompanying drawings or described in the prior art needed to be used in describing the embodiments the drawings are only some embodiments of the present invention, those of ordinary skill in the art is concerned, without any creative effort, and can obtain other drawings based on these drawings.

[0018] 图1是本发明实施中数据备份方法的流程图; [0018] FIG. 1 is a flowchart of a data backup method of the present invention;

[0019] 图2是本发明实施中数据备份装置的结构原理图。 [0019] FIG. 2 is a data structure diagram of the embodiment of the present invention, the backup device.

具体实施方式 Detailed ways

[0020] 本发明实施例提出一种数据备份方法和数据备份装置,可以简化用户的操作,方便用户使用。 Example [0020] The present invention provides a method for data backup and data backup device, the user's operation can be simplified, user-friendly.

[0021] 图1是本发明实施中数据备份方法的流程图,本发明实施中数据备份方法包括: [0021] FIG. 1 is a flowchart of a data backup method of the present invention, the embodiment of the present invention, a data backup method comprising:

[0022] 步骤101,获取用户设置的配置信息和配置数据信息,所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息,索引信息; [0022] Step 101, configuration information and the configuration information of the user data set, the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration information includes data name data information, index information;

[0023] 此处,配置信息和配置数据信息是运行参数配置表,允许用户自定义的运行参数, 以及保留数据的最少时间。 [0023] Here, the configuration information and configuration information data table operating parameters, allow the user-defined operating parameters, and minimal retention time data. 配置数据信息是配置信息的子表,规定当数据备份是按照配置信息定义的参数运行时,应用程序具体操作那些表,按照什么条件进行备份删除数据。 Sub configuration data is the configuration information table information, in accordance with a predetermined parameter when the data is backed up configuration information defining runtime, the specific application operation of those tables, deleting backup data according to what conditions. 如此类推,数据备份时会根据用户输入的参数,匹配配置信息,从而找到配置数据信息,也找到需要具体操作的对象和操作条件。 And so on, based on user input parameters, backup data match the configuration information, the configuration data in order to find information, also find the need for specific operations and operating conditions of the object. 当然这些初始化数据需要熟悉业务的人维护,也就是说, 如果数据备份时是给OSS使用,那么需要对OSS数据模型熟悉的工程师建立初始化数据;如果给其他系统使用,那么需要对其他系统数据模型熟悉的工程师建立初始化数据。 Of course, these data need to initialize the people familiar with the business of maintenance, that is, if the data backup is to use OSS, you need to build a data model initialization data for OSS engineers familiar; if for other systems, you need the data to other systems model establish initialization data familiar to engineers. 通过灵活的配置,数据备份能够根据为不同系统完成备份删除操作。 Flexible configuration, backup data to complete the delete operation is different according to the backup system.

[0024] 步骤102,根据所述配置信息和所述配置数据信息获取需要备份的备份数据表; [0024] Step 102, according to the configuration information and the configuration information acquiring data backs up the data table;

[0025] 步骤103,获取所述需要备份的数据表的关联信息; [0025] Step 103, acquiring the related information table to be backed up;

[0026] 步骤104,根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表; [0026] Step 104, according to the association information associated with the acquired data to be backed up data table associated with the table;

[0027] 此处,数据备份是通过参数配置表找到需要操作的对象后,还不能立即根据条件备份删除数据,因为在数据库中,各个表之间的数据是互相关联了,如果要删除备份数据表,根据数据关联性,首先需要删除关联数据表。 [0027] Here, after the backup data object is found to be operated by the parameter configuration table, not immediately delete the backup data according to the conditions, as in the database, the data shows association between each of the another, if the backup data to be deleted table, according to data relevance, first need to delete the associated data tables. 具体实施时,可以根据所述关联信息通过递归算法获取所有与所述需要备份的数据表相关联的关联数据表,可以通过SQL语句可以查找指定表都被哪些子表关联。 In specific implementation, the associated data may be acquired all the data table associated with the table needs to be backed by a recursive algorithm according to the association information table may be to find a specific SQL statements which are associated with the sub-table. 数据备份在处理第一层表时,根据参数配置表配置数据信息的条件,以及用户运行时输入的时间范围,查找第一层表的所有符合条件的记录,将符合要求的记录的主键ID存放在一个新建立的临时表1,如果第一层表有关联的子表,则将临时表1通过递归函数传递到第二层表,第二层表根据临时表1查找所有符合条件的记录,将符合要求的记录的主键ID存放在一个新建立的临时表2,然后再传递到第三层表,如此类推,到达最后一层表时,就可以进行备份删除操作。 Data backup table when processing a first layer, the configuration according to the condition table data information parameter configuration, and the time frame input by the user operation, the first layer of lookup tables for all matching records, the records according to the master key ID storage requirements in a newly created temporary table 1, if the table has a first sub-layer associated with the table, table 1 will be transferred to the second temporary table through the recursive function layer, the second layer lookup table of all the matching records in accordance with a temporary table, when the compliance of the primary key ID is stored in a record newly created temporary table 2, and then transmitted to the third layer table, and so on, reaching the final layer of the table, delete the backup operation can be performed. 如此类推,如此类推,数据备份就是通过以上方式对数据表进行自动搜索,自动从低到高遍历关联关系。 And so on, and so on, data backup is automatic search of the data table in the above manner, automatically from low to high traversing relationships.

[0028] 步骤105,对所述备份数据表和所述关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表。 [0028] Step 105, the backup data table and the associated data table backup, and deleting the backup data table and the associated data table after the backup.

[0029] 此处,具体实施时,根据时间范围对所述备份数据表和所述关联数据表进行备份。 [0029] Here, the specific implementation, according to the time range for the backup to the backup data table and the associated data table. DataBackup在备份方面遵循如下原则:1、以备份时间作为目录,例如备份2001_01_01 到2001-02-01之间的所有数据,目录名称为:20010101-20010201 ;每个表生成一个或多个文件,文件命名规则为“表名时间”,例如:0VERPAY20010101-20010201. txt ;2、如果文件记录数大于配置文件参数,生成子目录,文件名添加顺序号,例如:子目录OVERPAY,文件名0VERPAY20010101-20010201-00x. txt ;3、文件内容按表结构字段顺序排列,包含字段名称(用#开头),各内容以“,”分隔,方便日后再次将数据导入到数据库根据备份先后顺序,将表名生成一个文件,也是方便日后再次将数据导入到数据库。 In terms of backup DataBackup follow the following principles: 1, as a backup catalog, for example, all the data between the backup 2001_01_01 2001-02-01, directory name: 20010101-20010201; each table generating one or more files, naming convention "time table", for example: 0VERPAY20010101-20010201 txt; 2, if the file record number is greater than the profile parameters, generating a subdirectory, file name adding sequence number, for example: subdirectory OVERPAY, file name 0VERPAY20010101-20010201- . 00x txt; 3, contents of a file table structure field order, the field contains the name (beginning with #), to each content "," separated, again to facilitate future import data into the database from a backup order, to generate a table name files, but also to facilitate future re-import the data into the database. 在备份成功后进行删除操作, 如果遇到数据量超大,还可以自动设定专用的回滚段。 Delete operation after the backup is successful, if you encounter a large amount of data can also be automatically set specific rollback segment.

[0030] 图2是本发明实施中数据备份装置的结构原理图,本发明实施中数据备份装置包括: [0030] FIG. 2 is a data structure diagram of the embodiment of the present invention, the backup device, the backup device of the embodiment of the present invention, the data comprising:

[0031] 存储模块21,用于存储用户设置的配置信息和配置数据信息; [0031] The storage module 21 for storing the configuration information and the user setting information of configuration data;

[0032] 配置信息获取模块22,用于获取存储模块21中用户设置的配置信息和配置数据信息,所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息,索引信息; [0032] The configuration information acquisition module 22, memory module 21 for acquiring the configuration information and the configuration information of the user data set, the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration data information includes data name information, the index information;

[0033] 此处,配置信息和配置数据信息是运行参数配置表,允许用户自定义的运行参数, 以及保留数据的最少时间。 [0033] Here, the configuration information and configuration information data table operating parameters, allow the user-defined operating parameters, and minimal retention time data. 配置数据信息是配置信息的子表,规定当数据备份是按照配置信息定义的参数运行时,应用程序具体操作那些表,按照什么条件进行备份删除数据。 Sub configuration data is the configuration information table information, in accordance with a predetermined parameter when the data is backed up configuration information defining runtime, the specific application operation of those tables, deleting backup data according to what conditions. 如此类推,数据备份时会根据用户输入的参数,匹配配置信息,从而找到配置数据信息,也找到需要具体操作的对象和操作条件。 And so on, based on user input parameters, backup data match the configuration information, the configuration data in order to find information, also find the need for specific operations and operating conditions of the object. 当然这些初始化数据需要熟悉业务的人维护,也就是说, 如果数据备份时是给OSS使用,那么需要对OSS数据模型熟悉的工程师建立初始化数据;如果给其他系统使用,那么需要对其他系统数据模型熟悉的工程师建立初始化数据。 Of course, these data need to initialize the people familiar with the business of maintenance, that is, if the data backup is to use OSS, you need to build a data model initialization data for OSS engineers familiar; if for other systems, you need the data to other systems model establish initialization data familiar to engineers. 通过灵活的配置,数据备份能够根据为不同系统完成备份删除操作。 Flexible configuration, backup data to complete the delete operation is different according to the backup system.

[0034] 备份数据表获取模块23,根据所述配置信息获取模块22获取的配置信息和所述配置数据信息获取需要备份的备份数据表; [0034] Table backup data acquisition module 23, the acquisition module 22 acquires configuration information and the configuration data table backup data to be backed up information acquired according to the configuration information;

[0035] 关联信息获取模块M,获取所述备份数据表获取模块23得到的备份的数据表的关联信息; [0035] The related information acquisition module M, the backup data table for acquiring the associated information backup module 23 of the data table obtained;

[0036] 关联数据表获取模块25,根据所述关联信息获取模块M获取的关联信息获取与所述需要备份的数据表相关联的关联数据表;关联数据表获取模块25具体还包括: [0036] Table associated data acquisition module 25, the related information obtaining module M according to the association information acquired by acquiring the associated Data Sheet associated with the need to back up; associated data acquisition module 25 specifically table further comprises:

[0037] 递归单元251,用于根据所述关联信息通过递归算法获取所有与所述需要备份的数据表相关联的关联数据表。 [0037] recursion unit 251, configured to obtain correlation data table associated with the table of all data to be backed up by the recursive algorithm according to the association information.

[0038] 此处,数据备份是通过参数配置表找到需要操作的对象后,还不能立即根据条件备份删除数据,因为在数据库中,各个表之间的数据是互相关联了,如果要删除备份数据表,根据数据关联性,首先需要删除关联数据表。 [0038] Here, after the backup data object is found to be operated by the parameter configuration table, not immediately delete the backup data according to the conditions, as in the database, the data shows association between each of the another, if the backup data to be deleted table, according to data relevance, first need to delete the associated data tables. 具体实施时,可以根据所述关联信息通过递归算法获取所有与所述需要备份的数据表相关联的关联数据表,可以通过SQL语句可以查找指定表都被哪些子表关联。 In specific implementation, the associated data may be acquired all the data table associated with the table needs to be backed by a recursive algorithm according to the association information table may be to find a specific SQL statements which are associated with the sub-table. 数据备份在处理第一层表时,根据参数配置表配置数据信息的条件,以及用户运行时输入的时间范围,查找第一层表的所有符合条件的记录,将符合要求的记录的主键ID存放在一个新建立的临时表1,如果第一层表有关联的子表,则将临时表1通过递归函数传递到第二层表,第二层表根据临时表1查找所有符合条件的记录,将符合要求的记录的主键ID存放在一个新建立的临时表2,然后再传递到第三层表,如此类推,到达最后一层表时,就可以进行备份删除操作。 Data backup table when processing a first layer, the configuration according to the condition table data information parameter configuration, and the time frame input by the user operation, the first layer of lookup tables for all matching records, the records according to the master key ID storage requirements in a newly created temporary table 1, if the table has a first sub-layer associated with the table, table 1 will be transferred to the second temporary table through the recursive function layer, the second layer lookup table of all the matching records in accordance with a temporary table, when the compliance of the primary key ID is stored in a record newly created temporary table 2, and then transmitted to the third layer table, and so on, reaching the final layer of the table, delete the backup operation can be performed. 如此类推,如此类推,数据备份就是通过以上方式对数据表进行自动搜索,自动从低到高遍历关联关系。 And so on, and so on, data backup is automatic search of the data table in the above manner, automatically from low to high traversing relationships.

[0039] 备份模块沈,对所述备份数据表获取模块23获取的备份数据表和所述关联数据表获取模块25获取的关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表。 [0039] Shen backup module, obtain the backup data table and the associated data table module 23 to acquire the backup data table acquisition module 25 acquires related data tables for backup, and deletes the backup data after the backup sheet and the said related data tables.

[0040] 此处,具体实施时,备份模块沈包括: [0040] Here, the specific embodiment, Shen backup module comprises:

[0041] 时间备份单元沈1,用于根据时间范围对所述备份数据表和所述关联数据表进行备份。 [0041] SHEN time backup unit 1, a backup of the backup data table and the associated data table according to the time range.

[0042] 此处,以备份时间作为目录,例如备份2001-01-01到2001-02-01之间的所有数据,目录名称为:20010101-20010201 ;每个表生成一个或多个文件,文件命名规则为“表名+ 时间”,例如:0VERPAY20010101-20010201. txt。 [0042] Here, as a backup to the directory, for example, the backup of all data between 2001-01-01 to 2001-02-01, directory name: 20010101-20010201; each table generating one or more files, naming as "time table name +", for example:. 0VERPAY20010101-20010201 txt.

[0043] 备份模块沈还可以设置有如下规则:如果文件记录数大于配置文件参数,生成子目录,文件名添加顺序号,例如:子目录OVERPAY,文件名0VERPAY20010101-20010201-00x. txt ;文件内容按表结构字段顺序排列,包含字段名称(用#开头),各内容以“,”分隔,方便日后再次将数据导入到数据库根据备份先后顺序,将表名生成一个文件,也是方使日后再次将数据导入到数据库。 [0043] The backup module sink may also be provided with the following rules: If the file record number is greater than the profile parameters, generating a subdirectory, file name adding sequence number, for example: subdirectory OVERPAY, file name 0VERPAY20010101-20010201-00x txt; file content table order structure field, the name field contains the (beginning with #), to each content "," separated, again to facilitate future import data into the database from a backup sequence, to generate a file name of the table, also in the future will again cause side data into the database. 在备份成功后进行删除操作,如果遇到数据量超大,还可以自动设定专用的回滚段。 Delete operation after the backup is successful, if you encounter a large amount of data can also be automatically set specific rollback segment.

[0044] 实施本发明实施例,通过获取存储模块中用户设置的配置信息和配置数据信息, 根据所述配置信息和所述配置数据信息获取需要备份的备份数据表获取所述需要备份的数据表的关联信息;根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表;对所述备份数据表和所述关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表,即可自动实现数据表的备份删除,无须用户建立分区或人工干预,从而简化用户的操作,方便用户使用。 [0044] Example embodiment of the present invention, by acquiring configuration information and configuration data in the user setting information storage module, information and the configuration information according to the configuration data obtaining backup data to be backed up table to acquire the table data to be backed up association information; according to the data table associated with the association information obtaining the data to be backed up table associated therewith; the backup data table and the data table associated with backup and the backup data after deleting the backup table said table and associated data, can automatically delete the backup data table, the user need not create partitions or manual intervention, thereby simplifying the user's operation, user-friendly.

[0045] 以上所揭露的仅为本发明一种较佳实施例而已,当然不能以此来限定本发明之权利范围,因此依本发明权利要求所作的等同变化,仍属本发明所涵盖的范围。 [0045] The above descriptions are merely exemplary embodiments of the present invention, it, of course, not intended to limit the scope of the invention, therefore equivalent changes made under this invention as claimed in claim still covered by the scope of the present invention .

Claims (6)

1. 一种数据备份方法,其特征在于,包括:获取用户设置的配置信息和配置数据信息,所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息,索引fn息;根据所述配置信息和所述配置数据信息获取需要备份的备份数据表; 获取所述需要备份的数据表的关联信息;根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表; 对所述备份数据表和所述关联数据表进行备份,并在备份后删除所述备份数据表和所述关联数据表。 A data backup method comprising: obtaining the configuration information and the configuration information of the user data set, the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration data information includes data name information, index information fn; acquiring the related information table to be backed up;; according to the configuration information and the configuration information acquiring data backs up the data acquired according to the association information table and data sheet correlation associated with the need to back up; the backup data table and the associated data table backup, and deleting the backup data table and the associated data table after the backup.
2.如权利要求1所述的数据备份方法,其特征在于,所述根据所述关联信息获取与所述需要备份的数据表相关联的关联数据表步骤具体为:根据所述关联信息通过递归算法获取所有与所述需要备份的数据表相关联的关联数据表。 2. The data backup method according to claim 1, wherein said step of acquiring the data table associated with the need to back up the data table associated according to the association information specifically is: according to the association information is recursively algorithm to obtain all data tables associated data table associated with the backed up.
3.如权利要求2所述的数据备份方法,其特征在于,所述对所述备份数据表和所述关联数据表进行备份步骤具体为:根据时间范围对所述备份数据表和所述关联数据表进行备份。 A data backup method according to claim 2, wherein said step specifically for the backup data to the backup data table and the associated tables: the association of the table and the backup data according to the time range data tables for backup.
4. 一种数据备份装置,用于存储用户设置的配置信息和配置数据信息的存储模块,其特征在于,包括:配置信息获取模块,用于获取存储模块中用户设置的配置信息和配置数据信息,所述配置信息包括配置标识信息、备份类型信息、备份描述信息和数据保存时间信息,所述配置数据信息包括数据表名称信息,索引信息;备份数据表获取模块,根据所述配置信息获取模块获取的配置信息和所述配置数据信息获取需要备份的备份数据表;关联信息获取模块,获取所述备份数据表获取模块得到的备份的数据表的关联信息; 关联数据表获取模块,根据所述关联信息获取模块获取的关联信息获取与所述需要备份的数据表相关联的关联数据表;备份模块,对所述备份数据表获取模块获取的备份数据表和所述关联数据表获取模块获取的关联数据表进行备份,并在 A data backup means for storing module configuration information and configuration information stored in the data set by the user, wherein, comprising: a configuration information obtaining module, configured to obtain user configuration information stored in the module and set the configuration data the configuration information includes configuration identification information, type information of the backup, the backup data stored description information and time information, the configuration information includes data the data name information, index information; table backup data acquisition module, according to the configuration information acquisition module the acquired data configuration information and the configuration information table acquiring backup data to be backed up; related information acquisition module to acquire the backup data of the backup information table for the associated modules obtained data table; table associated data acquisition module according to the related information acquisition module acquires associated information acquiring association data table data table associated with the need to backup; backup module, the acquiring module acquires the backup data table and the data table associated with the backup data table for acquiring module data backup association table, and 备份后删除所述备份数据表和所述关联数据表。 After deleting the backup data of the backup data table and the associated tables.
5.如权利要求4所述的数据备份装置,其特征在于,所述关联数据表获取模块包括: 递归单元,用于根据所述关联信息通过递归算法获取所有与所述需要备份的数据表相关联的关联数据表。 Correlation recursive unit for acquiring all of the data tables to be backed up by a recursive algorithm according to the association information: data backup apparatus as claimed in claim 4, characterized in that said acquisition module comprises associated data table associated with the data table.
6.如权利要求5所述的数据备份装置,其特征在于,所述备份模块包括: 时间备份单元,用于根据时间范围对所述备份数据表和所述关联数据表进行备份。 6. The data backup apparatus according to claim 5, wherein said backup module comprising: a backup unit time, is used to back up the backup data table and the associated data table according to the time range.
CN2009102137718A 2009-12-14 2009-12-14 Data backup method and data backup device CN102096669A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2009102137718A CN102096669A (en) 2009-12-14 2009-12-14 Data backup method and data backup device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2009102137718A CN102096669A (en) 2009-12-14 2009-12-14 Data backup method and data backup device

Publications (1)

Publication Number Publication Date
CN102096669A true CN102096669A (en) 2011-06-15

Family

ID=44129765

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2009102137718A CN102096669A (en) 2009-12-14 2009-12-14 Data backup method and data backup device

Country Status (1)

Country Link
CN (1) CN102096669A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102254001A (en) * 2011-07-14 2011-11-23 青岛海信网络科技股份有限公司 Efficient data management method and system
CN103678396A (en) * 2012-09-20 2014-03-26 阿里巴巴集团控股有限公司 Data backup method and device based on data models
CN104391760A (en) * 2014-11-24 2015-03-04 华为技术有限公司 Data backup method, server and system
CN104714858A (en) * 2013-12-13 2015-06-17 中国移动通信集团公司 Data backup method, data recovery method and device

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6487558B1 (en) * 1997-06-27 2002-11-26 Sun Microsystems, Inc. Method for generating database server configuration documentation
CN1517918A (en) * 2003-01-17 2004-08-04 深圳市中兴通讯股分有限公司 Method for back-up and restoring important data
CN1549128A (en) * 2003-05-15 2004-11-24 深圳市中兴通讯股份有限公司南京分公 Databank back-up method
CN101183979A (en) * 2007-11-27 2008-05-21 上海华为技术有限公司 Method and device of configuration backup

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6487558B1 (en) * 1997-06-27 2002-11-26 Sun Microsystems, Inc. Method for generating database server configuration documentation
CN1517918A (en) * 2003-01-17 2004-08-04 深圳市中兴通讯股分有限公司 Method for back-up and restoring important data
CN1549128A (en) * 2003-05-15 2004-11-24 深圳市中兴通讯股份有限公司南京分公 Databank back-up method
CN101183979A (en) * 2007-11-27 2008-05-21 上海华为技术有限公司 Method and device of configuration backup

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102254001A (en) * 2011-07-14 2011-11-23 青岛海信网络科技股份有限公司 Efficient data management method and system
CN103678396A (en) * 2012-09-20 2014-03-26 阿里巴巴集团控股有限公司 Data backup method and device based on data models
CN103678396B (en) * 2012-09-20 2017-06-13 阿里巴巴集团控股有限公司 A data backup method and apparatus for data Model
CN104714858A (en) * 2013-12-13 2015-06-17 中国移动通信集团公司 Data backup method, data recovery method and device
CN104391760A (en) * 2014-11-24 2015-03-04 华为技术有限公司 Data backup method, server and system
CN104391760B (en) * 2014-11-24 2018-03-09 华为技术有限公司 A method for data backup, and the server system

Similar Documents

Publication Publication Date Title
US7389314B2 (en) Database backup, refresh and cloning system and method
US8489549B2 (en) Method and system for resolving conflicts between revisions to a distributed virtual file system
US9613104B2 (en) System and method for building a point-in-time snapshot of an eventually-consistent data store
US9898478B2 (en) Distributed deduplicated storage system
US9405776B2 (en) Remote backup and restore
CN104160381B (en) Multi-tenant environments tenant-specific data set management method and system
US8856080B2 (en) Backup using metadata virtual hard drive and differential virtual hard drive
US8666944B2 (en) Method and system of performing a granular restore of a database from a differential backup
US20090265396A1 (en) Method, system, and program for personal data management using content-based replication
US9703640B2 (en) Method and system of performing incremental SQL server database backups
CN101253484B (en) Method for storing data from client and the client
US8650167B2 (en) Method and system for data reduction
US20140372384A1 (en) Live restore for a data intelligent storage system
US8694469B2 (en) Cloud synthetic backups
US20090164529A1 (en) Efficient Backup of a File System Volume to an Online Server
CN102395962B (en) Composite hash and list partitioning of database tables
CN100449548C (en) Method and system for synchronizing data base
US7590667B2 (en) File replication method for distributed file systems
CN102169484B (en) Comprehensive, relative and dynamic data search in virtual environment
CN101329685B (en) Implementing method of memory database on household gateway
CN102169507B (en) Implementation method of distributed real-time search engine
CN101170416B (en) Network data storage system and data access method
US8417746B1 (en) File system management with enhanced searchability
US20130110873A1 (en) Method and system for data storage and management
JP2016517124A (en) Efficient read replica

Legal Events

Date Code Title Description
C06 Publication
C53 Correction of patent for invention or patent application
COR Change of bibliographic data

Free format text: CORRECT: INVENTOR; FROM: HE JINHUI TO: YUAN JUN

C10 Entry into substantive examination
C20 Patent right or utility model deemed to be abandoned or is abandoned