CN109597853A - Business scenario element sequence generation method, device, medium and computer equipment - Google Patents
Business scenario element sequence generation method, device, medium and computer equipment Download PDFInfo
- Publication number
- CN109597853A CN109597853A CN201811232383.XA CN201811232383A CN109597853A CN 109597853 A CN109597853 A CN 109597853A CN 201811232383 A CN201811232383 A CN 201811232383A CN 109597853 A CN109597853 A CN 109597853A
- Authority
- CN
- China
- Prior art keywords
- business scenario
- sequence number
- sequence
- business
- oracle database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000004590 computer program Methods 0.000 claims description 3
- 230000015572 biosynthetic process Effects 0.000 abstract description 4
- 101001023021 Homo sapiens LIM domain-binding protein 3 Proteins 0.000 description 60
- 102100035112 LIM domain-binding protein 3 Human genes 0.000 description 60
- 230000006870 function Effects 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 230000007704 transition 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
Abstract
The present invention provides a kind of business scenario element sequence generation method, device, computer storage medium and computer equipment based on oracle database；This method comprises: receiving the sequence number acquisition request of the business scenario element of oracle database, business scenario mark is carried in sequence number acquisition request；Obtain the business scenario mark in the sequence number acquisition request；It is identified according to the business scenario, generates the Format Type business scenario element sequence number corresponding with business scenario mark of the business scenario element.Technical solution through the invention, it can be realized while formation sequence format meets the sequence number of different business scene requirement, each business scenario can be used directly after obtaining sequence number, be converted without by sequence number, improved and used the efficiency of sequence number in business scenario.
Description
Technical field
The present invention relates to database serial number fields, specifically, the present invention relates to a kind of based on oracle database
Business scenario element sequence generation method, device, computer readable storage medium and computer equipment.
Background technique
In distributed system, often there is the demand of the sequence number for being provided simultaneously with uniqueness and order.It is being distributed
Typically include multiple business scene in formula system, and different business scenarios is because of itself scene characteristics, for sequence number
Format has particular/special requirement.
And at present in the generation scheme of sequence number, the format of sequence number is usually only a kind of, such as metric sequence number, and
Business scenario just needs to handle the format of sequence number after obtaining sequence number, so that the format of sequence number meets business field
Requirement of the scape itself to sequence number format.
Therefore a kind of sequence number generation method that can satisfy different business scene requirement is needed, to improve in business scenario
Use the efficiency of sequence number.
Summary of the invention
The present invention in view of the shortcomings of the prior art, provides a kind of business scenario element sequence based on oracle database
Number generation method, device, computer readable storage medium and computer equipment, can be realized while formation sequence format meets
The sequence number of different business scene requirement, each business scenario can be used directly after obtaining sequence number, without by sequence number into
Row conversion, improves and uses the efficiency of sequence number in business scenario.
The embodiment of the present invention provides a kind of business scenario element sequence based on oracle database according to first aspect
Number generation method, comprising:
The sequence number acquisition request of the business scenario element of oracle database is received, carries industry in sequence number acquisition request
Business scene identity；
Obtain the business scenario mark in the sequence number acquisition request；
It is identified according to the business scenario, the Format Type for generating the business scenario element is corresponding with business scenario mark
Business scenario element sequence number.
Further, described to be identified according to the business scenario, generate the Format Type and industry of the business scenario element
The corresponding business scenario element sequence number of scene identity of being engaged in, comprising:
Search sequence allocation table, determination currently can assigned sequence number；
By it is described currently can assigned sequence number be converted to Format Type corresponding with business scenario mark, obtain Format Type with
Business scenario identifies corresponding business scenario element sequence number.
Further, sequence number allocation table record can assigned sequence item and can assigned sequence maximum value
?；
Wherein, the search sequence allocation table, determining currently can assigned sequence number, comprising:
If it is described can assigned sequence item value no more than it is described can assigned sequence maximum value item value, will described in can
The value of assigned sequence item is determined as currently can assigned sequence number；In the sequence number allocation table can assigned sequence item
Value add 1；
If it is described can assigned sequence item value be greater than it is described can assigned sequence maximum value item value, to oracle number
It transmits Sequence Number acquisition request according to library, and currently can assigned sequence number according to the determination of the feedback message of oracle database.
It further, include indicating what this was requested in the sequence number acquisition request sent to oracle database
The sequence number step value of sequence number quantity；
It is described according to the feedback message of oracle database determine currently can assigned sequence number, step includes:
The feedback message of oracle database is received, the feedback message includes the sequence number of oracle database feedback
Value；
By in sequence number allocation table can assigned sequence item value be updated to oracle database feedback sequence number value,
By can the value of assigned sequence maximum value item be updated to the sequence number value of oracle database feedback and the sequence number walks
The sum of long value；
By in updated sequence number allocation table can the value of assigned sequence item be determined as currently can assigned sequence number；
In the sequence number allocation table can the value of assigned sequence item add 1；.
Further, described to be identified according to business scenario, generate Format Type business field corresponding with business scenario mark
Scape element sequence number, later, further includes:
The business scenario element comprising business scenario element sequence number with same business scenario element is accumulated one
A business scenario element group focuses on the business scenario element group.
Further, each business scenario is identified with unique business scenario, and each business scenario includes several business
Situation elements, each business scenario identify a corresponding Format Type.
It further, include identification information and series number information in the Format Type；
It is described by it is described currently can assigned sequence number be converted to Format Type corresponding with business scenario mark, comprising:
Obtain the business scenario and identify corresponding Format Type, by it is described currently can assigned sequence number be converted to the lattice
Formula type；
Accumulating one with the business scenario element comprising business scenario element sequence number that same business scenario identifies
A business scenario element group focuses on the business scenario element group, comprising:
According to Format Type, the business scenario element sequence number with same Format Type is filtered out, the industry filtered out
The corresponding business scenario element of business situation elements sequence number accumulates a business scenario element group；It is unified to include to Format Type
Identification information and/or series number information modify.
The embodiment of the present invention provides a kind of business scenario element sequence based on oracle database according to second aspect
Number generating means, comprising:
Acquisition request receiving module, the sequence number acquisition request of the business scenario element for receiving oracle database,
Business scenario mark is carried in sequence number acquisition request；
Scene identity obtains module, for obtaining the mark of the business scenario in the sequence number acquisition request；
It is corresponding with business scenario mark to generate Format Type for identifying according to business scenario for sequence number generation module
Business scenario element sequence number.
The embodiment of the present invention provides a kind of computer readable storage medium according to the third aspect, is stored thereon with computer
Program, the program realize the above-mentioned business scenario element sequence number generation side based on oracle database when being executed by processor
Method.
The embodiment of the present invention provides a kind of computer equipment according to fourth aspect, and the computer equipment includes:
One or more processors；
Storage device, for storing one or more programs；
When one or more of programs are executed by one or more of processors, so that one or more of processing
Device realizes the above-mentioned business scenario element sequence generation method based on oracle database.
In embodiments of the present invention, by receiving the sequence number acquisition request of the business scenario element of oracle database,
Business scenario mark is carried in sequence number acquisition request, obtains the business scenario mark in the sequence number acquisition request later,
It is finally identified according to business scenario, generates Format Type business scenario element sequence number corresponding with business scenario mark, it can
Realization while formation sequence format meet the sequence number of different business scene requirement, and each business scenario obtains energy after sequence number
It is enough directly to use, it is converted without by sequence number, improves and use the efficiency of sequence number in business scenario.
The additional aspect of the present invention and advantage will be set forth in part in the description, these will become from the following description
Obviously, or practice through the invention is recognized.
Detailed description of the invention
Above-mentioned and/or additional aspect and advantage of the invention will become from the following description of the accompanying drawings of embodiments
Obviously and it is readily appreciated that, in which:
Fig. 1 is the business scenario element sequence generation method stream based on oracle database of one embodiment of the invention
Journey schematic diagram；
Fig. 2 is the business scenario element sequence generating means based on oracle database of one embodiment of the invention
Structural schematic diagram；
Fig. 3 is the structural schematic diagram of the computer equipment of an embodiment of the present invention.
Specific embodiment
The embodiment of the present invention is described below in detail, examples of the embodiments are shown in the accompanying drawings, wherein from beginning to end
Same or similar label indicates same or similar element or element with the same or similar functions.Below with reference to attached
The embodiment of figure description is exemplary, and for explaining only the invention, and is not construed as limiting the claims.
The business scenario element sequence generation method based on oracle database that the embodiment of the invention provides a kind of, is answered
For in distributed system, including at least one application server in the distributed system.
Below from the angle of application server, describe in detail in conjunction with attached drawing to a specific embodiment of the invention.
As shown in Figure 1, in one embodiment, a kind of business scenario element sequence number generation based on oracle database
Method, comprising the following steps:
S110: receiving the sequence number acquisition request of the business scenario element of oracle database, in sequence number acquisition request
Carry business scenario mark.
In embodiments of the present invention, the distributed system includes multiple application servers, and by the generation of sequence number
Operation is transferred in each application server from oracle database, i.e., all business scenario elements in distributed system are to answering
With server request serial number without to database request sequence number, database only needs to provide index for each application server
Value, guarantees that the sequence number of the distributed to business scenario element of each application server can have only in entire distributed system
One property, and each application server is responsible for executing the operation of sequence number monotonic increase, and is receiving sequence number acquisition request
Feedback sequence number afterwards.By the cooperation of database and application server, it can provide and be provided simultaneously with uniquely for multiple business scenarios
The sequence number of property, order, and improve to the feedback speed of sequence number acquisition request.
S120: the business scenario mark in the sequence number acquisition request is obtained.
S130: identifying according to the business scenario, generates the Format Type and business scenario mark of the business scenario element
Know corresponding business scenario element sequence number.
Specifically, in one embodiment, step S130: it is described to be identified according to the business scenario, generate the industry
The Format Type business scenario element sequence number corresponding with business scenario mark of business situation elements, specifically includes the following steps:
S1301: search sequence allocation table, determination currently can assigned sequence number.
Each application server can all safeguard a sequence number allocation table, include that can distribute in the sequence number allocation table
Sequence number item and can two projects of assigned sequence maximum value item.
Specifically, step S1301: search sequence allocation table, determine currently can assigned sequence number, including following step
It is rapid:
If it is described can assigned sequence item value no more than it is described can assigned sequence maximum value item value, will described in can
The value of assigned sequence item is determined as currently can assigned sequence number；In the sequence number allocation table can assigned sequence item
Value add 1；
If it is described can assigned sequence item value be greater than it is described can assigned sequence maximum value item value, to oracle number
It transmits Sequence Number acquisition request according to library, and currently can assigned sequence number according to the determination of the feedback message of oracle database.
When application server receives the sequence number acquisition request from business scenario, can first judge can assigned sequence number
Whether be greater than can assigned sequence maximum value, if can assigned sequence number no more than can assigned sequence maximum value, application clothes
Business device can assigned sequence number feed back to the request, and after feeding back, by it is original can assigned sequence number value plus 1, replacement is former
First can assigned sequence number.For example, after application server receives sequence number acquisition request, judgement can on the basis of above-mentioned example
Assigned sequence number value is 101, and can assigned sequence maximum value be 200, then can assigned sequence number value 101 feed back to this and ask
Ask, later by assigned sequence number value 101 plus 1 generate it is new can assigned sequence number value 102, and by can assigned sequence item value
It is updated to 102.If can assigned sequence number be greater than can assigned sequence maximum value, application server do not distribute current
Sequence number is allocated, and sequence number acquisition request can be issued to database, and after receiving the sequence number of Database Feedback,
Update original sequence number allocation table, then from updated sequence number allocation table obtain can assigned sequence number feed back to this
Request.For example, on the basis of above-mentioned example, original sequence number allocation table can assigned sequence number value be 201, sequence can be distributed
Row number maximum value is 200, by judgement discovery it is original can assigned sequence number value be greater than can assigned sequence maximum value, then answering
With server to database request sequence number, if the sequence number step-length specifically requested is 50, and the sequence number that database returns
It is 500, then for application server after receiving the sequence number of Database Feedback, original sequence number allocation table is updated to can
Assigned sequence number value is 500, can assigned sequence maximum value be 549, and feed back to the sequence number not instead of 201 of the request,
500。
It in one embodiment, include indicating this in the sequence number acquisition request sent to oracle database
The sequence number step value of the sequence number quantity of request；
It is described according to the feedback message of oracle database determine currently can assigned sequence number, step includes:
The feedback message of oracle database is received, the feedback message includes the sequence number of oracle database feedback
Value；
By in sequence number allocation table can assigned sequence item value be updated to oracle database feedback sequence number value,
By can the value of assigned sequence maximum value item be updated to the sequence number value of oracle database feedback and the sequence number walks
The sum of long value；
By in updated sequence number allocation table can the value of assigned sequence item be determined as currently can assigned sequence number；
In the sequence number allocation table can the value of assigned sequence item add 1.
Specifically, the sequence number value of application server distribution is not random value, but is needed first to oracle database
A sequence number is requested, and assigned sequence is come with the Serial No. basis that oracle is fed back, application server is sent to oracle
Request in further include sequence step value, after oracle receives the request of application server, feeding back to application server one
After sequence, this sequence step value also will record, when oracle receives the request of application server again, the sequence number value of feedback
It is exactly the sequence step value that last time feedback sequence number adds last registration, being equivalent to application server is to request one to oracle
Criticize sequence number.For example, database receives the sequence number acquisition request an of application server, the sequence number step-length in request is
100, if Database Feedback is 101 to the sequence number of the application server, receive sequence number acquisition request when institute next time
The sequence number value of feedback is equal to 201, i.e. sum of the last time feedback sequence number value 101 plus sequence number step-length 100.It needs to illustrate
It is that this request can come from being the application server for last time sending request, is also possible to other application server, so
Oracle database can guarantee the sequence that the sequence number that each application server is distributed will not be distributed with other application server
Row number repeats.
S1302: by it is described currently can the Format Type of assigned sequence number be converted to format corresponding with business scenario mark
Type obtains Format Type business scenario element sequence number corresponding with business scenario mark.
Certain business scenarios have particular/special requirement for the type of sequence number, for example, some business scenarios are needed in sequence number
The upper date is spelled in beginning, and some business scenarios need to be converted to sequence number into character string type etc..In the past, business scenario needs made
When with sequence number, need to oracle database request serial number, however the sequence number of oracle feedback is metric integer,
Business scenario converts the type of sequence number further according to the requirement of oneself after the sequence number for receiving oracle feedback,
For example the oracle sequence number fed back is converted into character string type, or start in sequence number and spell the upper date.And this programme
By in the generation transition of operation to application server of sequence number, to reduce the load in oracle performance, i.e. business scenario is being needed
When using sequence number, to application server request serial number rather than to oracle request serial number；And application service
Device also undertakes the task of conversion sequence type so that business scenario obtain application server feedback sequence number when, directly
Using sequence number without being converted to sequence number.
Specifically, application server safeguards one for determining the table of sequence number translation type, and table includes each industry
Business scene identity, and serial number type corresponding with each business scenario requirement；Each business scenario is sent to application service
It identifies in the sequence number acquisition request of device comprising business scenario, after application server receives sequence number acquisition request, generates
Sequence number, the business scenario mark in acquisition request, finds corresponding sequence number according to business scenario mark from table later
Types entail requires to judge whether that the type by the sequence number of generation is needed to convert, if desired, then according to serial number type
The type of the sequence number of generation is converted to the type for meeting serial number type requirement, and the sequence number after conversion is fed back into phase
The request answered；If not needing, the sequence number of generation is directly fed back into corresponding request.
For example, application server receive comprising A business scenario mark sequence number acquisition request after, formation sequence number
100, it determines that corresponding serial number type requirement is date+sequence number from table according to A business scenario mark, then obtains and work as
The preceding date is 20180525, and is spliced to the beginning of initial sequence number 100, generates the sequence number that converted type
20180525100, then the sequence number is fed back into the sequence number acquisition request.
In another embodiment, step S130: it is described to be identified according to business scenario, generate Format Type and business field
Scape identifies corresponding business scenario element sequence number, later further include:
The business scenario element comprising business scenario element sequence number with same business scenario element is accumulated one
A business scenario element group focuses on the business scenario element group.
For example, as a coupon group, statistics has issued how many coupons or coupons the element of coupon
Total value；Because being Same Scene, therefore it is convenient for centralized calculation, improves the treatment effeciency of similar scene.
Specifically, each business scenario is identified with unique business scenario, and each business scenario includes several business fields
Scape element, each business scenario identify a corresponding Format Type.
It in a distributed system, include multiple business scene, each business scenario has the format of sequence number
Different requirements.For example the business scenario of short message is sent, the call format for sequence number is, then the beginning of sequence number is spliced
Time point at that time, such as the Format Type of 20180505+ sequence number.
It specifically, in one embodiment, include identification information and series number information in the Format Type；
It is described by it is described currently can the Format Type of assigned sequence number be converted to format class corresponding with business scenario mark
Type, comprising:
Obtain the business scenario and identify corresponding Format Type, by it is described currently can assigned sequence number be converted to the lattice
Formula type；
Accumulating one with the business scenario element comprising business scenario element sequence number that same business scenario identifies
A business scenario element group focuses on the business scenario element group, comprising:
According to Format Type, the business scenario element sequence number with same Format Type is filtered out, the industry filtered out
The corresponding business scenario element of business situation elements sequence number accumulates a business scenario element group；It is unified to include to Format Type
Identification information and/or series number information modify.
Technical solution for a better understanding of the present invention, the present invention also provides a kind of business based on oracle database
Situation elements sequence number generating means, as shown in Fig. 2, comprising the following modules:
Acquisition request receiving module 110 is asked for receiving the sequence number acquisition of business scenario element of oracle database
It asks, business scenario mark is carried in sequence number acquisition request.
Scene identity obtains module 120, for obtaining the mark of the business scenario in the sequence number acquisition request.
Sequence number generation module 130 generates the format of the business scenario element for identifying according to the business scenario
Type business scenario element sequence number corresponding with business scenario mark.
Specifically, the sequence number generation module 130 includes following submodule:
Sequence number determines submodule 1301, is used for search sequence allocation table, determination currently can assigned sequence number；
Specifically, sequence number allocation table record can assigned sequence item and can assigned sequence maximum value item；
Specifically, the sequence number determines that submodule 1301 includes:
First ray determination unit, for when it is described can assigned sequence item value no more than it is described can assigned sequence number
When the value of maximum value item, by it is described can the value of assigned sequence item be determined as currently can assigned sequence number；The sequence number point
With in table can the value of assigned sequence item add 1；
Second sequence number determining unit, for when it is described can assigned sequence item value be greater than it is described can assigned sequence number most
When the value of big value item, transmit Sequence Number acquisition request to oracle database, and true according to the feedback message of oracle database
It can assigned sequence number before settled.
It in one embodiment, include indicating this in the sequence number acquisition request sent to oracle database
The sequence number step value of the sequence number quantity of request；
Second sequence number determining unit, comprising:
Feedback message receiving subelement, for receiving the feedback message of oracle database, the feedback message includes
The sequence number value of oracle database feedback；
Table update subelement, for by sequence number allocation table can the value of assigned sequence item be updated to oracle number
According to the sequence number value that library is fed back, by can the value of assigned sequence maximum value item be updated to the sequence of oracle database feedback
Number value with the sequence number step value and；
Sequence number determines subelement, for by updated sequence number allocation table can assigned sequence item value it is true
Being set to currently can assigned sequence number；In the sequence number allocation table can the value of assigned sequence item add 1.
Format Type transform subblock 1302, for by it is described currently can the Format Type of assigned sequence number be converted to and industry
The corresponding Format Type of scene identity of being engaged in, obtains Format Type business scenario element sequence number corresponding with business scenario mark.
In one embodiment, the business scenario element sequence generating means based on oracle database, also
Including element group processing module, for the business comprising business scenario element sequence number with same business scenario element
Situation elements accumulate a business scenario element group, focus on to the business scenario element group.
Specifically, each business scenario is identified with unique business scenario, and each business scenario includes several business fields
Scape element, each business scenario identify a corresponding Format Type.
It in a distributed system, include multiple business scene, each business scenario has the format of sequence number
Different requirements.For example the business scenario of short message is sent, the call format for sequence number is, then the beginning of sequence number is spliced
Time point at that time, such as the Format Type of 20180505+ sequence number.
It specifically, in one embodiment, include identification information and series number information in the Format Type；
The Format Type transform subblock 1302, comprising:
Format Type converting unit identifies corresponding Format Type for obtaining the business scenario, currently may be used described
Assigned sequence number is converted to the Format Type；
Element group processing module is also used to filter out the business scenario member with same Format Type according to Format Type
The corresponding business scenario element of business scenario element sequence number filtered out is accumulated a business scenario element by prime sequences number
Group；The unified identification information and/or series number information for including to Format Type is modified.
It should be noted that the business scenario element sequence life provided in an embodiment of the present invention based on oracle database
It can be realized what the above-mentioned business scenario element sequence generation method embodiment based on oracle database was realized at device
Function, the specific implementation of function is referring to retouching in the above-mentioned business scenario element sequence generation method based on oracle database
It states, details are not described herein.
The embodiment of the present invention also provides a kind of computer readable storage medium, is stored thereon with computer program, the program
The above-mentioned business scenario element sequence generation method based on oracle database is realized when being executed by processor.Wherein, described
Storage medium includes but is not limited to any kind of disk (including floppy disk, hard disk, CD, CD-ROM and magneto-optic disk), ROM
(Read-Only Memory, read-only memory), RAM (Random AcceSS Memory, immediately memory), EPROM
(EraSable Programmable Read-Only Memory, Erarable Programmable Read only Memory), EEPROM
(Electrically EraSable Programmable Read-Only Memory, Electrically Erasable Programmable Read-Only Memory),
Flash memory, magnetic card or light card.It is, storage medium includes the form by equipment (for example, computer) can read
Any medium of storage or transmission information.It can be read-only memory, disk or CD etc..
The embodiment of the present invention also provides a kind of computer equipment, and the computer equipment includes:
One or more processors 510；
Storage device 520, for storing one or more programs 500,
When one or more of programs 500 are executed by one or more of processors 510, so that one or more
A processor 510 realizes the above-mentioned business scenario element sequence generation method based on oracle database.
It is illustrated in figure 3 the structural schematic diagram of computer equipment of the present invention, including processor 510, storage device 520, defeated
Enter the devices such as unit 530 and display unit 540.It will be understood by those skilled in the art that structure devices shown in Fig. 3 not structure
The restriction of pairs of all computer equipments may include than illustrating more or fewer components, or the certain components of combination.Storage
Device 520 can be used for storing application program 500 and each functional module, and the operation of processor 510 is stored in answering for storage device 520
With program 500, thereby executing the various function application and data processing of equipment.Storage device 520 can be built-in storage or
External memory, or including both built-in storage and external memory.Built-in storage may include read-only memory, programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), flash memory or random storage
Device.External memory may include hard disk, floppy disk, ZIP disk, USB flash disk, tape etc..Storage device disclosed in this invention includes but not
It is limited to the storage device of these types.Storage device 520 disclosed in this invention is only used as example rather than as restriction.
Input unit 530 is used to receive the input of signal, and the correlations such as selection voice document for receiving user's input are asked
It asks.Input unit 530 may include touch panel and other input equipments.Touch panel collects user on it or nearby
Touch operation (for example user uses any suitable objects or attachment such as finger, stylus on touch panel or in touch panel
Neighbouring operation), and corresponding attachment device is driven according to a pre-set procedure；Other input equipments may include but unlimited
In one of physical keyboard, function key (for example playing control button, switch key etc.), trace ball, mouse, operating stick etc. or
It is a variety of.Display unit 540 can be used for showing user input information or be supplied to user information and computer equipment it is each
Kind menu.The forms such as liquid crystal display, Organic Light Emitting Diode can be used in display unit 540.Processor 510 is computer equipment
Control centre be stored in storage by running or executing using the various pieces of various interfaces and the entire computer of connection
Software program and/or module in device 520, and the data being stored in storage device are called, it performs various functions and locates
Manage data.
In one embodiment, computer equipment includes one or more processors 510, and one or more storage dresses
520 are set, one or more application program 500, wherein one or more of application programs 500 are stored in storage device 520
In and be configured as being executed by one or more of processors 510, one or more of application programs 500 are configured to hold
Business scenario element sequence generation method described in row above embodiments based on oracle database.
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other
At least part of the sub-step or stage of step or other steps executes in turn or alternately.
It should be understood that each functional unit in various embodiments of the present invention can be integrated in a processing module,
It can be physically existed alone, can also be integrated in two or more units in a module with each unit.It is above-mentioned integrated
Module both can take the form of hardware realization, can also be realized in the form of software function module.
The above is only some embodiments of the invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of business scenario element sequence generation method based on oracle database characterized by comprising
The sequence number acquisition request of the business scenario element of oracle database is received, carries business field in sequence number acquisition request
Scape mark；
Obtain the business scenario mark in the sequence number acquisition request；
It is identified according to the business scenario, generates the Format Type industry corresponding with business scenario mark of the business scenario element
Business situation elements sequence number.
2. the business scenario element sequence generation method based on oracle database, feature exist as described in claim 1
In described to be identified according to the business scenario, the Format Type for generating the business scenario element is corresponding with business scenario mark
Business scenario element sequence number, comprising:
Search sequence allocation table, determination currently can assigned sequence number；
By it is described currently can the Format Type of assigned sequence number be converted to Format Type corresponding with business scenario mark, obtain lattice
Formula type business scenario element sequence number corresponding with business scenario mark.
3. the business scenario element sequence generation method based on oracle database, feature exist as claimed in claim 2
It can assigned sequence item and can assigned sequence maximum value item in, sequence number allocation table record；
The search sequence allocation table, determining currently can assigned sequence number, comprising:
If it is described can assigned sequence item value no more than it is described can assigned sequence maximum value item value, will described in can distribute
The value of sequence number item is determined as currently can assigned sequence number；In the sequence number allocation table can assigned sequence item value
Add 1；
If it is described can assigned sequence item value be greater than it is described can assigned sequence maximum value item value, to oracle database
Transmit Sequence Number acquisition request, and currently can assigned sequence number according to the determination of the feedback message of oracle database.
4. the business scenario element sequence generation method based on oracle database, feature exist as claimed in claim 3
In the sequence including this sequence number quantity requested of expression in the sequence number acquisition request sent to oracle database
Number step value；
Described determined according to the feedback message of oracle database currently can assigned sequence number, comprising:
The feedback message of oracle database is received, the feedback message includes the sequence number value of oracle database feedback；
By in sequence number allocation table can assigned sequence item value be updated to oracle database feedback sequence number value, can
The value of assigned sequence maximum value item is updated to the sequence number value and the sequence number step value that the oracle database is fed back
Sum；
By in updated sequence number allocation table can the value of assigned sequence item be determined as currently can assigned sequence number；Institute
State in sequence number allocation table can the value of assigned sequence item add 1.
5. the business scenario element sequence generation method based on oracle database, feature exist as described in claim 1
In described to be identified according to the business scenario, the Format Type for generating the business scenario element is corresponding with business scenario mark
Business scenario element sequence number, later, further includes:
Accumulating an industry with the business scenario element comprising business scenario element sequence number that same business scenario identifies
Business situation elements group, focuses on the business scenario element group.
6. such as the described in any item business scenario element sequence generation methods based on oracle database of claim 1 or 5,
It is characterized in that, each business scenario is identified with unique business scenario, each business scenario includes several business scenario members
Element, each business scenario identify a corresponding Format Type.
7. the business scenario element sequence generation method based on oracle database, feature exist as described in claim 1
In comprising identification information and series number information in the Format Type；
It is described by it is described currently can assigned sequence number be converted to Format Type corresponding with business scenario mark, comprising:
Obtain the business scenario and identify corresponding Format Type, by it is described currently can assigned sequence number be converted to the format class
Type；
Accumulating an industry with the business scenario element comprising business scenario element sequence number that same business scenario identifies
Business situation elements group, focuses on the business scenario element group, comprising:
According to Format Type, the business scenario element sequence number with same Format Type is filtered out, the business field filtered out
The corresponding business scenario element of scape element sequence number accumulates a business scenario element group；The unified mark for including to Format Type
Know information and/or series number information is modified.
8. a kind of business scenario element sequence generating means based on oracle database characterized by comprising
Acquisition request receiving module, the sequence number acquisition request of the business scenario element for receiving oracle database, sequence
Business scenario mark is carried in number acquisition request；
Scene identity obtains module, for obtaining the mark of the business scenario in the sequence number acquisition request；
Sequence number generation module, for being identified according to the business scenario, generate the Format Type of the business scenario element with
Business scenario identifies corresponding business scenario element sequence number.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
Such as the described in any item business scenario element sequence number generation sides based on oracle database claim 1-7 are realized when row
Method.
10. a kind of computer equipment, which is characterized in that the computer equipment includes:
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
Now such as the described in any item business scenario element sequence generation methods based on oracle database of claim 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811232383.XA CN109597853B (en) | 2018-10-22 | 2018-10-22 | Business scene element serial number generation method, device, medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811232383.XA CN109597853B (en) | 2018-10-22 | 2018-10-22 | Business scene element serial number generation method, device, medium and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109597853A true CN109597853A (en) | 2019-04-09 |
| CN109597853B CN109597853B (en) | 2024-01-23 |
Family
ID=65958054
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811232383.XA Active CN109597853B (en) | 2018-10-22 | 2018-10-22 | Business scene element serial number generation method, device, medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109597853B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110347887A (en) * | 2019-06-24 | 2019-10-18 | 阿里巴巴集团控股有限公司 | Obtain the method and device of business scenario time series data |
| CN110362573A (en) * | 2019-06-27 | 2019-10-22 | 北京大米科技有限公司 | Recommend generation method, device, electronic equipment and the storage medium of code |
| CN110515956A (en) * | 2019-09-02 | 2019-11-29 | 中国工商银行股份有限公司 | Sequence number acquisition methods, device, system, electronic equipment and storage medium |
| CN110674187A (en) * | 2019-09-24 | 2020-01-10 | 神州数码融信软件有限公司 | Method for generating global unique serial number |
| CN111125569A (en) * | 2019-12-25 | 2020-05-08 | 北京同邦卓益科技有限公司 | Data identifier generation method and device, electronic equipment and medium |
| CN112104743A (en) * | 2020-09-21 | 2020-12-18 | 北京金山云网络技术有限公司 | Sequence generation method and device and electronic equipment |
| CN112948399A (en) * | 2021-05-17 | 2021-06-11 | 太平金融科技服务(上海)有限公司深圳分公司 | Serial number generation method and device, computer equipment and storage medium |
| CN113239088A (en) * | 2021-04-12 | 2021-08-10 | 上海沐融信息科技有限公司 | Asynchronous pre-fetch adjustable sequence number generator acquisition method and device |
| CN113271342A (en) * | 2021-04-27 | 2021-08-17 | 北京沃东天骏信息技术有限公司 | Information processing method and device and storage medium |
| CN113486627A (en) * | 2021-06-01 | 2021-10-08 | 中国人民财产保险股份有限公司 | Single number generation method and device and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060155770A1 (en) * | 2004-11-11 | 2006-07-13 | Ipdev Co. | System and method for time-based allocation of unique transaction identifiers in a multi-server system |
| CN107229555A (en) * | 2017-05-04 | 2017-10-03 | 北京小度信息科技有限公司 | Mark generating method and device |
| CN108243264A (en) * | 2016-12-27 | 2018-07-03 | 中国移动通信有限公司研究院 | A kind of sequence number generation method and system |
| CN108509433A (en) * | 2017-02-23 | 2018-09-07 | 北京京东金融科技控股有限公司 | The method, apparatus and electronic equipment of formation sequence number based on distributed system |
| WO2018177350A1 (en) * | 2017-04-01 | 2018-10-04 | 北京京东尚科信息技术有限公司 | Method and apparatus for providing serial number, electronic device and readable storage medium |
-
2018
- 2018-10-22 CN CN201811232383.XA patent/CN109597853B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060155770A1 (en) * | 2004-11-11 | 2006-07-13 | Ipdev Co. | System and method for time-based allocation of unique transaction identifiers in a multi-server system |
| CN108243264A (en) * | 2016-12-27 | 2018-07-03 | 中国移动通信有限公司研究院 | A kind of sequence number generation method and system |
| CN108509433A (en) * | 2017-02-23 | 2018-09-07 | 北京京东金融科技控股有限公司 | The method, apparatus and electronic equipment of formation sequence number based on distributed system |
| WO2018177350A1 (en) * | 2017-04-01 | 2018-10-04 | 北京京东尚科信息技术有限公司 | Method and apparatus for providing serial number, electronic device and readable storage medium |
| CN108664521A (en) * | 2017-04-01 | 2018-10-16 | 北京京东尚科信息技术有限公司 | A kind of method, apparatus, electronic equipment and readable storage medium storing program for executing that sequence number is provided |
| CN107229555A (en) * | 2017-05-04 | 2017-10-03 | 北京小度信息科技有限公司 | Mark generating method and device |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110347887A (en) * | 2019-06-24 | 2019-10-18 | 阿里巴巴集团控股有限公司 | Obtain the method and device of business scenario time series data |
| CN110362573A (en) * | 2019-06-27 | 2019-10-22 | 北京大米科技有限公司 | Recommend generation method, device, electronic equipment and the storage medium of code |
| CN110515956A (en) * | 2019-09-02 | 2019-11-29 | 中国工商银行股份有限公司 | Sequence number acquisition methods, device, system, electronic equipment and storage medium |
| CN110515956B (en) * | 2019-09-02 | 2022-03-25 | 中国工商银行股份有限公司 | Serial number obtaining method, device and system, electronic equipment and storage medium |
| CN110674187A (en) * | 2019-09-24 | 2020-01-10 | 神州数码融信软件有限公司 | Method for generating global unique serial number |
| CN111125569A (en) * | 2019-12-25 | 2020-05-08 | 北京同邦卓益科技有限公司 | Data identifier generation method and device, electronic equipment and medium |
| CN112104743A (en) * | 2020-09-21 | 2020-12-18 | 北京金山云网络技术有限公司 | Sequence generation method and device and electronic equipment |
| CN112104743B (en) * | 2020-09-21 | 2022-08-16 | 北京金山云网络技术有限公司 | Sequence generation method and device and electronic equipment |
| CN113239088A (en) * | 2021-04-12 | 2021-08-10 | 上海沐融信息科技有限公司 | Asynchronous pre-fetch adjustable sequence number generator acquisition method and device |
| CN113271342A (en) * | 2021-04-27 | 2021-08-17 | 北京沃东天骏信息技术有限公司 | Information processing method and device and storage medium |
| CN113271342B (en) * | 2021-04-27 | 2023-03-07 | 北京沃东天骏信息技术有限公司 | Information processing method and device and storage medium |
| CN112948399B (en) * | 2021-05-17 | 2021-08-03 | 太平金融科技服务(上海)有限公司深圳分公司 | Serial number generation method and device, computer equipment and storage medium |
| CN112948399A (en) * | 2021-05-17 | 2021-06-11 | 太平金融科技服务(上海)有限公司深圳分公司 | Serial number generation method and device, computer equipment and storage medium |
| CN113486627A (en) * | 2021-06-01 | 2021-10-08 | 中国人民财产保险股份有限公司 | Single number generation method and device and electronic equipment |
| CN113486627B (en) * | 2021-06-01 | 2023-08-08 | 中国人民财产保险股份有限公司 | Single number generation method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109597853B (en) | 2024-01-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109597853A (en) | Business scenario element sequence generation method, device, medium and computer equipment | |
| CN111897638B (en) | Distributed task scheduling method and system | |
| CN102035896B (en) | TTCN-3-based distributed testing framework applicable to software system | |
| CN109388537A (en) | Operation information tracking, device and computer readable storage medium | |
| CN104978258A (en) | Software automation test method and system | |
| CN109597834A (en) | Mass data storage means, device, medium and equipment based on redis | |
| CN110928548B (en) | Data processing method and device | |
| CN112099800B (en) | Code data processing method, device and server | |
| CN103577165A (en) | Form generation method and form generator | |
| JP2014194642A (en) | Management method of information processor, and program | |
| CN101727648A (en) | Overtime control method in service system and service system | |
| CN110096521A (en) | Log information processing method and device | |
| CN109672721A (en) | Pushing method for media files, device, server-side and computer readable storage medium | |
| US20090112704A1 (en) | Management tool for efficient allocation of skills and resources | |
| CN111651459A (en) | Service ID generation method based on Redis | |
| CN110471968A (en) | Dissemination method, device, equipment and the storage medium of ETL task | |
| CN113360558B (en) | Data processing method, data processing device, electronic equipment and storage medium | |
| CN110061893B (en) | Fault information acquisition method, server and storage medium | |
| CN107741885B (en) | Transaction and service association method and system based on CS framework | |
| CN107193654B (en) | Resource operation method and device of distributed system and distributed system | |
| CN112380040B (en) | Message processing method and device, electronic equipment and storage medium | |
| CN108984238A (en) | Gesture processing method, device and the electronic equipment of application program | |
| CN103763615A (en) | Interaction method and equipment for episode selection | |
| CN103455521A (en) | Alternating-current contactor type selection processing method and system | |
| CN110990165B (en) | Method for simultaneously working multiple users in multi-channel concurrent transmission system and transmission server |
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 |