CN109710609A - Generate the method and device of tables of data mark - Google Patents
Generate the method and device of tables of data mark Download PDFInfo
- Publication number
- CN109710609A CN109710609A CN201811534101.1A CN201811534101A CN109710609A CN 109710609 A CN109710609 A CN 109710609A CN 201811534101 A CN201811534101 A CN 201811534101A CN 109710609 A CN109710609 A CN 109710609A
- Authority
- CN
- China
- Prior art keywords
- mark
- tables
- data
- generated
- random identification
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 239000003550 marker Substances 0.000 claims abstract description 30
- 230000004044 response Effects 0.000 claims abstract description 13
- 238000003860 storage Methods 0.000 claims description 14
- 238000012163 sequencing technique Methods 0.000 claims description 11
- 238000004590 computer program Methods 0.000 claims description 9
- 238000013500 data storage Methods 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 16
- 230000008569 process Effects 0.000 description 14
- 238000012545 processing Methods 0.000 description 10
- 238000010586 diagram Methods 0.000 description 9
- 230000000694 effects Effects 0.000 description 6
- 230000004048 modification Effects 0.000 description 6
- 238000012986 modification Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 239000003795 chemical substances by application Substances 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 230000001755 vocal effect Effects 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This disclosure relates to which technical field of data storage, specifically discloses a kind of method and device of generation tables of data mark, comprising: receive operation system according to the initiated mark of tables of data creation operation and generate request；Request is generated in response to mark, the register information of operation system is obtained from mark generation system, register information includes the constant mark element of random identification Element generation rule, marker element rule of combination and identification service system；Random identification element is generated according to random identification create-rule；The combination of marker element Yu random identification element is fixed according to marker element rule of combination, generates tables of data mark；Tables of data generated mark is sent to operation system, tables of data is identified into the major key as created tables of data.Tables of data mark is generated in conjunction with constant mark element and random identification element, identifies identical probability to reduce and tables of data occur.
Description
Technical field
This disclosure relates to technical field of data storage, in particular to a kind of method and device for generating tables of data mark.
Background technique
In insurance system, the relevant information of the bought insurance of user is stored by the tables of data in database, such as
The relevant information that the declaration form of the bought insurance of user is stored by declaration form table, is stored by saving table from damage and is become in the declaration form of user
Content etc. more.For each tables of data, the mark of tables of data is carried out by configuration data table mark.In insurance system,
Multiple tables of data are often related to for the insurance that same user is bought, such as declaration form table mentioned above, save table from damage, are also compared
Such as agent's table, institution table are carried out the association between multiple tables of data marks by tables of data mark, such as saved from damage
Table, agent's table, the tables of data mark that declaration form table is written in institution table, so as to quick by tables of data mark be written
Position and find declaration form table.
In the prior art by the way that, from increasing function, such as sequence, Lai Shengcheng tables of data identifies in database.Although can
Think that the tables of data in same database generates different tables of data marks.If it is such in two databases to be that is all made of
Mode generates tables of data mark, can have the mutually the same tables of data of multiple groups, such as the data in database A in two databases
Table A is identical as the tables of data B in database B, and the tables of data C in database A is identical as the tables of data B in database B, i.e. data
Table mark collides.
In insurance system, merging between database and database is generally involved, and merges it in database
Before, in order to guarantee the efficiency of data storage, needs to identify tables of data identical mark and modify, i.e., number is guaranteed by modification
It is different according to the Data Identification of tables of data each in library.And modify tables of data and be related to lock table, and typically the non-working time into
Row is modified, and the modification of tables of data is just carried out after needing system offline under extreme case, to lead since tables of data mark is identical
Cause at high cost, the heavy workload of tables of data modification.And correspond to modification with the associated tables of data of multiple tables of data, need modify with
The associated every tables of data of the tables of data, so that the workload of modification is bigger.
The probability to collide is identified from the foregoing, it will be observed that how to generate tables of data mark to reduce the tables of data of two tables of data
The problem of there are also to be solved.
Summary of the invention
In order to solve the problems, such as present in the relevant technologies, present disclose provides the methods and dress of a kind of generation tables of data mark
It sets.
In a first aspect, a kind of method for generating tables of data mark, is applied to mark generation system, comprising:
It receives operation system and operates initiated mark generation request according to tables of data creation；
It generates and requests in response to the mark, the registered letter of the operation system is obtained from the mark generation system
Breath, the register information include random identification Element generation rule, marker element rule of combination and the mark operation system
Constant mark element；
Random identification element is generated according to the random identification create-rule；
The combination of the constant mark element Yu the random identification element is carried out according to the marker element rule of combination,
Generate tables of data mark；
Tables of data generated mark is sent to the operation system, the tables of data is identified and is used as created number
According to the major key of table.
Second aspect, a kind of device generating tables of data mark are applied to mark generation system, comprising:
Receiving module is configured as: being received operation system and is operated initiated mark generation request according to tables of data creation；
Module is obtained, is configured as: generating and requests in response to the mark, from the mark generation system described in acquisition
The register information of operation system, the register information include random identification Element generation rule, marker element rule of combination and
Constant mark element；
Random identification Element generation module, is configured as: generating random identification member according to the random identification create-rule
Element；
Tables of data identifier generation module, is configured as: carrying out the constant mark according to the marker element rule of combination
The combination of element and the random identification element generates tables of data mark；
Sending module is configured as: tables of data generated mark being sent to the operation system, by the data
Table identifies the major key as created tables of data.
In one embodiment, the acquisition module includes:
System banner searching unit, is configured as: generating and requests in response to the mark, in the system of mark generation system
The lookup of the system banner is carried out in enrolled set；
Acquiring unit is configured as: if finding the system banner, being obtained and the system banner associated storage
Register information.
It in one embodiment, include multiple constant mark elements and pressing in register information corresponding to each operation system
The sequencing information of the multiple constant mark element sequence is carried out according to tables of data mark quantitative range, in the mark generation system
Quantity information including having generated tables of data mark for each operation system, the tables of data identifier generation module, comprising:
Quantity information acquiring unit, is configured as: obtaining the mark generation system is that the operation system generates data
The quantity information of table mark；
Constant mark element determination unit, is configured as: according to the quantity information in the sequencing information determine to
The quantitative range where tables of data mark is generated, constant mark element corresponding to identified quantitative range is determined as to be generated
At tables of data identify in constant mark element；
Tables of data identification generation unit, is configured as: combining the random identification according to the marker element rule of combination
Element and identified constant mark element generate the tables of data mark.
In one embodiment, described device further include:
Searching module is configured as: tables of data generated mark is identified lookup in the logo collection；
Execution module is configured as: if searching module do not find it is identical with the tables of data generated mark
Mark then executes the step of tables of data generated mark is sent to the operation system；And if searching module is searched
Identical mark is identified to the tables of data generated, then is back to and is generated at random according to the random identification create-rule
The step of marker element, to regenerate tables of data mark according to the random identification element regenerated.
In one embodiment, the logo collection is constituted by having generated the corresponding cryptographic Hash of tables of data mark, the dress
It sets further include:
Cryptographic Hash generation module, is configured as: the cryptographic Hash of generated tables of data mark being calculated by hash algorithm；
The searching module includes:
Searching unit is configured as: according to the cryptographic Hash of the generated tables of data mark in the logo collection into
Line identifier is searched.
In one embodiment, described device further include:
Reception and writing module, are configured as: the operation system receives the tables of data mark, and will be received
The tables of data mark is written in created tables of data.
The third aspect, a kind of device generating tables of data mark, comprising:
Processor；And
Memory is stored with computer-readable instruction on the memory, and the computer-readable instruction is by the processing
Device realizes the process described above when executing.
Fourth aspect, a kind of computer readable storage medium are stored thereon with computer program, the computer program quilt
Processor realizes the process described above when executing.
Pass through constant mark element corresponding to each operation system and random identification member usually combination producing tables of data mark
Know, for each operation system, constant mark element is different, and what random identification element was randomly generated, to occur
The identical probability of tables of data mark of two tables of data is very low, that is, reduces tables of data and identify the probability to collide, to also drop
It is low because tables of data identify it is identical carry out tables of data substantially modify the probability happened.
It should be understood that the above general description and the following detailed description are merely exemplary, this can not be limited
It is open.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows and meets implementation of the invention
Example, and in specification together principle for explaining the present invention.
Fig. 1 is the schematic diagram of the implementation environment according to involved in the disclosure；
Fig. 2 is a kind of block diagram of server shown according to an exemplary embodiment；
Fig. 3 is a kind of flow chart of method for generating tables of data mark shown according to an exemplary embodiment；
Fig. 4 is the flow chart of the step S130 of Fig. 3 corresponding embodiment；
Fig. 5 is the flow chart of the step S170 of Fig. 3 corresponding embodiment；
The flow chart of step before Fig. 6 is the step S170 shown according to another embodiment；
Fig. 7 is a kind of block diagram of device for generating tables of data mark shown according to an exemplary embodiment；
Fig. 8 is the block diagram of the acquisition module 130 of Fig. 7 corresponding embodiment；
Fig. 9 is a kind of block diagram of the device of the generation tables of data mark shown according to another exemplary embodiment.
Through the above attached drawings, it has been shown that the specific embodiment of the present invention will be hereinafter described in more detail, these attached drawings
It is not intended to limit the scope of the inventive concept in any manner with verbal description, but is by referring to specific embodiments
Those skilled in the art illustrate idea of the invention.
Specific embodiment
Here will the description is performed on the exemplary embodiment in detail, the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all embodiments consistented with the present invention.On the contrary, they be only with it is such as appended
The example of device and method being described in detail in claims, some aspects of the invention are consistent.
Fig. 1 is the schematic diagram of the implementation environment according to involved in the disclosure.The implementation environment includes: 110 He of mobile terminal
At least one smart machine 120.
Interrelational form between mobile terminal 110 and smart machine 120, network associate mode and/or association including hardware
View, and the data correlation mode come and gone therebetween.
Fig. 1 is the schematic diagram of the implementation environment according to involved in the disclosure.The implementation environment includes deployment operation system
The server 200 of terminal 100 and deployment mark generation system.
Wherein, the terminal 100 of configuration service system can be desktop computer, laptop, tablet computer, smart phone
Or the electronic equipment of other configurable operation systems, herein without specifically limiting.It is noted that on the terminal 100
The operation system configured can be application forms, can also be form web page.
Pass through wired or nothing between the server 200 of terminal 100 and configuration identifier the generation system of configuration service system
Line establishes network connection, to be connected to the network the data transmission realized between operation system and mark generation system based on this, is passed
Defeated data generate request etc. for example including mark.
The interaction that the server 200 of system is generated by the terminal 100 and configuration identifier of configuration service system, is configured at end
The mark configured on server 200 is generated system and initiates mark generation request, server 200 by the operation system at end 100
Tables of data mark is generated for operation system according to the disclosed method, and tables of data generated mark is sent to business system
System.
Fig. 2 is a kind of block diagram of server shown according to an exemplary embodiment.The server can be raw with configuration identifier
It is deployed at system in Fig. 1 implementation environment.
It should be noted that the server, which is one, adapts to example of the invention, it must not believe that there is provided to this
Any restrictions of the use scope of invention.The server can not be construed to need to rely on or must have in Fig. 2 to show
Illustrative server 200 in one or more component.
The hardware configuration of the server 200 can generate biggish difference due to the difference of configuration or performance, such as Fig. 2 institute
Show, server 200 include: power supply 210, interface 230, at least a memory 250 and an at least central processing unit (CPU,
Central Processing Units)270。
Wherein, power supply 210 is used to provide operating voltage for each hardware device on server 200.
Interface 230 includes an at least wired or wireless network interface 231, at least a string and translation interface 233, at least one defeated
Enter output interface 235 and at least USB interface 237 etc., is used for and external device communication.
The carrier that memory 250 is stored as resource, can be read-only memory, random access memory, disk or CD
Deng the resource stored thereon includes operating system 251, application program 253 and data 255 etc., and storage mode can be of short duration
It stores or permanently stores.Wherein, operating system 251 is for managing and each hardware device in control server 200 and answering
It can be Windows with program 253 to realize calculating and processing of the central processing unit 270 to mass data 255
ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM etc..Application program 253 be based on operating system 251 it
The upper computer program for completing at least one particular job, may include an at least module (being not shown in Fig. 2), each module
The series of computation machine readable instruction to server 200 can be separately included.Data 255 can be stored in disk
Photo, picture etc..
Central processing unit 270 may include the processor of one or more or more, and be set as through bus and memory
250 communications, for the mass data 255 in operation and processing memory 250.
As described in detail above, memory will be read by central processing unit 270 by being applicable in server 200 of the invention
The form of the series of computation machine readable instruction stored in 250 come complete generate tables of data mark method.
In addition, also can equally realize the present invention by hardware circuit or hardware circuit combination software, therefore, this hair is realized
The bright combination for being not limited to any specific hardware circuit, software and the two.
Fig. 3 is a kind of flow chart of method for generating tables of data mark shown according to an exemplary embodiment.The generation
The method of tables of data mark, can be executed by server 200, wherein configured with mark generation system, such as Fig. 3 in server 200
It is shown, it may comprise steps of:
Step S110 receives operation system and operates initiated mark generation request according to tables of data creation.
Operation system can be different types of operation system, such as life insurance system, produce dangerous system etc., step S110 it
Before, it establishes each operation system and identifies the communication connection between generation system, to establish communication link with mark generation system
The operation system connect can uniformly generate tables of data mark by mark generation system.
Operation system stores corresponding data by database, such as the life insurance database in life insurance system is for storing
User insures the relevant data of life insurance, produces the production danger database of dangerous system and insures for storing user and produces the relevant data in danger.?
By creating tables of data and corresponding data being written in tables of data in database, to realize the guarantor of data in the database
It deposits, such as saves the policy information of user A in producing dangerous database, then create a tables of data in producing dangerous Database Systems,
The information in the declaration form of user A is written in tables of data.
Each tables of data is identified corresponding to a tables of data, that is, passes through the tables of data mark for marking tables of data.It is led in insurance
In domain, for the insurance that user is bought, multiple tables of data are created in the database of insurance system to store the user institute
Relevant information is insured in purchase, such as declaration form table, saves table, agent's table, document table from damage etc., due to these tables of data be all about
The information of the bought insurance of the user, thus, it needs to associate these tables of data in storage.In the prior art, lead to
It crosses and is identified for each tables of data configuration data table, i.e., by identifying in tables of data come corresponding mark tables of data, thus, pass through
Tables of data identifies to carry out the association of multiple tables of data, is used to the tables of data being associated with other tables of data mark and becomes
The major key of the tables of data.To in a certain tables of data, such as save Table A from damage, in can write direct another tables of data, such as protect
Single Table A, tables of data identify to create the association saved from damage between Table A and declaration form Table A, can be numerous by the association created
It is positioned in declaration form table and declaration form Table A is accessed.
For the creation for carrying out tables of data in the database of operation system, the corresponding offer graphical interfaces member of operation system
Element, such as menu, icon etc. trigger for user and carry out tables of data creation.Such as it is configured on the interactive interface of operation system
For triggering the icon for carrying out tables of data creation, so that user realizes the creation of tables of data by clicking or touching the icon.
On the interactive interface of operation system monitor for carry out tables of data creation operation Basic Elements of Graphic User Interface whether by
Triggering, to judge whether to initiate tables of data creation operation.If monitoring Basic Elements of Graphic User Interface to be triggered, it is determined that tables of data
Creation operation be initiated, thus according to tables of data creation operation to mark generation system initiate mark generate request.
Since operation system can be different types of system, correspondingly, it includes initiating the request in request that mark, which generates,
Operation system corresponding to system banner.
Step S130 generates request in response to mark, and the register information of operation system is obtained from mark generation system, is stepped on
Note information includes the constant mark element of random identification Element generation rule, marker element rule of combination and identification service system.
In the technical solution of the disclosure, number is generated by way of constant mark element and random identification element combinations
It is identified according to table, it is described below.
The type of random identification element is indicated in random identification Element generation rule and generates random identification element
Mode.Wherein random identification element can be timestamp, random number, Universally Unique Identifier (Universally Unique
Identifier, UUID).For example, such as random identification Element generation rule A is indicated using timestamp as random identification
Element, and it is corresponding indicate the function of timestamp, timestamp is generated by the function.
On the one hand component that constant mark element is used as tables of data to identify, on the other hand can be used to identification service system
System, that is, be directed to different operation systems, and the constant mark element in tables of data mark is also different.In a particular embodiment,
The English name, Chinese, title that constant mark element can be operation system write a Chinese character in simplified form, domain name etc., can also be and is identifying
The operation system arranged between generation system and operation system refers to mark, such as agreement represents operation system B with letter b, with
Letter C represents operation system C, herein without specifically limiting.In a tables of data mark, wherein may include a fixation
Marker element also may include multiple constant mark elements, and the constant mark of each of certain multiple constant mark elements is all
The operation system can be identified.For example, can simultaneously by operation system Chinese and operation system domain name simultaneously
As constant mark element, then tables of data is identified by what Chinese, domain name and random identification element combinations generated.
Tables of data mark be made of constant mark element and random identification element, tables of data mark in constant mark element and
The combination of random identification element is between marker element rule of combination, such as constant mark element and random identification element
Distributing order, for another example between character each in random identification element be inserted into constant mark element in each character rule
Deng herein without specifically limiting.For different operation systems, marker element rule of combination be may be the same or different.
Since mark generation system can generate tables of data mark for different operation systems, so in mark generation system
Middle correspondence stores the register information of each operation system.It, can after receiving the mark that operation system is initiated and generating request
To obtain the register information of the operation system from corresponding storage location.
In one exemplary embodiment, it includes system banner corresponding to operation system that mark, which generates request, such as Fig. 4 institute
Show, step S130 includes:
Step S131 generates request in response to mark, system mark is carried out in the system registry set of mark generation system
The lookup of knowledge.
Step S132 obtains the register information with system banner associated storage if finding system banner.
That is, mark, which generates request, carries system banner corresponding to operation system, to pass through the system mark
Know, mark generation system, which can determine, initiates the operation system that mark generates request.
In mark generation system, the register information of each operation system is stored in system registry set, and each
The register information of operation system is and system banner associated storage.
In one embodiment, it if not finding system banner in system registry set, is given birth to mark is initiated
Prompt information is returned at the operation system of request, to prompt that the register information of the system is not present in mark generation system.
Step S150 generates random identification element according to random identification create-rule.
As described above, random identification element can be timestamp, random number, UUID.In random identification create-rule
It indicates the type of random identification element and generates the mode of random identification element, in step S150, i.e., according to random mark
Know the random identification that mode indicated in create-rule generates corresponding types.
In one embodiment, random identification element is timestamp, then when generating the mode of timestamp and can be calling
Between stamp generating function generate, for example, pass through function:
When LocalDateTime.now () .toEpochSecond (ZoneOffset.of ("+8 ")) carrys out corresponding production
Between stab.In the implementation, step S150 further comprises: obtaining the current time of mark generation system；And then according to acquired
Current time and allocating time stamp generating function generate timestamp.
Similarly, generation random number, UUID are corresponding can be by generating the function of random number, generating the function of UUID come real
It is existing.
The combination of marker element Yu random identification element is fixed according to marker element rule of combination by step S170, raw
It is identified at tables of data.
As described above, marker element rule of combination is constant mark element and random identification in tables of data mark
The combination of element.For example, if marker element rule of combination indicates tables of data mark generated are as follows: domain name _ with
The domain name combination of the operation system in random number generated and register information is then generated data according to this distributing order by machine number
Table mark.
Tables of data generated mark is sent to operation system, tables of data mark is used as and is created by step S190
The major key of tables of data.
By generating number from increasing function or sequence number generating function in each database in compared with the existing technology
Identified according to table, tables of data generated in the technical solution of the disclosure identify by identification service system constant mark element and with
The random identification element that machine generates is constituted, and for different operation systems, constant mark element is different, and random identification
What element was randomly generated, the identical probability of Data Identification so as to which two tables of data are greatly reduced, tables of data mark occurs
The probability of collision is also greatly reduced.
In one exemplary embodiment, in register information corresponding to each operation system include multiple constant mark elements and
The sequencing information that multiple constant mark element sequences are carried out according to tables of data mark quantitative range, identifying includes being in generation system
Each operation system has generated the quantity information of tables of data mark, as shown in figure 5, step S170, comprising:
Step S171, obtaining mark generation system is the quantity information that operation system generates tables of data mark.
Step S172 determines the quantitative range where tables of data mark to be generated according to quantity information in sequencing information,
Constant mark element corresponding to identified quantitative range is determined as the constant mark element in tables of data mark to be generated.
I.e. during mark generates system generated data table mark, it is recorded as each operation system respectively and generates data
The data information of table mark, it is the number that the operation system has generated tables of data mark which, which indicates mark generation system,
Amount.
In sequencing information, the sequence of multiple constant mark elements is carried out according to tables of data mark quantitative range.Citing comes
It says, such as includes operation system Chinese, English name, domain name, sequencing information in register information are as follows:
For the quantity of tables of data mark within the scope of 1-500, the constant mark element in tables of data mark uses Chinese；
For the quantity of tables of data mark within the scope of 501-1000, the constant mark element in tables of data mark uses English name
Claim；
For the quantity of tables of data mark within the scope of 1001-1500, the constant mark element in tables of data mark uses domain name；
For the quantity of tables of data mark within the scope of 1501-2000, the constant mark source in tables of data mark uses Chinese name
Title and domain name.
To first determine the quantitative range where tables of data mark to be generated, such as quantity information middle finger according to quantity information
It is shown as the operation system and has generated the quantity of tables of data mark to be 1200, then tables of data to be generated is identified as 1201 tables of data marks
To know, the quantitative range at place is 1001-1500, thus, the constant mark element in the tables of data mark to be generated is domain name.
Certainly above example is only illustrative examples, is not construed as the limitation to disclosure use scope.For
The constant mark element used in quantitative range and corresponding data the table mark being related in sequencing information is carried out certainly by user
Definition setting, and sequencing information is stored in mark generation system.
Step S173, according to marker element rule of combination combining random marker element and identified constant mark element,
Generate tables of data mark.
The constant mark element employed in different number range setting tables of data mark, especially suitable for a certain business
The big situation of the quantity of tables of data included by database in system can reduce the random identification element phase due to generating at random
Tables of data identifies identical probability with caused by, reduces tables of data and identifies the probability to collide.
In one exemplary embodiment, mark generation system includes for storing the identification sets for having generated tables of data mark
It closes, as shown in fig. 6, before step S190, further includes:
Tables of data generated mark is identified lookup by step S180 in logo collection.
Identical mark is identified with tables of data generated if do not found, thens follow the steps S190；And it if looks into
It finds and identifies identical mark with tables of data generated, be then back to step S150, according to the random identification regenerated
Element regenerates tables of data mark.
In this embodiment, it identifies and is configured with logo collection in generation system, generated tables of data mark for storing, into
And after executing step S170, tables of data generated mark is searched in logo collection, thus, if found
Identical tables of data mark, then be back to step S150, regenerate random identification element, and execute subsequent step according to again
The random identification element of generation regenerates tables of data mark, until cannot find identical tables of data mark in logo collection
Know.If do not found, tables of data generated mark is sent to operation system, and update logo collection.
The lookup of tables of data mark is carried out in logo collection after generating tables of data mark, to guarantee to be issued to business
The tables of data mark of system has uniqueness, can directly avoid two tables of data mark identical.
In one exemplary embodiment, logo collection is constituted by having generated the corresponding cryptographic Hash of tables of data mark, step
After S170, further includes:
The cryptographic Hash of generated tables of data mark is calculated by hash algorithm；
Step S180 includes:
Lookup is identified in logo collection according to the cryptographic Hash that generated tables of data identifies.
It is identified lookup by the corresponding cryptographic Hash of tables of data mark, so as to improve search efficiency and search speed
Degree.
In this embodiment, in step S190, generated tables of data is identified into corresponding cryptographic Hash and is sent to business system
System is equivalent to and is encrypted with the tables of data mark sent, so as to improve safety.Corresponding to operation system, receiving
It to after cryptographic Hash, is decrypted using corresponding hash algorithm, obtains tables of data mark generated.
In one exemplary embodiment, after step S190, further includes:
Operation system receives tables of data mark, and received tables of data mark is written in created tables of data.
In tables of data, corresponding literary name section is configured for tables of data mark, created data are written into tables of data mark
In table, i.e., the literary name section is assigned a value of tables of data generated and identified.To being associated in creation tables of data and another tables of data
When, it the tables of data being written is identified as major key to create is associated with another tables of data.
Following is embodiment of the present disclosure, can be used for executing the generation data that the above-mentioned server 200 of the disclosure executes
The embodiment of the method for table mark.For those undisclosed details in the apparatus embodiments, it please refers to the disclosure and generates tables of data
The embodiment of the method for mark.
Fig. 7 is a kind of block diagram of device for generating tables of data mark shown according to an exemplary embodiment, which can
With the server 200 for implementation environment shown in Fig. 1, wherein execute in server 200 configured with mark generation system to take up an official post
The all or part of step of the method for generation tables of data mark shown in one embodiment of the method.As shown in fig. 7, the device packet
It includes:
Receiving module 110, is configured as: receiving operation system and is asked according to the initiated mark generation of tables of data creation operation
It asks.
Module 130 is obtained, which connect with receiving module 110, be configured as: request is generated in response to mark, from mark
Know the register information that operation system is obtained in generation system, register information includes random identification Element generation rule, identification element
Plain rule of combination and constant mark element；
Random identification Element generation module 150, the module connect with module 130 is obtained, are configured as: according to random identification
Create-rule generates random identification element；
Tables of data identifier generation module 170, the module connect with random identification Element generation module 150, are configured as: pressing
Sighting target knows the combination that marker element Yu random identification element is fixed in element combinations rule, generates tables of data mark；
Sending module 190, the module connect with tables of data identifier generation module 170, are configured as: by data generated
Table mark is sent to operation system, and tables of data is identified the major key as created tables of data.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
It is appreciated that these modules can by hardware, software, or a combination of both realize.When realizing in hardware
When, these modules may be embodied as one or more hardware modules, such as one or more specific integrated circuits.When with software side
When formula is realized, these modules may be embodied as the one or more computer programs executed on the one or more processors, example
The program being stored in as performed by the central processing unit 270 of Fig. 2 in memory 250.
In one embodiment, as shown in figure 8, acquisition module 130 includes:
System banner searching unit 131, is configured as: request is generated in response to mark, in the system of mark generation system
The lookup of system banner is carried out in enrolled set；
Acquiring unit 132, is configured as: if finding system banner, acquisition is stepped on system banner associated storage
Remember information.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
In one embodiment, including multiple constant mark elements and according to number in register information corresponding to each operation system
The sequencing information that multiple constant mark element sequences are carried out according to table mark quantitative range, identifying in generation system includes for each industry
Business system has generated the quantity information of tables of data mark, tables of data identifier generation module 170, comprising:
Quantity information acquiring unit, is configured as: obtaining mark generation system is that operation system generates tables of data mark
Quantity information；
Constant mark element determination unit, is configured as: data to be generated are determined in sequencing information according to quantity information
Quantitative range where table mark, is determined as tables of data to be generated for constant mark element corresponding to identified quantitative range
Constant mark element in mark；
Tables of data identification generation unit, is configured as: according to marker element rule of combination combining random marker element and institute
Determining constant mark element generates tables of data mark.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
In one embodiment, the device of tables of data mark is generated further include:
Searching module is configured as: tables of data generated mark is identified lookup in logo collection；
Execution module is configured as: if searching module, which is not found, identifies identical mark with tables of data generated,
Then continue to execute corresponding step by sending module 190；And
If searching module, which is found, identifies identical mark with tables of data generated, it is back to random identification element
Generation module 150 regenerates random identification element to execute corresponding step by random identification Element generation module 150, with root
Tables of data mark is regenerated according to the random identification element regenerated.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
In one embodiment, logo collection is constituted by having generated the corresponding cryptographic Hash of tables of data mark, generates tables of data
The device of mark further include:
Cryptographic Hash generation module, is configured as: the cryptographic Hash of generated tables of data mark being calculated by hash algorithm；
Searching module includes:
Searching unit is configured as: being identified and is looked into logo collection according to the cryptographic Hash that generated tables of data identifies
It looks for.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
In one embodiment, the device of tables of data mark is generated further include:
It receives and writing module, be configured as: operation system receives tables of data mark, and by received tables of data mark
Know and is written in created tables of data.
The function of modules and the realization process of effect are specifically detailed in above-mentioned generation tables of data mark in above-mentioned apparatus
The realization process of step is corresponded in method, details are not described herein.
Optionally, the disclosure also provides a kind of device of generation tables of data mark, which can be used for implementing shown in Fig. 1
In the server 200 of environment, execute any of the above embodiment of the method shown in generation tables of data mark method whole or
Part steps.As shown in figure 9, the device for generating tables of data mark includes:
Processor 1001；
Memory 1002 for 1001 executable instruction of storage processor；
Wherein, the method in any of the above embodiment is realized when executable instruction is executed by processor 1001.It can wherein hold
Row instruction is such as computer-readable instruction, and when processor 1001 executes, processor between memory by being connect
Communication line/bus 1003 reads the computer-readable instruction being stored in memory.
The concrete mode that the processor of device in the embodiment executes operation is identified in the related generation tables of data
Method embodiment in perform detailed description, no detailed explanation will be given here.
In the exemplary embodiment, a kind of computer readable storage medium is additionally provided, computer program is stored thereon with,
The method of either method embodiment as above is realized when computer program is executed by processor.Wherein computer readable storage medium example
It such as include the memory 250 of computer program, above-metioned instruction can be executed by the central processing unit 270 of server 200 on to complete
State the method for generating tables of data mark.
Processor in the embodiment executes the concrete mode of operation in the method identified in relation to the generation tables of data
Embodiment in perform detailed description, no detailed explanation will be given here.
It should be understood that the present invention is not limited to the precise structure already described above and shown in the accompanying drawings, and
And various modifications and change can executed without departing from the scope.The scope of the present invention is limited only by the attached claims.
Claims (10)
1. a kind of method for generating tables of data mark, which is characterized in that be applied to mark generation system, comprising:
It receives operation system and operates initiated mark generation request according to tables of data creation；
It generates and requests in response to the mark, the register information of the operation system, institute are obtained from the mark generation system
State the fixed mark that register information includes random identification Element generation rule, marker element rule of combination and the mark operation system
Know element；
Random identification element is generated according to the random identification create-rule；
The combination of the constant mark element Yu the random identification element is carried out according to the marker element rule of combination, is generated
Tables of data mark；
Tables of data generated mark is sent to the operation system, the tables of data is identified and is used as created tables of data
Major key.
2. the method according to claim 1, wherein it includes that the operation system institute is right that the mark, which generates request,
The system banner answered, described generate in response to the mark are requested, and obtain the operation system from the mark generation system
Register information, comprising:
It generates and requests in response to the mark, carry out looking into for the system banner in the system registry set of mark generation system
It looks for；
If finding the system banner, the register information with the system banner associated storage is obtained.
3. the method according to claim 1, wherein including in register information corresponding to each operation system
Multiple constant mark elements and the sequence letter that the multiple constant mark element sequence is carried out according to tables of data mark quantitative range
Breath, described identify includes the quantity information that tables of data mark has been generated for each operation system in generation system, described according to institute
The combination that marker element rule of combination carries out the constant mark element Yu the random identification element is stated, tables of data mark is generated
Know, comprising:
Obtaining the mark generation system is the quantity information that the operation system generates tables of data mark；
The quantitative range where tables of data to be generated mark is determined in the sequencing information according to the quantity information, by really
Constant mark element corresponding to fixed quantitative range is determined as the constant mark element in tables of data mark to be generated；
The random identification element and identified constant mark element are combined according to the marker element rule of combination, generates institute
State tables of data mark.
4. the method according to claim 1, wherein the mark generation system includes having generated number for storing
It is described that tables of data generated mark is sent to before the operation system according to the logo collection that table identifies, further includes:
Tables of data generated mark is identified lookup in the logo collection；
Identical mark is identified with the tables of data generated if do not found, execution identifies tables of data generated
The step of being sent to the operation system；And
Identical mark is identified with the tables of data generated if found, is back to and is generated according to the random identification
Rule generates the step of random identification element, to regenerate tables of data mark according to the random identification element regenerated.
5. according to the method described in claim 4, it is characterized in that, the logo collection is as having generated corresponding to tables of data mark
Cryptographic Hash constitute, it is described to carry out the constant mark element and random identification member according to the marker element rule of combination
The combination of element, after generation tables of data identifies, further includes:
The cryptographic Hash of generated tables of data mark is calculated by hash algorithm；
It is described to search tables of data generated mark in the logo collection, comprising:
Lookup is identified in the logo collection according to the cryptographic Hash of the generated tables of data mark.
6. the method according to claim 1, wherein described be sent to the industry for tables of data generated mark
After business system, further includes:
The operation system receives the tables of data mark, and created number is written in received tables of data mark
According in table.
7. a kind of device for generating tables of data mark, which is characterized in that be applied to mark generation system, comprising:
Receiving module is configured as: being received operation system and is operated initiated mark generation request according to tables of data creation；
Module is obtained, is configured as: generating and requests in response to the mark, obtain the business from the mark generation system
The register information of system, the register information include random identification Element generation rule, marker element rule of combination and fixation
Marker element；
Random identification Element generation module, is configured as: generating random identification element according to the random identification create-rule；
Tables of data identifier generation module, is configured as: carrying out the constant mark element according to the marker element rule of combination
With the combination of the random identification element, tables of data mark is generated；
Sending module is configured as: tables of data generated mark being sent to the operation system, by the tables of data mark
Know the major key as created tables of data.
8. device according to claim 7, which is characterized in that the acquisition module includes:
System banner searching unit, is configured as: generating and requests in response to the mark, in the system registry of mark generation system
The lookup of the system banner is carried out in set；
Acquiring unit is configured as: if finding the system banner, acquisition is stepped on the system banner associated storage
Remember information.
9. a kind of device for generating tables of data mark characterized by comprising
Processor；And
Memory is stored with computer-readable instruction on the memory, and the computer-readable instruction is held by the processor
Such as method described in any one of claims 1 to 6 is realized when row.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
Such as method described in any one of claims 1 to 6 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811534101.1A CN109710609B (en) | 2018-12-14 | 2018-12-14 | Method and device for generating data table identification |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811534101.1A CN109710609B (en) | 2018-12-14 | 2018-12-14 | Method and device for generating data table identification |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109710609A true CN109710609A (en) | 2019-05-03 |
| CN109710609B CN109710609B (en) | 2023-08-08 |
Family
ID=66256532
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811534101.1A Active CN109710609B (en) | 2018-12-14 | 2018-12-14 | Method and device for generating data table identification |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109710609B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220691A (en) * | 2021-05-31 | 2021-08-06 | 北京互金新融科技有限公司 | Database table creating method and device for database table, and electronic equipment |
| CN114281889A (en) * | 2021-11-15 | 2022-04-05 | 道和邦(广州)电子信息科技有限公司 | SMG-VME-DSSS data sharing slicing service |
| CN115048356A (en) * | 2022-06-16 | 2022-09-13 | 平安银行股份有限公司 | Database ID generation method, electronic device and storage medium |
| CN115510815A (en) * | 2022-11-17 | 2022-12-23 | 山东未来网络研究院(紫金山实验室工业互联网创新应用基地) | Rule-based identification generation method and apparatus |
| CN115982205A (en) * | 2023-02-01 | 2023-04-18 | 西安电子科技大学 | A massive multivariate data intelligent collection system and collection method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117535B1 (en) * | 2001-12-14 | 2006-10-03 | Microsoft Corporation | Software-generated machine identifier |
| US20160162496A1 (en) * | 2014-12-09 | 2016-06-09 | Xurmo Technologies Pvt. Ltd. | Computer implemented system and method for investigative data analytics |
| CN106897335A (en) * | 2016-06-28 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of storage method of business datum, the generation method of record identifier and device |
| CN108694218A (en) * | 2017-04-12 | 2018-10-23 | 大唐移动通信设备有限公司 | A kind of method and apparatus data write-in and read |
-
2018
- 2018-12-14 CN CN201811534101.1A patent/CN109710609B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7117535B1 (en) * | 2001-12-14 | 2006-10-03 | Microsoft Corporation | Software-generated machine identifier |
| US20160162496A1 (en) * | 2014-12-09 | 2016-06-09 | Xurmo Technologies Pvt. Ltd. | Computer implemented system and method for investigative data analytics |
| CN106897335A (en) * | 2016-06-28 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of storage method of business datum, the generation method of record identifier and device |
| CN108694218A (en) * | 2017-04-12 | 2018-10-23 | 大唐移动通信设备有限公司 | A kind of method and apparatus data write-in and read |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220691A (en) * | 2021-05-31 | 2021-08-06 | 北京互金新融科技有限公司 | Database table creating method and device for database table, and electronic equipment |
| CN113220691B (en) * | 2021-05-31 | 2024-02-06 | 北京互金新融科技有限公司 | Database table creation method, database table creation device and electronic equipment |
| CN114281889A (en) * | 2021-11-15 | 2022-04-05 | 道和邦(广州)电子信息科技有限公司 | SMG-VME-DSSS data sharing slicing service |
| CN115048356A (en) * | 2022-06-16 | 2022-09-13 | 平安银行股份有限公司 | Database ID generation method, electronic device and storage medium |
| CN115510815A (en) * | 2022-11-17 | 2022-12-23 | 山东未来网络研究院(紫金山实验室工业互联网创新应用基地) | Rule-based identification generation method and apparatus |
| CN115982205A (en) * | 2023-02-01 | 2023-04-18 | 西安电子科技大学 | A massive multivariate data intelligent collection system and collection method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109710609B (en) | 2023-08-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109710609A (en) | Generate the method and device of tables of data mark | |
| US11362840B2 (en) | Methods, apparatuses, devices and systems for backtracking service behavior | |
| CN109558748B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN108900464B (en) | Electronic device, block chain-based data processing method, and computer storage medium | |
| WO2020233219A1 (en) | Abnormal problem locating method and device, apparatus and computer readable storage medium | |
| US10073916B2 (en) | Method and system for facilitating terminal identifiers | |
| CN107920112B (en) | Configuration file pushing method supporting gray mode, central server and storage medium | |
| CN107948152B (en) | Information storage method, information acquisition method, information storage device, information acquisition device and information acquisition equipment | |
| CN109873804A (en) | Behavior-based service identification method, apparatus, device, and readable storage medium | |
| CN109347839B (en) | Centralized password management method and device, electronic equipment and computer storage medium | |
| TWI627554B (en) | Methods for blocking unauthorized applications and apparatuses using the same | |
| US20160048703A1 (en) | Securing integrity and consistency of a cloud storage service with efficient client operations | |
| US10282120B2 (en) | Method, apparatus and system for inserting disk | |
| CN111078559A (en) | Method, device, medium and computer equipment for extracting function calls in java code | |
| CN111597567A (en) | Data processing method, data processing device, node equipment and storage medium | |
| US20180123791A1 (en) | Highly available and reliable secret distribution infrastructure | |
| CN112507298A (en) | User authentication method, device, server and storage medium | |
| CN115238310A (en) | Data encryption and decryption method, device, equipment and storage medium | |
| CN110619022B (en) | Node detection method, device, equipment and storage medium based on block chain network | |
| CN115934254A (en) | Deployment method, device, server and medium of elastic search engine cluster | |
| CN107276998B (en) | OpenSSL-based performance optimization method and device | |
| CN113221154A (en) | Service password obtaining method and device, electronic equipment and storage medium | |
| JP2014524210A (en) | Generate variable length nonce | |
| CN105787359A (en) | Course guarding method and device | |
| CN115130114B (en) | Gateway secure starting method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |