CN105528264B - Fool proof data reconstruction method and its system - Google Patents
Fool proof data reconstruction method and its system Download PDFInfo
- Publication number
- CN105528264B CN105528264B CN201510957661.8A CN201510957661A CN105528264B CN 105528264 B CN105528264 B CN 105528264B CN 201510957661 A CN201510957661 A CN 201510957661A CN 105528264 B CN105528264 B CN 105528264B
- Authority
- CN
- China
- Prior art keywords
- update
- preset rules
- source database
- update operation
- backup
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1479—Generic software techniques for error detection or fault masking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of fool proof data reconstruction method and system, wherein method includes：Obtain all update operations for acting on source database；The update is operated and is compared with preset rules；If the update operation does not violate preset rules, update operation is executed in Backup Data；If the update operation violates preset rules, judge whether the update operation is unreasonable operation；If so, restoring to the change of the source database related data caused by the operation；Conversely, then update operation is executed in Backup Data.Through the above way, the present invention can be by change shielding caused by the operation of mistake except backup database, and the change of source database caused by faulty operation is restored, the data caused by ensure that due to various reasons by mistake change can be restored to the correct status before being modified.
Description
Technical field
The present invention relates to database technical fields, more particularly, to a kind of fool proof data reconstruction method and system.
Background technology
Make in database inevitably because a variety of causes performs the database operating instruction of mistake in database
The change (including delete, increase newly, change) of mistake has occurred in data.These maloperations not only affect the accuracy of data,
It is serious to cause huge economic losses, such as quantity on order, contract award date, bill and account receivable generation mistake.
The accurate, complete, available of data is of great significance.Common cold standby can only utilize backup database by source number
It is restored to over the normal condition at a certain moment according to library, the correct data variation after this moment can not restore.Common is hot standby
Though part can guarantee the basic synchronization of source database and backup database data, using backup database to the source database of damage into
Row restores, and ensure that real-time, the consistency of data, if but the no mistake (not violating grammer etc.) of operation itself, and be
The behavior of operation, the result is that mistake, at this time system can not judge it is such mistake, can not be restored.
To solve this problem, a kind of Database Systems for forming by master library and from library are provided by technical staff
Method (master library herein with source database, from the effect of library and backup database be the same), master library and from library number when initial
According to identical, the then acquisition completed operation of master library in chronological order, after getting the operation every time, with the institute currently obtained
Identical operation is executed from library described after delay preset duration based on the deadline for stating operation；When the master library occurs
When mistake, the faulty operation for leading to mistake is determined；Judge whether the faulty operation has executed described from library；If institute
It states faulty operation not yet to execute from library described, then the data of the master library is restored using the data from library.
But when the faulty operation described in this method is determined, if this operation is being executed from library, it can not still ensure data at this time
It is accurate, errorless, therefore its effect or it is limited.
Invention content
The technical problem to be solved by the present invention is to：The database backup method of the fast quick-recovery of new anti-misoperation and it is
System, to solve the problems, such as that database may cause data inaccurate, imperfect, not available because of a variety of causes.
In order to solve the above-mentioned technical problem, the technical solution adopted by the present invention is：It is extensive to provide a kind of fool proof data
Compound method, including：
Obtain all update operations for acting on source database；
The update is operated and is compared with preset rules；
If the update operation does not violate preset rules, update operation is executed in Backup Data；
If the update operation violates preset rules, judge whether the update operation is unreasonable operation；
If so, restoring to the change of the source database related data caused by the operation；
Conversely, then update operation is executed in Backup Data.
To solve the above problems, the present invention also provides a kind of fool proof data recovery systems, including：
Logging modle, for obtaining all update operations for acting on source database；
First judgment module is compared for operating the update with preset rules；
Backup module operates the update in Backup Data if not violating preset rules for update operation
Middle execution；
Second judgment module, if violating preset rules for update operation, judge the update operate whether be
Unreasonable operation；
Recovery module, the change for the source database related data caused by the operation are restored.
To solve the above problems, the present invention also provides a kind of fool proof data recovery system, including processor and use
In the memory of storage processor-executable instruction；The wherein described processor is configured as executing following procedure：
Obtain all update operations for acting on source database；
The update is operated and is compared with preset rules；
If the update operation does not violate preset rules, update operation is executed in Backup Data；
If the update operation violates preset rules, judge whether the update operation is unreasonable operation；
If so, restoring to the change of the source database related data caused by the operation；
Conversely, then update operation is executed in Backup Data.
The beneficial effects of the present invention are：It is different from the prior art, the present invention is all to source database generation by obtaining
The update of effect operates, and is compared with preset rules, if not violating, executes in Backup Data, otherwise, then continue to determine whether
Restore conversely, being changed caused by then being operated to the update if so, being executed in Backup Data for reasonable operation.Pass through
Aforesaid way, the present invention can draw change shielding caused by the operation of mistake except backup database, and to faulty operation
The change of the source database risen is restored, and the data caused by ensure that due to various reasons by mistake change can be restored to
Correct status before being modified.
Description of the drawings
Fig. 1 is the flow diagram of the method for the present invention embodiment one；
Fig. 2 is the flow diagram of the method for the present invention embodiment two；
Fig. 3 is the flow diagram of the database restoring method of the specific embodiment of the invention one；
Fig. 4 is the structural schematic diagram one of the database backup system of the specific embodiment of the invention two；
Fig. 5 is the structural schematic diagram two of the database backup system of the specific embodiment of the invention two；
Fig. 6 is the structural schematic diagram three of the database backup system of the specific embodiment of the invention two；
Fig. 7 is the part-structure schematic diagram of the database backup system of the specific embodiment of the invention three.
Specific implementation mode
To explain the technical content, the achieved purpose and the effect of the present invention in detail, below in conjunction with embodiment and coordinate attached
Figure is explained.
The design of most critical of the present invention is：It is compared, and broken the rules with preset rules by the way that operation will be updated
In the case of, the reasonability of operation is further judged, by mistake change caused by having thereby may be ensured that due to various reasons
Data can be restored to the correct status before being modified.
Fig. 1 is please referred to, the embodiment of the present invention provides a kind of fool proof data reconstruction method, including：
S1：Obtain all update operations for acting on source database；
S2：The update is operated and is compared with preset rules, judges whether the update operation violates preset rules；
If the update operation does not violate preset rules, S3 is thened follow the steps：By update operation in Backup Data
It executes；
If the update operation violates preset rules, S4 is thened follow the steps：Judge whether the update operation is unreasonable
Operation；
If so, thening follow the steps S5：The change of the source database related data caused by the operation is restored；
Conversely, thening follow the steps S3：Update operation is executed in Backup Data.
Wherein, when executing step S1, specially：
All operations for acting on source database are recorded in chronological order；
Extraction can cause the update operation that source database changes.
Wherein, the preset rules are special object, specific operation are arranged in advance rule, and preset rules be can
Change.Then corresponding step S4 can be specially：
If the update operation violates preset rules, system sends out prompting；
According to prompting, user instruction is obtained；
According to user instruction, judge whether the update operation is unreasonable operation.
It is different from the prior art, the present invention is operated by obtaining all updates for being acted to source database, and default
Rule comparison, if not violating, executes in Backup Data, otherwise, then continues to determine whether as reasonable operation, if so,
It is executed in Backup Data, conversely, change caused by then being operated to the update restores.By the above-mentioned means, the present invention can be with
Will mistake operation caused by change shielding except backup database, and to the change of source database caused by faulty operation into
Row restores, and the data caused by ensure that due to various reasons by mistake change can be restored to the correct status before being modified.
It holds, as shown in Fig. 2, second embodiment of the present invention provides a kind of fool proof data recovery systems 100, including：
Logging modle 110, for obtaining all update operations for acting on source database；
First judgment module 120 is compared for operating the update with preset rules；
Backup module 130, for executing update operation in Backup Data；
Whether second judgment module 140 judges the update operation if violating preset rules for update operation
For unreasonable operation；
Recovery module 150, the change for the source database related data caused by the operation are restored.
Wherein, the part-structure in system of the invention includes processor and for storing depositing for processor-executable instruction
Reservoir；The wherein described processor is configured as executing following procedure：
Obtain all update operations for acting on source database；
The update is operated and is compared with preset rules；
If the update operation does not violate preset rules, update operation is executed in Backup Data；
If the update operation violates preset rules, judge whether the update operation is unreasonable operation；
If so, restoring to the change of the source database related data caused by the operation；
Conversely, then update operation is executed in Backup Data.
And the preset rules are special object, specific operation are arranged in advance rule, and preset rules be can be more
Change.Also, judge that the step of whether the update operation is unreasonable operation is specially：
If the update operation violates preset rules, system sends out prompting；
According to prompting, user instruction is obtained；
According to user instruction, judge whether the update operation is unreasonable operation.
As shown in Fig. 1~Fig. 7, the present invention provides a kind of database backup method of the fast quick-recovery of new anti-misoperation and is
System, including database manipulation daily record generation method and database backup method, restoration methods and database backup system, to solve
Certainly database may lead to inaccurate, imperfect, the not available problem of data because of a variety of causes.The present invention is applied to there are source numbers
In the case of according to library, backup database, a kind of database backup method and system are provided, understand side of the present invention for convenience
Method and system are described in detail below by way of several specific embodiments.
There is provided a kind of database restoring methods of the fast quick-recovery of anti-misoperation for the first aspect of the present invention, it is assumed that initial
When source database it is identical with the data of backup database.The method includes：
All operations of source database are recorded in chronological order, wherein the operation in the present invention refers to all causing to grasp
The operation different from preoperative source database of source database after work, such as inquiry operation will not cause source database data
Change, being not belonging to the operation object that discusses of the present invention namely inquiry operation can be recorded, but not with it is hereafter described default
Rule compares etc., these operations can be documented in operation log.
The operation for acting on source database of record is compared with preset rules；If the operation does not violate default rule
Then, then the operation is executed in Backup Data；If the operation violates preset rules, system sends out prompting；It can be by people
Work judges whether the operation really belongs to unreasonable operation according to the prompting message that system is sent out；System is according to artificial judgment
Different Results execute different tasks：If artificial judgment is correct operation, then the operation is executed in Backup Data, if
Artificial judgment is not allow to operate, then restores to the change of the source database related data caused by the operation.
The preset rules for being compared with all operations for acting on source database are in advance to specific right
As the rule of the settings such as, specific operation.Optionally, preset rules can be modified at any time according to actual needs.
If the operation for acting on source database violates preset rules, system sends out prompting, the content packet reminded
Include the details for the operation for violating preset rules；Its mode reminded can be one or more, preferred real at one
It applies in example, includes wherein at least a kind of system interface alerting pattern, include optionally：Sound prompting, the window of system interface carry
It wakes up, short message is reminded, the modes such as mailbox prompting.
It is described to mean that manually judging whether the operation belongs to according to the prompting message that system is sent out does not conform to by artificial judgment
Reason operation, namely judge whether to tally with the actual situation, there are two types of the results of judgement：One is act on source database certainly
Operation is correct, and it is correct to act on the operation of source data one is negative, that is, is judged to not allowing to operate.
System described above executes different tasks according to the Different Results of artificial judgment, refer to operation make it is correct,
The people of false judgment is to the correct either wrong judging result system of system one according to this correct or wrong judgement knot
Fruit, record the operation information that source database is done and pre-set the corresponding operation of execution：If the judgement that system receives
The result is that operation is correct, then the operation is executed on backup database；If the judging result that system receives is operating mistake,
Then the change of the source database related data caused by the operation is restored.
Change described above to the source data related data caused by the operation restores, and restoration methods can have more
Kind, one of which or a variety of modes being combined may be selected when specific system is realized.
The second aspect of the present invention is to provide a kind of database backup system of the fast quick-recovery of anti-misoperation, it is assumed that when initial
System source database is identical with the data of backup database.The system comprises：
Source database operation record module acts on all operations of source database for obtaining, recording in chronological order
Information after recording the operation every time, triggers judgment module；
Judgment module, for the operation information for acting on source database being recorded to be compared with preset rules, if
It was found that the operation does not violate preset rules, then trigger data backup module, if finding, the operation violates preset rules,
Trigger system alert module；
System alert module, for when the operation for acting on source database does not meet preset rules, (i.e. above to user
That mentions is artificial) prompting is sent out, if user is to being judged as wrong operation without handling, the prompting in system will deposit always
Until user provides the artificial judgment result of correctness of the system to made by the operation of prompting；
System alert module can provide user's judging result option, (correct or mistake, but do not limit to when system realization
With the two words, correct, mistake word, than being operated such as whether receiving so-and-so, optional judgement are operated as long as expressing
As a result it is yes, is no), while judging result information is received, if the judging result received is that operation is correct, trigger data backup mould
Block, if the judging result received is operating mistake, trigger data recovery module；
Optionally, system alert module may include that submodule is arranged in system alert, and prompting rule can be arranged according to setup module
Then, including remind number, time interval etc., it such as may be configured as not handled within the regular hour when the prompting, be
System can carry out secondary prompting；
Data backup module, for executing the behaviour for acting on source database in following two situations in backup database
Make：First, the operation of preset rules is not violated, though second is that it is correctly operation to violate preset rules by artificial judgment.
Data recovery module, for violating preset rules and by the source database of acting on that artificial judgment is mistake
The recovery for the related data that the caused source database of operation is modified；
Optionally, the system also includes preset rules setup modules, can be to specific for modifying to preset rules
Object, specific operation etc. are defined, including allow and refuse the rule of two kinds of forms.
The third aspect of the present invention is to provide a kind of present in database recovery system of the fast quick-recovery of anti-misoperation, it is assumed that when initial
System source database is identical with the data of backup database.The system comprises：
Processor；
Memory for storing processor-executable instruction；
Wherein, the processor is configured as：All operations of source data are recorded in chronological order；By acting on for record
The operation of source database is compared with preset rules；If the operation does not violate preset rules, the operation is being backed up
It is executed in data；If the operation violates preset rules, system sends out prompting；Then system is received by manually to the operation
Whether the judging result of unreasonable operation is really belonged to；System executes difference according to the Different Results of the artificial judgment received
Task：If artificial judgment is correct operation, the operation is executed in Backup Data, if being judged as not allowing to operate,
The change of the source data related data caused by the operation is restored.
Specific embodiment one：
Fig. 3 provides a kind of flow diagram of the database restoring method of the fast quick-recovery of anti-misoperation, it is assumed that when initial
Source database is identical with the data of backup database.The method includes：
Step 101：All operations of source database are recorded in chronological order；
Backup database can realize the operation in source database according to the operation note, and the operation is remembered
The temporal information that record is completed comprising the operation.
After source database has executed an operation, it can obtain and be sequentially recorded the operation information and deadline.
Step 102：When source database operation being recorded every time, compared with preset rules, and provide comparing result：Not
It violates preset rules, violate preset rules.System can directly acquire or read the comparing result.The comparing result can be with
It is shown in such a way that user sees, such as word；Also can be only the recording mode that system can be obtained or be understood.No
The different operation of same comparing result triggering system.
Step 103：If the operation for the source database being recorded does not violate preset rules, by the operation in Backup Data
It is executed in library, can be regarded as the process of Backup Data library backup.
Step 104：If the operation violates preset rules, system sends out prompting.User is reminded to judge that the operation is
No is unreasonable operation really.
Alerting pattern can be one or more, but include at least a kind of system interface alerting pattern, include optionally：System
Sound prompting, the window prompting at system interface etc., other optional alerting patterns include the modes such as short message is reminded, and mailbox is reminded.
The prompting that system described above is sent out, including the relevant operation information for violating preset rules, also includes optionally
Temporal information.
The prompting of system interface, while being supplied to two kinds of judging results of user：Belong to reasonable operation, be not belonging to rationally grasp
Make.Optionally, the specific verbal description of two kinds of judging results is there are many mode, if give expression to the operation whether be allowed to,
Whether rationally, whether correct.
Step 105：The prompting message that user sends out according to system, judges whether the operation really belongs to unreasonable behaviour
Make, and provides judging result.System can receive the judging result of user, wherein different judging results triggers different behaviour
Make.
Step 106：If the artificial judgment result that system receives is correct operation, executed in backup database
The operation can be regarded as the process of Backup Data library backup.
Step 107：If the artificial judgment result that system receives is not allow to operate, to being caused by the operation
The change of source database related data restored.
Step 103 and step 106 can be regarded as the process that backup database carries out source database async backup, backup
Database executes identical operation with source database.In step 103, the variation of backup database is regarded as same with source database
When, in step 106, the variation of backup database be receive it is manually whether reasonable to being happened at the operation of source database
Judgement after occur, have delay compared with source database, the length of delay time when handled according to user remind it is related.
To by the side for not allowing the change of source database related data caused by operating to be restored in step 107
Method optionally but is not limited to following several：The first is to execute not allow to operate with described in chronological order in source data
Opposite operation, for example described do not allow operation (A is the operation in order certain field of certain table so-and-so information is changed to B by A
Information before operation object execution, B are the information by the information after the operation change), then restoration methods are in source number
The B information of the operation object is changed to A according to middle；It finds in backup database for second and to be related to the operation
The corresponding data of the relevant information of related object in source data, after corresponding data cover is modified in backup database
Source database in relevant information, for example described do not allow operation to delete certain table in source database, then restoring
Method is table corresponding with this table to be found in backup database, and create source database；The third restoration methods
It is to be used in combination with both the above method.The present embodiment does not limit restoration methods.
When source database be damaged cause loss of data or it is unavailable the problems such as when, also using backup database pair
Source database is restored, and the prompting (in other words operate) to not carrying out manual examination and verification still can proceed with processing, using pair
The record of source database operation ensures the correctness of data.Even if the hardware such as the server where even worse source database break down,
Recovery such case must could be carried out after new equipment supplement, and also there is no problem, can directly utilize backup database at this time,
Untreated prompting and operation can be continued with simultaneously, for correctly operating direct execution, the operation directly refusal of mistake is held
Row；After enabling backup database, backup database also just becomes new source database, and new source database can record institute
There is the change to new source database, when condition, which has, new backup database occurs, backup database can utilize the operation
Record ensures the correctness of data, if operation note is correct at this time, without processing, if operating mistake, to new backup
Database executes opposite operation and is restored, so new source database is restored or new source database execute
Opposite operation is restored；After enabling new backup database, the operation note of new source database record can be according to initial source
Database, backup database processing mode handled.So just ensure that the accuracy of database data, integrality, can
The property used.
Specific embodiment two：
The database recovery side of the fast quick-recovery of anti-misoperation described in specific embodiment one of the specific embodiment of the invention two
On the basis of method, a kind of database backup system of the fast quick-recovery of anti-misoperation is provided, as shown in figure 4, Fig. 4 is described anti-error
The structural schematic diagram for operating the database backup system of fast quick-recovery, contains main functional modules, this standby system both can be with
It is autonomous system, can also be used as function or subsystem etc. and be integrated into other systems, present example is limited not to this
It is fixed.When initial, source database is identical as the data of backup database.
The system comprises：
Source database operation record module 201：All operations for obtaining, recording source database in chronological order are believed
Breath after recording the operation every time, triggers judgment module；
Judgment module 202：For the operation information for acting on source database being recorded to be compared with preset rules,
If it was found that the operation does not violate preset rules, trigger data backup module, if finding, the operation violates preset rules,
Then trigger system alert module；
System alert module 203：For when the operation for acting on source database does not meet preset rules, to user
(i.e. mentioned above artificial) sends out prompting, if user is to being judged as wrong operation without handling, the prompting in system is just
It can always exist, until user provides the artificial judgment result of correctness of the system to made by the operation of prompting；
System alert module can provide user's judging result option (correct or mistake, but when system is realized do not limit to
With the two words, correct, mistake word, than being operated such as whether receiving so-and-so, optional judgement are operated as long as expressing
As a result it is yes, is no), while judging result information is received, if the judging result received is that operation is correct, trigger data backup mould
Block, if the judging result received is operating mistake, trigger data recovery module；
Optionally, such as Fig. 5, system alert module 203 may include that submodule 301 is arranged in system alert, according to setup module
Prompting rule can be set, including remind number, time interval etc., it such as may be configured as not having within the regular hour when the prompting
It is handled, system can carry out secondary prompting；
Data backup mould 204：For executing the behaviour for acting on source database in following two situations in backup database
Make：First, the operation of preset rules is not violated, though second is that it is correctly operation to violate preset rules by artificial judgment.
Data recovery module 205：For to violating preset rules and acting on source data by artificial judgment for mistake
The recovery for the related data that source database caused by the operation in library is modified.
Optionally, such as Fig. 6, the system also includes preset rules setup modules 401, for being repaiied to preset rules
Change, special object, specific operation etc. can be defined, including allow and refuse the rule of two kinds of forms；
The general rule is configured to important object (library, table, field etc.), and described object itself is to allow to change
, but generally modification or being affected due to modification mistake, one review mechanism of increase do not protect important number so easily
According to.For the object that cannot absolutely change, directly setting cannot be changed or allow to change range, so directly in source number
It cannot be completed according to the relevant operation in library, manual examination and verification mechanism need not be increased, but this is not handled in standby system.
Specific embodiment three：
The database recovery side of the fast quick-recovery of anti-misoperation described in specific embodiment one of the specific embodiment of the invention three
On the basis of method, a kind of database backup system of the fast quick-recovery of anti-misoperation, such as Fig. 7 are provided.Fig. 7 is the anti-misoperation
The part-structure schematic diagram of the database backup system of fast quick-recovery, it is assumed that system source database and backup database when initial
Data are identical.
The system comprises：
Processor 501：The processor is configured as：All operations of source data are recorded in chronological order；By record
The operation and preset rules for acting on source database are compared；If the operation does not violate preset rules, by the operation
It is executed in Backup Data；If the operation violates preset rules, system sends out prompting；Then system is received by manually to institute
State the judging result whether operation really belongs to unreasonable operation；System is held according to the Different Results of the artificial judgment received
The different task of row：If artificial judgment is correct operation, the operation is executed in Backup Data, if being judged as not allowing to grasp
Make, then the change of the source data related data caused by the operation is restored.
Memory 502：For storing processor executable command.
In conclusion the present invention is set by the operation for allowing important object (library, table, field etc.) or not allowing
It sets, i.e., the preset rules of operation described herein, after the operation of source database is recorded in chronological order, with the preset rules
It is compared, judges whether the operation meets preset rules, if meeting preset rules, executed in Backup Data identical
Whether operation, if not meeting preset rules, system sends out prompting, have artificial judgment operation reasonable, in Backup Data if rationally
It is middle to execute identical operation, to being restored by operation caused change in source database if unreasonable.To, will
Change shielding caused by the operation of mistake carries out except backup database, and to the change of source database caused by faulty operation
Restore.Data caused by ensure that due to various reasons by mistake change can be restored to the correct status before being modified.
When source database occur mistake either damage occur loss of data or it is unavailable when, backup number can also be utilized
Source database is restored according to library, simultaneously as under the operation before source database is occurred mistake or damaged all has been recorded
Come, even if in the presence of the operation not being manually reviewed, can continue to be audited in Backup Data, before having audited, it
Restored all that there is no problem to source database afterwards.
In short, database backup method provided by the invention and system, risk caused by maloperation can be prevented and source number
It is adversely affected caused by mistake or damage occurs according to library, ensure that the correct, complete, available of source database database.
It should be understood that the emphasis of the present invention further includes providing one between source data and backup database manually
Review mechanism, whether audit is correct for the operation of important object, and correctly operation executes in Backup Data, the operation of mistake
The change of the source database caused by the operation is restored.
Example the above is only the implementation of the present invention is not intended to limit the scope of the invention, every to utilize this hair
Equivalents made by bright specification and accompanying drawing content are applied directly or indirectly in relevant technical field, include similarly
In the scope of patent protection of the present invention.
Claims (8)
1. a kind of fool proof data reconstruction method, which is characterized in that including：
Obtain all update operations for acting on source database；
The update is operated and is compared with preset rules；
If the update operation does not violate preset rules, update operation is executed in Backup Data；
If the update operation violates preset rules, judge whether the update operation is unreasonable operation；
If so, restoring to the change of the source database related data caused by the operation；
Conversely, then update operation is executed in Backup Data.
2. fool proof data reconstruction method according to claim 1, which is characterized in that obtain source database it is all more
The step of new operation is specially：
All operations for acting on source database are recorded in chronological order；
Extraction can cause the update operation that source database changes.
3. fool proof data reconstruction method according to claim 1, which is characterized in that the preset rules are right in advance
Special object, specific operation and the rule being arranged, and preset rules are modifiable.
4. fool proof data reconstruction method according to claim 3, which is characterized in that if update operation violates in advance
If regular, then judge that the step of whether the update operation is unreasonable operation is specially：
If the update operation violates preset rules, system sends out prompting；
According to prompting, user instruction is obtained；
According to user instruction, judge whether the update operation is unreasonable operation.
5. a kind of fool proof data recovery system, which is characterized in that including：
Logging modle, for obtaining all update operations for acting on source database；
First judgment module is compared for operating the update with preset rules；
Backup module holds update operation if not violating preset rules for update operation in Backup Data
Row；
Second judgment module judges whether the update operation is not conform to if violating preset rules for update operation
Reason operation；
Recovery module, the change for the source database related data caused by the operation are restored.
6. a kind of fool proof data recovery system, which is characterized in that can perform including processor and for storing processor
The memory of instruction；The wherein described processor is configured as executing following procedure：
Obtain all update operations for acting on source database；
The update is operated and is compared with preset rules；
If the update operation does not violate preset rules, update operation is executed in Backup Data；
If the update operation violates preset rules, judge whether the update operation is unreasonable operation；
If so, restoring to the change of the source database related data caused by the operation；
Conversely, then update operation is executed in Backup Data.
7. fool proof data recovery system according to claim 6, which is characterized in that the preset rules are right in advance
Special object, specific operation and the rule being arranged, and preset rules are modifiable.
8. fool proof data recovery system according to claim 7, which is characterized in that if update operation violates in advance
If regular, then judge that the step of whether the update operation is unreasonable operation is specially：
If the update operation violates preset rules, system sends out prompting；
According to prompting, user instruction is obtained；
According to user instruction, judge whether the update operation is unreasonable operation.
Priority Applications (4)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510957661.8A CN105528264B (en) | 2015-12-18 | 2015-12-18 | Fool proof data reconstruction method and its system |
| CN201811009532.6A CN109240854B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering data of change caused by misoperation |
| CN201811009102.4A CN109117314B (en) | 2015-12-18 | 2015-12-18 | Anti-misoperation data rapid recovery method and system |
| CN201811009101.XA CN109165121B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering misoperation data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510957661.8A CN105528264B (en) | 2015-12-18 | 2015-12-18 | Fool proof data reconstruction method and its system |
Related Child Applications (3)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811009102.4A Division CN109117314B (en) | 2015-12-18 | 2015-12-18 | Anti-misoperation data rapid recovery method and system |
| CN201811009532.6A Division CN109240854B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering data of change caused by misoperation |
| CN201811009101.XA Division CN109165121B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering misoperation data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105528264A CN105528264A (en) | 2016-04-27 |
| CN105528264B true CN105528264B (en) | 2018-08-21 |
Family
ID=55770508
Family Applications (4)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811009101.XA Active CN109165121B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering misoperation data |
| CN201811009532.6A Active CN109240854B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering data of change caused by misoperation |
| CN201811009102.4A Active CN109117314B (en) | 2015-12-18 | 2015-12-18 | Anti-misoperation data rapid recovery method and system |
| CN201510957661.8A Active CN105528264B (en) | 2015-12-18 | 2015-12-18 | Fool proof data reconstruction method and its system |
Family Applications Before (3)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811009101.XA Active CN109165121B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering misoperation data |
| CN201811009532.6A Active CN109240854B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering data of change caused by misoperation |
| CN201811009102.4A Active CN109117314B (en) | 2015-12-18 | 2015-12-18 | Anti-misoperation data rapid recovery method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (4) | CN109165121B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106383900A (en) * | 2016-09-29 | 2017-02-08 | 郑州云海信息技术有限公司 | Method and system for preventing mistaken deletion of data files in Sybase database |
| CN108572885A (en) * | 2017-03-10 | 2018-09-25 | 阿里巴巴集团控股有限公司 | A kind of operation processing method, device and electronic equipment |
| CN109144772B (en) * | 2017-06-15 | 2021-03-30 | 北京京东尚科信息技术有限公司 | Method and device for backing up database data |
| CN112270019A (en) * | 2020-10-23 | 2021-01-26 | 许继集团有限公司 | Double tamper-proof method and system for key information table of database |
| CN114117539A (en) * | 2022-01-24 | 2022-03-01 | 北京交研智慧科技有限公司 | Data protection method and device |
| CN115599595B (en) * | 2022-08-26 | 2023-04-11 | 北京万里开源软件有限公司 | Physical backup method based on distributed database |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101159003A (en) * | 2007-11-16 | 2008-04-09 | 中国科学院软件研究所 | Data-base malevolence transaction method and system thereof |
| CN101916215A (en) * | 2010-08-09 | 2010-12-15 | 哈尔滨工程大学 | Operation intercept based repentance method of distributed critical task system |
| CN101923573A (en) * | 2010-08-09 | 2010-12-22 | 哈尔滨工程大学 | Rapid database data recovery method aiming at data loss |
| CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001209298A (en) * | 2000-01-24 | 2001-08-03 | Armat Corp | Remote education management system |
| US7613806B2 (en) * | 2001-06-28 | 2009-11-03 | Emc Corporation | System and method for managing replication sets of data distributed over one or more computer systems |
| US6981177B2 (en) * | 2002-04-19 | 2005-12-27 | Computer Associates Think, Inc. | Method and system for disaster recovery |
| CN100590599C (en) * | 2007-12-06 | 2010-02-17 | 福建星网锐捷网络有限公司 | Write-operation process method, system and apparatus of FLASH |
| CN102693169B (en) * | 2011-03-25 | 2015-01-28 | 国际商业机器公司 | Method and device for recovering lessee data under multi-lessee environment, and database system |
| CN102567472B (en) * | 2011-12-14 | 2014-04-02 | 海角先锋(北京)科技有限公司 | Built-in database based high-efficient data deleting and restoring method |
| CN102662798A (en) * | 2012-04-12 | 2012-09-12 | 青岛海信移动通信技术股份有限公司 | Data recovery method and terminal for Android system |
| US9122711B1 (en) * | 2012-05-24 | 2015-09-01 | Symantec Corporation | Simplified system backup protection and recovery |
| CN103383698B (en) * | 2013-06-27 | 2016-09-21 | 宇龙计算机通信科技(深圳)有限公司 | The method of data deletion and mobile terminal thereof |
| CN103617277A (en) * | 2013-12-09 | 2014-03-05 | 山东瀚高基础软件股份有限公司 | Method for restoring data table content deleted mistakenly |
| CN103955421A (en) * | 2014-05-06 | 2014-07-30 | 珠海市君天电子科技有限公司 | Method and system for file deletion |
| CN104699551B (en) * | 2015-02-15 | 2018-12-25 | 四川长虹电器股份有限公司 | A kind of data reconstruction method and cloud server |
-
2015
- 2015-12-18 CN CN201811009101.XA patent/CN109165121B/en active Active
- 2015-12-18 CN CN201811009532.6A patent/CN109240854B/en active Active
- 2015-12-18 CN CN201811009102.4A patent/CN109117314B/en active Active
- 2015-12-18 CN CN201510957661.8A patent/CN105528264B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101159003A (en) * | 2007-11-16 | 2008-04-09 | 中国科学院软件研究所 | Data-base malevolence transaction method and system thereof |
| CN101916215A (en) * | 2010-08-09 | 2010-12-15 | 哈尔滨工程大学 | Operation intercept based repentance method of distributed critical task system |
| CN101923573A (en) * | 2010-08-09 | 2010-12-22 | 哈尔滨工程大学 | Rapid database data recovery method aiming at data loss |
| CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109117314B (en) | 2021-04-16 |
| CN109240854B (en) | 2021-04-09 |
| CN109165121B (en) | 2021-03-23 |
| CN109240854A (en) | 2019-01-18 |
| CN109117314A (en) | 2019-01-01 |
| CN109165121A (en) | 2019-01-08 |
| CN105528264A (en) | 2016-04-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105528264B (en) | Fool proof data reconstruction method and its system | |
| CN108847994A (en) | Alarm localization method, device, equipment and storage medium based on data analysis | |
| CN110213371A (en) | Information consumption method, apparatus, equipment and computer storage medium | |
| CN102857371B (en) | A kind of dynamic allocation management method towards group system | |
| CN103370693A (en) | Restarting processes | |
| CN102833281B (en) | It is a kind of distributed from the implementation method counted up, apparatus and system | |
| CN103370694A (en) | Restarting data processing systems | |
| CN104252500A (en) | Method and device for carrying out fault repairing on database management platform | |
| CN107451040A (en) | Localization method, device and the computer-readable recording medium of failure cause | |
| CN103595807A (en) | Data synchronous updating method and device | |
| CN108469725A (en) | Clock calibration method and terminal device | |
| CN107797896B (en) | A kind of data on flows self- recoverage processing method and server | |
| CN111835790B (en) | Risk identification method, device and system | |
| CN108537243A (en) | A kind of violation alarm method and device | |
| CN107544853A (en) | It is a kind of to interact the method and system retried with bank | |
| CN109544014A (en) | Anti- fraud method and device based on historical data playback | |
| CN103440460A (en) | Application system change validation method and system | |
| CN107678955A (en) | A kind of computational methods, device, equipment and the storage medium of functional interface time delay | |
| CN105468418A (en) | System and method for upgrading software of smart terminal cluster | |
| CN105760283B (en) | A kind of log-output method and device | |
| CN109743204A (en) | A kind of intelligence operational system | |
| CN110245148A (en) | A kind of date storage method, device, system and medium | |
| Fang et al. | Confidence interval estimation of software reliability growth models derived from stochastic differential equations | |
| CN108764607A (en) | User month data reinspection method, apparatus, equipment and storage medium | |
| CN115001998B (en) | Disaster recovery method and device for message service |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |