CN110060051A - A kind of date storage method, calculates equipment and storage medium at device - Google Patents
A kind of date storage method, calculates equipment and storage medium at device Download PDFInfo
- Publication number
- CN110060051A CN110060051A CN201811589793.XA CN201811589793A CN110060051A CN 110060051 A CN110060051 A CN 110060051A CN 201811589793 A CN201811589793 A CN 201811589793A CN 110060051 A CN110060051 A CN 110060051A
- Authority
- CN
- China
- Prior art keywords
- element value
- character string
- value character
- code
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90344—Query processing by using string matching techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/389—Keeping log of transactions for guaranteeing non-repudiation of a transaction
Abstract
This specification provides a kind of date storage method, device, calculates equipment and storage medium, wherein the data storage method includes: to receive the first payment detail, sets major key according to the first payment detail；The sorting elements combination and element value of the first payment detail are inquired by the major key；The sorting elements combination and the element value are spliced, first element value character string is generated；Being inquired according to the first element value character string whether there is corresponding basic code in database；In the database there is no in the case where basic code corresponding with the first element value character string, corresponding first basic code of the first element value character string is increased newly in the database.
Description
Technical field
This specification is related to Internet technical field, in particular to a kind of date storage method, device calculate equipment and deposit
Storage media.
Background technique
System for settling account first has to define sorting element, can be the payment with identical sorting element value when accepting payment detail
Detail distributes identical basic code, and after accepting payment detail, the asynchronous batch of meeting carries out sorting to payment detail, and sorting element is fixed
Adopted is too many, and the combination that will lead to element value is very more, and the dimension granularity for also allowing for summarizing is too thin, and the effect summarized is not achieved
Fruit.And if sorting element define it is very little will lead to summarize dimension granularity it is too thick, be unable to satisfy what business was individually cleared
Demand.So multi-party factor can be comprehensively considered when building system for settling account, extracts key element and form sorting element, as far as possible
Reach not only meet business clearance demand, but also be unlikely to clear element it is excessive.
Sorting elements combination is solidificated in code by existing most of systems for settling account after defining sorting element, and
Business is that occur with the development of business, might have new element, and need to add new element continuous developing
Enter into sorting element, and system for settling account is not often supported to expand sorting element, is unable to satisfy the clearance demand of business.If into
The transformation of row system code, new element is added in sorting elements combination, and can generate fresh code and old data are incompatible asks
Topic, the system reform and data moving costs are very high.
Summary of the invention
In view of this, this specification embodiment provides a kind of date storage method, device, calculates equipment and storage is situated between
Matter, to solve technological deficiency existing in the prior art.
According to this specification embodiment in a first aspect, providing a kind of date storage method, comprising:
The first payment detail is received, major key is set according to the first payment detail；
The sorting elements combination and element value of the first payment detail are inquired by the major key；
The sorting elements combination and the element value are spliced, first element value character string is generated；
Being inquired according to the first element value character string whether there is corresponding basic code in database；
In the case where basic code corresponding with the first element value character string is not present in the database,
Increase corresponding first basic code of the first element value character string in database.
Optionally, further includes:
In the case where there is basic code corresponding with the first element value character string in the database, multiplexing
The corresponding basic code of the first element value character string.
Optionally, further includes:
The basic code paid in the corresponding element value character string inquiry database of detail according to every, every payment is bright
Thin corresponding basic code is added in counterpart expenditure detail；
Payment detail with identical basic code is summarized and cleared.
Optionally, the basic code paid in the corresponding element value character string inquiry database of detail according to every,
Before the corresponding basic code of every payment detail is added in counterpart expenditure detail further include:
The sorting elements combination for splicing the element value character string comes into effect in the time of setting.
Optionally, the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the first payment detail.
Optionally, the element value character string basic generation corresponding with the element value character string is stored in the database
Code and the sorting elements combination for splicing the element value character string.
According to the second aspect of this specification embodiment, a kind of data storage device is provided, comprising:
Receiving module: being configured as receiving the first payment detail, sets major key according to the first payment detail；
First enquiry module: be configured as inquiring by the major key the first payment detail sorting elements combination and
Element value；
Splicing module: being configured as splicing the sorting elements combination and the element value, generates the first element
It is worth character string；
Second enquiry module: it is configured as being inquired in database according to the first element value character string with the presence or absence of correspondence
Basic code；
Increase module: being configured as that base corresponding with the first element value character string is not present in the database
In the case where this code, increase corresponding first basic code of the first element value character string in the database.
Optionally, further includes:
In the case where there is basic code corresponding with the first element value character string in the database, multiplexing
The corresponding basic code of the first element value character string.
Optionally, further includes:
Adding unit: it is configured as being paid according to every basic in the corresponding element value character string inquiry database of detail
The corresponding basic code of every payment detail is added in counterpart expenditure detail by code；
Summarize clearance unit: being configured as that will there is the payment detail of identical basic code to be summarized and cleared.
Optionally, the adding unit is configured to:
The sorting elements combination for splicing the element value character string comes into effect in the time of setting.
Optionally, the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the first payment detail.
Optionally, the element value character string basic generation corresponding with the element value character string is stored in the database
Code and the sorting elements combination for splicing the element value character string.
According to the third aspect of this specification embodiment, a kind of calculating equipment is provided, including memory, processor and deposit
The computer instruction that can be run on a memory and on a processor is stored up, the processor realizes the number when executing described instruction
The step of according to storage method.
According to the fourth aspect of this specification embodiment, a kind of computer readable storage medium is provided, is stored with meter
The step of calculation machine instruction, which realizes the date storage method when being executed by processor.
In this specification embodiment, by receiving the first payment detail, major key is set according to the first payment detail, is led to
Cross the major key inquire it is described first payment detail sorting elements combination and element value, by the sorting elements combination with it is described
Element value is spliced, generate first element value character string, according to the first element value character string inquire database in whether
There are corresponding basic codes, and basic code corresponding with the first element value character string is not present in the database
In the case where, corresponding first basic code of the first element value character string is increased newly in the database, by increasing described newly
The mode of one basic code has expanded corresponding sorting element, by reaching in the case where not influencing system for settling account upstream and downstream
The effect of sorting element is expanded.
Detailed description of the invention
Fig. 1 is the structure chart for the calculating equipment that one embodiment of this specification provides；
Fig. 2 is the flow chart for the date storage method that one embodiment of this specification provides；
Fig. 3 is the structural representation of sorting element being applied in date storage method that one embodiment of this specification provides
Figure；
Fig. 4 is the flow chart for the date storage method that one embodiment of this specification provides；
Fig. 5 is the flow chart for the date storage method that one embodiment of this specification provides；
Fig. 6 is the structural schematic diagram for the data storage device that one embodiment of this specification provides.
Specific embodiment
Many details are explained in the following description in order to fully understand the application.But the application can be with
Much it is different from other way described herein to implement, those skilled in the art can be without prejudice to the application intension the case where
Under do similar popularization, therefore the application is not limited by following public specific implementation.
The term used in this specification one or more embodiment be only merely for for the purpose of describing particular embodiments,
It is not intended to be limiting this specification one or more embodiment.In this specification one or more embodiment and appended claims
The "an" of singular used in book, " described " and "the" are also intended to including most forms, unless context is clearly
Indicate other meanings.It is also understood that term "and/or" used in this specification one or more embodiment refers to and includes
One or more associated any or all of project listed may combine.
It will be appreciated that though may be retouched using term first, second etc. in this specification one or more embodiment
Various information are stated, but these information should not necessarily be limited by these terms.These terms are only used to for same type of information being distinguished from each other
It opens.For example, first can also be referred to as second, class in the case where not departing from this specification one or more scope of embodiments
As, second can also be referred to as first.Depending on context, word as used in this " if " can be construed to
" ... when " or " when ... " or " in response to determination ".
Firstly, the vocabulary of terms being related to one or more embodiments of the invention explains.
System for settling account: system for settling account refers in payment transaction system that the system for undertaking fund clearing responsibility, responsible transaction relates to
And inter-agency fund clearing, mainly include sorting and pay off two parts.System for settling account includes at least following element: payment
People；The requestee bank of deposit；Bill clearing institute；Payee；Payee bank of deposit.
Sorting: being the data preparation stage of clearance, payment instruction is summarized, is calculated, calculate it is inter-agency receivable
Deal with relationship and specific stroke count, the amount of money.
Pay off: after the completion of sorting, the result based on sorting is completed true fund and is completed a business transaction.
Sorting element: sorting element refers to the dimension of sorting, carries out collect statistics to payment instruction according to certain dimension,
For example, common sorting will be known as product code, event code, mechanism ID, channel of disbursement, currency type etc..
Basic code: a number code is abstract to one kind of sorting element value and is represented, each sorting will be known as
One value set, the value of multiple sorting elements, which carries out permutation and combination, can produce multiple sorting element value combinations, system for settling account
A basic code can be distributed for the combination of each sorting element value, it is subsequent that payment detail is converged by basic code dimension
Always.
In this application, it provides a kind of date storage method, device, calculate equipment and storage medium, in following reality
It applies in example and is described in detail one by one.
Fig. 1 is to show the structural block diagram of the calculating equipment 100 according to one embodiment of this specification.The calculating equipment 100
Component include but is not limited to memory 110 and processor 120.Processor 120 is connected with memory 110 by bus 130,
Database 150 is for saving data.
Calculating equipment 100 further includes access device 140, access device 140 enable calculate equipment 100 via one or
Multiple networks 160 communicate.The example of these networks includes public switched telephone network (PSTN), local area network (LAN), wide area network
(WAN), the combination of the communication network of personal area network (PAN) or such as internet.Access device 140 may include wired or wireless
One or more of any kind of network interface (for example, network interface card (NIC)), such as IEEE802.11 wireless local area
Net (WLAN) wireless interface, worldwide interoperability for microwave accesses (Wi-MAX) interface, Ethernet interface, universal serial bus (USB) connect
Mouth, cellular network interface, blue tooth interface, near-field communication (NFC) interface, etc..
In one embodiment of this specification, unshowned other component in above-mentioned and Fig. 1 of equipment 100 is calculated
It can be connected to each other, such as pass through bus.It should be appreciated that calculating device structure block diagram shown in FIG. 1 is merely for the sake of example
Purpose, rather than the limitation to this specification range.Those skilled in the art can according to need, and increase or replace other portions
Part.
Calculating equipment 100 can be any kind of static or mobile computing device, including mobile computer or mobile meter
Calculate equipment (for example, tablet computer, personal digital assistant, laptop computer, notebook computer, net book etc.), movement
Phone (for example, smart phone), wearable calculating equipment (for example, smartwatch, intelligent glasses etc.) or other kinds of shifting
Dynamic equipment, or the static calculating equipment of such as desktop computer or PC.Calculating equipment 100 can also be mobile or state type
Server.
Wherein, processor 120 can execute the step in date storage method shown in Fig. 2.Fig. 2 shows according to this explanation
The flow chart of the date storage method of one embodiment of book, including step 202 is to step 210.
Step 202: receiving the first payment detail, major key is set according to the first payment detail.
In one embodiment of this specification, the first payment detail can be shopping or payment etc., according to described first
The major key that payment detail is set, which can be, sets major key as product code, event code and exchange hour or the setting according to shopping
Major key can be according to payment set major key as mechanism ID, channel of disbursement and currency type.
In one embodiment of this specification, the product code is used for differentiated service scene, and the event code is for distinguishing scene
In event, the exchange hour passes through the entry-into-force time for judging whether the entry-into-force time of sorting elements combination comes into force
Carry out version management, the channel of disbursement for distinguishing payment method in scene, the mechanism ID for distinguishing paying entity,
The channel of disbursement is for distinguishing pay charge way, and the currency type is for distinguishing applied currency type of paying the fees.
Step 204: the sorting elements combination and element value of the first payment detail are inquired by the major key.
In one embodiment of this specification, the sorting elements combination is sorting element composition, and pays with described first
The major key of detail setting is corresponding, if the major key is set as product code, event code and channel of disbursement, inquires described first
The sorting elements combination for paying detail is productCode^eventCode^mop, and the corresponding element value can be product code
001, event code 002, channel of disbursement abc001.
In one embodiment of this specification, in the undefined sorting elements combination in the case where product code concept, Ke Yiyong
Other fields form product code, are used for differentiated service scene.
Step 206: the sorting elements combination and the element value being spliced, first element value character string is generated.
Referring to Fig. 3, the sorting elements combination of the first payment detail is productCode^eventCode^instID, described
Corresponding element value can be product code 001, event code 002, and mechanism ID is ABC, and the element value character string of splicing is
ProductCode:001^eventCode:002^instID:ABC.
Step 208: being inquired according to the first element value character string whether there is corresponding basic code in database.
In one embodiment of this specification, the corresponding basic code of each element value character string in the database, according to
The first element value character string being spliced into is inquired in the database with the presence or absence of corresponding basic code.
Step 210: there is no basic codes corresponding with the first element value character string in the database
In the case of, increase corresponding first basic code of the first element value character string in the database.
Referring to Fig. 3, if the sorting elements combination of the first payment detail is productCode^eventCode^instID, institute
Stating corresponding element value is product code 001, and event code 002, mechanism ID is ABC, and the element value character string of splicing then can be
ProductCode:001^eventCode:002^instID:ABC, inquiring the corresponding basic code of the first payment detail can
Think 1001.
In one embodiment of this specification, there is no corresponding with the first element value character string basic in the database
Code increases corresponding first basic code of first element value character string newly in the database, by increasing first element value newly
The method of corresponding first basic code of character string, increases new sorting elements combination, increases sorting element by this method
Set avoids the influence to system for settling account upstream and downstream.
In one embodiment of this specification, by receiving the first payment detail, major key is set according to the first payment detail,
The sorting elements combination and element value that the first payment detail is inquired by the major key, by the sorting elements combination and institute
It states element value to be spliced, generates first element value character string, being inquired in database according to the first element value character string is
No there are corresponding basic codes, and basic generation corresponding with the first element value character string is not present in the database
In the case where code, corresponding first basic code of the first element value character string is increased newly in the database, by newly-increased described
The method of first basic code has expanded corresponding sorting element, by reaching in the case where not influencing system for settling account upstream and downstream
To the effect for having expanded sorting element.
Fig. 4 is to show the date storage method of one embodiment of this specification, and the date storage method is to expand expansion
Sorting element is described, including step 402 is to step 414.
Step 402: receiving the first payment detail, major key is set according to the first payment detail.
In one embodiment of this specification, the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the payment detail.
In practical applications, a payment detail is received described in certain system for settling account, and major key is set according to payment detail, it is described
Major key may include product code, event code, exchange hour and channel of disbursement, wherein the product code is used for differentiated service scene,
The event code is used to distinguish event in scene, the exchange hour be used to judge sorting elements combination entry-into-force time whether
It comes into force, version management is carried out by the entry-into-force time, the channel of disbursement is for distinguishing payment method in scene；It is clear at this
In the case where not having product code and event code in calculation system, master can be formed with the field of other energy differentiated service scenes and event
Key section.
In practical applications, the setting major key further includes mechanism ID and currency etc., and this specification does not do any limit to this
It is fixed.
Step 404: the sorting elements combination and element value of the first payment detail are inquired by the major key.
In practical applications, handle a payment detail, the major key of certain system for settling account setting include product code, event code,
Mechanism ID, currency, channel of disbursement and trade company ID are according to the sorting elements combination that the major key of setting inquires the payment detail
ProductCode^eventCode^instID^currency^mop^pid, element value are respectively that product code is 001, event code
Be 101, mechanism ID be ABC, currency be RMB, channel of disbursement is abc001 and trade company ID is 123.
Step 406: the sorting elements combination and the element value being spliced, first element value character string is generated.
In practical applications, handle a payment detail, the major key of certain system for settling account setting include product code, event code,
Mechanism ID, currency, channel of disbursement and trade company ID are according to the sorting elements combination that the major key of setting inquires the payment detail
ProductCode^eventCode^instID^currency^mop^pid, element value are respectively that product code is 001, event code
Be 101, mechanism ID be ABC, currency be CNY (China Yuan: RMB), channel of disbursement is abc001 and trade company ID is 123.
It is by the element value character string that the sorting elements combination and the element value carry out splicing generation
ProductCode:001^eventCode:101^instID:ABC^currency:CNY^mo p:abc001^pid:123.
In one embodiment of this specification, the splicing is that sorting elements combination and corresponding element value are spliced.
Step 408: being inquired according to the first element value character string whether there is corresponding basic code in database, if
It is to then follow the steps 412, if it is not, thening follow the steps 410.
In one embodiment of this specification, the element value character string and the element value character string are stored in the database
Corresponding basic code and the sorting elements combination for splicing the element value character string.
In practical applications, handle a payment detail, the major key of certain system for settling account setting include product code, event code,
Mechanism ID, currency, channel of disbursement and trade company ID are according to the sorting elements combination that the major key of setting inquires the payment detail
ProductCode^eventCode^instID^currency^mop^pid, element value are respectively that product code is 001, event code
Be 101, mechanism ID be ABC, currency be CNY, channel of disbursement is abc001 and trade company ID is 123, by the sorting elements combination
The element value character string that splicing generation is carried out with the element value is productCode:001^eventCode:101^instID:
ABC^currency:CNY^mop:abc001^pid:123 is searched in the database according to the element value character string of the generation
With the presence or absence of corresponding basic code.
In one embodiment of this specification, the corresponding basic code of the element value character string of the generation splices element value
The sorting elements combination and basic code of character string are stored in database.
Step 410: there is no basic codes corresponding with the first element value character string in the database
In the case of, increase corresponding first basic code of the first element value character string in the database.
In practical applications, handle a payment detail, the major key of certain system for settling account setting include product code, event code,
Mechanism ID, currency, channel of disbursement and trade company ID are according to the sorting elements combination that the major key of setting inquires the payment detail
ProductCode^eventCode^instID^currency^mop^pid, element value are respectively that product code is 001, event code
Be 101, mechanism ID be ABC, currency be CNY, channel of disbursement is abc001 and trade company ID is 123, by the sorting elements combination
The element value character string that splicing generation is carried out with the element value is productCode:001^eventCode:101^instID:
ABC^currency:CNY^mop:abc001^pid:123.
Pass through the element value character string productCode:001^eventCode:101^instID:ABC^
Currency:CNY^mop:abc001^pid:123 is inquired and corresponding basic code is not present in database, by the element value
Character string increases the basic code 002 being not present in a database newly, and basic code 002 is not present in the database, passes through
The mode of newly-increased basic code increases new sorting element, the method for realizing sorting element in expanding data library；Or it is described
It is described one basic code 003 of element value string matching, by institute in database in the case where undefined any sorting element
It states the corresponding element value character string of basic code 003 and the corresponding sorting element of element value character string is stored to the database
In, the system for settling account can identify sorting elements combination productCode^eventCode^instID^currency^mop^
Pid can dynamically increase the database of system for settling account by this method, clear suitable for different payment details.
Step 412: there are the feelings of basic code corresponding with the first element value character string in the database
Under condition, it is multiplexed the corresponding basic code of the first element value character string.
In practical applications, handle a payment detail, the major key of certain system for settling account setting include product code, event code,
Mechanism ID, currency, channel of disbursement and trade company ID are according to the sorting elements combination that the major key of setting inquires the payment detail
ProductCode^eventCode^instID^currency^mop^pid, element value are respectively that product code is 001, event code
Be 101, mechanism ID be ABC, currency be CNY, channel of disbursement is abc001 and trade company ID is 123, by the sorting elements combination
The element value character string that splicing generation is carried out with the element value is productCode:001^eventCode:101^instID:
ABC^currency:CNY^mop:abc001^pid:123.
Pass through the element value character string productCode:001^eventCode:101^instID:ABC^
Currency:CNY^mop:abc001^pid:123, inquire database in there are corresponding basic code be 001, by basic generation
Code 001 is filled into the down-stream system that the system for settling account is arrived in the payment detail, carries out the clearance for handling the payment detail.
Step 414: the payment detail with identical basic code is summarized and cleared.
In one embodiment of this specification, the base that the corresponding element value character string of detail is inquired in database is paid according to every
The corresponding basic code of every payment detail is added in counterpart expenditure detail by this code；It will be with identical basic code
Payment detail is summarized and is cleared.
It is described according in the corresponding element value character string inquiry database of every payment detail in one embodiment of this specification
Basic code, before the corresponding basic code of every payment detail is added in counterpart expenditure detail further include: splicing institute
The sorting elements combination for stating element value character string comes into effect in the time of setting.
In practical applications, certain system for settling account by calculate 4 payment details, respectively payment detail 1, pay detail 2,
Detail 3 and payment detail 4 are paid, wherein the payment detail 1 that every payment detail is inquired by element value character string is basic
Code, which is 001, the basic code of payment detail 2 is 001, pays the basic code of detail 3 is 002 and pays the basic of detail 4
Code is 002, and system for settling account is cleared together by summarizing the payment detail of identical basic code, pays 1 He of detail
Payment detail 2, which summarizes, is cleared, and payment detail 3 summarizes with payment detail 4 is cleared.
In one embodiment of this specification, by receiving the first payment detail, major key is set according to the first payment detail,
The sorting elements combination and element value that the first payment detail is inquired by the major key, by the sorting elements combination and institute
It states element value to be spliced, generates first element value character string, being inquired in database according to the first element value character string is
No there are corresponding basic codes, and basic generation corresponding with the first element value character string is not present in the database
In the case where code, corresponding first basic code of the first element value character string is increased newly in the database, by newly-increased described
The mode of first basic code has expanded corresponding sorting elements combination, by the case where not influencing system for settling account upstream and downstream
Under, achieve the effect that have expanded new sorting element.
Fig. 5 is to show the date storage method of one embodiment of this specification, and the date storage method to be to certain clearance
System, which increases, to be described for sorting element, including step 502 is to step 514.
Step 502: system for settling account receives payment detail, sets major key according to payment detail.
In one embodiment of this specification, system for settling account receives payment detail, and the payment detail can be one or more
Pen sets major key according to payment detail, and the major key can be product code, event code, mechanism ID and channel of disbursement.
Step 504: the sorting elements combination and element value of payment detail are inquired according to major key.
In one embodiment of this specification, institute is inquired according to the major key product code of setting, event code, mechanism ID and channel of disbursement
The sorting elements combination and element value of payment detail are stated, the corresponding sorting elements combination of the major key is productCode^
EventCode^instID^mop, the corresponding element value of the major key be product code be 001, event code 002, mechanism ID are
ABC and channel of disbursement are abc001.
Step 506: sorting elements combination and element value being spliced, forming element value character string.
In one embodiment of this specification, sorting elements combination is productCode^eventCode^instID^mop,
Plain value be product code be 001, event code 002, mechanism ID are ABC and channel of disbursement is abc001, by the sorting element collection
Closing and carrying out splicing forming element value character string with the element value is productCode:001^eventCode:002^instID:
ABC^mop:abc001.
Step 508: being inquired according to element value character string whether there is corresponding basic code in database, if so, holding
Row step 510, if it is not, thening follow the steps 512.
It is productCode:001^ according to the element value character string that payment detail generates in one embodiment of this specification
EventCode:002^instID:ABC^mop:abc001, by the element value character string inquire in the database whether
There are corresponding basic codes.
Step 510: there is basic code corresponding with element value character string in database, basic code filling payment is bright
Detail.
In one embodiment of this specification, by inquiring in the database element value character existed with the payment detail
It goes here and there in the case where corresponding basic code, passes through element value character string productCode:001^eventCode:002^
InstID:ABC^mop:abc001, inquire database in there are corresponding basic code be 001, the basic code 001 is filled out
Enter in the payment detail, waiting summarizes clearance.
Step 512: basic code corresponding with element value character string being not present in database, increases newly and wants in the database
Corresponding first basic code of element value character string.
In one embodiment of this specification, by inquiring in the database element value word not existed with the payment detail
Symbol is gone here and there in the case where corresponding basic code, is element value character string productCode:001^eventCode:002^
InstID:ABC^mop:abc001 generates new basic code 002, by the corresponding basic code 002 of the element value character string
It is added in database, increases corresponding element value character string and sorting elements combination in the database newly.
Step 514: the payment detail of identical basic code is summarized and cleared.
In one embodiment of this specification, the corresponding basic code of every payment detail is added to corresponding payment detail
In, the more identical basic codes of payment detail are summarized, the payment detail of identical basic code is cleared.
In one embodiment of this specification, by receiving the first payment detail, major key is set according to the first payment detail,
The sorting elements combination and element value that the first payment detail is inquired by the major key, by the sorting elements combination and institute
It states element value to be spliced, generates first element value character string, being inquired in database according to the first element value character string is
No there are corresponding basic codes, and basic generation corresponding with the first element value character string is not present in the database
In the case where code, corresponding first basic code of the first element value character string is increased newly in the database, by newly-increased described
The mode of first basic code has expanded corresponding sorting elements combination, by the case where not influencing system for settling account upstream and downstream
Under, achieve the effect that have expanded new sorting element.
Corresponding with above method embodiment, this specification additionally provides data storage device embodiment, and Fig. 6 shows this
The structural schematic diagram of the data storage device of specification one embodiment.As shown in fig. 6, the device 600 includes:
Receiving module 602: being configured as receiving the first payment detail, sets major key according to the first payment detail；
First enquiry module 604: it is configured as inquiring the sorting element collection of the first payment detail by the major key
It closes and element value；
Splicing module 606: being configured as splicing the sorting elements combination and the element value, generates first and wants
Element value character string；
Second enquiry module 608: being configured as being inquired in database according to the first element value character string whether there is
Corresponding basic code；
Increase module 610: being configured as being not present in the database corresponding with the first element value character string
Basic code in the case where, increase corresponding first basic code of the first element value character string in the database.
In an optional embodiment, further includes:
In the case where there is basic code corresponding with the first element value character string in the database, multiplexing
The corresponding basic code of the first element value character string.
In an optional embodiment, further includes:
Adding unit: it is configured as being paid according to every basic in the corresponding element value character string inquiry database of detail
The corresponding basic code of every payment detail is added in counterpart expenditure detail by code；
Summarize clearance unit: being configured as that will there is the payment detail of identical basic code to be summarized and cleared.
In an optional embodiment, the adding unit is configured to:
The sorting elements combination for splicing the element value character string comes into effect in the time of setting.
In an optional embodiment, the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the first payment detail.
In an optional embodiment, the element value character string and the element value character string are stored in the database
Corresponding basic code and the sorting elements combination for splicing the element value character string.
The first payment detail is received, major key is set according to the first payment detail；Described the is inquired by the major key
The sorting elements combination and element value of one payment detail；The sorting elements combination and the element value are spliced, generated
First element value character string；Being inquired according to the first element value character string whether there is corresponding basic code in database；
In the case where basic code corresponding with the first element value character string is not present in the database, in the database
Increase corresponding first basic code of the first element value character string newly.
A kind of calculating equipment is also provided in one embodiment of this specification, including memory, processor and is stored in memory
Computer instruction that is upper and can running on a processor, the processor realize the data storage side when executing described instruction
The step of method.
One embodiment of the application also provides a kind of computer readable storage medium, is stored with computer instruction, the instruction
The step of date storage method as previously described is realized when being executed by processor.
A kind of exemplary scheme of above-mentioned computer readable storage medium for the present embodiment.It should be noted that this is deposited
The technical solution of storage media and the technical solution of above-mentioned date storage method belong to same design, the technical solution of storage medium
The detail content being not described in detail may refer to the description of the technical solution of above-mentioned date storage method.
The computer instruction includes computer program code, the computer program code can for source code form,
Object identification code form, executable file or certain intermediate forms etc..The computer-readable medium may include: that can carry institute
State any entity or device, recording medium, USB flash disk, mobile hard disk, magnetic disk, CD, the computer storage of computer program code
Device, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory),
Electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that the computer-readable medium include it is interior
Increase and decrease appropriate can be carried out according to the requirement made laws in jurisdiction with patent practice by holding, such as in certain jurisdictions of courts
Area does not include electric carrier signal and telecommunication signal according to legislation and patent practice, computer-readable medium.
It should be noted that for the various method embodiments described above, describing for simplicity, therefore, it is stated as a series of
Combination of actions, but those skilled in the art should understand that, the application is not limited by the described action sequence because
According to the application, certain steps can use other sequences or carry out simultaneously.Secondly, those skilled in the art should also know
It knows, the embodiments described in the specification are all preferred embodiments, and related actions and modules might not all be this Shen
It please be necessary.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, there is no the portion being described in detail in some embodiment
Point, it may refer to the associated description of other embodiments.
The application preferred embodiment disclosed above is only intended to help to illustrate the application.There is no detailed for alternative embodiment
All details are described, are not limited the invention to the specific embodiments described.Obviously, according to the content of this specification,
It can make many modifications and variations.These embodiments are chosen and specifically described to this specification, is in order to preferably explain the application
Principle and practical application, so that skilled artisan be enable to better understand and utilize the application.The application is only
It is limited by claims and its full scope and equivalent.
Claims (14)
1. a kind of date storage method characterized by comprising
The first payment detail is received, major key is set according to the first payment detail；
The sorting elements combination and element value of the first payment detail are inquired by the major key；
The sorting elements combination and the element value are spliced, first element value character string is generated；
Being inquired according to the first element value character string whether there is corresponding basic code in database；
In the case where basic code corresponding with the first element value character string is not present in the database, in data
Increase corresponding first basic code of the first element value character string in library.
2. the method according to claim 1, wherein further include:
In the case where there is basic code corresponding with the first element value character string in the database, described in multiplexing
The corresponding basic code of first element value character string.
3. the method according to claim 1, wherein further include:
The basic code paid in the corresponding element value character string inquiry database of detail according to every, by every payment detail pair
The basic code answered is added in counterpart expenditure detail；
Payment detail with identical basic code is summarized and cleared.
4. according to the method described in claim 3, it is characterized in that, described according to the corresponding element value character of every payment detail
Basic code in string inquiry database, before the corresponding basic code of every payment detail is added in counterpart expenditure detail
Further include:
The sorting elements combination for splicing the element value character string comes into effect in the time of setting.
5. the method according to claim 1, wherein the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the first payment detail.
6. the method according to claim 1, wherein storing the element value character string and institute in the database
It states the corresponding basic code of element value character string and splices the sorting elements combination of the element value character string.
7. a kind of data storage device characterized by comprising
Receiving module: being configured as receiving the first payment detail, sets major key according to the first payment detail；
First enquiry module: it is configured as inquiring the sorting elements combination and element of the first payment detail by the major key
Value；
Splicing module: being configured as splicing the sorting elements combination and the element value, generates first element value word
Symbol string；
Second enquiry module: it is configured as being inquired in database according to the first element value character string with the presence or absence of corresponding base
This code；
Increase module: being configured as that basic generation corresponding with the first element value character string is not present in the database
In the case where code, increase corresponding first basic code of the first element value character string in the database.
8. device according to claim 7, which is characterized in that further include:
In the case where there is basic code corresponding with the first element value character string in the database, described in multiplexing
The corresponding basic code of first element value character string.
9. device according to claim 7, which is characterized in that further include:
Adding unit: it is configured as the basic generation paid in the corresponding element value character string inquiry database of detail according to every
Code, the corresponding basic code of every payment detail is added in counterpart expenditure detail；
Summarize clearance unit: being configured as that will there is the payment detail of identical basic code to be summarized and cleared.
10. device according to claim 9, which is characterized in that the adding unit is configured to:
The sorting elements combination for splicing the element value character string comes into effect in the time of setting.
11. device according to claim 7, which is characterized in that the major key includes:
Product code, event code, exchange hour and/or the channel of disbursement of the first payment detail.
12. device according to claim 7, which is characterized in that stored in the database element value character string with
The corresponding basic code of the element value character string and the sorting elements combination for splicing the element value character string.
13. a kind of calculating equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine instruction, which is characterized in that the processor realizes the step of claim 1-6 any one the method when executing described instruction
Suddenly.
14. a kind of computer readable storage medium, is stored with computer instruction, which is characterized in that the instruction is held by processor
The step of claim 1-6 any one the method is realized when row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811589793.XA CN110060051A (en) | 2018-12-25 | 2018-12-25 | A kind of date storage method, calculates equipment and storage medium at device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811589793.XA CN110060051A (en) | 2018-12-25 | 2018-12-25 | A kind of date storage method, calculates equipment and storage medium at device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110060051A true CN110060051A (en) | 2019-07-26 |
Family
ID=67315403
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811589793.XA Pending CN110060051A (en) | 2018-12-25 | 2018-12-25 | A kind of date storage method, calculates equipment and storage medium at device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110060051A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916262A (en) * | 2010-07-29 | 2010-12-15 | 北京用友政务软件有限公司 | Acceleration method of financial element matching |
| CN105989532A (en) * | 2015-02-28 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN106875175A (en) * | 2016-06-28 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for being easy to pay main body expansion |
| CN107908759A (en) * | 2017-11-23 | 2018-04-13 | 中国银行股份有限公司 | Repeat business determination methods and system |
-
2018
- 2018-12-25 CN CN201811589793.XA patent/CN110060051A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916262A (en) * | 2010-07-29 | 2010-12-15 | 北京用友政务软件有限公司 | Acceleration method of financial element matching |
| CN105989532A (en) * | 2015-02-28 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN106875175A (en) * | 2016-06-28 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for being easy to pay main body expansion |
| CN107908759A (en) * | 2017-11-23 | 2018-04-13 | 中国银行股份有限公司 | Repeat business determination methods and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7052127B1 (en) | Grant device, grant method and grant program | |
| CN110046828B (en) | Intelligent account division protocol system based on block chain | |
| CN110020873A (en) | Artificial customer service switching method, relevant apparatus, equipment and computer-readable medium | |
| CN108805632A (en) | A kind of charging method and device | |
| Kalra | Overriding fintech | |
| CN110009345A (en) | Transaction cochain method and Related product based on block chain | |
| CN111080424A (en) | Accounting management method and device | |
| CN110009501A (en) | Financing method, system, calculating equipment and storage medium based on block chain | |
| CN110347675A (en) | A kind of date storage method and device | |
| CN106296202A (en) | A kind of method of consumer's risk prevention and control in terminal charge payment process | |
| CN112132674A (en) | Transaction processing method and device | |
| JP6938744B1 (en) | Grant device, grant method and grant program | |
| CN111383007A (en) | Service processing method and device | |
| CN112561510A (en) | Payment system, method, device, equipment and storage medium | |
| CN112001732A (en) | Service processing system, method and device | |
| US7917437B1 (en) | Method for avoiding intermediated payment aggregation | |
| CN110705981B (en) | Real-time settlement method and device | |
| CN111242604A (en) | Data processing method and device | |
| CN109583931B (en) | Transaction data processing method, device, electronic equipment and readable storage medium | |
| CN104376473A (en) | Electronic commercial draft payment system and method | |
| CN110060051A (en) | A kind of date storage method, calculates equipment and storage medium at device | |
| CN112967047B (en) | Settlement method, device, apparatus, storage medium, and program product | |
| CN102194197A (en) | Method for ensuring fulfillment of surety bond insurance contract | |
| CN111221855B (en) | Data processing method and device | |
| US20200380482A1 (en) | Method and system for implementing an electronic exchange for bill pay and other transactions via an interbank information network (iin) |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201013 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201013 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right |