CN104881474B - A kind of generation method and system of affairs index set - Google Patents
A kind of generation method and system of affairs index set Download PDFInfo
- Publication number
- CN104881474B CN104881474B CN201510290998.8A CN201510290998A CN104881474B CN 104881474 B CN104881474 B CN 104881474B CN 201510290998 A CN201510290998 A CN 201510290998A CN 104881474 B CN104881474 B CN 104881474B
- Authority
- CN
- China
- Prior art keywords
- connection identifier
- affairs
- identifier
- unique mark
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is suitable for computer realm, provides a kind of generation method and system of affairs index set, described method includes following steps:Build connection identifier set and affairs index set;Sequence reading database operation note set obtains connection identifier, action type mark and the unique mark of database manipulation record;According to the connection identifier set, connection identifier, action type mark and unique mark indexes set to the affairs and the connection identifier set is updated.The embodiment of the present invention is by building a connection identifier set, and set and connection identifier set are indexed to affairs according to connection identifier set, connection identifier, action type mark and unique mark and updated into Mobile state, the corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of storage address of the database manipulation record under same affairs is realized, so as to establish the index of Transaction Identifier and the affairs Relational database operation note.
Description
Technical field
The invention belongs to computer realm more particularly to the generation methods and system of a kind of affairs index set.
Background technology
Database server usually externally provides service by network, and client application is by database server
Operational order is sent, network session is established with database server, and passes through this session and database server-side interacts,
The various services of database server offer are provided.It, can during client is by database server operating database
Maloperation can be carried out to database, for example the mistake of data is deleted, accidentally modification etc., user is often given in the generation of these maloperations
Huge loss is brought, especially in financial circles.
When finding to have carried out maloperation to database before client, need it is quick, accurate obtain it is related some or
(affairs are the database sequences of operation that database server defines, these operations are either complete to be done or complete for certain several affairs
It does not do, is an indivisible work unit.For example, in relational database, an affairs can be a SQL statement,
One group of SQL statement or entire program.) database manipulation sequence, and then according to the database manipulation sequence pair database carry out
The operations such as rollback, so that database recovery is to correct state.
In the prior art, it is by ergodic data library when finding to have carried out maloperation to database before client
Network message set between server and client either the transaction journal in database come obtain it is related some or it is a few
The database manipulation sequence of a affairs, since the database manipulation sequence of each affairs is in network message set or transaction journal
In random storage rule, obtain the Relational database sequence of operation process require a great deal of time, acquisition speed
Slowly, the requirement to database resume speed such as financial circles can not be met.
Invention content
The embodiment of the present invention provides a kind of generation method of affairs index, and the database manipulation for belonging to same affairs is recorded
It is recorded in subtransaction set corresponding with the Transaction Identifier of the affairs, database has been carried out before discovery client accidentally to grasp
When making, database resume speed can be wanted with meeting financial circles etc. with the database manipulation sequence of quick obtaining relevant issues
It asks.
The embodiment of the present invention is achieved in that a kind of generation method of affairs index set, and the method includes as follows
Step:
Sequence reading database operation note set obtains connection identifier, the action type mark of database manipulation record
And unique mark;
According to the connection identifier set, connection identifier, action type mark and unique mark to the affairs that build in advance
Index set and the connection identifier set are updated;
The connection identifier collection is combined into the mapping relations set of connection identifier and unique mark, records the thing having had begun
The connection identifier of business and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark
Know;
The affairs indexed set is combined into the mapping relations set of Transaction Identifier and subtransaction set, and the Transaction Identifier is unique
One affairs of mark, including at least connection identifier and unique mark, the subtransaction set sequence is recorded under same affairs
Database manipulation record storage address.
The embodiment of the present invention also provides a kind of generation system of affairs index set, the system comprises:
Information acquisition unit for sequence reading database operation note set, obtains the connection of database manipulation record
Mark, action type mark and unique mark;And
Updating unit, for according to the connection identifier set, connection identifier, action type mark and unique mark to pre-
The affairs index set first built and the connection identifier set are updated;
The connection identifier collection is combined into the mapping relations set of connection identifier and unique mark, records the thing having had begun
The connection identifier of business and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark
Know;
The affairs indexed set is combined into the mapping relations set of Transaction Identifier and subtransaction set, and the Transaction Identifier is unique
One affairs of mark, including at least connection identifier and unique mark, the subtransaction set sequence is recorded under same affairs
Database manipulation record storage address.
The embodiment of the present invention is by building a connection identifier set, and according to connection identifier set, connection identifier, operation
Type identification and unique mark index set and connection identifier set to affairs and are updated into Mobile state, realize under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of storage address of database manipulation record, so as to establish thing
Business mark and the index of the affairs Relational database operation note, maloperation has been carried out before discovery client to database
When, the database manipulation sequence for gathering quick obtaining relevant issues can be indexed by the affairs, to meet the logarithms such as financial circles
According to the requirement of library resume speed.
Description of the drawings
Fig. 1 be a kind of affairs indexed set symphysis provided in an embodiment of the present invention into method flow chart;
Fig. 2 is a kind of flow that affairs are indexed with set and connection identifier set and is updated provided in an embodiment of the present invention
Figure;
Fig. 3 is another stream that affairs are indexed with set and connection identifier set and is updated provided in an embodiment of the present invention
Cheng Tu;
Fig. 4 is a kind of structure diagram of the generation system of affairs index set provided in an embodiment of the present invention;
Fig. 5 is a kind of structure diagram of updating unit provided in an embodiment of the present invention;
Fig. 6 is the structure diagram of another updating unit provided in an embodiment of the present invention.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, it is right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
The embodiment of the present invention is updated affairs index set, realizes same according to the connection identifier set of structure
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of storage address of database manipulation record under affairs, from
And the index of Transaction Identifier and the affairs Relational database operation note is established, database is carried out before discovery client
During maloperation, the database manipulation sequence of set quick obtaining relevant issues can be indexed by the affairs, to meet financial circles
Deng the requirement to database resume speed.
Fig. 1 show a kind of affairs indexed set symphysis provided in an embodiment of the present invention into method flow, details are as follows:
In step S101, sequence reading database operation note set.
In embodiments of the present invention, all operations of database manipulation set of records ends (OperSet) recording needle to database
Historical information can be obtained by the transaction journal in analytical database, can also pass through analytical database server and client
The all-network message exchanged between end obtains.
In embodiments of the present invention, database manipulation record includes at least action type mark, connection identifier and operation letter
Breath.
In embodiments of the present invention, what action type mark showed to carry out database is what type of operation, is such as opened
Beginning, (Begin) is operated, insertion (Insert) operation, is updated (Update) operation, deletion (Delete) operates, submits (Commit)
Operation and rollback (RollBack) operation;Connection identifier, can be with for uniquely identifying the connection between client and server
By the internet protocol address (Server-IP) of server, port (Server-Port) and the internet protocol address of client
(Client-IP), port (Client-Port) is composed;Operation information includes table name, preceding mirror image or rear mirror image, value
Condition etc..
As one embodiment of the invention, the database manipulation set of records ends record action type is starts (Begin)
The database manipulation record of operation at this point, affairs start to start (Begin) operation, submits (Commit) operation and rollback
(RollBack) operation terminates.
As another embodiment of the present invention, the database manipulation set of records ends does not record action type to start
(Begin) the database manipulation record of operation.
In step s 102, judge in database manipulation set of records ends with the presence or absence of the database manipulation note that can be read
Record when judging result is yes, then enters step S103;When judging result is no, then flow terminates.
In step s 103, connection identifier, action type mark and the database manipulation note of database manipulation record are obtained
The unique mark of record.
In step S104, according to the connection identifier set, connection identifier, action type mark and unique mark to pre-
The affairs index set and connection identifier set first built is updated.
In embodiments of the present invention, the connection identifier collection is combined into the mapping relations set of connection identifier and unique mark,
Record the connection identifier of affairs having had begun and affairs corresponding with the connection identifier start or at the end of database
The unique mark of operation note.
In embodiments of the present invention, the action type of corresponding database manipulation record is identified as submission behaviour at the end of affairs
Work or rolling back action.
In embodiments of the present invention, unique mark can be data for uniquely identifying a data library operation note
One or its group in the time identifier of library operation note, the serial number of database manipulation record or random unique number
It closes.
In embodiments of the present invention, time identifier can be database manipulation time for actually occurring of record or
The time that database manipulation record is read, it will be understood that in order to reach time identifier unique mark a data library operation note
The purpose of record, the time identifier can be as accurate as microsecond even smaller unit, at this point, due to the affairs index ultimately generated
The Transaction Identifier of set includes the time identifier of database manipulation record, can accurately position thing by the time identifier
The time of origin of each affairs in business index set;Serial number can by construct a counter (Counter), counter
Initial count value is 0, often reads a data library operation note count value and adds 1, such as:The three data libraries behaviour that sequence is got
It notes down, respectively Begin operation notes, Insert operation notes and Update operation notes, then Begin operation notes correspond to
Serial number Counter be the corresponding serial number Counter of 1, Insert operation notes be the corresponding serial number of 2, Update operation notes
Counter is 3;Random unique number can be number, letter or number and the combination of letter, as long as ensureing each unique number
It does not repeat.
In embodiments of the present invention, the affairs indexed set is combined into the mapping relations collection of Transaction Identifier and subtransaction set
It closes, unique one affairs of mark of the Transaction Identifier, including at least connection identifier and the unique mark of database operation note,
The storage address of the database manipulation recorded under same affairs the record of the subtransaction set sequence.
In the present invention is implemented, storage address is to be directed toward the address information that database manipulation records in file, can be text
Part offset address (FileOffset);It is appreciated that when database manipulation record storage is in different files, in order to distinguish
Different storage files can also be the combination of file identification (FileID) and file offset address (FileOffset).
In embodiments of the present invention, the storage address record of the database manipulation record in subtransaction set under same affairs
The sequence that sequence is read for the sequence or database manipulation record of database manipulation generation.
In embodiments of the present invention, when database manipulation is recorded as the first data library operation note of some affairs
When, the Transaction Identifier of addition Current transaction in affairs index set;When database manipulation is recorded as non-the of some affairs
During the operation note of a data library, current database operation note is added in corresponding subtransaction set in affairs index set
Storage address.
In embodiments of the present invention, when database manipulation is recorded as the corresponding first data library behaviour of some connection identifier
When noting down, connection identifier and corresponding unique mark are added in connection identifier set;When database manipulation record it is non-a certain
The corresponding first data library operation note of a connection identifier, and the database manipulation be recorded as first of some affairs or
When person's the last item database manipulation records, the corresponding unique mark of connection identifier described in connection identifier set is updated to work as
The unique mark of preceding database manipulation record.
The embodiment of the present invention is by building a connection identifier set, and according to connection identifier set, connection identifier, operation
Type identification and unique mark index set and connection identifier set to affairs and are updated into Mobile state, realize Transaction Identifier and the thing
Business identifies the foundation of the storage address index of corresponding database manipulation record, realizes the database manipulation note under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of record, so as to establish Transaction Identifier and the thing
The index of business Relational database operation note, when finding to have carried out maloperation to database before client, can quickly obtain
The database manipulation sequence of relevant issues is taken, to meet the requirement to database resume speed such as financial circles.
As one embodiment of the invention, further included before step S101:
The step of building connection identifier set and affairs index set.
A kind of set is indexed to affairs and connection identifier set is updated Fig. 2 shows provided in an embodiment of the present invention
Flow, details are as follows:
When database manipulation set of records ends record action type is the database manipulation record for starting (Begin) operation,
Set and connection identifier are indexed to affairs according to the connection identifier set, connection identifier, action type mark and unique mark
Gathering the step of being updated is specially:
In step s 201, the action type for judging to obtain is identified whether to start to operate, when judging result is yes, expression
One new affairs starts, then enters step S202;When judging result is no, then S206 is entered step.
In step S202, a new Transaction Identifier is added in affairs index set, enters step S203.
In embodiments of the present invention, which includes at least above-mentioned connection identifier and unique mark, becomes thing
The Transaction Identifier part of one new instance objects of business index set.
As one embodiment of the invention, while adding a new Transaction Identifier in affairs index set, at this
The storage address of current database operation note is written in the corresponding subtransaction set of Transaction Identifier.Those skilled in the art can
With understanding, start to operate when the action type is identified as, only add a new Transaction Identifier in affairs index set, and
The position of the database manipulation record or database manipulation record is not written in the corresponding subtransaction set of the Transaction Identifier
Confidence ceases, and can equally achieve the object of the present invention.
In step S203, judge in connection identifier set with the presence or absence of obtain connection identifier, when judging result be it is yes,
Represent the database manipulation record be not with the relevant first data library operation note of the connection identifier, then enter step
S204;When judging result is no, it is the first data library operation relevant with the connection identifier to represent database manipulation record
Record, then enter step S205.
In step S204, unique mark corresponding with above-mentioned connection identifier in the connection identifier set is updated to work as
The unique mark of preceding database manipulation record.
It is corresponding in connection identifier set to add above-mentioned connection identifier and current database operation note in step S205
The unique mark of record.
In step S206, judge with the presence or absence of above-mentioned connection identifier in connection identifier set, when judging result is yes, table
Show before the database manipulation record database manipulation record relevant with above-mentioned connection identifier occurred, then entered step
Rapid S207, when judging result is no, represents before the database manipulation records, and not yet occurs relevant with above-mentioned connection identifier
Database manipulation records, i.e., records relevant affairs with the database manipulation and not yet start, which is recorded as mistake
Operation note, then enter step S101.
In step S207, judge that affairs index whether there is in gathering and include above-mentioned connection identifier and above-mentioned connection identifier
The Transaction Identifier of corresponding unique mark in connection identifier set when judging result is yes, represents that the database manipulation records
Relevant affairs have begun, but not yet terminate, then enter step S208;When judging result is no, the database manipulation is represented
It records corresponding affairs not yet to start, which is recorded as the operation note of mistake, then enters step S101.
In step S208, judge whether aforesaid operations type identification is to submit operation or rolling back action, when judgement is tied
Fruit is yes, represents that the database manipulation records corresponding affairs and terminates, then enters step S209;When judging result is no, expression
The database manipulation, which records corresponding affairs, not yet to be terminated, then enters step S210.
In step S209, by database manipulation record storage address write-in affairs index set in above-mentioned affairs mark
Know corresponding subtransaction set;Meanwhile unique mark corresponding with above-mentioned connection identifier in connection identifier set is updated to work as
Preceding database manipulation records unique mark.
In step S210, by database manipulation record storage location information write-in affairs index set in above-mentioned thing
Business identifies corresponding subtransaction set.
In the above-described embodiments, due to starting to operate when the action type obtained is identified as, submitting operation or rollback behaviour
When making, connection identifier set is added or updated, to ensure affairs that connection identifier set record had begun
Connection identifier and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark, and write
Enter the Transaction Identifier in affairs index set to include starting the connection mark of the database manipulation record of operation for action type mark
Know and unique mark, simultaneously as same connection identifier, putting only allow, there are an affairs, to work as database at the same time
The action type of operation note be identified as start operation when, by corresponding Transaction Identifier write-in affairs index set, work as database
The action type of operation note be identified as it is non-start operation when, by searching for connection identifier corresponding present in connection identifier with
Whether unique mark exists in affairs index set, and whether the database manipulation record for determining reading is to have begun but still
The relevant database manipulation record of unclosed affairs, so as to have begun but the relevant database behaviour of still unclosed affairs
The storage address noted down is written in the corresponding subtransaction set of Transaction Identifier of the affairs, realizes the data under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of library operation note, and then establish affairs mark
Know the index with the storage address of the affairs Relational database operation note, database is missed before discovery client
It, can be with the database manipulation sequence of quick obtaining relevant issues, to meet financial circles etc. to database resume speed during operation
It is required that.
Fig. 3 shows that another kind provided in an embodiment of the present invention indexes set to affairs and connection identifier set is updated
Flow, details are as follows:
It is to start the database manipulation note of (Begin) operation when the database manipulation set of records ends does not record action type
During record, according to the connection identifier set, connection identifier, action type mark and unique mark to the affairs index set and
The step of connection identifier set is updated be specially:
In step S301, the action type for judging to obtain identifies whether, to submit operation or rolling back action, to work as judgement
As a result it is yes, then enters step S302;When judging result is no, then S305 is entered step.
In step s 302, judge in connection identifier set with the presence or absence of obtain connection identifier, when judging result be it is yes,
Represent before the database manipulation record database manipulation record relevant with above-mentioned connection identifier occurred, then entered
Step S303;When judging result is no, represent before the database manipulation records not yet occur related to above-mentioned connection identifier
Database manipulation record, the database manipulation be recorded as mistake operation note, then enter step S101.
In step S303, judge in affairs index set with the presence or absence of including above-mentioned connection identifier and the connection identifier exists
The Transaction Identifier of corresponding unique mark in the connection identifier set if the determination result is YES, represents and the database manipulation
It records relevant affairs to have begun, but not yet terminate, then enters step S304, if judging result is no, represent in the data
Before the operation note of library, not yet occur recording with the relevant database manipulation of above-mentioned connection identifier, the affairs which answers
Not yet start, which is recorded as the operation note of mistake, then enters step S101.
In step s 304, Transaction Identifier described in the storage address write-in affairs index set by database manipulation record
Corresponding subtransaction set, meanwhile, unique mark corresponding with above-mentioned connection identifier in connection identifier set is updated to currently
Database manipulation records unique mark.
In step S305, judge to whether there is the connection identifier obtained in connection identifier set, if the determination result is YES,
Represent before the database manipulation record database manipulation record relevant with above-mentioned connection identifier occurred, then entered
Step S306;If judging result is no, represent before the database manipulation records not yet occur related to above-mentioned connection identifier
Database manipulation record, the database manipulation be recorded as under the connection identifier first database manipulation record, then enter step
Rapid S309.
In step S306, judge that affairs index whether there is in gathering and include above-mentioned connection identifier and above-mentioned connection identifier
The Transaction Identifier of corresponding unique mark in the connection identifier set if the determination result is YES, represents to grasp with the database
Relevant affairs of noting down have begun, but not yet terminate, then enter step S307;If judging result is no, the data are represented
Library operation note is the first data library operation note of relevant issues, then enters step S308.
In step S307, by above-mentioned Transaction Identifier in the storage address write-in affairs index set of database manipulation record
Corresponding subtransaction set.
In step S308, by above-mentioned Transaction Identifier in the storage address write-in affairs index set of database manipulation record
Corresponding subtransaction set, meanwhile, unique mark corresponding with the connection identifier in connection identifier set is updated to current number
According to the unique mark of library operation note.
In step S309, corresponding Transaction Identifier is recorded with above-mentioned database manipulation in affairs index set write-in and deposited
Address is stored up, meanwhile, the unique of above-mentioned connection identifier and corresponding current database operation note is written in connection identifier set
Mark.
In embodiments of the present invention, when the transaction types of acquisition are identified as rolling back action or submit operation, and connecting
When the connection identifier of acquisition is had existed in logo collection, by unique mark corresponding with above-mentioned connection identifier in connection identifier set
Knowledge is updated to current database operation note unique mark;When the transaction types mark of acquisition for rolling back action or does not submit behaviour
Make, and right in the connection identifier set there is no above-mentioned connection identifier and above-mentioned connection identifier is included in affairs index set
During the Transaction Identifier for the unique mark answered, above-mentioned connection identifier and corresponding unique mark are written in connection identifier set;When
In connection identifier set there is no obtain connection identifier, represent the database manipulation record before, not yet occur with it is above-mentioned
The relevant database manipulation record of connection identifier, is written above-mentioned connection identifier and corresponding unique mark in connection identifier set
Know, by aforesaid operations, mark is connect with the connection identifier for ensureing affairs that connection identifier set record had begun and with this
Know corresponding affairs start or at the end of database manipulation record unique mark, simultaneously as same connection identifier,
Putting at the same time only allows there are an affairs, by judging action type mark not to submit operation or rolling back action,
There is the connection identifier obtained in connection identifier set, and there is no include above-mentioned connection identifier and above-mentioned in affairs index set
Connection identifier in the connection identifier set during Transaction Identifier of corresponding unique mark, affairs index set write-in with it is upper
It states database manipulation and records corresponding Transaction Identifier, to ensure the Transaction Identifier in write-in affairs index set as some affairs
The connection identifier and unique mark of first data library operation note, further, by searching for right present in connection identifier
Whether the connection identifier answered and unique mark exist in affairs index set, determine reading database manipulation record whether
To have begun but still unclosed affairs relevant database manipulation record, so as to have begun but still unclosed affairs
The storage address of relevant database manipulation record is written in the corresponding subtransaction set of Transaction Identifier of the affairs, is realized same
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of storage address of database manipulation record under a affairs,
And then Transaction Identifier and the index of the storage address of the affairs Relational database operation note are established, it is right before client when finding
It, can be with the database manipulation sequence of quick obtaining relevant issues, to meet the logarithms such as financial circles when database has carried out maloperation
According to the requirement of library resume speed.
Fig. 4 shows a kind of structure of the generation system of affairs index set provided in an embodiment of the present invention, for the ease of
Illustrate, only show and the relevant part of the embodiment of the present invention.
The generation system of affairs index set includes information acquisition unit 100 and updating unit 200.
Information acquisition unit 100 for sequence reading database operation note set, obtains the company of database manipulation record
Connect mark, action type mark and unique mark.
In embodiments of the present invention, all operations of database manipulation set of records ends (OperSet) recording needle to database
Historical information can be obtained by the transaction journal in analytical database, can also pass through analytical database server and client
The all-network message exchanged between end obtains.
In embodiments of the present invention, database manipulation record includes at least action type mark, connection identifier and operation letter
Breath.
In embodiments of the present invention, what action type mark showed to carry out database is what type of operation, is such as opened
Beginning, (Begin) is operated, insertion (Insert) operation, is updated (Update) operation, deletion (Delete) operates, submits (Commit)
Operation and rollback (RollBack) operation;Connection identifier, can be with for uniquely identifying the connection between client and server
By the internet protocol address (Server-IP) of server, port (Server-Port) and the internet protocol address of client
(Client-IP), port (Client-Port) is composed;Operation information includes table name, preceding mirror image or rear mirror image, value
Condition etc..
As one embodiment of the invention, the database manipulation set of records ends record action type is starts (Begin)
The database manipulation record of operation at this point, affairs start to start (Begin) operation, submits (Commit) operation and rollback
(RollBack) operation terminates.
As another embodiment of the present invention, the database manipulation set of records ends does not record action type to start
(Begin) the database manipulation record of operation.
In embodiments of the present invention, the connection identifier collection is combined into the mapping relations set of connection identifier and unique mark,
Record the connection identifier of affairs having had begun and affairs corresponding with the connection identifier start or at the end of database
The unique mark of operation note.
In embodiments of the present invention, the action type of corresponding database manipulation record is identified as submission behaviour at the end of affairs
Work or rolling back action.
In embodiments of the present invention, unique mark can be data for uniquely identifying a data library operation note
One or its group in the time identifier of library operation note, the serial number of database manipulation record or random unique number
It closes.
In embodiments of the present invention, time identifier can be database manipulation time for actually occurring of record or
The time that database manipulation record is read, at this point, including in the Transaction Identifier gathered due to the affairs index ultimately generated
The time identifier of database manipulation record can accurately position each affairs in affairs index set by the time identifier
Time of origin;Serial number can be by constructing a counter (Counter), and the initial count value of counter is 0, is often read
Operation note count value in a data library adds 1, such as:The three data library operation notes that sequence is got, respectively Begin behaviour
It noting down, Insert operation notes and Update operation notes, then the corresponding serial number Counter of Begin operation notes is 1,
The corresponding serial number Counter of Insert operation notes is that the corresponding serial number Counter of 2, Update operation notes is 3;At random only
One number can be number, letter or number and the combination of letter, as long as ensureing that each unique number does not repeat.
In embodiments of the present invention, the affairs indexed set is combined into the mapping relations collection of Transaction Identifier and subtransaction set
It closes, initial sets are null set, and the Transaction Identifier uniquely identifies an affairs, are grasped including at least connection identifier and database
The unique mark noted down, the storage of the database manipulation recorded under same affairs the record of the subtransaction set sequence
Location.
In the present invention is implemented, storage address is to be directed toward the address information that database manipulation records in file, can be text
Part offset address (FileOffset);It is appreciated that when database manipulation record storage is in different files, in order to distinguish
Different storage files can also be the combination of file identification (FileID) and file offset address (FileOffset).
In embodiments of the present invention, the storage address record of the database manipulation record in subtransaction set under same affairs
The sequence that sequence is read for the sequence or database manipulation record of database manipulation generation.
Updating unit 200, for according to the connection identifier set, connection identifier, action type mark and unique mark
The affairs index set built in advance and the connection identifier set are updated;
In embodiments of the present invention, when database manipulation is recorded as the first data library operation note of some affairs
When, the Transaction Identifier of addition Current transaction in affairs index set;When database manipulation is recorded as non-the of some affairs
During the operation note of a data library, current database operation note is added in corresponding subtransaction set in affairs index set
Storage address.
In embodiments of the present invention, when database manipulation is recorded as the corresponding first data library behaviour of some connection identifier
When noting down, connection identifier and corresponding unique mark are added in connection identifier set;When database manipulation record it is non-a certain
The corresponding first data library operation note of a connection identifier, and the database manipulation be recorded as first of some affairs or
When person's the last item database manipulation records, the corresponding unique mark of connection identifier described in connection identifier set is updated to work as
The unique mark of preceding database manipulation record.
The embodiment of the present invention is by building a connection identifier set, and according to connection identifier set, connection identifier, operation
Type identification and unique mark index set and connection identifier set to affairs and are updated into Mobile state, realize Transaction Identifier and the thing
Business identifies the foundation of the storage address index of corresponding database manipulation record, realizes the database manipulation note under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of record, so as to establish Transaction Identifier and the thing
The index of business Relational database operation note, when finding to have carried out maloperation to database before client, can quickly obtain
The database manipulation sequence of relevant issues is taken, to meet the requirement to database resume speed such as financial circles.
As one embodiment of the invention, the generation system of affairs index set further includes initialization unit, for building
Connection identifier set and affairs index set.
Fig. 5 shows a kind of structure of updating unit provided in an embodiment of the present invention, for convenience of description, only shows and this
The relevant part of inventive embodiments.
When database manipulation set of records ends record action type is the database manipulation record for starting operation, the update
Unit 200 includes:
Transaction Identifier add module 211, for when the action type be identified as start operation when, affairs index gather
One new Transaction Identifier of middle addition;
Start to operate update module 212, be identified as working as the action type and start to operate, and the connection identifier collection
There are during the connection identifier in conjunction, unique mark corresponding with above-mentioned connection identifier in the connection identifier set is updated to
The unique mark of current database operation note;
Start to operate add module 213, be identified as working as the action type and start to operate, and the connection identifier collection
It is corresponding in connection identifier set to add above-mentioned connection identifier and current database behaviour when the connection identifier being not present in conjunction
The unique mark noted down;
First submits, rolling back action update module 214, and submission operation or rollback are identified as working as the action type
Operation there are the connection identifier in connection identifier set, exists in affairs index set and includes above-mentioned connection identifier and above-mentioned
Connection identifier is in connection identifier set during the Transaction Identifier of corresponding unique mark, storage address that database manipulation is recorded
Be written affairs index set in subtransaction set corresponding with above-mentioned Transaction Identifier, meanwhile, by connection identifier set with it is above-mentioned
The corresponding unique mark of connection identifier is updated to current database operation note unique mark;
First other operation writing modules 215, for work as action type mark for start to operate, submits operate or
Person's rolling back action there are the connection identifier in connection identifier set, exists in affairs index set and includes above-mentioned connection identifier
And above-mentioned connection identifier during the Transaction Identifier of corresponding unique mark, is deposited in connection identifier set by what database manipulation recorded
Store up subtransaction set corresponding with above-mentioned Transaction Identifier in location information write-in affairs index set.
In the above-described embodiments, due to starting to operate when the action type obtained is identified as, submitting operation or rollback behaviour
When making, connection identifier set is added or updated, to ensure affairs that connection identifier set record had begun
Connection identifier and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark, and write
Enter the Transaction Identifier in affairs index set to include starting the connection mark of the database manipulation record of operation for action type mark
Know and unique mark, simultaneously as same connection identifier, putting only allow, there are an affairs, to work as database at the same time
The action type of operation note be identified as start operation when, by corresponding Transaction Identifier write-in affairs index set, work as database
The action type of operation note be identified as it is non-start operation when, by searching for connection identifier corresponding present in connection identifier with
Whether unique mark exists in affairs index set, and whether the database manipulation record for determining reading is to have begun but still
The relevant database manipulation record of unclosed affairs, so as to have begun but the relevant database behaviour of still unclosed affairs
The storage address noted down is written in the corresponding subtransaction set of Transaction Identifier of the affairs, realizes the data under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of library operation note, and then establish affairs mark
Know the index with the storage address of the affairs Relational database operation note, database is missed before discovery client
It, can be with the database manipulation sequence of quick obtaining relevant issues, to meet financial circles etc. to database resume speed during operation
It is required that.
Fig. 6 shows the structure of another updating unit provided in an embodiment of the present invention, for convenience of description, only show with
The relevant part of the embodiment of the present invention.
When database manipulation set of records ends do not record action type be start operation database manipulation record when, it is described more
New unit 200 includes:
Second submits, rolling back action update module 221, and submission operation or rollback are identified as working as the action type
It operates, there are the connection identifier in connection identifier set, and exists in affairs index set and include the connection identifier and institute
Connection identifier is stated in the connection identifier set during Transaction Identifier of corresponding unique mark, by depositing for database manipulation record
Store up address write-in affairs index set described in the corresponding subtransaction set of Transaction Identifier, meanwhile, by connection identifier set with
The corresponding unique mark of the connection identifier is updated to current database operation note unique mark;
Second other operation writing modules 222, for working as the action type mark not to submit operation or rollback behaviour
Make, there are the connection identifier in the connection identifier set, and exist in affairs index set and include the connection mark
Know and during the Transaction Identifier of corresponding unique mark, database manipulation is remembered in the connection identifier set for the connection identifier
The corresponding subtransaction set of Transaction Identifier described in the storage address write-in affairs index set of record;
Other operation write-in, update modules 223, for working as the action type mark not to submit operation or rollback behaviour
Make, there are the connection identifier in the connection identifier set, and there is no include the connection in affairs index set
Mark and the connection identifier are in the connection identifier set during Transaction Identifier of corresponding unique mark, by database manipulation
The corresponding subtransaction set of Transaction Identifier described in the storage address write-in affairs index set of record, meanwhile, by connection identifier
Unique mark corresponding with the connection identifier is updated to the unique mark of current database operation note in set;
Other operation writing modules 224 of third, for working as the action type mark not to submit operation or rollback behaviour
When making, and the connection identifier being not present in the connection identifier set, index set write-in in affairs and grasped with the database
It notes down corresponding Transaction Identifier and storage address, meanwhile, the connection identifier and corresponding is written in connection identifier set
The unique mark of current database operation note.
In embodiments of the present invention, when the transaction types of acquisition are identified as rolling back action or submit operation, and connecting
When the connection identifier of acquisition is had existed in logo collection, by unique mark corresponding with above-mentioned connection identifier in connection identifier set
Knowledge is updated to current database operation note unique mark;When the transaction types mark of acquisition for rolling back action or does not submit behaviour
Make, and right in the connection identifier set there is no above-mentioned connection identifier and above-mentioned connection identifier is included in affairs index set
During the Transaction Identifier for the unique mark answered, above-mentioned connection identifier and corresponding unique mark are written in connection identifier set;When
In connection identifier set there is no obtain connection identifier, represent the database manipulation record before, not yet occur with it is above-mentioned
The relevant database manipulation record of connection identifier, is written above-mentioned connection identifier and corresponding unique mark in connection identifier set
Know, by aforesaid operations, mark is connect with the connection identifier for ensureing affairs that connection identifier set record had begun and with this
Know corresponding affairs start or at the end of database manipulation record unique mark, simultaneously as same connection identifier,
Putting at the same time only allows there are an affairs, by judging action type mark not to submit operation or rolling back action,
There is the connection identifier obtained in connection identifier set, and there is no include above-mentioned connection identifier and above-mentioned in affairs index set
Connection identifier in the connection identifier set during Transaction Identifier of corresponding unique mark, affairs index set write-in with it is upper
It states database manipulation and records corresponding Transaction Identifier, to ensure the Transaction Identifier in write-in affairs index set as some affairs
The connection identifier and unique mark of first data library operation note, further, by searching for right present in connection identifier
Whether the connection identifier answered and unique mark exist in affairs index set, determine reading database manipulation record whether
To have begun but still unclosed affairs relevant database manipulation record, so as to have begun but still unclosed affairs
The storage address of relevant database manipulation record is written in the corresponding subtransaction set of Transaction Identifier of the affairs, is realized same
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of storage address of database manipulation record under a affairs,
And then Transaction Identifier and the index of the storage address of the affairs Relational database operation note are established, it is right before client when finding
It, can be with the database manipulation sequence of quick obtaining relevant issues, to meet the logarithms such as financial circles when database has carried out maloperation
According to the requirement of library resume speed.
The embodiment of the present invention is by building a connection identifier set, and according to connection identifier set, connection identifier, operation
Type identification and unique mark index set and connection identifier set to affairs and are updated into Mobile state, realize Transaction Identifier and the thing
Business identifies the foundation of the storage address index of corresponding database manipulation record, realizes the database manipulation note under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of record, so as to establish Transaction Identifier and the thing
The index of business Relational database operation note, when finding to have carried out maloperation to database before client, can quickly obtain
The database manipulation sequence of relevant issues is taken, to meet the requirement to database resume speed such as financial circles.
When database manipulation set of records ends record action type is the database manipulation record for starting (Begin) operation,
During due to starting to operate when the action type of acquisition is identified as, submitting operation or rolling back action, connection identifier set is carried out
Addition or update, with the connection identifier that ensures affairs that connection identifier set record had begun and with the connection identifier pair
The affairs answered start or at the end of database manipulation record unique mark, and be written affairs index set in affairs mark
Know and include starting the connection identifier and unique mark of the database manipulation record of operation for action type mark, simultaneously as together
One connection identifier is put only allow there are an affairs at the same time, when the action type of database manipulation record is identified as
When starting operation, corresponding Transaction Identifier write-in affairs index is gathered, when the action type of database manipulation record is identified as
It is non-when starting operation, by searching for connection identifier corresponding present in connection identifier and unique mark whether in affairs indexed set
Exist in conjunction, whether the database manipulation record for determining reading is to have begun but the still unclosed relevant database of affairs
Operation note, so as to which the thing is written in the storage address that will be had begun but the relevant database manipulation of still unclosed affairs records
In the corresponding subtransaction set of Transaction Identifier of business, realize that the storage address of the database manipulation record under same affairs corresponds to
The subtransaction set being recorded in corresponding to same Transaction Identifier, and then establish Transaction Identifier and the affairs Relational database and operate
The index of the storage address of record, can be with quick obtaining correlation when finding to have carried out maloperation to database before client
The database manipulation sequence of affairs, to meet the requirement to database resume speed such as financial circles.
It is to start the database manipulation note of (Begin) operation when the database manipulation set of records ends does not record action type
During record, when the transaction types of acquisition are identified as rolling back action or submit operation, and have existed and obtain in connection identifier set
During the connection identifier taken, unique mark corresponding with above-mentioned connection identifier in connection identifier set is updated to current database behaviour
It notes down unique mark;When the transaction types mark of acquisition for rolling back action or does not submit operation, and in affairs index set
There is no the affairs of the corresponding unique mark in the connection identifier set including above-mentioned connection identifier and above-mentioned connection identifier
During mark, above-mentioned connection identifier and corresponding unique mark are written in connection identifier set;When not deposited in connection identifier set
It in the connection identifier of acquisition, represents before the database manipulation records, not yet occurs and the relevant data of above-mentioned connection identifier
Above-mentioned connection identifier and corresponding unique mark is written in library operation note in connection identifier set, by aforesaid operations, to protect
The connection identifier of affairs and affairs corresponding with the connection identifier that card connection identifier set record has had begun start or
At the end of database manipulation record unique mark, simultaneously as same connection identifier, putting only allow to deposit at the same time
In an affairs, by judging that action type is identified not to submit operation or rolling back action, exist in connection identifier set and obtain
The connection identifier taken, and there is no include above-mentioned connection identifier and above-mentioned connection identifier in the connection mark in affairs index set
When knowing the Transaction Identifier of corresponding unique mark in set, it is corresponding with above-mentioned database manipulation record to index set write-in in affairs
Transaction Identifier, using ensure write-in affairs index set in Transaction Identifier as some affairs the first data library operation note
Connection identifier and unique mark, further, by searching for connection identifier corresponding present in connection identifier and unique mark
Know and whether exist in affairs index set, whether the database manipulation record for determining reading is to have begun but not yet terminate
Affairs relevant database manipulation record, so as to have begun but the relevant database manipulation record of still unclosed affairs
Storage address be written in the corresponding subtransaction set of Transaction Identifier of the affairs, realize the database manipulation under same affairs
The corresponding subtransaction set being recorded in corresponding to same Transaction Identifier of the storage address of record, and then Transaction Identifier is established with being somebody's turn to do
The index of the storage address of affairs Relational database operation note has carried out maloperation before discovery client to database
When, it can be with the database manipulation sequence of quick obtaining relevant issues, to meet the requirement to database resume speed such as financial circles.
It should be noted that:The affairs index generation system that above-described embodiment provides only is illustrated with the division of above-mentioned each function module
Illustrate, in practical application, can be completed, i.e., indexed affairs by different function modules as needed and by above-mentioned function distribution
The internal structure of generation system is divided into different function modules, to complete all or part of function described above.In addition,
The affairs index generation system that above-described embodiment provides belongs to same design with affairs index generation method embodiment, specific real
Existing process refers to embodiment of the method, and which is not described herein again.
It will appreciated by the skilled person that all or part of step in realization above-described embodiment method is can
To instruct relevant hardware by program come what is completed, the program can be stored in a computer read/write memory medium
In, without loss of generality, computer read/write memory medium can include computer storage media and communication media.Computer stores
Medium is included for any of the information such as storage computer-readable instruction, data structure, program module or other data
The volatile and non-volatile of method or technique realization, removable and irremovable medium.Computer storage media include RAM,
ROM, EPROM, EEPROM, flash memory or other solid storage mediums, CD-ROM, DVD or other optical storage mediums, cassette,
Tape, disk or other magnetic storage apparatus.Certainly, skilled person will appreciate that computer storage media be not limited to it is above-mentioned
It is several.
One of ordinary skill in the art will appreciate that hardware can be passed through by realizing all or part of step of above-described embodiment
It completes, relevant hardware can also be instructed to complete by program, which can be stored in a kind of computer-readable storage
In medium, storage medium mentioned above can be read-only memory, disk or CD etc..
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all essences in the present invention
All any modification, equivalent and improvement made within refreshing and principle etc., should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of generation method of affairs index set, which is characterized in that described method includes following steps:
Sequence reading database operation note set, obtain database manipulation record connection identifier, action type mark and only
One mark;
Set and connection identifier are indexed to the affairs built in advance according to the connection identifier, action type mark and unique mark
Set is updated;
The connection identifier collection is combined into the mapping relations set of connection identifier and unique mark, the affairs that record has had begun
Connection identifier and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark;
The affairs indexed set is combined into the mapping relations set of Transaction Identifier and subtransaction set, and the Transaction Identifier is uniquely marked
Know an affairs, including at least connection identifier and the unique mark of current database operation note, the subtransaction set sequence
Record under same affairs database manipulation record storage address.
2. the generation method of affairs index set as described in claim 1, which is characterized in that in the sequence reading database
Before the step of operation note set, connection identifier, action type mark and unique mark that acquisition database manipulation records, also
Including:
Build connection identifier set and affairs index set.
3. the generation method of affairs index set as described in claim 1, which is characterized in that the unique mark is database
An or combination in the time identifier of operation note, the serial number of database manipulation record or random unique number.
4. the generation method of affairs index set as described in claim 1, which is characterized in that when database manipulation set of records ends
When record action type is the database manipulation record for starting operation, according to the connection identifier set, connection identifier, operation class
Type identify and unique mark to the affairs index set and the connection identifier set be updated the step of be specially:
When the action type, which is identified as, starts operation, a new Transaction Identifier is added in affairs index set;
Start to operate when the action type is identified as, and there are during the connection identifier in the connection identifier set, by institute
State unique mark that unique mark corresponding with above-mentioned connection identifier in connection identifier set is updated to current database operation note
Know;
When starting to operate when the action type is identified as, and the connection identifier being not present in the connection identifier set,
The corresponding unique mark for adding above-mentioned connection identifier and current database operation note in connection identifier set;
When the action type is identified as submission operation or rolling back action, there are the connection identifier in connection identifier set,
Exist in affairs index set and include above-mentioned connection identifier and above-mentioned connection identifier corresponding unique mark in connection identifier set
It, will be corresponding with above-mentioned Transaction Identifier in the storage address write-in affairs index set of database manipulation record during the Transaction Identifier of knowledge
Subtransaction set, meanwhile, unique mark corresponding with above-mentioned connection identifier in connection identifier set is updated to current data
Library operation note unique mark;
When action type mark does not operate or rolling back action to start to operate, submit, there are institutes in connection identifier set
It states connection identifier, exists in affairs index set and include above-mentioned connection identifier and above-mentioned connection identifier is right in connection identifier set
During the Transaction Identifier for the unique mark answered, by database manipulation record storage location information write-in affairs index set in it is upper
State the corresponding subtransaction set of Transaction Identifier.
5. the generation method of affairs index set as described in claim 1, which is characterized in that when database manipulation set of records ends
Do not record action type be start operation database manipulation record when, according to the connection identifier set, connection identifier, operation
Type identification and unique mark index the affairs set and the step of connection identifier set is updated is specially:
When the action type is identified as submission operation or rolling back action, there are the connection identifier in connection identifier set,
It is and corresponding in the connection identifier set in the presence of the connection identifier and the connection identifier is included in affairs index set
During the Transaction Identifier of unique mark, the storage address write-in affairs that first database manipulation is recorded index affairs described in set
Corresponding subtransaction set is identified, meanwhile, unique mark corresponding with the connection identifier in connection identifier set is updated to
Current database operation note unique mark;
When action type mark is not submission operation or rolling back action, there are the connections in the connection identifier set
Mark, and exist in affairs index set and include the connection identifier and the connection identifier in the connection identifier set
In corresponding unique mark Transaction Identifier when, by database manipulation record storage address write-in affairs index set described in
The corresponding subtransaction set of Transaction Identifier;
When action type mark is not submission operation or rolling back action, there are the connections in the connection identifier set
Mark, and there is no include the connection identifier and the connection identifier in the connection identifier collection in affairs index set
In conjunction during the Transaction Identifier of corresponding unique mark, by institute in the storage address write-in affairs index set of database manipulation record
The corresponding subtransaction set of Transaction Identifier is stated, meanwhile, by unique mark corresponding with the connection identifier in connection identifier set
It is updated to the unique mark of current database operation note;
When action type mark is not to submit operation or rolling back action, and there is no described in the connection identifier set
During connection identifier, index set write-in in affairs and record corresponding Transaction Identifier and storage with the first database manipulation
Location, meanwhile, the unique mark of the connection identifier and corresponding current database operation note is written in connection identifier set.
6. a kind of generation system of affairs index set, which is characterized in that the system comprises:
Information acquisition unit, for sequence reading database operation note set, obtain database manipulation record connection identifier,
Action type identifies and unique mark;And
Updating unit, for according to the connection identifier set, connection identifier, action type mark and unique mark to advance structure
The affairs index set built and the connection identifier set are updated;
The connection identifier collection is combined into the mapping relations set of connection identifier and unique mark, the affairs that record has had begun
Connection identifier and affairs corresponding with the connection identifier start or at the end of database manipulation record unique mark;
The affairs indexed set is combined into the mapping relations set of Transaction Identifier and subtransaction set, and the Transaction Identifier is uniquely marked
Know an affairs, including at least connection identifier and the unique mark of current database operation note, the subtransaction set sequence
Record under same affairs database manipulation record storage address.
7. the generation system of affairs index set as claimed in claim 6, which is characterized in that the system also includes:
Initialization unit, for building connection identifier set and affairs index set.
8. the generation system of affairs index set as claimed in claim 6, which is characterized in that the unique mark is database
An or combination in the time identifier of operation note, the serial number of database manipulation record or random unique number.
9. the generation system of affairs index set as claimed in claim 6, which is characterized in that when database manipulation set of records ends
When record action type is the database manipulation record for starting operation, the updating unit includes:
Transaction Identifier add module, for when the action type be identified as start operation when, affairs index set in add
One new Transaction Identifier;
Start to operate update module, be identified as working as the action type and start to operate, and deposit in the connection identifier set
In the connection identifier, unique mark corresponding with above-mentioned connection identifier in the connection identifier set is updated to current number
According to the unique mark of library operation note;
Start to operate add module, be identified as working as the action type and start to operate, and in the connection identifier set not
There are during the connection identifier, the above-mentioned connection identifier of corresponding addition and current database operation note in connection identifier set
Unique mark;
First submits, rolling back action update module, is identified as submission operation or rolling back action for working as the action type, even
It connects there are the connection identifier in logo collection, affairs index exists in gathering includes above-mentioned connection identifier and above-mentioned connection identifier
In connection identifier set during the Transaction Identifier of corresponding unique mark, affairs are written into the storage address of database manipulation record
Index set in subtransaction set corresponding with above-mentioned Transaction Identifier, meanwhile, by connection identifier set with above-mentioned connection identifier
Corresponding unique mark is updated to current database operation note unique mark;
First other operation writing modules, for working as the action type mark not to start to operate, submitting operation or rollback
Operation there are the connection identifier in connection identifier set, exists in affairs index set and includes above-mentioned connection identifier and above-mentioned
Connection identifier is in connection identifier set during the Transaction Identifier of corresponding unique mark, storage location that database manipulation is recorded
Subtransaction set corresponding with above-mentioned Transaction Identifier in information write-in affairs index set.
10. the generation system of affairs index set as claimed in claim 6, which is characterized in that when database manipulation record set
Close do not record action type be start operation database manipulation record when, the updating unit includes:
Second submits, rolling back action update module, is identified as submission operation or rolling back action for working as the action type, even
It connects there are the connection identifier in logo collection, and exists in affairs index set and include the connection identifier and the connection mark
Know the storage that during Transaction Identifier of corresponding unique mark, first database manipulation is recorded in the connection identifier set
Location write-in affairs index set described in the corresponding subtransaction set of Transaction Identifier, meanwhile, by connection identifier set with it is described
The corresponding unique mark of connection identifier is updated to current database operation note unique mark;
Second other operation writing modules, it is described for working as the action type mark not to submit operation or rolling back action
Exist there are the connection identifier in connection identifier set, and in affairs index set and include the connection identifier and described
Connection identifier is in the connection identifier set during Transaction Identifier of corresponding unique mark, storage that database manipulation is recorded
The corresponding subtransaction set of Transaction Identifier described in address write-in affairs index set;
Other operation write-in, update modules, it is described for working as the action type mark not to submit operation or rolling back action
There are the connection identifier in connection identifier set, and there is no include the connection identifier and institute in affairs index set
Connection identifier is stated in the connection identifier set during Transaction Identifier of corresponding unique mark, by depositing for database manipulation record
Store up address write-in affairs index set described in the corresponding subtransaction set of Transaction Identifier, meanwhile, by connection identifier set with
The corresponding unique mark of the connection identifier is updated to the unique mark of current database operation note;
Other operation writing modules of third, for working as the action type mark not to submit operation or rolling back action, and institute
It states in connection identifier set there is no during the connection identifier, set write-in and the first database manipulation note is indexed in affairs
Corresponding Transaction Identifier and storage address are recorded, meanwhile, the connection identifier and corresponding current is written in connection identifier set
The unique mark of database manipulation record.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510290998.8A CN104881474B (en) | 2015-05-30 | 2015-05-30 | A kind of generation method and system of affairs index set |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510290998.8A CN104881474B (en) | 2015-05-30 | 2015-05-30 | A kind of generation method and system of affairs index set |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104881474A CN104881474A (en) | 2015-09-02 |
CN104881474B true CN104881474B (en) | 2018-07-06 |
Family
ID=53948967
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510290998.8A Active CN104881474B (en) | 2015-05-30 | 2015-05-30 | A kind of generation method and system of affairs index set |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104881474B (en) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
KR102593362B1 (en) * | 2016-04-27 | 2023-10-25 | 에스케이하이닉스 주식회사 | Memory system and operating method of memory system |
CN106933974B (en) * | 2017-02-14 | 2020-02-14 | 浙江大华技术股份有限公司 | Video file index information construction and query method and device |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4914569A (en) * | 1987-10-30 | 1990-04-03 | International Business Machines Corporation | Method for concurrent record access, insertion, deletion and alteration using an index tree |
CN101202792A (en) * | 2006-11-29 | 2008-06-18 | Sap股份公司 | Method and apparatus for processing messages based on relationship between sender and recipient |
CN104252501A (en) * | 2013-06-29 | 2014-12-31 | 华为技术有限公司 | Computing equipment and method for executing database operating command |
-
2015
- 2015-05-30 CN CN201510290998.8A patent/CN104881474B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4914569A (en) * | 1987-10-30 | 1990-04-03 | International Business Machines Corporation | Method for concurrent record access, insertion, deletion and alteration using an index tree |
CN101202792A (en) * | 2006-11-29 | 2008-06-18 | Sap股份公司 | Method and apparatus for processing messages based on relationship between sender and recipient |
CN104252501A (en) * | 2013-06-29 | 2014-12-31 | 华为技术有限公司 | Computing equipment and method for executing database operating command |
Also Published As
Publication number | Publication date |
---|---|
CN104881474A (en) | 2015-09-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7805439B2 (en) | Method and apparatus for selecting data records from versioned data | |
CN104391725B (en) | Page display method and page presentation device | |
CN104715041B (en) | A kind of database restoring method and system | |
WO2020093808A1 (en) | Method and apparatus for constructing merkle trees, and method and apparatus for simplified payment verification | |
CN103262043B (en) | The method and system of the meticulous recovery of performing database from differential backup | |
CN109033186A (en) | Data consistency detection, device, storage medium and electronic equipment | |
US20080304769A1 (en) | Common Image Format File Image Extraction | |
CN102193970A (en) | Metadata-aware search engine | |
CN100465949C (en) | System and method for identifying and storing table changes | |
WO2020093809A1 (en) | Method and device for reading blockchain data | |
CN109522290A (en) | A kind of HBase data block restores and data record extraction method | |
CN104881474B (en) | A kind of generation method and system of affairs index set | |
CN107832448A (en) | Database operation method, device and equipment | |
JP3663770B2 (en) | Information processing apparatus and method | |
CN106528830B (en) | A kind of method and apparatus for restoring file index catalogue | |
CN115048435A (en) | Intelligent database storage method and system | |
CN110647421B (en) | Database processing method, device and system and electronic equipment | |
CN106980685B (en) | Data processing method and data processing device | |
WO2016101528A1 (en) | Method and device for processing data in memory database | |
CN115883687A (en) | Flow playback method and device, electronic equipment and storage medium | |
Kondam | Comparing SSD forensics with HDD forensics | |
CN115408474B (en) | Block chain mass data storage certificate system and method for multi-source database | |
JP2007141089A (en) | Content storage management system, content storage management method and content storage management program | |
CN115994172B (en) | Method, device, equipment and medium for determining service access relation | |
CN113127494B (en) | Method and device for updating knowledge graph |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
EXSB | Decision made by sipo to initiate substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |