CN1517918A - Method for back-up and restoring important data - Google Patents
Method for back-up and restoring important data Download PDFInfo
- Publication number
- CN1517918A CN1517918A CNA031150047A CN03115004A CN1517918A CN 1517918 A CN1517918 A CN 1517918A CN A031150047 A CNA031150047 A CN A031150047A CN 03115004 A CN03115004 A CN 03115004A CN 1517918 A CN1517918 A CN 1517918A
- Authority
- CN
- China
- Prior art keywords
- storehouse
- data
- backup
- record
- file
- Prior art date
- Legal status (The legal status 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 status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method for backup and restoring important data includes such steps as choosing the database lists to be backup and restored, storing the database list sequence in the form of configuration file on hard disk, searching the data in relative database list from relational database to generate backup data, storing in the mode of text file on hard disk, and restoring the data by writing the relative data from text file to database. Its advantage is high speed.
Description
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 " SQL Server 7 relational database systems are managed in the south of bristling with anger " 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;
In the 3rd step, when the needs restore data, one that selectes according to the user writes database with the data item in the file with the form that writes down in the relevant database at the backup data file that backup procedure generated, finishes data restore operation.
Adopt method of the present invention, compare, aspect the dirigibility of operation and function qualitative leap is being arranged with existing data backup restoration technology.
Especially for communication and relevant industries, 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.
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.Obtain gratifying income in actual applications, be subjected to operating personnel's extensive favorable comment.
Claims (7)
1. a backup and recover the method for significant data may further comprise the steps:
1) as the case may be, freely choose the storehouse table that need back up recovery, storehouse table sequence is stored in workstation or the PC hard disc of computer with the form of configuration file, in order to calling;
2) according to the data in the corresponding storehouse table in the table sequence retrieval relevant database of storehouse, generate Backup Data, be stored in workstation or the PC hard disc of computer with the text form;
3) when the needs restore data, one that selectes according to the user writes database with the data item in the file with the form that writes down in the relevant database at the backup data file that backup procedure generated, finishes data restore operation.
2. the method for a kind of backup as claimed in claim 1 and recovery significant data is characterized in that described method of data backup is:
1) read 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, original data in the deletion 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.
3. the method for a kind of backup as claimed in claim 1 or 2 and recovery significant data, it is characterized in that described data reconstruction method is: 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.
4. the method for a kind of backup as claimed in claim 3 and recovery significant data, the implementation that it is characterized in that SQL statement is to be encapsulated into developing application inside voluntarily.
5. the method for a kind of backup as claimed in claim 3 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).
6. the method for a kind of backup as claimed in claim 3 and recovery significant data is characterized in that the implementation of SQL statement is to use the arbitrary text editing machine directly to check data backup information.
7. the method for a kind of backup as claimed in claim 3 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.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB031150047A CN100373385C (en) | 2003-01-17 | 2003-01-17 | Method for back-up and restoring important data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB031150047A CN100373385C (en) | 2003-01-17 | 2003-01-17 | Method for back-up and restoring important data |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1517918A true CN1517918A (en) | 2004-08-04 |
CN100373385C CN100373385C (en) | 2008-03-05 |
Family
ID=34284060
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB031150047A Expired - Fee Related CN100373385C (en) | 2003-01-17 | 2003-01-17 | Method for back-up and restoring important data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN100373385C (en) |
Cited By (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100349129C (en) * | 2004-10-27 | 2007-11-14 | 中兴通讯股份有限公司 | Processing resource monitoring and pre-warning method for computer system |
CN100410944C (en) * | 2005-02-04 | 2008-08-13 | 国际商业机器公司 | Method, system and computer program product for backing up and recovering a database |
CN100422948C (en) * | 2006-09-18 | 2008-10-01 | 毛国红 | Recovery method for computer system or data |
CN100461167C (en) * | 2005-06-06 | 2009-02-11 | 华为技术有限公司 | Universal database automatic unloading method and system |
CN101847162A (en) * | 2010-05-25 | 2010-09-29 | 中国电力科学研究院 | Electric system simulation centre data processing method based on file and database exchange |
WO2010145095A1 (en) * | 2009-06-15 | 2010-12-23 | 中兴通讯股份有限公司 | Key information area in file system maintaining method and apparatus |
CN101989305A (en) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | Data incremental backup method and system |
CN102096669A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data backup method and data backup device |
CN101460934B (en) * | 2006-05-29 | 2011-10-19 | 微软公司 | Creating frequent application-consistent backups efficiently |
CN101222527B (en) * | 2008-01-25 | 2011-12-07 | 中兴通讯股份有限公司 | Method and system for protecting terminal key configuration |
CN101667181B (en) * | 2008-09-05 | 2011-12-21 | 华为技术有限公司 | Method, device and system for data disaster tolerance |
CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
CN102624545A (en) * | 2012-02-22 | 2012-08-01 | 中兴通讯股份有限公司 | Data backup method, data backup device, data recovery method and data recovery device of network management system |
CN104424219A (en) * | 2013-08-23 | 2015-03-18 | 华为技术有限公司 | Method and equipment of managing data documents |
CN107291574A (en) * | 2016-03-30 | 2017-10-24 | 中国石油化工股份有限公司 | Backup Data based on solution release system recovers major key generation method |
CN108319466A (en) * | 2017-12-15 | 2018-07-24 | 北京先进数通信息技术股份公司 | A kind of restoration methods and device of configuration information |
CN111459720A (en) * | 2020-04-02 | 2020-07-28 | 上海新炬网络技术有限公司 | Mysql data recovery method based on transaction log |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102693174B (en) * | 2012-06-06 | 2015-02-18 | 武汉大学 | Object broker database constraint-oriented backup method |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5991772A (en) * | 1997-10-31 | 1999-11-23 | Oracle Corporation | Method and apparatus for restoring a portion of a database |
US7756818B1 (en) * | 1999-07-07 | 2010-07-13 | Computer Associates Think, Inc. | Database table recovery system |
US7043504B1 (en) * | 2000-04-10 | 2006-05-09 | International Business Machines Corporation | System and method for parallel primary and secondary backup reading in recovery of multiple shared database data sets |
-
2003
- 2003-01-17 CN CNB031150047A patent/CN100373385C/en not_active Expired - Fee Related
Cited By (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100349129C (en) * | 2004-10-27 | 2007-11-14 | 中兴通讯股份有限公司 | Processing resource monitoring and pre-warning method for computer system |
CN100410944C (en) * | 2005-02-04 | 2008-08-13 | 国际商业机器公司 | Method, system and computer program product for backing up and recovering a database |
CN100461167C (en) * | 2005-06-06 | 2009-02-11 | 华为技术有限公司 | Universal database automatic unloading method and system |
CN101460934B (en) * | 2006-05-29 | 2011-10-19 | 微软公司 | Creating frequent application-consistent backups efficiently |
CN100422948C (en) * | 2006-09-18 | 2008-10-01 | 毛国红 | Recovery method for computer system or data |
CN101222527B (en) * | 2008-01-25 | 2011-12-07 | 中兴通讯股份有限公司 | Method and system for protecting terminal key configuration |
CN101667181B (en) * | 2008-09-05 | 2011-12-21 | 华为技术有限公司 | Method, device and system for data disaster tolerance |
WO2010145095A1 (en) * | 2009-06-15 | 2010-12-23 | 中兴通讯股份有限公司 | Key information area in file system maintaining method and apparatus |
CN102096669A (en) * | 2009-12-14 | 2011-06-15 | 深圳速浪数字技术有限公司 | Data backup method and data backup device |
CN101847162A (en) * | 2010-05-25 | 2010-09-29 | 中国电力科学研究院 | Electric system simulation centre data processing method based on file and database exchange |
CN101989305A (en) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | Data incremental backup method and system |
CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
CN102624545A (en) * | 2012-02-22 | 2012-08-01 | 中兴通讯股份有限公司 | Data backup method, data backup device, data recovery method and data recovery device of network management system |
WO2013123703A1 (en) * | 2012-02-22 | 2013-08-29 | 中兴通讯股份有限公司 | Data backup method and device, and data recovery method and device of network management system |
CN104424219A (en) * | 2013-08-23 | 2015-03-18 | 华为技术有限公司 | Method and equipment of managing data documents |
CN104424219B (en) * | 2013-08-23 | 2018-10-09 | 华为技术有限公司 | A kind of management method and device of data file |
CN107291574A (en) * | 2016-03-30 | 2017-10-24 | 中国石油化工股份有限公司 | Backup Data based on solution release system recovers major key generation method |
CN107291574B (en) * | 2016-03-30 | 2020-08-25 | 中国石油化工股份有限公司 | Backup data recovery primary key generation method based on interpretation system |
CN108319466A (en) * | 2017-12-15 | 2018-07-24 | 北京先进数通信息技术股份公司 | A kind of restoration methods and device of configuration information |
CN111459720A (en) * | 2020-04-02 | 2020-07-28 | 上海新炬网络技术有限公司 | Mysql data recovery method based on transaction log |
CN111459720B (en) * | 2020-04-02 | 2023-07-07 | 上海新炬网络技术有限公司 | Mysql data recovery method based on transaction log |
Also Published As
Publication number | Publication date |
---|---|
CN100373385C (en) | 2008-03-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN1517918A (en) | Method for back-up and restoring important data | |
CN107391306B (en) | Heterogeneous database backup file recovery method | |
US7222133B1 (en) | Method for reducing database recovery time | |
US7917472B2 (en) | Method, system and computer-readable media for backing up information contained in a database | |
US5560006A (en) | Entity-relation database | |
US8548965B2 (en) | Changed files list with time buckets for efficient storage management | |
US8738668B2 (en) | System and method for creating a de-duplicated data set | |
US8977597B2 (en) | Generating and applying redo records | |
US7552130B2 (en) | Optimal data storage and access for clustered data in a relational database | |
EP2144177B1 (en) | System and method for a log-based data storage | |
US5347653A (en) | System for reconstructing prior versions of indexes using records indicating changes between successive versions of the indexes | |
US6496944B1 (en) | Method for database assisted file system restore | |
CN101840419B (en) | Method for restoring data from a monolithic backup | |
EP2270692A1 (en) | Lifecycle-based horizontal partitioning | |
US9916211B2 (en) | Relational database recovery | |
US20070118573A1 (en) | System and method to create a subset of a database | |
US6901418B2 (en) | Data archive recovery | |
US20070088766A1 (en) | Method and system for capturing and storing multiple versions of data item definitions | |
US8818961B1 (en) | User restoration of workflow objects and elements from an archived database | |
EP0583108B1 (en) | Entity-relation database | |
CN1205577C (en) | Database table recovery system | |
US20030204516A1 (en) | Determination of relevant figures for database recovery processes | |
CN1211745C (en) | Method for checking tables paces involved in referential integrity | |
US8630984B1 (en) | System and method for data extraction from email files | |
Schwind et al. | The conversion of the Mississippi state sovereignty commission records |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080305 Termination date: 20180117 |