CN110309185A - Data query method, system, computer equipment and storage medium - Google Patents

Data query method, system, computer equipment and storage medium Download PDF

Info

Publication number
CN110309185A
CN110309185A CN201910440409.8A CN201910440409A CN110309185A CN 110309185 A CN110309185 A CN 110309185A CN 201910440409 A CN201910440409 A CN 201910440409A CN 110309185 A CN110309185 A CN 110309185A
Authority
CN
China
Prior art keywords
record
transaction
data
consumer sale
processing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201910440409.8A
Other languages
Chinese (zh)
Inventor
包六十三
欧阳海
安娜娜
邹延鑫
徐晶
姚伏霞
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Bank Co Ltd
Original Assignee
Ping An Bank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Bank Co Ltd filed Critical Ping An Bank Co Ltd
Priority to CN201910440409.8A priority Critical patent/CN110309185A/en
Publication of CN110309185A publication Critical patent/CN110309185A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Finance (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Computing Systems (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Computational Linguistics (AREA)
  • Cash Registers Or Receiving Machines (AREA)

Abstract

The present invention relates to data query technique field, the present invention provides a kind of data query method, system, computer equipment and storage medium.The described method includes: receiving the record data that service server passes down in real time;It is consumer sale record to be operated that data, which will be recorded, and be converted into processing status, and consumer sale record and processing status are stored in transaction record list;The data inquiry request for receiving client, searches the corresponding target transaction record of data inquiry request from transaction record list and target transaction records corresponding processing status;Target transaction record is returned to client and target transaction records corresponding processing status.The above method, record data are received by searching platform and record data are handled, subsequent basis treated record data complete client data inquiry request, it can avoid client and carry out direct data query to service server, the consumption to service server on hardware resource is reduced, the safety performance of service server is promoted.

Description

Data query method, system, computer equipment and storage medium
Technical field
The present invention relates to data query technique fields, specifically, the present invention relates to a kind of data query method, data to look into Inquiry system, computer equipment and storage medium.
Background technique
Mainframe is usually used in the business data processing of all trades and professions at present, such as in banking system, bank's key business Server is typically all to use mainframe to build, such as the data that consumer sale records in bank can be handled in mainframe And storage.
In face of multi-user to the data inquiry request of mainframe, if the consumer sale record queries of banking system, not only Mainframe can not only occupy the flow of data transmission interface, data in the inquiry request for receiving multi-user, a large amount of inquiry request The security risk that coffret faces also will increase, and can also consume when handling inquiry request more hard of service server Part resource.
Therefore, it is easy to appear and accounts for when handling mass data inquiry request in the service server built based on mainframe With the situation that resource is excessive, service server safety performance is affected.
Summary of the invention
The purpose of the present invention is intended at least can solve above-mentioned one of technological deficiency, limited occupation Server Security performance Low technological deficiency.
The present invention provides a kind of data query method, includes the following steps:
Receive the record data that service server passes down in real time, wherein the record data include consumption authority record;
Converting processing status for the record data is consumer sale record to be operated, and in transaction record list Store the consumer sale record and the processing status;
It asks money information to record the consumer sale according to transaction and carries out node processing, wherein money information is asked in the transaction For claiming consumer sale record to the service server;
The data inquiry request for receiving client is searched from the transaction record list and returns to institute to the client It states the corresponding target transaction record of data inquiry request and the target transaction records corresponding processing status, wherein the visitor Family end shows the target transaction record and the processing status.
In one embodiment, the step for asking money information to record progress node processing to the consumer sale according to transaction Suddenly, comprising:
It receives the transaction that the service server passes down in real time and asks money information;Ask money information corresponding the transaction The processing status of consumer sale record is changed to operate.
In one embodiment, the processing status of the corresponding consumer sale record of money information is asked to become the transaction described After the step of more having operated, further includes:
Receive the processing credential information that the service server passes down, wherein the processing credential information is for being recorded in Consumer sale record corresponding to the consumption authority record of operation is completed in the service server;Believed according to the processing voucher The processing status for recording consumer sale in the transaction record list is ceased to synchronize.
In one embodiment, described that consumer sale in the transaction record list is remembered according to the processing credential information The step of processing status of record synchronizes, comprising:
Consumer sale record to be checked involved in the processing credential information is transferred from the transaction record list;Sentence Whether the processing status of the disconnected consumer sale record to be checked is to have operated;In the processing of the consumer sale record to be checked State is to be changed to operate by the processing status that the consumer sale to be checked records wait operate.
In one embodiment, described according to the processing credential information to consumer sale in the transaction record list After the step of processing status of record synchronizes, further includes:
According to the consumption authority record and the processing credential information to the processing status of the transaction record list into The verification of row total score, generates cross-check information.
In one embodiment, after the generation cross-check information the step of, further includes:
The cross-check information, the consumer sale operated record and the consumer sale record institute checked is right The consumption authority record and processing voucher answered are filed, and are stored in filing database;From the transaction record list Delete the consumer sale record checked.
It is in one embodiment, described that convert processing status for the record data be that consumer sale to be operated records The step of, comprising:
The consumer sale amount of money and transaction ID number are extracted from the consumption authority record;According to the consumer sale amount of money The consumer sale record is established with the transaction ID number, and the state that keeps accounts that the consumer sale record is arranged is wait grasp Make.
The present invention also provides a kind of data query systems, comprising:
Receiving module, the record data passed down in real time for receiving service server, wherein the record data include disappearing Take authority record;
Conversion module is consumer sale record to be operated for converting processing status for the record data, and The consumer sale record and the processing status are stored in transaction record list;
Processing module carries out node processing for asking money information to record the consumer sale according to transaction, wherein described Transaction asks money information for claiming consumer sale record to the service server;
Return module is searched and to institute for receiving the data inquiry request of client from the transaction record list It states the corresponding target transaction record of the client return data inquiry request and the target transaction records corresponding processing shape State, wherein the client shows the target transaction record and the processing status.
The present invention also provides a kind of computer equipment, including memory and processor, calculating is stored in the memory Machine readable instruction, when the computer-readable instruction is executed by the processor, so that the processor is executed as any of the above-described Described in embodiment the step of data query method.
The present invention also provides a kind of storage mediums for being stored with computer-readable instruction, and the computer-readable instruction is by one When a or multiple processors execute, so that one or more processors execute data query method described in any of the above-described embodiment Step.
Above-mentioned data query method, system, computer equipment and storage medium receives record data by searching platform And to record data handle, subsequent basis treated record data complete client data inquiry request, can keep away Exempt from client and carry out direct data query to service server, reduces the consumption to service server on hardware resource, mention Rise the safety performance of service server.Simultaneously as the consumer sale record of transaction record list has real-time timeliness, The target transaction record inquired is also possible to realize the effect of data real-time query.
The additional aspect of the present invention and advantage will be set forth in part in the description, these will become from the following description Obviously, or practice through the invention is recognized.
Detailed description of the invention
Above-mentioned and/or additional aspect and advantage of the invention will become from the following description of the accompanying drawings of embodiments Obviously and it is readily appreciated that, in which:
Fig. 1 is the implementation environment figure of the data query method provided in one embodiment;
Fig. 2 is the flow chart of data query method in one embodiment;
Fig. 3 is the flow chart of data query method in another embodiment;
Fig. 4 is the structural schematic diagram of data query system in one embodiment;
Fig. 5 is the schematic diagram of internal structure of computer equipment in one embodiment.
Specific embodiment
The embodiment of the present invention is described below in detail, examples of the embodiments are shown in the accompanying drawings, wherein from beginning to end Same or similar label indicates same or similar element or element with the same or similar functions.Below with reference to attached The embodiment of figure description is exemplary, and for explaining only the invention, and is not construed as limiting the claims.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singular " one " used herein, " one It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition Other one or more features, integer, step, operation, element, component and/or their group.It should be understood that when we claim member Part is " connected " or when " coupled " to another element, it can be directly connected or coupled to other elements, or there may also be Intermediary element.In addition, " connection " used herein or " coupling " may include being wirelessly connected or wirelessly coupling.It is used herein to arrange Diction "and/or" includes one or more associated wholes for listing item or any cell and all combinations.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art Language and scientific term), there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also Understand, those terms such as defined in the general dictionary, it should be understood that have in the context of the prior art The consistent meaning of meaning, and unless idealization or meaning too formal otherwise will not be used by specific definitions as here To explain.
As shown in FIG. 1, FIG. 1 is the implementation environment figures of the data query method provided in one embodiment, in the implementation ring In border, including service server 110, searching platform 120 and client 130.
Service server 110 can be built on mainframe, such as service server 110 can be used in record and processing The data of consumer sale.Service server 110 can be connect with searching platform 120, and record number to the lower biography of searching platform 120 According to.Searching platform 120 can be the business platform in computer or server operation, can receive the note that service server passes down Record data are simultaneously handled record data, can also be inquired to clients providing data.Client 130 is mountable in intelligent hand On machine, tablet computer, laptop or desktop computer.
In one embodiment, as shown in Fig. 2, Fig. 2 is the flow chart of data query method in one embodiment, this implementation A kind of data query method is proposed in example, which can be applied in above-mentioned searching platform 120, specifically may be used With the following steps are included:
Step S210: the record data that service server passes down in real time are received, wherein record data include consumption authorization note Record.
In this step, service server can be used for recording and handling data relevant to consumer record, the note recorded Record data may include consumption authority record.Consumer is somebody's turn to do when bankcard consumption in the POS machine of trade company is traded in POS machine record Consumption authority record is generated when consumer sale, POS machine can upload the consumption authority record to service server, business clothes in real time Business device can recorde the consumption authority record, and service server will periodically can also reach under the consumption authority record of real-time reception Searching platform.
Step S220: will record data and be converted into processing status is consumer sale record to be operated, and in transaction record Consumer sale record and processing status are stored in list.
In this step, consumption authority record can be converted to consumer sale record, consumer sale note can be recorded in real time Record improves the real-time for generating consumer sale record, is inquired in order to subsequent for client.
Consumer sale record is obtained after converting in advance, is advanced by the processing node for obtaining consumer sale record at this time, this disappears Expense transaction record fails to reflect whether by processing node to be operated.Such as the node processing wait operate is when keeping accounts to handle, If the processing node by the processing that keeps accounts then shows the consumer sale, record is really, and corresponding consumer sale is success 's;Although but then show there is the consumption authority record swiped the card when without the processing node for the processing that keeps accounts, it is likely that the consumption Transaction is failed.It therefore can be consumer sale record setting processing status, so that distinguishing the consumer sale is recorded in processing In whether by the processing node of processing of keeping accounts, improve the authenticity of consumer sale record.
When conversion, since processing node to be operated has a time delay, the general processing node is not at once can be with It is wait operate that the processing status can be set when reaching, therefore convert.
Step S230: money information is asked to carry out node processing to consumption transaction record according to transaction, wherein money information is asked in transaction For claiming consumer sale record to service server.
In this step, the operation of node processing can also be carried out to consumer transaction data, node processing may include keeping accounts Processing.
Specifically, the step of asking money information to carry out node processing to consumption transaction record according to transaction in step S230, can To include:
Step S231: it receives the transaction that service server passes down in real time and asks money information.
In this step, transaction asks money information to ask money information can be with for claiming consumer sale record transaction to service server The information for coming from the initiation of POS machine trade company can be used for that trade company is allowed to claim this consumer sale record, POS machine quotient to bank Family can send transaction to service server and ask money information, and service server, which records and handles the transaction, asks money information.Industry at this time The transaction of real-time reception can be asked periodically under money information and reach searching platform by business server, and searching platform is subsequent can be according to friendship Money information is easily asked to carry out the operation of processing node.
Step S232: the processing status of the corresponding consumer sale record of money information is asked to be changed to operate transaction.
In this step, money information is asked to record the operation for carrying out handling node, example to corresponding consumer sale according to transaction It such as asks money information to carry out the operation that keeps accounts according to transaction, at this point, can be processed to Status Change is to have operated, represents the consumption Transaction record has kept accounts.
In above-mentioned node processing, the Status Change of consumer sale record can be completed, is remembered convenient for real-time update consumer sale The processing status of record can be improved the accuracy of real-time query data.
Step S240: receiving the data inquiry request of client, searches from transaction record list and returns to client The corresponding target transaction record of data inquiry request and target transaction record corresponding processing status, wherein client shows mesh Mark transaction record and processing status.
In this step, the data inquiry request of client is received, data inquiry request pair is searched from transaction record list The target transaction record and target transaction answered record corresponding processing status.Target transaction record is returned to client and target is handed over Easily record corresponding processing status.
The data inquiry request at customer in response end is searched corresponding target transaction record and processing status, is completed to client The response of the data inquiry request at end.Since the consumer sale record of transaction record list has real-time timeliness, this When can satisfy to real-time consumer sale record inquiry, meet the effect of data real-time query.
Above-mentioned data query method receives record data by searching platform and handles record data, and subsequent The data inquiry request that data complete client is recorded according to treated, can be carried out to avoid client to service server direct Data query, reduce consumption to service server on hardware resource, promote the safety performance of service server.Together When, since the consumer sale record of transaction record list has real-time timeliness, the target transaction that the above method can be inquired Record is also possible to realize the effect of data real-time query.
After the operation for having carried out processing node in searching platform, in one embodiment, transaction is asked in step S232 The processing status of the corresponding consumer sale record of money information was changed to after the step of having operated, and can also include:
Step S251: the processing credential information that service server passes down is received, wherein processing credential information is for being recorded in Consumer sale record corresponding to the consumption authority record of operation is completed in service server.
Service server after receiving transaction and asking money information, can within the predetermined time to corresponding consumption authority record into Row keeps accounts operation, will record after the operation that keeps accounts and handles credential information accordingly.Processing credential information is for being recorded in business clothes It is engaged in completing consumer sale record corresponding to the consumption authority record of operation in device, on the other hand, i.e., the processing voucher is believed Breath represents corresponding consumption authority record and is in the processing status operated.
Step S252: the processing status that consumer sale in transaction record list records is carried out according to processing credential information same Step.
Above-mentioned data query method records the rank highest of the accuracy of data in service server, transaction record is arranged The data of table are synchronized to the higher data of accuracy, ensure the uniformity of data between searching platform and service server, Improve the accuracy of data in searching platform.
Specifically, in one embodiment, in step S252 according to processing credential information to being consumed in transaction record list The step of processing status of transaction record synchronizes may include:
S2521: consumer sale record to be checked involved in processing credential information is transferred from transaction record list.
S2522: whether the processing status for judging consumer sale record to be checked is to have operated.
S2523: being to record the consumer sale to be checked wait operate in the processing status of consumer sale to be checked record Processing status is changed to operate.
Above-mentioned data query method inquires the place whether corresponding with processing credential information of processing status in transaction record list Reason state is identical, will be changed to operate with the processing status having differences in processing credential information, to realize processing status Synchronization.
In one embodiment, consumer sale in transaction record list is remembered according to processing credential information in step S252 After the step of processing status of record synchronizes, can also include:
S261: according to consumption authority record and credential information is handled to the total pyrene of processing status progress of transaction record list It is right, generate cross-check information.
Cross-check information can be used for recording the case where total score verification, can be according to the cross-check information to transaction record list Processing status is corrected.
Above-mentioned data query method can periodically carry out total score verification, carry out verification one by one to general ledger and each notes record, Ensure the accuracy of data.
When the consumer sale for having carried out node processing record be not changed in time the processing status that has operated or certain The processing status of a little consumer sale records may be changed to mode of operation when money information is asked in no transaction, at this time may be used To check by total score, nonsynchronous or wrong consumer sale record is found out, and correct to it.
In one embodiment, after the step of cross-check information is generated in step S261, can also include:
A1: cross-check information, the consumer sale operated are recorded, and are disappeared corresponding to the consumer sale record checked Expense authority record and processing voucher are filed, and are stored in filing database.
In this step, filing storage is carried out, consumer sale is rationally stored and records relevant data, can also be convenient for subsequent progress The lookup of related data.
A2: the consumer sale record checked is deleted from transaction record list.
In this step, the consumer sale after filing is recorded and is deleted from transaction record list, transaction record can be discharged The memory space of list.
Above-mentioned data query method can use memory space in reasonable and orderly manner, rationally occupy storage resource and processing money Source, in order to improve the efficiency of processing inquiry.
In one embodiment, it is that consumer sale to be operated is remembered that data will be recorded in step S220 and are converted into processing status The step of record may include:
S221: the consumer sale amount of money and transaction ID number are extracted from consumption authority record.
S222: consumer sale record is established according to the consumer sale amount of money and transaction ID number, and consumer sale record is set Keep accounts state be wait operate.
Above-mentioned data query method, after the consumption authority record extraction consumer sale amount of money and transaction ID number, foundation disappears Take transaction record, the consumer sale amount of money therein is inquiry information of interest, and transaction ID number can be in order to marking and look into Look for consumption authority record.
In another embodiment, as shown in figure 3, Fig. 3 is the flow chart of data query method in another embodiment, this A kind of data query method is provided in embodiment, which can apply in above-mentioned searching platform 120, specifically It may comprise steps of:
Step S310: the record data that service server passes down in real time are received, wherein record data include consumption authorization note Record.
Step S320: will record data and be converted into processing status is consumer sale record to be operated, and in transaction record Consumer sale record and processing status are stored in list.Specifically, the consumer sale amount of money can be extracted from consumption authority record With transaction ID number;Consumer sale record is established according to the consumer sale amount of money and transaction ID number, and consumer sale record is set Keep accounts state be wait operate.
Step S330: receive the transaction that passes down in real time of service server and ask money information, wherein transaction ask money information for Service server claims consumer sale record;The processing status of the corresponding consumer sale record of money information is asked to be changed to transaction Operation.
Step S340: the processing credential information that service server passes down is received, wherein processing credential information is for being recorded in Consumer sale record corresponding to the consumption authority record of operation is completed in service server;According to processing credential information to transaction The processing status that consumer sale records in record list synchronizes.Wherein, from can specifically being transferred from transaction record list Manage consumer sale record to be checked involved in credential information;Whether the processing status for judging consumer sale record to be checked is Operation;It is wait operate, by the processing status of consumer sale record to be checked in the processing status of consumer sale to be checked record It is changed to operate.
Wherein under service server biography record data, may include: consumption authority record, transaction ask money information and processing with Demonstrate,prove information etc..Service server may only be responsible for searching platform down-transmitting data to guarantee the safety and reliabilities of data, But the data of searching platform upload are not received.
Step S350: receiving the data inquiry request of client, and data inquiry request pair is searched from transaction record list The target transaction record and target transaction answered record corresponding processing status.
Step S360: target transaction record is returned to client and target transaction records corresponding processing status, wherein visitor Family end displaying target transaction record and processing status.
Client directly sends inquiry request to searching platform, and the operation of query processing occupies the data transmission of searching platform The flow of interface avoids sending inquiry request to the mainframe of service server, avoids the occupancy to resource in service server, Ensure the security performance of service server.
Step S370: the processing status of transaction record list is carried out according to consumption authority record and processing credential information total Pyrene pair generates cross-check information.It can be corrected according to processing status of the cross-check information to transaction record list, ensure number According to accuracy.
Step S380: cross-check information, the consumer sale operated are recorded, and the consumer sale record institute checked is right The consumption authority record and processing voucher answered are filed, and are stored in filing database;It is deleted from transaction record list The consumer sale record checked.
Memory space can be used in reasonable and orderly manner, rationally occupies storage resource and process resource, in order to improve processing The efficiency of inquiry.
Above-mentioned data query method receives the record data of service server by searching platform and carries out to record data Processing, subsequent basis treated record data complete client data inquiry request, can to avoid client to business take Business device carries out direct data query, reduces the consumption to service server on hardware resource, promotes the peace of service server Full property performance.Simultaneously as the consumer sale record of transaction record list has real-time timeliness, the above method can be inquired Target transaction record be also possible to realize data real-time query effect.
In one embodiment, as shown in figure 4, Fig. 4 is the structural schematic diagram of data query system in one embodiment, this A kind of data query system is provided in embodiment, can specifically include receiving module 410, conversion module 420, processing module 430 With return module 440, in which:
Receiving module 410, the record data passed down in real time for receiving service server, wherein record data include disappearing Take authority record.
Service server can be used for recording and handling relevant to consumer record data, and the record data recorded can be with Including consuming authority record.Consumer is when bankcard consumption in the POS machine of trade company is traded, when POS machine records the consumer sale Consumption authority record is generated, POS machine can upload the consumption authority record to service server in real time, and service server can be remembered The consumption authority record is recorded, service server periodically will can also reach searching platform under the consumption authority record of real-time reception.
Conversion module 420 is consumer sale record to be operated for that will record data to be converted into processing status, and is handing over Storage consumer sale record and processing status in easy record list.
Conversion module 420 can convert consumption authority record to consumer sale record, can record consumer sale in real time Record improves the real-time for generating consumer sale record, is inquired in order to subsequent for client.Disappeared after converting in advance Take transaction record, be advanced by the processing node for obtaining consumer sale record at this time, consumer sale record fail to reflect whether through Cross processing node to be operated.Such as the node processing wait operate is when keeping accounts to handle, if the processing section by the processing that keeps accounts Point then shows that consumer sale record is really that corresponding consumer sale is successful;But without the processing for the processing that keeps accounts Although then showing there is the consumption authority record swiped the card when node, it is likely that the consumer sale is failed.Therefore can disappear for this Take transaction record setting processing status, to distinguish the processing section whether consumer sale record passes through the processing that keeps accounts in processes Point improves the authenticity of consumer sale record.When conversion, since processing node to be operated has time delay, generally should Processing node is not that can reach at once, therefore it is wait operate that the processing status can be set when conversion.
Processing module 430, for asking money information to carry out node processing to consumption transaction record according to transaction, wherein transaction Please money information be used for service server claim consumer sale record.
Processing module 430 can carry out the operation of node processing to consumer transaction data, and node processing may include keeping accounts Processing.Processing module 430 can receive the transaction that service server passes down in real time and ask money information, ask money information corresponding transaction The processing status of consumer sale record is changed to operate.
Return module 440 is searched and to client for receiving the data inquiry request of client from transaction record list The corresponding target transaction record of end returned data inquiry request and target transaction record corresponding processing status, wherein client Displaying target transaction record and processing status.
Return module 440 receives the data inquiry request of client, searches data inquiry request from transaction record list Corresponding target transaction record and target transaction record corresponding processing status.Target transaction record and target are returned to client The corresponding processing status of transaction record.The data inquiry request at customer in response end searches corresponding target transaction record and processing State completes the response to the data inquiry request of client.Since the consumer sale record of transaction record list has in real time Timeliness, therefore, can satisfy at this time to real-time consumer sale record inquiry, meet the effect of data real-time query.
Above-mentioned data query system receives record data by searching platform and handles record data, and subsequent The data inquiry request that data complete client is recorded according to treated, can be carried out to avoid client to service server direct Data query, reduce consumption to service server on hardware resource, promote the safety performance of service server.Together When, since the consumer sale record of transaction record list has real-time timeliness, the target transaction that the above method can be inquired Record is also possible to realize the effect of data real-time query.
Specific about data query system limits the restriction that may refer to above for data query method, herein not It repeats again.Modules in above-mentioned data query system can be realized fully or partially through software, hardware and combinations thereof.On Stating each module can be embedded in the form of hardware or independently of in the processor in computer equipment, can also store in a software form In memory in computer equipment, the corresponding operation of the above modules is executed in order to which processor calls.
As shown in figure 5, Fig. 5 is the schematic diagram of internal structure of computer equipment in one embodiment.The computer equipment packet Include processor, non-volatile memory medium, memory and the network interface connected by system bus.Wherein, which sets Standby non-volatile memory medium is stored with operating system and computer-readable instruction, which is held by processor When row, processor may make to realize a kind of data query method.The processor of the computer equipment is calculated and is controlled for providing Ability supports the operation of entire computer equipment.Computer-readable instruction can be stored in the memory of the computer equipment, it should When computer-readable instruction is executed by processor, processor may make to execute a kind of data query method.The computer equipment Network interface is used for and terminal connection communication.It will be understood by those skilled in the art that structure shown in Fig. 5, only and originally The block diagram of the relevant part-structure of application scheme, does not constitute the limit for the computer equipment being applied thereon to application scheme Fixed, specific computer equipment may include perhaps combining certain components or tool than more or fewer components as shown in the figure There is different component layouts.
In one embodiment it is proposed that a kind of computer equipment, including memory and processor, deposited in the memory Contain computer-readable instruction, which is characterized in that when the computer-readable instruction is executed by the processor, so that the place Manage the step of device executes data query method in any of the above-described embodiment.
In one embodiment it is proposed that a kind of storage medium for being stored with computer-readable instruction, this is computer-readable When instruction is executed by one or more processors, so that one or more processors execute data query in any of the above-described embodiment The step of method.
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow, These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other At least part of the sub-step or stage of step or other steps executes in turn or alternately.
The above is only some embodiments of the invention, it is noted that for the ordinary skill people of the art For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered It is considered as protection scope of the present invention.

Claims (10)

1. a kind of data query method, which comprises the steps of:
Receive the record data that service server passes down in real time, wherein the record data include consumption authority record;
Converting processing status for the record data is consumer sale record to be operated, and is stored in transaction record list The consumer sale record and the processing status;
It asks money information to record the consumer sale according to transaction and carries out node processing, wherein the transaction asks money information to be used for Consumer sale record is claimed to the service server;
The data inquiry request for receiving client is searched from the transaction record list and returns to the number to the client Corresponding processing status is recorded according to the corresponding target transaction record of inquiry request and the target transaction, wherein the client Show the target transaction record and the processing status.
2. data query method according to claim 1, which is characterized in that described to ask money information to disappear to described according to transaction Take the step of transaction record carries out node processing, comprising:
It receives the transaction that the service server passes down in real time and asks money information;
The processing status of the corresponding consumer sale record of money information is asked to be changed to operate the transaction.
3. data query method according to claim 2, which is characterized in that ask money information corresponding the transaction described Consumer sale record processing status be changed to after the step of having operated, further includes:
Receive the processing credential information that the service server passes down, wherein the processing credential information is described for being recorded in Consumer sale record corresponding to the consumption authority record of operation is completed in service server;
It is synchronized according to the processing status that the processing credential information records consumer sale in the transaction record list.
4. data query method according to claim 3, which is characterized in that it is described according to the processing credential information to institute State the step of processing status that consumer sale records in transaction record list synchronizes, comprising:
Consumer sale record to be checked involved in the processing credential information is transferred from the transaction record list;
Whether the processing status of the judgement consumer sale record to be checked is to have operated;
It is wait operate, by the processing shape of consumer sale record to be checked in the processing status of the consumer sale record to be checked State is changed to operate.
5. data query method according to claim 3, which is characterized in that described according to the processing credential information pair After the step of processing status that consumer sale records in the transaction record list synchronizes, further includes:
The processing status of the transaction record list is carried out according to the consumption authority record and the processing credential information total Pyrene pair generates cross-check information.
6. data query method according to claim 5, which is characterized in that the generation cross-check information the step of it Afterwards, further includes:
It will be corresponding to the cross-check information, the consumer sale operated record and the consumer sale record checked Consumption authority record and processing voucher are filed, and are stored in filing database;
The consumer sale record checked is deleted from the transaction record list.
7. data query method according to claim 1, which is characterized in that described to convert processing for the record data The step of state is consumer sale record to be operated, comprising:
The consumer sale amount of money and transaction ID number are extracted from the consumption authority record;
The consumer sale record is established according to the consumer sale amount of money and the transaction ID number, and the consumption is set and is handed over The state that keeps accounts easily recorded is wait operate.
8. a kind of data query system characterized by comprising
Receiving module, the record data passed down in real time for receiving service server, wherein the record data include that consumption is awarded Power record;
Conversion module is that consumer sale to be operated records, and is trading for converting processing status for the record data The consumer sale record and the processing status are stored in record list;
Processing module carries out node processing for asking money information to record the consumer sale according to transaction, wherein the transaction Please money information be used for the service server claim consumer sale record;
Return module is searched and to the visitor for receiving the data inquiry request of client from the transaction record list Family end returns to the corresponding target transaction record of the data inquiry request and the target transaction records corresponding processing status, In, the client shows the target transaction record and the processing status.
9. a kind of computer equipment, including memory and processor, it is stored with computer-readable instruction in the memory, it is special Sign is, when the computer-readable instruction is executed by the processor, so that the processor executes such as claim 1 to 7 Any one of described in data query method the step of.
10. a kind of storage medium for being stored with computer-readable instruction, which is characterized in that the computer-readable instruction is by one Or multiple processors are when executing, so that one or more processors execute the data query as described in any one of claims 1 to 7 The step of method.
CN201910440409.8A 2019-05-24 2019-05-24 Data query method, system, computer equipment and storage medium Pending CN110309185A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910440409.8A CN110309185A (en) 2019-05-24 2019-05-24 Data query method, system, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910440409.8A CN110309185A (en) 2019-05-24 2019-05-24 Data query method, system, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN110309185A true CN110309185A (en) 2019-10-08

Family

ID=68074864

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910440409.8A Pending CN110309185A (en) 2019-05-24 2019-05-24 Data query method, system, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN110309185A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111556160A (en) * 2020-05-09 2020-08-18 支付宝(杭州)信息技术有限公司 Data asset admission method and device
CN113656435A (en) * 2021-08-20 2021-11-16 北京神州新桥科技有限公司 Transaction data query method, electronic device and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102609488A (en) * 2012-01-20 2012-07-25 北京星网锐捷网络技术有限公司 Client, data query method of client, server and data query system
CN107623747A (en) * 2017-10-27 2018-01-23 中国银行股份有限公司 A kind of data transmission method, equipment and system
CN109241067A (en) * 2018-08-21 2019-01-18 中国平安人寿保险股份有限公司 transaction data management method and device

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102609488A (en) * 2012-01-20 2012-07-25 北京星网锐捷网络技术有限公司 Client, data query method of client, server and data query system
CN107623747A (en) * 2017-10-27 2018-01-23 中国银行股份有限公司 A kind of data transmission method, equipment and system
CN109241067A (en) * 2018-08-21 2019-01-18 中国平安人寿保险股份有限公司 transaction data management method and device

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111556160A (en) * 2020-05-09 2020-08-18 支付宝(杭州)信息技术有限公司 Data asset admission method and device
CN111556160B (en) * 2020-05-09 2023-03-24 支付宝(杭州)信息技术有限公司 Data asset admission method and device
CN113656435A (en) * 2021-08-20 2021-11-16 北京神州新桥科技有限公司 Transaction data query method, electronic device and storage medium
CN113656435B (en) * 2021-08-20 2023-09-01 北京神州新桥科技有限公司 Transaction data query method, electronic device and storage medium

Similar Documents

Publication Publication Date Title
US11410146B2 (en) Order processing
CN109493024A (en) Digital asset trustship method, equipment and storage medium
CN109598598A (en) Transaction processing method and device, electronic equipment based on block chain
CN109598504A (en) Transaction processing method and device, electronic equipment based on block chain
CN109542980A (en) A kind of data processing method, device, equipment and the medium of block chain
CN108734457A (en) A kind of Withdrawing method unified under cash register system
CN109194495A (en) server, message processing method and computer readable storage medium
CN110223153A (en) Account checking method, device, electronic equipment and storage medium
CN109241067A (en) transaction data management method and device
CN107766393A (en) Information processing method, client and server based on database
CN106331100A (en) Method and device for pushing business information to be processed
CN110309185A (en) Data query method, system, computer equipment and storage medium
CN109447802B (en) Fund management system based on block chain technology
CN108764876A (en) A kind of transaction processing method and server
CN108762895B (en) Method and device for processing distributed transaction
CN109146523B (en) Commodity anti-counterfeiting and authenticity-checking system and method based on block chain
CN106096926B (en) Event processing method, device, electronic device and storage medium
CN102035879B (en) Server and data processing system using same
CN108897729A (en) A kind of trading template sharing method, device, electronic equipment and storage medium
CN108711045A (en) A kind of cash register system and cash method
TWI748163B (en) A system and method for transcating and sorting affair
CN109598603B (en) Account opening task processing method and account opening service system
CN112596801A (en) Transaction processing method, device, equipment, storage medium and database
CN109784971A (en) The processing method of member's consumption information, apparatus and system
CN108694660A (en) A kind of industry wealth integration account checking method

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