CN102346784A - Database backup method and system - Google Patents
Database backup method and system Download PDFInfo
- Publication number
- CN102346784A CN102346784A CN2011103583501A CN201110358350A CN102346784A CN 102346784 A CN102346784 A CN 102346784A CN 2011103583501 A CN2011103583501 A CN 2011103583501A CN 201110358350 A CN201110358350 A CN 201110358350A CN 102346784 A CN102346784 A CN 102346784A
- Authority
- CN
- China
- Prior art keywords
- database
- backup
- value
- priority
- acquisition module
- 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.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database backup method and system. The method provided by the invention comprises the following steps of: obtaining a total weighted value according to the attribute of a table in a database and a corresponding preset weight, and obtaining the priority and a corresponding threshold of the database according to the total weighted value; obtaining the variation value of the database according to different operation types and corresponding weights of the database; and comparing the variation value of the database with the threshold corresponding to the grade of the database, and carrying out a backup strategy according to the comparison result.
Description
Technical field
The invention belongs to database technical field, relate in particular to a kind of method and system of DB Backup.
Background technology
Growing along with social informatization, database technology is by widespread use more and more.In daily data transmission applications, DB Backup is absolutely necessary and one of operates, and existing backup method is various.Common backup mainly is fixed cycle backup in time, but for database take place at any time than cataclysm, do not provide the backup cycle of maneuverability to regulate; In addition, on the DB Backup mode, no matter be full backup or differential backup, all can not distinguish and treat according to the significance level of different pieces of information table, backup in time is prone to cause data degradation after important tables of data change.
Summary of the invention
The present invention provides a kind of method and system of DB Backup to address the above problem.
The present invention provides a kind of method of DB Backup, and the inventive method may further comprise the steps.According to attribute of showing in the database and corresponding preset weight, obtain total weighted value and, obtain the priority and the corresponding threshold value of database according to said total weighted value.According to the different operating type and the respective weights of database, obtain the database change value.More said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.
The present invention provides a kind of system of DB Backup, comprises priority and threshold value acquisition module, changing value acquisition module, relatively reaches policy enforcement module.Wherein, priority and threshold value acquisition module connect the changing value acquisition module, and the connection of changing value acquisition module relatively reaches policy enforcement module.Priority and threshold value acquisition module are used for attribute and the corresponding preset weight shown according to database, obtain total weighted value and according to said total weighted value, obtain the priority and the corresponding threshold value of database.The changing value acquisition module is used for different operating type and respective weights according to database, obtains the database change value.Relatively reach policy enforcement module, be used for more said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.
Compared to prior art; According to the method and system of DB Backup provided by the invention, through the database change value with priority is changed after the comparison of database corresponding threshold, carry out the backup policy of database flexibly; Can carry out data backup effectively in time, avoid data degradation.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
The process flow diagram of the method for the DB Backup that provides for preferred embodiment according to the present invention shown in Figure 1;
The synoptic diagram of the system of the DB Backup that provides for preferred embodiment according to the present invention shown in Figure 2.
Embodiment
Hereinafter will with reference to the accompanying drawings and combine embodiment to describe the present invention in detail.Need to prove that under the situation of not conflicting, embodiment and the characteristic among the embodiment among the application can make up each other.
The process flow diagram of the method for the DB Backup that provides for preferred embodiment according to the present invention shown in Figure 1.As shown in Figure 1, the DB Backup method that provides of preferred embodiment according to the present invention comprises step 101～103.
Step 101:, obtain total weighted value and, obtain the priority and the corresponding threshold value of database according to said total weighted value according to attribute of showing in the database and corresponding weight.Wherein, initial priority and the corresponding threshold value of database preset before the backup first.
Particularly; Many tables of data in the individual data storehouse are pressed the different weight of attribute assignment; The quantity of different attribute table and the sum of products of respective weights; Be total weighted value of this database; Compare and according to comparative result the priority in specified data storehouse and corresponding threshold with the preset weights scope.
For example: before backup triggers; The relation of the total weighted value of each database, priority and corresponding threshold value is as shown in the table: the scope of setting different priorities according to preset weights in the table is: total weight value＞3.5 o'clock are senior; 2.0＜total weight value≤3.5 o'clock are middle rank; Total weight value≤2.0 o'clock are rudimentary; The corresponding priority of confirming to go up each database in the table; And preset each database corresponding threshold, priority is high more, and threshold value is low more.
After backup triggers,, calculate each database total weight value, obtain the priority and the corresponding threshold value of database according to the attribute of showing in each database respective weights separately, as shown in the table:
Step 102:, obtain the database change value according to the different operating type and the respective weights of database.Wherein, the different operating type of database comprises: increase, inquire about, revise, delete, preset different operating type increases, inquires about, revises, deletes the weights summation is 1.
Particularly, when database triggers backup at every turn, the different operating type of database is added up, the product summation with action type respective weights and this action type number obtains the database change value.As shown in the table:
Step 103: more said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.Wherein, the backup triggering mode comprise regularly trigger, be periodic backups, and trigger in real time, be the aperiodicity backup.Particularly; Each database will back up the changing value that calculates when triggering and compare with place priority corresponding threshold; When the changing value of database more than or equal to database rank corresponding threshold, the higher table of weights in the backup database then, and shorten full backup and incremental backup cycle.When the changing value of database less than database rank corresponding threshold, then prolong full backup and incremental backup cycle.
Execution below in conjunction with step 101 and 102 pairs of backup policy is made an explanation.
Storehouse, Suzhou changing value 500 equals the corresponding threshold value 500 of its place priority, the higher table of weights in the storehouse, Suzhou of then backing up in realtime, is MSDS; And shorten full backup and incremental backup cycle; That is,, shorten to 10 days if former full backup and incremental backup cycle are 15 days at present; Storehouse, Nanjing changing value 290 less than the corresponding threshold value 300 of its place priority, then prolongs full backup and incremental backup cycle, and even former full backup and incremental backup cycle are 10 days, are extended for 15 days at present; Storehouse, Zhenjiang changing value 650 less than the corresponding threshold value 700 of its place priority, then prolongs full backup and incremental backup cycle, and even former full backup and incremental backup cycle are 25 days, are extended for 40 days at present.Wherein, each self-corresponding full backup of the database of different priorities and incremental backup cycle preset before triggering backup, and rank is high more, and the cycle is short more.And the difference absolute value of changing value and threshold value is big more; The amplitude that full backup and incremental backup cycle change just more greatly; The concrete corresponding relation of the difference of changing value and threshold value and backup cycle can be done the different formulas setting according to actual conditions in application, this present invention is not limited.
The synoptic diagram of the system of the DB Backup that provides for preferred embodiment according to the present invention shown in Figure 2.As shown in Figure 2, the database backup system that provides of preferred embodiment according to the present invention comprises priority and threshold value acquisition module 201, changing value acquisition module 202, relatively reaches policy enforcement module 203.Wherein, priority and threshold value acquisition module 201 connect changing value acquisition module 202, and 202 connections of changing value acquisition module relatively reach policy enforcement module 203.Priority and threshold value acquisition module 201 are used for attribute and the corresponding preset weight shown according to database, obtain total weighted value and according to said total weighted value, obtain the priority and the corresponding threshold value of database.Changing value acquisition module 202 is used for different operating type and respective weights according to database, obtains the database change value.Relatively reach policy enforcement module 203, be used for more said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.
In sum; According to the method and system of DB Backup provided by the invention, through the database change value with priority is changed after the comparison of database corresponding threshold, carry out the backup policy of database flexibly; Can carry out data backup effectively in time, avoid data degradation.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (9)
1. the method for a DB Backup is characterized in that:
According to attribute of showing in the database and corresponding weight, obtain total weighted value and, obtain the priority and the corresponding threshold value of database according to said total weighted value;
According to the different operating type and the respective weights of database, obtain the database change value;
More said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.
2. method according to claim 1 is characterized in that, triggers the mode of backup, comprises regularly triggering, triggering in real time.
3. method according to claim 2 is characterized in that, before timer triggers, according to attribute of showing in the database and corresponding weight, obtains total weighted value and according to said total weighted value, presetting database priority and corresponding threshold value.
4. method according to claim 1; It is characterized in that; According to the different operating type and the respective weights of database, the process that obtains the database change value is: multiply by corresponding weight according to the corresponding number of the different operating type of database, obtain the database change value.
5. method according to claim 4 is characterized in that, said action type comprises: increase, inquire about, revise, delete.
6. method according to claim 1 is characterized in that, said backup policy comprises: the higher table of weights in shortening full backup and incremental backup time, prolongation full backup and incremental backup time, the backup database.
7. method according to claim 6 is characterized in that, if the changing value of said database is more than or equal to database rank corresponding threshold, and the higher table of weights in the backup database then, and shorten full backup and incremental backup cycle.
8. method according to claim 6 is characterized in that, if the changing value of said database then prolongs full backup and incremental backup cycle less than database rank corresponding threshold.
9. the system of a DB Backup is characterized in that, comprises priority and threshold value acquisition module, changing value acquisition module, relatively reaches policy enforcement module; Wherein, priority and threshold value acquisition module connect the changing value acquisition module, and the connection of changing value acquisition module relatively reaches policy enforcement module;
Priority and threshold value acquisition module, attribute that is used for showing according to database and corresponding weight obtain total weighted value and according to said total weighted value, obtain the priority and the corresponding threshold value of database;
The changing value acquisition module is used for different operating type and respective weights according to database, obtains the database change value;
Relatively reach policy enforcement module, be used for more said database change value and database rank corresponding threshold, and, carry out backup policy according to comparative result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103583501A CN102346784A (en) | 2011-11-14 | 2011-11-14 | Database backup method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103583501A CN102346784A (en) | 2011-11-14 | 2011-11-14 | Database backup method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102346784A true CN102346784A (en) | 2012-02-08 |
Family
ID=45545461
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103583501A Pending CN102346784A (en) | 2011-11-14 | 2011-11-14 | Database backup method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102346784A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103425551A (en) * | 2013-07-31 | 2013-12-04 | 清华大学 | Database concentrated backup method |
| CN103617098A (en) * | 2013-12-03 | 2014-03-05 | 上海爱数软件有限公司 | Intelligent backup method and system based on data changes |
| CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
| CN105242984A (en) * | 2015-08-27 | 2016-01-13 | 北京金山安全软件有限公司 | Data backup method and device |
| CN106569917A (en) * | 2016-11-07 | 2017-04-19 | 广东欧珀移动通信有限公司 | Data backup method and mobile terminal |
| CN106776704A (en) * | 2016-11-14 | 2017-05-31 | 平安科技（深圳）有限公司 | Statistical information collection method and device |
| CN107846418A (en) * | 2017-12-14 | 2018-03-27 | 广东天网安全信息科技有限公司 | Fire wall Initiative Defence System and means of defence |
| CN108762988A (en) * | 2018-05-31 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method and relevant device of data processing |
| CN109002446A (en) * | 2017-06-07 | 2018-12-14 | 联芯科技有限公司 | A kind of intelligent sorting method, terminal and computer readable storage medium |
| CN109154902A (en) * | 2017-02-14 | 2019-01-04 | 华为技术有限公司 | System and method for backing up scheduling |
| CN109445965A (en) * | 2018-11-07 | 2019-03-08 | 北京明朝万达科技股份有限公司 | By the Redis and MySQL message treatment method realized and equipment |
| CN114579369A (en) * | 2022-05-09 | 2022-06-03 | 武汉四通信息服务有限公司 | Data backup method, computer equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002297427A (en) * | 2001-03-30 | 2002-10-11 | Hitachi Ltd | Method, device, system, program and storage medium for data backup |
| CN101030156A (en) * | 2006-03-03 | 2007-09-05 | 国际商业机器公司 | Method and apparatus for performing data backup |
| CN101719165A (en) * | 2010-01-12 | 2010-06-02 | 山东高效能服务器和存储研究院 | Method for realizing high-efficiency rapid backup of database |
-
2011
- 2011-11-14 CN CN2011103583501A patent/CN102346784A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002297427A (en) * | 2001-03-30 | 2002-10-11 | Hitachi Ltd | Method, device, system, program and storage medium for data backup |
| CN101030156A (en) * | 2006-03-03 | 2007-09-05 | 国际商业机器公司 | Method and apparatus for performing data backup |
| CN101719165A (en) * | 2010-01-12 | 2010-06-02 | 山东高效能服务器和存储研究院 | Method for realizing high-efficiency rapid backup of database |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103425551A (en) * | 2013-07-31 | 2013-12-04 | 清华大学 | Database concentrated backup method |
| CN103617098A (en) * | 2013-12-03 | 2014-03-05 | 上海爱数软件有限公司 | Intelligent backup method and system based on data changes |
| CN103617098B (en) * | 2013-12-03 | 2017-06-16 | 上海爱数信息技术股份有限公司 | Intelligent backup method and intelligent backup system based on data variation |
| CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
| CN105242984A (en) * | 2015-08-27 | 2016-01-13 | 北京金山安全软件有限公司 | Data backup method and device |
| CN106569917A (en) * | 2016-11-07 | 2017-04-19 | 广东欧珀移动通信有限公司 | Data backup method and mobile terminal |
| CN106569917B (en) * | 2016-11-07 | 2020-06-16 | Oppo广东移动通信有限公司 | Data backup method and mobile terminal |
| CN106776704B (en) * | 2016-11-14 | 2020-03-06 | 平安科技（深圳）有限公司 | Statistical information collection method and device |
| CN106776704A (en) * | 2016-11-14 | 2017-05-31 | 平安科技（深圳）有限公司 | Statistical information collection method and device |
| CN109154902A (en) * | 2017-02-14 | 2019-01-04 | 华为技术有限公司 | System and method for backing up scheduling |
| CN109002446A (en) * | 2017-06-07 | 2018-12-14 | 联芯科技有限公司 | A kind of intelligent sorting method, terminal and computer readable storage medium |
| CN107846418A (en) * | 2017-12-14 | 2018-03-27 | 广东天网安全信息科技有限公司 | Fire wall Initiative Defence System and means of defence |
| CN108762988A (en) * | 2018-05-31 | 2018-11-06 | 郑州云海信息技术有限公司 | A kind of method and relevant device of data processing |
| CN108762988B (en) * | 2018-05-31 | 2022-04-22 | 郑州云海信息技术有限公司 | Data processing method and related equipment |
| CN109445965A (en) * | 2018-11-07 | 2019-03-08 | 北京明朝万达科技股份有限公司 | By the Redis and MySQL message treatment method realized and equipment |
| CN114579369A (en) * | 2022-05-09 | 2022-06-03 | 武汉四通信息服务有限公司 | Data backup method, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102346784A (en) | Database backup method and system | |
| CN101604268B (en) | Method for filtering monitored directory change events | |
| CN105868361A (en) | Data updating method and device | |
| CN101127102A (en) | Contracted life cycle supervision system and method | |
| US11604703B2 (en) | Systems and methods for performing backups of a server database | |
| CN105608366A (en) | User permission control method and device | |
| CN105069109A (en) | Dilatation method and system of distributed database | |
| CN104679792A (en) | Data permission achievement method | |
| CN103944964A (en) | Distributed system and method carrying out expansion step by step through same | |
| CN104462577A (en) | Data storing method and device | |
| CN104145222B (en) | For the synchronous apparatus and method of control logic | |
| CN101539756B (en) | Implementation method and device of alarm clock | |
| CN104572784A (en) | Database backup method and system | |
| CN101547197B (en) | URL (Uniform resource locator) whitening device and method | |
| CN104410511A (en) | Server management method and system | |
| Azamzadeh et al. | Effects of declining energy subsidies on value added in agricultural sector | |
| CN104298756A (en) | Method for exchanging data between databases based on internal and external networks | |
| Sears et al. | The economics of sustainable agricultural groundwater management: Recent findings | |
| CN103117995B (en) | A kind of method and system realizing communication security | |
| CN104679821A (en) | Data access processing method and data access processing device | |
| CN102594728A (en) | Distributed instant communication method and system | |
| CN108629589B (en) | Transaction management method and system based on block chain | |
| CN103117994B (en) | A kind of processing method of communication security and system | |
| CN101426192A (en) | Charging system and accounting period processing method | |
| CN109388958A (en) | A kind of data permission management service middleware platform scheme based on section |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120208 |