Business data query method and device, electronic equipment and computer program product

By synchronizing the business data of financial applications to the business database, and performing access control and business type identification after receiving the query request, the problem of low efficiency of financial business data query is solved, and efficient and accurate data query and real-time update are achieved.

CN119807248APending Publication Date: 2025-04-11INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF 0 Cites 2 Cited by

Patent Information

Application Number
CN202411894755.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-20
Publication Date
2025-04-11

AI Technical Summary

Technical Problem

When querying business data in the financial field, the existing technology has problems with low query efficiency, resulting in extended service response time, network delays and frequent RPC calls increase the load of the system, and may even cause abnormal situations such as service timeouts, thread pool full load and hotspot blockage.

Method used

By obtaining the business data of M financial applications, synchronizing them to the business database of the business information auxiliary service system, receiving the client's business query request, and performing access control and legality detection. Then, the query service of the service information auxiliary service system is called for business type identification, the target service data is filtered out and sent to the client.

Benefits of technology

It improves the efficiency and accuracy of financial business data query, reduces the equipment resource pressure and resource consumption of each application system during high-frequency query, realizes real-time update of business data and data consistency, and solves the problem of low query efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119807248A_ABST
    Figure CN119807248A_ABST
Patent Text Reader

Abstract

The invention discloses a business data query method and device, electronic equipment and a computer program product. The method comprises the following steps: obtaining business data of M financial applications; synchronizing the M pieces of business data to a business database of a business information auxiliary service system; receiving a business query request sent by a client from a channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request; under the condition that the channel side passes the access control detection and the business query request passes the detection, calling a query service to perform business type identification on the business query request to obtain query information; and screening out target business data from the business database according to the query information, and sending the target business data to the client to respond to the business query request. Through the method and the device, the problem of low query efficiency when the business data in the financial field is queried is solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of financial technology, and specifically, to a method, device, electronic device and computer program product for querying business data. Background Art

[0002] In the current internal system architecture of financial institutions, different financial products are associated with different business sectors, which are supported by special business codes and business data is stored in independent databases, forming information islands. As the most frequently used channel for customers, mobile applications bear a large number of customer query requests. When querying the relevant information of multiple financial products, it is necessary to call the service interfaces of different fields separately to obtain complete asset information.

[0003] Under the above technical architecture, obtaining personal financial asset information involves frequent data interactions across multiple independent nodes. The communication between these nodes is mainly achieved through remote procedure calls. In the process of calling financial services, data needs to be transmitted multiple times on different network links, which will increase data latency and network loss, resulting in longer overall service response time. In high-concurrency scenarios, network latency and frequent RPC calls will further aggravate the response time and stability issues of the service, and may even cause abnormal situations such as service timeouts, thread pool full loads, and hotspot blocking, seriously affecting customer experience.

[0004] In addition, since query calls must pass through application services in various financial fields, this adds additional load to the originally independent and single-function applications. In order to cope with the high-frequency queries of applications, financial applications need to re-evaluate their container performance and database access capabilities, which not only affects the application's processing of other transaction calls, but also leads to a significant increase in equipment costs.

[0005] With regard to the problem of low query efficiency when querying business data in the financial field in related technologies, no effective solution has been proposed so far. Summary of the invention

[0006] The main purpose of the present application is to provide a business data query method, device, electronic device and computer program product to solve the problem of low query efficiency when querying business data in the financial field in the related technology.

[0007] In order to achieve the above-mentioned purpose, according to one aspect of the present application, a method for querying business data is provided. The method includes: obtaining business data of M financial applications, where M is a positive integer; synchronizing the business data of the M financial applications to the business database of the business information auxiliary service system; receiving a business query request sent by a client on the channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, calling the query service of the business information auxiliary service system to identify the business type of the business query request and obtain query information; according to the query information, filtering out the target business data corresponding to the business query request from the business database, and sending the target business data to the client to respond to the business query request.

[0008] Furthermore, synchronizing the business data of the M financial applications to the business database of the business information auxiliary service system includes: performing an application evaluation on each financial application to obtain M evaluation results, wherein each evaluation result is used to indicate whether to perform data synchronization on the business data associated with a financial application; for a financial application, when the evaluation result of the financial application indicates that data synchronization is performed on the business data associated with the financial application, determining a data source for storing business data in the financial application, wherein the data source includes a main application database and a backup application database or a main application database and three backup application databases; synchronizing the business data in the data source to the business database, wherein the data synchronization method includes at least one of the following: existing data synchronization, real-time data synchronization, and data synchronization backup.

[0009] Furthermore, when the data synchronization method is the existing data synchronization, synchronizing the business data in the data source to the business database includes: obtaining N business tables associated with the data source, and extracting the business data of each business table to obtain N groups of business data, where N is a positive integer; obtaining preset format rules, and using the preset format rules to convert the format of each group of business data to obtain N groups of converted business data; the N groups of converted business data constitute a first stored file, and synchronizing the first stored file to the business database.

[0010] Furthermore, in the case where the data synchronization mode is the real-time data synchronization, before synchronizing the business data in the data source to the business database, the method also includes: when monitoring the data source for new data, obtaining Y real-time business data newly added in the data source, wherein the Y real-time business data are distributed in N business tables associated with the data source, and Y is a positive integer; caching the Y real-time business data to a target message queue, wherein the target message queue includes N data streams corresponding to the N business tables, and each data stream corresponds to a business cache table; synchronizing the business data in the data source to the business database The service database includes: subscribing to the N data streams and performing regular monitoring on the N data streams; when the Y real-time business data exist in the business cache table associated with the N data streams, extracting the Y real-time business data from the target message queue, and updating the Y real-time business data to the business database; when the data synchronization method is the data synchronization guarantee, synchronizing the business data in the data source to the business database includes: extracting K business data newly added by the data source within a preset time period, and synchronizing the K business data to the business database, wherein K is greater than or equal to Y and K is a positive integer.

[0011] Furthermore, performing access control detection on the channel side includes: obtaining a channel control table, wherein the channel control table includes the correlation relationship between channel side information and permission information of multiple channel sides; identifying target channel side information of the channel side, and extracting target permission information from the channel control table according to the target channel side information; when the target permission information indicates that the channel side is allowed to perform business access, determining that the channel side has passed the access control detection, and executing the step of performing legality and compliance detection on the business query request; when the target permission information indicates that the channel side is not allowed to perform business access, generating a first prompt information, wherein the first prompt information is used to indicate that business access is not allowed.

[0012] Further, performing a legality and compliance check on the service query request includes: extracting a message field from the service query request and obtaining a preset field rule; extracting a service address from the service query request when the message field complies with the preset field rule, and generating a second prompt message when the message field does not comply with the preset field rule, wherein the second prompt message is used to indicate a service access error; obtaining a preset area, and when the service address is within the preset area, determining whether the client number of the client is within a preset list, and generating the second prompt message when the service address is outside the preset area, wherein the second prompt message is used to indicate a service access error; when the client number of the client is not within the preset list, determining that the service query request passes the legality and compliance check; and when the client number of the client is within the preset list, generating the second prompt message, wherein the second prompt message is used to indicate a service access error.

[0013] Furthermore, the query service of the business information auxiliary service system is determined in the following manner: obtaining the component service of each financial application to obtain M groups of component services; link merging the M groups of component services to obtain merged component services, and determining the merged component services as the query service of the business information auxiliary service system.

[0014] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a device for querying business data is provided. The device includes: a first acquisition unit, used to acquire business data of M financial applications, wherein M is a positive integer; a synchronization unit, used to synchronize the business data of the M financial applications to the business database of the business information auxiliary service system; a receiving unit, used to receive a business query request sent by a client on the channel side, perform access control detection on the channel side, and perform legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; a calling unit, used to call the query service of the business information auxiliary service system to identify the business type of the business query request and obtain query information when the channel side passes the access control detection and the business query request passes the legality and compliance detection; a screening unit, used to screen out target business data corresponding to the business query request from the business database according to the query information, and send the target business data to the client to respond to the business query request.

[0015] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is also provided, wherein the computer-readable storage medium includes a stored executable program, wherein when the executable program is running, the device where the computer-readable storage medium is located is controlled to execute any of the above-mentioned business data query methods.

[0016] According to another aspect of an embodiment of the present invention, there is also provided an electronic device, comprising one or more processors and a memory, wherein the memory stores an executable program, and the processor is used to run the program, wherein when the one or more programs are executed by the one or more processors, the one or more processors implement any one of the above-mentioned business data query methods.

[0017] According to another aspect of an embodiment of the present invention, a computer program product is provided. The computer program product includes a computer program. When the computer program is executed by a processor, any one of the above-mentioned business data query methods is implemented.

[0018] In an embodiment of the present application, a business data query method is adopted to obtain business data of M financial applications, where M is a positive integer; the business data of the M financial applications are synchronized to the business database of the business information auxiliary service system; a business query request sent by a client on the channel side is received, access control detection is performed on the channel side, and legality and compliance detection is performed on the business query request, where the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, the query service of the business information auxiliary service system is called to identify the business type of the business query request to obtain query information; according to the query information, the target business data corresponding to the business query request is filtered out from the business database, and the target business data is sent to the client to respond to the business query request, thereby achieving the purpose of improving the efficiency and accuracy of financial business data query and reducing the equipment resource pressure and resource consumption brought to each application system during high-frequency query, thereby achieving the technical effect of reducing cross-application query business data, improving the query efficiency of business data, and realizing real-time update of business data and data consistency, thereby solving the problem of low query efficiency when querying business data in the financial field. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings constituting a part of the present application are used to provide a further understanding of the present application. The illustrative embodiments and descriptions of the present application are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0020] Figure 1It is a hardware structure block diagram of a computer terminal (or mobile device) for implementing a method for querying business data;

[0021] Figure 2 is a flowchart of a method for querying business data provided in an embodiment of the present application;

[0022] Figure 3 is a schematic diagram of a business information auxiliary service system provided according to an embodiment of the present application Figure 1 ;

[0023] Figure 4 is a schematic diagram of a business information auxiliary service system provided according to an embodiment of the present application Figure 2 ;

[0024] Figure 5 is a schematic diagram of an operation method of a business processing module provided according to an embodiment of the present application;

[0025] Figure 6 is a schematic diagram of an operation method of a data module provided according to an embodiment of the present application;

[0026] Figure 7 is a schematic diagram of a device for querying business data provided in an embodiment of the present application;

[0027] Figure 8 It is a structural block diagram of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0028] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0029] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0030] It should be noted that the relevant information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for display, data for analysis, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties. For example, an interface is set up between this system and the relevant user or organization. Before obtaining relevant information, it is necessary to send an acquisition request to the aforementioned user or organization through the interface, and obtain relevant information after receiving the consent information fed back by the aforementioned user or organization.

[0031] It should be noted that the collected information used in this application is information and data authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, disclosure and application of the relevant data comply with the relevant laws, regulations and standards of the relevant regions, take necessary confidentiality measures, do not violate public order and good morals, and provide corresponding operation entrances for users to choose to authorize or refuse to use it.

[0032] Example 1

[0033] According to an embodiment of the present application, a method embodiment for querying business data is also provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0034] The method embodiment provided in the first embodiment of the present application can be executed in a mobile terminal, a computer terminal or a similar computing device. Figure 1 It is a hardware structure diagram of a computer terminal (or mobile device) for implementing a method for querying business data, such as Figure 1 As shown, the computer terminal 10 (or mobile device) may include one or more ( Figure 1 102a, 102b, ..., 102n are used to illustrate) a processor 102 (the processor 102 may include but is not limited to a processing device such as a microprocessor MCU (Microcontroller Unit) or a programmable logic device FPGA (Field-Programmable Gate Array)), a memory 104 for storing data, and a transmission device 106 for communication functions. In addition, it may also include: a display, an input / output interface (I / O interface), a universal serial bus (USB) port (which may be included as one of the ports of the BUS bus), a network interface, a keyboard, a cursor control device, a power supply and / or a camera. It can be understood by those skilled in the art that Figure 1The structure shown is only for illustration and does not limit the structure of the above electronic device. Figure 1 More or fewer components as shown, or with Figure 1 Different configurations shown.

[0035] It should be noted that the one or more processors 102 and / or other data processing circuits described above may generally be referred to herein as "data processing circuits". The data processing circuits may be embodied in whole or in part as software, hardware, firmware, or any other combination thereof. In addition, the data processing circuit may be a single independent processing module, or may be incorporated in whole or in part into any of the other components in the computer terminal 10 (or mobile device). As described in the embodiments of the present application, the data processing circuit acts as a processor control (e.g., selection of a variable resistor terminal path connected to an interface).

[0036] The memory 104 can be used to store software programs and modules of application software, such as program instructions / data storage devices corresponding to the query method for business data in the embodiment of the present application. The processor 102 executes various functional applications and data processing by running the software programs and modules stored in the memory 104, that is, realizing the query method for business data described above. The memory 104 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 104 may further include a memory remotely arranged relative to the processor 102, and these remote memories may be connected to the computer terminal 10 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0037] The transmission device 106 is used to receive or send data via a network. The specific example of the above network may include a wireless network provided by a communication provider of the computer terminal 10. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, NIC) and a network interface, which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 106 can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0038] The display may be, for example, a touch screen liquid crystal display (LCD) that enables a user to interact with a user interface of the computer terminal 10 (or mobile device).

[0039] Under the above operating environment, this application provides Figure 2The query method of the business data shown. Figure 2 is a flowchart of a method for querying business data provided in an embodiment of the present application, such as Figure 2 As shown, the method comprises the following steps:

[0040] Step S201, obtaining business data of M financial applications, where M is a positive integer.

[0041] Specifically, the financial application may be a deposit application, a provident fund application, etc., and the business data of these financial applications may be deposit amount data, etc.

[0042] Step S202: Synchronize the business data of the M financial applications to the business database of the business information auxiliary service system.

[0043] Specifically, in order to achieve high-efficiency, low-latency financial query services, we can first monitor the database change logs of financial applications, capture data changes in real time, and then synchronize the business data of each financial application to the business database of the business information auxiliary service system, thereby reducing the calling pressure of each financial application, improving the operating efficiency and user experience of the entire financial system, and achieving high aggregation and optimization of financial services.

[0044] Step S203, receiving a business query request sent by a client on the channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold.

[0045] Specifically, after synchronizing the business data of financial applications, if the channel side needs to perform business access, after receiving the business query request sent by the client on the channel side, it is necessary to authenticate the accessed channel, verify its identity and authority, and perform parameter legality and compliance checks on the received business query request. For example, verify whether the parameters contained in the request are complete, the format is correct, and whether they comply with predefined field rules; check whether the customer number field contains abnormal characters, whether it exceeds the limit, whether required fields are missing, etc., to ensure the accuracy and security of the data, thereby improving the security, reliability and efficiency of access.

[0046] Step S204: When the channel side passes the access control detection and the business query request passes the legality and compliance detection, the query service of the business information auxiliary service system is called to identify the business type of the business query request to obtain query information.

[0047] Specifically, the channel side can be a mobile application, a physical institution of a financial institution, etc. When the access control detection on the channel side and the legitimacy and compliance detection of the business query request are passed, the request can be parsed to extract key business identification information, such as business code, request type, etc., to identify specific business needs.

[0048] After identifying the specific business type, select the appropriate query service of the business information auxiliary service system according to the predefined business logic for invocation. For example, for a query request for fund business, the fund business query service in the query service can be called. After calling the query service, read the query information to be queried. For example, the query information can be to query the balance, obtain account details, or query the amount status.

[0049] Step S205 , screen out target business data corresponding to the business query request from the business database according to the query information, and send the target business data to the client to respond to the business query request.

[0050] Specifically, after identifying the query information, the query information can be used to filter out data records associated with the query request from the business database, that is, to obtain the target business data. The target business data is then encapsulated into a specific response format, such as JSON, XML, or a custom message format, for easy parsing and use by the client.

[0051] It should be noted that in order to protect the security of data during transmission, encryption protocols can be used to transmit data to ensure that the data is not stolen or tampered with during transmission between the channel side and the business information auxiliary service system. After the client receives the data, it will parse the data and display it to the user or use it for subsequent business processing.

[0052] The business data query method provided in the embodiment of the present application obtains the business data of M financial applications, where M is a positive integer; synchronizes the business data of the M financial applications to the business database of the business information auxiliary service system; receives a business query request sent by a client on the channel side, performs access control detection on the channel side, and performs legality and compliance detection on the business query request, where the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, calls the query service of the business information auxiliary service system to identify the business type of the business query request, and obtains Query information; based on the query information, the target business data corresponding to the business query request is filtered out from the business database, and the target business data is sent to the client in response to the business query request, which solves the problem of low query efficiency when querying business data in the financial field in related technologies. By synchronizing the business data of multiple financial applications to the business database, after receiving the business query request and detecting the channel side and the request sending the request, the query service is called to identify the request, so as to determine the target business data according to the identified query information, thereby achieving the technical effect of reducing cross-application query business data, improving the query efficiency of business data and realizing real-time update of business data and data consistency.

[0053] In order to achieve real-time update and data consistency of data, optionally, in the query method of business data provided in the embodiment of the present application, synchronizing the business data of M financial applications to the business database of the business information auxiliary service system includes: performing application evaluation on each financial application to obtain M evaluation results, wherein each evaluation result is used to indicate whether to synchronize the business data associated with a financial application; for a financial application, when the evaluation result of the financial application indicates that the business data associated with the financial application is to be synchronized, determining the data source for storing the business data in the financial application, wherein the data source includes a main application database and a backup application database or a main application database and three backup application databases; synchronizing the business data in the data source to the business database, wherein the data synchronization method includes at least one of the following: existing data synchronization, real-time data synchronization, and data synchronization guarantee.

[0054] Specifically, before synchronizing the business data of each financial application, the application needs to be evaluated first to determine whether the business data needs to be synchronized. For example, the frequency of use of the financial application, the frequency of data updates, the complexity of the business, the size of the data, the real-time requirements and other dimensions need to be evaluated to determine whether each application meets the conditions for data synchronization. If a financial application has multiple business transactions within a certain period of time and the data therein is updated, the evaluation result indicates that the financial application needs to be synchronized, so as to balance the efficiency and cost of data synchronization.

[0055] When data synchronization is required for a financial application, its data source, i.e., the database used to store business data, is first determined. Due to differences between different financial applications, in order to improve the high availability and fault tolerance of data, a financial application may have multiple databases, i.e., it may include a main application database and a backup application database, a main application database and three backup application databases. At this time, the most suitable data synchronization method can be selected according to the characteristics of the data source, the real-time requirements of the data, and the synchronization efficiency. For example, for a newly connected financial application, the first full data synchronization can be performed to import all historical data in the application into the business database; for high-frequency updated business data, a real-time data synchronization strategy can be adopted to capture data changes in real time and update the business database immediately; data loss or network anomalies may occur during real-time synchronization. At this time, incremental data files can be regularly downloaded from the financial application for proofreading and correcting the data in the business database. In this embodiment, business data is synchronized after evaluating the financial application, and then the business information auxiliary service system can centrally process data aggregation and data distribution tasks, avoid frequent remote calls between multiple financial applications, thereby significantly reducing resource consumption, equipment costs, and operation and maintenance costs.

[0056] There are multiple data synchronization methods. Optionally, in the business data query method provided in the embodiment of the present application, when the data synchronization method is stock data synchronization, synchronizing the business data in the data source to the business database includes: obtaining N business tables associated with the data source, and extracting the business data of each business table to obtain N groups of business data, where N is a positive integer; obtaining preset format rules, and using the preset format rules to convert the format of each group of business data to obtain N groups of converted business data; the N groups of converted business data constitute a first stored file, and synchronizing the first stored file to the business database.

[0057] When a financial application is newly connected to the business information auxiliary service system, the data synchronization of the financial application can be synchronization of existing data. At this time, the data source of the financial application can be determined, and multiple business tables in the data source can be located, such as fund tables, financial management tables, etc.

[0058] Furthermore, after extracting business data from each business table, in order to enable business data from different business tables to be uniformly stored and processed in the business database and to ensure that they comply with the data model and storage requirements of the business database, the extracted business data can be formatted using preset format rules, such as the definition of data field types, data length restrictions, and data format standardization, and data desensitization and encryption can also be performed. After the format conversion, the converted business data is quality checked to check whether the data is complete, accurate, and correct. The converted multiple sets of business data are then combined into a first-stored file containing the full amount of business data for financial applications, and transmitted to the business database of the business information auxiliary service system through a secure network connection.

[0059] It should be noted that after receiving the first deposit file, the business database can perform a data import operation to write the business data in the file into the corresponding business table. This embodiment achieves the aggregation of business data from different financial applications through data extraction, format conversion and first deposit file construction, while ensuring data consistency, providing a reliable data foundation for subsequent data query and business processing.

[0060] Data synchronization may also include synchronizing incremental data. Optionally, in the query method for business data provided in the embodiment of the present application, when the data synchronization mode is real-time data synchronization, before synchronizing the business data in the data source to the business database, the method further includes: while monitoring the data source for new data, obtaining Y real-time business data newly added in the data source, wherein the Y real-time business data are distributed in N business tables associated with the data source, and Y is a positive integer; caching the Y real-time business data to a target message queue, wherein the target message queue includes N data streams corresponding to the N business tables, and each data stream corresponds to one business cache table; synchronizing the business data in the data source to the business database includes: subscribing to N data streams and performing regular monitoring on the N data streams; when there are Y real-time business data in the business cache table associated with the N data streams, extracting Y real-time business data from the target message queue, and updating the Y real-time business data to the business database; when the data synchronization method is data synchronization guarantee, synchronizing the business data in the data source to the business database includes: extracting K business data newly added by the data source within a preset time period, and synchronizing the K business data to the business database, wherein K is greater than or equal to Y and K is a positive integer.

[0061] Specifically, when a financial application is an already connected application, in order to synchronize the newly added business data to the business database in a timely manner, data change capture technology can be used to monitor in real time the new or changed data in the business table in the data source of the above financial application. It can also be achieved by monitoring the database's transaction log, change log or using a trigger mechanism to ensure that the newly added real-time business data in the data source can be captured in a timely manner.

[0062] After detecting new data in the data source, accurately extract these real-time business data and cache them in the target message queue. You can also cache the business attributes, update time, operation type (such as insert, update) and other information of these real-time business data in the message queue.

[0063] Since the target message queue contains multiple data streams (i.e., topics) representing business cache tables (capable of caching real-time business data), the business information auxiliary service system can subscribe to the above data streams to ensure that it can receive and promptly process real-time business data from the data source. By setting up scheduled monitoring, after detecting new real-time business data, the data can be pulled out from the target message queue in a timely manner and synchronized to the corresponding business table of the business database to avoid data accumulation and delays. It should be noted that when performing synchronization operations, data consistency and transaction atomicity are also required to avoid data conflicts and anomalies.

[0064] In addition, since there may be data loss or data anomalies due to network anomalies during the real-time data synchronization process, the above-mentioned financial applications can also be synchronized as a backup, that is, all new business data of the day is extracted from the data source of the financial application during a preset time period (such as 24:00 every day), and then synchronized to the business database through batch operations to ensure the final consistency of the data. After synchronizing the incremental data, the data in the business database can also be checked for integrity to ensure that all new data from the data source has been correctly synchronized without omissions or errors. This embodiment can quickly capture and cache real-time business data in the data source through real-time data monitoring and message queue caching, ensure real-time update of data in the business database, improve data accuracy and timeliness, and at the same time avoid data redundancy and repeated synchronization through incremental data synchronization and data synchronization backup mechanism, avoid data inconsistency problems caused by various abnormal situations, and further optimize resource usage.

[0065] In order to ensure the security of data, optionally, in the query method for business data provided in the embodiment of the present application, performing access control detection on the channel side includes: obtaining a channel control table, wherein the channel control table includes the channel side information of multiple channel sides and the correlation relationship between the permission information; identifying the target channel side information of the channel side, and extracting the target permission information from the channel control table according to the target channel side information; when the target permission information indicates that the channel side is allowed to perform business access, determining that the channel side has passed the access control detection, and performing the steps of performing legality and compliance detection on the business query request; when the target permission information indicates that the channel side is not allowed to perform business access, generating a first prompt information, wherein the first prompt information is used to indicate that business access is not allowed.

[0066] Specifically, the channel control table refers to a list in the business information auxiliary service system used to manage channel-side access rights. The table includes channel-side information of multiple channel sides, such as channel name, channel type, channel status, etc., as well as permission information associated with it, such as access rights, query frequency limits, etc. In order to ensure the security of business data, access control detection is required on the channel side before business access is performed on the channel side. That is, when the channel side initiates a business query request, it is first necessary to identify the specific channel-side information of the requester, including identifiers such as the channel name. Then, the target channel-side information is accurately identified through message parsing, identity authentication, and other methods.

[0067] Furthermore, based on the identified target channel side information, the corresponding permission information is extracted from the channel control table to determine whether the channel side has the permission to access specific business data. Then, based on the extracted target permission information, it is verified whether the channel side is authorized to access the business. If the target permission information indicates that business access is allowed, the subsequent business query request legitimacy and compliance detection can be continued; on the contrary, if the target permission information indicates that the channel side is not allowed to access the business, the first prompt information that informs the channel side that its access request is not allowed can be generated, so as to ensure that unauthorized access requests can be responded to in a timely and accurate manner and strengthen the security protection of the system.

[0068] It should be noted that the access control on the channel side can be flexibly configured and dynamically adjusted, such as real-time update of permission information, dynamic adjustment of query frequency limit, etc., to adapt to the ever-changing business environment and security requirements. This embodiment can effectively prevent unauthorized channel-side access through access permission verification based on the channel control table, avoid business risks and compliance issues caused by improper permission management, ensure the security of business data and the overall security of the system, and control the access permissions on the channel side at the same time, avoid excessive consumption of system resources by unauthorized high-frequency access, reduce system performance issues caused by resource competition, and achieve effective resource utilization and cost control.

[0069] In order to reduce redundant legality and compliance checks and improve response efficiency, optionally, in the query method for business data provided in the embodiment of the present application, the legality and compliance detection of the business query request includes: extracting the message field from the business query request and obtaining the preset field rule; when the message field conforms to the preset field rule, extracting the business address from the business query request, and when the message field does not conform to the preset field rule, generating a second prompt information, wherein the second prompt information is used to indicate a business access error; obtaining a preset area, and when the business address is within the preset area, determining whether the client number of the client is in a preset list, and when the business address is outside the preset area, generating a second prompt information, wherein the second prompt information is used to indicate a business access error; when the client number of the client is not in the preset list, determining that the business query request passes the legality and compliance detection; when the client number of the client is in the preset list, generating a second prompt information, wherein the second prompt information is used to indicate a business access error.

[0070] It should be noted that after performing access control detection on the channel side and allowing access to the channel side, the sent business query requests can be detected to ensure that all requests comply with the preset business rules and security policies. Since the business query request corresponds to a query operation, which does not involve modifying data, the risk is more controllable than modifying data. Therefore, only field rule verification, business address check, and preset list check can be performed on the business query data, thereby improving transaction response efficiency.

[0071] Specifically, after receiving the service query request message, the message can be parsed to extract key message fields, such as business type, customer number, business address, etc. After obtaining the preset field rules, the extracted message fields are compared with the preset field rules to check whether the fields meet the prescribed format and constraints, for example, field type matching, field length checking, field non-empty verification, etc. are performed to ensure the accuracy of key information in the service query request. If the message field does not meet the preset field rules, a second prompt message indicating that there is an error in the service query request can be generated.

[0072] Further, after the text segment meets the preset field rules, the business address can be extracted from the business query request, and then the address can be matched with the preset area to confirm the validity of the business address, wherein the preset area is used to limit business access in a specific area. When the business address is not in the preset area, a second prompt message indicating that there is an error in the business query request can be generated; when the business address is in the preset area, the client number of the client can be detected to achieve refined control of the access request. When the client number of the client is in the preset list, it indicates that there is an abnormality in the client, and the business access error can be indicated by the second prompt message; if the client number is not in the preset list, it indicates that the legality and compliance detection has been passed, and the business query request can continue. This embodiment can reduce redundant checks, effectively identify and prevent non-compliant business access, ensure the security of business data and the compliance of business operations, accelerate the response speed of business query requests, and improve the user experience of the channel side and the client. By performing strict field and business address verification at the early stage of access control, it can detect and prevent erroneous requests in advance, reduce the cost of subsequent error processing and the ineffective consumption of system resources.

[0073] In order to reduce data calls across applications, optionally, in the query method for business data provided in an embodiment of the present application, the query service of the business information auxiliary service system is determined in the following manner: obtain the component service of each financial application to obtain M groups of component services; link merge the M groups of component services to obtain merged component services, and determine the merged component services as the query service of the business information auxiliary service system.

[0074] Specifically, after detecting the channel side and business query requests, in order to improve the business processing efficiency, each financial application can be deeply analyzed to identify multiple groups of component services. For example, component services may include financial asset query of the financial management system, personal debt asset query of the personal loan system, and fund asset query under the name of the customer of the fund system.

[0075] Then analyze the call link of each component service, for example, determine the called service node, the called business logic, etc., to understand the dependencies and data flows between services. Then, based on the results of the service link analysis required by the channel side, determine the link merging strategy, where the strategy can include merging or refactoring the calls to component services to reduce the number of remote calls across applications and improve the efficiency of data access. The above strategy can be used to further merge component services to build a unified service call link and form a merged component service, where the link merging operation can include refactoring the service code, unifying the service interface, optimizing the data processing logic, etc., to ensure that the merged service can meet various business query requests.

[0076] Furthermore, the communication mechanism between services can be optimized, and remote calls can be converted into local calls to improve the speed and stability of service calls. Finally, the merged component service is determined as the query service of the business information auxiliary service system and deployed. This embodiment can reduce the number of remote calls across applications, reduce network latency, improve the response speed of query services, reduce unnecessary service instances and communication resource consumption, and improve resource utilization and optimize the overall performance of the system by merging component services.

[0077] This application also provides a business information auxiliary service system, Figure 3 is a schematic diagram of a business information auxiliary service system provided according to an embodiment of the present application Figure 1 , Figure 4 is a schematic diagram of a business information auxiliary service system provided according to an embodiment of the present application Figure 2 ,like Figure 3 , Figure 4 As shown, the business information auxiliary service system is connected to the channel side and the server respectively. The system includes a channel access module, an interactive control module, a business processing module, and a data module. Among them, the channel access module includes multiple channel sides, such as personal online banking, mobile banking and institutional outlets on the mobile terminal; the business processing module includes multiple financial businesses, such as financial management business, financial management business and personal loan business; the data module includes multiple business tables, such as financial management table, fund table, personal loan table and channel control table, etc.; the interactive control module includes bank internal management services.

[0078] If the channel side needs to perform business access, after receiving the business query request sent by the client on the channel side, the channel access module can authenticate the accessed channel side and verify its identity and authority. At the same time, the interactive control module performs parameter legality and compliance checks on the received business query request. For example, it verifies whether the parameters contained in the request are complete, the format is correct, and whether they comply with predefined field rules; checks the business address in the request; checks whether the client number is within the preset area, etc., to ensure the accuracy and security of the data, thereby improving the security, reliability and efficiency of access.

[0079] Figure 5 is a schematic diagram of an operation method of a business processing module provided in an embodiment of the present application, such as Figure 5 As shown, the business processing module receives the business query request detected by the public inspection module composed of the channel access module and the interactive control module, and calls the query service of the business information auxiliary service system to identify the business type of the business query request. When identifying the business type, the business logic in the query service can perform detection in sequence, such as loan business table query, mortgage business table query, etc., to obtain query information, and then filter out the target business data corresponding to the business query request from the business database according to the query information.

[0080] It should be noted that before performing business processing, the business processing module can analyze the call link of each component service, such as determining the service node called, the business logic called, etc., to understand the dependencies and data flows between services. Then, based on the results of the service link analysis, the component services are linked together to build a unified service call link and form a merged component service. The business data in the business database is obtained by the data module through data synchronization of multiple financial applications.

[0081] Figure 6 is a schematic diagram of an operation method of a data module provided in an embodiment of the present application, such as Figure 6 As shown, the data module obtains the data source used to store business data in financial applications, and extracts multiple business tables and the business data therein, converts the format of each group of business data through a general file transfer method (that is, preset format rules), and forms the converted business data into a first storage file, which is synchronized to the business database of the business information auxiliary service system.

[0082] When a financial application is an already connected application, in order to synchronize the newly added business data to the business database in a timely manner, the KAFKA method can be used to extract real-time business data from the database of the financial application, and then cache the data in the target message queue. Since the target message queue contains multiple data streams (i.e. topics) representing business cache tables (capable of caching real-time business data), the business information auxiliary service system can subscribe to the above data streams to ensure that it can receive and process real-time business data from the data source in a timely manner. Then, by setting up scheduled monitoring, after detecting that there is newly added real-time business data in the target message queue, the data is pulled out from the target message queue in a timely manner and synchronized to the corresponding business table of the business database to avoid data accumulation and delays.

[0083] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0084] Example 2

[0085] The embodiment of the present application also provides a device for querying business data. It should be noted that the device for querying business data in the embodiment of the present application can be used to execute the method for querying business data provided in the embodiment of the present application. The following introduces the device for querying business data provided in the embodiment of the present application.

[0086] According to an embodiment of the present application, a device for implementing the above-mentioned business data query method is also provided. Figure 7 is a schematic diagram of a device for querying business data provided in an embodiment of the present application, such as Figure 7 As shown, the device includes: a first acquisition unit 70, a synchronization unit 71, a receiving unit 72, a calling unit 73, and a screening unit 74.

[0087] A first acquisition unit 70 is used to acquire business data of M financial applications, where M is a positive integer;

[0088] A synchronization unit 71, configured to synchronize the business data of the M financial applications to a business database of the business information auxiliary service system;

[0089] The receiving unit 72 is used to receive a business query request sent by a client on the channel side, perform access control detection on the channel side, and perform legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold;

[0090] The calling unit 73 is used to call the query service of the business information auxiliary service system to identify the business type of the business query request and obtain query information when the channel side passes the access control detection and the business query request passes the legality and compliance detection;

[0091] The screening unit 74 is used to screen out target business data corresponding to the business query request from the business database according to the query information, and send the target business data to the client to respond to the business query request.

[0092] The business data query device provided in the embodiment of the present application obtains the business data of M financial applications through the first acquisition unit 70, where M is a positive integer; the synchronization unit 71 synchronizes the business data of the M financial applications to the business database of the business information auxiliary service system; the receiving unit 72 receives the business query request sent by the client on the channel side, performs access control detection on the channel side, and performs legality and compliance detection on the business query request, where the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; the calling unit 73 calls the query service of the business information auxiliary service system to perform legality and compliance detection on the business query request when the channel side passes the access control detection and the business query request passes the legality and compliance detection. The business type is identified and query information is obtained; the screening unit 74 screens out the target business data corresponding to the business query request from the business database according to the query information, and sends the target business data to the client to respond to the business query request, thereby solving the problem of low query efficiency when querying business data in the financial field in the related technology. By synchronizing the business data of multiple financial applications to the business database, after receiving the business query request and detecting the channel side and the request that sent the request, the query service is called to identify the request, thereby determining the target business data according to the identified query information, thereby achieving the technical effect of reducing cross-application query business data, improving the query efficiency of business data, and realizing real-time update of business data and data consistency.

[0093] Optionally, in the query device for business data provided in the embodiment of the present application, the synchronization unit 71 includes: an evaluation module, used to perform application evaluation on each financial application to obtain M evaluation results, wherein each evaluation result is used to indicate whether to perform data synchronization on business data associated with a financial application; a first determination module, used to determine, for a financial application, a data source for storing business data in the financial application when the evaluation result of the financial application indicates that data synchronization is performed on the business data associated with the financial application, wherein the data source includes a main application database and a backup application database or a main application database and three backup application databases; a synchronization module, used to synchronize the business data in the data source to the business database, wherein the data synchronization method includes at least one of the following: existing data synchronization, real-time data synchronization, and data synchronization backup.

[0094] Optionally, in the query device for business data provided in the embodiment of the present application, the synchronization unit 71 includes: a first acquisition module, used to acquire N business tables associated with the data source, and extract the business data of each business table to obtain N groups of business data, where N is a positive integer; a second acquisition module, used to acquire preset format rules, and use the preset format rules to convert the format of each group of business data to obtain N groups of converted business data; a composition module, used to construct a first-stored file from the N groups of converted business data, and synchronize the first-stored file to the business database.

[0095] Optionally, in the query device for business data provided in the embodiment of the present application, the device also includes: a second acquisition unit, which is used to acquire Y real-time business data newly added in the data source before synchronizing the business data in the data source to the business database when the data synchronization mode is real-time data synchronization, while monitoring the data source for new data, wherein the Y real-time business data are distributed in N business tables associated with the data source, and Y is a positive integer; a cache unit, which is used to cache the Y real-time business data to a target message queue, wherein the target message queue includes N data streams corresponding to the N business tables, and each data stream corresponds to a business cache table; the synchronization unit 71 includes: a subscription module, which is used to subscribe to the N data streams and perform regular monitoring on the N data streams; a first extraction module, which is used to extract the Y real-time business data from the target message queue when there are Y real-time business data in the business cache table associated with the N data streams, and update the Y real-time business data to the business database; the synchronization unit 71 includes: a second extraction module, which is used to extract K business data newly added by the data source within a preset time period, and synchronize the K business data to the business database, wherein K is greater than or equal to Y, and K is a positive integer.

[0096] Optionally, in the query device for business data provided in the embodiment of the present application, the receiving unit 72 includes: a third acquisition module, used to acquire a channel control table, wherein the channel control table includes the channel side information of multiple channel sides and the correlation relationship between the permission information; an identification module, used to identify the target channel side information of the channel side, and extract the target permission information from the channel control table according to the target channel side information; a second determination module, used to determine that the channel side passes the access control detection when the target permission information indicates that the channel side is allowed to perform business access, and execute the steps of performing legality and compliance detection on the business query request; a first generation module, used to generate a first prompt information when the target permission information indicates that the channel side is not allowed to perform business access, wherein the first prompt information is used to indicate that business access is not allowed.

[0097] Optionally, in the query device for business data provided in the embodiment of the present application, the receiving unit 72 includes: a third extraction module, used to extract a message field from the business query request and obtain a preset field rule; a fourth extraction module, used to extract a business address from the business query request when the message field conforms to the preset field rule, and generate a second prompt information when the message field does not conform to the preset field rule, wherein the second prompt information is used to indicate that a business access error has occurred; a fourth acquisition module, used to obtain a preset area, and when the business address is within the preset area, determine whether the client number of the client is in a preset list, and when the business address is outside the preset area, generate a second prompt information, wherein the second prompt information is used to indicate that a business access error has occurred; a third determination module, used to determine that the business query request has passed the legality and compliance detection when the client number of the client is not in the preset list; and a second generation module, used to generate a second prompt information when the client number of the client is in the preset list, wherein the second prompt information is used to indicate that a business access error has occurred.

[0098] Optionally, in the query device for business data provided in an embodiment of the present application, the calling unit 73 includes: a fifth acquisition module, used to acquire the component service of each financial application to obtain M groups of component services; a merging module, used to link merge the M groups of component services to obtain merged component services, and determine the merged component services as the query service of the business information auxiliary service system.

[0099] It should be noted that the above-mentioned first acquisition unit 70, synchronization unit 71, receiving unit 72, calling unit 73, and screening unit 74 correspond to steps S201 to S205 in Embodiment 1, and the two modules and the corresponding steps implement the same examples and application scenarios, but are not limited to the contents disclosed in the above-mentioned Embodiment 1. It should be noted that the above-mentioned modules or units may be hardware components or software components stored in a memory (e.g., memory 104) and processed by one or more processors (e.g., processors 102a, 102b, ..., 102n), and the above-mentioned units may also be part of the device and may be run in the computer terminal 10 provided in Embodiment 1.

[0100] Example 3

[0101] The embodiment of the present application may provide a computer terminal, which may be any computer terminal device in a computer terminal group. Optionally, in this embodiment, the computer terminal may also be replaced by a terminal device such as a mobile terminal or an electronic device.

[0102] Optionally, in this embodiment, the computer terminal may be located in at least one network device among a plurality of network devices of the computer network.

[0103] In this embodiment, the above-mentioned computer terminal can execute the program code of the following steps in the business data query method: obtain business data of M financial applications, where M is a positive integer; synchronize the business data of the M financial applications to the business database of the business information auxiliary service system; receive a business query request sent by a client on the channel side, perform access control detection on the channel side, and perform legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, call the query service of the business information auxiliary service system to identify the business type of the business query request to obtain query information; filter out the target business data corresponding to the business query request from the business database according to the query information, and send the target business data to the client to respond to the business query request.

[0104] Optionally, the computer terminal may execute the program code of the following steps in the business data query method: performing an application evaluation on each financial application to obtain M evaluation results, wherein each evaluation result is used to indicate whether to perform data synchronization on the business data associated with a financial application; for a financial application, when the evaluation result of the financial application indicates that data synchronization is performed on the business data associated with the financial application, determining a data source for storing business data in the financial application, wherein the data source includes a main application database and a backup application database or a main application database and three backup application databases; synchronizing the business data in the data source to the business database, wherein the data synchronization method includes at least one of the following: existing data synchronization, real-time data synchronization, and data synchronization backup.

[0105] Optionally, the above-mentioned computer terminal can execute the program code of the following steps in the business data query method: obtain N business tables associated with the data source, and extract the business data of each business table to obtain N groups of business data, where N is a positive integer; obtain preset format rules, and use the preset format rules to convert the format of each group of business data to obtain N groups of converted business data; the N groups of converted business data constitute a first storage file, and synchronize the first storage file to the business database.

[0106] Optionally, the above-mentioned computer terminal can execute the program code of the following steps in the business data query method: when monitoring the data source for new data, obtain Y real-time business data newly added in the data source, wherein the Y real-time business data are distributed in N business tables associated with the data source, and Y is a positive integer; cache the Y real-time business data to the target message queue, wherein the target message queue includes N data streams corresponding to the N business tables, and each data stream corresponds to a business cache table; synchronize the business data in the data source to the business database includes: subscribe to N data streams and perform regular monitoring on the N data streams; when there are Y real-time business data in the business cache table associated with the N data streams, extract Y real-time business data from the target message queue, and update the Y real-time business data to the business database; when the data synchronization mode is data synchronization guarantee, synchronize the business data in the data source to the business database includes: extract K business data newly added by the data source within a preset time period, and synchronize the K business data to the business database, wherein K is greater than or equal to Y, and K is a positive integer.

[0107] Optionally, the above-mentioned computer terminal can execute the program code of the following steps in the business data query method: obtaining a channel control table, wherein the channel control table includes the channel side information of multiple channel sides and the correlation relationship between the permission information; identifying the target channel side information of the channel side, and extracting the target permission information from the channel control table according to the target channel side information; when the target permission information indicates that the channel side is allowed to perform business access, determining that the channel side passes the access control detection, and performing the steps of performing legality and compliance detection on the business query request; when the target permission information indicates that the channel side is not allowed to perform business access, generating a first prompt information, wherein the first prompt information is used to indicate that business access is not allowed.

[0108] Optionally, the computer terminal may execute the following steps of the business data query method: extracting a message field from a business query request and obtaining a preset field rule; extracting a business address from the business query request when the message field complies with the preset field rule, and generating a second prompt message when the message field does not comply with the preset field rule, wherein the second prompt message is used to indicate a business access error; obtaining a preset area, and determining whether the client number of the client is in a preset list when the business address is in the preset area, and generating a second prompt message when the business address is outside the preset area, wherein the second prompt message is used to indicate a business access error; determining that the business query request passes the legality and compliance check when the client number of the client is not in the preset list; and generating a second prompt message when the client number of the client is in the preset list, wherein the second prompt message is used to indicate a business access error.

[0109] Optionally, the above-mentioned computer terminal can execute the program code of the following steps in the business data query method: obtain the component service of each financial application to obtain M groups of component services; link merge the M groups of component services to obtain merged component services, and determine the merged component services as the query service of the business information auxiliary service system.

[0110] Optionally, Figure 8 is a structural block diagram of an electronic device according to an embodiment of the present application. Figure 8 As shown, the electronic device may include: one or more ( Figure 8 (only one is shown) processor 802, memory 804, storage controller, and peripheral interface, wherein the peripheral interface is connected to the radio frequency module, audio module and display.

[0111] Among them, the memory can be used to store software programs and modules, such as the program instructions / modules corresponding to the query method and device for business data in the embodiment of the present application. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory, that is, realizing the query method for the above-mentioned business data. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the terminal via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0112] The processor can call the information and application programs stored in the memory through the transmission device to execute the above steps in the above business data query method.

[0113] By adopting the embodiment of the present application, a solution for querying business data is provided. By acquiring the business data of M financial applications, where M is a positive integer; synchronizing the business data of M financial applications to the business database of the business information auxiliary service system; receiving a business query request sent by a client on the channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, calling the query service of the business information auxiliary service system to identify the business type of the business query request to obtain query information; according to the query information, filtering out the target business data corresponding to the business query request from the business database, and sending the target business data to the client to respond to the business query request, thereby achieving the purpose of improving the efficiency and accuracy of financial business data query, reducing the equipment resource pressure and resource consumption brought to each application system during high-frequency query, and thus solving the problem of low query efficiency when querying business data in the financial field.

[0114] It can be understood by those skilled in the art that Figure 8 The structure shown is for illustration only, and the electronic device may also be a smart phone, a tablet computer, a PDA, a mobile Internet device (MID), a PAD or other terminal device. Figure 8 The structure of the electronic device is not limited. Figure 8 More or fewer components (such as network interfaces, display devices, etc.) shown in, or having Figure 8 Different configurations shown.

[0115] A person of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing the hardware related to the terminal device through a program, and the program can be stored in a computer-readable storage medium, and the storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.

[0116] Example 4

[0117] The embodiment of the present application further provides a storage medium. Optionally, in this embodiment, the storage medium can be used to store the program code executed by the query method for business data provided in the first embodiment.

[0118] Optionally, in this embodiment, the above storage medium may be located in any computer terminal in a computer terminal group in a computer network, or in any mobile terminal in a mobile terminal group.

[0119] Optionally, in this embodiment, the storage medium is configured to store program code for executing the following steps: obtaining business data of M financial applications, where M is a positive integer; synchronizing the business data of the M financial applications to a business database of a business information auxiliary service system; receiving a business query request sent by a client on a channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request, wherein a business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; when the channel side passes the access control detection and the business query request passes the legality and compliance detection, calling the query service of the business information auxiliary service system to identify the business type of the business query request to obtain query information; filtering out target business data corresponding to the business query request from the business database according to the query information, and sending the target business data to the client in response to the business query request.

[0120] The present application also provides a computer program product, which, when executed on a data processing device, is suitable for executing the program steps of the query method for business data.

[0121] The serial numbers of the above-mentioned embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments.

[0122] In the above embodiments of the present application, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, please refer to the relevant description of other embodiments.

[0123] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0124] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0125] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0126] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or all or part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of each embodiment method of the present application. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, disk or optical disk, etc. Various media that can store program codes.

[0127] The above are only preferred implementations of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A method for querying business data, characterized in that: include: Obtain business data of M financial applications, where M is a positive integer; Synchronizing the business data of the M financial applications to the business database of the business information auxiliary service system; Receiving a business query request sent by a client on the channel side, performing access control detection on the channel side, and performing legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; In the case where the channel side passes the access control detection and the business query request passes the legality and compliance detection, calling the query service of the business information auxiliary service system to identify the business type of the business query request to obtain query information; Target business data corresponding to the business query request is screened out from the business database according to the query information, and the target business data is sent to the client to respond to the business query request.

2. The method according to claim 1, characterized in that Synchronizing the business data of the M financial applications to the business database of the business information auxiliary service system includes: Perform application evaluation on each financial application to obtain M evaluation results, wherein each evaluation result is used to indicate whether to perform data synchronization on business data associated with a financial application; For a financial application, when the evaluation result of the financial application indicates that data synchronization is performed on business data associated with the financial application, determining a data source for storing business data in the financial application, wherein the data source includes a primary application database and a backup application database or a primary application database and three backup application databases; The business data in the data source is synchronized to the business database, wherein the data synchronization method includes at least one of the following: existing data synchronization, real-time data synchronization and data synchronization backup.

3. The method according to claim 2, characterized in that When the data synchronization mode is the stock data synchronization, synchronizing the business data in the data source to the business database includes: Obtain N business tables associated with the data source, and extract business data from each business table to obtain N groups of business data, where N is a positive integer; Obtaining a preset format rule, and performing format conversion on each set of business data using the preset format rule to obtain N sets of converted business data; The N groups of converted business data form a first stored file, and the first stored file is synchronized to the business database.

4. The method according to claim 2, characterized in that: When the data synchronization mode is the real-time data synchronization, before synchronizing the business data in the data source to the business database, the method further includes: In the case of monitoring the newly added data on the data source, obtaining Y newly added real-time business data in the data source, wherein the Y real-time business data are distributed in N business tables associated with the data source, and Y is a positive integer; Cache the Y real-time business data into a target message queue, wherein the target message queue includes N data streams corresponding to the N business tables, and each data stream corresponds to a business cache table; Synchronizing the business data in the data source to the business database includes: Subscribing to the N data streams and performing regular monitoring on the N data streams; In the case where the Y real-time service data exist in the service cache table associated with the N data flows, extracting the Y real-time service data from the target message queue, and updating the Y real-time service data into the service database; When the data synchronization mode is the data synchronization backup mode, synchronizing the business data in the data source to the business database includes: Extract K business data newly added by the data source within a preset time period, and synchronize the K business data to the business database, where K is greater than or equal to Y and K is a positive integer.

5. The method according to claim 1, characterized in that The access control detection on the channel side includes: Acquire a channel control table, wherein the channel control table includes associations between channel side information and permission information of multiple channel sides; Identifying target channel side information of the channel side, and extracting target authority information from the channel control table according to the target channel side information; In the case where the target permission information indicates that the channel side is allowed to perform business access, determining that the channel side passes the access control detection, and performing the step of performing the legality and compliance detection on the business query request; In the case where the target authority information indicates that the channel side is not allowed to perform business access, first prompt information is generated, wherein the first prompt information is used to indicate that the business access is not allowed.

6. The method according to claim 1, characterized in that The legality and compliance detection of the business query request includes: Extracting message fields from the service query request and obtaining preset field rules; If the message field conforms to the preset field rule, extracting the service address from the service query request, and if the message field does not conform to the preset field rule, generating second prompt information, wherein the second prompt information is used to indicate that the service access is wrong; Acquire a preset area, and if the service address is within the preset area, determine whether the client number of the client is within a preset list, and if the service address is outside the preset area, generate the second prompt information, wherein the second prompt information is used to indicate that a service access error occurs; In the case where the client number of the client is not in the preset list, determining that the service query request passes the legality and compliance detection; In a case where the client number of the client is in the preset list, the second prompt information is generated, wherein the second prompt information is used to indicate a service access error.

7. The method according to claim 1, characterized in that The query service of the business information auxiliary service system is determined in the following manner: Get the component service of each financial application to obtain M groups of component services; The M groups of component services are linked together to obtain a merged component service, and the merged component service is determined as a query service of the business information auxiliary service system.

8. A device for querying business data, characterized in that: include: A first acquisition unit is used to acquire business data of M financial applications, where M is a positive integer; A synchronization unit, used to synchronize the business data of the M financial applications to a business database of the business information auxiliary service system; A receiving unit, configured to receive a business query request sent by a client on a channel side, perform access control detection on the channel side, and perform legality and compliance detection on the business query request, wherein the business query request refers to a transaction business query request with a query frequency greater than a preset frequency threshold; A calling unit, configured to call the query service of the business information auxiliary service system to identify the business type of the business query request and obtain query information when the channel side passes the access control detection and the business query request passes the legality and compliance detection; A screening unit is used to screen out target business data corresponding to the business query request from the business database according to the query information, and send the target business data to the client to respond to the business query request.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored executable program, wherein when the executable program is run, the device where the computer-readable storage medium is located is controlled to execute the business data query method according to any one of claims 1 to 7.

10. An electronic device, characterized in that: include: A memory storing an executable program; A processor is used to run the program, wherein the program, when running, executes the business data query method described in any one of claims 1 to 7.

11. A computer program product comprising computer instructions, characterized in that: When the computer instructions are executed by a processor, the steps of the business data query method described in any one of claims 1 to 7 are implemented.

Citation Information

Cited By

  • Financial data processing system and method

    CN120873061A

  • Data query method and device, equipment and storage medium

    CN121117062A