CN114168579B

CN114168579B - Comprehensive query method and system

Info

Publication number: CN114168579B
Application number: CN202111510666.8A
Authority: CN
Inventors: 肖彤; 戈笑珊; 高兴宇
Original assignee: China Construction Bank Corp
Current assignee: China Construction Bank Corp
Priority date: 2021-12-10
Filing date: 2021-12-10
Publication date: 2025-10-03
Anticipated expiration: 2041-12-10
Also published as: CN114168579A

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

Comprehensive query method and system

Technical Field

The invention relates to the technical field of computers, in particular to a comprehensive query method and a comprehensive query system.

Background

The account is an account opened by a customer, such as a deposit account, a loan account, a transaction account, or the like opened at a bank. Contracts are the ways in which a customer needs to contract to restrict the use of a product, such as the start time of using the product, the end time of using the product, the contract name, the way a fee is charged, etc., before using the product. Such contract information may uniquely identify the specifics of the customer's use of the product. At present, customers sign various contract products, and contract information and contract and account relation information of different products are stored in a scattered system. The customer cannot acquire the account and contract relation overview, and the customer releases the contract when required to go to each product menu to conduct contract maintenance. The research design of the data management method for optimizing the relation between the account and the contract has important practical significance.

The prior art has the technical problems that the data consistency problem aiming at the relation between the account and the contract lacks unified management, and unified view inquiry and subsequent processing cannot be performed.

Disclosure of Invention

The embodiment of the application provides a comprehensive query method and a comprehensive query system, which solve the technical problems that the data consistency problem aiming at the relation between accounts and contracts in the prior art lacks unified management and unified view query and subsequent processing cannot be performed.

In view of the above problems, the embodiment of the application provides a comprehensive query method and a system.

In one aspect, the embodiment of the application provides a comprehensive query method, wherein the method is applied to a comprehensive query system and comprises the steps of obtaining an event query set; the method comprises the steps of collecting data of all events in an event query set to generate event data sets, preprocessing the data of the event data sets to obtain processed standard data sets, calling a data query service interface and comprehensively querying the processed standard data sets.

On the other hand, the application also provides a comprehensive query system, which comprises a first obtaining unit, a first generating unit, a second obtaining unit and a first executing unit, wherein the first obtaining unit is used for obtaining an event query set, the first generating unit is used for collecting data of all events in the event query set and generating all event data sets, the second obtaining unit is used for preprocessing the data of all event data sets to obtain a processed standard data set, and the first executing unit is used for calling a data query service interface to comprehensively query the processed standard data set.

In a third aspect, an embodiment of the present application provides an integrated query device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the steps of the method of any one of the first aspects when the processor executes the program.

One or more technical solutions provided in the embodiments of the present application at least have the following technical effects or advantages:

The method comprises the steps of obtaining event query sets, carrying out data acquisition on events in the event query sets to generate event data sets, carrying out data preprocessing on the event data sets to obtain processed standard data sets, calling a data query service interface, and carrying out comprehensive query on the processed standard data sets. The one-key compensation payment of the arrearage contract under the account name is supported by realizing the one-time synchronous inquiry and cancellation of the account and contract relation. The counter pressure is greatly reduced, the risk of misoperation is reduced, the waiting time of clients is reduced, the user experience and efficiency are improved, the high-quality development of clients is promoted, the service impression and the service satisfaction of the clients are improved, the counter money laundering supervision requirement is met, and once Gao Weike groups appear, all products can be rapidly separated, and the technical effect of the financial risk of the whole bank is reduced.

The foregoing description is only an overview of the present application, and is intended to be implemented in accordance with the teachings of the present application in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present application more readily apparent.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions of the prior art, the drawings that are required to be used in the description of the embodiments or the prior art will be briefly described below, it being obvious that the drawings in the description below are only exemplary and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic flow chart of a comprehensive query method according to an embodiment of the present application;

FIG. 2 is a schematic flow chart of a comprehensive query module of an embodiment of the present application, wherein the method is applied to an account and contract relationship;

FIG. 3 is a diagram of a comprehensive query module architecture in a comprehensive query method according to an embodiment of the present application;

FIG. 4 is a schematic diagram of a process for one-touch release of a contract for contract release in a contract data set for contract signing for each product in a comprehensive query method according to an embodiment of the present application;

FIG. 5 is a schematic diagram of a big data cloud data service scheme in a comprehensive query method according to an embodiment of the present application;

FIG. 6 is a schematic diagram of a comprehensive query system according to an embodiment of the present application;

fig. 7 is a schematic structural diagram of an exemplary electronic device according to an embodiment of the present application.

Detailed Description

The embodiment of the application solves the technical problems that the data consistency problem aiming at the relation between accounts and contracts in the prior art lacks unified management and cannot be subjected to unified view query and subsequent processing by providing the comprehensive query method and the system. The one-key compensation payment of the arrearage contract under the account name is supported by realizing the one-time synchronous inquiry and cancellation of the account and contract relation. The counter pressure is greatly reduced, the risk of misoperation is reduced, the waiting time of clients is reduced, the user experience and efficiency are improved, the high-quality development of clients is promoted, the service impression and the service satisfaction of the clients are improved, the counter money laundering supervision requirement is met, and once Gao Weike groups appear, all products can be rapidly separated, and the technical effect of the financial risk of the whole bank is reduced.

Hereinafter, exemplary embodiments according to the present application will be described in detail with reference to the accompanying drawings. It should be apparent that the described embodiments are only some embodiments of the present application and not all embodiments of the present application, and it should be understood that the present application is not limited by the example embodiments described herein.

Because the prior art lacks unified management for the problem of data consistency of account and contract relation, the technical problems of incapability of carrying out unified view inquiry and subsequent processing are solved. The application provides a comprehensive query method, which can unify and collect data of all product components into a data integration calculation area for data cleaning and data standardization processing, so that the data is prevented from inconsistent data caused by failure of interface to call synchronous data in a unified pushing mode, a unified comprehensive query entrance is formed, and a unified query view based on account and contract relation is formed, thereby realizing one-time synchronous query and cancellation of the account and the contract relation.

Aiming at the technical problems, the technical scheme provided by the application has the following overall thought:

The embodiment of the application provides a comprehensive query method, which is applied to a comprehensive query system and comprises the steps of obtaining an event query set; the method comprises the steps of collecting data of all events in an event query set to generate event data sets, preprocessing the data of the event data sets to obtain processed standard data sets, calling a data query service interface and comprehensively querying the processed standard data sets.

In order to better understand the above technical solutions, the following detailed description will refer to the accompanying drawings and specific embodiments.

Example 1

Referring to fig. 1, an embodiment of the present application provides a comprehensive query method, where the method is applied to a comprehensive query system, and the method specifically includes the following steps:

Step S100, obtaining an event query set;

step 200, data acquisition is carried out on each event in the event query set, and each event data set is generated;

Specifically, the event query set is a set of clients that need to make account and contract relationship queries. And acquiring data of each event in the event query set, wherein each event data set is a set formed by contract information of different products and contract and account relation information signed by a client for inquiring the account and contract relation. The technical effect of providing data support for the data preprocessing of the event data sets is achieved.

Step S300, carrying out data preprocessing on each event data set to obtain a processed standard data set;

And step 400, calling a data query service interface to comprehensively query the processed standard data set.

Specifically, the data preprocessing refers to data cleansing and formatting. By performing data preprocessing on the event data sets, a processed canonical data set can be obtained, wherein the processed canonical data set refers to a data set which is rechecked and checked and is used for eliminating inconsistency in data. And further, carrying out comprehensive query on the processed standard data set by calling a data query service interface, wherein the data query service interface is a big data query service interface. The method and the device achieve the technical effects of realizing one-time synchronous inquiry of the account and the contract relationship, improving user experience and efficiency and reducing the waiting time of clients.

Further, as shown in fig. 2, step S400 of the embodiment of the present application further includes:

step S410, obtaining a product service set of a target bank according to the event query set;

Step S420, based on the product service assembly, collecting data of each product contract signing information in the product service set to generate each product contract signing data set;

Specifically, the product service set of the target bank refers to a set formed by product services such as deposit service, loan service, financial product, and the like of any bank. The product service components are data sources, namely, contract information of each product subscription in the system is derived from each product service component, and meanwhile, contract and account relation information, product arrearage information and the like are contained. Through data collection, each product contract signing data set is generated, and the technical effect of laying a foundation for pushing each product contract signing data set to a data paste source area in the follow-up process is achieved.

Step S430, pushing the contract signing data sets of the products to a data paste source area, wherein the data paste source area is in communication link with a data integration module;

Step S440, loading the product contract signing data sets of the data paste source area into a data calculation area, performing data cleaning and formatting processing, and generating processed product contract signing standard data sets, wherein the data calculation area is in communication link with the data integration module;

Specifically, the product contract specification data sets refer to data sets obtained by loading the product contract data sets of the data paste source area into a data calculation area, and uniformly cleaning and formatting the data calculation area. The data source pasting area is a source pasting layer in a data warehouse, the source pasting layer summarizes the product contract signing data sets together, and the stored data are consistent with the data in the product contract signing data sets. The data cleaning refers to a process of rechecking and checking the data in the contract data sets signed by each product loaded to the data calculation area, and aims to delete repeated information, correct existing errors and provide data consistency. The formatting process refers to preprocessing of the disk before use to store data. The technical effects of rechecking and checking the data in the contract signing data sets of all products, eliminating the inconsistency in the data, ensuring the standardization of the data and providing data support for the subsequent generation of the big data query service interface are achieved.

Step S450, uploading the contract specification data sets of the product signing contracts to a big data cloud module to generate a big data query service interface;

step S460, calling the big data query service interface, and performing call query on the contract data sets of all product subscriptions by a data query user, wherein the contract data sets of all product subscriptions comprise contract and account relation query and arrearage list information query;

Specifically, the big data query service interface is a query service interface obtained by pushing the contract specification data sets of the product subscription contracts to the big data cloud module. And the data inconsistency caused by failure of the interface to call the synchronous data and the business trouble caused by the data inconsistency are avoided. As shown in fig. 3, the big data query interface service is issued through the big data cloud, so that the big data result query function is satisfied. The employee channel page can call the functions of contract information inquiry, contract and account relation inquiry, arrearage list information inquiry and the like of the client service assembly through the interface to complete comprehensive inquiry unified view display of the contract and account relation. The customer service page can jump to each product component through one page, so as to complete the functions of eliminating and paying the arrearage information. The one-key compensation payment of the arrearage contract under the account name is supported by realizing the one-time synchronous inquiry and cancellation of the account and contract relation. The technical effects of greatly reducing counter pressure, reducing misoperation risk, reducing customer waiting time, improving user experience and efficiency, promoting high-quality development of customers and improving customer service impression and service satisfaction are achieved.

And step 470, based on the comprehensive contract release module, performing one-key release on the contract release in the contract data set of each product contract.

The integrated contract solving module is used for solving the contract and account contract relation in the account list in the integrated query by one-key, establishing a unified normalized contract solving process, and carrying out unified bill making/rechecking on the release of the public product contract and the channel product contract and the account relation, and realizing the release of the one-key contract and the account relation in an asynchronous mode. The problems of long service handling time, poor user experience and the like caused by the fact that a customer releases contracts and needs to go to each product menu to conduct contract maintenance are solved, meanwhile, the requirements of the anti-money laundering tube are met, all products can be rapidly released when high-risk customer groups appear, and the technical effect of reducing financial risks of the whole bank is achieved.

Further, as shown in fig. 4, step S470 of the embodiment of the present application further includes:

step 471, making a single process for the contract to be contracted to generate a contract to be contracted sequence;

step S472, performing one-by-one final-check judgment on single contract in the contract-releasing sequence to generate a request sequence of the contract-releasing to be checked;

step S473, generating a unique JMS identifier for a single contract in the contract request sequence to be checked, wherein the single contract corresponds to the unique JMS identifier one by one;

step S474, sorting the unique JMS identifications according to the number of the to-be-checked contract-opening request sequences to generate JMS message queues;

And step S475, the contracts in the contract request sequence to be checked are checked, and the traversing cycle is sent to the JMS message queue for checking.

Specifically, the bill making process refers to making a bill for a contract that needs to be released, and further starting the audit after making the bill. The contract of the contract after each making form the contract of the contract sequence. And further, performing final judgment on a single contract to be released in the generated contract releasing sequence, namely judging whether the contract is the contract to be released, and further generating the contract requesting sequence to be checked according to the judgment result, wherein the contract requesting sequence to be checked is the contract sequence to be released finally determined. And further generating a unique JMS identifier for a single contract in the contract request sequence to be checked, wherein the single contract corresponds to the unique JMS identifier one by one, a JMS, namely Java message service (Java MESSAGE SERVICE) application program interface, is an API (application program interface) for Message Oriented Middleware (MOM) in a Java platform, is used for sending messages between two application programs or in a distributed system to carry out asynchronous communication, and Java message service is an API (application program interface) irrelevant to a specific platform, so that the distributed communication coupling degree is lower, and the message service is more reliable and asynchronous. The unique JMS identification refers to a token generated by a single contract in the above-described list of pending contract requests to uniquely identify a message. And sequencing the unique JMS identifications according to the number of the to-be-checked contract request sequences to generate JMS message queues, wherein the JMS message queues are areas for accommodating the sent messages to be read. The queue implies that these messages will be sent in sequence. Once a message is read, the message is removed from the queue. When the client acquires the message, the message can be automatically sent to the available client without actively sending a request. Meanwhile, the message is ensured to be delivered only once, and the problem of repeatedly creating the message is avoided. Based on the JMS asynchronous message receiving mode, the contracts in the contract request sequence to be checked can be sent to the JMS message queue for checking through traversing circulation until the contracts in the contract request sequence to be checked are checked.

Further, step S470 of the embodiment of the present application further includes:

step 476, based on the asynchronous message receiving mode of the JMS message queue, monitoring the contract request sequence to be checked, and receiving contracts in the contract request sequence to be checked according to the monitoring result;

Step 477, based on the unified database configuration, asynchronous auditing is carried out on the public comprehensive contracts in the to-be-audited contract request sequence, and meanwhile, the auditing result is fed back to the to-be-audited contract request sequence through the JMS message queue.

Specifically, the asynchronous message receiving mode of the JMS message queue refers to that in a distributed heterogeneous environment, mutual communication among application programs does not need synchronous execution of the application programs, the application programs can continue to perform other work by sending out the message, the occurrence of message transmission does not force the application programs to wait for sending to finish, and a receiving party application program does not need to monitor the whole receiving process and simply reads and processes the message from the queue. The coupling degree between programs is greatly reduced, a safe storage mode is provided for information, and the method is particularly suitable for applications which are not directly connected, such as applications in which a mobile user, a sender or a receiver process may be in an inactive state. Based on the above, contracts in the contract request sequence to be checked can be received according to the monitoring result, and further, a unified database configuration mode is adopted to asynchronously check the public comprehensive contracts in the contract request sequence to be checked, and meanwhile, the checking result is fed back to the contract request sequence to be checked through the JMS message queue. For example, after one of the contracts is audited, the audit result can be fed back to the contract request sequence to be audited, so that the contract is not sent until all the contracts are audited, the accuracy, consistency and integrity of the data are improved, and meanwhile, the subsequent maintenance and management by adopting a unified database configuration mode is simpler and lower in cost, and the informationized sustainable development can be realized. And sending and monitoring the messages in a JMS message queue mode, and completing the solution customization of different products through unified database configuration.

Step S478, executing single product asynchronous audit on the public integrated contract;

Step 479, obtaining product coding information corresponding to the single product, executing outbound tasks for public users of the single product, and simultaneously releasing the public comprehensive contract.

Specifically, when the public integrated contracts in the contract request sequence to be verified are subjected to asynchronous verification, single-product asynchronous verification can be performed on the public integrated contracts, namely, single contracts in the public integrated contracts are subjected to asynchronous verification one by one, and meanwhile, product coding information corresponding to the single product can be obtained, wherein the product coding information refers to coding information which is obtained by performing single-product asynchronous verification on the public integrated contracts and indicates that the product is a single product. And then, executing outbound tasks for public users of the single product through the product coding information, wherein the outbound tasks are tasks created by an administrator and distributed to customer service personnel for customer return visit. Customer service can view, execute tasks, and add follow-up records. For example, if a certain public contract is checked, it is confirmed that the public contract needs to be released, a telephone outbound task can be executed on the public matched with the public contract, that is, the public contract can be communicated with through the outbound task until the public contract is released. The method achieves the technical effects of obtaining accurate and reliable public integrated contract execution single products, further completing asynchronous one-key type reduction operation through identifying the products and calling transactions, reducing error operation, optimizing reduction flow and improving user experience.

Further, step S450 of the embodiment of the present application further includes:

Step S451, uploading the contract specification data sets of the product signing contracts to a data management component and a data service component for management and processing, and generating topic information of the product signing contracts;

step S452, writing an API inquiry service interface for the subscription subject information of each product;

And step S453, carrying out authorization management on the API query service interface to generate the big data query service interface.

Specifically, when the product contract standard data sets are uploaded to the big data cloud module, the product contract standard data sets can be uploaded to a data management component and a data service component for management and processing, and meanwhile, the product contract topic information can be obtained. The product contract signing and specifying data sets are data sets obtained by loading the product contract signing data sets of the data paste source area into a data calculation area, uniformly cleaning the data calculation area and formatting the data calculation area. The data management component is a module for managing data services in the data integration platform. The data service components are self-contained, self-describing loosely coupled data modules defined in a distributed heterogeneous data environment, interoperation between them is supported by a range of standards, and new data services can be defined by multiplexing existing data services. It should also be noted that the data service is limited to the platform environment for providing the service, but the data service may be provided to the application program in the form of Web service, so as to solve the issue problem of the data service. The product signing topic information refers to contract names of contracted products, such as a bank borrowing agreement, a bank loan agreement, a bank financing product agreement and the like, which are signed by clients. Then, through the signing topic information of each product, an API query service interface can be written. The API refers to an application program interface (Application Program Interface) which is a set of definitions, programs and protocols, and the mutual communication between computer software is realized through the API interface. The API inquiry service interface is a calling interface reserved for the inquiry application program by the operating system, and the inquiry application program enables the system to execute the command of the inquiry application program by calling the API of the operating system. And then the interface authorization management can obtain the big data inquiry service interface. As shown in fig. 5, the big data query interface service is issued through the big data cloud, so that the big data result query function is satisfied. The method achieves the technical effects of forming a unified query view based on the account and contract relationship, facilitating the client to acquire the account and contract relationship overview, and facilitating unified management and maintenance of data.

Further, step S460 of the embodiment of the present application further includes:

step S461, inquiring according to the arrearage list information, and calling a fee compensation component;

And S462, eliminating and paying the arrearage information of the single product in the arrearage list according to the fee paying component.

Specifically, when inquiring the arrearage list information, the arrearage payment component can be obtained by inquiring the arrearage list. The fee compensation component is used for obtaining product contract information requiring user compensation by inquiring the arrearage list information. Through one page, the multi-product jumps to each product component to finish the functions of eliminating and paying the arrearage information. The method and the device have the advantages that the technical effects of supporting product contract arrearage information query and arrearage information compensation based on accounts, optimizing counter business handling flows, greatly shortening business handling time and improving user experience are achieved.

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

1. The method comprises the steps of obtaining a product service set of a target bank, carrying out data acquisition on product contract signing information in the product service set based on a product service component to generate product contract signing data sets, pushing the product contract signing data sets to a data paste source area, carrying out communication link between the data paste source area and a data integration module, loading the product contract signing data sets in the data paste source area to a data calculation area, carrying out data cleaning and formatting processing to generate processed product contract signing standard data sets, wherein the data calculation area is in communication link with the data integration module, uploading the product contract signing standard data sets to a big data cloud module to generate a big data query service interface, calling the big data query service interface, and carrying out call query on the product contract signing data sets by a data query user, wherein the product contract signing data sets comprise contract and account relation query and owed list information query, and carrying out one-key release on contract opening in the product contract signing data sets based on a comprehensive contract opening module. The one-key compensation payment of the arrearage contract under the account name is supported by realizing the one-time synchronous inquiry and cancellation of the account and contract relation. The counter pressure is greatly reduced, the risk of misoperation is reduced, the waiting time of clients is reduced, the user experience and efficiency are improved, the high-quality development of clients is promoted, the service impression and the service satisfaction of the clients are improved, the counter money laundering supervision requirement is met, and once Gao Weike groups appear, all products can be rapidly separated, and the technical effect of the financial risk of the whole bank is reduced.

2. And the big data query interface service is issued through the big data cloud, so that the big data result query function is satisfied. The employee channel page can call the functions of contract information inquiry, contract and account relation inquiry, arrearage list information inquiry and the like of the client service assembly through the interface to complete comprehensive inquiry unified view display of the contract and account relation. The customer service page can jump to each product component through one page, so as to complete the functions of eliminating and paying the arrearage information.

3. In the comprehensive reduction function, the information is sent and monitored in a JMS information queue mode, the reduction customization of different products is completed through unified database configuration, and meanwhile, the scheme effectively supports the expandability of the products. Asynchronous one-touch reduction is accomplished by identifying the product and invoking the transaction.

Example two

Based on the same inventive concept as the comprehensive query method in the foregoing embodiment, the present invention further provides a comprehensive query system, referring to fig. 6, where the system includes:

a first obtaining unit 11, where the first obtaining unit 11 is configured to obtain an event query set;

The first generating unit 12 is configured to perform data collection on each event in the event query set, and generate each event data set;

a second obtaining unit 13, where the second obtaining unit 13 is configured to perform data preprocessing on the event data sets to obtain a processed canonical data set;

The first execution unit 14 is configured to invoke a data query service interface, and perform comprehensive query on the processed canonical data set.

The embodiments of the present invention are described in a progressive manner, and each embodiment focuses on the differences from the other embodiments, so that an integrated query method and a specific example in the first embodiment of fig. 1 are equally applicable to an integrated query system of the present embodiment, and a person skilled in the art can clearly know an integrated query system in the present embodiment through the foregoing detailed description of an integrated query method, so that the details of the description are not described herein. For the device disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant points refer to the description of the method section.

The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Example III

A computer device of an embodiment of the present application is described below with reference to fig. 7. The computer device may be an application version management server or terminal, and its internal structure may be as shown in fig. 7. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a method of processing application packages.

When the computer device is a terminal, the computer device may further comprise a display screen and input means. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

It will be appreciated by those skilled in the art that the structure shown in FIG. 7 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.

In an embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.

In one embodiment, a computer-readable storage medium is provided, storing a computer program which, when executed by a processor, implements the steps of the method embodiments described above.

In one embodiment, a computer program product or computer program is provided that includes computer instructions stored in a computer readable storage medium. The processor of the computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-described method embodiments.

The embodiment of the application provides a comprehensive query method, which is applied to a comprehensive query system and comprises the steps of obtaining an event query set; the method comprises the steps of collecting data of all events in an event query set to generate event data sets, preprocessing the data of the event data sets to obtain processed standard data sets, calling a data query service interface and comprehensively querying the processed standard data sets. The method solves the technical problems that the data consistency problem aiming at the relation between the account and the contract lacks unified management and cannot be subjected to unified view query and subsequent processing in the prior art. The one-key compensation payment of the arrearage contract under the account name is supported by realizing the one-time synchronous inquiry and cancellation of the account and contract relation. The counter pressure is greatly reduced, the risk of misoperation is reduced, the waiting time of clients is reduced, the user experience and efficiency are improved, the high-quality development of clients is promoted, the service impression and the service satisfaction of the clients are improved, the counter money laundering supervision requirement is met, and once Gao Weike groups appear, all products can be rapidly separated, and the technical effect of the financial risk of the whole bank is reduced.

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, or the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory. By way of illustration, and not limitation, RAM can be in various forms such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), etc.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. The scope of the present application should therefore be determined by the appended claims.

Claims

1. A method of comprehensive querying, the method comprising:

Obtaining an event query set;

data acquisition is carried out on each event in the event query set, and each event data set is generated;

Performing data preprocessing on each event data set to obtain a processed standard data set;

invoking a data query service interface to comprehensively query the processed canonical data set;

The method is applied to a comprehensive query module of account and contract relation, and comprises the following steps:

Obtaining a product service set of a target bank according to the event query set;

based on a product service assembly, collecting data of each product contract signing information in the product service set to generate each product contract signing data set;

Pushing the contract signing data sets of the products to a data paste source area, wherein the data paste source area is in communication link with a data integration module;

Loading the product contract signing data sets of the data paste source region into a data calculation region, performing data cleaning and formatting processing, and generating processed product contract signing standard data sets, wherein the data calculation region is in communication link with the data integration module;

Uploading the contract specification data sets of all the product signing contracts to a big data cloud module to generate a big data query service interface;

Invoking the big data query service interface, and invoking and querying the contract data sets of all product subscription contracts by a data query user, wherein the contract data sets of all product subscription contracts comprise contract and account relation query and arrearage list information query;

and based on the comprehensive contract release module, one-key release is carried out on the contract release in the contract signing data set of each product.

2. The method of claim 1, wherein one-touch release of the contract release in each product contract data set comprises:

Making a single process for the contract to generate a contract sequence;

performing one-by-one final-examination judgment on single contract in the contract-opening sequence to generate a contract-opening request sequence to be examined;

Generating a unique JMS (joint management system) identifier for a single contract in the contract request sequence to be checked, wherein the single contract corresponds to the unique JMS identifier one by one;

Sequencing the unique JMS identifiers according to the number of the contract request sequences to be checked to generate JMS message queues;

And traversing the contracts in the contract request sequence to be checked and transmitting the traversing cycle to the JMS message queue for checking.

3. The method according to claim 2, wherein the method comprises:

based on the asynchronous message receiving mode of the JMS message queue, monitoring the contract request sequence to be checked, and receiving contracts in the contract request sequence to be checked according to monitoring results;

Based on unified database configuration, asynchronously auditing the public comprehensive contracts in the contract request sequence to be audited, and feeding the auditing result back to the contract request sequence to be audited through the JMS message queue;

Performing a single product asynchronous audit on the public integrated contract;

and obtaining product coding information corresponding to the single product, executing outbound tasks on public users of the single product, and simultaneously releasing the public comprehensive contract.

4. The method of claim 1, wherein uploading the product contract specification data sets to a big data cloud module comprises:

uploading the contract specification data sets of the product signing contracts to a data management component and a data service component for management and processing, and generating theme information of the product signing contracts;

writing an API inquiry service interface for the signing topic information of each product;

and carrying out authorization management on the API query service interface to generate the big data query service interface.

5. The method of claim 1, wherein the arrearage list information query comprises:

inquiring according to the arrearage list information, and calling a fee compensation component;

and according to the fee compensation component, eliminating and compensating the single product arrearage information in the arrearage list.

6. An integrated query system, the system comprising:

A first obtaining unit configured to obtain an event query set;

The first generation unit is used for collecting data of each event in the event query set and generating each event data set;

The second obtaining unit is used for carrying out data preprocessing on the event data sets to obtain processed standard data sets;

The first execution unit is used for calling a data query service interface and comprehensively querying the processed standard data set;

according to the event query set, a product service set of a target bank is obtained;

7. A computer readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when executed by a processor, implements the method of any of claims 1-5.

8. An electronic device comprising a processor and a memory;

The memory is used for storing;

the processor is configured to execute the method of any one of claims 1 to 5 by calling.

9. A computer program product comprising a computer program and/or instructions which, when executed by a processor, implement the steps of the method of any one of claims 1 to 5.