CN102541694B - Method and device for database backup - Google Patents
Method and device for database backup Download PDFInfo
- Publication number
- CN102541694B CN102541694B CN201210015596.3A CN201210015596A CN102541694B CN 102541694 B CN102541694 B CN 102541694B CN 201210015596 A CN201210015596 A CN 201210015596A CN 102541694 B CN102541694 B CN 102541694B
- Authority
- CN
- China
- Prior art keywords
- backup
- policy
- database
- data
- backup policy
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000004140 cleaning Methods 0.000 claims 2
- 238000009472 formulation Methods 0.000 abstract description 3
- 239000000203 mixture Substances 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 5
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000012467 final product Substances 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 206010000125 Abnormal dreams Diseases 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and device for database backup, relating to the field of databases. The database backup device disclosed by the invention at least comprises a backup policy formulation module and a data backup module, wherein the backup policy formulation module sets a backup policy of a database according to a user command and sends the backup policy to the database backup module, and the backup policy at least comprises backup time, backup position and backup type; and the database backup module stores the data of the database in the backup position according to the backup type of the backup policy when the backup time of the backup policy arrives. The invention also discloses a database backup method. The way of separated policy, backup and storage is adopted for the technical scheme of the invention, the flow of user backup is simplified, and more flexible backup way is provided.
Description
Technical field
The present invention relates to database field, be specifically related to a kind of method and device of DB Backup.
Background technology
Loss of data is all a bad dream concerning large small enterprise, and business datum and enterprise's day to day operation operate is as close as lips and teeth, and loses these data, also can bring irremediable loss to enterprise even temporary.For the backup of key business information in database, mostly adopt the backup tool that database itself provides, but there is following shortcoming in these instruments: 1, backup policy is sufficiently complete, needs manually to intervene.2, in general backup set data are all very large, and user needs the manual migration work carrying out backup set data, wastes time and energy.If 3 data sets are stored on local client computer, the waste of system resource can be brought to local client computer.
Summary of the invention
Technical matters to be solved by this invention is, provides a kind of method and device of DB Backup, to simplify the flow process of user ID.
In order to solve the problems of the technologies described above, the invention discloses a kind of DB Backup device, at least comprise backup policy and formulating module and data backup module, wherein:
Described backup policy formulates module, according to user instruction setting data storehouse backup policy and send to described database backup module, wherein, described backup policy at least comprises BACKUP TIME, backup location and type of backup;
Described database backup module, when the BACKUP TIME of described backup policy arrives, is saved in the type of backup of the data of described database according to described backup policy in backup location.
Preferably, in said apparatus, described database backup module, also obtains the information of described database, and the information according to described database provides corresponding backup policy setting options to user, and user arranges the backup policy of described database by described setting options.
Preferably, in said apparatus, the information of described database is example information or table space information.
Preferably, in said apparatus, described backup policy also comprises management information, and wherein, described management information comprises update mode to Backup Data and update cycle.
Preferably, said apparatus also comprises: backup management module, carries out renewal rewards theory according to the management information in described backup policy to the data backed up.
The invention also discloses a kind of backup method of database, comprising:
According to the backup policy in user instruction setting data storehouse, described backup policy at least comprises BACKUP TIME, backup location and type of backup;
When the BACKUP TIME of described backup policy arrives, the type of backup of the data of described database according to described backup policy is saved in backup location.
Preferably, said method also comprises:
Obtain the information of described database, the information according to described database provides corresponding backup policy setting options to user, and user arranges the backup policy of described database by described setting options.
Preferably, in said method, the information of described database is example information or table space information.
Preferably, in said method, described backup policy also comprises management information, and wherein, described management information comprises update mode to Backup Data and update cycle.
Preferably, said method also comprises:
According to the management information in described backup policy, renewal rewards theory is carried out to the data backed up
Technical scheme adopts strategy, backup, stores mode separately, simplifies the flow process of user ID, provides backup mode more flexibly.
Accompanying drawing explanation
Fig. 1 is the structural representation of DB Backup device in the present embodiment;
Fig. 2 is DB Backup process flow diagram in the present embodiment.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly understand, hereafter will be described in further detail technical solution of the present invention by reference to the accompanying drawings.It should be noted that, when not conflicting, the feature in the embodiment of the application and embodiment can combine arbitrarily mutually.
Embodiment 1
The present embodiment provides a kind of DB Backup device, and the framework of this device as shown in Figure 1, at least comprises backup policy and formulates module and data backup module.Introduce the function of each module below.
Backup policy formulates module, according to user instruction setting data storehouse backup policy and send to database backup module, wherein, backup policy at least comprises BACKUP TIME (BACKUP TIME of such as timed backup, or the BACKUP TIME interval of cycle backup), backup location and type of backup (such as full dose, increment or differential backup);
Whether certainly, above-mentioned backup policy can also comprise other guide, such as, management information, encrypt and the information such as whether to compress.Wherein, management information comprises the update mode, update cycle etc. to Backup Data.Update mode refers to carry out the operations such as deletion management to the data backed up.Database backup module, when the BACKUP TIME of backup policy arrives, is saved in the type of backup of the data of database according to this backup policy in backup location.
On the basis of said apparatus, some preferred versions propose, and backup policy formulates the information that module can obtain database in advance, and the information according to database provides corresponding backup policy setting options to user, like this, user gets final product the backup policy in setting data storehouse by these setting options.Wherein, the information of database is example information or table space information.
It should be noted that why provide corresponding backup policy setting options according to the information of database to user in a preferred approach, is that its backup policy specifically should be selected according to the feature of database because the feature of disparate databases is different.Such as the database of sql, backup policy formulation module can be user provides three kinds of type of backups, i.e. full backup, differential backup and transaction log backup.And for oracle example information or table space information, backup policy formulates module then can provide full backup, difference incremental backup and sigma delta to back up.Specifically how backup policy is set, is then arranged according to demand by user.
Also have in some schemes, also add backup management module, this module can carry out renewal rewards theory according to the management information in backup policy to the data backed up.Renewal as herein described comprises operations such as deleting management.
In addition, consider limited system resources, therefore database backup module, after the backup set data (data namely to back up) generated are stored into the backup location of specifying, local backup set data can also be cleared up, to improve the resource utilization of system.
Embodiment 2
This enforcement provides a kind of backup method of database, and the method mainly comprises:
According to the backup policy in user instruction setting data storehouse, wherein, backup policy at least comprises BACKUP TIME, backup location and type of backup;
When the BACKUP TIME of set backup policy arrives, the type of backup of the data of database according to this backup policy is saved in backup location.
Have some preferred versions, can obtain the information of database in advance, then provide corresponding backup policy setting options according to the information of database to user, like this, user gets final product the backup policy in setting data storehouse by these setting options.The flow process of this preferred version fulfillment database backup as shown in Figure 2.Wherein, the information of database is example information or table space information.
Also have in some schemes, whether backup policy, except BACKUP TIME, backup location and type of backup, can also comprise management information, encrypts and the information such as whether compress.Wherein, management information comprises the update mode, update cycle etc. to Backup Data.Update mode refers to carry out the operations such as deletion management to the data backed up.
Whether whether now, said method carries out in data backup procedure, also can come to encrypt accordingly and/or squeeze operation according to the information such as encrypting in backup policy and compress.In addition, after said method carries out data backup, renewal rewards theory can also be carried out according to the management information in backup policy to the data backed up.
The all or part of step that one of ordinary skill in the art will appreciate that in said method is carried out instruction related hardware by program and is completed, and described program can be stored in computer-readable recording medium, as ROM (read-only memory), disk or CD etc.Alternatively, all or part of step of above-described embodiment also can use one or more integrated circuit to realize.Correspondingly, each module/unit in above-described embodiment can adopt the form of hardware to realize, and the form of software function module also can be adopted to realize.The application is not restricted to the combination of the hardware and software of any particular form.
As can be seen from above-described embodiment, technical scheme is according to the information of database and user's request customization backup strategy, carry out data backup according to this backup policy again, thus avoid the loss of backup set data or backup set is stored the system resource taking client computer too much on a client.And, because the backup policy proposed in technical scheme combines BACKUP TIME, backup location (also can think storage mode) and type of backup etc., for user provides a complete flow process, user is not needed to know data flow wherein and storage mode.
The above, be only preferred embodiments of the present invention, be not intended to limit protection scope of the present invention.Within the spirit and principles in the present invention all, any amendment made, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (6)
1. a DB Backup device, is characterized in that, this device at least comprises backup policy and formulates module and data backup module, wherein:
Described backup policy formulates module, according to user instruction setting data storehouse backup policy and send to described database backup module, wherein, described backup policy at least comprises BACKUP TIME, backup location and type of backup;
The data of described database, when the BACKUP TIME of described backup policy arrives, are saved in backup location according to the type of backup of described backup policy by described database backup module; Also obtain the information of described database, the feature of disparate databases is different, its backup policy is specifically selected according to the feature of database, information according to described database provides corresponding backup policy setting options to user, and user arranges the backup policy of described database by described setting options;
The feature of described disparate databases is different, and its backup policy is specifically selected to be specially according to the feature of database,
For oracle example information or table space information, backup policy formulates module then can provide full backup, difference incremental backup and sigma delta to back up;
Described database backup module, after the data of described database are saved in backup location according to the type of backup of described backup policy, the data of the database that cleaning is local.
2. device as claimed in claim 1, it is characterized in that, described backup policy also comprises management information, and wherein, described management information comprises update mode to Backup Data and update cycle.
3. device as claimed in claim 2, it is characterized in that, this device also comprises:
Backup management module, carries out renewal rewards theory according to the management information in described backup policy to the data backed up;
Described renewal rewards theory comprises: delete bookkeeping.
4. a backup method for database, is characterized in that, the method comprises:
According to the backup policy in user instruction setting data storehouse, described backup policy at least comprises BACKUP TIME, backup location and type of backup;
When the BACKUP TIME of described backup policy arrives, the data of described database are saved in backup location according to the type of backup of described backup policy;
Described method also comprises:
Obtain the information of described database, the feature of disparate databases is different, its backup policy is specifically selected according to the feature of database, and the information according to described database provides corresponding backup policy setting options to user, and user arranges the backup policy of described database by described setting options;
The feature of described disparate databases is different, and its backup policy is specifically selected to be specially according to the feature of database,
For oracle example information or table space information, backup policy is formulated then can provide full backup, difference incremental backup and sigma delta to back up;
After the data of described database are saved in backup location according to the type of backup of described backup policy, the data of the database that cleaning is local.
5. method as claimed in claim 4, is characterized in that,
Described backup policy also comprises management information, and wherein, described management information comprises update mode to Backup Data and update cycle.
6. method as claimed in claim 5, it is characterized in that, the method also comprises:
According to the management information in described backup policy, renewal rewards theory is carried out to the data backed up;
Described renewal rewards theory comprises: delete bookkeeping.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210015596.3A CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210015596.3A CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102541694A CN102541694A (en) | 2012-07-04 |
| CN102541694B true CN102541694B (en) | 2015-05-13 |
Family
ID=46348644
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210015596.3A Active CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102541694B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239369A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of database filing standby system and method |
Families Citing this family (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103176867B (en) * | 2013-04-02 | 2017-12-01 | 浪潮电子信息产业股份有限公司 | A kind of fast file differential backup method |
| CN103473151B (en) * | 2013-09-10 | 2016-04-06 | 中国银行股份有限公司 | The backup method of database table and device |
| CN103853827A (en) * | 2014-03-07 | 2014-06-11 | 浪潮电子信息产业股份有限公司 | Database backup method capable of guaranteeing data consistency |
| CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
| CN105630626B (en) * | 2014-11-03 | 2020-05-05 | 中兴通讯股份有限公司 | Transaction backup processing method and device |
| CN104850598B (en) * | 2015-04-28 | 2017-11-14 | 江苏瑞中数据股份有限公司 | A kind of real-time data base back-up restoring method |
| CN105930226B (en) * | 2015-12-30 | 2019-01-01 | 中国银联股份有限公司 | A kind of data processing method and device |
| CN106354588A (en) * | 2016-09-13 | 2017-01-25 | 郑州云海信息技术有限公司 | Database automatic backup method and device |
| CN106569911A (en) * | 2016-10-14 | 2017-04-19 | 深圳前海微众银行股份有限公司 | Data backup method and device |
| CN106569920B (en) * | 2016-11-09 | 2020-12-11 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN108153613A (en) * | 2016-12-06 | 2018-06-12 | 中标软件有限公司 | the backup method of data |
| CN106648980A (en) * | 2016-12-12 | 2017-05-10 | 北京雷石天地电子技术有限公司 | Backup and recovery method and backup and recovery device for high-availability server databases in offline places |
| CN107193687A (en) * | 2017-04-18 | 2017-09-22 | 北京潘达互娱科技有限公司 | Database backup method and controlling equipment |
| CN108121793A (en) * | 2017-12-20 | 2018-06-05 | 北京搜狐新媒体信息技术有限公司 | A kind of DB Backup dispositions method and device |
| CN111104247A (en) * | 2018-10-25 | 2020-05-05 | 伊姆西Ip控股有限责任公司 | Method, apparatus and computer program product for managing data replication |
| CN110008066A (en) * | 2019-04-11 | 2019-07-12 | 苏州浪潮智能科技有限公司 | A kind of database backup method, system and electronic equipment and storage medium |
| CN111611104B (en) * | 2020-05-14 | 2022-11-29 | 华云数据有限公司 | InfluxDB data backup method, system and terminal equipment |
| CN114328029B (en) * | 2022-03-02 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Backup method and device of application resources, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| CN101610303A (en) * | 2008-06-17 | 2009-12-23 | 中兴通讯股份有限公司 | Multi-medium data automatic backup method and system |
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100373385C (en) * | 2003-01-17 | 2008-03-05 | 中兴通讯股分有限公司 | Method for back-up and restoring important data |
| US7904679B2 (en) * | 2004-02-04 | 2011-03-08 | Netapp, Inc. | Method and apparatus for managing backup data |
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
-
2012
- 2012-01-18 CN CN201210015596.3A patent/CN102541694B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| CN101610303A (en) * | 2008-06-17 | 2009-12-23 | 中兴通讯股份有限公司 | Multi-medium data automatic backup method and system |
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239369A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of database filing standby system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102541694A (en) | 2012-07-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541694B (en) | Method and device for database backup | |
| US10158483B1 (en) | Systems and methods for efficiently and securely storing data in a distributed data storage system | |
| EP2788876B1 (en) | System and method for restoring application data | |
| US11354065B2 (en) | Cloud edition and retrieve | |
| US11442961B2 (en) | Active transaction list synchronization method and apparatus | |
| US9430272B2 (en) | Efficiently providing virtual machine reference points | |
| CN106021016A (en) | Virtual point in time access between snapshots | |
| CN103106271B (en) | A kind of DB Backup based on mass data and restoration methods and system | |
| CN103605585A (en) | Intelligent backup method based on data discovery | |
| CN104463508A (en) | Coordination method and device between multiple workflow systems | |
| CN103365740B (en) | A kind of data cold standby method and device | |
| US7200625B2 (en) | System and method to enhance availability of a relational database | |
| US20080195675A1 (en) | Method for Pertorming Distributed Backup on Client Workstations in a Computer Network | |
| CN109241063A (en) | A kind of data merging method and system | |
| US11449389B2 (en) | Techniques for performing incremental data backups | |
| CN104573107A (en) | Network security application NoSQL database and relational database fusion interface method | |
| CN105993002A (en) | In-place disk unformatting | |
| CN106250273B (en) | Method for realizing data remote disaster recovery based on Hadoop file system | |
| CN105117282A (en) | Input and output request splitting method and device | |
| CN101236519A (en) | Radioactive source control application level backup recovery method | |
| CN101655938A (en) | Method and system for realizing business data copying | |
| CA3159118A1 (en) | System for creating a dataset network | |
| CN116628060A (en) | Data exchange method for realizing web based on keyle | |
| CN116501714A (en) | Data asset management system, corresponding computer device and storage medium | |
| US7133910B2 (en) | Method for recovering the data of a logic cell in a DCE system |
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 |