CN110309185A - Data query method, system, computer equipment and storage medium - Google Patents
Data query method, system, computer equipment and storage medium Download PDFInfo
- 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
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, 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
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.
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)
| 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)
| 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 |
-
2019
- 2019-05-24 CN CN201910440409.8A patent/CN110309185A/en active Pending
Patent Citations (3)
| 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)
| 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 | |
| CN108961034A (en) | System and method, storage medium based on user behavior certification | |
| CN108765106A (en) | A kind of integrated financial affairs receipt generation method of industry wealth | |
| CN108711045A (en) | A kind of cash register system and cash method | |
| TWI748163B (en) | A system and method for transcating and sorting affair | |
| CN112596801A (en) | Transaction processing method, device, equipment, storage medium and database | |
| 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 |