CN117271563A - Data query method, apparatus, computer device, storage medium, and program product - Google Patents

Data query method, apparatus, computer device, storage medium, and program product Download PDF

Info

Publication number
CN117271563A
CN117271563A CN202311207651.3A CN202311207651A CN117271563A CN 117271563 A CN117271563 A CN 117271563A CN 202311207651 A CN202311207651 A CN 202311207651A CN 117271563 A CN117271563 A CN 117271563A
Authority
CN
China
Prior art keywords
query
channel
data
interface
information
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
CN202311207651.3A
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.)
Bank of China Ltd
Original Assignee
Bank of China 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 Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202311207651.3A priority Critical patent/CN117271563A/en
Publication of CN117271563A publication Critical patent/CN117271563A/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
    • 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
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

The present application relates to a data query method, apparatus, computer device, storage medium and program product. The method comprises the following steps: acquiring channel identification information and client information input in a data query entry; determining a channel inquiry interface for data forwarding according to the channel identification information; invoking the channel query interface to send a query request carrying the client information to a query server, so that the query server queries to obtain original transaction data according to the query request, and issues the original transaction data to the channel query interface; and determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface. By adopting the method, the complexity of data query can be reduced, and the accuracy of the query result can be improved.

Description

Data query method, apparatus, computer device, storage medium, and program product
Technical Field
The present invention relates to the field of data query technologies, and in particular, to a data query method, apparatus, computer device, storage medium, and program product.
Background
To ensure the development of banking and to meet customer needs, bank teller needs to query the transaction details of funds.
In the related art, different query entries are provided for different types of transaction data, and when query is performed, the teller is required to additionally memorize a plurality of transaction codes, so that the data query mode is complex, and the accuracy of the query result is not high.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a data query method, apparatus, computer device, storage medium, and program product that can reduce complexity of data query and improve accuracy of query results.
In a first aspect, the present application provides a data query method. The method comprises the following steps:
acquiring channel identification information and client information input in a data query entry;
determining a channel inquiry interface for data forwarding according to the channel identification information;
invoking the channel query interface to send a query request carrying the client information to a query server, so that the query server queries to obtain original transaction data according to the query request, and issues the original transaction data to the channel query interface;
and determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface.
In one embodiment, before obtaining the channel identification information and the customer information entered in the data query entry, the method further comprises:
acquiring field information corresponding to at least two channel query interfaces;
and integrating the at least two channel query interfaces according to the field information to obtain the data query entry.
In one embodiment, the integrating the at least two channel query interfaces according to each field information to obtain the data query entry includes:
acquiring a union of the field information;
and integrating the at least two channel query interfaces according to the union of the field information to obtain the data query entry.
In one embodiment, the field information includes a transmission field;
the step of calling the channel query interface to send a query request carrying the client information to a query server comprises the following steps:
generating standard query information according to the transmission field and the client information;
generating the query request according to the standard query information;
and calling the channel query interface to send the query request.
In one embodiment, the field information includes a return field;
the determining target transaction data corresponding to the customer information based on the original transaction data in the channel query interface comprises:
determining a return field corresponding to the channel identification information;
and reading original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain the target transaction data.
In a second aspect, the present application further provides a data query method. Comprising the following steps:
acquiring a query request sent by a channel query interface; the channel inquiry interface is determined according to channel identification information input in a data inquiry inlet, and the inquiry request carries client information input in the data inquiry inlet;
determining a channel transaction code according to the channel inquiry interface;
and inquiring according to the channel transaction code and the client information in the inquiry request to obtain original transaction data, and transmitting the original transaction data to the channel inquiry interface.
In a third aspect, the present application further provides a data query device. The device comprises:
the information acquisition module is used for acquiring channel identification information and client information input in the data query entry;
the interface determining module is used for determining a channel query interface for data forwarding according to the channel identification information;
the interface calling module is used for calling the channel inquiry interface to send an inquiry request carrying the client information to an inquiry server so that the inquiry server can inquire according to the inquiry request to obtain original transaction data and send the original transaction data to the channel inquiry interface;
and the transaction data determining module is used for determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps of the data query method when executing the computer program.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the data query method described above.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of the data query method described above.
The data query method, the data query device, the computer equipment, the storage medium and the program product are characterized in that channel identification information and client information input in a data query inlet are obtained, a channel query interface for data forwarding is determined according to the channel identification information, the channel query interface is called to send a query request carrying the client information to a query server, so that the query server queries according to the query request to obtain original transaction data, and the original transaction data is issued to the channel query interface; and determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface. In the application, when data inquiry is carried out, a bank teller only needs to input channel identification information and customer information at a unified data inquiry entrance when inquiring different types of transactions, and the terminal can directly acquire the input channel identification information and the customer information, so that when inquiring different types of transactions, the bank teller does not need to inquire at different inquiry entrances, the complexity of data inquiry is further reduced, and when the data inquiry is carried out, the bank teller does not need to memorize various transaction codes, the error of inquiry results caused by the memory errors of the transaction codes is avoided, and the accuracy of the inquiry results is improved.
Drawings
FIG. 1 is an application environment diagram of a data polling method in one embodiment;
FIG. 2 is a flow diagram of a method of data polling in one embodiment;
FIG. 3 is a flow chart of a data polling method in another embodiment;
FIG. 4 is a flow chart of a data polling method in another embodiment;
FIG. 5 is a block diagram of the structure of a data polling device in one embodiment;
FIG. 6 is a block diagram of a data polling device in another embodiment;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The data query method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the query terminal 102 communicates with the channel query interface 104 via a network, and the channel query interface communicates with the query server 106 via a network. The data storage system may store data that the query server 106 needs to process, such as channel transaction codes corresponding to respective channel query interfaces. The data storage system may be integrated on the query server 106 or may be located on the cloud or other network server. The query terminal 102 obtains channel identification information and client information input in a data query entry, determines a channel query interface for data forwarding according to the channel identification information, calls the channel query interface to send a query request carrying the client information to a query server, so that the query server queries to obtain original transaction data according to the query request, and issues the original transaction data to the channel query interface; target transaction data corresponding to the customer information is determined based on the original transaction data in the channel query interface. The inquiry terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, terminal devices for inquiry services for banks, and the like. The channel query interface 104 may be an interface for data forwarding integrally generated with the query terminal, or may be a virtual interface, or may be a terminal device for data forwarding separately provided. The query server 106 may be implemented as a stand-alone server or as a cluster of servers.
In one embodiment, as shown in fig. 2, a data query method is provided, which is illustrated by taking the query terminal 102 in fig. 1 as an example, and includes the following steps:
step 202, obtaining channel identification information and customer information input in a data query entry.
Wherein, the data query portal may refer to a portal for conducting transaction data queries. The data query portal may query historical transaction data and real-time transaction data. The data query entrance is positioned at the front end and can receive information input by a bank teller.
The channel identification information may refer to information for characterizing unique identifications of the respective channel query interfaces. The channel identification information may be a number of each channel query interface.
The channel query interface may refer to an interface for providing transaction data forwarding services. The channel inquiry interface is in butt joint with the front end and the background (inquiry server), when the data inquiry entrance at the front end receives information input by a bank teller, the front end forwards the information input by the bank teller to the channel inquiry interface, and the channel inquiry interface receives the information forwarded by the front end and sends the corresponding information to the inquiry server so that the inquiry server can inquire transaction data according to the information. After the query server queries to obtain the transaction data, the query server sends the queried data to the channel query interface so that the channel query interface forwards the transaction data to the front end, thereby realizing the query of the transaction data.
Customer information may refer to information used to characterize a unique identity of a customer. Such as the customer's identification card number, cell phone number, bank card number, etc.
For example, a man-machine interaction platform may be set up in advance on the front end (query terminal), and a data query entry is set up in the man-machine interaction platform, and when a bank teller inputs channel identification information and customer information in the data query entry, the query terminal obtains the channel identification information and the customer information input in the data query entry.
In some embodiments, the bank teller may also determine the scope of the data query in the data query portal to more accurately query for the original transaction data.
For example, a bank teller may determine to query for transaction data for the last three months in a data query portal.
Step 204, determining a channel query interface for data forwarding according to the channel identification information.
In this embodiment, a plurality of channel query interfaces are provided, and each channel query interface corresponds to one channel identification information. When the channel identification information is determined, the channel query interface for data forwarding is also uniquely determined.
Step 206, calling the channel inquiry interface to send an inquiry request carrying the client information to the inquiry server, so that the inquiry server inquires according to the inquiry request to obtain the original transaction data, and issuing the original transaction data to the channel inquiry interface.
The query request may refer to request information sent by the channel query interface for requesting the query server to query the original transaction data.
Raw transaction data may refer to raw transaction data that a query server directly queries from a database storing data, a server storing data, a local storage unit for data storage, or elsewhere.
The query terminal initiates a call request to the channel query interface after determining the channel query interface according to the channel identification information, so as to call the channel query interface to send a query request carrying client information to the query server, and the query server obtains original transaction data according to the query request query after receiving the query request and issues the original transaction data to the channel query interface. The channel inquiry interface receives the original transaction data and stores the original transaction data in a classified mode according to the client information so that the follow-up front end can directly inquire according to the client information to obtain target transaction data.
In some embodiments, the channel query interface may also forward the original transaction data directly to the front end after receiving the original transaction data. The raw transaction data may also be stored in a memory unit that is locally used for transaction data storage.
Step 208, determining target transaction data corresponding to the customer information based on the original transaction data in the channel query interface.
Wherein the target transaction data may refer to transaction data corresponding to customer information.
For example, the original transaction data in the channel query interface may be read directly, and then the target transaction data is obtained according to the client information query.
In some embodiments, the front end may determine a format requirement of the corresponding information upload according to the client information, and then perform conversion processing on the original transaction data according to the format requirement to obtain the corresponding target transaction data.
For example, some clients have special format requirements, such as exporting data according to a predetermined format, at this time, the original transaction data can be directly converted according to the predetermined format to obtain corresponding target transaction data, so that subsequent manual processing of the transaction data is avoided, the data conversion efficiency is improved, and the experience of users is improved.
According to the technical scheme, when the data query is carried out, when a bank teller inquires different types of transactions, only channel identification information and client information are required to be input at a unified data query entrance, and the terminal can directly acquire the input channel identification information and the client information, so that when the different types of transactions are queried, the different query entrances are not required to be queried, the complexity of the data query is further reduced, and when the data query is carried out, the teller is not required to memorize various transaction codes, the error of query results caused by the memory errors of the transaction codes is avoided, and the accuracy of the query results is improved.
In some embodiments, prior to the step 202 of obtaining the channel identification information and the customer information entered in the data query portal, the data query method further comprises the steps of: acquiring field information corresponding to at least two channel query interfaces; and integrating at least two channel query interfaces according to the information of each field to obtain a data query entry.
In the related art, different channel query interfaces have different field information requirements and transaction codes. And if and only if the field input by the bank teller meets the field information requirement and the transaction code input is correct, the transaction data can be queried in the channel query interface.
The field information may refer to field information requirements of the respective channel query interfaces. The channel query interface can identify field information if and only if the entered field information meets the field information requirements.
The field information corresponding to the at least two channel query interfaces can be obtained, then the field information requirement of each channel query interface is determined according to each field information, and the at least two channel query interfaces are integrated according to the field information to obtain a data query entry, so that the field information of the data query entry meets the field information requirement of each channel query interface.
The field information of all channel query interfaces connected with the front end can be obtained, and then all channel query interfaces are integrated according to the field information to obtain a data query entry, so that the field information of the query entry meets the field information requirements of all channel query interfaces.
According to the technical scheme, the field information corresponding to the at least two channel query interfaces is acquired, the at least two channel query interfaces are integrated according to the field information to obtain the data query entrance, when data query is carried out subsequently, data query is not required to be carried out on different channel query interfaces according to different data types, the complexity of the data query is reduced, the data query is convenient for a teller to query, the situation that a teller makes mistakes due to the fact that the channel query interfaces are selected incorrectly when the teller queries is avoided, and the accuracy of the query result is improved.
In some embodiments, the step of integrating at least two channel query interfaces into a data query entry according to each field of information includes the steps of: acquiring a union of information of each field; and integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
The method includes the steps that after each field information is obtained, a union set of the field information is obtained, and at least two channel query interfaces are integrated according to the union set of the field information to obtain a data query entry, so that the data query entry can meet query requirements of all the channel query interfaces.
According to the technical scheme, the union of the field information is obtained, and then at least two channel query interfaces are integrated according to the union of the field information to obtain the data query entrance, so that when data query is carried out subsequently, data query is not required to be carried out on different channel query interfaces according to different data types, the complexity of the data query is reduced, the query of a teller is facilitated, the situation that the query result is wrong due to the fact that the channel query interfaces are selected by the teller in the process of query is avoided, and the accuracy of the query result is improved.
In some embodiments, the field information includes a send field, step 206 "send a query request carrying customer information to a query server with a channel query interface" includes the steps of: generating standard query information according to the transmission field and the client information; generating a query request according to the standard query information; and calling a channel query interface to send a query request.
Wherein the send field may refer to a field requirement sent to the query server.
Standard query information may refer to information that meets field requirements and is used to perform a data query.
The client information is illustratively processed according to the sending field to generate and obtain standard query information, then the standard query information is packaged to obtain a query request, and the channel query interface is called to send the query request, so that the query server queries and obtains the original transaction data according to the standard query information in the query request.
According to the technical scheme, the standard query information meeting the information query requirement in the query server is generated by sending the fields and the client information, so that the subsequent query server can query and obtain the original transaction data conveniently, and the efficiency and accuracy of information query are improved.
In some embodiments, the field information includes a return field, step 208 "determining target transaction data corresponding to customer information based on the original transaction data in the channel query interface" includes the steps of: determining a return field corresponding to the channel identification information; and reading the original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain target transaction data.
The return field may refer to a field requirement of the return information received by the channel query interface.
Illustratively, the corresponding return field is first determined according to the channel identification information, then the original transaction data corresponding to the client information stored in the channel inquiry interface is read, and then the original transaction data is converted according to the return field, so as to obtain the target transaction data.
Referring to fig. 3, some embodiments of the present application provide a data query method, taking a query server applied in fig. 1 as an example for illustration, including the following steps:
step 302, acquiring a query request sent by a channel query interface; the channel query interface determines that the query request carries the client information input in the data query entrance according to the channel identification information input in the data query entrance.
Illustratively, the query server obtains a query request from the channel query interface and extracts customer information from the query request.
Step 304, determining the channel transaction code according to the channel inquiry interface.
The channel transaction code may refer to a transaction code corresponding to the channel query interface for querying transaction data. Each channel inquiry interface automatically corresponds to a channel transaction code, and when the channel inquiry interface is uniquely determined, the channel transaction code is uniquely determined.
Step 306, obtaining the original transaction data according to the channel transaction code and the customer information in the query request, and transmitting the original transaction data to the channel query interface.
Illustratively, after determining the channel transaction code and the customer information, the query server queries directly for the original transaction data according to the channel transaction code and the customer information, and issues the original transaction data to the channel query interface.
According to the technical scheme, the channel transaction code is determined according to the channel query interface by acquiring the query request sent by the channel query interface, and then the original transaction data can be queried and obtained directly according to the channel transaction code and the client information in the query request, so that a bank teller is not required to memorize a plurality of transaction codes, the query result error caused by the transaction code memory error is avoided, and the accuracy of the query result is improved.
Referring to fig. 4, some embodiments of the present application provide a data query method, including the following steps:
step 402, obtaining field information corresponding to at least two channel query interfaces.
Step 404, a union of the field information is obtained.
Step 406, integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
Step 408, obtaining channel identification information and customer information entered in the data query entry.
Step 410, determining a channel query interface for data forwarding according to the channel identification information.
Step 412, generating standard query information according to the sending field and the client information in the field information.
In step 414, a query request is generated based on the standard query information.
Step 416, call the channel inquiry interface to send an inquiry request, so that the inquiry server inquires to obtain the original transaction data according to the inquiry request, and send the original transaction data to the channel inquiry interface.
Step 418, determining a return field corresponding to the channel identification information.
Step 420, original transaction data corresponding to the customer information in the channel inquiry interface is read, and the original transaction data is converted according to the return field to obtain target transaction data.
Specifically, the specific implementation process of steps 402 to 420 is referred to the foregoing embodiments, and will not be described in detail herein.
According to the technical scheme, when the data query is carried out, when a bank teller inquires different types of transactions, only channel identification information and customer information are required to be input at a unified data query entrance, and the terminal can directly acquire the input channel identification information and the customer information, so that when the different types of transactions are queried, the different query entrances are not required to be queried, the complexity of the data query is further reduced, and when the data query is carried out, the teller is not required to memorize various transaction codes, the complexity of the data query is reduced, meanwhile, the error of query results caused by the memory errors of the transaction codes is avoided, and the accuracy of the query results is improved.
It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a data query device for realizing the above related data query method. The implementation of the solution provided by the device is similar to the implementation described in the method above, so the specific limitations in one or more embodiments of the data querying device provided below may be found in the limitations of the data querying method above.
In one embodiment, as shown in fig. 5, there is provided a data query apparatus, including: an information acquisition module 502, an interface determination module 504, an interface invocation module 506, and a transaction data determination module 508, wherein:
the information acquisition module 502 is configured to acquire channel identification information and client information input in the data query entry.
An interface determining module 504 is configured to determine a channel query interface for data forwarding according to the channel identification information.
The interface calling module 506 is configured to call the channel query interface to send a query request carrying client information to the query server, so that the query server queries to obtain the original transaction data according to the query request, and issues the original transaction data to the channel query interface.
The transaction data determining module 508 is configured to determine target transaction data corresponding to the customer information based on the original transaction data in the channel query interface.
In some embodiments, the data query device further includes an interface integration module for: acquiring field information corresponding to at least two channel query interfaces; and integrating at least two channel query interfaces according to the information of each field to obtain a data query entry.
In some embodiments, the interface integration module is further to: acquiring a union of information of each field; and integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
In some embodiments, the information acquisition module 502 is further configured to generate standard query information from the transmission field and the client information; generating a query request according to the standard query information; and calling a channel query interface to send a query request.
In some embodiments, the transaction data determination module 508 is further configured to determine a return field corresponding to the channel identification information; and reading the original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain target transaction data.
Referring to fig. 6, in some embodiments, a data query apparatus is provided, including a query request acquisition module 602, a channel transaction code determination module 604, and a query module 606, wherein:
a query request acquisition module 602, configured to acquire a query request sent by a channel query interface; the channel query interface determines that the query request carries the client information input in the data query entrance according to the channel identification information input in the data query entrance.
The channel transaction code determining module 604 is configured to determine a channel transaction code according to the channel query interface.
The query module 606 is configured to query and obtain original transaction data according to the channel transaction code and the client information in the query request, and send the original transaction data to the channel query interface.
The various modules in the data querying device described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a data query method. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 7 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of: acquiring channel identification information and client information input in a data query entry; determining a channel inquiry interface for data forwarding according to the channel identification information; calling a channel query interface to send a query request carrying client information to a query server so that the query server queries to obtain original transaction data according to the query request and issues the original transaction data to the channel query interface; target transaction data corresponding to the customer information is determined based on the original transaction data in the channel query interface.
In one embodiment, the processor when executing the computer program further performs the steps of: acquiring field information corresponding to at least two channel query interfaces; and integrating at least two channel query interfaces according to the information of each field to obtain a data query entry.
In one embodiment, the processor when executing the computer program further performs the steps of: acquiring a union of information of each field; and integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
In one embodiment, the processor when executing the computer program further performs the steps of: generating standard query information according to the transmission field and the client information; generating a query request according to the standard query information; and calling a channel query interface to send a query request.
In one embodiment, the processor when executing the computer program further performs the steps of: determining a return field corresponding to the channel identification information; and reading the original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain target transaction data.
In one embodiment, the processor when executing the computer program further performs the steps of: acquiring a query request sent by a channel query interface; the channel inquiry interface determines that the inquiry request carries client information input in the data inquiry entrance according to channel identification information input in the data inquiry entrance; determining a channel transaction code according to the channel inquiry interface; and inquiring according to the channel transaction code and the client information in the inquiry request to obtain the original transaction data, and transmitting the original transaction data to the channel inquiry interface.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring channel identification information and client information input in a data query entry; determining a channel inquiry interface for data forwarding according to the channel identification information; calling a channel query interface to send a query request carrying client information to a query server so that the query server queries to obtain original transaction data according to the query request and issues the original transaction data to the channel query interface; target transaction data corresponding to the customer information is determined based on the original transaction data in the channel query interface.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring field information corresponding to at least two channel query interfaces; and integrating at least two channel query interfaces according to the information of each field to obtain a data query entry.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a union of information of each field; and integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
In one embodiment, the computer program when executed by the processor further performs the steps of: generating standard query information according to the transmission field and the client information; generating a query request according to the standard query information; and calling a channel query interface to send a query request.
In one embodiment, the computer program when executed by the processor further performs the steps of: determining a return field corresponding to the channel identification information; and reading the original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain target transaction data.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a query request sent by a channel query interface; the channel inquiry interface determines that the inquiry request carries client information input in the data inquiry entrance according to channel identification information input in the data inquiry entrance; determining a channel transaction code according to the channel inquiry interface; and inquiring according to the channel transaction code and the client information in the inquiry request to obtain the original transaction data, and transmitting the original transaction data to the channel inquiry interface.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of: acquiring channel identification information and client information input in a data query entry; determining a channel inquiry interface for data forwarding according to the channel identification information; calling a channel query interface to send a query request carrying client information to a query server so that the query server queries to obtain original transaction data according to the query request and issues the original transaction data to the channel query interface; target transaction data corresponding to the customer information is determined based on the original transaction data in the channel query interface.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring field information corresponding to at least two channel query interfaces; and integrating at least two channel query interfaces according to the information of each field to obtain a data query entry.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a union of information of each field; and integrating at least two channel query interfaces according to the union of the field information to obtain a data query entry.
In one embodiment, the computer program when executed by the processor further performs the steps of: generating standard query information according to the transmission field and the client information; generating a query request according to the standard query information; and calling a channel query interface to send a query request.
In one embodiment, the computer program when executed by the processor further performs the steps of: determining a return field corresponding to the channel identification information; and reading the original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain target transaction data.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a query request sent by a channel query interface; the channel inquiry interface determines that the inquiry request carries client information input in the data inquiry entrance according to channel identification information input in the data inquiry entrance; determining a channel transaction code according to the channel inquiry interface; and inquiring according to the channel transaction code and the client information in the inquiry request to obtain the original transaction data, and transmitting the original transaction data to the channel inquiry interface.
It should be noted that, the client information (including, but not limited to, client device information, client personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use and processing of the relevant data are required to comply with relevant laws and regulations of relevant countries and regions.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims (10)

1. A method of querying data, the method comprising:
acquiring channel identification information and client information input in a data query entry;
determining a channel inquiry interface for data forwarding according to the channel identification information;
invoking the channel query interface to send a query request carrying the client information to a query server, so that the query server queries to obtain original transaction data according to the query request, and issues the original transaction data to the channel query interface;
and determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface.
2. The method of claim 1, wherein prior to obtaining the channel identification information and the customer information entered in the data query portal, the method further comprises:
acquiring field information corresponding to at least two channel query interfaces;
and integrating the at least two channel query interfaces according to the field information to obtain the data query entry.
3. The method according to claim 2, wherein integrating the at least two channel query interfaces according to each of the field information to obtain the data query entry comprises:
acquiring a union of the field information;
and integrating the at least two channel query interfaces according to the union of the field information to obtain the data query entry.
4. The method of claim 2, wherein the field information comprises a send field;
the step of calling the channel query interface to send a query request carrying the client information to a query server comprises the following steps:
generating standard query information according to the transmission field and the client information;
generating the query request according to the standard query information;
and calling the channel query interface to send the query request.
5. The method of claim 2, wherein the field information comprises a return field;
the determining target transaction data corresponding to the customer information based on the original transaction data in the channel query interface comprises:
determining a return field corresponding to the channel identification information;
and reading original transaction data corresponding to the client information in the channel inquiry interface, and converting the original transaction data according to the return field to obtain the target transaction data.
6. A method of querying data, the method comprising:
acquiring a query request sent by a channel query interface; the channel inquiry interface is determined according to channel identification information input in a data inquiry inlet, and the inquiry request carries client information input in the data inquiry inlet;
determining a channel transaction code according to the channel inquiry interface;
and inquiring according to the channel transaction code and the client information in the inquiry request to obtain original transaction data, and transmitting the original transaction data to the channel inquiry interface.
7. A data querying device, the device comprising:
the information acquisition module is used for acquiring channel identification information and client information input in the data query entry;
the interface determining module is used for determining a channel query interface for data forwarding according to the channel identification information;
the interface calling module is used for calling the channel inquiry interface to send an inquiry request carrying the client information to an inquiry server so that the inquiry server can inquire according to the inquiry request to obtain original transaction data and send the original transaction data to the channel inquiry interface;
and the transaction data determining module is used for determining target transaction data corresponding to the client information based on the original transaction data in the channel query interface.
8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any one of claims 1 to 5 or the steps of the method of claim 6.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any one of claims 1 to 5 or the steps of the method of claim 6.
10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any one of claims 1 to 5 or the steps of the method of claim 6.
CN202311207651.3A 2023-09-19 2023-09-19 Data query method, apparatus, computer device, storage medium, and program product Pending CN117271563A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311207651.3A CN117271563A (en) 2023-09-19 2023-09-19 Data query method, apparatus, computer device, storage medium, and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311207651.3A CN117271563A (en) 2023-09-19 2023-09-19 Data query method, apparatus, computer device, storage medium, and program product

Publications (1)

Publication Number Publication Date
CN117271563A true CN117271563A (en) 2023-12-22

Family

ID=89213625

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311207651.3A Pending CN117271563A (en) 2023-09-19 2023-09-19 Data query method, apparatus, computer device, storage medium, and program product

Country Status (1)

Country Link
CN (1) CN117271563A (en)

Similar Documents

Publication Publication Date Title
US11442939B2 (en) Configurable and incremental database migration framework for heterogeneous databases
WO2020207084A1 (en) Payment complaint method, device, server, and readable storage medium
CN111863178A (en) Method, device, medium and electronic device for issuing medical report
CN114238397A (en) User data processing method, device, equipment, storage medium and program product
US20210326368A1 (en) Workflow-based dynamic data model and application generation
EP3407568A1 (en) Service processing method and device
CN111753203A (en) Card number recommendation method, device, equipment and medium
CN117271563A (en) Data query method, apparatus, computer device, storage medium, and program product
CN114254278A (en) User account merging method and device, computer equipment and storage medium
CN112990783A (en) Material allocation method, system, equipment and medium
CN111814029A (en) Data query method, system and computing device
CN117114665A (en) Unified transfer system and method
CN117669528A (en) Document generation method, device, computer equipment and storage medium
CN117151841A (en) Service processing method, device, computer equipment, storage medium and program product
CN116011029A (en) Information verification method, information verification device, computer equipment and storage medium
CN117035855A (en) Resource management method, apparatus, device, storage medium, and program product
CN117709615A (en) Data processing method, device, computer equipment and storage medium
CN117437002A (en) Service carding method, device, computer equipment and storage medium
CN116911410A (en) Mesh point reservation method, mesh point reservation device, computer equipment and storage medium
CN116709299A (en) Auxiliary card opening method, device, computer equipment and storage medium
CN117216164A (en) Financial data synchronous processing method, apparatus, device, medium and program product
CN117436889A (en) Resource processing method, device, computer equipment and storage medium
CN116452214A (en) Block chain-based after-sales information processing method and device and computer equipment
CN117422459A (en) Resource transfer method, device, computer equipment and storage medium
CN117437008A (en) Bank merchant intelligent registration method, device, computer equipment and storage medium

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