CN100373385C

CN100373385C - Method for back-up and restoring important data

Info

Publication number: CN100373385C
Application number: CNB031150047A
Authority: CN
Inventors: 王振宇; 蒋松平
Original assignee: ZTE Corp
Current assignee: ZTE Corp
Priority date: 2003-01-17
Filing date: 2003-01-17
Publication date: 2008-03-05
Anticipated expiration: 2023-01-17
Also published as: CN1517918A

Abstract

The present invention provides a method for backing up and restoring important data. The method comprises the following steps that 1, base lists which need backing up and restoring are freely selected according to specific conditions and the sequence of the base lists is stored in a work station or a hard disk of a PC computer in the form of a configuration file for being invoked; 2, the data of corresponding base lists in a relational database is searched according to the sequence of the base lists and is generated into backup data which is stored in the work station or the hard disk of the PC computer; 3, according to a data backup file generated in the process of backup and selected by users, data items in the file are stored into the database in the recording form of the relational database to complete the restoring operation of the data when the data needs restoring. The method can arbitrarily set up base lists which need backing up and the whole database can not be backed up during each backup. The process for backing up and restoring all configuration data can be completed in more than ten minutes or even scores of minutes, but at present, the present invention can complete the process in certain minutes.

Description

The method of a kind of backup and recovery significant data

Technical field

The invention provides a kind of backup and recover the method for significant data, particularly be to carry out in the system of data storage using system R, backup and recover the assembly and the method for significant data.

Background technology

For any one large and medium-sized software systems, the backup of data and to recover all be the most general, basic functions demand.The instrument that existing way is to use data base management system (DBMS) (DBMS is as SQL Server, Oracle etc.) to be provided is realized.But all there are very flexible, user interface shortcomings such as close friend, complicated operation inadequately to some extent.

With Microsoft SQL Server is example.In " management of SQL Server 7 relational database systems and the development guides " of in April, 2000 first published, it provides three kinds of backup modes by China Machine Press:

Backup fully---back up all database objects, data and transaction journal;

Incremental backup---all data since backup was backed up fully since the last time;

Log backup---all daily records since backup begins from the last Log backup.

More than in three kinds of backup modes, no matter any, all be to carry out, and be that structure, object and the data recording of database backs up together at entire database.Obviously dirigibility is relatively poor.If user's demand just will back up to part even to the record of single library table, then existing backup mode just can not meet the demands.

For communication and relevant industries, many times need backup and recover many cover important configuration parameters data, and relatively independent between every cover parameter, the continuity relation on having no time, for this kind situation, existing backup mode is just more inadequate aspect dirigibility.

In addition, existing backup recover tool-face to the user be mostly data base administrator (DBA), need to be grasped very specialized computing machine and Database Systems knowledge, and this instrument all is to be integrated among the data base management system (DBMS) platform (as SQL Server Enterprise Manager), so all have friendly inadequately or the like the defective of complicated operation, user interface.

Summary of the invention

The objective of the invention is in order to overcome available data backup recovery technology very flexible, complicated operation, user interface shortcoming such as close friend inadequately.Better meet communication and relevant industries, important configuration parameter data is backed up and the requirement of recovery operation repeatedly, flexibly, easily.

The operation steps that important data backup of the present invention recovers is as follows:

The first step as the case may be, is freely chosen the storehouse table that need back up recovery, and storehouse table sequence is stored in workstation or the PC hard disc of computer with the form of configuration file, in order to calling;

In second step, the data according in the corresponding storehouse table in the table sequence retrieval relevant database of storehouse generate Backup Data, are stored in workstation or the PC hard disc of computer with the text form, and what write down in the text file is the standard SQL sentence collection;

The 3rd step, when the needs restore data, one that selectes according to the user at the backup data file that backup procedure generated, and the SQL statement collection that order is carried out in this backup file can write database with the form that writes down in the relevant database with the data item in the file, finishes data restore operation.

Adopt method of the present invention, compare especially for communication and relevant industries with existing data backup restoration technology, the user can back up many parts of different configuration datas as required easily or even at the configuration data of disparate databases, use in order to checking and recovering.

Use method of the present invention, can customize the storehouse table of required backup arbitrarily, all entire database is carried out and needn't back up at every turn; Restriction when so not only having reduced database design, and improved the efficient that backup recovers.The process to the backup and the recovery of whole configuration datas of using original Technology Need tens just can finish until dozens of minutes can be finished in a few minutes now, had improved work efficiency greatly.

Use method of the present invention, can also develop user interface voluntarily, make the interface warmer, more humane, make things convenient for those of ordinary skill to manipulate according to the described design philosophy of method.Be specially adapted to communication and relevant industries, the situation that need repeatedly back up and recover important configuration data.

Description of drawings

Fig. 1 is the implementation procedure of data backup.

Embodiment

The present invention is described in further detail below in conjunction with the drawings and specific embodiments:

1. data backup

Fig. 1 has provided the implementation procedure of data backup.

The input item of data backup process is storehouse table name listing file on the hard disc of computer and the record data in the database; Output item is the backup result that provides with document form, has write down all recorded informations that need the backup library table with a plurality of Insert statements in the file.And just just can return to database to the data that backup is got well and suffered as long as carry out these Insert statements in output item restore data the time.

Step 1, read the storehouse table name in the storehouse table name listing file that is stored in the input item on the hard disc of computer in order, generate the Delete statement part of backup data file, put into first memory 1, when this part is used for restore data, delete original data in the storehouse earlier;

Step 2, for certain storehouse table, according to the storehouse table name, the storing process that utilizes the data base management system (DBMS) storer to provide can obtain the field information of this storehouse table, show the first half of the Insert statement of every record to generate this storehouse of backup---" Insert storehouse table name i (... field name m, field name n ...) Values ", put into second memory 2, this step is carried out once for each storehouse table;

Step 3, show for the storehouse in the step 2, according to storehouse table name and storehouse literary name segment information, retrieve the value of each field of every record of this storehouse table, show the latter half of the Insert statement of every record to generate this storehouse of backup---" (... the value of field m; the value of field n ...) ", put into the 3rd storer 3; This step is carried out once for every record among the table i of storehouse;

Step 4 gathers the result that step 2 and step 3 generated together, forms a complete Insert statement, in order to a record among the backup library table i, puts into the 4th storer 4; This step is carried out once for every record among the table i of storehouse;

Step 5 is all carried out once resulting result altogether with result and step 4 that step 1 is carried out once at each storehouse every record of table, puts into the result that the 5th storer 5 has just formed the data backup operation.

2. data are recovered

The file that data backup generated is write as with the standard SQL language, only these SQL statement from first to last need be carried out once getting final product when data are recovered.

The implementation of SQL statement can be encapsulated into developing application inside voluntarily, also can directly carry out in the query facility that data base management system (DBMS) provided.There are the operating personnel of database Knowledge Base can also use the arbitrary text editing machine directly to check data backup information.

3. about storehouse table name listing file

As shown in drawings, for the data backup process, listing file and data-base recording are all the system importation and are stored on the hard disc of computer, and a plurality of operation stepss all need to read information from this input item.

This storehouse table name listing file is a simple text, has listed the title that needs all of backup storehouses table.

Here it should be noted that order, the requirement that put in order of the storehouse table name in the table name listing file of storehouse corresponding to the structure Delete statement that step 1 adopted of backup procedure.Promptly, if the order of structure Delete statement is identical with storehouse table name order in the table name listing file of storehouse in the above-mentioned steps one, for the situation that foreign key constraint is arranged between the table of storehouse, in the table name listing file of storehouse, the storehouse at major key place table should come the back of storehouse, external key place table so.Vice versa.

In a word, we provided to the assembly and the method for the backup and the recovery of system's significant data, had overcome available data backup recovery technology very flexible, complicated operation, user interface shortcoming such as close friend inadequately.Better met communication and relevant industries, important configuration parameter data has been backed up and the requirement of recovery operation repeatedly, flexibly, easily.

Claims

1. a backup and recover the method for significant data may further comprise the steps:

Step 1, is as the case may be freely chosen the storehouse table that need back up recovery, and storehouse table sequence is stored in workstation or the PC hard disc of computer with the form of configuration file, in order to calling;

Step 2, according to the data in the corresponding storehouse table in the storehouse table sequence retrieval relevant database, generate Backup Data, be stored in workstation or the PC hard disc of computer with the text form, what write down in the text file is the standard SQL sentence collection;

Step 3, when the needs restore data, select according to the user one at backup data file that backup procedure generated, the SQL statement collection that order is carried out in this backup file can write database with the form that writes down in the relevant database with the data item in this backup file, finishes data restore operation; Wherein, the method for data backup of described step 2 is:

1) reads storehouse table name in the storehouse table name listing file that is stored in the input item on the hard disc of computer in order, generate the Delete statement part of backup data file, put into first memory (1), when this part is used for restore data, delete original data in the storehouse earlier;

2) for certain storehouse table, according to the storehouse table name, the storing process that utilizes the data base management system (DBMS) storer to provide can obtain the field information of this storehouse table, show the first half of the Insert statement of every record to generate this storehouse of backup---" Insert storehouse table name i (... field name m; field name n; ...) Values ", put into second memory (2), this step is carried out once for each storehouse table;

3) for step 2) in storehouse table, according to storehouse table name and storehouse literary name segment information, retrieve the value of each field of every record of this storehouse table, show the latter half of the Insert statement of every record to generate this storehouse of backup---" (... the value of field m; the value of field n; ...) ", put into the 3rd storer (3); This step is carried out once for every record among the table i of storehouse;

4) with step 2) result that generated with step 3) gathers together, forms a complete Insert statement, in order to a record among the backup library table i, puts into the 4th storer (4); This step is carried out once for every record among the table i of storehouse;

5) result and the step 4) of step 1) being carried out once all carried out once resulting result altogether at each storehouse every record of table, puts into the result that the 5th storer (5) has just formed the data backup operation.

2. the method for a kind of backup as claimed in claim 1 and recovery significant data, the implementation that it is characterized in that SQL statement is to be encapsulated into developing application inside voluntarily.

3. the method for a kind of backup as claimed in claim 1 and recovery significant data, the implementation that it is characterized in that SQL statement is directly to carry out in the query facility that provides in data base management system (DBMS).

4. the method for a kind of backup as claimed in claim 1 and recovery significant data is characterized in that using the arbitrary text editing machine directly to check data backup information.

5. the method for a kind of backup as claimed in claim 1 and recovery significant data, it is characterized in that if the order of constructing the Delete statement is identical with storehouse table name order in the table name listing file of storehouse, so for the situation that foreign key constraint is arranged between the table of storehouse, in the table name listing file of storehouse, the storehouse at major key place table should come the back of storehouse, external key place table; Vice versa.