CN112445800A - Method and system for generating data serial number and electronic equipment - Google Patents
Method and system for generating data serial number and electronic equipment Download PDFInfo
- Publication number
- CN112445800A CN112445800A CN202011310653.1A CN202011310653A CN112445800A CN 112445800 A CN112445800 A CN 112445800A CN 202011310653 A CN202011310653 A CN 202011310653A CN 112445800 A CN112445800 A CN 112445800A
- Authority
- CN
- China
- Prior art keywords
- data
- piece
- serial number
- filled
- sequence
- 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
- 238000000034 method Methods 0.000 title claims abstract description 28
- 230000008878 coupling Effects 0.000 abstract description 9
- 238000010168 coupling process Methods 0.000 abstract description 9
- 238000005859 coupling reaction Methods 0.000 abstract description 9
- 230000009286 beneficial effect Effects 0.000 description 7
- 238000011161 development Methods 0.000 description 4
- 238000004590 computer program Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 229910002056 binary alloy Inorganic materials 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000010485 coping Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005429 filling process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06F16/2228—Indexing structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method, a system and electronic equipment for generating a data serial number, which are characterized in that host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of the data serial number corresponding to each piece of data is ensured, repeated data serial numbers cannot occur, and then higher coupling degree between the data serial numbers and the data is ensured.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and a system for generating a data serial number, and an electronic device.
Background
The internet plus is a new state developed by the internet under the promotion of innovation 2.0 (innovation form of information era and knowledge society), and simply speaking, the internet plus is the internet plus traditional industry, and the internet and the traditional industry are fused by using information and an internet platform along with the development of scientific technology, and a new development opportunity is created by using the advantages and the characteristics of the internet. The internet + optimizes, upgrades and transforms the traditional industry through the advantages of the internet + and enables the traditional industry to adapt to new development, thereby finally promoting the society to continuously develop forward.
In the large environment of "internet +", a backend system in each IT support field performs processing such as micro-servization, docker-ization, and clouding to improve the capability of coping with the development of application well-jet business, and accordingly the first problem to be solved is the problem of setting a unique serial number for each data, and at present, the serial number of each data is generally generated in several ways, specifically:
1) the serial number of each datum is generated based on the database, but when a cloud system frequently accesses the database, the performance of the database is reduced, even a fault occurs, the database is used as a single node, and therefore when the database fails, the whole system cannot be used;
2) the serial number of each data is generated based on a UUID (the UUID is an abbreviation of a Universal unique identifier, is a standard for software construction, and is also a part of the field of distributed computing environment organized by the open software foundation), but the generated serial number of each data is unordered, the index association efficiency is low, and the data is unreadable;
3) the serial number of each data is generated using a millisecond time point, a random number, or the like, but in the case of high concurrency, a repeated serial number occurs, resulting in a decrease in the degree of coupling between the serial number and the data.
Therefore, how to ensure the uniqueness of the data serial number, the high index association efficiency of the data serial number and not to cause the performance reduction of the database is an urgent technical problem to be solved in the industry.
Disclosure of Invention
The invention provides a method, a system and electronic equipment for generating a data serial number, aiming at the defects of the prior art.
The technical scheme of the method for generating the data serial number is as follows:
filling host deployment information of each host for acquiring data to a first preset position of each field to be filled with the same number of bits;
and generating a sequence number corresponding to each piece of acquired data according to the time sequence, and filling the sequence number to a second preset position of a field to be filled corresponding to each piece of data to obtain a data serial number corresponding to each piece of data.
The method for generating the data serial number has the following beneficial effects:
the host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
On the basis of the above scheme, the method for generating a data serial number of the present invention may be further improved as follows.
Further, before obtaining the data serial number corresponding to each piece of data, the method further includes:
and generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of a field to be filled corresponding to each piece of data.
The beneficial effect of adopting the further scheme is that: the sequence number corresponding to each piece of data is added at the third preset position of the field to be filled corresponding to each piece of data, so that the uniqueness of the data serial number corresponding to each piece of data is further ensured.
Further, the generating a sequence number corresponding to each piece of data includes:
and at each millisecond-level time point, assigning a sequence number to each piece of data acquired in the millisecond-level time point in an optimistic lock mode, wherein the sequence numbers assigned in the millisecond-level time points are related or unrelated in sequence.
The beneficial effect of adopting the further scheme is that: each piece of data acquired at each same millisecond time point is guaranteed to have different sequence numbers, and uniqueness of the data serial number corresponding to each piece of data is further guaranteed.
Further, the host deployment information includes a machine room identification code and a host identification code.
The technical scheme of the system for generating the data serial number comprises the following steps:
the device comprises a first filling module and a second filling module;
the first filling module is used for filling the host deployment information of each host used for acquiring data to a first preset position of each field to be filled with the same number of bits;
the second filling module is used for generating a sequence number corresponding to each piece of acquired data according to a time sequence, and filling the sequence number to a second preset position of a field to be filled corresponding to each piece of data to obtain a data serial number corresponding to each piece of data.
The beneficial effects of the generation system of the data serial number are as follows:
the host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
On the basis of the above scheme, the generation system of the data serial number of the present invention can be further improved as follows.
Further, the system also comprises a third filling module, wherein the third filling module is used for: and generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of a field to be filled corresponding to each piece of data.
The beneficial effect of adopting the further scheme is that: the sequence number corresponding to each piece of data is added at the third preset position of the field to be filled corresponding to each piece of data, so that the uniqueness of the data serial number corresponding to each piece of data is further ensured.
Further, the third padding module is specifically configured to assign a sequence number to each piece of data acquired at each millisecond-level time point in an optimistic lock manner, where the sequence numbers assigned at each millisecond-level time point are related or unrelated in sequence.
The beneficial effect of adopting the further scheme is that: each piece of data acquired at each same millisecond time point is guaranteed to have different sequence numbers, and uniqueness of the data serial number corresponding to each piece of data is further guaranteed.
Further, the host deployment information includes a machine room identification code and a host identification code.
The technical scheme of the electronic equipment is as follows:
comprising a memory, a processor and a program stored in said memory and running on said processor, wherein said processor implements the steps of a method of generating a data stream number as described in any of the above when executing said program.
The electronic equipment has the following beneficial effects:
the host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
Drawings
Fig. 1 is a schematic flow chart of a method for generating a data serial number according to an embodiment of the present invention;
FIG. 2 is a diagram of a field to be filled;
FIG. 3 is a flowchart illustrating a technique for generating a serial number according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention;
Detailed Description
As shown in fig. 1, a method for generating a data serial number according to an embodiment of the present invention includes the following steps:
s1, filling the host deployment information of each host for acquiring data to a first preset position of each field to be filled with the same number of bits;
and S2, generating a sequence number corresponding to each piece of acquired data according to the time sequence, and filling the sequence number to a second preset position of a field to be filled corresponding to each piece of data to obtain a data serial number corresponding to each piece of data.
Wherein, the field to be padded may be understood as a character string with a plurality of bits, for example, the field to be padded is a 64-bit character string, each bit of the 64-bit character string defaults to 0, the host deployment information is padded in a first preset position in the 64-bit character string, and the first preset position may be understood as: the 1 st bit to the 5 th bit of the field to be filled, the filling process is as follows: replace the host deployment information with a default 0 between bit 1 to bit 5, then:
if the host deployment information is 1, the 1 st bit to the 5 th bit of the field to be filled after filling are 00001; if the host deployment information is 2, bits 1 to 5 of the field to be filled after the padding are 00010, and it can be understood that most of the stored data in the software is binary data, but the application is not limited to this form.
Then generating a serial number corresponding to each piece of acquired data according to a time sequence, taking a time point corresponding to each piece of acquired data as the serial number, setting the precision of the time point to be millisecond level, and converting a time point corresponding to each piece of acquired data into a binary system or filling the time point into the 6 th bit to the 50 th bit of a field to be filled in other formats by using a second preset position, thereby obtaining a data serial number corresponding to each piece of data;
the host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
The host deployment information includes a machine room identifier code and a host identifier code, and the machine room identifier code and the host identifier code are configured by confirmation, for example, the host deployment information is an a1 machine room a1-B1 rack a1-B1-C1 machine location, that is, the host is not deployed in an a1 machine room a1-B1 rack a1-B1-C1 machine location. Computer room-computer room refers generally to the area, rack, of telecommunications, network, mobile, two-wire, power, government or enterprise etc. where servers are stored to provide IT services for users and employees-a rack can be simply understood as a cabinet where servers are stored. And the host id code can be obtained through a zookeeper or other distributed coordination system, which is not described herein.
It should be noted that the data in a method for generating a data serial number according to the present invention also includes each operation or each step executed on each host, i.e., each operation or each step executed by each host is uniquely identified.
Preferably, in the above technical solution, before obtaining the data serial number corresponding to each piece of data, the method further includes:
and S3, generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of the field to be filled corresponding to each piece of data. The sequence number corresponding to each piece of data is added at the third preset position of the field to be filled corresponding to each piece of data, so that the uniqueness of the data serial number corresponding to each piece of data is further ensured.
The sequence number corresponding to each piece of data can be generated in the following two ways, specifically:
1) and at each millisecond-level time point, assigning a sequence number to each piece of data acquired in the millisecond-level time point in an optimistic lock mode, wherein the sequence numbers assigned in the millisecond-level time points are related or unrelated in sequence. Each piece of data acquired at each same millisecond-level time point is guaranteed to have different sequence numbers, and uniqueness of a data serial number corresponding to each piece of data is further guaranteed, specifically:
where the millisecond-level time point refers to a time point accurate to the millisecond level, it is assumed that 100 pieces of data are acquired at the same millisecond-level time point, each piece of data acquired at each same millisecond time point is incrementally numbered in an optimistic lock, may be 1, 2, and 3 … … 100, respectively, where 1, 2, and 3 … … 100 are sequence numbers of each piece of data that acquired 100 pieces of data at the same millisecond time point, and the sequence number corresponding to each piece of data is filled to a third preset position of the field to be filled corresponding to each piece of data, so that the uniqueness of the data serial number corresponding to each piece of data is further ensured, it can be understood that the initial parameter, i.e. 1, may be adjusted according to the actual situation, or may be incremented from 2, where the sequence number of each piece of data of 100 pieces of data acquired at the millisecond time point is 2, 3 … … 100, and 101, respectively.
The assigned sequence numbers in the respective millisecond time points are related in sequence, which is to be understood as: each piece of data acquired at the previous millisecond time point is subjected to incremental numbering, namely the sequence number of each piece of data acquired at the previous millisecond time point is respectively 1, 2 and 3 … … 100, namely 1, 2 and 3 … … 100, each piece of data acquired at the next millisecond time point is subjected to incremental numbering, namely 101 and 102 … …, namely the sequence number of each piece of data acquired at the next millisecond time point is respectively 101 and 102 … …;
the sequence independence of the assigned sequence numbers in the individual millisecond time points is to be understood as: each piece of data acquired at the previous millisecond time point is subjected to incremental numbering, namely the sequence number of each piece of data acquired at the previous millisecond time point is respectively 1, 2 and 3 … … 100, namely 1, 2 and 3 … … 100, each piece of data acquired at the next millisecond time point is subjected to incremental numbering, namely 1, 2 and 3 … …, namely the sequence number of each piece of data acquired at the next millisecond time point is subjected to incremental numbering again from an initial parameter, namely 1; 2) the sequence number corresponding to each piece of data in all the data can be generated by sequentially increasing +1 or +2 and the like, and then the sequence number is filled to a third preset position of a field to be filled corresponding to each piece of data.
Among them, optimistic locks-are mostly implemented based on a data Version (Version) recording mechanism. In the solution, a version identifier is added to the data version, and in general, a "version" field is added to the database table. When the data is read out, the version number is read out together, and then when the data is updated, the version number is increased by one.
The following describes a method for generating a data serial number according to another embodiment:
s40, as shown in fig. 2, defining a 64-bit Long type string as a field to be filled, and dividing the string to obtain a first preset position, a second preset position and a third preset position, where the first preset position is a position from an index of 42 to an index of 51, the second preset position is a position from an index of 1 to an index of 41, the third preset position is a position from an index of 52 to an index of 63, the position from an index of 0 is a fixed position, and the position from an index of 0 is fixable to 0, which represents that the Long type string is a positive integer, and 0 to 63 represent indexes;
it can be understood that the first preset position, the second preset position and the third preset position can be re-divided according to actual conditions, no repeated description is given here, and the host deployment information includes a machine room identification code and a host identification code, and the machine room identification code and the host identification code can also be divided according to actual conditions from a position corresponding to the index 42 to a position corresponding to the index 51, for example, the machine room identification code occupies 5 bits, the host identification code occupies 5 bits, or the machine room identification code occupies 6 bits, the host identification code occupies 4 bits, and the like, and no repeated description is given here.
S41, generating a data serial number corresponding to each piece of data, where each piece of data corresponds to one field to be filled, and taking any piece of data as an example for description, specifically:
filling host deployment information corresponding to the host which acquires or generates the piece of data into a first preset position of a field to be filled corresponding to the piece of data, namely filling the position from 42 bits of the index to 51 bits of the index;
filling a second preset position of a field to be filled corresponding to the data, namely filling a bit with an index of 1 to a bit with an index of 41, wherein the millisecond time point, namely the millisecond time stamp, for acquiring the data is used as a serial number corresponding to the data;
after each piece of data acquired at the same millisecond time point corresponding to the piece of data is acquired by means of optimistic locking, acquiring a sequence number corresponding to the data, and filling the sequence number to a third preset position of a field to be filled corresponding to the piece of data, namely filling the sequence number from a bit with an index of 52 to a bit with an index of 63, so as to acquire a data serial number corresponding to the piece of data;
according to S41, and so on, a data stream number corresponding to each piece of data is generated.
The method for generating the data serial number of the invention of the embodiment can ensure the uniqueness of the data serial number corresponding to each piece of data, can not generate repeated data serial numbers, thereby ensuring higher coupling degree between the serial number and the data and high reliability, in addition, the serial number and the data do not need to be based on a database, the performance of the database is not reduced, the serial number of each generated data is ordered, the index association efficiency is high, the readability is realized, the malicious modification of a user to acquire the data can be prevented, and each piece of data acquired at the same millisecond time point is subjected to incremental numbering by using an optimistic lock mode to generate a sequence number corresponding to each piece of data, the method can ensure that the data serial number generated next time is first larger than the current data serial number, and can judge whether all data have the problems of missing and the like according to the data serial number corresponding to each data.
In the foregoing embodiments, although the steps are numbered as S1, S2, etc., but only the specific embodiments are given in this application, and those skilled in the art may adjust the execution order of S1, S2, etc. according to the actual situation, which is also within the protection scope of the present invention, and it is understood that some embodiments may include some or all of the above embodiments.
As shown in fig. 3, a system 200 for generating a data serial number according to an embodiment of the present invention includes a first padding module 210 and a second padding module 220;
the first padding module 210 is configured to pad host deployment information of each host for acquiring data to a first preset position of each field to be padded with the same number of bits;
the second filling module 220 is configured to generate a sequence number corresponding to each acquired data according to a time sequence, and fill the sequence number to a second preset position of a field to be filled corresponding to each data, so as to obtain a data serial number corresponding to each data.
The host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
Preferably, in the above technical solution, the apparatus further includes a third filling module, where the third filling module is configured to: and generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of a field to be filled corresponding to each piece of data.
The sequence number corresponding to each piece of data is added at the third preset position of the field to be filled corresponding to each piece of data, so that the uniqueness of the data serial number corresponding to each piece of data is further ensured.
Preferably, in the above technical solution, the third padding module is specifically configured to allocate, at each millisecond-level time point, a sequence number to each piece of data acquired in the millisecond-level time point in an optimistic lock manner, where the sequence numbers allocated in the respective millisecond-level time points are related or unrelated in sequence. Each piece of data acquired at each same millisecond time point is guaranteed to have different sequence numbers, and uniqueness of the data serial number corresponding to each piece of data is further guaranteed.
Preferably, in the above technical solution, the host deployment information includes a machine room identification code and a host identification code.
The above steps for realizing the corresponding functions of each parameter and each unit module in the data serial number generation system 200 of the present invention can refer to each parameter and step in the above embodiment of a data serial number generation method, which are not described herein again.
As shown in fig. 4, an electronic device 300 according to an embodiment of the present invention includes a memory 310, a processor 320, and a program 330 stored in the memory 310 and running on the processor 320, where the processor 320 executes the program 330 to implement any of the steps of the method for generating a data serial number implemented in the foregoing embodiments.
The host deployment information of each host is filled to a first preset position of each field to be filled, a serial number corresponding to each piece of acquired data is generated according to a time sequence and is filled to a second preset position of each field to be filled corresponding to each piece of data, the uniqueness of a data serial number corresponding to each piece of data is guaranteed, repeated data serial numbers cannot occur, and therefore high coupling degree between the data serial numbers and the data is guaranteed.
The electronic device 300 may be a computer, a mobile phone, or the like, and correspondingly, the program 330 is computer software or a mobile phone APP, and the parameters and the steps in the electronic device 300 of the present invention may refer to the parameters and the steps in the above embodiment of the method for generating a data serial number, which are not described herein again.
As will be appreciated by one skilled in the art, the present invention may be embodied as a system, method or computer program product.
Accordingly, the present disclosure may be embodied in the form of: may be embodied entirely in hardware, entirely in software (including firmware, resident software, micro-code, etc.) or in a combination of hardware and software, and may be referred to herein generally as a "circuit," module "or" system. Furthermore, in some embodiments, the invention may also be embodied in the form of a computer program product in one or more computer-readable media having computer-readable program code embodied in the medium.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium include an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (9)
1. A method for generating a data serial number, comprising:
filling host deployment information of each host for acquiring data to a first preset position of each field to be filled with the same number of bits;
and generating a sequence number corresponding to each piece of acquired data according to the time sequence, and filling the sequence number to a second preset position of a field to be filled corresponding to each piece of data to obtain a data serial number corresponding to each piece of data.
2. The method according to claim 1, wherein before obtaining the data serial number corresponding to each piece of data, the method further comprises:
and generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of a field to be filled corresponding to each piece of data.
3. The method according to claim 2, wherein the generating a sequence number corresponding to each piece of data comprises: and at each millisecond-level time point, assigning a sequence number to each piece of data acquired in the millisecond-level time point in an optimistic lock mode, wherein the sequence numbers assigned in the millisecond-level time points are related or unrelated in sequence.
4. The method according to any one of claims 1 to 3, wherein the host deployment information includes a machine room identifier and a host identifier.
5. A generation system of a data serial number is characterized by comprising a first filling module and a second filling module;
the first filling module is used for filling the host deployment information of each host used for acquiring data to a first preset position of each field to be filled with the same number of bits;
the second filling module is used for generating a sequence number corresponding to each piece of acquired data according to a time sequence, and filling the sequence number to a second preset position of a field to be filled corresponding to each piece of data to obtain a data serial number corresponding to each piece of data.
6. The system for generating a data serial number according to claim 5, further comprising a third padding module, wherein the third padding module is configured to: and generating a sequence number corresponding to each piece of data, and filling the sequence number to a third preset position of a field to be filled corresponding to each piece of data.
7. The system according to claim 6, wherein the third padding module is specifically configured to assign a sequence number to each piece of data acquired at each millisecond time point by using an optimistic lock, and the sequence numbers assigned at each millisecond time point are sequentially related or sequentially unrelated.
8. The system for generating a data serial number according to any one of claims 5 to 7, wherein the host deployment information comprises a machine room identification code and a host identification code.
9. An electronic device comprising a memory, a processor and a program stored on the memory and running on the processor, wherein the steps of a method of generating a data stream number as claimed in any one of claims 1 to 4 are implemented when the program is executed by the processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011310653.1A CN112445800A (en) | 2020-11-20 | 2020-11-20 | Method and system for generating data serial number and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011310653.1A CN112445800A (en) | 2020-11-20 | 2020-11-20 | Method and system for generating data serial number and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112445800A true CN112445800A (en) | 2021-03-05 |
Family
ID=74737153
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011310653.1A Pending CN112445800A (en) | 2020-11-20 | 2020-11-20 | Method and system for generating data serial number and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112445800A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113079175A (en) * | 2021-04-14 | 2021-07-06 | 上海浦东发展银行股份有限公司 | Authorization system and method based on oauth2 protocol enhancement |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105072160A (en) * | 2015-07-17 | 2015-11-18 | 联动优势科技有限公司 | Serial number generating method and device, and a server |
| WO2016179574A1 (en) * | 2015-05-07 | 2016-11-10 | Cloudera, Inc. | Mutations in a column store |
| CN106412035A (en) * | 2016-09-14 | 2017-02-15 | 联动优势电子商务有限公司 | Serial number generation method and terminal |
| CN108241715A (en) * | 2016-12-27 | 2018-07-03 | 苏宁云商集团股份有限公司 | A kind of distributed data base major key generation method and device |
| CN109933574A (en) * | 2019-02-27 | 2019-06-25 | 常州猛犸电动科技有限公司 | A kind of unique key generation method, device and terminal device |
| CN110619114A (en) * | 2019-09-26 | 2019-12-27 | 北京明略软件系统有限公司 | Serial number generation method and system |
| CN111371918A (en) * | 2020-02-28 | 2020-07-03 | 上海钧正网络科技有限公司 | ID generation method, device, medium and equipment in distributed cluster environment |
| US20200334254A1 (en) * | 2019-04-19 | 2020-10-22 | Timescale, Inc. | Querying of materialized views for time-series database analytics |
-
2020
- 2020-11-20 CN CN202011310653.1A patent/CN112445800A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016179574A1 (en) * | 2015-05-07 | 2016-11-10 | Cloudera, Inc. | Mutations in a column store |
| CN105072160A (en) * | 2015-07-17 | 2015-11-18 | 联动优势科技有限公司 | Serial number generating method and device, and a server |
| CN106412035A (en) * | 2016-09-14 | 2017-02-15 | 联动优势电子商务有限公司 | Serial number generation method and terminal |
| CN108241715A (en) * | 2016-12-27 | 2018-07-03 | 苏宁云商集团股份有限公司 | A kind of distributed data base major key generation method and device |
| CN109933574A (en) * | 2019-02-27 | 2019-06-25 | 常州猛犸电动科技有限公司 | A kind of unique key generation method, device and terminal device |
| US20200334254A1 (en) * | 2019-04-19 | 2020-10-22 | Timescale, Inc. | Querying of materialized views for time-series database analytics |
| CN110619114A (en) * | 2019-09-26 | 2019-12-27 | 北京明略软件系统有限公司 | Serial number generation method and system |
| CN111371918A (en) * | 2020-02-28 | 2020-07-03 | 上海钧正网络科技有限公司 | ID generation method, device, medium and equipment in distributed cluster environment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113079175A (en) * | 2021-04-14 | 2021-07-06 | 上海浦东发展银行股份有限公司 | Authorization system and method based on oauth2 protocol enhancement |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3467635A1 (en) | Data writing and reading method and apparatus, and distributed object storage cluster | |
| CN111352935B (en) | Index creating method, device and equipment in block chain type account book | |
| CN107360224A (en) | Sequence number generation method, system, equipment and storage medium in distributed system | |
| CN109558525B (en) | Test data set generation method, device, equipment and storage medium | |
| CN110737806B (en) | Global ID generation method and device for business entity | |
| WO2013097546A1 (en) | Assisting query and querying | |
| CN108599973B (en) | Log association method, device and equipment | |
| EP3014479A2 (en) | Omega names: name generation and derivation | |
| CN110795399B (en) | Method, device and system for generating machine ID for application | |
| CN109447820B (en) | Data processing method, device, computer equipment and storage medium | |
| CN105824849A (en) | Data import method and adapter | |
| CN111143446A (en) | Data structure conversion processing method and device of data object and electronic equipment | |
| CN106844288B (en) | Random character string generation method and device | |
| CN111858586B (en) | Data processing method and device | |
| CN113704790A (en) | Abnormal log information summarizing method and computer equipment | |
| JP2005050347A (en) | Method and apparatus for late-binding / dynamic path name resolution | |
| CN110019444B (en) | Operation request processing method, device, equipment and system | |
| CN115756955A (en) | Data backup and data recovery method and device and computer equipment | |
| CN112445800A (en) | Method and system for generating data serial number and electronic equipment | |
| CN103051480B (en) | The storage means of a kind of DN and DN storage device | |
| CN117349291A (en) | Database primary key short ID generation method, electronic equipment and medium | |
| CN113377813B (en) | Global unique identification code generation method, device, system and computer readable medium | |
| CN114970464A (en) | Method, device, terminal equipment and storage medium for generating identification | |
| CN112148299A (en) | Byte code object copying method, device, equipment and storage medium | |
| CN106993036B (en) | Running environment information processing method and switch |
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 |