CN106126633A - The processing method of noble metal data, device and system - Google Patents

The processing method of noble metal data, device and system Download PDF

Info

Publication number
CN106126633A
CN106126633A CN201610461141.2A CN201610461141A CN106126633A CN 106126633 A CN106126633 A CN 106126633A CN 201610461141 A CN201610461141 A CN 201610461141A CN 106126633 A CN106126633 A CN 106126633A
Authority
CN
China
Prior art keywords
nugget
noble metal
record
section
sequence number
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
Application number
CN201610461141.2A
Other languages
Chinese (zh)
Other versions
CN106126633B (en
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.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
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 China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN201610461141.2A priority Critical patent/CN106126633B/en
Publication of CN106126633A publication Critical patent/CN106126633A/en
Application granted granted Critical
Publication of CN106126633B publication Critical patent/CN106126633B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/3331Query processing
    • G06F16/334Query execution

Abstract

The invention provides processing method, device and the system of a kind of noble metal data, nugget number stores using single piece number as the form of a record in data base, and the method includes: receive the demand information of service terminal;At least with nugget number as sort field, a plurality of noble metal record is ranked up;Every record after sequence increases the arrangement sequence number of correspondence;Number section sequence number using the nugget number after sequence deducts corresponding arrangement sequence number, obtains sequence number poor;By in multiple attribute-bits of noble metal, at least number paragraph header, block length identical nugget number poor with sequence number merges into consecutive number section, shows with the form shown with consecutive number section at service terminal.The present invention is by changing nugget number in the storage form of background data base so that the amendment process of noble metal balance account book is become simple directly on the basis of, also assures that front end display mode does not changes simultaneously.

Description

The processing method of noble metal data, device and system
Technical field
The present invention relates to financial services technology field, particularly relate to processing method, the device of a kind of noble metal data and be System.
Background technology
In banking system of today, noble metal is that a kind of common keeping is in kind.In the data base of bank, noble metal is Carry out recording with the form of nugget number.Under normal circumstances, nugget number is made up of number paragraph header and a number section sequence number, number section Head is made up of arbitrary string, does not typically comprise numeral, the pure digi-tal part number of the being section sequence number after number paragraph header in number paragraph header.
In the service process of banking system, need to show nugget at service cabinets you (hereinafter referred to as service terminal) Number, the noble metal inventories of mechanism are checked for teller.Owing to nugget number is too much, in the data base of same mechanism May have tens0000 to nugget record up to a million, for the ease of checking, use every when showing in banking system front end The display mode (being called for short consecutive number section to show) of row one consecutive number section of display, such as one consecutive number section of display in often row Starting block number and cut-off block number.In background data base, nugget number is stored in the noble metal remaining sum registration of background data base In book, and, the nugget number storage form in register also keeps consistent with front end display format, i.e. with one continuously Number section stores as a record.
In the routine work of bank, when noble metal material object is alloted by national treasury, need noble metal balance account book Carrying out increasing block number, deleting the operation that the amendments such as block number record, specific works process is as follows:
1) noble metal recalls authorities to when alloting demand, first to judge that noble metal section to be recalled is in mechanism Noble metal balance account book in whether exist.If existing, needing according to the demand of alloting, the noble metal remaining sum of mechanism is stepped on Record in note book (hereinafter referred to as book) splits, will the consecutive number of the number of recalling section by comprising in mechanism book Duan Jinhang splits, and is respectively processed afterwards.I.e. exchange the section of being extra-large to delete, remaining discontinuous section is split into a plurality of Record.
2) receiving mechanism is after receiving number section alloted, and can number section that judgement be needed to call in your gold in mechanism Number section belonged in balance account book merges into consecutive number section, if permissible, then the number of calling in section is merged, if cannot with an existing number section Merge, then increase a record newly.
Inventor finds, the process logic in prior art modified noble metal balance account book is extremely complex, leads The operating process causing rear end background server is the most loaded down with trivial details, affects the treatment effeciency of background server.
Summary of the invention
For the most methodical deficiency, the present invention proposes processing method, device and the system of a kind of noble metal data, should Method is by storing nugget number using single piece number as the form of a record in data base to your gold On the basis of the amendment process of genus balance account book becomes the most directly, also assures that front end display mode does not changes simultaneously Become.
For reaching object above, technical scheme is as follows:
The invention discloses the processing method of a kind of noble metal data, nugget number in data base with single piece number work Being that a form recorded stores, the method includes:
Receive the demand information of service terminal;
At least with nugget number as sort field, a plurality of noble metal record of storage in described data base is arranged Sequence, with in multiple attribute-bits of noble metal, will at least have same No. paragraph header and the nugget number of same block length Arrange successively according to a number size for section sequence number;
Every record after sequence increases the arrangement sequence number of correspondence, the arranged mode of described arrangement sequence number and number Duan Xu The sortord of number size is consistent;Number section sequence number using the nugget number after sequence deducts corresponding arrangement sequence number, Obtain sequence number poor;
By in multiple attribute-bits of noble metal, at least number paragraph header, block length identical nugget poor with sequence number Number merge into consecutive number section, the form that the noble metal information stored in data base shows with consecutive number section to be entered at service terminal Row display.
Preferably, described at least with nugget number as sort field, to your gold a plurality of of storage in described data base Before or after genus record is ranked up, also include:
Described nugget number is split, obtains number paragraph header and number section sequence number of each nugget number;
When before described noble metal record is ranked up, when described nugget number is split, described with expensive Metal derby number is sort field, is ranked up particularly as follows: at least to tear open to a plurality of noble metal record of storage in described data base Number paragraph header of the nugget number after Fen, number section sequence number and number a length of sort field of section sequence number, store in described data base A plurality of noble metal record be ranked up, with in multiple attribute-bits of noble metal, will at least have same No. paragraph header and phase The nugget number of jack per line section sequence number length arranges successively according to a number size for section sequence number.
Preferably, described nugget number is split, obtain number paragraph header part and number section of each nugget number The concrete mode of sequence number part is: uses regular expression, inquires number paragraph header part and number Duan Xu of described nugget number Number part, and described paragraph header part and a number section sequence number part are split, obtain number g. slice header of each nugget number Divide and number section sequence number part.
Preferably, use number section sequence number of the nugget number after sequence to deduct corresponding arrangement sequence number, obtain sequence Before number difference, also include: number section sequence number length of record nugget number, described paragraph header is identical and number section sequence number length is identical Time, described piece of number length is identical.
Preferably, the sort field being ranked up nugget number also includes noble metal mechanism number, keeping teller number, produces Product code, matter damage at least one in mark, property rights mark, locking mark and Storage Cabinets box number.
Preferably, by multiple attribute-bits of noble metal, at least number paragraph header, block length is poor with sequence number identical expensive Consecutive number section merged into by metal derby number, with at service terminal by the noble metal information that stores in data base with the form of consecutive number section The concrete mode carrying out showing is: use SQL, described noble metal record is carried out Querying by group, with will be expensive In multiple attribute-bits of metal, at least number paragraph header, number section sequence number length identical nugget number poor with sequence number merges into one Group, often group is as a consecutive number section, with at service terminal by the noble metal information that stores in data base with the shape of consecutive number section Formula shows.
Preferably, the method also includes: receiving when recalling instruction of nugget number, deletes and recalls in data base Nugget record;Receiving when calling in instruction of nugget number, data base increases the nugget number called in Record.
Preferably, in data base, the recording mode to described nugget number is, carries out record in the form of a list, one Record occupies same a line of list or same string;The exhibition method of the consecutive number section of nugget number is by service terminal, with row The form of table is shown, and the record of a consecutive number section occupies same a line of list or same string.
Preferably, when before described noble metal record is ranked up, when described nugget number is split, After the demand information of described reception service terminal, also include:
The action type that nugget record in data base is modified by the inquiry last time;
When the last time to data base in nugget record carried out delete block number record operation time, then skip institute State the step that nugget number carries out splitting, enter the described a plurality of noble metal record to storing in described data base and be ranked up Step;
When the last time to data base in nugget record carried out increase block number record operation time, then enter institute State the step that nugget number carries out splitting.
Preferably, the method also includes:
Receive that certain service terminal sends shows the need of multiple nuggets number that certain or some consecutive number sections comprise Seek information;
The information of the multiple nuggets number described consecutive number section comprised is sent to described service terminal, with in described industry Multiple nuggets number that consecutive number section described in business terminal display comprises.
Preferably, the method also includes:
Receive the demand information locking single or multiple nuggets number that certain service terminal sends;
Lock described single or multiple nugget number, to avoid at other service terminal in addition to described service terminal On described single or multiple nuggets number are carried out repetitive operation.
The embodiment of the invention also discloses a kind of noble metal data processing equipment, nugget number in data base with single Block number stores as the form of a record, and this processing means includes:
Receive unit, for receiving the demand information of service terminal;
Sequencing unit, at least with nugget number as sort field, to your gold a plurality of of storage in described data base Belong to record to be ranked up, with in multiple attribute-bits of noble metal, will at least have same No. paragraph header and same block length Nugget number arrange successively according to a number size for section sequence number;
Sequence number adding device, increases the arrangement sequence number of correspondence, described arrangement sequence number in every record after sequence Arranged mode consistent with number sortord of section sequence number size;
Computing unit, number section sequence number of the nugget number after using sequence deducts corresponding arrangement sequence number, Obtain sequence number poor;
Combining unit, for by multiple attribute-bits of noble metal, at least number paragraph header, block length and sequence number difference phase Same nugget number merges into consecutive number section;
Transmitting element, for being sent to display device, with by data base by the noble metal information after merging cell processing The form that the noble metal information of middle storage shows with consecutive number section at service terminal shows.
Preferably, this device also includes: split cells, for splitting described nugget number, obtains each expensive Number paragraph header part of metal derby number and number section sequence number part.
Preferably, this device also includes: record modification unit, in noble metal data handling procedure, increases your gold Belong to number section sequence number length and the recorded content of sequence number difference of block number, and when receiving nugget number and recalling instruction, delete number According to the nugget record recalled in storehouse;When receiving nugget number and calling in instruction, in data base, increase is called in Nugget record.
Preferably, this device also includes: query unit, is used for inquiring about nugget record in last data base and carries out The action type of amendment.
Preferably, this device also includes: information locking unit, for receiving certain service terminal at described reception unit During the demand information locking single or multiple nuggets number sent, lock described single or multiple nugget number.
The embodiment of the invention also discloses a kind of noble metal data handling system, including data base, background server and extremely A few service terminal;
Wherein, described data base is used for storing nugget number, the described nugget number storage form in data base For single piece number as a record;
Described background server is after the demand receiving service terminal, at least with nugget number as sort field, right In described data base, a plurality of noble metal record of storage is ranked up, and with in multiple attribute-bits of noble metal, will at least have The nugget number having same No. paragraph header and same block length arranges successively according to a number size for section sequence number, and in sequence After every record in increase the arrangement sequence number of correspondence, and it is right with it to use a number section sequence number for the nugget number after sequence to deduct The arrangement sequence number answered, obtains sequence number poor, by multiple attribute-bits of noble metal, and at least number paragraph header, block length and sequence number The identical nugget number of difference merges into consecutive number section, and the noble metal information after block merging treatment is sent to display dress Putting, wherein, the arranged mode of described arrangement sequence number is consistent with number sortord of section sequence number size;
Described service terminal is for showing the form that the noble metal information stored in data base shows with consecutive number section Show.
Preferably, described background server is additionally operable to split described nugget number, obtains each nugget Number number paragraph header and number section sequence number.
Preferably, described background server is additionally operable in noble metal data handling procedure, increase nugget number number Section sequence number length and the recorded content of sequence number difference, and when receiving nugget number and recalling instruction, directly delete in data base The nugget record recalled;When receiving nugget number and calling in instruction, in data base, directly increase call in expensive Metal derby record.
Preferably, described service terminal is additionally operable to when showing described noble metal information arrange index entry, described index entry Index field include mandatory field and Optional Field, the described mandatory field number of including paragraph header, number section sequence number and number section sequence number are long Degree, described Optional Field includes that described noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, lock Calibration is known, Storage Cabinets box number.
Preferably, described service terminal is additionally operable to, when showing described noble metal information, carry out described noble metal information Sequencing display and/or Pagination Display.
Preferably, described service terminal is additionally operable to, while display consecutive number section, send exhibition to described background server Show the demand information of multiple nuggets number that certain or some consecutive number sections comprise, and show that described consecutive number section comprises many Individual nugget number;Described background server is additionally operable to receive displaying certain or some the consecutive number section that certain service terminal sends The demand information of the multiple nuggets number comprised, and the information transmission of multiple nuggets number that described consecutive number section is comprised To described service terminal.
Preferably, described service terminal is additionally operable to send to described background server lock single or multiple nuggets number Demand information, to avoid on other service terminal in addition to described service terminal described single or multiple nuggets Number carry out repetitive operation;Described background server is additionally operable to receive the single or multiple noble metal of locking that certain service terminal sends The demand information of block number, and lock described single or multiple nugget number.
The beneficial effects of the present invention is:
The processing method of noble metal data disclosed by the invention and system, by changing nugget number at background data base Storage form, consecutive number section will carry out the form that stores as a record, be revised as using single piece number as a note Record stores, thus allots in business at noble metal, for recalling mechanism, only need to use the mode of inquiry comparison, will adjust Go out block number to compare with the block number that mechanism stores, it is judged that whether mechanism stores the block number that need to recall and number section is Can, without the calculating as carried out complexity in prior art.For calling in mechanism, more need not carry out any judging Journey, but directly in data base, increase the block number called in and record.In other words, i.e. need noble metal balance account book In nugget number when deleting and increase, directly carry out the operation deleted and increase, without doing difference again Whether block number is positioned at a series of pre actions such as the judgement of same consecutive number section, so that the amendment process of background data base Become simple direct, improve the treatment effeciency of background server.
Further, method disclosed by the invention is used, by the nugget number in register is ranked up, calculating section Sequence number is poor with the sequence number of sequence sequence number, such that it is able to according to poor the most identical of sequence number, determine whether consecutive number section, and then Carry out recording and being shown at service terminal by consecutive number section.By these simply operating process such as sequence and packet, real Show nugget number in register with single piece of number record, and consecutive number section when showing in front end, can have been shown, both letter Change the operation on backstage, in turn ensure that the convenience that front end shows.
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 embodiment or existing In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is only this Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, it is also possible to Other accompanying drawing is obtained according to these accompanying drawings.
Fig. 1 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention one;
Fig. 2 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention two;
Fig. 3 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention three;
Fig. 4 is the structure chart of the processing means of noble metal data disclosed in the embodiment of the present invention.
Detailed description of the invention
The present invention is described in further detail with specific embodiment below in conjunction with the accompanying drawings.
Inventor finds, during the alloting of noble metal of the prior art, carries out noble metal balance account book every time Before amendment, it is required for carrying out a judge process, i.e. judges the number of recalling section and the number of calling in section and number section in mechanism register Be made whether to be positioned at same consecutive number section, namely judge whether not exist between jack per line section inclusion relation, and multiple continuously Can number section form a consecutive number section.
Carry out this judgement, first have to judge that different nuggets number is whether in same section.Determination methods is, Obtaining a block number, from back to front, taking first is not digital character, and this character, to the first character of block number, cuts Taking-up paragraph header, the pure digi-tal number of being section sequence number below.It is respectively compared length and number paragraph header of two blocks number, when two blocks number Length and number paragraph header completely the same time, just belong to same section.
Whether judgement section the most again comprises or whether can make up consecutive number section.This process is, firstly, it is necessary to judge With in the consecutive number segment record of kind noble metal in the noble metal remaining sum book of mechanism, if having less than or equal to required number Section starting block number starting block number, more than or equal to required number section cut-off block number by block number.Consecutive number section split process, needs Block number after several pieces of starting block number to be calculated is how many, finds the block number identical with required number section cut-off block number.Consecutive number section Merging process, needs to judge that, between different consecutive number sections, the starting block number of a consecutive number section cuts with another consecutive number section The most identical to the next block number of block number.
From above analysis, can be evident that, when carrying out noble metal material object and alloting, recall mechanism and call in machine Noble metal record modification process in the data base of structure need to carry out the computing of complexity, brings the biggest pressure to backstage background server Power, affects the work efficiency of background server.Occur this problem mainly by nugget number in the storage form of data base Cause.Background data base is consistent to the storage mode of nugget number and the display mode of service terminal, although be easy to business The digital independent of terminal, but the most complicated to the pre action before the noble metal record modification in data base, revise mode The easiest.But, the convenience that service terminal shows have to meet, therefore to adjust nugget number storage shape Formula, also must assure that front end display mode is constant simultaneously.
Embodiment one
Based on above reason, the embodiment of the present invention one proposes the processing method of a kind of noble metal data, solves and is changing In variable database while the storage form of nugget number, it is ensured that service terminal display mode is constant.
First, in the present embodiment of the present invention, have adjusted the nugget number storage form in data base, by existing skill The form carrying out storing with consecutive number section in art is revised as storing using single nugget number as the form of a record.
Owing to have modified the nugget number storage form in data base so that when occurring noble metal to allot business, The operation that background server need to be carried out greatly reduces.Concrete, for recalling mechanism, negative compared to what prior art was carried out The preposition judge process of duty, in the present embodiment, background server only need to use the mode of inquiry comparison, it would be desirable to the block number recalled Compare with the block number of storage in mechanism data base, it is judged that whether mechanism stores the block number that need to recall and number section is Can, if having, the block number record directly recalled by needs carries out deleting, without the most existing skill in mechanism data base Art carries out the calculating of complexity.For calling in mechanism, more need not carry out any judge process, but directly in data base Increase the block number called in record.
During it is to say, i.e. need the nugget number in noble metal balance account book is deleted and increased, directly Carry out the operation deleted and increase, without doing different masses number judgement whether being positioned at same consecutive number section etc. be again The pre action of row, so that the amendment process of background data base becomes simple direct, improves the process of background server Efficiency.
Additionally, in prior art there is the strongest the lacking of coupling in data base to the recording mode of nugget number the most simultaneously Point.Original noble metal material object is one piece one piece placement, and in data base is one record of a consecutive number section, thus causes expensive Metal derby number is in Input Process, if mistake occurs in a record, may result in the note of the polylith noble metal of whole consecutive number section All can there is mistake in record, thus be not easy to the block number to there is mistake and position.And in the embodiment of the present invention single piece number , between each piece number, there is not any contact, the shortcoming that coupling is strong also would not occur in storage mode, if certain block number Record mistake occurs, be more convenient for mistake location and amendment.
On the basis of storing as a record at single piece number, noble metal process side disclosed in the embodiment of the present invention It is identical, i.e. at service terminal with continuous blocks with prior art that method also ensures the nugget number display mode at service terminal Number showing as a record, the flow chart of the method is as it is shown in figure 1, specifically include following steps:
Step S101, the demand information of reception service terminal, i.e. receive trigger action information.
Generally, when service terminal generation noble metal allots demand or noble metal transaction, will be to background service Device end sends the demand information of service terminal, thus triggers the data handling procedure of the embodiment of the present invention.Such as, noble metal transaction Time, the business personnel of front end will send noble metal data query information at service terminal, and this Query Information is service terminal Demand information, can be used as trigger action information.Additionally, the computer system of mechanism receives noble metal when alloting business, Also can receive triggering noble metal and allot the instruction information of business, this instruction information also can be as triggering touching of the embodiment of the present invention Send out operation information.
Step S102, demand according to service terminal, at least with nugget number as sort field, in described data base The a plurality of noble metal record of storage is ranked up, by multiple attribute-bits of noble metal, at least to have same No. paragraph header Arrange successively according to a number size for section sequence number with the nugget number of same block length.
The service personal of front end is to carry out normal noble metal transactional services etc., it is necessary to see your gold at service terminal The various attribute-bits belonged to, in order to introduce the noble metal situation of mechanism stock to client.To meet the demand of service terminal, It is accomplished by the different attribute mark according to noble metal, the nugget number in data base is sorted out and sorts.
The attribute in kind of noble metal is more, and its attribute-bit also can have a lot accordingly, and such as mark noble metal, whether matter is damaged Matter damage mark, mark is can to sell or client specifies the property rights of extraction identify, identifies current noble metal systems and locks to go out The locking mark sold, the product code etc. of mark product type, also have and represent noble metal mark of storage condition in national treasury, as Noble metal mechanism number, keeping teller number, Storage Cabinets box number etc., additionally include the signature identification of nugget number, as block number is long Degree, number paragraph header, number section sequence number etc..
When nugget number is ranked up by the present embodiment, suitable sequence can be selected according to the demand of front-end business Field and the priority of sort field.Due to for nugget number, number paragraph header and the identical situation of block length Under, just can be identified as same section, be positioned in same section, a number section sequence number continuous print is just identified as consecutive number section.Therefore In theory, when showing in order to ensure service terminal, a consecutive number section is shown as a record, if foundation section Head and the similarities and differences of block length are ranked up, as only by block number identical with block length for number paragraph header according to number section sequence number Size order arranges successively.
But in practical operation, often can not meet the demand of service terminal only in accordance with number paragraph header sequence.Generally, May select noble metal mechanism number, product code, matter damages mark, property rights identify, locking identifies, block length is identical with number paragraph header Nugget number, be ranked up according to a number size for section sequence number, it is also possible to only select noble metal mechanism number, product code, guarantor Several fields such as pipe teller number, block length and number paragraph header, are ranked up according to a number size for section sequence number afterwards.Anyway select Select sort field, in sort field must the number of comprising paragraph header, block length and number section sequence number, i.e. make with complete nugget number For sort field.
Step S103, complete sequence after, need after sequence every record increases the arrangement sequence number of correspondence, arrangement The arranged mode of sequence number is consistent with number sortord of section sequence number size.
Concrete, if nugget number arranges successively according to number order that section sequence number is ascending, then arrange sequence number The most ascending layout successively, is i.e. positioned at the serial number 1 of primary piece number in the noble metal balance account book of data base, afterwards The sequence number of block number is incremented by the most successively.Otherwise, if nugget number is carried out successively according to number order that section sequence number is descending Arrangement, then the arrangement the most descending layout successively of sequence number, is i.e. positioned at last block in the noble metal balance account book of data base Number serial number 1, the sequence number of block number is incremented by the most successively before.In the present embodiment, preferred nugget number is according to a number section sequence number Ascending order is arranged in order.
Number section sequence number of the nugget number after step S104, use sequence deducts corresponding arrangement sequence number, obtains Sequence number is poor.
Sortord in previous step so that be positioned at the nugget number of same consecutive number section after this step, The sequence number difference arrived is identical.I.e. after the calculating of this step, the most identical by sequence number difference, i.e. can determine whether that multiple nugget number is No it is positioned at same consecutive number section.
Step S105, by multiple attribute-bits of noble metal, at least number paragraph header, block length is poor with sequence number identical Nugget number merges into consecutive number section, the noble metal information stored in data base to be shown with consecutive number section at service terminal Form show.In this step, the display format to consecutive number section can be identical with prior art, thus ensure that business The simplicity of terminal demonstration.
Use method disclosed in the embodiment of the present invention, by the nugget in the noble metal balance account book to data base Number being ranked up, calculating section sequence number is poor with the sequence number of sequence sequence number, such that it is able to according to poor the most identical of sequence number, judge Whether it is consecutive number section, and then carries out recording and being shown at service terminal by consecutive number section.Simply sorted by these And the operating process such as packet, it is achieved that nugget number in register with single piece of number record, and can when showing in front end To show consecutive number section, both simplified the operation on backstage, in turn ensure that the convenience that front end shows.
Embodiment two
The processing method of noble metal data disclosed in the embodiment of the present invention, on the basis of a upper embodiment, to these data Processing method has carried out further improving and refining, concrete, and the method flow diagram of the present embodiment is as in figure 2 it is shown, this reality Execute the step that in example, content is identical with a upper embodiment, refer to the description of an embodiment, the present embodiment repeats no more.This Method in embodiment comprises the following steps:
Step S201, the demand information of reception service terminal, i.e. receive trigger action information.
Step S202, described nugget number is split, obtain each nugget number number paragraph header part and number Section sequence number part.
Concrete, regular expression can be used, inquire number paragraph header part and number section sequence number portion of described nugget number Point, and described paragraph header part and a number section sequence number part are split, obtain number paragraph header part of each nugget number with Number section sequence number part.The most respectively described paragraph header part and a number section sequence number part are individually carried out record, the record side of the two Formula is consistent with the attribute-bit recording mode of noble metal.
Wherein, in data base, the recording mode to described nugget number is, carries out record, a note in the form of a list Record occupies same a line of list or same string.When occupying same a line of list such as a record, different lines in the same row is then Identify for recording the different attribute of this noble metal, same, if record occupies the same string of list, in same string Different rows then for record this noble metal different attribute mark.As a example by the former, nugget number is at your gold of data base Belong to the record form in balance account book as shown in table 1.For the ease of showing, only with noble metal attribute mark in the present embodiment table 1 Illustrate as a example by several in knowledge, do not show whole attribute-bits.
Table 1 nugget number recording mode in data base
In table 1, in being not carried out the present embodiment before each step, the nugget number record arrangement mode in data base Unordered and random, only as example in the present embodiment, illustrate as a example by the following steps also data shape in table 1.Table 1 In each attribute-bit be only used as example and illustrate, do not indicate that the noble metal information of any reality.
After performing step S202, use regular expression, number paragraph header and number section sequence number of nugget number are split Afterwards, the recording mode of noble metal is as shown in table 2.
Table 2 is to the recording mode after nugget number fractionation
Embodiment one does not increase the step that nugget number splits, nugget number is being ranked up, is calculating sequence number During difference, background server needs by first identifier paragraph header and number section sequence number part, then carries out associative operation, this enforcement After example increases the process of step S202, it is only necessary to use regular expression, be extra-large paragraph header and number section sequence number part can be distinguished, Without carrying out the identification of block number the most one by one, further simplify the processing procedure of background server.
Step S203, number section sequence number length of record nugget number, described paragraph header is identical and number section sequence number length phase Meanwhile, described piece of number length is identical.
Further, since after fractionation paragraph header and number section sequence number, number section serial number pure digi-tal, it is possible to appearance section sequence number Former bit strips 0, and in the arranging of data base, if often pure digi-tal part prefix band 0, record after automatically zero-suppressing, can be carried out, Such as ABC00120456, number section sequence number part is actual is 00120456, then can be automatically record as 120456, cause in data base There is mistake in the record of number section sequence number, therefore, increases the record of check mark section sequence number length, as shown in table 3 in the present embodiment.
The table 3 recording mode to nugget number increase section sequence number length
Step S204, demand according to service terminal, at least with nugget number as sort field, in described data base The a plurality of noble metal record of storage is ranked up, by multiple attribute-bits of noble metal, at least to have same No. paragraph header Arrange successively according to a number size for section sequence number with the nugget number of same block length.
In the present embodiment, owing to paragraph header and a number section sequence number being split, therefore in the case of number paragraph header is identical, Number section sequence number length is identical, and block length is inevitable the most identical.Therefore, in the present embodiment, the concrete executive mode of this step is: at least With number paragraph header of nugget number, number section sequence number and number a length of sort field of section sequence number after splitting, in described data base The a plurality of noble metal record of storage is ranked up, and with in multiple attribute-bits of noble metal, will at least have same No. paragraph header Arrange successively according to a number size for section sequence number with the nugget number of same No. section sequence number length.
After performing this step, the recording mode of the nugget number in table 3 is as shown in table 4.
Table 4 is to the recording mode after nugget number sequence
The present embodiment illustrates as a example by the sortord in above table, in practical operation, product code, Storage Cabinets The relation of the interfields such as member number, matter damage mark, number paragraph header there will be various situation, does not repeats in the present embodiment.
For sortord, in table 3 only with product code, matter damage mark identical in the case of, number paragraph header is identical, number section On the basis of sequence number length etc. are identical, arrange according to number order that section sequence number is ascending, therefore every note after sequence Arrangement sequence number in record also carries out layout with ascending order.In other embodiments, sortord can be according to business The demand of terminal is adjusted, and with the data instance of table 3, as do not considered, matter damage identifies whether identical, only consideration paragraph header With fields such as number section sequence number length, then ranking results also can be different.
In theory, sort field may also include noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights Mark, locking mark and Storage Cabinets box number, at least one.In actual mechanical process, the most at least number of including paragraph header, number section Sequence number and number section sequence number length, additionally, according to business demand, also can increase noble metal mechanism number, keeping teller number, product generation Code, matter damage the fields such as mark.
Further, at level (i.e. the priority of the sort field) aspect of sort field, also can carry out according to business demand Corresponding setting.For example, the priority of each sort field is followed successively by, and the priority of noble metal mechanism number is the highest, product generation Code takes second place, and third matter damage mark, is locked out mark, number paragraph header, number section sequence number length, number section sequence number, this feelings the most successively Under condition, it will be appreciated that for, when sequence, first by arrangement identical for noble metal mechanism number the most together, afterwards in noble metal mechanism phase With record in, by identical for product code arranged together, in the record that product code is identical, matter is damaged mark identical Arranged together, in matter damages the identical record of mark, by identical for locking mark arranged together, identical in locking mark In record, by identical for number paragraph header arranged together, in the record that number paragraph header is identical, by number arrangement that section sequence number length is identical Together, in number record that section sequence number length is identical, it is arranged in order according to a number size for section sequence number.Certainly in other embodiments In, also the quantity of sort field and priority can be adjusted correspondingly.
Step S205, complete sequence after, need after sequence every record increases the arrangement sequence number of correspondence, arrangement The arranged mode of sequence number is consistent with number sortord of section sequence number size.
This step step executive mode corresponding with a upper embodiment is identical, your gold after performing this step, in table 4 The recording mode belonging to block number is as shown in table 5.
Table 5 increases arrangement sequence number in the nugget number record after sequence
Number section sequence number of the nugget number after step S206, use sequence deducts corresponding arrangement sequence number, obtains Sequence number is poor.
After calculating sequence number difference, sequence number difference can be carried out record, the data in table 5 in data base, calculate sequence number Result after difference is as shown in table 6.As can be seen from the table, in the case of number section sequence number continuous print, sequence number difference is identical.
Table 6 calculates the recording mode between nugget number and arrangement sequence number after sequence number difference
Step S207, by multiple attribute-bits of noble metal, at least number paragraph header, block length is poor with sequence number identical Nugget number merges into consecutive number section, the noble metal information stored in data base to be shown with consecutive number section at service terminal Form show.As described in step before, in the case of number paragraph header is identical, number section sequence number length is identical, can represent Block length is identical.It should be noted that for the ease of the service terminal lookup to noble metal consecutive number section, in step S204 In, field required when searching is disposed as sort field, to avoid the need for repeating sequence as far as possible.
Service terminal is to be shown in the form of a list to the exhibition method of the consecutive number section of nugget number, one The record of consecutive number section occupies same a line of list or same string.The present embodiment preferably employs the former illustrate, such as table 7 institute Show.
Concrete, this step can use SQL, i.e. SQL (full name Structured Query Language) language, carries out Querying by group to described noble metal record, by multiple attribute-bits of noble metal, at least number Paragraph header, number section sequence number length identical nugget number poor with sequence number merge into one group, and often group is as a consecutive number section, with The noble metal information stored in data base is shown by service terminal with the form of consecutive number section.
The query script using sql like language is the simplest, strong operability, and effect is high.By table 6 medium size paragraph header, number section sequence number The identical identical block number poor with sequence number of length merges, and draws consecutive number section, shows that result example is as shown in table 7.
Table 7 is at the service terminal display form to nugget number
When service terminal shows, the quantity of the block number comprised in consecutive number section typically need to be increased, as shown above.And And, display form can be same as the prior art, does not the most comprise that setting paragraph header, sequence number be poor, the displaying of number section sequence number length, when So, it is possible to as shown in table 7, showing the situation of these fields, consecutive number Duan Zhongke after merging no longer shows sequence number, it is possible to weight New sequence number is newly set, without limitation in the present embodiment.
Additionally, in the embodiment of the present invention when noble metal information is shown by service terminal, index entry also can be arranged, with It is easy to service terminal to the lookup of noble metal storage condition in data base.In theory, the index field of this index entry includes essential Field and Optional Field, the described mandatory field number of including paragraph header, number section sequence number and number section sequence number length;Described Optional Field includes Described noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, locking mark, Storage Cabinets box number.Change Sentence is talked about, and for index field, mandatory field is the field that must be provided with, and Optional Field is dispensable, and can That thinks in above field is arbitrary one or more.Actual index entry is set time, typically multiple index word can be set selectivity Section, does not repeats in the present embodiment, arranges according to actual needs.
Further, when service terminal shows, it is also possible to according to business demand and described index entry, to described expensive Metal derby number is ranked up display and/or Pagination Display.
Above to index entry and nugget number is ranked up display and/or the setting up procedure of Pagination Display, can use JAVA program realizes.
It should be noted that the nugget split process of step S202 can be arranged on step S203, step S204, In step S205 before either step, it is also possible to be arranged on arbitrary in step S203, step S204, step S205 after, this reality Execute before example is preferably provided at step S203.In same step S203, the execution sequence of recording mechanism section sequence number length can also Do arbitrary adjustment, as long as by the curriculum offering of step S203 before step S206, to guarantee that sequence number difference is just calculating Really property.The present embodiment is only illustrated with above-mentioned execution sequence, and other execution sequence is also at the protection domain of the embodiment of the present invention Among, other execution sequence of the present embodiment repeats no more.
Additionally, at service terminal and national treasury end, when noble metal transaction and business of alloting occur, background server also needs to Nugget record in data base is made corresponding amendment.
Wherein, when service terminal generation noble metal is concluded the business, after i.e. client determines the purchase situation of noble metal, front end Business personnel will send the purchase information of noble metal data at service terminal, and afterwards, background server can revise data base In the corresponding attribute-bit of corresponding nugget number.Owing to the block information in data base is monolithic storage, therefore revise During, background server only need to directly revise the block attribute of correspondence, it is not necessary to does any piece number and searches and consecutive number section The operation such as fractionation, simplify the process logic of background server, it is to avoid when identical services takes place frequently, the work of background server The situation that process breaks down.
Concrete, in the present embodiment, when national treasury or service terminal generation noble metal allot business, recall mechanism and receiving To nugget number when recalling instruction, directly delete the nugget number recalled in data base and record, be also not required to appoint What block number is searched and the fractionation etc. of consecutive number section operates.Receiving mechanism is receiving when calling in instruction of nugget number, directly Whether being connected in data base increases the nugget number called in and records, any for being positioned at same consecutive number without carrying out The judge process etc. of section, simplifies the operation of background server.
Further, in the present embodiment when service terminal shows, may also allow for service terminal to the list in consecutive number section Block noble metal is shown and the operation such as locking, such as, when service terminal show, can show the periphery of position in consecutive number section Region arranges drop-down menu mark, clicks on this drop-down menu mark, can show multiple pieces numbers in consecutive number section.When multiple industry The Query Information that business terminal is simultaneously emitted by step S201, after triggering the adjustment of backstage nugget information, the most multiple When terminal display device shows same interface simultaneously, and multiple service terminal carries out the operations such as locking in succession to same consecutive number section Time, single piece under this consecutive number section number can be locked by certain service terminal, does not the most affect other service terminals simultaneously To operations such as the inquiry of other blocks number in this consecutive number section and lockings, thus avoid the display interface of frequent updating consecutive number section The operation inconvenience brought.
The specific implementation of aforesaid operations is: service terminal sends displaying certain or some consecutive number to background server The demand information of multiple nuggets number that section comprises, is arranged on consecutive number section viewing area as the service personal of service terminal clicks on The operation of the drop-down menu mark of territory periphery, can send what this displaying certain or some consecutive number section comprised to background server The demand information of multiple nuggets number.The displaying certain or some that background server receives the transmission of certain service terminal is continuous After the demand information of number multiple nuggets number that section comprises, the multiple nuggets number that described consecutive number section can be comprised Information be sent to described service terminal, to show multiple nuggets of comprising of described consecutive number section at described service terminal Number.
Implementation for locking nugget number is: it is single or multiple that service terminal sends locking to background server The demand information of nugget number, as after showing multiple nuggets number of comprising of consecutive number section, the service of service terminal Personnel click on the locking mark being arranged on nugget viewing area periphery, can send this locking to background server single Or the demand information of multiple nugget number.Except of course that be respectively provided with a locking mark in each nugget viewing area Outside, it is also possible to one locking mark is set at consecutive number section viewing area periphery, for locking the noble metal of whole consecutive number section Block number.
Background server receives the demand information locking single or multiple nuggets number that certain service terminal sends Afterwards, lock described single or multiple nugget number, to avoid on other service terminal in addition to described service terminal Described single or multiple nuggets number are carried out repetitive operation.The mode of concrete locking nugget number can be, in locking During certain nugget, add the mark of the service terminal sending this demand information, in order to identify and to process of exchange Record etc..
Embodiment three
The flow chart of the processing method of noble metal data disclosed in the present embodiment as it is shown on figure 3, identical with embodiment two, its The step implementation process that middle content is identical is the most identical, and the present embodiment repeats no more.
Unlike embodiment two, in the present embodiment after receiving trigger action information, add step S302, Query script to the action type that nugget record in last data base is modified, when the last time is in data base Nugget record carry out be delete block number record operation, then the processing procedure of these less noble metal data is skipped expensive Metal derby number carries out the step etc. split, and is directly entered in step 307 process being ranked up nugget number;Work as the last time The operation being to increase block number record that nugget record in data base is carried out, then the process of these less noble metal data Journey enters the process in step 305 split nugget number.
Further, in step 305 to the split process of nugget number upon execution, due to newly-increased nugget number Part attribute field be in the state of non-typing, and hence it is also possible to further increase a step, i.e. judge existing number According in the nugget number of storage in storehouse, whether it is in not in the attributes such as a number paragraph header, number section sequence number, number segment length, sequence number difference The state of typing flesh and blood, the most only carry out the fractionation of block number, number section sequence number length to the nugget number that these are newly-increased Record etc. process, to passing through in operation before, block number splits, the block number of number section sequence number record is then not repeated to carry out Corresponding process.
It should be noted that the premise implementing the present embodiment scheme is in the processing method process performing these noble metal data In, when data base at least to perform the method to the last time, nugget number is split and recording mechanism section sequence number length Result preserve.
Noble metal information in last data base is modified by the method in the present embodiment by simply adding Action type query script, take place frequently the period in business, it is to avoid need noble metal data existing in data base are carried out Repetition split process again and again, further increases the work efficiency of background server.
Embodiment four
Corresponding with embodiment of the method, present embodiment discloses a kind of noble metal data processing equipment, expensive in the present embodiment Metal derby number stores using single piece number as the form of a record in data base, and this noble metal data processing equipment is tied Composition as shown in Figure 4, specifically includes following functions module:
Receive unit 11, for receiving the demand information of service terminal, with the triggering following process to noble metal data Journey.
Sequencing unit 12, for the demand according to service terminal, at least with nugget number as sort field, to described number It is ranked up according to a plurality of noble metal record of storage in storehouse, with in multiple attribute-bits of noble metal, will at least have identical The nugget number of number paragraph header and same block length arranges successively according to a number size for section sequence number.
Sequence number adding device 13, increases the arrangement sequence number of correspondence, described arrangement sequence in every record after sequence Number arranged mode consistent with number sortord of section sequence number size.
Computing unit 14, number section sequence number of the nugget number after using sequence deducts corresponding arrangement sequence Number, obtain sequence number poor.
Combining unit 15, for by multiple attribute-bits of noble metal, at least number paragraph header, block length and sequence number is poor Identical nugget number merges into consecutive number section.
Transmitting element 16, for being sent to display device, with by data by the noble metal information after merging cell processing The form that in storehouse, the noble metal information of storage shows with consecutive number section at service terminal shows.
Additionally, also include split cells 17, for described nugget number is split, obtain each nugget number Number paragraph header and number section sequence number.
Record modification unit 18, in noble metal data handling procedure, number section sequence number increasing nugget number is long Degree and the recorded content of sequence number difference, and when receiving nugget number and recalling instruction, directly recall in deletion data base is expensive Metal derby record;When receiving nugget number and calling in instruction, in data base, directly increase the nugget number called in Record.
Corresponding with embodiment of the method, for the function of multiple nuggets number that displaying consecutive number section comprises, can be by connecing Receive unit 11 and be used for receiving multiple nuggets number that displaying certain or some consecutive number sections of certain service terminal transmission comprise Demand information, transmitting element 16 information of the multiple nuggets number described consecutive number section comprised is sent to described business Terminal, to show, at described service terminal, multiple nuggets number that described consecutive number section comprises.
Additionally, for the function locking single or multiple nuggets number, also include lock cell, for receiving unit 11 receive certain service terminal send lock single or multiple nuggets number demand information time, lock described single or Multiple nuggets number, to avoid on other service terminal in addition to described service terminal described your gold single or multiple Belong to block number and carry out repetitive operation.
In other embodiments, this noble metal data processing equipment also includes, query unit, is used for inquiring about last data The action type that in storehouse, nugget record is modified.When the last time to data base in nugget record deleted Except block number record operation time, then skip split cells 17, directly by sequencing unit 12, nugget record processed; When the last time to data base in nugget record carried out increase block number record operation time, the most successively by split cells 17, described nugget record is processed by sequencing unit 12 etc..
Embodiment five
Corresponding with embodiment of the method, present embodiment discloses a kind of noble metal data handling system, this system includes number According to storehouse, background server and at least one service terminal.Background server in the present embodiment is equivalent in a upper embodiment Processing means.
Wherein, described data base is used for storing nugget number, the described nugget number storage form in data base For single piece number as a record.
Described background server is after the demand information receiving service terminal, i.e. trigger action information, service terminal is extremely Few with nugget number as sort field, a plurality of noble metal record of storage in described data base is ranked up, with at your gold In the multiple attribute-bits belonged to, will at least there is the nugget number of same No. paragraph header and same block length according to a number section sequence number Size arrange successively, and after sequence every record increases the arrangement sequence number of correspondence, and use after sequence expensive Number section sequence number of metal derby number deducts corresponding arrangement sequence number, obtains sequence number poor, by the multiple attribute-bits at noble metal In, at least number paragraph header, block length identical nugget number poor with sequence number merges into consecutive number section, will be through block merging treatment After noble metal information be sent to display device, wherein, the sequence of the arranged mode of described arrangement sequence number and number section sequence number size Mode is consistent.
Described service terminal is for showing the form that the noble metal information stored in data base shows with consecutive number section Show.
Described background server is additionally operable to split described nugget number, obtains number section of each nugget number Head part and number section sequence number part.Further, in noble metal data handling procedure, number section sequence number length of nugget number is increased The recorded content poor with sequence number, and when receiving nugget number and recalling instruction, directly delete your gold recalled in data base Belong to block record;When receiving nugget number and calling in instruction, in data base, directly increase the nugget number note called in Record.
Corresponding with content in embodiment of the method, for the function of multiple nuggets number that displaying consecutive number section comprises, The process of implementing is, described service terminal is additionally operable to, while display consecutive number section, send exhibition to described background server Show the demand information of multiple nuggets number that certain or some consecutive number sections comprise, and show that described consecutive number section comprises many Individual nugget number.Described background server is additionally operable to receive displaying certain or some the consecutive number section that certain service terminal sends The demand information of the multiple nuggets number comprised, and the information transmission of multiple nuggets number that described consecutive number section is comprised To described service terminal.
For the function of multiple nuggets number that displaying consecutive number section comprises, in addition to implementations described above process, also Only can be realized by the processor of service terminal, the most not do too much repeating.
For locking the function of single or multiple nuggets number, the process of implementing is, described service terminal is additionally operable to The demand information locking single or multiple nuggets number is sent, to avoid except described service terminal to described background server Outside other service terminal on described single or multiple nuggets number are carried out repetitive operation;Described background server is also used In receiving the demand information locking single or multiple nuggets number that certain service terminal sends, and lock described single or many Individual nugget number.
Additionally, when noble metal information is shown by service terminal, it is also possible to index entry is set, and, it is also possible to root According to demand and the facilities of index entry of business, when showing described noble metal information, described noble metal information is arranged Sequence shows and/or Pagination Display, to facilitate business service personnel to check noble metal information.The most described service terminal is additionally operable to Index entry is set when showing described noble metal information, and described noble metal information is ranked up display and/or paging shows Show.The index field of described index entry includes mandatory field and Optional Field, the described mandatory field number of including paragraph header, number section sequence number With number section sequence number length, described Optional Field include described noble metal mechanism number, keeping teller number, product code, matter damage mark, Property rights mark, locking mark, Storage Cabinets box number.
Obviously, those skilled in the art can carry out various change and the modification essence without deviating from the present invention to the present invention God and scope.So, if these amendments of the present invention and modification belong to the scope of the claims in the present invention and equivalent technologies thereof Within, then the present invention is also intended to comprise these change and modification.

Claims (23)

1. the processing method of noble metal data, it is characterised in that nugget number in data base using single piece number as Article one, the form of record stores, and the method includes:
Receive the demand information of service terminal;
At least with nugget number as sort field, a plurality of noble metal record of storage in described data base is ranked up, with In multiple attribute-bits of noble metal, by least have the nugget number of same No. paragraph header and same block length according to number The size of section sequence number arranges successively;
Increasing the arrangement sequence number of correspondence in every record after sequence, the arranged mode of described arrangement sequence number is big with number section sequence number Little sortord is consistent;Number section sequence number using the nugget number after sequence deducts corresponding arrangement sequence number, obtains Sequence number is poor;
By in multiple attribute-bits of noble metal, at least number paragraph header, block length identical nugget number poor with sequence number closes And be consecutive number section, the form that the noble metal information stored in data base shows with consecutive number section is shown at service terminal Show.
The processing method of noble metal data the most according to claim 1, it is characterised in that described at least with nugget Number it is sort field, before or after a plurality of noble metal record of storage is ranked up in described data base, also includes:
Described nugget number is split, obtains number paragraph header and number section sequence number of each nugget number;
When before described noble metal record is ranked up, when described nugget number is split, described with noble metal Block number is sort field, in described data base storage a plurality of noble metal record be ranked up particularly as follows: at least with split after Number paragraph header of nugget number, number section sequence number and number a length of sort field of section sequence number, in described data base store many Bar noble metal record is ranked up, and with in multiple attribute-bits of noble metal, will at least have same No. paragraph header and same No. The nugget number of section sequence number length arranges successively according to a number size for section sequence number.
The processing method of noble metal data the most according to claim 2, it is characterised in that described nugget number is carried out Splitting, the concrete mode of number paragraph header part and number section sequence number part that obtain each nugget number is:
Use regular expression, inquire number paragraph header part and number section sequence number part of described nugget number, and by described number Paragraph header part and a number section sequence number part split, and obtain number paragraph header part and number section sequence number part of each nugget number.
The processing method of noble metal data the most according to claim 2, it is characterised in that use the nugget after sequence Number number section sequence number deduct corresponding arrangement sequence number, before obtaining sequence number difference, also include: record nugget number number section Sequence number length, when described paragraph header is identical and number section sequence number length is identical, described piece of number length is identical.
The processing method of noble metal data the most according to claim 1, it is characterised in that nugget number is ranked up Sort field also include noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, locking mark and At least one in Storage Cabinets box number.
The processing method of noble metal data the most according to claim 4, it is characterised in that by the multiple attributes at noble metal In mark, at least number paragraph header, block length identical nugget number poor with sequence number merges into consecutive number section, with at service terminal By the concrete mode that the noble metal information stored in data base carries out showing with the form of consecutive number section it is:
Use SQL, described noble metal record is carried out Querying by group, with by the multiple attribute marks at noble metal In knowledge, at least number paragraph header, number section sequence number length identical nugget number poor with sequence number merges into one group, and often group is as a company Continuous number section, to show the noble metal information stored in data base with the form of consecutive number section at service terminal.
The processing method of noble metal data the most according to claim 1, it is characterised in that also include: receiving your gold Belong to when recalling instruction of block number, delete the nugget record recalled in data base;Receiving calling in of nugget number During instruction, data base increases the nugget record called in.
8. according to the processing method of the noble metal data described in any one of claim 1-7, it is characterised in that to institute in data base The recording mode stating nugget number is, carries out record in the form of a list, and a record occupies same a line or same of list Row;Service terminal is to be shown in the form of a list to the exhibition method of the consecutive number section of nugget number, a consecutive number The record of section occupies same a line of list or same string.
The processing method of noble metal data the most according to claim 2, it is characterised in that when to described noble metal record Before being ranked up, when described nugget number is split, after the demand information of described reception service terminal, also wrap Include:
The action type that nugget record in data base is modified by the inquiry last time;
When the last time to data base in nugget record carried out delete block number record operation time, then skip described expensive Metal derby number carries out the step split, and enters the described step being ranked up a plurality of noble metal record of storage in described data base Suddenly;
When the last time to data base in nugget record carried out increase block number record operation time, then enter described expensive Metal derby number carries out the step split.
The processing method of noble metal data the most according to claim 2, it is characterised in that also include:
Receive the demand letter showing multiple nuggets number of comprising of certain or some consecutive number sections that certain service terminal sends Breath;
The information of the multiple nuggets number described consecutive number section comprised is sent to described service terminal, with in described business eventually End shows multiple nuggets number that described consecutive number section comprises.
The processing method of 11. noble metal data according to claim 10, it is characterised in that also include:
Receive the demand information locking single or multiple nuggets number that certain service terminal sends;
Lock described single or multiple nugget number, right to avoid on other service terminal in addition to described service terminal Described single or multiple nugget number carries out repetitive operation.
12. 1 kinds of noble metal data processing equipments, it is characterised in that nugget number in data base using single piece number as one The form of bar record stores, and this processing means includes:
Receive unit, for receiving the demand information of service terminal;
Sequencing unit, for a plurality of noble metal note at least with nugget number as sort field, to storage in described data base Record is ranked up, and with in multiple attribute-bits of noble metal, will at least have the expensive of same No. paragraph header and same block length Metal derby number arranges successively according to a number size for section sequence number;
Sequence number adding device, increases the arrangement sequence number of correspondence, the volume of described arrangement sequence number in every record after sequence Row's mode is consistent with number sortord of section sequence number size;
Computing unit, number section sequence number of the nugget number after using sequence deducts corresponding arrangement sequence number, obtains Sequence number is poor;
Combining unit, for by multiple attribute-bits of noble metal, at least number paragraph header, block length is poor with sequence number identical Nugget number merges into consecutive number section;
Transmitting element, for being sent to display device, will deposit in data base by the noble metal information after merging cell processing The form that the noble metal information of storage shows with consecutive number section at service terminal shows.
13. noble metal data processing equipments according to claim 12, it is characterised in that also include: split cells, be used for Described nugget number is split, obtains number paragraph header part and number section sequence number part of each nugget number.
14. noble metal data processing equipments according to claim 13, it is characterised in that also include: record modification unit, For in noble metal data handling procedure, increase number section sequence number length and the recorded content of sequence number difference of nugget number, and When receiving nugget number and recalling instruction, delete the nugget record recalled in data base;Receiving noble metal When block number calls in instruction, data base increases the nugget record called in.
15. noble metal data processing equipments according to claim 13, it is characterised in that also include: query unit, be used for The action type that in the last data base of inquiry, nugget record is modified.
16. noble metal data processing equipments according to claim 13, it is characterised in that also include: information locking unit, For receiving, at described reception unit, the demand information locking single or multiple nuggets number that certain service terminal sends Time, lock described single or multiple nugget number.
17. 1 kinds of noble metal data handling systems, it is characterised in that include data base, background server and at least one business Terminal;
Wherein, described data base is used for storing nugget number, and the described nugget number storage form in data base is single Individual block number is as a record;
Described background server is after the demand receiving service terminal, at least with nugget number as sort field, to described In data base, a plurality of noble metal record of storage is ranked up, and with in multiple attribute-bits of noble metal, will at least have phase The nugget number of jack per line paragraph header and same block length arranges successively according to a number size for section sequence number, and after sequence Every record increases the arrangement sequence number of correspondence, and uses a number section sequence number for the nugget number after sequence to deduct corresponding Arrangement sequence number, obtains sequence number poor, by multiple attribute-bits of noble metal, and at least number paragraph header, block length and sequence number difference phase Same nugget number merges into consecutive number section, and the noble metal information after block merging treatment is sent to display device, its In, the arranged mode of described arrangement sequence number is consistent with number sortord of section sequence number size;
Described service terminal is for showing the form that the noble metal information stored in data base shows with consecutive number section.
18. noble metal data handling systems according to claim 17, it is characterised in that described background server is additionally operable to Described nugget number is split, obtains number paragraph header and number section sequence number of each nugget number.
19. noble metal data handling systems according to claim 18, it is characterised in that described background server is additionally operable to In noble metal data handling procedure, increase number section sequence number length and the recorded content of sequence number difference of nugget number, and connecing Receive nugget number when recalling instruction, directly delete the nugget record recalled in data base;Receiving noble metal When block number calls in instruction, in data base, directly increase the nugget record called in.
20. noble metal data handling systems according to claim 17, it is characterised in that described service terminal is additionally operable to Arranging index entry when showing described noble metal information, the index field of described index entry includes mandatory field and Optional Field, institute State the mandatory field number of including paragraph header, number section sequence number and number section sequence number length, described Optional Field include described noble metal mechanism number, Keeping teller number, product code, matter damage mark, property rights mark, locking mark, Storage Cabinets box number.
21. noble metal data handling systems according to claim 20, it is characterised in that described service terminal is additionally operable to When showing described noble metal information, described noble metal information is ranked up display and/or Pagination Display.
22. noble metal data handling systems according to claim 17, it is characterised in that described service terminal is additionally operable to While display consecutive number section, send the multiple noble metals showing that certain or some consecutive number sections comprise to described background server The demand information of block number, and show multiple nuggets number that described consecutive number section comprises;Described background server is additionally operable to connect That receives that certain service terminal sends shows the demand information of multiple nuggets number that certain or some consecutive number sections comprise, and will The information of multiple nuggets number that described consecutive number section comprises is sent to described service terminal.
23. noble metal data handling systems according to claim 22, it is characterised in that described service terminal be additionally operable to Described background server send lock single or multiple nuggets number demand information, with avoid except described service terminal it On other outer service terminal, described single or multiple nuggets number are carried out repetitive operation;Described background server is additionally operable to Receive the demand information locking single or multiple nuggets number that certain service terminal sends, and lock described single or multiple Nugget number.
CN201610461141.2A 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data Active CN106126633B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610461141.2A CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610461141.2A CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Publications (2)

Publication Number Publication Date
CN106126633A true CN106126633A (en) 2016-11-16
CN106126633B CN106126633B (en) 2019-10-18

Family

ID=57267996

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610461141.2A Active CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Country Status (1)

Country Link
CN (1) CN106126633B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109544239A (en) * 2018-11-26 2019-03-29 广州每金珠宝有限公司 A kind of red packet management method based on gold product monomer
CN112860780A (en) * 2021-03-30 2021-05-28 中国工商银行股份有限公司 Data export method and device and terminal equipment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050240843A1 (en) * 2004-04-26 2005-10-27 Joerg Steinmann Method, computer program and device for deleting data sets contained in a data list from a table system
CN101751406A (en) * 2008-12-18 2010-06-23 赵伟 Method and device for realizing column storage based relational database
CN101751475A (en) * 2010-01-08 2010-06-23 联动优势科技有限公司 Method for compressing section records and device therefor
CN102163226A (en) * 2011-04-12 2011-08-24 浙江大学 Adjacent sorting repetition-reducing method based on Map-Reduce and segmentation

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050240843A1 (en) * 2004-04-26 2005-10-27 Joerg Steinmann Method, computer program and device for deleting data sets contained in a data list from a table system
CN101751406A (en) * 2008-12-18 2010-06-23 赵伟 Method and device for realizing column storage based relational database
CN101751475A (en) * 2010-01-08 2010-06-23 联动优势科技有限公司 Method for compressing section records and device therefor
CN102163226A (en) * 2011-04-12 2011-08-24 浙江大学 Adjacent sorting repetition-reducing method based on Map-Reduce and segmentation

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109544239A (en) * 2018-11-26 2019-03-29 广州每金珠宝有限公司 A kind of red packet management method based on gold product monomer
CN112860780A (en) * 2021-03-30 2021-05-28 中国工商银行股份有限公司 Data export method and device and terminal equipment

Also Published As

Publication number Publication date
CN106126633B (en) 2019-10-18

Similar Documents

Publication Publication Date Title
CN109086394B (en) Search ranking method and device, computer equipment and storage medium
CN110113200A (en) The correlating method of chain-circuit system and log system, device and storage medium
CN110245069B (en) Page version testing method and device and page display method and device
CN104243273A (en) Method and device for displaying information on instant messaging client and information display system
CN103095737A (en) Handling method and device of browsing information through network
CN107590386B (en) Security event information processing method and device, storage medium and computer equipment
CN107704202A (en) A kind of method and apparatus of data fast reading and writing
CN110134929A (en) Document verification method, apparatus, computer equipment and storage medium
CN110781183A (en) Method and device for processing incremental data in Hive database and computer equipment
CN108073707B (en) Financial business data updating method and device and computer readable storage medium
CN113760839A (en) Log data compression processing method and device, electronic equipment and storage medium
CN106126633A (en) The processing method of noble metal data, device and system
CN110489032B (en) Dictionary query method for electronic book and electronic equipment
CN112052259A (en) Data processing method, device, equipment and computer storage medium
US20170171128A1 (en) Method and electronic device for email processing
CN107341105A (en) Information processing method, terminal and server
CN108829882B (en) Information collection method, device, terminal and medium
US9020931B2 (en) System and method for enhancing search experience of a user of a communication device
CN112650791B (en) Method, device, computer equipment and storage medium for processing field
WO2021129849A1 (en) Log processing method, apparatus and device, and storage medium
JPH11134410A (en) Method for displaying securities information and terminal equipment for the same
CN116263770A (en) Method, device, terminal equipment and medium for storing business data based on database
CN113656731A (en) Advertisement page processing method and device, electronic equipment and storage medium
JP2018013819A (en) Business matching support system, and business matching support method
JP6338758B1 (en) Distribution system, distribution method and program

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant