CN106547801A - Database data flash back method and apparatus - Google Patents
Database data flash back method and apparatus Download PDFInfo
- Publication number
- CN106547801A CN106547801A CN201510613717.8A CN201510613717A CN106547801A CN 106547801 A CN106547801 A CN 106547801A CN 201510613717 A CN201510613717 A CN 201510613717A CN 106547801 A CN106547801 A CN 106547801A
- Authority
- CN
- China
- Prior art keywords
- maloperation
- data base
- row
- daily record
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/1805—Append-only file systems, e.g. using logs or journals to store data
- G06F16/1815—Journaling file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The method and apparatus the invention discloses a kind of database data flashes back, is related to database technical field.Methods described includes：Receiving data recovery request；The data recovery request includes the very first time corresponding to the maloperation for data base；From the operation note daily record of data base, the operation note daily record of the maloperation part of the correspondence very first time is obtained；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；Each row operation corresponding with the maloperation is parsed from the operation note daily record；From the beginning of last column of each row operation corresponding with the maloperation, reverse operating corresponding with the maloperation is carried out for data base.The present invention achieves that the time for using is shorter, recover efficiency high, can effectively solve the problem that the beneficial effect of impact of the user to database access that recovery time is longer and produces.
Description
Technical field
The present invention relates to database technical field, and in particular to a kind of database data flash back method and dress
Put.
Background technology
Data base (Database), is come the warehouse organized, store and manage data according to data structure.
Data base has number of different types, and the form from the simplest various data that are stored with is to can carry out magnanimity number
All it is widely used in all fields according to the large-scale database system of storage.
At present, many business have all used data base, such as there is a kind of following framework, front-end server
Each applied business service to the phase in back-end server should the data base of application service carry out data
The operation such as management operation, such as inquiry, renewal, deletion, modification.And the skill of front end applications business service
Art personnel, when operating to above-mentioned data base, it is understood that there may be maloperation, when such as being deleted, should
One deletion condition of the setting, such as deletes the row of some ID of table, but technical staff is not provided with this
Deletion condition, whole table may be deleted by which.Thus, the maloperation may then affect data base
The effectiveness of subsequent operation.
For above-mentioned situation, in first technology, in the following way the data of data base can be carried out extensive
It is multiple：
1st, nearest DB Backup before searching the maloperation moment.
2nd, by the DB Backup by database recovery to backup time.
3rd, on the basis of the data base of the recovery, by technical staff by backup time to the maloperation moment
Normal operating, by operation tandem re-execute one time.
Such as, first technology daily 12:00 couple of data base backs up, when some day 10:00 data base
It is misused, then needs to extract the DB Backup of the previous day, by database recovery to the previous day 12:00
When state, then from 12:State when 00, will be from 12:00 starts to the day 10:00 mistake behaviour
Operation before making the moment to data base, is re-executed one time by operation tandem, reaches data base
Correct state before maloperation in this day.But which uses the DB Backup of the previous day from the mistake recovered
The time that journey needs is long, and needs for backup time to re-execute one to the operation between the maloperation moment
Time, which is also required to for a long time.Therefore, the recovery efficiency of the data base of first technology is low, the time is long,
For applied business on many lines, its longer recovery time can largely effect on user's logarithm
According to the access in storehouse.
The content of the invention
In view of the above problems, it is proposed that the present invention overcomes the problems referred to above or at least part of to provide one kind
Solve the above problems database data flash back device and corresponding database data flash back method.
According to one aspect of the present invention, there is provided a kind of database data flash back method, including：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of maloperation.
Alternatively, in the operation note daily record from data base, obtain the mistake of the correspondence very first time
The operation note daily record of operation part, including：
Start the first process, by described in first process simulation data base from storehouse, and notify the number
The operation note daily record of the maloperation part of the correspondence very first time is returned according to storehouse.
Alternatively, the operation note daily record is binary binlog daily records.
Alternatively, it is described that each row behaviour corresponding with the maloperation is parsed from the operation note daily record
Make, including：
The binary stream of the binlog daily records is resolved to a plurality of row for recording in temporal sequence to can perform
Operation；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
Alternatively, it is operated each row corresponding with the maloperation is parsed from the operation note daily record
Afterwards, also include：
Operated according to each row corresponding with the maloperation, generate maloperation and indicate file.
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
Stating the corresponding reverse operating of operation includes：
From the beginning of last column of each row operation corresponding with the maloperation, extracting correspondence one by one carries out phase
The SQL statement of inverse operations；
The SQL statement is performed, with the data in restoring data storehouse one by one.
Alternatively, the non-inquiry generic operation includes：Deletion action, renewal operation, insertion operation.
According to a further aspect in the invention, there is provided a kind of database data flashes back device, including：
Recovery request receiver module, is suitable to receiving data recovery request；The data recovery request includes pin
To the very first time corresponding to the maloperation of data base；
Operation note log acquisition module, is suitable to from the operation note daily record of data base, obtains correspondence institute
State the operation note daily record of the maloperation part of the very first time；Row format record is pressed in the operation note daily record
Non- inquiry generic operation to data base；
Parsing module, is suitable to from the operation note daily record parse each row behaviour corresponding with the maloperation
Make；
Reverse operating module, is suitable to from the beginning of last column of each row operation corresponding with the maloperation,
Reverse operating corresponding with the maloperation is carried out for data base.
Alternatively, the operation note log acquisition module includes：
Operation note daily record returns submodule, is suitable to start the first process, by the first process simulation institute
State data base from storehouse, and notify that the data base returns to the maloperation part of the correspondence very first time
Operation note daily record.
Alternatively, the operation note daily record is binary binlog daily records.
Alternatively, the parsing module includes：
Binary stream analyzing sub-module, is suitable to resolve to temporally the binary stream of the binlog daily records
The executable operation of a plurality of row of sequential recording；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
Alternatively, after the parsing module, also include：
Maloperation indicates file generation module, is suitable to according to each row operation corresponding with the maloperation, raw
File is indicated into maloperation.
Alternatively, the reverse operating module includes：
SQL statement extracting sub-module, is suitable to the last column from each row operation corresponding with the maloperation
Start, extracting correspondence one by one carries out the SQL statement of inverse operation.
Alternatively, it is characterised in that the non-inquiry generic operation includes：Deletion action, update operation,
Insertion operation.
According to another aspect of the present invention, there is provided a kind of equipment, including：
Memorizer, is loaded with a plurality of executable instruction；
Processor, performs a plurality of executable instruction；The a plurality of instruction includes performing following steps
Method：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of operation.
Database data flash back method and apparatus according to embodiments of the present invention, by the operation from data base
In log, the maloperation part operation log of the correspondence very first time is obtained, and will be from maloperation
Carry out for data base from the beginning of last column in corresponding each row operation in partial operation note daily record
Reverse operating corresponding with maloperation, it is possible to achieve the recovery to data base, the present invention only need to be to maloperations
Part carries out reverse operating and is capable of achieving the recovery to data storehouse.Solve in first technology, directly pass through
Extract DB Backup, to backup time to maloperation moment during the operation execution side of a time again
Case, causes the problem of database recovery time length, achieve the time that the solution of the present invention uses it is shorter,
Recover efficiency high, can effectively solve the problem that the impact that recovery time is longer and the user of generation is to database access
Effect.
Described above is only the general introduction of technical solution of the present invention, in order to better understand the skill of the present invention
Art means, and being practiced according to the content of description, and in order to allow, the present invention's is above and other
Objects, features and advantages can become apparent, below especially exemplified by the specific embodiment of the present invention.
Description of the drawings
By the detailed description for reading hereafter preferred implementation, various other advantages and benefit are for this
Field those of ordinary skill will be clear from understanding.Accompanying drawing is only used for the purpose for illustrating preferred implementation,
And it is not considered as limitation of the present invention.And in whole accompanying drawing, be denoted by the same reference numerals
Identical part.In the accompanying drawings：
The step of Fig. 1 shows a kind of database data flash back method according to an embodiment of the invention is flowed
Cheng Tu；
The step of Fig. 2 shows a kind of database data flash back method according to an embodiment of the invention is flowed
Cheng Tu；
Fig. 3 shows that a kind of structure of database data flash back device according to an embodiment of the invention is shown
It is intended to；
Fig. 4 shows that a kind of structure of database data flash back device according to an embodiment of the invention is shown
It is intended to；And
Fig. 5 shows a kind of structural representation of equipment according to an embodiment of the invention.
Specific embodiment
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although showing in accompanying drawing
The exemplary embodiment of the disclosure, it being understood, however, that may be realized in various forms the disclosure and not
Should be limited by embodiments set forth here.On the contrary, there is provided these embodiments are able to more thoroughly
Understand the disclosure, and the scope of the present disclosure complete can be conveyed to those skilled in the art.
Embodiment one
With reference to Fig. 1, a kind of step of database data flash back method that the embodiment of the present invention one is provided is shown
Rapid flow chart, can specifically include：
Step S110：Receiving data recovery request；The data recovery request includes the mistake for data base
The operation corresponding very first time.
The embodiment of the present invention can apply to the recovery that data or table are carried out for data base's maloperation.Number
Can be that certain table is deleted by mistake in data base according to storehouse maloperation, or the data in certain table are deleted by mistake
Remove, or some data have been added in error list by mistake etc..The embodiment of the present invention can be applied
In MySQL database.
Certainly the system structure of the embodiment of the present invention can include database server and the front end of rear end
The framework of various applied business servers.Before its applied business can be deployed in by each applied business developer
On the applied business server at end, then supported using the database server of rear end.Rear end
Database server possess the access right of various data bases.
The data recovery request for a data base is received, is contained for data in the data recovery request
The maloperation corresponding very first time in storehouse.
The maloperation corresponding very first time can be the sometime point occurred in maloperation, for example, from morning
Upper 9:00 moment, manager of programming are operated in the addition that some data have been carried out to A data bases,
When 12:During 00 moment, manager of programming has found be added in table 1, but but these data
These data are added in table 2, herein, it is possible to 9:00 moment is used as data base's maloperation
The very first time.
Step S120：From the operation note daily record of data base, the mistake of the correspondence very first time is obtained
The operation note daily record of operation part；The operation note daily record is have recorded to the non-of data base by row format
Inquiry generic operation.
In the embodiment of the present invention, the modification operation carried out to data base all can recorded operation note accordingly
In daily record, wherein, operation note daily record is the non-inquiry generic operation to data base carried out according to row format.
Wherein, row format is each SQL statement often the going to every tables of data to modifying in data base
The operation of data and execution time are recorded in daily record.For example, 08:43 moment are in data base A
Table 1 with the addition of ID be 19, name be Zhang San data, the SQL statement of execution is：insert into
Table 1 (ID, name) values (19, Zhang San), accordingly, in the operation note daily record of data base
In can be the SQL statement to, in table 1, each row of data of insertion and execution time are remembered accordingly
Record.That is, the situation of the operation to all rows of one SQL statement of record.
Non- inquiry generic operation can include：Deletion action, renewal operation and insertion operation.Deletion action can
To be the deletion for data in database table, it can be the deletion for table in data base；Update operation
It can be the change for some data in database table；Insertion operation can be table a certain for data base
The addition of middle data, or the addition for table in data base.
Preferably, the operation note daily record is binary binlog daily records.
Binlog log recordings perform all operations of non-inquiry class to data base, but also can include
Perform the information such as the time and execution time of the non-inquiry generic operation of data base.
It is described in detail with the change operation that specific example is specified to data base below.
Deletion action can be the deletion for data in data base, for example, 18:At 00 moment, delete
The data of id=19 in table 1, SQL statement is：Delete from table 1where id=19；Can also be
For the deletion of table in data base, for example, 18:At 06 moment, delete the table 3, SQL in data base
Sentence is：Drop table tables 3.Binlog daily records can be to these deletion actions performed for data
SQL statement and corresponding execution time are recorded.
Under row (OK) form, the context phase of the SQL statement of execution can not be recorded in binlog
The information of pass, only only needs to record that record and is modified, and what is modified as, so row
The every data line modification of recording of being perfectly clear of log content details,
Than if any such update sentence：
UPDATE product SET owner_member_id='b'WHERE
owner_member_id
After execution, that what is recorded in daily record is not this event (MySQL corresponding to update sentences
Bin-log daily records are recorded in the form of event), but updated each record of this sentence
Situation of change, is thus recorded as many events that many bar records are updated.
Insertion operation can be the addition for data in a certain table of data base, for example, 19:05 moment,
Add an id=5, name=outstanding data in table 4, SQL statement is：Insert into tables 4
(id, name) values (5, Zhang Jie)；Can also be the addition for table in data base, for example,
Add table 6 in data base, SQL statement is：Create table tables 4 (id, name, age).binlog
Daily record can be to the corresponding each insertion number of the SQL statement of these addition operations performed for data
According to being recorded.
Step S130：Each row operation corresponding with the maloperation is parsed from the operation note daily record.
In the embodiment of the present invention, in the operation note daily record of the maloperation part for obtaining the correspondence very first time
Afterwards, as the information of the change operation in operation note daily record for data is to be stored in the form of streaming
, so that each row operation corresponding for maloperation is parsed.
Preferably, each row operation corresponding with the maloperation is parsed in the daily record from operation note, can
To include：
The binary stream of the binlog daily records is resolved to what is recorded in temporal sequence by sub-step A131
The executable operation of a plurality of row；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
In the embodiment of the present invention, the byte in binary stream is to be based entirely on programming their form to write
Enter in binlog daily records, and be based entirely on the form that they are read from binlog daily records and be read into journey
In sequence, they do not make any change, thus, reading, binlog daily record extractions are corresponding with maloperation
When each row is operated, need for the binary stream of binlog to resolve to readable documents.
The binary stream of binlog daily records is resolved to readable text specifically to may comprise steps of：
Step A1：The binary stream of conversion needed for obtaining；
Step A2：An interim byte array is created, readable text is stored；
Step A3：Set up the corresponding binary stream object of readable text；
Step A4：According to binary stream object, readable text data is read.
Can realize resolving to the binary stream of binlog daily records by the above-mentioned steps of the present embodiment can
The executable operation of a plurality of row read.
Certainly, the binlog daily records that the embodiment of the present invention can also be analyzed and acquired by by other instruments, than
Such as with instruments such as python, mysqlbinlog-v.Python instruments are utilized and for example, its resolving is such as
Under：
1st, seek first is to original position；
2nd, first event type is parsed, if table_map_event opens parsing, if
It is not just to skip.
Because if being that the mode that a normal sentence is recorded in ROW forms is certainly
Table_map_event+ is specifically operated.
3rd, then proceed to parse next table_map_evnt by that analogy, can just parse each row SQL
Sentence.
It should be understood that above-mentioned can with regard to the binary stream of binlog daily records is resolved to readable a plurality of row
The step of performing operation, is intended merely to allow those skilled in the art to better understood when the present invention, and carries
A kind of binary stream of the parsing binlog daily records for going out is the scheme that readable a plurality of row can perform operation, no
Can be in this, as limitation of the present invention.
Sub-step A132, using a plurality of row executable operation as each row corresponding with the maloperation
Operation, or from the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
In the embodiment of the present invention, can hold the binary stream of binlog daily records is resolved to readable a plurality of row
After row operation, directly a plurality of row executable operation can be operated as each row corresponding with maloperation,
Transaction rollback operation is performed, the data recovery of data base is realized, for example, binlog binary streams is parsed
The executable operation arrived is 10 rows, then directly using 10 row executable operation as corresponding with maloperation
Operation, performs one by one in reverse order and transaction rollback operation is performed in data base, realize that the data of data base are extensive
It is multiple；
Can also be from the executable operation of a plurality of row, each row operation that extraction is associated with maloperation, for example,
Be 10 rows by the executable operation that obtains of parsing of binlog binary streams, in the executable operation of this 10 row with
Related only rear 5 rows of maloperation, then can choose what is be associated with maloperation from this 10 row
The executable operation of 5 rows afterwards, performs transaction rollback operation in data base, realizes the data recovery of data base.
It is appreciated that the present invention corresponding to the operation note daily record that gets all can perform behaviour
Make all to carry out reverse operating.The executable operation related to maloperation can also only be chosen reversely to be grasped
Make, the data volume of this kind of form recovery is little, and coverage is little.
Preferably, it is operated each row corresponding with the maloperation is parsed from the operation note daily record
Afterwards, can also include：
Step S131, operates according to each row corresponding with the maloperation, generates maloperation and indicates file.
In the embodiment of the present invention, indicate file can each row operation corresponding to maloperation store, when
When data base occurs maloperation, can be recovered by calling the maloperation of the instruction file to data base
Operation, and without the need for recovering to the data in data base one by one or one by one again, therefore, it is possible to improve
The resume speed of database data, and operating procedure is less, it is simple to operate.
In addition, the maloperation indicates that file can also be sent to the service technique personnel of front-end business server
Check, allow its data base for voluntarily business being applied to according to its data base authority to perform contrary operation.
Step S140：From the beginning of last column of each row operation corresponding with the maloperation, for number
Reverse operating corresponding with the maloperation is carried out according to storehouse.
In the embodiment of the present invention, after parsing obtains each row operation corresponding with maloperation, in data base
Middle execution transaction rollback operation, carries out recovery operation to data base, and the maloperation to data base recovers
Carry out according to reverse operating corresponding with maloperation.Wherein, with the reverse operating of maloperation can be
Order reverse and perform the reverse of sentence.The direction of order is the recovery operation to data base and to data
The order of the maloperation in storehouse is contrary, and for example, the maloperation to data base is according to 1,2 ... 10
What order was carried out, and the recovery to data base is then according to the reverse operating from 10,9 ... 1 order；
Perform sentence be reversely for data base maloperation carry out perform sentence inverse operation, for example, hold
Line statement is the insertion operation of certain data, then be then that the data deletes behaviour to the recovery operation of data base
Make, the maloperation to data base is that a data is added in data base, insert into table 1values
(12, Li Hong), then, when recovering to data base, perform contrary operation, will the data delete
Remove, delete from table 1where id=12.
Preferably, from the beginning of last column of each row operation corresponding with the maloperation, for data base
Carry out to include with the corresponding reverse operating of the operation：
Sub-step 141, from the beginning of last column of each row operation corresponding with the maloperation, is carried one by one
Taking correspondence carries out the SQL statement of inverse operation；
Sub-step 142, performs the SQL statement, with the data in restoring data storehouse one by one.
In the embodiment of the present invention, started according to last column of the corresponding each row operation of maloperation, carried one by one
Taking correspondence carries out the SQL statement of inverse operation, and performs the SQL statement to realize to number in data base
According to reduction.For example, when delete certain table, which is to data base according to first
In data deleted one by one, then again by table delete order, can in database manipulation log
Detailed record is carried out with the order to these data deletions, then according still further to such as upper type with reverse suitable
Ordered pair the data base recovered, and for example, the table 1 in data base is deleted by the maloperation to data base,
Storage and 6 datas in table 1, it is as follows to the deletion order of 6 datas in table 1：
Then in operation note daily record according to corresponding data deletion order to delete operation SQL statement and
The execution time, and data are recorded accordingly, finally record the SQL languages to 1 deletion action of table
Sentence, it is as follows：
Accordingly, to the operation of the data recovery of the data base be according to reverse operating corresponding with maloperation according to
It is secondary to carry out, it is as follows：
1st, create table tables 1
2nd, insert into tables 1 (id, name, age, sex) values (2, Li Li, 23, female)
3rd, insert into tables 1 (id, name, age, sex) values (3, Ren Hao, 25, man)
4th, insert into tables 1 (id, name, age, sex) values (5, king station, 16, man)
5th, insert into tables 1 (id, name, age, sex) values (6, Zhang Jing, 23, female)
6th, insert into tables 1 (id, name, age, sex) values (4, Li Tian, 21, female)
7th, insert into tables 1 (id, name, age, sex) values (1, Li Han, 18, man)
Corresponding operation is performed according to as above institute's mode to recover with the data for realizing data base one by one.
By, from the operation note daily record of data base, obtaining the correspondence very first time in the embodiment of the present invention
Maloperation part operation log, and by corresponding each row from the operation note daily record of maloperation part
In operation from the beginning of last column, reverse operating corresponding with maloperation, Ke Yishi are carried out for data base
The now recovery to data base.In relative to first technology, directly by extracting DB Backup, to backup
Operation during moment to maloperation moment performs the scheme of a time again, and the present invention only need to be to maloperation portion
Dividing carries out the i.e. achievable recovery to data storehouse of reverse operating, thus, the time that the solution of the present invention is used
It is shorter, recover efficiency high, can effectively solve the problem that recovery time it is longer and produce user to database access
Impact.
Embodiment two
With reference to Fig. 2, a kind of step of database data flash back method that the embodiment of the present invention two is provided is shown
Rapid flow chart, can specifically include：
Step S210：Receiving data recovery request；The data recovery request is included for data base's
The very first time corresponding to maloperation.
Step S220：Start the first process, by described in first process simulation data base from storehouse,
And notify that the data base returns the operation note daily record of the maloperation part of the correspondence very first time.
In the embodiment of the present invention, after data recovery request is received, start the first process, by this
One process is according to data base's master library (Master) and data base from the protocol emulation data base of storehouse (Slave)
From storehouse, so that the operation note day of the maloperation part of the correspondence very first time is obtained from the master library of data base
Will.
Data base's is the backup library of data base from storehouse, in practical application, after MDL is set up,
Can set up corresponding from data base accordingly, to avoid as odjective cause is (as server occurs firmly
Part problem cannot be repaired) cause the loss of data in data base, MDL to be responsible for the load of write operation,
And the operation read then is split in and carries out from data base, the efficiency of reading can be greatly improved.
The embodiment of the present invention is then the first process simulation from data base, and the simulation only obtains behaviour from data base
Note down daily record, not really from data base.
Below by taking MySQL as an example, it is described in detail how according to data base principal and subordinate storehouse protocol emulation from storehouse,
To obtain the scheme of the operation note daily record of the maloperation part of the correspondence very first time in master library,
Such scheme specifically may comprise steps of：
Step B1：The upper master library of IO threads connection from storehouse, and ask from specified Operation Log file
Maloperation part log content；
Step B2：Master library is received after the request of the IO threads in storehouse, by the IO lines for replicating
Journey reads the log information for specifying daily record maloperation part according to solicited message, returns to the IO from storehouse end
Thread；In the log information of the maloperation part of return in addition to the information included by daily record, also include
The information that this returns is in title and the position in binlog of the binlog files at master library end；
Step B3：Receive after the log information of maloperation part from the IO threads in storehouse, by what is received
Log content is written to the least significant end of the Relay Log files from storehouse end successively, and by the master library for reading
The filename and location of the binlog at end is recorded in master-info files；
Step B4, detect after the content newly increased in Relay Log from the SQL threads in storehouse, can horse
The upper content parsed in the Relay Log files becomes executable when master library end truly performs
SQL statement；
Step B5：Start the first process, obtain these SQL statement from storehouse end from data base.
Data base's return can be got from storehouse end from data base by the aforesaid way of the present embodiment
The operation note daily record of the maloperation part of the correspondence very first time, it is possible to understand that, it is above-mentioned with regard to from data
The step of storehouse returns the operation note daily record of the maloperation part of the correspondence very first time, is intended merely to allow ability
Field technique personnel better understood when the present invention, and a kind of operation of the acquisition maloperation part for proposing is remembered
The scheme of record daily record, it is impossible in this, as limitation of the present invention.
Step S230：Each row operation corresponding with the maloperation is parsed from the operation note daily record.
Step S240：From the beginning of last column of each row operation corresponding with the maloperation, for number
Reverse operating corresponding with the maloperation is carried out according to storehouse.
The corresponding operation note daily record in maloperation part to receiving is parsed, and obtains maloperation correspondence
The operation of each row, from the beginning of last column of the corresponding each row operation of maloperation, for data base carry out with
The corresponding reverse operating of maloperation.
In the embodiment of the present invention, for the recovery request for receiving, behaviour by mistake can be got from data base
Make the operation log recording of part, and carry out the operation note daily record of maloperation part parsing to obtain and by mistake
Corresponding each row operation is operated, from the beginning of last column, is carried out for data base corresponding with maloperation anti-
To operation, it is possible to achieve the recovery to data base, relative to first technology, directly by extracting data base
Backup, to backup time to maloperation moment during operation perform the scheme of a time, the present invention again
Reverse operating need to be carried out to maloperation part and is capable of achieving the recovery to data storehouse, thus, the side of the present invention
Time that case is used is shorter, recover efficiency high, can effectively solve the problem that the user that recovery time is longer and produces
Impact to database access.
Embodiment three
With reference to Fig. 3, a kind of knot of database data flash back device that the embodiment of the present invention three is provided is shown
Structure schematic diagram, can specifically include：
Recovery request receiver module 310, is suitable to receiving data recovery request；The data recovery request bag
Include the very first time corresponding to the maloperation for data base；
Operation note log acquisition module 320, is suitable to from the operation note daily record of data base, and it is right to obtain
Answer the operation note daily record of the maloperation part of the very first time；Row format is pressed in the operation note daily record
Have recorded the non-inquiry generic operation to data base；
Parsing module 330, is suitable to from the operation note daily record to parse corresponding with the maloperation each
Row operation；
Reverse operating module 340, the last column being suitable to from each row operation corresponding with the maloperation are opened
Begin, reverse operating corresponding with the maloperation is carried out for data base.
Preferably, the operation note daily record is binary binlog daily records.
Preferably, the parsing module 330 can include：
Binary stream analyzing sub-module, is suitable to resolve to temporally the binary stream of the binlog daily records
The executable operation of a plurality of row of sequential recording；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
Preferably, after the parsing module 330, can also include：
Maloperation indicates file generation module, is suitable to according to each row operation corresponding with the maloperation, raw
File is indicated into maloperation.
Preferably, the reverse operating module 340 can include：
SQL statement extracting sub-module, is suitable to the last column from each row operation corresponding with the maloperation
Start, extracting correspondence one by one carries out the SQL statement of inverse operation；
Preferably, the non-inquiry generic operation can include：Deletion action, renewal operation, insertion operation.
Example IV
With reference to Fig. 4, a kind of knot of database data flash back device that the embodiment of the present invention four is provided is shown
Structure schematic diagram, can specifically include：
Recovery request receiver module 410, is suitable to receiving data recovery request；The data recovery request bag
Include the very first time corresponding to the maloperation for data base；
Operation log recording module 420, is suitable to from the operation note daily record of data base, obtains correspondence institute
State the operation note daily record of the maloperation part of the very first time；Row format record is pressed in the operation note daily record
Non- inquiry generic operation to data base；Can specifically include：
Operation note daily record returns submodule 4202, is suitable to start the first process, by the first process mould
Intend the data base from storehouse, and notify that the data base returns to the maloperation portion of the correspondence very first time
The operation note daily record for dividing；
Parsing module 430, is suitable to from the operation note daily record to parse corresponding with the maloperation each
Row operation；
Reverse operating module 440, the last column being suitable to from each row operation corresponding with the maloperation are opened
Begin, reverse operating corresponding with the maloperation is carried out for data base.
Embodiment five
With reference to Fig. 5, a kind of structural representation of equipment that the embodiment of the present invention five is provided is shown, specifically
The equipment 500 can specifically include：
Memorizer 510, is loaded with a plurality of executable instruction；
Processor 520, performs a plurality of executable instruction；The a plurality of executable instruction includes following
The method of step：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of maloperation.
Preferably, a plurality of executable instruction of the embodiment of the present invention may also include the side of aforementioned each step
Method, the embodiment of the present invention are not limited to which.
Algorithm and display are solid with any certain computer, virtual system or miscellaneous equipment provided herein
There is correlation.Various general-purpose systems can also be used together based on teaching in this.As described above,
It is obvious to construct the structure required by this kind of system.Additionally, the present invention be also not for it is any specific
Programming language.It is understood that, it is possible to use various programming languages realize the content of invention described herein,
And the description done to language-specific above is for the preferred forms for disclosing the present invention.
In description mentioned herein, a large amount of details are illustrated.It is to be appreciated, however, that this
Inventive embodiment can be put into practice in the case where not having these details.In some instances, not
Known method, structure and technology are shown specifically, so as not to obscure the understanding of this description.
Similarly, it will be appreciated that in order to simplify the disclosure and help understand in each inventive aspect
Or it is multiple, above to, in the description of the exemplary embodiment of the present invention, each feature of the present invention is sometimes
It is grouped together in single embodiment, figure or descriptions thereof.However, should not be by the disclosure
Method be construed to reflect following intention：I.e. the present invention for required protection requires ratio in each claim
The more features of middle feature be expressly recited.More precisely, as the following claims reflect
As, inventive aspect is less than all features of single embodiment disclosed above.Therefore, it then follows
Thus claims of specific embodiment are expressly incorporated in the specific embodiment, wherein each right
Separate embodiments of the requirement all as the present invention itself.
Those skilled in the art are appreciated that can be carried out to the module in the equipment in embodiment certainly
Adaptively change and they are arranged in one or more different from embodiment equipment.Can be with
Module or unit or component in embodiment is combined into a module or unit or component, and in addition may be used
To be divided into multiple submodule or subelement or sub-component.Except such feature and/or process or
Outside at least some in unit is excluded each other, (companion can be included to this specification using any combinations
With claim, summary and accompanying drawing) disclosed in all features and so disclosed any method or
All processes of person's equipment or unit are combined.Unless expressly stated otherwise, this specification (includes companion
With claim, summary and accompanying drawing) disclosed in each feature can it is identical by offers, be equal to or phase
Replace like the alternative features of purpose.
Although additionally, it will be appreciated by those of skill in the art that some embodiments described herein include which
Some included features rather than further feature in its embodiment, but the group of the feature of different embodiments
Conjunction means to be within the scope of the present invention and formed different embodiments.For example, in following power
In sharp claim, embodiment required for protection one of arbitrarily can in any combination mode making
With.
The present invention all parts embodiment can be realized with hardware, or with one or more process
The software module run on device is realized, or is realized with combinations thereof.Those skilled in the art should
Understand, basis can be realized using microprocessor or digital signal processor (DSP) in practice
Some or all parts in the database data flash back equipment of the embodiment of the present invention some or it is complete
Portion's function.The present invention is also implemented as performing some or all of method as described herein
Equipment or program of device (for example, computer program and computer program).Such realization
The program of the present invention can be stored on a computer-readable medium, or can be with one or more letter
Number form.Such signal can be downloaded from internet website and be obtained, or above carry in carrier signal
For, or provided with any other form.
It should be noted that above-described embodiment the present invention will be described rather than limits the invention,
And those skilled in the art can design replacement without departing from the scope of the appended claims
Embodiment.In the claims, any reference markss between bracket should not be configured to right
The restriction of requirement.Word "comprising" does not exclude the presence of element not listed in the claims or step.Position
Word "a" or "an" before element does not exclude the presence of multiple such elements.The present invention can
Realize with by means of the hardware for including some different elements and by means of properly programmed computer.
If in the unit claim for listing equipment for drying, several in these devices can be by same
Individual hardware branch is embodying.The use of word first, second, and third does not indicate that any order.
These words can be construed to title.
The invention discloses a kind of C1, database data flash back method, including：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of maloperation.
C2, the method according to C1, in the operation note daily record from data base, obtain correspondence
The operation note daily record of the maloperation part of the very first time, including：
Start the first process, by described in first process simulation data base from storehouse, and notify the number
The operation note daily record of the maloperation part of the correspondence very first time is returned according to storehouse.
C3, the method according to C1, the operation note daily record are binary binlog daily records.
C4, the method according to C3, described parsing from the operation note daily record are grasped by mistake with described
Make corresponding each row operation, including：
The binary stream of the binlog daily records is resolved to a plurality of row for recording in temporal sequence to can perform
Operation；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
C5, the method according to C1, are parsing from the operation note daily record and the maloperation
After corresponding each row operation, also include：
Operated according to each row corresponding with the maloperation, generate maloperation and indicate file.
C6, the method according to C1, from last column of each row operation corresponding with the maloperation
Start, carry out including with the corresponding reverse operating of the operation for data base：
From the beginning of last column of each row operation corresponding with the maloperation, extracting correspondence one by one carries out phase
The SQL statement of inverse operations；
The SQL statement is performed, with the data in restoring data storehouse one by one.
C7, the method according to C1-C6, the non-inquiry generic operation include：Deletion action, more
New operation, insertion operation.
The invention also discloses a kind of D8, database data flash back device, including：
Recovery request receiver module, is suitable to receiving data recovery request；The data recovery request includes pin
To the very first time corresponding to the maloperation of data base；
Operation note log acquisition module, is suitable to from the operation note daily record of data base, obtains correspondence institute
State the operation note daily record of the maloperation part of the very first time；Row format record is pressed in the operation note daily record
Non- inquiry generic operation to data base；
Parsing module, is suitable to from the operation note daily record parse each row behaviour corresponding with the maloperation
Make；
Reverse operating module, is suitable to from the beginning of last column of each row operation corresponding with the maloperation,
Reverse operating corresponding with the maloperation is carried out for data base.
D9, the device according to D8, the operation note log acquisition module include：
Operation note daily record returns submodule, is suitable to start the first process, by the first process simulation institute
State data base from storehouse, and notify that the data base returns to the maloperation part of the correspondence very first time
Operation note daily record.
D10, the device according to D8, the operation note daily record are binary binlog daily records.
D11, the device according to D10, the parsing module include：
Binary stream analyzing sub-module, is suitable to resolve to temporally the binary stream of the binlog daily records
The executable operation of a plurality of row of sequential recording；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
D12, the device according to D8, after the parsing module, also include：
Maloperation indicates file generation module, is suitable to according to each row operation corresponding with the maloperation, raw
File is indicated into maloperation.
D13, the device according to D8, the reverse operating module include：
SQL statement extracting sub-module, is suitable to the last column from each row operation corresponding with the maloperation
Start, extracting correspondence one by one carries out the SQL statement of inverse operation.
D14, the device according to D8-D13, the non-inquiry generic operation include：Deletion action,
Update operation, insertion operation.
The invention also discloses E15, a kind of equipment, including：
Memorizer, is loaded with a plurality of executable instruction；
Processor, performs a plurality of executable instruction；The a plurality of instruction includes performing following steps
Method：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of operation.
Claims (10)
1. a kind of database data flashes back method, including：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of maloperation.
2. method according to claim 1, it is characterised in that the operation from data base is remembered
In record daily record, the operation note daily record of the maloperation part of the correspondence very first time is obtained, including：
Start the first process, by described in first process simulation data base from storehouse, and notify the number
The operation note daily record of the maloperation part of the correspondence very first time is returned according to storehouse.
3. method according to claim 1, it is characterised in that the operation note daily record is two
The binlog daily records of system.
4. method according to claim 3, it is characterised in that described from the operation note day
Each row operation corresponding with the maloperation is parsed in will, including：
The binary stream of the binlog daily records is resolved to a plurality of row for recording in temporal sequence to can perform
Operation；
The a plurality of row executable operation is operated as each row corresponding with the maloperation, or from institute
State in the executable operation of a plurality of row, each row operation that extraction is associated with the maloperation.
5. method according to claim 1, it is characterised in that from the operation note daily record
After middle parsing each row operation corresponding with the maloperation, also include：
Operated according to each row corresponding with the maloperation, generate maloperation and indicate file.
6. method according to claim 1, it is characterised in that from corresponding with the maloperation
Last column of each row operation starts, and carries out reverse operating bag corresponding with the operation for data base
Include：
From the beginning of last column of each row operation corresponding with the maloperation, extracting correspondence one by one carries out phase
The SQL statement of inverse operations；
The SQL statement is performed, with the data in restoring data storehouse one by one.
7. the method according to one of claim 1-6, it is characterised in that the non-inquiry
Generic operation includes：Deletion action, renewal operation, insertion operation.
8. a kind of database data flashes back device, including：
Recovery request receiver module, is suitable to receiving data recovery request；The data recovery request includes pin
To the very first time corresponding to the maloperation of data base；
Operation note log acquisition module, is suitable to from the operation note daily record of data base, obtains correspondence institute
State the operation note daily record of the maloperation part of the very first time；Row format record is pressed in the operation note daily record
Non- inquiry generic operation to data base；
Parsing module, is suitable to from the operation note daily record parse each row behaviour corresponding with the maloperation
Make；
Reverse operating module, is suitable to from the beginning of last column of each row operation corresponding with the maloperation,
Reverse operating corresponding with the maloperation is carried out for data base.
9. device according to claim 8, it is characterised in that the operation note log acquisition
Module includes：
Operation note daily record returns submodule, is suitable to start the first process, by the first process simulation institute
State data base from storehouse, and notify that the data base returns to the maloperation part of the correspondence very first time
Operation note daily record.
10. a kind of equipment, including：
Memorizer, is loaded with a plurality of executable instruction；
Processor, performs a plurality of executable instruction；The a plurality of instruction includes performing following steps
Method：
Receiving data recovery request；The data recovery request is included corresponding to the maloperation for data base
The very first time；
From the operation note daily record of data base, the behaviour of the maloperation part of the correspondence very first time is obtained
Note down daily record；The operation note daily record have recorded the non-inquiry generic operation to data base by row format；
Each row operation corresponding with the maloperation is parsed from the operation note daily record；
From the beginning of last column of each row operation corresponding with the maloperation, carry out and institute for data base
State the corresponding reverse operating of operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510613717.8A CN106547801A (en) | 2015-09-23 | 2015-09-23 | Database data flash back method and apparatus |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510613717.8A CN106547801A (en) | 2015-09-23 | 2015-09-23 | Database data flash back method and apparatus |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106547801A true CN106547801A (en) | 2017-03-29 |
Family
ID=58365244
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510613717.8A Pending CN106547801A (en) | 2015-09-23 | 2015-09-23 | Database data flash back method and apparatus |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106547801A (en) |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169108A (en) * | 2017-05-19 | 2017-09-15 | 郑州云海信息技术有限公司 | A kind of method and apparatus that the fast quick-recovery of MySQL data is realized based on Oracle |
| CN107329854A (en) * | 2017-06-20 | 2017-11-07 | 算丰科技（北京）有限公司 | Operation repealing method and device, electronic equipment |
| CN107357885A (en) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | Method for writing data and device, electronic equipment, computer-readable storage medium |
| CN108345684A (en) * | 2018-03-06 | 2018-07-31 | 弘成科技发展有限公司 | Intelligent analysis system and analysis method based on various dimensions multi objective system |
| CN108984337A (en) * | 2018-05-29 | 2018-12-11 | 杭州网易再顾科技有限公司 | A kind of restorative procedure of data synchronous abnormality, prosthetic device, medium and calculate equipment |
| CN109241061A (en) * | 2018-09-14 | 2019-01-18 | 上海新炬网络信息技术股份有限公司 | Guard method for oracle database Truncate operation |
| CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
| CN109491834A (en) * | 2018-10-23 | 2019-03-19 | 网宿科技股份有限公司 | A kind of data reconstruction method and device applied to database |
| CN109656935A (en) * | 2018-11-23 | 2019-04-19 | 阿里巴巴集团控股有限公司 | The method and system of data readback for database |
| CN110134653A (en) * | 2019-05-17 | 2019-08-16 | 杭州安恒信息技术股份有限公司 | It is a kind of to utilize log auxiliary data base auditing method and system |
| CN110674151A (en) * | 2019-09-23 | 2020-01-10 | 四川长虹电器股份有限公司 | Method for supporting MySQL to quickly rollback data |
| CN110781036A (en) * | 2019-10-31 | 2020-02-11 | 北京东软望海科技有限公司 | Data recovery method and device, computer equipment and storage medium |
| CN111176887A (en) * | 2018-11-09 | 2020-05-19 | 上海擎感智能科技有限公司 | MySQL misoperation rollback method, equipment and system |
| CN111177141A (en) * | 2018-11-09 | 2020-05-19 | 上海擎感智能科技有限公司 | Method, equipment and system for recovering data by utilizing MySQL (MySQL structured query language) parallel copying |
| CN111913972A (en) * | 2019-05-10 | 2020-11-10 | 阿里巴巴集团控股有限公司 | Data processing method, device and equipment |
| CN112256656A (en) * | 2019-07-22 | 2021-01-22 | 中兴通讯股份有限公司 | Transaction rollback method and device, database, system and computer storage medium |
| CN112817798A (en) * | 2021-02-26 | 2021-05-18 | 北京车和家信息技术有限公司 | Data recovery method, device, medium and electronic equipment |
| CN113127261A (en) * | 2019-12-31 | 2021-07-16 | 浙江宇视科技有限公司 | File processing method, device, equipment and storage medium |
| CN113342841A (en) * | 2021-06-07 | 2021-09-03 | 北京许继电气有限公司 | Method and system for autonomously controllable database flashback deletion |
| CN117971854A (en) * | 2024-04-02 | 2024-05-03 | 天津南大通用数据技术股份有限公司 | Data flashback implementation method based on GBase8s database logical log |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102024052A (en) * | 2010-12-17 | 2011-04-20 | 北京握奇数据系统有限公司 | Method and device for realizing transaction of data storage system |
| US20120030172A1 (en) * | 2010-07-27 | 2012-02-02 | Oracle International Corporation | Mysql database heterogeneous log based replication |
| US20120166576A1 (en) * | 2010-08-12 | 2012-06-28 | Orsini Rick L | Systems and methods for secure remote storage |
| CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
| CN104820625A (en) * | 2015-05-19 | 2015-08-05 | 重庆大学 | A data record, backup, and recovery method oriented to an information management system |
-
2015
- 2015-09-23 CN CN201510613717.8A patent/CN106547801A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120030172A1 (en) * | 2010-07-27 | 2012-02-02 | Oracle International Corporation | Mysql database heterogeneous log based replication |
| US20120166576A1 (en) * | 2010-08-12 | 2012-06-28 | Orsini Rick L | Systems and methods for secure remote storage |
| CN102024052A (en) * | 2010-12-17 | 2011-04-20 | 北京握奇数据系统有限公司 | Method and device for realizing transaction of data storage system |
| CN104679841A (en) * | 2015-02-11 | 2015-06-03 | 北京京东尚科信息技术有限公司 | Consumption terminal data flow copying method and system |
| CN104820625A (en) * | 2015-05-19 | 2015-08-05 | 重庆大学 | A data record, backup, and recovery method oriented to an information management system |
Cited By (31)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107169108B (en) * | 2017-05-19 | 2020-10-20 | 苏州浪潮智能科技有限公司 | Method and device for realizing MySQL data quick recovery based on Oracle |
| CN107169108A (en) * | 2017-05-19 | 2017-09-15 | 郑州云海信息技术有限公司 | A kind of method and apparatus that the fast quick-recovery of MySQL data is realized based on Oracle |
| CN107329854A (en) * | 2017-06-20 | 2017-11-07 | 算丰科技（北京）有限公司 | Operation repealing method and device, electronic equipment |
| CN107357885A (en) * | 2017-06-30 | 2017-11-17 | 北京奇虎科技有限公司 | Method for writing data and device, electronic equipment, computer-readable storage medium |
| CN107357885B (en) * | 2017-06-30 | 2020-11-20 | 北京奇虎科技有限公司 | Data writing method and device, electronic equipment and computer storage medium |
| CN108345684A (en) * | 2018-03-06 | 2018-07-31 | 弘成科技发展有限公司 | Intelligent analysis system and analysis method based on various dimensions multi objective system |
| CN108984337B (en) * | 2018-05-29 | 2021-04-16 | 杭州网易再顾科技有限公司 | Data synchronization abnormity repairing method, device, medium and computing equipment |
| CN108984337A (en) * | 2018-05-29 | 2018-12-11 | 杭州网易再顾科技有限公司 | A kind of restorative procedure of data synchronous abnormality, prosthetic device, medium and calculate equipment |
| CN109241061B (en) * | 2018-09-14 | 2022-02-11 | 上海新炬网络信息技术股份有限公司 | Protection method for Oracle database trunte operation |
| CN109241061A (en) * | 2018-09-14 | 2019-01-18 | 上海新炬网络信息技术股份有限公司 | Guard method for oracle database Truncate operation |
| CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
| CN109299099B (en) * | 2018-10-11 | 2020-11-06 | 瀚高基础软件股份有限公司 | Data flashback query and recovery method and device for PostgreSQL database |
| CN109491834A (en) * | 2018-10-23 | 2019-03-19 | 网宿科技股份有限公司 | A kind of data reconstruction method and device applied to database |
| CN111176887A (en) * | 2018-11-09 | 2020-05-19 | 上海擎感智能科技有限公司 | MySQL misoperation rollback method, equipment and system |
| CN111177141A (en) * | 2018-11-09 | 2020-05-19 | 上海擎感智能科技有限公司 | Method, equipment and system for recovering data by utilizing MySQL (MySQL structured query language) parallel copying |
| CN109656935A (en) * | 2018-11-23 | 2019-04-19 | 阿里巴巴集团控股有限公司 | The method and system of data readback for database |
| CN109656935B (en) * | 2018-11-23 | 2023-12-01 | 创新先进技术有限公司 | Method and system for data playback of a database |
| CN111913972A (en) * | 2019-05-10 | 2020-11-10 | 阿里巴巴集团控股有限公司 | Data processing method, device and equipment |
| CN110134653B (en) * | 2019-05-17 | 2021-09-07 | 杭州安恒信息技术股份有限公司 | Method and system for assisting database auditing by using logs |
| CN110134653A (en) * | 2019-05-17 | 2019-08-16 | 杭州安恒信息技术股份有限公司 | It is a kind of to utilize log auxiliary data base auditing method and system |
| WO2021012868A1 (en) * | 2019-07-22 | 2021-01-28 | 中兴通讯股份有限公司 | Transaction rollback method and apparatus, database, system, and computer storage medium |
| WO2021012932A1 (en) * | 2019-07-22 | 2021-01-28 | 中兴通讯股份有限公司 | Transaction rollback method and device, database, system, and computer storage medium |
| CN112256656A (en) * | 2019-07-22 | 2021-01-22 | 中兴通讯股份有限公司 | Transaction rollback method and device, database, system and computer storage medium |
| CN112256656B (en) * | 2019-07-22 | 2023-04-18 | 金篆信科有限责任公司 | Transaction rollback method and device, database, system and computer storage medium |
| CN110674151A (en) * | 2019-09-23 | 2020-01-10 | 四川长虹电器股份有限公司 | Method for supporting MySQL to quickly rollback data |
| CN110781036A (en) * | 2019-10-31 | 2020-02-11 | 北京东软望海科技有限公司 | Data recovery method and device, computer equipment and storage medium |
| CN113127261A (en) * | 2019-12-31 | 2021-07-16 | 浙江宇视科技有限公司 | File processing method, device, equipment and storage medium |
| CN112817798A (en) * | 2021-02-26 | 2021-05-18 | 北京车和家信息技术有限公司 | Data recovery method, device, medium and electronic equipment |
| CN113342841A (en) * | 2021-06-07 | 2021-09-03 | 北京许继电气有限公司 | Method and system for autonomously controllable database flashback deletion |
| CN117971854A (en) * | 2024-04-02 | 2024-05-03 | 天津南大通用数据技术股份有限公司 | Data flashback implementation method based on GBase8s database logical log |
| CN117971854B (en) * | 2024-04-02 | 2024-06-14 | 天津南大通用数据技术股份有限公司 | Data flashback implementation method based on GBase8s database logical log |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106547801A (en) | Database data flash back method and apparatus | |
| CN107590277B (en) | Data synchronization method and device, electronic equipment and storage medium | |
| US9183268B2 (en) | Partition level backup and restore of a massively parallel processing database | |
| CN104376091B (en) | The method and device that the data deleted in SQLite are recovered | |
| KR101643729B1 (en) | System and method of data managing for time base data backup, restoring, and mounting | |
| CN110716739B (en) | Code change information statistical method, system and readable storage medium | |
| CN103209153B (en) | Message treatment method, Apparatus and system | |
| TW201020824A (en) | Efficient transfer of deduplicated data | |
| US9268778B2 (en) | Efficient backup of virtual data | |
| CN107704604A (en) | A kind of information persistence method, server and computer-readable recording medium | |
| CN111125298A (en) | Method, equipment and storage medium for reconstructing NTFS file directory tree | |
| US20140331084A1 (en) | Information processing system and control method thereof | |
| CN111291235A (en) | Metadata storage method and device based on time sequence database | |
| CN103838780A (en) | Data recovery method of database and relevant device | |
| CN113094442A (en) | Full data synchronization method, device, equipment and medium | |
| US9483485B1 (en) | Restore database from backup system where full and incremental backups are performed simultaneously | |
| CN105159820A (en) | Transmission method and device of system log data | |
| CN111698330B (en) | Data recovery method and device of storage cluster and server | |
| CN110457348B (en) | Data processing method and device | |
| CN109101368A (en) | A kind of data processing method and device | |
| US20190163800A1 (en) | Updating a database | |
| CN106599006B (en) | Data recovery method and device | |
| CN106407385A (en) | Data management method and system, and equipment | |
| CN106469086B (en) | Event processing method and device | |
| CN115328876A (en) | Method and device for recording page operation log |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170329 |
|
| RJ01 | Rejection of invention patent application after publication |