Comprehensive query method and system

Abstract

The present invention discloses a comprehensive query method and system, which relate to the field of computer technology, wherein the method comprises: obtaining an event query set; collecting data for each event in the event query set to generate each event data set; performing data preprocessing on each event data set to obtain a processed standard data set; calling a data query service interface to perform a comprehensive query on the processed standard data set.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a comprehensive query method and system. Background Art

[0002] An account is an account opened by a customer, such as a deposit account, loan account, or current account opened at a bank. A contract is a contract that a customer must sign before using a product to constrain how the product is used, such as the start time and end time of use, the contract name, the charging method, and so on. This contract information can uniquely identify the specific circumstances of a customer's use of a product. Currently, customers sign contracts for a variety of products, and the contract information for different products and the relationship between contracts and accounts are all stored in decentralized systems. Customers cannot obtain an overview of the relationship between their accounts and contracts. If they need to terminate a contract, they need to go to each product menu to perform contract maintenance. Researching and designing a data management method that optimizes the relationship between accounts and contracts is of great practical significance.

[0003] The existing technology has the technical problem of lack of unified management for data consistency issues between account and contract relationships, and inability to perform unified view query and subsequent processing. Summary of the Invention

[0004] The embodiments of the present application provide a comprehensive query method and system, which solves the technical problems in the prior art of lacking unified management of data consistency issues regarding account and contract relationships, and being unable to perform unified view query and subsequent processing.

[0005] In view of the above problems, an embodiment of the present application provides a comprehensive query method and system.

[0006] On the one hand, an embodiment of the present application provides a comprehensive query method, wherein the method is applied to a comprehensive query system, and the method includes: obtaining an event query set; collecting data for each event in the event query set to generate each event data set; performing data preprocessing on each event data set to obtain a processed standard data set; calling a data query service interface to perform a comprehensive query on the processed standard data set.

[0007] On the other hand, the present application also provides a comprehensive query system, wherein the system includes: a first acquisition unit, the first acquisition unit is used to obtain an event query set; a first generation unit, the first generation unit is used to collect data for each event in the event query set to generate each event data set; a second acquisition unit, the second acquisition unit is used to perform data preprocessing on each event data set to obtain a processed standard data set; a first execution unit, the first execution unit is used to call a data query service interface to perform a comprehensive query on the processed standard data set.

[0008] In a third aspect, an embodiment of the present application provides a comprehensive query device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any one of the methods described in the first aspect when executing the program.

[0009] One or more technical solutions provided in the embodiments of this application have at least the following technical effects or advantages:

[0010] Obtain an event query set; collect data for each event in the event query set to generate each event data set; perform data preprocessing on each event data set to obtain a processed standard data set; call the data query service interface to conduct a comprehensive query on the processed standard data set. By realizing a one-time synchronous query and cancellation of the account and contract relationship, it also supports one-click payment of overdue contracts under the account name. It has achieved the technical effect of significantly reducing the pressure on the counter, reducing the risk of erroneous operations, reducing customer waiting time, improving user experience and efficiency, promoting high-quality customer development, and improving customer service impression and service satisfaction; meeting anti-money laundering regulatory requirements, once a high-risk customer group appears, all products can be quickly terminated, reducing the financial risks of the entire bank.

[0011] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are merely exemplary. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without any creative work.

[0013] Figure 1 A flowchart of a comprehensive query method according to an embodiment of the present application is shown;

[0014] Figure 2 This is a flow chart of a method described in a comprehensive query method according to an embodiment of the present application applied to a comprehensive query module for account and contract relationships;

[0015] Figure 3 This is a diagram of the architecture of a comprehensive query module in a comprehensive query method according to an embodiment of the present application;

[0016] Figure 4A schematic diagram of a process for performing one-click cancellation of the contract in the contract data set for each product in a comprehensive query method according to an embodiment of the present application;

[0017] Figure 5 This is a schematic diagram of a big data cloud data service solution in a comprehensive query method according to an embodiment of the present application;

[0018] Figure 6 This is a schematic diagram of the structure of a comprehensive query system according to an embodiment of the present application;

[0019] Figure 7 This is a schematic diagram of the structure of an exemplary electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0020] The embodiment of the present application solves the technical problems in the prior art of the lack of unified management of data consistency issues between account and contract relationships, and the inability to conduct unified view queries and subsequent processing by providing a comprehensive query method and system. By realizing a one-time synchronous query and cancellation of account and contract relationships, it also supports one-click payment of overdue contracts under the account name. It achieves the technical effect of significantly reducing counter pressure, reducing the risk of erroneous operations, reducing customer waiting time, improving user experience and efficiency, promoting high-quality customer development, and improving customer service impression and service satisfaction; it meets anti-money laundering regulatory requirements, and once a high-risk customer group appears, all products can be quickly terminated, reducing the financial risks of the entire bank.

[0021] Below, the exemplary embodiments of the present application will be described in detail with reference to the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments of the present application, and it should be understood that the present application is not limited to the exemplary embodiments described herein.

[0022] Due to the lack of unified management of data consistency issues regarding account and contract relationships in the existing technology, it is impossible to perform unified view query and subsequent processing. This application proposes a comprehensive query method that can aggregate the data of each product component into a data integration calculation area for data cleaning and data normalization. This allows data to be pushed in a unified manner, avoiding data inconsistencies caused by interface call synchronization data failures, forming a unified comprehensive query portal, and forming a unified query view based on account and contract relationships, thereby achieving one-time synchronous query and cancellation of account and contract relationships.

[0023] In response to the above technical problems, the overall idea of ​​the technical solution provided by this application is as follows:

[0024] An embodiment of the present application provides a comprehensive query method, wherein the method is applied to a comprehensive query system, and the method includes: obtaining an event query set; collecting data for each event in the event query set to generate each event data set; performing data preprocessing on each event data set to obtain a processed standard data set; calling a data query service interface to perform a comprehensive query on the processed standard data set.

[0025] In order to better understand the above technical solution, the above technical solution will be described in detail below with reference to the accompanying drawings and specific implementation methods.

[0026] Example 1

[0027] Please see the attached Figure 1 The embodiment of the present application provides a comprehensive query method, wherein the method is applied to a comprehensive query system, and the method specifically includes the following steps:

[0028] Step S100: obtaining an event query set;

[0029] Step S200: collecting data for each event in the event query set to generate a data set for each event;

[0030] Specifically, the event query set consists of customers who need to query their accounts and contract relationships. By collecting data for each event in the event query set, individual event data sets can be obtained. Each event data set consists of information about different product contracts and contract-account relationships signed by the customers who are querying their accounts and contract relationships. This provides data support for subsequent data preprocessing of each event data set.

[0031] Step S300: performing data preprocessing on each event data set to obtain a processed standard data set;

[0032] Step S400: calling a data query service interface to perform a comprehensive query on the processed standard data set.

[0033] Specifically, data preprocessing refers to data cleaning and formatting. By preprocessing each event data set, a processed, standardized data set can be obtained. This processed, standardized data set is a data set that has been re-examined, verified, and cleaned of inconsistencies. Furthermore, a comprehensive query can be performed on this processed, standardized data set by calling a data query service interface (a big data query service interface). This achieves the technical effect of enabling one-time, simultaneous querying of account and contract relationships, improving user experience and efficiency, and reducing customer wait time.

[0034] Further, as attached Figure 2 As shown, step S400 in this embodiment of the application further includes:

[0035] Step S410: Obtaining a product and service set of a target bank according to the event query set;

[0036] Step S420: Based on the product service component, data collection is performed on the contract information of each product in the product service set to generate a contract data set for each product;

[0037] Specifically, the target bank's product and service set refers to a collection of any bank's deposit services, loan services, wealth management products, and other product services. The product and service components represent data sources, meaning that the contract information for each product in the system originates from each product and service component, including contract and account relationship information, product arrears information, and so on. Through data collection, a contract data set for each product is generated, laying the foundation for subsequently pushing each product contract data set to the data source area.

[0038] Step S430: Pushing the contract data set of each product to the data source area, wherein the data source area is in communication with the data integration module;

[0039] Step S440: Loading the contract data sets of each product in the data source area into the data calculation area, performing data cleaning and formatting processing to generate a processed contract specification data set of each product, wherein the data calculation area is in communication with the data integration module;

[0040] Specifically, the standard data set of each product contract signing contract refers to the data set obtained by loading the data set of each product contract signing contract in the data source area into the data calculation area, and uniformly cleaning and formatting it. The data source area refers to the source layer in the data warehouse, which aggregates the data sets of each product contract signing contract, and the data stored here is consistent with the data in the data set of each product contract signing contract. The data cleaning refers to the process of re-examining and verifying the data in the data set of each product contract signing contract loaded into the data calculation area, with the purpose of deleting duplicate information, correcting existing errors, and providing data consistency. The formatting process refers to the pre-processing of the disk before use in order to store data. The technical effect of re-examining and verifying the data in the data set of each product contract signing contract, eliminating inconsistencies in the data, ensuring data standardization, and providing data support for the subsequent generation of big data query service interfaces is achieved.

[0041] Step S450: uploading the contract specification data set of each product to the big data cloud module to generate a big data query service interface;

[0042] Step S460: calling the big data query service interface, and the data query user calls and queries the contract data set of each product, wherein the contract data set of each product includes querying the relationship between contracts and accounts and querying the list of overdue payments;

[0043] Specifically, the big data query service interface refers to the query service interface obtained by pushing the contract specification data set of each product to the big data cloud module. It avoids the data inconsistency caused by the failure of interface call synchronization data and the business troubles it brings. Figure 3 As shown, the big data query interface service is released through the big data cloud to meet the big data result query function. The employee channel page can call the customer service component contract information query, contract and account relationship query, arrears list information query and other functions through the interface to complete the unified view of the comprehensive query of contract and account relationship. The customer service page can jump to each product component through one page for multiple products to complete the exemption and re-payment of each arrears information. By realizing the one-time synchronous query and cancellation of the account and contract relationship, it also supports one-click re-payment of arrears contracts under the account name. It has achieved the technical effect of greatly reducing the pressure on the counter, reducing the risk of erroneous operation, reducing customer waiting time, improving user experience and efficiency, promoting high-quality customer development, and improving customer service impression and service satisfaction.

[0044] Step S470: Based on the comprehensive termination module, the termination contracts in the contract data set of each product are terminated with one click.

[0045] Specifically, the comprehensive contract termination module enables one-click termination of all contract and account contract relationships in the account list during comprehensive query. A unified and standardized contract termination process is established to uniformly prepare and review the termination of public product contracts and channel product contracts and account relationships, achieving one-click termination of contract and account relationships asynchronously. This avoids the long processing times and poor user experience associated with having to navigate through each product menu to perform contract maintenance when a customer terminates a contract. Furthermore, it meets anti-money laundering requirements, enabling rapid termination of all product contracts when high-risk customers emerge, thus reducing the bank's overall financial risks.

[0046] Further, as attached Figure 4 As shown, step S470 in this embodiment of the application further includes:

[0047] Step S471: Processing the termination contract to generate a termination contract sequence;

[0048] Step S472: performing final review on each of the individual contract termination contracts in the contract termination sequence, and generating a sequence of contract termination requests to be reviewed;

[0049] Step S473: generating a unique JMS identifier for each contract in the pending contract termination request sequence, wherein the single contract corresponds to the unique JMS identifier in a one-to-one manner;

[0050] Step S474: sorting the unique JMS identifiers according to the number of the pending contract termination request sequences, and generating a JMS message queue;

[0051] Step S475: The contracts in the pending contract termination request sequence are traversed and sent to the JMS message queue for review.

[0052] Specifically, the document preparation process refers to preparing documents for contracts that need to be terminated, and then initiating a review after the document preparation. Each terminated contract after the document preparation constitutes the contract termination sequence. A final judgment is then made on each individual contract termination in the generated contract termination sequence, i.e., determining whether the contract is a contract that needs to be terminated. Based on the judgment result, the pending contract termination request sequence is generated, wherein the pending contract termination request sequence is the sequence of contracts that are finally determined to need to be terminated. A unique JMS identifier is then generated for each individual contract in the pending contract termination request sequence, i.e., each individual contract has a one-to-one correspondence with the unique JMS identifier. JMS, or Java Message Service (Java Message Service) application programming interface, is an API for message-oriented middleware (MOM) in the Java platform. It is used to send messages between two applications or distributed systems for asynchronous communication. Java Message Service is an API independent of a specific platform, which makes distributed communication less coupled and message services more reliable and asynchronous. The unique JMS identifier refers to a mark generated by a single contract in the pending contract termination request sequence to uniquely identify a message. Then, according to the number of the pending contract termination request sequence, the unique JMS identifier is sorted to generate a JMS message queue. The JMS message queue is an area that holds messages that have been sent and are waiting to be read. The queue implies that these messages will be sent in sequence. Once a message is read, the message will be removed from the queue. When the client obtains the message, it does not need to actively send a request, and the message will be automatically sent to the available client. At the same time, it is guaranteed that the message will only be delivered once, avoiding the problem of duplicate message creation. Based on the asynchronous message receiving method of JMS, the contracts in the pending contract termination request sequence can be traversed and sent to the JMS message queue for review until the review of the contracts in the pending contract termination request sequence is completed.

[0053] Furthermore, step S470 in this embodiment of the application further includes:

[0054] Step S476: Based on the asynchronous message receiving mode of the JMS message queue, the pending contract termination request sequence is monitored, and contracts in the pending contract termination request sequence are received according to the monitoring result;

[0055] Step S477: Based on the unified database configuration, asynchronously review the corporate comprehensive contracts in the pending contract termination request sequence, and at the same time, feed back the review results to the pending contract termination request sequence through the JMS message queue.

[0056] Specifically, the asynchronous message reception method of the JMS message queue means that in a distributed heterogeneous environment, communication between applications does not require synchronous execution by both parties. Applications only need to send messages to continue other work. The occurrence of message transmission does not force the application to wait for the transmission to complete. The receiving application does not need to monitor the entire reception process, but simply reads the message from the queue and processes it. This greatly reduces the coupling between programs and provides a secure storage method for information. It is particularly suitable for applications that are not directly connected, such as mobile users, senders, or receivers whose processes may be inactive. Based on this, the contracts in the pending contract termination request sequence can be received based on the monitoring results. Then, using a unified database configuration method, the public comprehensive contracts in the pending contract termination request sequence can be asynchronously audited. At the same time, the audit results are fed back to the pending contract termination request sequence through the JMS message queue. For example, once the review of one of the comprehensive corporate contracts is complete, the review result can be fed back to the pending contract termination request sequence, preventing the submission of that contract until all corporate contracts have been reviewed. This improves data accuracy, consistency, and integrity. Furthermore, the use of a unified database configuration simplifies subsequent maintenance and management, reduces costs, and enables sustainable development of informatization. Message sending and monitoring are implemented through JMS message queues, and customized termination of contracts for different products can be achieved through unified database configuration.

[0057] Step S478: Performing asynchronous review of a single product on the comprehensive corporate contract;

[0058] Step S479: Obtain product coding information corresponding to the single product, perform an outbound call task for the corporate user of the single product, and terminate the corporate comprehensive contract at the same time.

[0059] Specifically, during the asynchronous review of the corporate comprehensive contracts in the pending contract termination request sequence, a single-product asynchronous review can be performed on the corporate comprehensive contracts. This means that each individual contract within the corporate comprehensive contract is asynchronously reviewed one by one. Simultaneously, product code information corresponding to each individual product can be obtained. This product code information refers to the code information obtained by performing the single-product asynchronous review on the corporate comprehensive contract, indicating that the product is a single product. This product code information can then be used to execute an outbound call task for the corporate user of the single product. An outbound call task is a task created by an administrator and assigned to a customer service representative for customer follow-up visits. Customer service representatives can view and execute the task and add follow-up records. For example, if a corporate contract has been reviewed and confirmed to require termination, an outbound call task can be executed for the corresponding corporate user. This outbound call task allows communication with the corporate user until the contract is terminated. The technical effect is achieved by obtaining accurate and reliable public comprehensive contract execution products, and then completing asynchronous one-click termination operations by identifying products and calling transactions, reducing erroneous operations, optimizing the termination process, and improving user experience.

[0060] Furthermore, step S450 in the embodiment of the present application further includes:

[0061] Step S451: uploading the contract specification data set of each product to the data management component and the data service component for management and processing, and generating contract subject information of each product;

[0062] Step S452: compile an API query service interface for the contract subject information of each product;

[0063] Step S453: Authorization management is performed on the API query service interface to generate the big data query service interface.

[0064] Specifically, when uploading the contract specification data sets for each product to the big data cloud module, the data sets can be uploaded to the data management component and the data service component for management and processing. At the same time, the contract subject information for each product can also be obtained. The contract specification data sets for each product refer to the data sets obtained by loading the contract specification data sets for each product from the data source area into the data calculation area and uniformly cleaning and formatting them. The data management component manages data services within the data integration platform. The data service components are self-contained, self-describing, loosely coupled data modules defined in a distributed, heterogeneous data environment. A series of standards support interoperability between them, and new data services can be defined by reusing existing data services. It should also be noted that data services are limited to the platform environment providing the services. However, data services can be provided to applications as web services, thereby solving the data service publishing problem. The contract subject information for each product refers to the contract name of the product contracted by the customer, such as a bank loan agreement, bank loan agreement, or bank wealth management product agreement. Subsequently, API query service interfaces can be written based on the contract subject information for each product. The API refers to the Application Program Interface (API), which is a set of definitions, programs, and protocols that enable mutual communication between computer software. The API query service interface is a calling interface left by the operating system for the query application. The query application makes the system execute the query application's commands by calling the operating system's API. Then, by authorizing and managing the interface, a big data query service interface can be obtained. Figure 5 As shown, the Big Data Cloud publishes a Big Data query interface service to meet the needs of Big Data result query. This achieves the technical effect of forming a unified query view based on account and contract relationships, making it easier for customers to obtain an overview of their account and contract relationships, and facilitating unified data management and maintenance.

[0065] Furthermore, step S460 in this embodiment of the application further includes:

[0066] Step S461: Query the arrears list information and call the fee payment component;

[0067] Step S462: According to the fee supplementary payment component, the overdue payment information of the single product in the overdue payment list is exempted and supplemented.

[0068] Specifically, when querying the arrears list, a fee supplementary payment component can be obtained by querying the arrears list. The fee supplementary payment component refers to the product contract information that requires the user to make supplementary payments, obtained by querying the arrears list information. Through a single page, multiple products jump to each product component to complete the exemption and supplementary payment functions of each arrears information. This achieves the technical effect of supporting account-based product contract arrears information query and arrears payment information, optimizing the counter business processing process, greatly shortening business processing time, and improving user experience.

[0069] In summary, the comprehensive query method provided by the embodiment of the present application has the following technical effects:

[0070] 1. Obtain the target bank's product and service set; based on the product and service component, collect data on the contract information of each product in the product and service set to generate a contract data set for each product; push the contract data set for each product to a data source area, which is communicatively linked to a data integration module; load the contract data set for each product in the data source area to a data calculation area, perform data cleaning and formatting, and generate a processed contract specification data set for each product, wherein the data calculation area is communicatively linked to the data integration module; upload the contract specification data set for each product to a big data cloud module to generate a big data query service interface; invoke the big data query service interface, and a data query user query the contract data set for each product, wherein the contract data set for each product includes querying contract-account relationships and a list of outstanding payments; based on the comprehensive contract cancellation module, perform one-click cancellation of the contract in each contract data set. This enables one-time simultaneous query and cancellation of account and contract relationships, while also supporting one-click repayment of outstanding payments for contracts under an account. It has achieved the goal of significantly reducing counter pressure, lowering the risk of erroneous operations, shortening customer waiting time, improving user experience and efficiency, promoting high-quality customer development, and enhancing customer service impression and service satisfaction; meeting anti-money laundering regulatory requirements, and once high-risk customer groups appear, all products can be quickly terminated, thereby reducing the financial risks of the entire bank.

[0071] 2. A big data query interface service has been released through the Big Data Cloud, enabling the query of big data results. The employee channel page can use this interface to call the customer service component to query contract information, contract and account relationships, and arrears information, providing a unified view of comprehensive contract and account relationship queries. The customer service page can also be used to redirect multiple products to various product components, enabling the waiver and repayment of arrears information.

[0072] 3. The comprehensive contract termination function uses JMS message queues to send and monitor messages. Customized contract termination for different products is achieved through unified database configuration. This solution also effectively supports product scalability. Asynchronous one-click contract termination is completed by identifying the product and invoking the transaction.

[0073] Example 2

[0074] Based on the same inventive concept as the comprehensive query method in the above embodiment, the present invention also provides a comprehensive query system. Figure 6 , the system comprising:

[0075] A first obtaining unit 11, wherein the first obtaining unit 11 is used to obtain an event query set;

[0076] A first generating unit 12, the first generating unit 12 is used to collect data for each event in the event query set and generate a data set for each event;

[0077] A second obtaining unit 13, the second obtaining unit 13 is used to perform data preprocessing on each event data set to obtain a processed standard data set;

[0078] The first execution unit 14 is used to call a data query service interface to perform a comprehensive query on the processed standard data set.

[0079] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. Figure 1 The comprehensive query method and specific examples in Example 1 are also applicable to the comprehensive query system of this embodiment. Through the detailed description of the comprehensive query method above, those skilled in the art can clearly understand the comprehensive query system of this embodiment. Therefore, for the sake of brevity, it will not be described in detail here. As for the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple. For relevant details, please refer to the method description.

[0080] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present application. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application is not limited to the embodiments shown herein, but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.

[0081] Example 3

[0082] Reference below Figure 7 The computer device of the embodiment of the present application is described as follows. The computer device may be an application version management server or a terminal, and its internal structure diagram may be as follows: Figure 7 As shown. The computer device includes a processor, memory, and a network interface connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, it implements a method for processing an application package.

[0083] When the computer device is a terminal, the computer device may further include a display screen and an input device. The display screen of the computer device may be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device may be a touch layer covering the display screen, a key, a trackball, or a touchpad provided on the computer device housing, or an external keyboard, touchpad, or mouse.

[0084] Those skilled in the art will understand that Figure 7 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.

[0085] In one embodiment, a computer device is further provided, including a memory and a processor. The memory stores a computer program, and the processor implements the steps in the above method embodiments when executing the computer program.

[0086] In one embodiment, a computer-readable storage medium is provided, storing a computer program, which implements the steps in the above-mentioned method embodiments when executed by a processor.

[0087] In one embodiment, a computer program product or computer program is provided, the computer program product or computer program including computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the steps of each of the above-described method embodiments.

[0088] The embodiment of the present application provides a comprehensive query method, wherein the method is applied to a comprehensive query system, and the method includes: obtaining an event query set; collecting data for each event in the event query set to generate each event data set; performing data preprocessing on each event data set to obtain a processed standard data set; calling a data query service interface to perform a comprehensive query on the processed standard data set. It solves the technical problem that the existing technology lacks unified management for the data consistency problem of account and contract relationship, and cannot perform unified view query and subsequent processing. By realizing a one-time synchronous query and cancellation of the account and contract relationship, it supports one-click payment of overdue contracts under the account name. It achieves the technical effect of greatly reducing the pressure on the counter, reducing the risk of erroneous operation, reducing customer waiting time, improving user experience and efficiency, promoting high-quality customer development, and improving customer service impression and service satisfaction; meeting anti-money laundering regulatory requirements, once a high-risk customer group appears, all products can be quickly terminated, reducing the financial risks of the entire bank.

[0089] Those skilled in the art will appreciate that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include at least one of non-volatile and volatile memory. Non-volatile memory may include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0090] The technical features of the above embodiments can be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0091] The above-described embodiments merely represent several implementation methods of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the present invention. It should be noted that a person skilled in the art could make various modifications and improvements without departing from the spirit of the present application, all of which fall within the scope of protection of the present application. Therefore, the scope of protection of the present patent application shall be subject to the appended claims.

Claims

1. A comprehensive query method, characterized in that: The method comprises: Get event query set; Collecting data for each event in the event query set to generate a data set for each event; Performing data preprocessing on each event data set to obtain a processed standard data set; Calling a data query service interface to conduct a comprehensive query on the processed standard data set; The method is applied to a comprehensive query module for account and contract relationships, and includes: Obtaining a product and service set of a target bank according to the event query set; Based on the product service component, data collection is performed on the contract information of each product in the product service set to generate a contract data set for each product; Pushing the contract data set of each product to the data source area, which is in communication with the data integration module; Loading the contract data sets of each product in the data source area into the data calculation area, performing data cleaning and formatting processing to generate a processed contract specification data set of each product, wherein the data calculation area is in communication with the data integration module; Upload the contract specification data set of each product to the big data cloud module to generate a big data query service interface; The big data query service interface is called, and the data query user calls and queries the contract data set of each product, wherein the contract data set of each product includes contract and account relationship query and arrears list information query; Based on the comprehensive termination module, the termination contracts in the contract data set of each product are terminated with one click.

2. The method according to claim 1, wherein The one-click cancellation of the contract in the contract data set for each product includes: Processing the termination contract to generate a termination contract sequence; Performing final review on each of the termination contracts in the termination contract sequence, and generating a sequence of termination contract requests to be reviewed; Generate a unique JMS identifier for each contract in the pending contract termination request sequence, wherein each contract corresponds to the unique JMS identifier in a one-to-one manner; Sorting the unique JMS identifiers according to the number of the pending contract termination request sequences to generate a JMS message queue; The contracts in the pending contract termination request sequence are traversed and sent to the JMS message queue for review.

3. The method according to claim 2, wherein The method comprises: Based on the asynchronous message receiving mode of the JMS message queue, the sequence of contract termination requests to be reviewed is monitored, and contracts in the sequence of contract termination requests to be reviewed are received according to the monitoring result; Based on the unified database configuration, asynchronously review the corporate comprehensive contracts in the pending contract termination request sequence, and simultaneously feed back the review results to the pending contract termination request sequence through the JMS message queue; Performing asynchronous review of single products on the aforementioned comprehensive corporate contracts; Obtain product coding information corresponding to the single product, perform outbound calling tasks for corporate users of the single product, and terminate the corporate comprehensive contract at the same time.

4. The method according to claim 1, wherein The step of uploading the contract specification data set of each product to the big data cloud module includes: Upload the contract specification data set of each product to the data management component and the data service component for management and processing, and generate the contract subject information of each product; Write an API query service interface for the contract subject information of each product; Authorization management is performed on the API query service interface to generate the big data query service interface.

5. The method according to claim 1, wherein The arrears list information query includes: According to the query of the arrears list information, call the fee payment component; According to the fee supplementary payment component, the overdue payment information of a single product in the overdue payment list is exempted and supplemented.

6. A comprehensive query system, characterized in that: The system comprises: a first obtaining unit, configured to obtain an event query set; a first generating unit, configured to collect data for each event in the event query set and generate a data set for each event; a second obtaining unit, configured to perform data preprocessing on each event data set to obtain a processed standard data set; a first execution unit, configured to call a data query service interface to perform a comprehensive query on the processed standard data set; Wherein, according to the event query set, a product and service set of the target bank is obtained; Based on the product service component, data collection is performed on the contract information of each product in the product service set to generate a contract data set for each product; Pushing the contract data set of each product to the data source area, which is in communication with the data integration module; Loading the contract data sets of each product in the data source area into the data calculation area, performing data cleaning and formatting processing to generate a processed contract specification data set of each product, wherein the data calculation area is in communication with the data integration module; Upload the contract specification data set of each product to the big data cloud module to generate a big data query service interface; The big data query service interface is called, and the data query user calls and queries the contract data set of each product, wherein the contract data set of each product includes contract and account relationship query and arrears list information query; Based on the comprehensive termination module, the termination contracts in the contract data set of each product are terminated with one click.

7. A computer-readable storage medium, characterized in that The storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

8. An electronic device, characterized in that: including processor and memory; The memory is used for storing; The processor is configured to execute the method according to any one of claims 1 to 5 by calling.

9. A computer program product comprising a computer program and / or instructions, characterized in that When the computer program and / or instructions are executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.

Images