CN109240854A - Data reconstruction method and system - Google Patents
Data reconstruction method and system Download PDFInfo
- Publication number
- CN109240854A CN109240854A CN201811009532.6A CN201811009532A CN109240854A CN 109240854 A CN109240854 A CN 109240854A CN 201811009532 A CN201811009532 A CN 201811009532A CN 109240854 A CN109240854 A CN 109240854A
- Authority
- CN
- China
- Prior art keywords
- update
- preset rules
- data
- source database
- update operation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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 data reconstruction method and systems, and wherein method includes: to 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 as 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
This case is so that application No. is 201510957661.8, the applying date is on December 18th, 2015, entitled " anti-misoperation
Data reconstruction method and its system " patent application be female case divisional application.
Technical field
The present invention relates to database technical fields, more particularly, to a kind of data reconstruction method and system.
Background technique
Make in database in 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 may 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
The normal condition at a certain moment is restored to over according to library, and 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 operate itself without wrong (not violating grammer etc.), 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, it is provided by technical staff a kind of for by master library and the Database Systems formed from library
Method (master library herein and 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 from library described；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 faulty operation described in this method is determined, if this operation is being executed from library, data are not can guarantee still at this time
It is accurate, errorless, therefore its effect is also limited.
Summary of the invention
The technical problems to be solved by the present invention are: the database backup method of the fast quick-recovery of new anti-misoperation and being
System, to solve the problems, such as that database is inaccurate, imperfect, not available because a variety of causes may cause data.
In order to solve the above-mentioned technical problem, the technical solution adopted by the present invention are as follows: it is extensive to provide a kind of fool proof data
Compound method, comprising:
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 as 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, comprising:
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 updates operation, judge the update operate whether be
Unreasonable operation；
Recovery module, the change for the source database related data as 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；Wherein the processor is configured to 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 as 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 generated by obtaining all pairs of source databases
The update of effect operates, and compares with preset rules, if not violating, executes in Backup Data, otherwise, then continue to determine whether
Restore if so, being executed in Backup Data conversely, being changed caused by then being operated to the update 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.
Detailed description of the invention
Fig. 1 is the flow diagram of embodiment of the present invention method one；
Fig. 2 is the flow diagram of embodiment of the present invention method 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 partial structure diagram of the database backup system of the specific embodiment of the invention three.
Specific embodiment
To explain the technical content, the achieved purpose and the effect of the present invention in detail, below in conjunction with embodiment and cooperate attached
Figure is explained.
The most critical design of the present invention is: being compared by the way that operation will be updated with preset rules, and breaking the rules
In the case where, further the reasonability of judgement operation, has been changed caused by having thereby may be ensured that due to various reasons by mistake
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, comprising:
S1: all update operations for acting on source database are obtained；
S2: the update being 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: judging whether the update operation is unreasonable
Operation；
If so, thening follow the steps S5: restoring to the change of the source database related data as caused by the operation；
Conversely, thening follow the steps S3: update operation is executed in Backup Data.
Wherein, when executing step S1, specifically:
All operations for acting on source database are recorded in chronological order；
Extract the update operation that source database can be caused to change.
Wherein, the preset rules be in advance to special object, specific operation and the rule being arranged, and preset rules be can
Change.Then corresponding step S4, can specifically:
If the update operation violates preset rules, system, which issues, is reminded；
According to prompting, user instruction is obtained；
According to user instructions, judge whether the update operation is unreasonable operation.
It is different from the prior art, the present invention is and default by obtaining the update operation of all pairs of source database generations effect
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 operating 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, comprising:
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 as caused by the operation are restored.
Wherein, the part-structure in system of the invention includes processor and depositing for storage processor executable instruction
Reservoir；Wherein the processor is configured to 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 as caused by the operation；
Conversely, then update operation is executed in Backup Data.
And the preset rules be in advance to special object, specific operation and the rule being arranged, and preset rules be can be more
Change.Also, the step of whether the update operation is unreasonable operation judged specifically:
If the update operation violates preset rules, system, which issues, is reminded；
According to prompting, user instruction is obtained；
According to user instructions, judge whether the update operation is unreasonable operation.
As shown in FIG. 1 to FIG. 7, the present invention provides the database backup method of the new fast quick-recovery of anti-misoperation of one kind and is
System, including database manipulation log generation method and database backup method, restoration methods and database backup system, to solve
Certainly database may cause 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 where 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 described method includes:
All operations for recording source database in chronological order, all cause to grasp wherein the operation in the present invention refers to
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, 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, which issues, is reminded；It can be by people
Work judges whether the operation really belongs to unreasonable operation according to the prompting message that system issues；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 as caused by the operation.
The preset rules for comparing 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, which issues, is reminded, the content packet reminded
Include the details for violating the operation of preset rules；Its mode reminded can be one or more, preferred real at one
It applies in example, wherein at least includes a kind of system interface alerting pattern, optionally include: that sound prompting, the window of system interface mentions
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 issues 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, is correctly, that is, to be judged to not allowing to operate one is the operation that negative acts on source data.
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 system one correct perhaps wrong judging result system according to this correct or wrong judgement knot
Fruit, record the operation information that source database is done and preset execution corresponding operation: 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 as caused by the operation is restored.
Change described above to the source data related data as caused by the operation restores, and restoration methods can have more
Kind, one of or a variety of modes 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 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 the discovery 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) it issues and reminds, if user is to the operation of mistake is judged as without processing, the prompting in system will be deposited always
Until user provides the artificial judgment result of correctness made by operation of the system to 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 operating 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 received judging result is that operation is correct, trigger data backup mould
Block, if received judging result is operating mistake, trigger data recovery module；
Optionally, system alert module may include system alert setting submodule, be advised according to the settable prompting of 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 situation in backup database
Make: first is that the operation of preset rules is not violated, though second is that violating preset rules by artificial judgment is correctly operation.
Data recovery module, for violate preset rules and by artificial judgment be mistake the source database of acting on
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, the rule including allowing and refusing two kinds of forms.
The third aspect of the present invention is to provide a kind of present in database recovery system of 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 storage processor executable instruction；
Wherein, the processor is configured to: in chronological order record source data all operations；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, which issues, is reminded；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 be correct operation, the operation is executed in Backup Data, if being judged as does not allow to operate,
The change of the source data related data as caused by the operation is restored.
Specific embodiment one:
Fig. 3 provides a kind of flow diagram of the database restoring method of fast quick-recovery of anti-misoperation, it is assumed that when initial
Source database is identical with the data of backup database.The described method includes:
Step 101: recording all operations of source database in chronological order；
Backup database can be realized 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, being 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 text；It 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, which issues, is reminded.User is reminded to judge that the operation is
No be unreasonable operation really.
Alerting pattern can be one or more, but include at least a kind of system interface alerting pattern, optionally include: to be
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 issues, the operation information comprising relevant violation preset rules optionally also include
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 issues 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, being 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, causing to 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 async backup to source database, backup
Database and source database execute identical operation.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 manually to occur source database the operation it is whether reasonable
Judgement after occur, have delay compared with source database, the length of delay time when handled according to user remind it is related.
To the side restored by the change for not allowing to operate caused source database related data 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 to operate that (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；Second is to find to be related to the operation in backup database
The corresponding data of the relevant information of related object in source data, after being modified using data cover corresponding in backup database
Source database in relevant information, for example described do not allow to operate 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 still can proceed with processing to the prompting (in other words operate) for not carrying out manual examination and verification, using pair
The record of source database operation guarantees the correctness of data.Even if the hardware such as the server where even worse source database break down,
Recovery such case must just be can 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 of mistake is directly refused to hold
Row；After enabling backup database, backup database also just becomes new source database, and new source database will 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 guarantees 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, and then restores to new source database or new source database executes
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 the 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 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 if finding, the operation violates preset rules it was found that the operation does not violate preset rules, trigger data backup module,
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), which issues, reminds, if user is to the operation of mistake is judged as without processing, the prompting in system is just
It can always exist, until user provides the artificial judgment result of correctness made by operation of the system to prompting；
System alert module can provide user's judging result option (correct or mistake, but when system is realized does not limit to
With the two words, correct, mistake word, than operating 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 received judging result is that operation is correct, trigger data backup mould
Block, if received judging result is operating mistake, trigger data recovery module；
Optionally, such as Fig. 5, system alert module 203 may include system alert setting submodule 301, according to setup module
Settable prompting rule, 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 situation in backup database
Make: first is that the operation of preset rules is not violated, though second is that violating preset rules by artificial judgment is correctly operation.
Data recovery module 205: for violate preset rules and by artificial judgment be mistake act on source data
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 repairing to preset rules
Change, special object, specific operation etc. can be defined, the rule including allowing and refusing two kinds of forms；
The general rule is configured to important object (library, table, field etc.), and described object itself is to allow to modify
, but do not modify generally or being affected since modification is wrong easily, increase a review mechanism, so protects important number
According to.For the object that cannot absolutely modify, 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, not need to increase manual examination and verification mechanism, but this is not handled in standby system.
Specific embodiment three:
The database recovery side of the fast quick-recovery of the 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 fast quick-recovery of anti-misoperation, such as Fig. 7 are provided.Fig. 7 is the anti-misoperation
The partial structure 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 to: all operations of source data are recorded in chronological order；By record
The operation and preset rules for acting on source database compare；If the operation does not violate preset rules, by the operation
It is executed in Backup Data；If the operation violates preset rules, system, which issues, is reminded；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 does not allow to grasp
Make, then the change of the source data related data as caused by the operation is restored.
Memory 502: it is used for storage 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 in the text, after the operation of source database is recorded in chronological order, with the preset rules
It compares, judges whether the operation meets preset rules, if meeting preset rules, executed in Backup Data identical
Whether operation, if not meeting preset rules, system, which issues, is reminded, have artificial judgment operation reasonable, in Backup Data if rationally
It is middle to execute identical operation, restore if unreasonable to by operation caused change in source database.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 perhaps damage occur loss of data or it is unavailable when, also can use backup number
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 can continue to be audited in Backup Data in the presence of the operation not being manually reviewed, 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, can prevent risk caused by maloperation and source number
Occur to adversely affect caused by mistake or damage according to library, ensure that the correct, complete, available of source database database.
It should be understood that emphasis of the 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 as caused by the operation is restored.
The above description is only an embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalents made by bright specification and accompanying drawing content are applied directly or indirectly in relevant technical field, similarly include
In scope of patent protection of the invention.
Claims (8)
1. a kind of data reconstruction method characterized by comprising
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, prompting is issued until receiving whether the update operation is unreasonable behaviour
The judging result of work；
If the update operation is unreasonable operation, the change of the source database related data as caused by the operation is carried out
Restore；
Conversely, then update operation is executed in Backup Data.
2. data reconstruction method according to claim 1, which is characterized in that obtain all updates operation of source database
Step specifically:
All operations for acting on source database are recorded in chronological order；
Extract the update operation that source database can be caused to change.
3. data reconstruction method according to claim 1, which is characterized in that the preset rules are in advance to specific right
The rule being arranged as, specific operation, and preset rules are modifiable.
4. data reconstruction method according to claim 3, which is characterized in that if update operation violates preset rules,
The step of whether the update operation is unreasonable operation then judged specifically:
If the update operation violates preset rules, system, which issues, is reminded；
According to prompting, user instruction is obtained；
According to user instructions, judge whether the update operation is unreasonable operation.
5. a kind of data recovery system characterized by comprising
Logging modle, for obtaining all update operations for acting on source database；
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；
System alert module issues prompting until receiving the update if violating preset rules for update operation
Operation whether be unreasonable operation judging result；
Recovery module, the change for the source database related data as caused by the operation are restored.
6. a kind of data recovery system, which is characterized in that including processor and for the storage of storage processor executable instruction
Device；Wherein the processor is configured to 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, prompting is issued until receiving whether the update operation is unreasonable behaviour
The judging result of work；
If the update operation is unreasonable operation, the change of the source database related data as caused by the operation is carried out
Restore；
Conversely, then update operation is executed in Backup Data.
7. data recovery system according to claim 6, which is characterized in that the preset rules are in advance to specific right
The rule being arranged as, specific operation, and preset rules are modifiable.
8. data recovery system according to claim 7, which is characterized in that if update operation violates preset rules,
The step of whether the update operation is unreasonable operation then judged specifically:
If the update operation violates preset rules, system, which issues, is reminded；
According to prompting, user instruction is obtained；
According to user instructions, judge whether the update operation is unreasonable operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811009532.6A CN109240854B (en) | 2015-12-18 | 2015-12-18 | Method and system for recovering data of change caused by misoperation |
Applications Claiming Priority (2)
| 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 |
Related Parent Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510957661.8A Division CN105528264B (en) | 2015-12-18 | 2015-12-18 | Fool proof data reconstruction method and its system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109240854A true CN109240854A (en) | 2019-01-18 |
| CN109240854B CN109240854B (en) | 2021-04-09 |
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 (1)
| 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 |
Family Applications After (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| 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 |
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 (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001209298A (en) * | 2000-01-24 | 2001-08-03 | Armat Corp | Remote education management system |
| CN1659522A (en) * | 2002-04-19 | 2005-08-24 | 电脑联合想象公司 | Method and system for disaster recovery |
| CN102567472A (en) * | 2011-12-14 | 2012-07-11 | 海角先锋(北京)科技有限公司 | Built-in database based high-efficient data deleting and restoring method |
| CN102693169A (en) * | 2011-03-25 | 2012-09-26 | 国际商业机器公司 | Method and device for recovering lessee data under multi-lessee environment, and database system |
| CN103383698A (en) * | 2013-06-27 | 2013-11-06 | 宇龙计算机通信科技(深圳)有限公司 | Data deletion method 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 |
| CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN100504905C (en) * | 2007-11-16 | 2009-06-24 | 中国科学院软件研究所 | Data-base malevolence transaction method and system thereof |
| CN100590599C (en) * | 2007-12-06 | 2010-02-17 | 福建星网锐捷网络有限公司 | Write-operation process method, system and apparatus of FLASH |
| CN101923573A (en) * | 2010-08-09 | 2010-12-22 | 哈尔滨工程大学 | Rapid database data recovery method aiming at data loss |
| CN101916215B (en) * | 2010-08-09 | 2012-02-01 | 哈尔滨工程大学 | Operation intercept based repentance method of distributed critical task system |
| 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 |
| 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 (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001209298A (en) * | 2000-01-24 | 2001-08-03 | Armat Corp | Remote education management system |
| CN1659522A (en) * | 2002-04-19 | 2005-08-24 | 电脑联合想象公司 | Method and system for disaster recovery |
| CN102693169A (en) * | 2011-03-25 | 2012-09-26 | 国际商业机器公司 | Method and device for recovering lessee data under multi-lessee environment, and database system |
| CN102567472A (en) * | 2011-12-14 | 2012-07-11 | 海角先锋(北京)科技有限公司 | Built-in database based high-efficient data deleting and restoring method |
| CN103383698A (en) * | 2013-06-27 | 2013-11-06 | 宇龙计算机通信科技(深圳)有限公司 | Data deletion method 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 |
| CN105045678A (en) * | 2015-07-09 | 2015-11-11 | 小米科技有限责任公司 | Database recovery method and apparatus |
Non-Patent Citations (2)
| Title |
|---|
| O. SUDARSKY，C. GOTSMAN: "Dynamic scene occlusion culling", 《IEEE TRANSACTIONS ON VISUALIZATION AND COMPUTER GRAPHICS》 * |
| 苏伟: "有效降低数据库批量操作失误风险的管控设计和系统实践", 《电子技术与软件工程》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109117314B (en) | 2021-04-16 |
| CN109240854B (en) | 2021-04-09 |
| CN109165121B (en) | 2021-03-23 |
| CN109117314A (en) | 2019-01-01 |
| CN109165121A (en) | 2019-01-08 |
| CN105528264A (en) | 2016-04-27 |
| CN105528264B (en) | 2018-08-21 |
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 | |
| CN107609188B (en) | Data synchronization verification method based on golden gate | |
| CN107451040A (en) | Localization method, device and the computer-readable recording medium of failure cause | |
| CN105404581B (en) | A kind of evaluating method and device of database | |
| US10747776B2 (en) | Replication control using eventually consistent meta-data | |
| CN107688487A (en) | For the method and system for the state for recovering database session | |
| CN102857371B (en) | A kind of dynamic allocation management method towards group system | |
| WO2019051042A1 (en) | Apparatus and method for real time analysis, predicting and reporting of anomalous database transaction log activity | |
| CN103370693A (en) | Restarting processes | |
| CN104252500A (en) | Method and device for carrying out fault repairing on database management platform | |
| US8554727B2 (en) | Method and system of tiered quiescing | |
| CN107797896B (en) | A kind of data on flows self- recoverage processing method and server | |
| CN109254922A (en) | A kind of automated testing method and device of server B MC Redfish function | |
| 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 | |
| CN108337108A (en) | A kind of cloud platform failure automation localization method based on association analysis | |
| CN108958965A (en) | A kind of BMC monitoring can restore the method, device and equipment of ECC error | |
| CN110291505A (en) | Reduce the recovery time of application | |
| WO2021012565A1 (en) | Business system test method and apparatus, device, and storage medium | |
| CN108287774A (en) | A kind of method for diagnosing faults of server, device, equipment and storage medium | |
| CN103440460A (en) | Application system change validation method and system | |
| WO2012101531A1 (en) | Data integrity protection in storage volumes | |
| CN105468418A (en) | System and method for upgrading software of smart terminal cluster | |
| CN105760283B (en) | A kind of log-output method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |