CN108255867A - Unique mark processing method and processing device - Google Patents
Unique mark processing method and processing device Download PDFInfo
- Publication number
- CN108255867A CN108255867A CN201611248656.0A CN201611248656A CN108255867A CN 108255867 A CN108255867 A CN 108255867A CN 201611248656 A CN201611248656 A CN 201611248656A CN 108255867 A CN108255867 A CN 108255867A
- Authority
- CN
- China
- Prior art keywords
- mark
- unique mark
- unique
- generation
- unit
- 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/22—Indexing; Data structures therefor; Storage structures
Abstract
Present disclose provides a kind of unique mark processing method and processing devices, it may determine that and whether there is the unique mark identical with the unique mark of generation in mark table, if there is, then regenerate the unique mark of data, if there is no, it then determines that unique mark has uniqueness, realizes that the judgement by unique mark solves the Uniqueness of unique mark.It is used for storing the unique mark of generation since the disclosure has pre-established mark table in the database, therefore when the uniqueness for carrying out unique mark judges, it does not need to read from the value of major key, directly read from mark table, and the disclosure is in the comparison for carrying out unique mark, it does not need to lock major key, therefore the disclosure is applicable in the data of major key and is scattered in situation in multiple tables of data or in a tables of data simultaneously.
Description
Technical field
This disclosure relates to database technical field, more particularly, to a kind of unique mark processing method and processing device.
Background technology
Major key (primary key), also referred to as major key, it is one or more of table field, in the database,
Its value is used to uniquely identify a certain item record in tables of data.It, can be by the number of major key sometimes for performance or service impact
According to being scattered in multiple tables of data.
Since the value of major key randomly generates, it is thus possible to will appear the identical situation of the value of two major keys.When two
When the value of major key is identical, uniqueness has not just existed so that tables of data by quote major key obtain certain record when with regard to nothing
Method determines whether the record that it is obtained is correct.
Therefore, how to ensure the uniqueness of major key is still the technical barrier urgently to be resolved hurrily of this field one.Certainly, other
Unique mark is also likely to be present same problem.
Invention content
In view of the above problems, it is proposed that the disclosure overcomes the above problem in order to provide one kind or solves at least partly
The unique mark processing method of problem is stated, for ensureing the uniqueness of major key, specific technical solution is as follows:
The disclosure provides a kind of unique mark processing method, applied in database, the method includes:
Generate the unique mark of data;
Judge in mark table with the presence or absence of the unique mark identical with the unique mark of generation, the mark table is pre-
The tables of data first established in the database;
If it is present the step of returning to the unique mark for performing the generation data, if it does not exist, then determining described
Unique mark has uniqueness.
Optionally, before in mark table is judged with the presence or absence of the unique mark identical with the unique mark of generation,
The method further includes:
It will be in the unique mark write-in mark table of generation;
It is described to judge to whether there is the unique mark identical with the unique mark of generation in mark table, including:Judge
With the presence or absence of the unique mark of at least two generations in the mark table.
Optionally, the method further includes:
It, will be described in generation when the unique mark identical with the unique mark of generation is not present in the mark table
In the unique mark write-in mark table.
Optionally, the method further includes:
To not cleared up in preset time period present in the mark table by the unique mark of other data table references;
And/or the unique mark repeated in the mark table is cleared up.
Optionally, after in the unique mark write-in mark table by generation, the method further includes:
Receive the corresponding transaction rollback message of the unique mark;
Ignore the transaction rollback message.
A kind of unique mark processing unit, applied in database, described device includes:Identification generation unit, mark are sentenced
Disconnected unit and unit is uniquely determined,
The identification generation unit, for generating the unique mark of data;
The mark judging unit, for judging to identify in table with the presence or absence of identical only with the unique mark of generation
One mark, the mark table are the tables of data established in the database in advance;If it is present the triggering mark generation is single
Otherwise member uniquely determines unit described in triggering;
It is described to uniquely determine unit, for determining that the unique mark has uniqueness.
Optionally, described device further includes:
First writing unit, for it is described mark judging unit judge mark table in whether there is with described in generation only
Before the identical unique mark of one mark, by the unique mark write-in mark table of generation, the mark table is to exist in advance
The tables of data established in database;
The mark judging unit, specifically for judging to whether there is described at least two generations only in the mark table
One mark if it is present triggering the identification generation unit, otherwise uniquely determines unit described in triggering.
Optionally, described device further includes:
Second writing unit, for the unique mark identical with the unique mark of generation to be not present in the mark table
It, will be in the unique mark write-in mark table of generation during knowledge.
Optionally, described device further includes:First cleaning unit and/or the second cleaning unit,
The first cleaning unit, for not drawn in preset time period present in the mark table by other tables of data
Unique mark is cleared up;
The second cleaning unit, for clearing up the unique mark repeated in the mark table.
Optionally, described device further includes:Message reception units and message ignore unit,
The message reception units after in the unique mark write-in mark table by generation, connect
Receive the corresponding transaction rollback message of the unique mark;
The message ignores unit, for ignoring the transaction rollback message.
By above-mentioned technical proposal, the disclosure provide above-mentioned technical proposal may determine that in mark table whether there is and life
Into the identical unique mark of unique mark, if it is present the unique mark of regeneration data, if it does not exist, then determining
Unique mark has uniqueness, realizes that the judgement by unique mark solves the Uniqueness of unique mark.Due to this public affairs
It opens and has pre-established the unique mark that mark table is used for storing generation in the database, therefore in the uniqueness for carrying out unique mark
It during judgement, does not need to read from the value of major key, directly be read from mark table, and the disclosure is carrying out unique mark
Comparison when, do not need to lock major key, therefore the disclosure is applicable in the data of major key simultaneously and is scattered in multiple tables of data
Or the situation in a tables of data.
Above description is only the general introduction of disclosed technique scheme, in order to better understand the technological means of the disclosure,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects, features and advantages of the disclosure can
It is clearer and more comprehensible, below the special specific embodiment for lifting the disclosure.
Description of the drawings
By reading the detailed description of hereafter preferred embodiment, it is various other the advantages of and benefit it is common for this field
Technical staff will become clear.Attached drawing is only used for showing the purpose of preferred embodiment, and is not considered as to the disclosure
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows the flow chart of a kind of unique mark processing method that the exemplary embodiment of the disclosure provides;
Fig. 2 shows the flow charts of another unique mark processing method that the exemplary embodiment of the disclosure provides;
Fig. 3 shows the flow chart of another unique mark processing method that the exemplary embodiment of the disclosure provides;
Fig. 4 shows the structure diagram of a kind of unique mark processing unit that the exemplary embodiment of the disclosure provides;
Fig. 5 shows the structural representation of another unique mark processing unit that the example embodiments of the disclosure provide
Figure;
Fig. 6 shows the structural representation of another unique mark processing unit that the example embodiments of the disclosure provide
Figure.
Specific embodiment
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although the disclosure is shown in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
Completely it is communicated to those skilled in the art.
As shown in Figure 1, a kind of unique mark processing method that the exemplary embodiment of the disclosure provides, applied to database
In, this method can include:
S100, the unique mark for generating data;
Wherein, the unique mark is the value of major key.
Specifically, step S100 can be multiple batch datas generation it is multiple relative to unique mark, can also be each
Only generate a unique mark.
S200, judge to whether there is the unique mark identical with the unique mark of generation in mark table, the mark table is
The tables of data established in the database in advance;The step S100 is performed if it is present returning, if it does not exist, then performing
Step S300;
Specifically, step S200 can according to serializing isolation level judge mark table in whether there is with described in generation
The identical unique mark of unique mark is according to serializing isolation level.
Wherein, there are four types of the isolation levels of affairs, respectively:
Reading does not submit (Read uncommitted), reads to submit (Read committed), repeats to read (Repeatable
Read) and (Serializable) is serialized, wherein, serializing is highest Transaction service, and under the rank, affairs are suitable
Sequence performs, not only can be to avoid dirty reading, non-repeatable read, it is thus also avoided that mirage phantom is read.
The disclosure according to serializing isolation level by judging in mark table with the presence or absence of the unique mark with generation
Identical unique mark so that the judgement to each unique mark is all that sequence performs, and is not in thus two and judged
The situation that journey is performed simultaneously ensure that the accuracy of judgement.
It is understood that it is used for storing unique mark of generation since the disclosure has pre-established mark table in the database
Know, thus carry out unique mark uniqueness judge when, do not need to read from major key, directly from mark table reading be
It can.Therefore, it in the comparison for carrying out unique mark, does not need to lock major key, the disclosure is applicable in the data of major key simultaneously
It is scattered in the situation in multiple tables of data or in a tables of data.Further, the disclosure applies also for the public unique mark of cross-system
The situation of knowledge, such as:A systems and B system are all monitoring systems, but the unique mark of the monitoring object of the two cannot be identical, this
Open one kind that can be all stored in the unique mark used in the two systems in same mark table and perform the disclosure is unique
Identification processing method, so that the unique mark used in the two systems does not repeat mutually.
When identifying in table in the presence of the unique mark identical with the unique mark of generation, illustrate step S100 generations
The unique mark is occupied, and a unique mark can be regenerated with return to step S100 and continues sentencing for step S200
It is disconnected, until the unique mark identical with the unique mark of generation is not present in mark table.
S300, determine that the unique mark has uniqueness.
When determining that the unique mark identical with the unique mark of generation is not present in mark table, it may be determined that this is only
The uniqueness of one mark.
Specifically, the unique mark that the thread that a thread from performing practice can be used different performs the disclosure is handled
Method, in this way, the implementation procedure with practice is not interfere with each other by the unique mark processing method of the disclosure, when affairs need rollback
When, the disclosure can ignore rollback.
A kind of unique mark processing method that the exemplary embodiment of the disclosure provides, it can be determined that whether deposited in mark table
In the unique mark identical with the unique mark of generation, if it is present the unique mark of data is regenerated, if it does not,
It then determines that unique mark has uniqueness, realizes that the judgement by unique mark solves the Uniqueness of unique mark.By
Mark table has been pre-established in the database in the disclosure for storing the unique mark of generation, therefore is carrying out unique mark
It when uniqueness judges, does not need to read from the value of major key, directly be read from mark table, and the disclosure is carrying out only
It during the comparison of one mark, does not need to lock major key, therefore the disclosure is applicable in the data of major key simultaneously and is scattered in multiple numbers
According to the situation in table or in a tables of data.
In addition, the disclosure can by according to serializing isolation level judge mark table in whether there is with described in generation
The identical unique mark of unique mark so that the judgement to each unique mark is all that sequence performs, and is not in thus two
The situation that a deterministic process is performed simultaneously ensure that the accuracy of judgement.
As shown in Fig. 2, another unique mark processing method that the exemplary embodiment of the disclosure provides, applied to data
In library, this method can include:
S100, the unique mark for generating data;
Step S100 is identical with embodiment illustrated in fig. 1 step S100, repeats no more.
S110, the unique mark write-in of generation is identified in table, the mark table is to establish in the database in advance
Tables of data;
S210, judge with the presence or absence of the unique mark of at least two generations in the mark table, if it is present returning
Return step S100;If it does not exist, then perform step S300;
Step S210 is a kind of specific executive mode of step S200 shown in Fig. 1.
First mark table is written in unique mark by embodiment illustrated in fig. 2, is then judged in the mark table with the presence or absence of extremely
The unique mark of few two generations.
Optionally, the disclosure unique mark can be written in mark table, therefore appoint according to serializing isolation level
When inscribe, mark table is all deterministic (it is understood that a unique mark is written in parallel to there are two or more
When identifying in table, mark table can not determine its state.There may be various states, such as:A has been stored in and B has been stored in, A
It is stored in and B is not stored in, A is not stored in and B has been stored in, A is not stored in and B is not stored in).Due to it is any when inscribe, mark table all be tool
Have it is deterministic, can be with therefore when whether there is the judgement of the unique marks of at least two generations in being identified table
Improve the accuracy of judging result.
In practical applications, step S210 can be performed according to serializing isolation level mode, also cannot be according to sequence
Change isolation level mode to perform.
S300, determine that the unique mark has uniqueness.
A kind of unique mark processing method that the exemplary embodiment of the disclosure provides, the unique mark can be written
Into mark table, judge with the presence or absence of the unique mark of at least two generations in the mark table, if it is present regeneration
Into a unique mark;If it does not exist, then determining that the unique mark has uniqueness, the judgement by unique mark is realized
Solves the Uniqueness of unique mark.It is used for storing simultaneously as the disclosure has pre-established mark table in the database
The unique mark of generation, thus carry out unique mark uniqueness judge when, do not need to read from the value of major key, directly from
It identifies in table and reads, and the disclosure does not need to lock major key in the comparison for carrying out unique mark, therefore this
Data that are open while being applicable in major key are scattered in the situation in multiple tables of data or in a tables of data.
As shown in figure 3, another unique mark processing method that the exemplary embodiment of the disclosure provides, applied to data
In library, this method can include:
S100, the unique mark for generating data;
Step S100 is identical with embodiment illustrated in fig. 1 step S100, repeats no more.
S200, judge in mark table with the presence or absence of the unique mark identical with the unique mark of generation, the mark
Table is the tables of data established in the database in advance, if it is present return to step S100;If it does not exist, then perform step
S310;
S310, determine that the unique mark has uniqueness, and the unique mark of generation is written the mark table
In.
One of difference of embodiment illustrated in fig. 2 and embodiment illustrated in fig. 3 is:Embodiment illustrated in fig. 3 first determines whether to identify
With the presence or absence of the unique mark identical with the unique mark of generation in table, there is no the institutes with generation in the mark table
It, just will be in the unique mark of the generation write-in mark table when stating the identical unique mark of unique mark.It is and real shown in Fig. 2
Example is applied the unique mark of generation is written in mark table first;Then judge to whether there is at least two in the mark table
The unique mark of generation.
It in practical applications, can be according to serializing by the step in the unique mark of the generation write-in mark table
Isolation level mode performs, and cannot also be performed according to serializing isolation level mode.
On the basis of Fig. 2 or embodiment illustrated in fig. 3, at another unique mark of the exemplary embodiment offer of the disclosure
Reason method after the unique mark by generation is written in the mark table, can also include:
Receive the corresponding transaction rollback message of the unique mark;
Ignore the transaction rollback message.
It is understood that the atomicity based on affairs, although the unique mark of generation has uniqueness, when this is unique
When identifying corresponding affairs needs rollback, since the unique mark of the disclosure is stored in mark table, the disclosure can neglect
Slightly transaction rollback message, without rollback.It preferably, can be afterwards again in preset time period present in the mark table
It is not cleared up by the unique mark of data table reference.Specifically, periodically the unique mark in mark table can be carried out
Cleaning, thereby realizes offline cleaning, avoids and receive the cleaning that transaction rollback message just carries out unique mark every time, mitigates
System burden.
In addition, the unique mark processing method that the exemplary embodiment of the disclosure provides can also be to unique in mark table
Mark is cleared up, and manner of cleaning up includes but not limited to following manner:
A kind of manner of cleaning up is:It is identified in preset time period present in table not by unique mark of data table reference to described
Knowledge is cleared up.
Specifically, can periodically clear up the unique mark in mark table, offline cleaning is thereby realized,
It avoids and receives the cleaning that transaction rollback message just carries out unique mark every time, alleviate system burden.
Another manner of cleaning up is:The unique mark repeated in mark table is cleared up, so that in mark table only
One mark is different.
Corresponding with above method embodiment, the present invention also provides a kind of unique mark processing units.
As shown in figure 4, the exemplary embodiment of the disclosure provides a kind of unique mark processing unit, at the unique mark
It manages device to be applied in database, can include:Identification generation unit 11 identifies judging unit 12 and uniquely determines unit 13.
Identification generation unit 11, for generating the unique mark of data.
Judging unit 12 is identified, whether there is the unique mark identical with the unique mark of generation in table for judging to identify
Know, mark table is the tables of data established in the database in advance.If it is present triggering identification generation unit 11, is otherwise triggered
Uniquely determine unit 13.
Unit 13 is uniquely determined, for determining that unique mark has uniqueness.
As shown in figure 5, the exemplary embodiment of the disclosure provides another unique mark processing unit, on the basis of Fig. 4,
It can also include:First writing unit 14.
First writing unit 14, for whether there is unique mark with generation in the mark judgement mark table of judging unit 12
It is sensible with unique mark before, by the unique mark of generation write-in mark table, the mark table is in advance in the database
The tables of data of foundation.
The mark judging unit 12, specifically for judging in the mark table with the presence or absence of described at least two generations
Unique mark if it is present triggering the identification generation unit 11, otherwise uniquely determines unit 13 described in triggering.
As shown in fig. 6, the exemplary embodiment of the disclosure provides another unique mark processing unit, on the basis of Fig. 4,
It can also include:Second writing unit 17.
Second writing unit 17, in identifying table be not present the unique mark identical with the unique mark of generation when,
It will be in the unique mark write-in mark table of generation.
It can also include in unique mark processing unit shown in Fig. 5 or Fig. 6:Message reception units and message ignore list
Member.
Message reception units, for after the unique mark generated is written in mark table, it is corresponding to receive unique mark
Transaction rollback message.
Message ignores unit, for ignoring transaction rollback message.
In addition, the unique mark processing unit that the example embodiments of the above-mentioned disclosure provide can also include:First is clear
Unit and/or the second cleaning unit are managed,
First cleaning unit, for identifying in preset time period present in table not by the unique of other data table references
Mark is cleared up.
Second cleaning unit, for clearing up the unique mark repeated in mark table.
The unique mark processing unit includes processor and memory, and above-mentioned identification generation unit 11, mark judge single
Member 12 is used as program unit storage in memory with 13 grade of unit is uniquely determined, and storage is performed in memory by processor
Above procedure unit realize corresponding function.
Comprising kernel in processor, gone in memory to transfer corresponding program unit by kernel.Kernel can set one
Or more, judge in mark table with the presence or absence of the unique mark identical with the unique mark of generation by adjusting kernel parameter,
If it is present the unique mark of regeneration data, if it does not exist, then determining that unique mark has uniqueness, realization passes through
The judgement of unique mark solves the Uniqueness of unique mark.
Memory may include computer-readable medium in volatile memory, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM), memory includes at least one deposit
Store up chip.
By above-mentioned technical proposal, a kind of unique mark processing unit may determine that mark table disclosed in the embodiment of the present disclosure
In with the presence or absence of the unique mark identical with the unique mark of generation, if it is present the unique mark of regeneration data, if
It is not present, it is determined that unique mark has uniqueness, realizes that the judgement by unique mark solves the uniqueness of unique mark
Problem.Since the disclosure has pre-established mark table for storing the unique mark of generation in the database, carrying out only
It when the uniqueness of one mark judges, does not need to read from the value of major key, directly be read, and the disclosure from mark table
It in the comparison for carrying out unique mark, does not need to lock major key, therefore the disclosure is applicable in the data dispersion of major key simultaneously
Situation in multiple tables of data or in a tables of data.
Present invention also provides a kind of computer program products, first when being performed on data processing equipment, being adapted for carrying out
The program code of beginningization there are as below methods step:
Generate the unique mark of data;
Judge in mark table with the presence or absence of the unique mark identical with the unique mark of generation, the mark table is pre-
The tables of data first established in the database;
If it is present the step of returning to the unique mark for performing the generation data, if it does not exist, then determining described
Unique mark has uniqueness.
It should be understood by those skilled in the art that, embodiments herein can be provided as method, system or computer program
Product.Therefore, the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware can be used in the application
Apply the form of example.Moreover, the computer for wherein including computer usable program code in one or more can be used in the application
The computer program production that usable storage medium is implemented on (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The application is with reference to the flow according to the method for the embodiment of the present application, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that it can be realized by computer program instructions every first-class in flowchart and/or the block diagram
The combination of flow and/or box in journey and/or box and flowchart and/or the block diagram.These computer programs can be provided
The processor of all-purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that the instruction performed by computer or the processor of other programmable data processing devices is generated for real
The device of function specified in present one flow of flow chart or one box of multiple flows and/or block diagram or multiple boxes.
These computer program instructions, which may also be stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction generation being stored in the computer-readable memory includes referring to
Enable the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one box of block diagram or
The function of being specified in multiple boxes.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps are performed on calculation machine or other programmable devices to generate computer implemented processing, so as in computer or
The instruction offer performed on other programmable devices is used to implement in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, computing device includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include computer-readable medium in volatile memory, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer-readable instruction, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase transition internal memory (PRAM), static RAM (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), fast flash memory bank or other memory techniques, CD-ROM read-only memory (CD-ROM),
Digital versatile disc (DVD) or other optical storages, magnetic tape cassette, the storage of tape magnetic rigid disk or other magnetic storage apparatus
Or any other non-transmission medium, available for storing the information that can be accessed by a computing device.It defines, calculates according to herein
Machine readable medium does not include temporary computer readable media (transitory media), such as data-signal and carrier wave of modulation.
It these are only embodiments herein, be not limited to the application.To those skilled in the art,
The application can have various modifications and variations.All any modifications made within spirit herein and principle, equivalent replacement,
Improve etc., it should be included within the scope of claims hereof.
Claims (10)
1. a kind of unique mark processing method, which is characterized in that applied in database, the method includes:
Generate the unique mark of data;
Judge in mark table with the presence or absence of the unique mark identical with the unique mark of generation, the mark table is to exist in advance
The tables of data established in database;
If it is present the step of returning to the unique mark for performing the generation data, if it does not exist, then determining described unique
Mark has uniqueness.
2. according to the method described in claim 1, it is characterized in that, judge identify table in whether there is with described in generation only
Before the identical unique mark of one mark, the method further includes:
It will be in the unique mark write-in mark table of generation;
It is described to judge to whether there is the unique mark identical with the unique mark of generation in mark table, including:Described in judgement
It identifies in table with the presence or absence of the unique mark of at least two generations.
3. according to the method described in claim 1, it is characterized in that, the method further includes:
When the unique mark identical with the unique mark of generation is not present in the mark table, by the described unique of generation
In the mark write-in mark table.
4. according to the method in any one of claims 1 to 3, which is characterized in that the method further includes:
To not cleared up in preset time period present in the mark table by the unique mark of other data table references;
And/or the unique mark repeated in the mark table is cleared up.
5. the method according to any one of Claims 2 or 3, which is characterized in that in unique mark by generation
After knowing in the write-in mark table, the method further includes:
Receive the corresponding transaction rollback message of the unique mark;
Ignore the transaction rollback message.
6. a kind of unique mark processing unit, which is characterized in that applied in database, described device includes:Mark generation is single
Member identifies judging unit and uniquely determines unit,
The identification generation unit, for generating the unique mark of data;
The mark judging unit whether there is the unique mark identical with the unique mark of generation for judging to identify in table
Know, the mark table is the tables of data established in the database in advance;If it is present the identification generation unit is triggered, it is no
Then unit is uniquely determined described in triggering;
It is described to uniquely determine unit, for determining that the unique mark has uniqueness.
7. device according to claim 6, which is characterized in that described device further includes:
First writing unit, for whether there is unique mark with generation in the mark judging unit judgement mark table
Before sensible same unique mark, by the unique mark write-in mark table of generation, the mark table is in advance in data
The tables of data established in library;
The mark judging unit, specifically for judging in the mark table with the presence or absence of unique mark of at least two generations
Know, if it is present triggering the identification generation unit, otherwise uniquely determine unit described in triggering.
8. device according to claim 6, which is characterized in that described device further includes:
Second writing unit, for the unique mark identical with the unique mark of generation to be not present in the mark table
When, it will be in the unique mark write-in mark table of generation.
9. the device according to any one of claim 6 to 8, which is characterized in that described device further includes:First cleaning is single
Member and/or the second cleaning unit,
The first cleaning unit, for being identified in preset time period present in table not by other data table references to described
Unique mark is cleared up;
The second cleaning unit, for clearing up the unique mark repeated in the mark table.
10. device according to claim 7 or 8, which is characterized in that described device further includes:Message reception units and disappear
Breath ignores unit,
The message reception units after in the unique mark write-in mark table by generation, receive institute
State the corresponding transaction rollback message of unique mark;
The message ignores unit, for ignoring the transaction rollback message.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611248656.0A CN108255867A (en) | 2016-12-29 | 2016-12-29 | Unique mark processing method and processing device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611248656.0A CN108255867A (en) | 2016-12-29 | 2016-12-29 | Unique mark processing method and processing device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108255867A true CN108255867A (en) | 2018-07-06 |
Family
ID=62721403
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611248656.0A Pending CN108255867A (en) | 2016-12-29 | 2016-12-29 | Unique mark processing method and processing device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108255867A (en) |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102541963A (en) * | 2010-12-31 | 2012-07-04 | 北大方正集团有限公司 | Method and device for inquiring character identification |
CN104111937A (en) * | 2013-04-18 | 2014-10-22 | 中兴通讯股份有限公司 | Master database standby database and data consistency testing and repairing method and device of master database and standby database |
CN104268272A (en) * | 2014-10-14 | 2015-01-07 | 青岛海尔软件有限公司 | Method and device for checking uniqueness of data |
CN104462396A (en) * | 2014-12-10 | 2015-03-25 | 北京国双科技有限公司 | Method and device for handing character strings |
CN105868210A (en) * | 2015-01-21 | 2016-08-17 | 阿里巴巴集团控股有限公司 | Creating method and device of unique index in distributed database |
-
2016
- 2016-12-29 CN CN201611248656.0A patent/CN108255867A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102541963A (en) * | 2010-12-31 | 2012-07-04 | 北大方正集团有限公司 | Method and device for inquiring character identification |
CN104111937A (en) * | 2013-04-18 | 2014-10-22 | 中兴通讯股份有限公司 | Master database standby database and data consistency testing and repairing method and device of master database and standby database |
CN104268272A (en) * | 2014-10-14 | 2015-01-07 | 青岛海尔软件有限公司 | Method and device for checking uniqueness of data |
CN104462396A (en) * | 2014-12-10 | 2015-03-25 | 北京国双科技有限公司 | Method and device for handing character strings |
CN105868210A (en) * | 2015-01-21 | 2016-08-17 | 阿里巴巴集团控股有限公司 | Creating method and device of unique index in distributed database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
T'kindt et al. | Multicriteria scheduling: theory, models and algorithms | |
US9135071B2 (en) | Selecting processing techniques for a data flow task | |
US10585726B2 (en) | Parameter-sharing apparatus and method | |
CN109558237A (en) | A kind of task status management method and device | |
CN108829604A (en) | Method for generating test case and device based on vehicle control device | |
Lyu et al. | An empirical study of the impact of data splitting decisions on the performance of aiops solutions | |
CN108241531A (en) | A kind of method and apparatus for distributing resource for virtual machine in the cluster | |
CN108255628A (en) | A kind of data processing method and device | |
Quinton et al. | Evolution in dynamic software product lines: challenges and perspectives | |
US8135932B2 (en) | Initializing of a memory area | |
CN110675255A (en) | Method and apparatus for concurrently executing transactions in a blockchain | |
Sheu et al. | Invention principles and contradiction matrix for semiconductor manufacturing industry: chemical mechanical polishing | |
CN108255867A (en) | Unique mark processing method and processing device | |
CN106878365B (en) | data synchronization method and device | |
CN109388644A (en) | A kind of data-updating method and device | |
CN110019440A (en) | The processing method and processing device of data | |
CN111368362A (en) | Building model component protection method and system based on block chain | |
Corea et al. | A taxonomy of business rule organizing approaches in regard to business process compliance | |
CN108241620A (en) | The generation method and device of query script | |
US20210334704A1 (en) | Method and System for Operating a Technical Installation with an Optimal Model | |
CN109582396A (en) | A kind of task status processing method, device, system and storage medium | |
CN107256252A (en) | Third-party multidimensional data migration method and device | |
CN106648550A (en) | Method and device for executing tasks concurrently | |
US11855849B1 (en) | Artificial intelligence based self-organizing event-action management system for large-scale networks | |
CN111427863A (en) | Data migration method, device and equipment based on domain model |
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 | ||
CB02 | Change of applicant information |
Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
CB02 | Change of applicant information | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180706 |
|
RJ01 | Rejection of invention patent application after publication |