CN117992494A

CN117992494A - Parameter checking method and device, electronic equipment and medium

Info

Publication number: CN117992494A
Application number: CN202311836588.XA
Authority: CN
Inventors: 董文婷; 杨帆; 万剑桥; 韩文豪; 何亮
Original assignee: Icbc Credit Suisse Fund Management Co ltd
Current assignee: Icbc Credit Suisse Fund Management Co ltd
Priority date: 2023-12-28
Filing date: 2023-12-28
Publication date: 2024-05-07

Abstract

The parameter checking method, the device, the electronic equipment and the medium can be applied to the technical field of big data. The method comprises the following steps: obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer; generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data; acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked; acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result.

Description

Parameter checking method and device, electronic equipment and medium

Technical Field

The present invention relates to the field of big data technologies, and in particular, to a parameter checking method, apparatus, electronic device, and medium.

Background

In modern foundation operations, the synergy of multiple core systems is critical, wherein each system plays an indispensable role in the overall process. However, these core systems are often designed and operated independently of each other, which in practice results in the following problems and challenges:

First, because the same parameter values between different systems may be inconsistent in configuration, this results in data inconsistencies and operational inaccuracies. For example, the parameter values configured in different systems by the hosted line of the same fund may not be synchronized, which not only increases the complexity of operation, but may also lead to erroneous decision bases; secondly, the problem of miss-fitting of parameter ranges between different systems is also quite common. One system may have configured a certain parameter, while another system ignores the configuration, which may cause incomplete data, and even affect the efficiency and safety of the overall fund operation; finally, dictionary configuration inconsistencies from system to system are also a common problem. Even the same parameter values, may take different forms in different systems due to dictionary configuration differences, further exacerbating the problem of data consistency.

The existence of the above problems not only increases the complexity and risk of the fund operation, but also requires a great deal of manpower to check and correct parameter values one by one to ensure the integrity and consistency of the configuration. Therefore, there is a need for a method that enables efficient and accurate configuration of parameter values to improve the efficiency of fund operations and reduce operational risks.

Disclosure of Invention

In view of the above-described problems, according to a first aspect of the present invention, there is provided a parameter collation method comprising: obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer; generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data; acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked; acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result.

According to some exemplary embodiments, the generating, based on the parameters to be checked, a query condition for each piece of data in the N pieces of check task data specifically includes: traversing the N pieces of check task data, and processing each piece of data one by one, wherein for each piece of data: extracting a checking parameter value of each piece of data based on the parameters to be checked; generating M query terms by using the check parameter values, wherein M is a positive integer greater than or equal to 0; when M is not 0, forming the query condition based on the query term; and generating a query condition for each piece of data in the N pieces of check task data in response to the completion of the traversal, and storing the query condition in a temporary array or list.

According to some exemplary embodiments, when M is 0, the query condition is formed based on a collation parameter value, identifier or primary key of the corresponding collation task data.

According to some exemplary embodiments, the obtaining a plurality of service systems to be checked and parameter value obtaining manners corresponding to the plurality of service systems to be checked specifically include: acquiring the type of the business system to be checked by analyzing a parameter configuration interface or a database table description document of the business system to be checked; and configuring the parameter value acquisition mode based on the type of the service system to be checked.

According to some exemplary embodiments, the configuring the parameter value obtaining manner based on the type of the service system to be checked specifically includes: for a database driving system, configuring the parameter value acquisition mode comprises constructing SQL query; for an API integrated system, configuring the parameter value acquisition mode comprises calling an API interface; or for a customization system, configuring the parameter value acquisition mode comprises executing custom code based on internal logic of the customization system.

According to some exemplary embodiments, the obtaining a plurality of parameter values to be checked from the plurality of business systems to be checked by using the query condition and the parameter value obtaining manner specifically includes: selecting a target query condition based on the temporary array or list; constructing a query request based on the target query condition and the parameter value acquisition mode; and acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query request.

According to some exemplary embodiments, the method further comprises: and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result, wherein the method specifically comprises the following steps of: defining consistency rules of parameter value comparison to be checked based on a rule engine or a decision engine; and carrying out consistency judgment on the plurality of parameter values to be checked by utilizing the consistency rule, and obtaining the parameter checking result.

According to some exemplary embodiments, the method further comprises: creating a dynamic parameter value table based on the parameters to be checked, the query conditions, the plurality of business systems to be checked and the parameter check results; re-executing the operations of acquiring parameters to be checked and checking ranges, generating inquiry conditions, acquiring a plurality of parameter values to be checked and consistency judgment according to preset time intervals, and acquiring a dynamic parameter checking result; and updating the dynamic parameter value table based on the dynamic parameter checking result.

According to a second aspect of the present invention, there is provided a parameter collation apparatus, comprising: the checking parameter and range acquisition module is used for: obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer; the query condition generation module is used for: generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data; the business system to be checked acquisition module is used for: acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked; the parameter value obtaining module to be checked is used for: acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and a consistency judging module for: and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result.

According to some example embodiments, the query condition generation module may include a traversal unit and a query condition generation unit.

According to some exemplary embodiments, the traversing unit may be configured to traverse the N pieces of collation task data, and process each piece of data one by one, wherein for each piece of data: extracting a checking parameter value of each piece of data based on the parameters to be checked; generating M query terms by using the check parameter values, wherein M is a positive integer greater than or equal to 0; when M is not 0, the query condition is formed based on the query term.

According to some example embodiments, the query condition generating unit may be configured to generate a query condition for each of the N pieces of collation task data in response to the traversal being completed, and store the query condition in a temporary array or list.

According to some exemplary embodiments, the service system obtaining module to be checked may include a service system type obtaining unit and a parameter value obtaining mode configuration module.

According to some exemplary embodiments, the service system type obtaining unit may be configured to obtain the type of the service system to be checked by analyzing a parameter configuration interface or a database table description document of the service system to be checked.

According to some exemplary embodiments, the parameter value acquisition mode configuration module may be configured to configure the parameter value acquisition mode based on the type of the service system to be checked.

According to some exemplary embodiments, the parameter value acquisition mode configuration module may include a build SQL query unit, a call API interface unit, or an execute custom code unit.

According to some example embodiments, the constructing an SQL query unit may be configured to configure the parameter value acquisition manner for a database drive system to include constructing an SQL query.

According to some example embodiments, the calling API interface unit may be configured to configure the parameter value acquisition means to include calling an API interface for an API integration system.

According to some exemplary embodiments, the executing custom code unit may be configured to configure the parameter value acquisition means for a customization system comprising executing custom code based on internal logic of the customization system.

According to some exemplary embodiments, the parameter value obtaining module to be checked may include a target query condition selecting unit, a query request constructing unit, and a parameter value obtaining unit.

According to some example embodiments, the target query condition selection unit may be configured to select a target query condition based on the temporary array or list.

According to some exemplary embodiments, the query request construction unit may be configured to construct a query request based on the target query condition and the parameter value acquisition manner.

According to some exemplary embodiments, the parameter value obtaining unit may be configured to obtain a plurality of parameter values to be checked from the plurality of business systems to be checked using the query request.

According to some exemplary embodiments, the consistency judging module may include a definition unit and a parameter collation result acquiring unit.

According to some exemplary embodiments, the defining unit may be configured to define the consistency rule for comparison of the parameter values to be checked based on a rule engine or a decision engine.

According to some exemplary embodiments, the parameter verification result obtaining unit may be configured to perform consistency judgment on the plurality of parameter values to be verified by using the consistency rule, to obtain the parameter verification result.

According to some example embodiments, the parameter verification apparatus may further include a dynamic result presentation module.

According to some example embodiments, the dynamic result presentation module may include a dynamic parameter value table creation unit, a re-execution unit, and an update unit.

According to some exemplary embodiments, the dynamic parameter value table creating unit may be configured to create a dynamic parameter value table based on the parameters to be checked, the query conditions, the plurality of business systems to be checked, and the parameter check result.

According to some exemplary embodiments, the re-execution unit may be configured to re-execute operations of acquiring parameters to be checked and a check range, generating a query condition, acquiring a plurality of parameter values to be checked and consistency judgment at preset time intervals, and acquiring a dynamic parameter check result.

According to some exemplary embodiments, the updating unit may be configured to update the dynamic parameter value table based on the dynamic parameter check result.

According to a third aspect of the present invention, there is provided an electronic device comprising: one or more processors; and a storage device for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method as described above.

According to a fourth aspect of the present invention there is provided a computer readable storage medium having stored thereon executable instructions which when executed by a processor cause the processor to perform a method as described above.

According to a fifth aspect of the present invention there is provided a computer program product comprising a computer program which, when executed by a processor, implements a method as described above.

One or more of the above embodiments have the following advantages or benefits: according to the parameter checking method provided by the invention, the checking operation can be executed in batches by acquiring the parameter value of the business system to be checked according to the corresponding parameter value acquisition mode, repeated work of a single task is reduced, the checking process can be ensured to be concentrated on related data points by generating the query condition, and unnecessary data processing is avoided, so that the calculation speed of a computer is improved; meanwhile, by using a computer program and an automatic process, the parameter checking task can be rapidly and accurately executed, and the complicated and potential errors of manual operation are avoided, so that the user experience is improved.

Drawings

The foregoing and other objects, features and advantages of the invention will be apparent from the following description of embodiments of the invention with reference to the accompanying drawings, in which:

Fig. 1 schematically illustrates an application scenario diagram of a parameter verification method, device, equipment and medium according to an embodiment of the invention.

Fig. 2 schematically shows a flow chart of a parameter verification method according to an embodiment of the invention.

Fig. 3 schematically shows a flow chart of a method of generating query conditions for collation task data according to an embodiment of the invention.

Fig. 4 schematically shows a flow chart of a method of acquiring a plurality of business systems to be checked according to an embodiment of the invention.

Fig. 5 schematically shows a flow chart of a method of configuring a parameter value acquisition means based on a service system type according to an embodiment of the present invention.

Fig. 6 schematically shows a flow chart of a method of acquiring a plurality of parameter values to be checked according to an embodiment of the invention.

Fig. 7 schematically shows a flowchart of a method of consistency determination of a plurality of parameter values to be checked according to an embodiment of the present invention.

Fig. 8 schematically shows a flow chart of a method of dynamic result presentation according to an embodiment of the invention.

Fig. 9 schematically shows a block diagram of the configuration of the parameter collation apparatus according to the embodiment of the present invention.

Fig. 10 schematically shows a block diagram of an electronic device adapted for the parameter verification method according to an embodiment of the invention.

Detailed Description

Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings. It should be understood that the description is only illustrative and is not intended to limit the scope of the invention. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the invention. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the present invention.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a convention should be interpreted in accordance with the meaning of one of skill in the art having generally understood the convention (e.g., "a system having at least one of A, B and C" would include, but not be limited to, systems having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

In the technical scheme of the invention, the acquisition, storage, application and the like of the related personal information of the user accord with the regulations of related laws and regulations, necessary security measures are taken, and the public order harmony is not violated.

First, technical terms described herein are explained and illustrated as follows.

A Rule Engine (Rule Engine) is a software system that is specifically used to define, monitor, and execute pre-written rules. In enterprise and technology applications, rule engines are often used to automate the decision process and improve efficiency and consistency. Wherein the rules engine may automatically perform complex logic decisions based on a series of predefined business rules; rules can be easily updated and modified as business requirements change without modifying the underlying code.

Decision engines (Decision engines) are used to automate the Decision process, especially in scenarios where large amounts of data and complex rules need to be processed. It utilizes predefined logic, algorithms, and data analysis to make fast, consistent decisions. Decision engines support or make decisions by analyzing large amounts of data, including historical data, real-time data, external data sources, and the like. The method can process and execute complex business rules, algorithms and logic flows, so that the decision making process is more accurate and efficient.

In the rapidly evolving financial field of today, fund management is a core business facing unprecedented technical challenges. The fund operations involve not only complex financial calculations and transaction processing, but also require processing of large amounts of data from multiple core systems. For example, the plurality of core systems may include an valuation system, a constant generation system, a TA system, a sales clearance system, etc., each of which plays a critical role in different links of the fund operation. However, these systems tend to be developed and run independently of each other, resulting in a number of important data consistency and integration issues.

First, the data consistency problem causes a barrier to the decision level. The accuracy of key parameters involved in the operation of funds, such as the rate of interest of the hosted user, is critical to investment decision making and risk management. Because these parameters may be configured by different teams in different systems, mis-configurations can easily occur as if the managed rows of the same fund were not consistent in parameter values configured in different systems. This situation may result in decisions for fund management based on erroneous information, increasing investment risk.

Second, the parameter range mismatch problem may cause interruption of the operation flow. When a certain system updates the parameter configuration and other systems interdependent with it fail to synchronize the update, it may result in a stagnation of the business process or erroneous business execution. This not only affects the efficiency of the fund operation, but may also cause customer service problems affecting the reputation of the fund company.

In addition, the problem of inconsistent dictionary configuration adopted by different systems increases the difficulty of data integration. For example, the same transaction may be represented by different codes in different systems, and this discrepancy complicates and time-consuming data analysis and reporting across systems. For example, in one system, a transaction may be represented by "01" and in another system by "HK". This discrepancy exacerbates the complexity of cross-system data integration.

Therefore, it takes a lot of time to check whether the parameter values are configured completely and consistently one by one.

Based on this, an embodiment of the present invention provides a parameter collation method, characterized in that the method comprises: obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer; generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data; acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked; acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result. According to the parameter checking method provided by the invention, the checking operation can be executed in batches by acquiring the parameter value of the business system to be checked according to the corresponding parameter value acquisition mode, repeated work of a single task is reduced, the checking process can be ensured to be concentrated on related data points by generating the query condition, and unnecessary data processing is avoided, so that the calculation speed of a computer is improved; meanwhile, by using a computer program and an automatic process, the parameter checking task can be rapidly and accurately executed, and the complicated and potential errors of manual operation are avoided, so that the user experience is improved.

It should be noted that the parameter checking method, device, equipment and medium determined by the present invention can be used in the big data technical field, the financial field, and various fields other than the big data technical field and the financial field. The application fields of the parameter checking method, the device, the equipment and the medium provided by the embodiment of the invention are not limited.

In the technical scheme of the invention, the related user information (including but not limited to user personal information, user image information, user equipment information, such as position information and the like) and data (including but not limited to data for analysis, stored data, displayed data and the like) are information and data authorized by a user or fully authorized by all parties, and the processing of the related data such as collection, storage, use, processing, transmission, provision, disclosure, application and the like are all conducted according to the related laws and regulations and standards of related countries and regions, necessary security measures are adopted, no prejudice to the public welfare is provided, and corresponding operation inlets are provided for the user to select authorization or rejection.

As shown in fig. 1, an application scenario 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 101, 102, 103.

The terminal devices 101, 102, 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

It should be noted that the parameter checking method provided by the embodiment of the present invention may be generally performed by the server 105. Accordingly, the parameter checking apparatus provided in the embodiment of the present invention may be generally provided in the server 105. The parameter checking method provided by the embodiment of the present invention may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Accordingly, the parameter checking apparatus provided by the embodiment of the present invention may also be provided in a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

As shown in fig. 2, the parameter collation method 200 of the embodiment may include operations S210 to S250.

In operation S210, parameters to be checked and a checking range are acquired, wherein the checking range includes N pieces of checking task data, and N is a positive integer.

In embodiments of the present invention, it may be assumed herein that the parameter to be checked is "net value of fund" for ease of illustration. Net value of funds is a key parameter in the management of funds, representing the value of each fund unit, which is an important basis for the management of funds and investment decisions, and thus ensuring accuracy is critical.

In an embodiment of the present invention, the collation scope defines a specific data set that needs to be focused and processed in the data collation process, determined by specific service requirements and data formats, etc. For example, the reconciliation range corresponding to "net value of funds" may be "all active stock-type funds", meaning that the reconciliation process is focused on active funds in a particular category (stock-type funds). The net value of each active stock-type fund in the checking range constitutes checking task data.

In operation S220, a query condition is generated for each piece of data of the N pieces of collation task data based on the parameter to be collated, wherein the query condition is used for uniquely determining a parameter value of the corresponding data.

In an embodiment of the invention, the purpose of generating the query condition is to be able to uniquely lock the parameter values of the parameters to be checked, thereby ensuring that the checking process is focused on the relevant data points, avoiding processing unnecessary data.

As shown in fig. 3, the method of generating a query condition for collation task data of this embodiment may include operations S310 to S320, and operations S310 to S320 may at least partially perform operation S220.

Traversing the N pieces of collation task data, processing each piece of data one by one, in operation S310, wherein for each piece of data: extracting a checking parameter value of each piece of data based on the parameters to be checked; generating M query terms by using the check parameter values, wherein M is a positive integer greater than or equal to 0; when M is not 0, the query condition is formed based on the query term.

In an embodiment of the present invention, the query term is an element constituting a query condition, which in the above example may be information such as a foundation code, an evaluation date, or the like.

In an embodiment of the present invention, for each piece of data, a corresponding collation parameter value may be extracted according to a parameter to be collated (e.g., net value of the fund). For example, it may include obtaining the net value of a particular fund on a particular date from an associated data source (e.g., an valuation system). Next, M query terms are generated using the extracted collation parameter values, wherein M is a positive integer greater than or equal to 0. When M is not 0 (i.e., there is at least one query term), a query condition may be formed based on these query terms that will be used to retrieve the same collation parameter value in other systems for comparison. For example, if the query condition is formed by the query terms "fund code" and "evaluation date", the net value of the fund for the corresponding date is retrieved in the accounting system or the customer reporting system and compared to the value extracted in the evaluation system.

In response to the completion of the traversal, a query condition is generated for each of the N pieces of collation task data and stored in a temporary array or list in operation S320.

In embodiments of the present invention, the query conditions generated during the collation process may all be stored in a temporary array or list. This storage mechanism provides a well-organized data structure for subsequent data processing and analysis, making the collation process more efficient and systematic. In particular, the choice of arrays or lists as storage structures may depend on specific needs. For example, if the number of collation tasks is known in advance and fixed, an array may be selected for storage; the list provides more flexibility if the number of collation tasks dynamically changes.

In an embodiment of the present invention, when M is 0, the query condition may be formed based on a collation parameter value, identifier or primary key of the corresponding collation task data.

According to an embodiment of the present invention, when M is 0, meaning that no additional query term is used to form the query condition, the flow of forming the query condition is different from that in operation S320. In this case, the query condition is not composed based on a plurality of query terms, but directly depends on the collation parameter value, identifier or primary key of the collation task data to directly point to a specific data entity or record.

Referring back to fig. 2, in operation S230, a plurality of service systems to be checked and a parameter value acquisition manner corresponding to the plurality of service systems to be checked are acquired.

As shown in fig. 4, the method for acquiring a plurality of business systems to be checked according to the embodiment may include operations S410 to S420, and the operations S410 to S420 may at least partially perform the operation S230.

In operation S410, the type of the service system to be checked is obtained by analyzing the parameter configuration interface or database table description document of the service system to be checked.

In the embodiment of the invention, the detailed information about the system functions, the data structures, the parameter types and the configuration options can be obtained by analyzing the parameter configuration interface or the database table description document of the business system to be checked. From this analysis, the type of business system to be checked can be determined to understand how to interact with the system and obtain data from it.

In operation S420, the parameter value obtaining manner is configured based on the type of the service system to be checked.

In the practical process, various complex situations exist in the parameter value acquisition, and flexible access modes need to be adapted according to a service system, such as executing SQL, calling API or dynamically executing a certain code.

As shown in fig. 5, the method for configuring a parameter value acquisition manner based on a service system type of this embodiment may include operation S510, operation S520, or operation S530, and the operation S510, operation S520, or operation S530 may at least partially perform operation S420.

In operation S510, for the database driving system, configuring the parameter value acquisition manner includes constructing an SQL query.

In embodiments of the present invention, for database driven systems, the retrieval of parameter values may be accomplished by constructing SQL queries. In particular, the required data can be retrieved from the database by writing specific SQL commands, and the constructed SQL query will depend on the structure of the database, including table names, field names, etc., and need to consider the accuracy and consistency of the data. This method is applicable to systems where data is stored in a relational database, such as MySQL, oracle, or SQL SERVER.

In operation S520, for the API integration system, configuring the parameter value acquisition means includes calling an API interface.

In embodiments of the present invention, for API-integrated systems, obtaining parameter values typically involves invoking predefined API (Application Programming Interface) interfaces that provide a way for external programs to access and operate on system data. In particular, when an API is called, authentication information may need to be provided, and parameters, request format, and response format of the API need to be known.

In operation S530, for a customization system, configuring the parameter value acquisition means includes executing custom code based on internal logic of the customization system.

In embodiments of the present invention, for custom systems, the acquisition of parameter values requires the execution of custom code based on the internal logic of the system, which code is typically specifically designed for this system to accommodate its unique structure and function. In particular, it may involve writing scripts or programs that are tightly coupled to the internal logic of the system to properly access and process the desired data.

Referring back to fig. 2, in operation S240, a plurality of parameter values to be checked are acquired from the plurality of business systems to be checked using the query condition and the parameter value acquisition method.

As shown in fig. 6, the method of acquiring a plurality of parameter values to be checked of this embodiment may include operations S610 to S630.

In operation S610, a target query condition is selected based on the temporary array or list.

In an embodiment of the present invention, operation S610 involves selecting a specific query condition of the present collation task from the temporary array or list generated and stored in operation S320.

In operation S620, a query request is constructed based on the target query condition and the parameter value acquisition mode.

In an embodiment of the invention, the form of the query request depends on the target query conditions and the type of business system described above. For example, for a database driven system, this might be an SQL query; for an API-integrated system, this may be a request for an API call.

In operation S630, a plurality of parameter values to be checked are obtained from the plurality of business systems to be checked using the query request.

Referring back to fig. 2, in operation S250, consistency judgment is performed on the plurality of parameter values to be checked, and a parameter checking result is obtained.

In the embodiment of the invention, since the parameter values of different systems do not necessarily have strong consistency (for example, the parameter value is harbor, corresponding to 01 in the system a and corresponding to HK in the system B due to inconsistent dictionary configuration of different systems), consistency judgment can be dynamically realized by a rule engine (qlexpress), a decision engine (DMN) and the like.

As shown in fig. 7, the method for performing consistency determination on a plurality of parameter values to be checked according to this embodiment may include operations S710 to S720.

In operation S710, a consistency rule for parameter value comparison to be checked is defined based on a rule engine or a decision engine.

In embodiments of the present invention, the following consistency rules may be defined based on a rules engine or decision engine, for example: an equality check, a rule may be defined to check if the values of the same parameters in both systems are exactly equal; thresholds and tolerances, in some cases, tolerance ranges may be defined, particularly for parameter values involving estimation or calculation; special condition processing, defining definite processing rules for special conditions (such as missing data and abnormal values); time sensitivity, defining a time-dependent consistency rule for a time-varying parameter, e.g. comparing only recently updated data; business rules, consider business logic, e.g., certain parameters need to be checked only under certain conditions, etc.

In operation S720, consistency judgment is performed on the plurality of parameter values to be checked by using the consistency rule, so as to obtain the parameter checking result.

In addition, in order to ensure the real-time consistency of the data and improve the flexibility and accuracy of the whole checking operation, the embodiment of the invention also provides a dynamic result display method.

As shown in fig. 8, the method for dynamic result presentation of this embodiment may include operations S810 to S830.

In operation S810, a dynamic parameter value table is created based on the parameters to be checked, the query conditions, the plurality of business systems to be checked, and the parameter check results.

In an embodiment of the invention, the dynamic parameter value table is a data structure for recording, tracking and updating parameter values in the business system to be checked. The table contains parameter values from each service system, and the parameter values are acquired from each system based on defined query conditions; in addition to the parameter values, the table also records the results of parameter checks, such as whether the parameter values are consistent across different systems, or whether predetermined consistency rules are met.

In operation S820, the operations of acquiring the parameters to be checked and the check range, generating the query condition, acquiring the plurality of parameter values to be checked and the consistency judgment are re-performed at preset time intervals, and the dynamic parameter check result is acquired.

In operation S830, the dynamic parameter value table is updated based on the dynamic parameter check result.

In an embodiment of the present invention, the table may be updated periodically to reflect the latest data state, wherein it may be implemented by periodically performing a collation operation and updating the table based on the new collation result.

In the embodiment of the present invention, taking the above checking process that needs to check whether the net value of all active stock-type funds is consistent as an example, the query condition may be a fund code, an evaluation date, and the query result is the net value of the fund; the service system is set as an A system and a B system. An example of a dynamic parameter value table is given in table 1 below:

Table 1 dynamic parameter value table example

According to the parameter checking method provided by the invention, the checking operation can be executed in batches by acquiring the parameter value of the business system to be checked according to the corresponding parameter value acquisition mode, repeated work of a single task is reduced, the checking process can be ensured to be concentrated on related data points by generating the query condition, and unnecessary data processing is avoided, so that the calculation speed of a computer is improved; meanwhile, by using a computer program and an automatic process, the parameter checking task can be rapidly and accurately executed, and the complicated and potential errors of manual operation are avoided, so that the user experience is improved.

Specifically, the following beneficial effects are brought:

1. The values of the same parameters are compared across a plurality of systems, so that the consistency of data among different systems is effectively ensured, the possibility of data errors and inconsistency is reduced in a periodical and systematic checking process, and the overall data quality is improved;

2. most of checking work is allowed to be automatically carried out, the requirement of manual operation is reduced, the efficiency is improved, the checking flow of automatic and timing execution ensures that data is always up to date, and meanwhile, the requirement of manually updating the data is reduced;

3. The system can adapt to various different data sources and systems, namely, adapt to various environments, and can correspondingly expand with the development of business and the increase of the data sources so as to contain more data and systems;

4. the dynamic parameter value table provides a centralized data storage and access point, reduces the need for repeated inquiry of a plurality of systems, and thereby optimizes the overall calculation performance;

5. the automated process can discover and respond to data inconsistency problems faster, reducing the manual inspection effort and potential errors.

Based on the parameter checking method, the invention also provides a parameter checking device. The device will be described in detail below in connection with fig. 9.

As shown in fig. 9, the parameter collation apparatus 900 according to this embodiment includes a collation parameter and range acquisition module 910, a query condition generation module 920, a business system to be collated acquisition module 930, a parameter value to be collated acquisition module 940, and a consistency judgment module 950.

The verification parameter and range obtaining module 910 may be configured to obtain a parameter to be verified and a verification range, where the verification range includes N pieces of verification task data, and N is a positive integer. In an embodiment, the verification parameter and range obtaining module 910 may be configured to perform the operation S210 described above, which is not described herein.

The query condition generating module 920 may be configured to generate a query condition for each piece of data in the N pieces of verification task data based on the parameter to be verified, where the query condition is used to uniquely determine a parameter value of the corresponding piece of data. In an embodiment, the query condition generating module 920 may be configured to perform the operation S220 described above, which is not described herein.

The service system to be checked acquisition module 930 may be configured to acquire a plurality of service systems to be checked and parameter value acquisition manners corresponding to the plurality of service systems to be checked. In an embodiment, the to-be-checked business system obtaining module 930 may be configured to perform the operation S230 described above, which is not described herein.

The parameter value to be checked obtaining module 940 may be configured to obtain a plurality of parameter values to be checked from the plurality of service systems to be checked by using the query condition and the parameter value obtaining mode. In an embodiment, the parameter value to be checked obtaining module 940 may be configured to perform the operation S240 described above, which is not described herein.

The consistency judging module 950 may be configured to perform consistency judgment on the parameter values to be checked, and obtain a parameter checking result. In an embodiment, the consistency determination module 950 may be configured to perform the operation S250 described above, which is not described herein.

According to an embodiment of the present invention, the query condition generation module 920 may include a traversal unit and a query condition generation unit.

The traversing unit may be configured to traverse the N pieces of collation task data, and process each piece of data one by one, where for each piece of data: extracting a checking parameter value of each piece of data based on the parameters to be checked; generating M query terms by using the check parameter values, wherein M is a positive integer greater than or equal to 0; when M is not 0, the query condition is formed based on the query term. In an embodiment, the traversing unit may be configured to perform the operation S310 described above, which is not described herein.

The query condition generating unit may be configured to generate a query condition for each of the N pieces of collation task data in response to completion of the traversal, and store the query condition in a temporary array or list. In an embodiment, the query condition generating unit may be configured to perform the operation S320 described above, which is not described herein.

According to an embodiment of the present invention, the service system obtaining module 930 to be checked may include a service system type obtaining unit and a parameter value obtaining mode configuration module.

The service system type obtaining unit may be configured to obtain the type of the service system to be checked by analyzing a parameter configuration interface or a database table description document of the service system to be checked. In an embodiment, the service system type obtaining unit may be configured to perform the operation S410 described above, which is not described herein.

The parameter value acquisition mode configuration module may be configured to configure the parameter value acquisition mode based on the type of the service system to be checked. In an embodiment, the parameter value obtaining manner configuration module may be configured to perform the operation S420 described above, which is not described herein.

According to an embodiment of the present invention, the parameter value obtaining manner configuration module may include an SQL query unit, an API interface unit, or a custom code unit.

The constructing the SQL query unit may be configured to configure the parameter value acquisition mode for the database driving system, including constructing the SQL query. In an embodiment, the constructing SQL query unit may be used to perform the operation S510 described above, which is not described herein.

The calling API interface unit may be configured to configure the parameter value acquisition manner for an API integration system, including calling an API interface. In an embodiment, the calling API interface unit may be configured to perform the operation S520 described above, which is not described herein.

The executing custom code unit may be configured to configure the parameter value acquisition means for a customization system including executing custom code based on internal logic of the customization system. In an embodiment, the executing custom code unit may be used to execute the operation S530 described above, which is not described herein.

According to an embodiment of the present invention, the parameter value obtaining module 940 to be checked may include a target query condition selecting unit, a query request constructing unit, and a parameter value obtaining unit.

The target query condition selection unit may be configured to select a target query condition based on the temporary array or list. In an embodiment, the target query condition selection unit may be configured to perform the operation S610 described above, which is not described herein.

The query request construction unit may be configured to construct a query request based on the target query condition and the parameter value acquisition manner. In an embodiment, the query request building unit may be configured to perform the operation S620 described above, which is not described herein.

The parameter value obtaining unit may be configured to obtain a plurality of parameter values to be checked from the plurality of service systems to be checked by using the query request. In an embodiment, the parameter value obtaining unit may be configured to perform the operation S630 described above, which is not described herein.

According to an embodiment of the present invention, the consistency judging module 950 may include a definition unit and a parameter check result obtaining unit.

The definition unit may be configured to define a consistency rule for comparing parameter values to be checked based on a rule engine or a decision engine. In an embodiment, the defining unit may be configured to perform the operation S710 described above, which is not described herein.

The parameter checking result obtaining unit may be configured to perform consistency judgment on the plurality of parameter values to be checked by using the consistency rule, to obtain the parameter checking result. In an embodiment, the parameter verification result obtaining unit may be configured to perform the operation S720 described above, which is not described herein.

According to an embodiment of the present invention, the parameter checking apparatus 900 may further include a dynamic result display module.

According to an embodiment of the present invention, the dynamic result presentation module may include a dynamic parameter value table creation unit, a re-execution unit, and an update unit.

The dynamic parameter value table creation unit may be configured to create a dynamic parameter value table based on the parameters to be checked, the query conditions, the plurality of business systems to be checked, and the parameter check result. In an embodiment, the dynamic parameter value table creating unit may be configured to perform the operation S810 described above, which is not described herein.

The re-execution unit may be configured to re-execute operations of acquiring parameters to be checked and a checking range, generating a query condition, acquiring a plurality of parameter values to be checked and consistency judgment according to a preset time interval, and acquiring a dynamic parameter checking result. In an embodiment, the re-executing unit may be configured to execute the operation S820 described above, which is not described herein.

The updating unit may be configured to update the dynamic parameter value table based on the dynamic parameter collation result. In an embodiment, the updating unit may be configured to perform the operation S830 described above, which is not described herein.

Any of the collation parameter and range acquisition module 910, the inquiry condition generation module 920, the business system to be collated acquisition module 930, the parameter value to be collated acquisition module 940 and the consistency judgment module 950 may be incorporated in one module to be implemented, or any of them may be split into a plurality of modules, according to an embodiment of the present invention. Or at least some of the functionality of one or more of the modules may be combined with, and implemented in, at least some of the functionality of other modules. According to embodiments of the present disclosure, at least one of the collation parameter and range acquisition module 910, the query condition generation module 920, the business system to be collated acquisition module 930, the parameter value to be collated acquisition module 940 and the consistency determination module 950 may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or in hardware or firmware in any other reasonable manner of integrating or packaging the circuitry, or in any one of or a suitable combination of any of the three implementations of software, hardware and firmware. Or at least one of the collation parameter and range acquisition module 910, the inquiry condition generation module 920, the business system to be collated acquisition module 930, the parameter value to be collated acquisition module 940 and the consistency judgment module 950 may be at least partially implemented as a computer program module which, when executed, may perform the corresponding functions.

As shown in fig. 10, an electronic device 1000 according to an embodiment of the present invention includes a processor 1001 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 1002 or a program loaded from a storage section 1008 into a Random Access Memory (RAM) 1003. The processor 1001 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. The processor 1001 may also include on-board memory for caching purposes. The processor 1001 may include a single processing unit or a plurality of processing units for performing different actions of the method flow according to an embodiment of the invention.

In the RAM 1003, various programs and data necessary for the operation of the electronic apparatus 1000 are stored. The processor 1001, the ROM 1002, and the RAM 1003 are connected to each other by a bus 1004. The processor 1001 performs various operations of the method flow according to the embodiment of the present invention by executing programs in the ROM 1002 and/or the RAM 1003. Note that the program may be stored in one or more memories other than the ROM 1002 and the RAM 1003. The processor 1001 may also perform various operations of the method flow according to an embodiment of the present invention by executing programs stored in the one or more memories.

According to an embodiment of the invention, the electronic device 1000 may further comprise an input/output (I/O) interface 1005, the input/output (I/O) interface 1005 also being connected to the bus 1004. The electronic device 1000 may also include one or more of the following components connected to the I/O interface 1005: an input section 1006 including a keyboard, a mouse, and the like; an output portion 1007 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), etc., and a speaker, etc.; a storage portion 1008 including a hard disk or the like; and a communication section 1009 including a network interface card such as a LAN card, a modem, or the like. The communication section 1009 performs communication processing via a network such as the internet. The drive 1010 is also connected to the I/O interface 1005 as needed. A removable medium 1011, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like, is installed as needed in the drive 1010, so that a computer program read out therefrom is installed as needed in the storage section 1008.

The present invention also provides a computer-readable storage medium that may be embodied in the apparatus/device/system described in the above embodiments; or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present invention.

According to embodiments of the present invention, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the invention, the computer-readable storage medium may include ROM 1002 and/or RAM 1003 described above and/or one or more memories other than ROM 1002 and RAM 1003.

Embodiments of the present invention also include a computer program product comprising a computer program containing program code for performing the method shown in the flowcharts. The program code means for causing a computer system to carry out the methods provided by embodiments of the present invention when the computer program product is run on the computer system.

The above-described functions defined in the system/apparatus of the embodiment of the present invention are performed when the computer program is executed by the processor 1001. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the invention.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted in the form of signals on a network medium, distributed, and downloaded and installed via the communication section 1009, and/or installed from the removable medium 1011. The computer program may include program code that may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In such an embodiment, the computer program may be downloaded and installed from a network via the communication portion 1009, and/or installed from the removable medium 1011. The above-described functions defined in the system of the embodiment of the present invention are performed when the computer program is executed by the processor 1 001. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the invention.

According to embodiments of the present invention, program code for carrying out computer programs provided by embodiments of the present invention may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or in assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The embodiments of the present invention are described above. These examples are for illustrative purposes only and are not intended to limit the scope of the present invention. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the invention, and such alternatives and modifications are intended to fall within the scope of the invention.

Claims

1. A method of parameter verification, the method comprising:

obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer;

Generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data;

acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked;

Acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and

And carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result.

2. The method according to claim 1, wherein generating a query condition for each piece of the N pieces of collation task data based on the parameter to be collated, specifically comprises:

Traversing the N pieces of check task data, processing each piece of data one by one,

Wherein, for each piece of data: extracting a checking parameter value of each piece of data based on the parameters to be checked; generating M query terms by using the check parameter values, wherein M is a positive integer greater than or equal to 0; when M is not 0, forming the query condition based on the query term; and

And generating a query condition for each piece of data in the N pieces of check task data in response to the completion of the traversal, and storing the query condition in a temporary array or list.

3. The method according to claim 2, wherein when M is 0, the query condition is formed based on a collation parameter value, identifier or primary key of the corresponding collation task data.

4. A method according to claim 2 or 3, wherein the obtaining a plurality of service systems to be checked and parameter value obtaining manners corresponding to the plurality of service systems to be checked specifically includes:

acquiring the type of the business system to be checked by analyzing a parameter configuration interface or a database table description document of the business system to be checked; and

And configuring the parameter value acquisition mode based on the type of the service system to be checked.

5. The method of claim 4, wherein the configuring the parameter value obtaining manner based on the type of the service system to be checked specifically includes:

for a database driving system, configuring the parameter value acquisition mode comprises constructing SQL query;

for an API integrated system, configuring the parameter value acquisition mode comprises calling an API interface; or (b)

For a customization system, configuring the parameter value acquisition mode includes executing custom code based on internal logic of the customization system.

6. The method according to claim 5, wherein the obtaining a plurality of parameter values to be checked from the plurality of business systems to be checked by using the query condition and the parameter value obtaining manner specifically includes:

Selecting a target query condition based on the temporary array or list;

Constructing a query request based on the target query condition and the parameter value acquisition mode; and

And acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query request.

7. The method according to any one of claims 1 to 3 and 5 to 6, wherein the step of performing consistency judgment on the plurality of parameter values to be checked to obtain a parameter check result specifically includes:

defining consistency rules of parameter value comparison to be checked based on a rule engine or a decision engine; and

And carrying out consistency judgment on the plurality of parameter values to be checked by utilizing the consistency rule, and obtaining the parameter checking result.

8. The method according to any one of claims 2-3, 5-6, further comprising:

creating a dynamic parameter value table based on the parameters to be checked, the query conditions, the plurality of business systems to be checked and the parameter check results;

Re-executing the operations of acquiring parameters to be checked and checking ranges, generating inquiry conditions, acquiring a plurality of parameter values to be checked and consistency judgment according to preset time intervals, and acquiring a dynamic parameter checking result; and

And updating the dynamic parameter value table based on the dynamic parameter checking result.

9. A parameter verification apparatus, the apparatus comprising:

The checking parameter and range acquisition module is used for: obtaining parameters to be checked and a checking range, wherein the checking range comprises N pieces of checking task data, and N is a positive integer;

The query condition generation module is used for: generating a query condition for each piece of data in the N pieces of check task data based on the parameters to be checked, wherein the query condition is used for uniquely determining the parameter value of the corresponding data;

the business system to be checked acquisition module is used for: acquiring a plurality of business systems to be checked and a parameter value acquisition mode corresponding to the business systems to be checked;

the parameter value obtaining module to be checked is used for: acquiring a plurality of parameter values to be checked from the plurality of business systems to be checked by utilizing the query conditions and the parameter value acquisition mode; and

The consistency judging module is used for: and carrying out consistency judgment on the plurality of parameter values to be checked to obtain a parameter checking result.

10. An electronic device, comprising:

One or more processors;

Storage means for storing one or more programs,

Wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-8.

11. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the method according to any of claims 1-8.

12. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 8.