CN106033582A - Data processing method and device - Google Patents

Data processing method and device Download PDF

Info

Publication number
CN106033582A
CN106033582A CN201610282562.9A CN201610282562A CN106033582A CN 106033582 A CN106033582 A CN 106033582A CN 201610282562 A CN201610282562 A CN 201610282562A CN 106033582 A CN106033582 A CN 106033582A
Authority
CN
China
Prior art keywords
order
field
order contents
contents
length
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201610282562.9A
Other languages
Chinese (zh)
Inventor
殷雅萍
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SUZHOU JIANGDUODUO TECHNOLOGY Co Ltd
Original Assignee
SUZHOU JIANGDUODUO TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SUZHOU JIANGDUODUO TECHNOLOGY Co Ltd filed Critical SUZHOU JIANGDUODUO TECHNOLOGY Co Ltd
Priority to CN201610282562.9A priority Critical patent/CN106033582A/en
Publication of CN106033582A publication Critical patent/CN106033582A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0633Lists, e.g. purchase orders, compilation or processing
    • G06Q30/0635Processing of requisition or of purchase orders

Abstract

The embodiment of the invention discloses a data processing method and device. The method comprises the steps of acquiring a field format rule corresponding to an order record field in an order content detail list, wherein the order record field is used for describing order content; extracting an original field length corresponding to a field length format in the field format rule, and modifying the original field length into a target field length so as to generate a new field length format, wherein the target field length is larger than the original field length; acquiring target order content corresponding to an order request after the order request is detected, and generating an order record field corresponding to the target order content in the order content detail list according to the new field length format. By the adoption of the method and device, the storage success rate of order content can be increased.

Description

A kind of data processing method and device
Technical field
The present invention relates to Internet technical field, particularly relate to a kind of data processing method and device.
Background technology
Current server side, when receiving the order request that client-side sends, is generally required for order The order contents of request correspondence carries out warehouse-in process.As a example by lottery ticket, when server side joint receives client-side During lottery ticket choosing and selling request (i.e. order request) sent, server side can be by this lottery ticket choosing and selling request correspondence Lottery ticket choosing and selling content (i.e. order contents) be stored in data base, in order to follow-up flow process can be to data Lottery ticket choosing and selling content in storehouse is updated, and wherein, lottery ticket choosing and selling content can include types of lottery ticket, lottery ticket Odds etc..
Along with the variation of order kind, user can select various order to be combined, with generate order please Ask.When the order combined by user is too much, it will the order contents causing order request corresponding is the most complicated, And then cause order contents to exceed the data recording capability of data base, thus order contents is caused to be put in storage unsuccessfully.
Summary of the invention
The embodiment of the present invention provides a kind of data processing method and device, it is possible to solve because of order data amount mistake Cause greatly the technical problem that order warehouse-in is failed.
Embodiments provide a kind of data processing method, including:
Obtain the field format rule that the order record field in order contents details table is corresponding;Described order is remembered Record field is the field for describing order contents;
Extract the original word segment length that the field length form in described field format rule is corresponding, and by described Original word segment length is revised as aiming field length, to generate newer field format length;Described target word segment length Degree is more than described original word segment length;
When order request being detected, obtain the target order contents that described order request is corresponding, and according to institute State newer field format length to generate and described corresponding the ordering of target order contents in described order contents details table Unirecord field.
Wherein, described when order request being detected, obtain the target order contents that described order request is corresponding, And generate in described order contents details table and described target order contents according to described newer field format length Corresponding order record field, including:
When order request being detected, obtain the target order contents that described order request is corresponding;
Add up the quantity of the sub-order contents that described target order contents is comprised;Between every sub-order contents Separate;
Quantity according to described sub-order contents determines the order authority of described target order contents;
When described order authority is lawful authority, according to described newer field format length in described order contents Details table generates the order record field corresponding with described target order contents.
Wherein, the described quantity according to described sub-order contents determines the order authority of described target order contents, Including:
Judge whether the quantity of described sub-order contents exceedes predetermined number threshold value;
If being judged as YES, it is determined that the order authority of described target order contents is illegal authority;
If being judged as NO, it is determined that the order authority of described target order contents is lawful authority.
Wherein, described generate with described in described order contents details table according to described newer field format length The order record field that target order contents is corresponding, including:
Extract the pass built-in value that each sub-order contents in described target order contents is the most corresponding;
According to described field format rule, relevant built-in value is combined, to obtain closing the total character string of built-in value;
Generate in described order contents details table according to described newer field format length and there is described aiming field The field model of length, adds the described pass total character string of built-in value to described field model, to obtain described mesh The order record field that mark order contents is corresponding.
Wherein, also include:
When described order authority is illegal authority, stop generating the order corresponding with described target order contents Record field, and send and carry the illegal order information of described predetermined number threshold value to client, so that Described client resends legal order request according to described predetermined number threshold value;Described legal order request Corresponding order contents has described lawful authority.
Correspondingly, the embodiment of the present invention additionally provides a kind of data processing equipment, including:
Acquisition module, for obtaining the field format rule that the order record field in order contents details table is corresponding Then;Described order record field is the field for describing order contents;
Extract modified module, for extracting corresponding original of the field length form in described field format rule Field length, and described original word segment length is revised as aiming field length, to generate newer field length lattice Formula;Described aiming field length is more than described original word segment length;
Field generation module, for when order request being detected, obtains the target that described order request is corresponding Order contents, and generate in described order contents details table and described mesh according to described newer field format length The order record field that mark order contents is corresponding.
Wherein, described field generation module includes:
Order contents acquiring unit, for when order request being detected, obtains described order request corresponding Target order contents;
Statistic unit, for adding up the quantity of the sub-order contents that described target order contents is comprised;Each Between sub-order contents separate;
Authority determines unit, for determining described target order contents according to the quantity of described sub-order contents Order authority;
Field signal generating unit, for when described order authority is lawful authority, according to described newer field length Form generates the order record field corresponding with described target order contents in described order contents details table.
Wherein, described authority determines that unit includes:
Judgment sub-unit, for judging whether the quantity of described sub-order contents exceedes predetermined number threshold value;
Determine subelement, if being judged as YES for described judgment sub-unit, it is determined that described target order contents Order authority be illegal authority;
Described determining subelement, being judged as NO if being additionally operable to described judgment sub-unit, it is determined that described target is ordered The order authority of single content is lawful authority.
Wherein, described field signal generating unit includes:
Extract subelement, for extracting the pass that each sub-order contents in described target order contents is the most corresponding Built-in value;
Combination subelement, for being combined relevant built-in value according to described field format rule, to obtain Close the total character string of built-in value;
Generate and add subelement, be used for according to described newer field format length in described order contents details table Generate the field model with described aiming field length, the described pass total character string of built-in value is added to described word Segment model, the order record field corresponding to obtain described target order contents.
Wherein, described field generation module also includes:
Illegal order processing unit, for when described order authority is illegal authority, stops generating with described The order record field that target order contents is corresponding, and send the illegal order carrying described predetermined number threshold value Information is to client, so that described client resends legal order according to described predetermined number threshold value Request;Order contents corresponding to described legal order request has described lawful authority.
The field format that the embodiment of the present invention is corresponding by obtaining the order record field in order contents details table Rule, then extract the original word segment length that the field length form in field format rule is corresponding, and by original Field length is revised as aiming field length, to generate newer field format length, thereby may be ensured that in detection During to order request, the target order contents that order request is corresponding can be obtained, and according to newer field length lattice Formula generates the order record field corresponding with target order contents in order contents details table, due to target word Segment length is more than original word segment length, i.e. adds the original word segment length that field length form is corresponding, so Improve the data recording capability of data base, i.e. can ensure that the complex order contents of content also is able to note Record, in the order contents details table of data base, to promote the warehouse-in success rate of order contents, i.e. can solve the problem that The technical problem that order warehouse-in is failed is caused because order data amount is excessive.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to enforcement In example or description of the prior art, the required accompanying drawing used is briefly described, it should be apparent that, describe below In accompanying drawing be only some embodiments of the present invention, for those of ordinary skill in the art, do not paying On the premise of going out creative work, it is also possible to obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of a kind of data processing method that the embodiment of the present invention provides;
Fig. 2 is the schematic flow sheet of the another kind of data processing method that the embodiment of the present invention provides;
Fig. 3 is the structural representation of a kind of data processing equipment that the embodiment of the present invention provides;
Fig. 4 is the structural representation of a kind of field generation module that the embodiment of the present invention provides;
Fig. 5 is the structural representation that a kind of authority that the embodiment of the present invention provides determines unit;
Fig. 6 is the structural representation of a kind of field signal generating unit that the embodiment of the present invention provides;
Fig. 7 is the structural representation of the another kind of data processing equipment that the embodiment of the present invention provides.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clearly Chu, be fully described by, it is clear that described embodiment be only a part of embodiment of the present invention rather than Whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not making creation The every other embodiment obtained under property work premise, broadly falls into the scope of protection of the invention.
Refer to Fig. 1, be the schematic flow sheet of a kind of data processing method that the embodiment of the present invention provides, described Method includes:
S101, obtains the field format rule that the order record field in order contents details table is corresponding;Described Order record field is the field for describing order contents;
Concrete, the data base of server is preset with order contents details table, described order contents details Table is the description being associated for the order contents stored corresponding to the order request initiated with client, institute Stating order contents details table and include multiple separate order record field, each order record field is respectively Corresponding with the description that an order contents is associated, the most described order record field is for being used for describing order contents Field.As a example by soccer lottery, order contents is that soccer lottery bets content, a soccer lottery stake Content can include that multiple playing methods of at least one football match correspondence respectively are (as playing method can include guessing always to enter Ball number, guess score etc.) and the stake information such as stake odds corresponding to each playing method.
Owing to each order record field is to deposit in described order contents details table in the same format, institute Unified field format rule is correspond to each order record field in described order contents details table, because of This, described server can obtain the field lattice that the order record field in described order contents details table is corresponding Formula rule.Described field format rule can include field length form, field description rule, field type Form.Described field type form refers to the field type of described order record field, such as varchar;Described Original word segment length in field length form refers to the length limit value of described order record field, if described Original word segment length is varchar (2000), then the greatest length of the described order record field that can generate is varchar(2000).Again as a example by soccer lottery, described field description rule can be: play number=playing method _ Stake content ^ playing method _ stake content, the numeral that wherein " playing method " is corresponding can be expressed as: 1 represents the victory that concedes points puts down Negative, 2 represent total score, 3 represent guess score, 4 represent half whole audience, 6 to represent victory flat negative;Wherein " ^ " symbol Represent the separator between same play difference playing method;As described order record field can be 160413007=1_3S1.38^2_2S3.15^3_1:0S7.50.
S102, extracts the original word segment length that the field length form in described field format rule is corresponding, and Described original word segment length is revised as aiming field length, to generate newer field format length;Described target Field length is more than described original word segment length;
Concrete, after described server gets described field format rule, described field format can be extracted The original word segment length that field length form in rule is corresponding, and described original word segment length is revised as mesh Marking-up segment length, to generate newer field format length;Described aiming field length is more than described original word segment length Degree.If the most described original word segment length is varchar (2000), a length of varchar of aiming field (max), The target word then varchar (2000) can being revised as in varchar (max), i.e. newer field format length Segment length is varchar (max) (max > 2000), it is seen that can generate based on described newer field format length The order record field that increasingly complex order contents is corresponding.
S103, when order request being detected, obtains the target order contents that described order request is corresponding, and Generate in described order contents details table and described target order contents pair according to described newer field format length The order record field answered;
Concrete, when the order request that client sends being detected, described server can obtain described order The target order contents that request is corresponding, and obtain the pass built-in value that described target order contents is corresponding, such as described pass Built-in value can include that each stake pass built-in value corresponding to play in described target order contents is (as certain is bet The play number of play is 160413007, then 160413007 be the pass built-in value that this stake play is corresponding), each The pass built-in value of the playing method of individual stake play correspondence respectively (is put down negative, i.e. " 1 " as " 1 " in playing method represents the victory that concedes points Pass built-in value for this playing method), pass built-in value corresponding to the stake odds of various playing method (if stake odds is 7.5, Then 7.5 it is the pass built-in value that this stake odds is corresponding) etc..Described server is further according to described newer field length Form generates the field model with described aiming field length in described order contents details table, and by institute State pass built-in value corresponding to target order contents to add to described field model, to obtain described target order contents Corresponding order record field.Can accommodate more owing to having the field model of described aiming field length Close built-in value, it is possible to improve the success rate generating described order record field, i.e. improve order contents Warehouse-in success rate.
The field format that the embodiment of the present invention is corresponding by obtaining the order record field in order contents details table Rule, then extract the original word segment length that the field length form in field format rule is corresponding, and by original Field length is revised as aiming field length, to generate newer field format length, thereby may be ensured that in detection During to order request, the target order contents that order request is corresponding can be obtained, and according to newer field length lattice Formula generates the order record field corresponding with target order contents in order contents details table, due to target word Segment length is more than original word segment length, i.e. adds the original word segment length that field length form is corresponding, so Improve the data recording capability of data base, i.e. can ensure that the complex order contents of content also is able to note Record, in the order contents details table of data base, to promote the warehouse-in success rate of order contents, i.e. can solve the problem that The technical problem that order warehouse-in is failed is caused because order data amount is excessive.
Refer to Fig. 2, be the schematic flow sheet of the another kind of data processing method that the embodiment of the present invention provides;Institute The method of stating may include that
S201, obtains the field format rule that the order record field in order contents details table is corresponding;Described Order record field is the field for describing order contents;
Concrete, the data base of server is preset with order contents details table, described order contents details Table is the description being associated for the order contents stored corresponding to the order request initiated with client, institute Stating order contents details table and include multiple separate order record field, each order record field is respectively Corresponding with the description that an order contents is associated, the most described order record field is for being used for describing order contents Field.As a example by soccer lottery, order contents is that soccer lottery bets content, a soccer lottery stake Content can include that multiple playing methods of at least one football match correspondence respectively are (as playing method can include guessing always to enter Ball number, guess score etc.) and the stake information such as stake odds corresponding to each playing method.
Owing to each order record field is to deposit in described order contents details table in the same format, institute Unified field format rule is correspond to each order record field in described order contents details table, because of This, described server can obtain the field lattice that the order record field in described order contents details table is corresponding Formula rule.Described field format rule can include field length form, field description rule, field type Form.Described field type form refers to the field type of described order record field, such as varchar;Described Original word segment length in field length form refers to the length limit value of described order record field, if described Original word segment length is varchar (2000), then the greatest length of the described order record field that can generate is varchar(2000).Again as a example by soccer lottery, described field description rule can be: play number=playing method _ Stake content ^ playing method _ stake content, the numeral that wherein " playing method " is corresponding can be expressed as: 1 represents the victory that concedes points puts down Negative, 2 represent total score, 3 represent guess score, 4 represent half whole audience, 6 to represent victory flat negative;Wherein " ^ " symbol Represent the separator between same play difference playing method;As described order record field can be 160413007=1_3S1.38^2_2S3.15^3_1:0S7.50.
S202, extracts the original word segment length that the field length form in described field format rule is corresponding, and Described original word segment length is revised as aiming field length, to generate newer field format length;Described target Field length is more than described original word segment length;
Concrete, after described server gets described field format rule, described field format can be extracted The original word segment length that field length form in rule is corresponding, and described original word segment length is revised as mesh Marking-up segment length, to generate newer field format length;Described aiming field length is more than described original word segment length Degree.If the most described original word segment length is varchar (2000), a length of varchar of aiming field (max), The target word then varchar (2000) can being revised as in varchar (max), i.e. newer field format length Segment length is varchar (max) (max > 2000), it is seen that can generate based on described newer field format length The order record field that increasingly complex order contents is corresponding.
S203, when order request being detected, obtains the target order contents that described order request is corresponding;
S204, adds up the quantity of the sub-order contents that described target order contents is comprised;In every sub-order Between appearance separate;
Concrete, after described server gets the target order contents that described order request is corresponding, Ke Yitong Count the quantity of the sub-order contents that described target order contents is comprised.As a example by lottery ticket, a described son is ordered Single content may refer to the stake of the one of which playing method of a play in described target order contents, if institute Stating target order contents and include A play and the stake of B play, the stake of A play includes the throwing of 3 kinds of playing methods Note, the stake of B play includes the stake of 2 kinds of playing methods, in the sub-order that the most described target order contents is comprised The quantity held is 5.
S205, determines the order authority of described target order contents according to the quantity of described sub-order contents;
Concrete, described server may determine that whether the quantity of described sub-order contents exceedes predetermined number threshold Value;If being judged as YES, it is determined that the order authority of described target order contents is illegal authority;If being judged as No, it is determined that the order authority of described target order contents is lawful authority.
S206, when described order authority is lawful authority, each son extracted in described target order contents is ordered The pass built-in value that single content is the most corresponding;
Concrete, when described order authority is lawful authority, described server can extract described target and order The pass built-in value of the correspondence respectively of each sub-order contents in single content.Such as, one of them sub-order contents is A The playing method " 3 " (playing method " 3 " represents and guesses score) of play (play number of A play is 160413007) Betting, and the score conjecture of this stake is 1:0, the odds of this stake is 7.50, then can extract this son and order Pass built-in value corresponding to single content includes: " 160413007 ", " 3 ", " 1:0 ", " 7.50 ".
S207, is combined relevant built-in value according to described field format rule, to obtain closing the total word of built-in value Symbol string;
Concrete, described server can be regular according to the described field description in described field format rule, Relevant built-in value is combined, to obtain closing the total character string of built-in value.Such as, described field description rule can Thinking: play number=playing method _ stake content ^ playing method _ stake content, the numeral that wherein " playing method " is corresponding can be with table It is shown as: 1 represent that the victory that concedes points is flat negative, 2 represent and total score, 3 represent and guess score, 4 represent half whole audience, 6 represent Victory is flat negative;The wherein separator between " ^ " symbology same play difference playing method;The most described pass total word of built-in value Symbol string can be 160413007=1_3S1.38^2_2S3.15^3_1:0S7.50.
S208, generates in described order contents details table according to described newer field format length and has described mesh The field model of marking-up segment length, adds the described pass total character string of built-in value to described field model, to obtain The order record field that described target order contents is corresponding;
Concrete, described server further according to described newer field format length in described order contents details table Generate the field model with described aiming field length, and the described pass total character string of built-in value is added to described Field model, the order record field corresponding to obtain described target order contents.With the field in soccer lottery As a example by the pass built-in value secondary, playing method, odds are the most corresponding, described order record field can be: " 160413008=1_3S1.56^2_3S3.75^3_1:1S6.25^4_0-0S3.10^6_0S2. 08 ".Owing to having State the field model of aiming field length to accommodate and more close built-in value, it is possible to improve and order described in generating The success rate of unirecord field, i.e. improves the warehouse-in success rate of order contents.And based on described present count Amount threshold value, can control the quantity of sub-order contents included in described target order contents, i.e. control The quantity of the pass built-in value that described target order contents is corresponding, such that it is able to improve further in described target order The warehouse-in success rate held, and can also shorten and calculate the amount of money corresponding to order contents and the consumption of anticipated bonus Time, for example, it is possible to ensure that the response time calculating the amount of money and anticipated bonus is not more than 5 seconds, to improve user Experience.
Optionally, when described order authority is illegal authority, stop generating and described target order contents pair The order record field answered, and send carry the illegal order information of described predetermined number threshold value to client End, so that described client resends legal order request according to described predetermined number threshold value;Described legal Order contents corresponding to order request has described lawful authority.Such as, in the sub-order in certain order contents When the quantity held exceedes described predetermined number threshold value, described server will not generate corresponding the ordering of this order contents Unirecord field, and send illegal order information to client, then user can be by this client Display interface view described illegal order information, make user know in the order contents oneself submitted to The quantity of sub-order contents too much, allow the quantity of user's antithetical phrase order contents delete so that by this The order request that client resends belongs to legal order request.
The field format that the embodiment of the present invention is corresponding by obtaining the order record field in order contents details table Rule, then extract the original word segment length that the field length form in field format rule is corresponding, and by original Field length is revised as aiming field length, to generate newer field format length, thereby may be ensured that in detection During to order request, the target order contents that order request is corresponding can be obtained, and according to newer field length lattice Formula generates the order record field corresponding with target order contents in order contents details table, due to target word Segment length is more than original word segment length, i.e. adds the original word segment length that field length form is corresponding, so Improve the data recording capability of data base, i.e. can ensure that the complex order contents of content also is able to note Record, in the order contents details table of data base, to promote the warehouse-in success rate of order contents, i.e. can solve the problem that The technical problem that order warehouse-in is failed is caused because order data amount is excessive;And based on described predetermined number threshold value, The quantity of sub-order contents included in order contents can be controlled, be possible not only to improve in order further The warehouse-in success rate held, and can also shorten and calculate the amount of money corresponding to order contents and the consumption of anticipated bonus Time.
Refer to Fig. 3, be the structural representation of a kind of data processing equipment that the embodiment of the present invention provides;Described Data processing equipment 1 can be applied in the server;Described data processing equipment 1 may include that acquisition mould Block 10, extraction modified module 20, field generation module 30;
Described acquisition module 10, for obtaining the field that the order record field in order contents details table is corresponding Format convention;Described order record field is the field for describing order contents;
Concrete, the data base of server is preset with order contents details table, described order contents details Table is the description being associated for the order contents stored corresponding to the order request initiated with client, institute Stating order contents details table and include multiple separate order record field, each order record field is respectively Corresponding with the description that an order contents is associated, the most described order record field is for being used for describing order contents Field.As a example by soccer lottery, order contents is that soccer lottery bets content, a soccer lottery stake Content can include that multiple playing methods of at least one football match correspondence respectively are (as playing method can include guessing always to enter Ball number, guess score etc.) and the stake information such as stake odds corresponding to each playing method.
Owing to each order record field is to deposit in described order contents details table in the same format, institute Unified field format rule is correspond to each order record field in described order contents details table, because of This, described acquisition module 10 can obtain the word that the order record field in described order contents details table is corresponding Paragraph format rule.Described field format rule can include field length form, field description rule, field Type format.Described field type form refers to the field type of described order record field, such as varchar; Original word segment length in described field length form refers to the length limit value of described order record field, if Described original word segment length is varchar (2000), then greatly enhancing most of the described order record field that can generate Degree is varchar (2000).Again as a example by soccer lottery, described field description rule can be: play number= Playing method _ stake content ^ playing method _ stake content, the numeral that wherein " playing method " is corresponding can be expressed as: 1 representative allows Ball victory is flat negative, 2 represent total score, 3 represent guess score, 4 represent half whole audience, 6 to represent victory flat negative;Wherein " ^ " Separator between symbology same play difference playing method;As described order record field can be 160413007=1_3S1.38^2_2S3.15^3_1:0S7.50.
Described extraction modified module 20 is corresponding for extracting the field length form in described field format rule Original word segment length, and described original word segment length is revised as aiming field length, to generate newer field Format length;Described aiming field length is more than described original word segment length;
Concrete, after described acquisition module 10 gets described field format rule, described extraction modified module 20 can extract the original word segment length that the field length form in described field format rule is corresponding, and by institute State original word segment length and be revised as aiming field length, to generate newer field format length;Described aiming field Length is more than described original word segment length.If the most described original word segment length is varchar (2000), target Field length is varchar (max), and varchar (2000) can be repaiied by the most described extraction modified module 20 Change a length of varchar of the aiming field (max) in varchar (max), i.e. newer field format length into (max > 2000), it is seen that increasingly complex order contents can be generated based on described newer field format length corresponding Order record field.
Described field generation module 30, for when order request being detected, obtains described order request corresponding Target order contents, and according to described newer field format length generate in described order contents details table with The order record field that described target order contents is corresponding;
Concrete, when the order request that client sends being detected, described field generation module 30 can obtain The target order contents that described order request is corresponding, and obtain the pass built-in value that described target order contents is corresponding, Each stake pass built-in value corresponding to play in target order contents as described in described pass built-in value can include (as The play number of certain stake play is 160413007, then 160413007 passes being this stake play corresponding are built Value), (such as " 1 " in playing method, to represent the victory that concedes points flat for the respectively corresponding pass built-in value of the playing method of each stake play Negative, i.e. " 1 " is the pass built-in value of this playing method), pass built-in value corresponding to the stake odds of various playing method be (as bet Odds is 7.5, then 7.5 be the pass built-in value that this stake odds is corresponding) etc..Described field generation module 30 Generate in described order contents details table further according to described newer field format length and there is described target word segment length The field model of degree, and pass built-in value corresponding for described target order contents is added extremely described field model, with Obtain the order record field that described target order contents is corresponding.Owing to having the word of described aiming field length Segment model can accommodate and more closes built-in value, it is possible to improve the success rate generating described order record field, I.e. improve the warehouse-in success rate of order contents, i.e. can solve the problem that and cause order to be put in storage because order data amount is excessive Failed technical problem.
Further, then please also refer to Fig. 4, it is a kind of field generation module of embodiment of the present invention offer The structural representation of 30;Described field generation module 30 may include that order contents acquiring unit 301, system Meter unit 302, authority determine unit 303, field signal generating unit 304;
Described order contents acquiring unit 301, for when order request being detected, obtains described order request Corresponding target order contents;
Described statistic unit 302, for adding up the number of the sub-order contents that described target order contents is comprised Amount;Between every sub-order contents separate;
Concrete, described order contents acquiring unit 301 gets the target order that described order request is corresponding After content, described statistic unit 302 can add up the sub-order contents that described target order contents comprised Quantity.As a example by lottery ticket, a described sub-order contents may refer in described target order contents The stake of the one of which playing method of play, if described target order contents includes A play and the stake of B play, The stake of A play includes that the stake of 3 kinds of playing methods, the stake of B play include the stake of 2 kinds of playing methods, then described It is 5 that statistic unit 302 can count the quantity of the sub-order contents that described target order contents is comprised.
Described authority determines unit 303, for determining described target order according to the quantity of described sub-order contents The order authority of content;
Concrete, can determine please also refer to a kind of authority that Fig. 5, Fig. 5 are embodiment of the present invention offers again The structural representation of unit 303;Described authority determines that unit 303 includes: judgment sub-unit 3031, determine Subelement 3032;
Described judgment sub-unit 3031, for judging whether the quantity of described sub-order contents exceedes predetermined number Threshold value;Described determine subelement 3032, if being judged as YES for described judgment sub-unit 3031, it is determined that institute The order authority stating target order contents is illegal authority;Described determine subelement 3032, if being additionally operable to described Judgment sub-unit 3031 is judged as NO, it is determined that the order authority of described target order contents is lawful authority.
Described field signal generating unit 304, for when described order authority is lawful authority, according to described new word Segment length form generates the order record corresponding with described target order contents in described order contents details table Field;
Concrete, can generate please also refer to a kind of field that Fig. 6, Fig. 6 are embodiment of the present invention offers again The structural representation of unit 304;Described field signal generating unit 304 includes: extract subelement 3041, combination Subelement 3043 is added in subelement 3042, generation;
Described extraction subelement 3041, for extracting each sub-order contents in described target order contents respectively Corresponding pass built-in value;
Wherein, when described order authority is lawful authority, described extraction subelement 3041 can extract described The pass built-in value that each sub-order contents in target order contents is the most corresponding.Such as, in one of them sub-order (playing method " 3 " represents and guesses to hold the playing method " 3 " for A play (play number of A play is 160413007) Score) stake, and the score conjecture of this stake is for 1:0, and the odds of this stake is 7.50, the most described extraction The pass built-in value that subelement 3041 can extract this sub-order contents corresponding includes: " 160413007 ", " 3 ", “1:0”、“7.50”。
Described combination subelement 3042, for relevant built-in value being combined according to described field format rule, To obtain closing the total character string of built-in value;
Wherein, described combination subelement 3042 can be according to the described field description in described field format rule Rule, is combined relevant built-in value, to obtain closing the total character string of built-in value.Such as, described field description Rule can be: play number=playing method _ stake content ^ playing method _ stake content, the numeral that wherein " playing method " is corresponding Can be expressed as: 1 represent the victory that concedes points flat negative, 2 represent total score, 3 represent guess score, 4 represent half whole audience, 6 represent victory puts down negative;The wherein separator between " ^ " symbology same play difference playing method;The most described pass is built Being worth total character string can be 160413007=1_3S1.38^2_2S3.15^3_1:0S7.50.
Described generation adds subelement 3043, is used for according to described newer field format length in described order contents Details table generates the field model with described aiming field length, the described pass total character string of built-in value is added To described field model, the order record field corresponding to obtain described target order contents;
Wherein, described generation adds subelement 3043 according to described newer field format length in described order contents Details table generates the field model with described aiming field length, and the described pass total character string of built-in value is added Add to described field model, the order record field corresponding to obtain described target order contents.Color with football As a example by the pass built-in value that play in ticket, playing method, odds are the most corresponding, described order record field can be: " 160413008=1_3S1.56^2_3S3.75^3_1:1S6.25^4_0-0S3.10^6_0S2. 08 ".Owing to having State the field model of aiming field length to accommodate and more close built-in value, it is possible to improve and order described in generating The success rate of unirecord field, i.e. improves the warehouse-in success rate of order contents.And based on described present count Amount threshold value, can control the quantity of sub-order contents included in described target order contents, i.e. control The quantity of the pass built-in value that described target order contents is corresponding, such that it is able to improve further in described target order The warehouse-in success rate held, and can also shorten and calculate the amount of money corresponding to order contents and the consumption of anticipated bonus Time, for example, it is possible to ensure that the response time calculating the amount of money and anticipated bonus is not more than 5 seconds, to improve user Experience.
Optionally, as shown in Figure 4, described field generation module 30 can also include: illegal order processing list Unit 305;Described illegal order processing unit 305, for when described order authority is illegal authority, stops Generate the order record field corresponding with described target order contents, and described predetermined number threshold value is carried in transmission Illegal order information to client so that described client is sent out again according to described predetermined number threshold value Send legal order request;Order contents corresponding to described legal order request has described lawful authority.
Such as, when the quantity of the sub-order contents in certain order contents exceedes described predetermined number threshold value, described Illegal order processing unit 305 generates, by stopping, the order record field that this order contents is corresponding, and sends non- Method order information is to client, and then user can view described by the display interface of this client Illegal order information, makes user know the quantity mistake of the sub-order contents in the order contents oneself submitted to Many, allow the quantity of user's antithetical phrase order contents delete so that the order resend by this client Request belongs to legal order request.
The field format that the embodiment of the present invention is corresponding by obtaining the order record field in order contents details table Rule, then extract the original word segment length that the field length form in field format rule is corresponding, and by original Field length is revised as aiming field length, to generate newer field format length, thereby may be ensured that in detection During to order request, the target order contents that order request is corresponding can be obtained, and according to newer field length lattice Formula generates the order record field corresponding with target order contents in order contents details table, due to target word Segment length is more than original word segment length, i.e. adds the original word segment length that field length form is corresponding, so Improve the data recording capability of data base, i.e. can ensure that the complex order contents of content also is able to note Record, in the order contents details table of data base, to promote the warehouse-in success rate of order contents, i.e. can solve the problem that The technical problem that order warehouse-in is failed is caused because order data amount is excessive;And based on described predetermined number threshold value, The quantity of sub-order contents included in order contents can be controlled, be possible not only to improve in order further The warehouse-in success rate held, and can also shorten and calculate the amount of money corresponding to order contents and the consumption of anticipated bonus Time.
Refer to Fig. 7, be the structural representation of the another kind of data processing equipment that the embodiment of the present invention provides.Institute State data processing equipment 1000 and can include processor 1001, communication interface 1002 and memorizer 1003 (number Can be one or more according to the quantity of the processor 1001 in processing means 1000, with at one in Fig. 7 As a example by reason device 1001).In some embodiments of the present invention, processor 1001, communication interface 1002 and storage Device 1003 can be connected by communication bus or other modes, and wherein, Fig. 7 is as a example by connecting by communication bus.
Wherein, described communication interface 1002, for communicating with client;
Described memorizer 1003 is used for storing program;
Described processor 1001 is used for performing described program, to realize
Obtain the field format rule that the order record field in order contents details table is corresponding;Described order is remembered Record field is the field for describing order contents;
Extract the original word segment length that the field length form in described field format rule is corresponding, and by described Original word segment length is revised as aiming field length, to generate newer field format length;Described target word segment length Degree is more than described original word segment length;
When order request being detected, obtain the target order contents that described order request is corresponding, and according to institute State newer field format length to generate and described corresponding the ordering of target order contents in described order contents details table Unirecord field.
In one embodiment, described processor 1001 is performing when order request being detected, obtains described The target order contents that order request is corresponding, and detailed in described order contents according to described newer field format length When feelings table generates corresponding with described target order contents order record field, specifically perform following steps:
When order request being detected, obtain the target order contents that described order request is corresponding;
Add up the quantity of the sub-order contents that described target order contents is comprised;Between every sub-order contents Separate;
Quantity according to described sub-order contents determines the order authority of described target order contents;
When described order authority is lawful authority, according to described newer field format length in described order contents Details table generates the order record field corresponding with described target order contents.
In one embodiment, described processor 1001 determines according to the quantity of described sub-order contents in execution During the order authority of described target order contents, specifically perform following steps:
Judge whether the quantity of described sub-order contents exceedes predetermined number threshold value;
If being judged as YES, it is determined that the order authority of described target order contents is illegal authority;
If being judged as NO, it is determined that the order authority of described target order contents is lawful authority.
In one embodiment, described processor 1001 is performing according to described newer field format length described When order contents details table generates the order record field corresponding with described target order contents, specifically perform Following steps:
Extract the pass built-in value that each sub-order contents in described target order contents is the most corresponding;
According to described field format rule, relevant built-in value is combined, to obtain closing the total character string of built-in value;
Generate in described order contents details table according to described newer field format length and there is described aiming field The field model of length, adds the described pass total character string of built-in value to described field model, to obtain described mesh The order record field that mark order contents is corresponding.
In one embodiment, described processor 1001 also performs following steps:
When described order authority is illegal authority, stop generating the order corresponding with described target order contents Record field, and send and carry the illegal order information of described predetermined number threshold value to client, so that Described client resends legal order request according to described predetermined number threshold value;Described legal order request Corresponding order contents has described lawful authority.
The field format that the embodiment of the present invention is corresponding by obtaining the order record field in order contents details table Rule, then extract the original word segment length that the field length form in field format rule is corresponding, and by original Field length is revised as aiming field length, to generate newer field format length, thereby may be ensured that in detection During to order request, the target order contents that order request is corresponding can be obtained, and according to newer field length lattice Formula generates the order record field corresponding with target order contents in order contents details table, due to target word Segment length is more than original word segment length, i.e. adds the original word segment length that field length form is corresponding, so Improve the data recording capability of data base, i.e. can ensure that the complex order contents of content also is able to note Record, in the order contents details table of data base, to promote the warehouse-in success rate of order contents, i.e. can solve the problem that The technical problem that order warehouse-in is failed is caused because order data amount is excessive;And based on described predetermined number threshold value, The quantity of sub-order contents included in order contents can be controlled, be possible not only to improve in order further The warehouse-in success rate held, and can also shorten and calculate the amount of money corresponding to order contents and the consumption of anticipated bonus Time.
One of ordinary skill in the art will appreciate that all or part of flow process realizing in above-described embodiment method, Can be by computer program and complete to instruct relevant hardware, described program can be stored in a calculating In machine read/write memory medium, this program is upon execution, it may include such as the flow process of the embodiment of above-mentioned each method. Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, Or random store-memory body (Random Access Memory, RAM) etc. ROM).
Above disclosed be only present pre-ferred embodiments, certainly can not with this limit the present invention it Interest field, the equivalent variations therefore made according to the claims in the present invention, still belong to the scope that the present invention is contained.

Claims (10)

1. a data processing method, it is characterised in that including:
Obtain the field format rule that the order record field in order contents details table is corresponding;Described order is remembered Record field is the field for describing order contents;
Extract the original word segment length that the field length form in described field format rule is corresponding, and by described Original word segment length is revised as aiming field length, to generate newer field format length;Described target word segment length Degree is more than described original word segment length;
When order request being detected, obtain the target order contents that described order request is corresponding, and according to institute State newer field format length to generate and described corresponding the ordering of target order contents in described order contents details table Unirecord field.
2. the method for claim 1, it is characterised in that described when order request being detected, obtains Take the target order contents that described order request is corresponding, and according to described newer field format length at described order Content details table generates the order record field corresponding with described target order contents, including:
When order request being detected, obtain the target order contents that described order request is corresponding;
Add up the quantity of the sub-order contents that described target order contents is comprised;Between every sub-order contents Separate;
Quantity according to described sub-order contents determines the order authority of described target order contents;
When described order authority is lawful authority, according to described newer field format length in described order contents Details table generates the order record field corresponding with described target order contents.
3. method as claimed in claim 2, it is characterised in that the described number according to described sub-order contents Amount determines the order authority of described target order contents, including:
Judge whether the quantity of described sub-order contents exceedes predetermined number threshold value;
If being judged as YES, it is determined that the order authority of described target order contents is illegal authority;
If being judged as NO, it is determined that the order authority of described target order contents is lawful authority.
4. method as claimed in claim 2 or claim 3, it is characterised in that described according to described newer field length Form generates the order record field corresponding with described target order contents in described order contents details table, Including:
Extract the pass built-in value that each sub-order contents in described target order contents is the most corresponding;
According to described field format rule, relevant built-in value is combined, to obtain closing the total character string of built-in value;
Generate in described order contents details table according to described newer field format length and there is described aiming field The field model of length, adds the described pass total character string of built-in value to described field model, to obtain described mesh The order record field that mark order contents is corresponding.
5. method as claimed in claim 3, it is characterised in that also include:
When described order authority is illegal authority, stop generating the order corresponding with described target order contents Record field, and send and carry the illegal order information of described predetermined number threshold value to client, so that Described client resends legal order request according to described predetermined number threshold value;Described legal order request Corresponding order contents has described lawful authority.
6. a data processing equipment, it is characterised in that including:
Acquisition module, for obtaining the field format rule that the order record field in order contents details table is corresponding Then;Described order record field is the field for describing order contents;
Extract modified module, for extracting corresponding original of the field length form in described field format rule Field length, and described original word segment length is revised as aiming field length, to generate newer field length lattice Formula;Described aiming field length is more than described original word segment length;
Field generation module, for when order request being detected, obtains the target that described order request is corresponding Order contents, and generate in described order contents details table and described mesh according to described newer field format length The order record field that mark order contents is corresponding.
7. device as claimed in claim 6, it is characterised in that described field generation module includes:
Order contents acquiring unit, for when order request being detected, obtains described order request corresponding Target order contents;
Statistic unit, for adding up the quantity of the sub-order contents that described target order contents is comprised;Each Between sub-order contents separate;
Authority determines unit, for determining described target order contents according to the quantity of described sub-order contents Order authority;
Field signal generating unit, for when described order authority is lawful authority, according to described newer field length Form generates the order record field corresponding with described target order contents in described order contents details table.
8. device as claimed in claim 7, it is characterised in that described authority determines that unit includes:
Judgment sub-unit, for judging whether the quantity of described sub-order contents exceedes predetermined number threshold value;
Determine subelement, if being judged as YES for described judgment sub-unit, it is determined that described target order contents Order authority be illegal authority;
Described determining subelement, being judged as NO if being additionally operable to described judgment sub-unit, it is determined that described target is ordered The order authority of single content is lawful authority.
9. device as claimed in claim 7 or 8, it is characterised in that described field signal generating unit includes:
Extract subelement, for extracting the pass that each sub-order contents in described target order contents is the most corresponding Built-in value;
Combination subelement, for being combined relevant built-in value according to described field format rule, to obtain Close the total character string of built-in value;
Generate and add subelement, be used for according to described newer field format length in described order contents details table Generate the field model with described aiming field length, the described pass total character string of built-in value is added to described word Segment model, the order record field corresponding to obtain described target order contents.
10. device as claimed in claim 8, it is characterised in that described field generation module also includes:
Illegal order processing unit, for when described order authority is illegal authority, stops generating with described The order record field that target order contents is corresponding, and send the illegal order carrying described predetermined number threshold value Information is to client, so that described client resends legal order according to described predetermined number threshold value Request;Order contents corresponding to described legal order request has described lawful authority.
CN201610282562.9A 2016-04-29 2016-04-29 Data processing method and device Pending CN106033582A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610282562.9A CN106033582A (en) 2016-04-29 2016-04-29 Data processing method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610282562.9A CN106033582A (en) 2016-04-29 2016-04-29 Data processing method and device

Publications (1)

Publication Number Publication Date
CN106033582A true CN106033582A (en) 2016-10-19

Family

ID=57149292

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610282562.9A Pending CN106033582A (en) 2016-04-29 2016-04-29 Data processing method and device

Country Status (1)

Country Link
CN (1) CN106033582A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111882429A (en) * 2020-07-28 2020-11-03 中国银行股份有限公司 Bank system field length segmentation method and device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101674606A (en) * 2009-09-25 2010-03-17 华为技术有限公司 Data transmission method and device
CN102253980A (en) * 2011-06-23 2011-11-23 上海西本网络科技有限公司 Data processing method and data processing system
CN104462121A (en) * 2013-09-18 2015-03-25 腾讯科技(深圳)有限公司 Data processing method, device and system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101674606A (en) * 2009-09-25 2010-03-17 华为技术有限公司 Data transmission method and device
CN102253980A (en) * 2011-06-23 2011-11-23 上海西本网络科技有限公司 Data processing method and data processing system
CN104462121A (en) * 2013-09-18 2015-03-25 腾讯科技(深圳)有限公司 Data processing method, device and system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111882429A (en) * 2020-07-28 2020-11-03 中国银行股份有限公司 Bank system field length segmentation method and device
CN111882429B (en) * 2020-07-28 2023-08-18 中国银行股份有限公司 Bank system field length segmentation method and device

Similar Documents

Publication Publication Date Title
US9952834B2 (en) Distribution of applications with a saved state
US20150065251A1 (en) Player generated content management
WO2020000675A1 (en) Method and device for publishing game resource package, terminal device and medium
US20220172577A1 (en) Sportsbook odds optimization and correlated proposition bet analysis
WO2016018779A1 (en) Systems and methods for providing electronic gaming pieces
US20220005321A1 (en) Sportsbook odds optimization and correlated proposition bet analysis
CN103593355A (en) User original content recommending method and device
CN106033582A (en) Data processing method and device
CN103377117B (en) One kind game automatic test approach and device
CN104715131A (en) Data processing method and device for internet game
CN104753758B (en) A kind of information attribute recognition methods and device
CN107862540A (en) A kind of lottery drawing method and device
CN104572464B (en) The automatic test state saving approach and device of a kind of Android platform
JP2020108760A5 (en)
US20220405509A1 (en) Image processing method and device, edge computing device, and computer storage medium
CN108170838A (en) The visualization that topic develops shows method, application server and computer readable storage medium
US7204413B2 (en) Judgment systems and methods
CN106921536A (en) Data processing method and device based on client release information
CN105528724A (en) Lottery pooled-purchasing method based on user behavior characteristics
US20190073877A1 (en) Pull-tab gaming system and method of operation
CN111242494A (en) Patent infringement detection method and system based on game theory
CN110750681A (en) Account similarity calculation method, storage medium, electronic device and system
CN107967310A (en) Public opinion data processing method and device and storage medium
US9704345B1 (en) Single action betting system and method
CN115865661B (en) Method and system for detecting firmware of game handle

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20161019