Account reconciliation monitoring method, device, equipment and medium

Abstract

The present invention relates to the technical field of data security monitoring, and discloses a reconciliation monitoring method, including: obtaining a reconciliation monitoring instruction; matching the reconciliation monitoring instruction with a reconciliation monitoring instruction script of a preset database to generate a reconciliation monitoring processing script; configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script; and executing the corresponding reconciliation data monitoring in the preset database according to the target reconciliation monitoring processing script to obtain a reconciliation data monitoring result. The present invention also relates to blockchain technology, and the reconciliation monitoring instruction can be deployed in a blockchain node. The present invention can realize the configurability of reconciliation monitoring.

Description

Technical Field

[0001] The present invention relates to the field of data security monitoring technology, and in particular to a method, device, electronic device and computer-readable storage medium for reconciliation monitoring. Background Art

[0002] Account reconciliation monitoring refers to the process of automatic data checking in the financial field to ensure the accuracy and reliability of data during data accounting. Currently, account reconciliation monitoring is used in many industries, such as securities, stocks, and funds.

[0003] However, there are currently the following disadvantages with reconciliation monitoring: it can only be applied to fixed business scenarios. For example, for fund reconciliation, there is a corresponding fund reconciliation monitoring module. If a new business is added, such as share reconciliation monitoring, a new share reconciliation monitoring module needs to be developed. Each time a new business is added, a new module needs to be developed, resulting in poor configurability of reconciliation monitoring. At the same time, each business development requires time and manpower costs. Summary of the invention

[0004] The present invention provides a method, device, electronic device and computer-readable storage medium for reconciliation monitoring, the main purpose of which is to achieve configurability of reconciliation monitoring.

[0005] To achieve the above object, the present invention provides a reconciliation monitoring method, comprising:

[0006] Obtain reconciliation monitoring instructions;

[0007] Matching the reconciliation monitoring instruction with the reconciliation monitoring instruction script in a preset database to generate a reconciliation monitoring processing script;

[0008] Configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;

[0009] According to the target reconciliation monitoring processing script, the corresponding reconciliation data monitoring in the preset database is executed to obtain the reconciliation data monitoring result.

[0010] Optionally, before obtaining the reconciliation monitoring instruction, the method further includes:

[0011] When at least one initial reconciliation monitoring instruction to be processed is received, the format of the initial reconciliation monitoring instruction is parsed to obtain a standard reconciliation monitoring instruction, and the standard reconciliation monitoring instruction is verified, and the initial reconciliation monitoring instruction that succeeds in verification is selected as the reconciliation monitoring instruction.

[0012] Optionally, verifying the standard reconciliation monitoring instruction includes:

[0013] Obtaining the assembly code of the standard reconciliation monitoring instruction;

[0014] Parsing the instruction address in the assembly code and obtaining the first field attribute of the instruction address;

[0015] Acquire source data in a corresponding database according to the instruction address, and acquire a second field attribute of the source data;

[0016] The matching degree between the first field attribute and the second field attribute is calculated, and the verification result of the standard reconciliation monitoring instruction is identified according to the matching degree.

[0017] Optionally, matching the account reconciliation monitoring instruction with an account reconciliation monitoring instruction script in a preset database includes:

[0018] Calculate the hash value of the reconciliation monitoring instruction and determine the pointer of the hash value; query the first id of the reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer; map the length of the first id to obtain the first index value of the reconciliation monitoring instruction script; and determine the first offset value of the movable position of the first index value by using a preset offset value function;

[0019] Obtaining a second id of the reconciliation monitoring instruction script, mapping the length of the second id to obtain a second index value of the reconciliation monitoring instruction script, and using the preset offset value function to determine a second offset value of a movable position of the second index value;

[0020] The similarity between the first offset value and the second offset value is calculated, and based on the similarity, the reconciliation monitoring instruction is matched with the reconciliation monitoring instruction script of the preset database to generate the reconciliation monitoring processing script.

[0021] Optionally, calculating the similarity between the first offset value and the second offset value includes:

[0022] The similarity between the first offset value and the second offset value is calculated using the following formula:

[0023]

[0024] Wherein, T(x,y) represents the similarity, x i represents the first offset value, y i represents the second offset value.

[0025] Optionally, configuring the business logic of the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:

[0026] Configuring the compilation environment of the reconciliation monitoring script;

[0027] The configuration file of the business logic is obtained, and the configuration file is compiled using a preset compiler, and the compiled configuration file is imported into the compilation environment and run to generate the target reconciliation monitoring processing script.

[0028] In order to solve the above problem, the present invention further provides an account reconciliation monitoring device, the device comprising:

[0029] The acquisition module is used to obtain the reconciliation monitoring instructions;

[0030] A matching module, used to match the reconciliation monitoring instruction with the reconciliation monitoring instruction script in a preset database to generate a reconciliation monitoring processing script;

[0031] A configuration module, used to configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;

[0032] An execution module is used to execute the corresponding reconciliation data monitoring in the preset database according to the target reconciliation monitoring processing script to obtain the reconciliation data monitoring result.

[0033] Optionally, the configuration module includes:

[0034] A compilation submodule, used to configure the compilation environment of the reconciliation monitoring script, obtain the configuration file of the business logic, and compile the configuration file using a preset compilation program;

[0035] The generation submodule is used to import the compiled configuration file into the compilation environment and run it to generate the target reconciliation monitoring processing script.

[0036] In order to solve the above problem, the present invention further provides an electronic device, the electronic device comprising:

[0037] a memory storing at least one instruction; and

[0038] The processor executes the instructions stored in the memory to implement the reconciliation monitoring method described above.

[0039] In order to solve the above problem, the present invention also provides a computer-readable storage medium, in which at least one instruction is stored. The at least one instruction is executed by a processor in an electronic device to implement the reconciliation monitoring method described above.

[0040] The embodiment of the present invention performs format parsing on the acquired reconciliation monitoring instructions to obtain standard reconciliation monitoring instructions, matches the standard reconciliation monitoring instructions with the reconciliation monitoring instruction script of the preset database, generates a reconciliation monitoring processing script, and implements the corresponding reconciliation data monitoring in the database according to the generated reconciliation monitoring processing script; secondly, the embodiment of the present invention configures the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script, thereby realizing the configurability of reconciliation monitoring, thereby reducing manpower and time costs; further, the embodiment of the present invention executes the corresponding reconciliation data monitoring in the database according to the target reconciliation monitoring processing script to obtain a reconciliation data monitoring result. Therefore, a reconciliation monitoring method, device, electronic device, and computer-readable storage medium proposed by the present invention can realize the configurability of reconciliation monitoring. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 A schematic diagram of a flow chart of a method for monitoring reconciliation provided in a first embodiment of the present invention;

[0042] Figure 2 A schematic diagram of a flow chart of a standard reconciliation monitoring instruction verification method provided by a second embodiment of the present invention;

[0043] Figure 3 In the first embodiment of the present invention Figure 1 A flowchart of step S2 of the provided reconciliation monitoring method;

[0044] Figure 4 A schematic diagram of modules of the account reconciliation monitoring device provided in the first embodiment of the present invention;

[0045] Figure 5 A schematic diagram of the internal structure of an electronic device for implementing the account reconciliation monitoring method provided by the first embodiment of the present invention;

[0046] The realization of the purpose, functional features and advantages of the present invention will be further explained by integrating embodiments with reference to the accompanying drawings. DETAILED DESCRIPTION

[0047] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.

[0048] The execution subject of the reconciliation monitoring method provided in the embodiment of the present application includes but is not limited to at least one of the electronic devices such as a server and a terminal that can be configured to execute the method provided in the embodiment of the present application. In other words, the reconciliation monitoring method can be executed by software or hardware installed in a terminal device or a server device, and the software can be a blockchain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, etc.

[0049] The present invention provides a method for monitoring reconciliation. Figure 1 FIG. 1 is a flow chart of a method for monitoring reconciliation provided by an embodiment of the present invention. The method may be performed by a device, and the device may be implemented by software and / or hardware.

[0050] In this embodiment, the method for reconciliation monitoring includes:

[0051] S1. Obtain reconciliation monitoring instructions.

[0052] In at least one embodiment of the present invention, the reconciliation monitoring instruction is used to query whether the stored data in the database is consistent with the business data generated by the corresponding actual scenario. The reconciliation monitoring instruction can be initiated by the front-end system, or it can be initiated by the user based on the actual business scenario. For example, the reconciliation monitoring instruction can be: fund reconciliation instructions, salary reconciliation instructions, and project payment reconciliation instructions, etc., which are not limited here. It should be emphasized that in order to further ensure the privacy and security of the above-mentioned reconciliation monitoring instructions, the above-mentioned reconciliation monitoring instructions can also be stored in a node of a blockchain.

[0053] Furthermore, in another optional embodiment of the present invention, before obtaining the reconciliation monitoring instruction, it also includes: when at least one initial reconciliation monitoring instruction to be processed is received, the format of the initial reconciliation monitoring instruction is parsed to obtain a standard reconciliation monitoring instruction, and the standard reconciliation monitoring instruction is verified, and the initial reconciliation monitoring instruction that has successfully been verified is selected as the reconciliation monitoring instruction. Through the verification, a large number of useless initial reconciliation monitoring instructions can be deleted to improve the timeliness of subsequent reconciliation data monitoring.

[0054] In one embodiment of the present invention, the at least one initial reconciliation monitoring instruction is format parsed, that is, the format of the initial reconciliation monitoring instruction is converted into a json (JavaScript Object Notation) format. The json format refers to a lightweight data exchange format that facilitates data reading and understanding.

[0055] In an optional embodiment, the format of the initial reconciliation monitoring instruction is converted into json format using the following method:

[0056] JSONObject getJSONObject(Instruct name){}->JSONObject paramzObject=rootObject.getJSONObject("paramz").

[0057] For details, see Figure 2 As shown, the verification of the standard reconciliation monitoring instruction includes:

[0058] S10. Obtain the assembly code of the standard reconciliation monitoring instruction.

[0059] The substantial content of the standard reconciliation monitoring instruction is binary data composed of 0 and 1, which is essentially a machine code. Since the machine code is not easily recognized by a computer, the embodiment of the present invention utilizes the Java language to compile the assembly code of the standard reconciliation monitoring instruction to generate the assembly code of the standard reconciliation monitoring instruction.

[0060] S11. Parse the instruction address in the assembly code and obtain the first field attribute of the instruction address.

[0061] In an optional embodiment, the href tag is called to parse the instruction address in the assembly code, that is, the url, and the reference method is used to obtain the first field attribute of the instruction address, wherein the first field attribute includes: field name, table name, and ID, etc.

[0062] S12. Acquire source data in a corresponding database according to the instruction address, and acquire a second field attribute of the source data.

[0063] Optionally, the present invention uses a SQL statement to obtain source data in a corresponding database according to the instruction address, and uses a get() function to obtain a second field attribute of the source data, wherein the second field attribute includes: field name, column name, table name, etc.

[0064] S13. Calculate the matching degree between the first field attribute and the second field attribute, and identify the verification result of the initial reconciliation monitoring instruction according to the matching degree.

[0065] In an optional embodiment, the matching degree between the first field attribute and the second field attribute is calculated using a currently known Euclidean distance formula.

[0066] Further, the identifying the verification result of the initial account reconciliation monitoring instruction according to the matching degree includes:

[0067] If the matching degree is less than the preset threshold, it means that the initial account reconciliation monitoring instruction verification has failed. If the matching degree is not less than the preset threshold, it means that the initial account reconciliation detection instruction verification has succeeded.

[0068] Optionally, the preset threshold is 0.6.

[0069] S2. Match the account reconciliation monitoring instruction with the account reconciliation monitoring instruction script in a preset database to generate an account reconciliation monitoring processing script.

[0070] Another embodiment of the present invention includes: storing the reconciliation monitoring instruction in a preset distributed storage function to quickly achieve subsequent matching with the reconciliation monitoring instruction script of a preset database.

[0071] Optionally, the preset distributed storage function is as follows:

[0072] instruct_id=(w1×(hash_str(instruction) / b1)+w2×(instruct_time(time) / b2))%Hash_Bucket

[0073] Among them, instruct_id represents the storage number of the target reconciliation monitoring instruction, hash_str(instruction) represents the object quantization function of the reconciliation monitoring instruction, and instruct_time(time) represents the time quantization function of the reconciliation monitoring instruction, b1 represents the dispersion degree of the object quantization function, b2 represents the dispersion degree of the time quantization function, w1 represents the coefficient of the object quantization function, and w2 represents the coefficient of the time quantization function.

[0074] Furthermore, the reconciliation monitoring instruction script is used to execute the monitoring of the reconciliation data in the database, and the reconciliation monitoring instruction script includes: a request parameter object (request) and a return parameter object (response).

[0075] The request object is the only legal way for the script program to obtain request data from the outside world. After parsing, a request message will be converted into a logical object request of the Service Request type. The request object may include user_id, req_seq, state, message, time_stamp, datas and other fields. Except for the user_id field, other fields are copied from the request message as is, except for the user_id field in the request message, whose user information type is User, and its content is the entity object of the user corresponding to the user_id.

[0076] The response object is the only legal way for the script to return information to the outside world. The response object also includes fields such as user_id, req_seq, state, message, time_stamp, datas, etc. Among them, req_seq is a read-only field written by the reconciliation monitoring command script engine before entering the reconciliation monitoring command script, and time_stamp is automatically filled in by the system according to the current time after exiting the reconciliation monitoring command script. The remaining values ​​need to be written by the writer during the running of the reconciliation monitoring command script.

[0077] Optionally, the preset database is a relational database, such as an Oracle database.

[0078] In an optional embodiment, a preset multi-mode matching algorithm is used to match the reconciliation monitoring instruction with the reconciliation monitoring instruction script in a preset database to generate a reconciliation monitoring processing script. The reconciliation monitoring processing script is used to perform the reconciliation data monitoring required for the reconciliation monitoring instruction. For example, if the reconciliation monitoring instruction is salary reconciliation monitoring, the reconciliation monitoring processing script performs the monitoring of salary reconciliation.

[0079] Optionally, the preset multi-mode matching algorithm includes: a Shift function and a Hash function. The Shift function is used to characterize the shift value of the data, and the range of the data to be matched can be determined according to the shift value. The Hash function is used to convert an input of any length into an output of a fixed length through hashing.

[0080] For details, see Figure 3 As shown, the preset multi-mode matching algorithm matches the account reconciliation monitoring instruction with the account reconciliation monitoring instruction script of the preset database, including:

[0081] S20. Calculate the hash value of the reconciliation monitoring instruction using the Hash function, and determine a pointer to the hash value; query the first id of the reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction based on the pointer; map the length of the first id to obtain the first index value of the reconciliation monitoring instruction script; and determine the first offset value of the movable position of the first index value using the Shift function.

[0082] S21. Obtain the second id of the reconciliation monitoring instruction script, map the length of the second id, obtain the second index value of the reconciliation monitoring instruction script, and use the Shift function to determine the second offset value of the movable position of the second index value.

[0083] S22. Calculate the similarity between the first offset value and the second offset value, and based on the similarity, match the reconciliation monitoring instruction with the reconciliation monitoring instruction script in the preset database to generate the reconciliation monitoring processing script.

[0084] In an optional embodiment, the similarity between the first offset value and the second offset value is calculated using the following method:

[0085]

[0086] Wherein, T(x,y) represents the similarity, x i Indicates the first offset value, y i represents the second offset value.

[0087] Furthermore, performing matching of the account reconciliation monitoring instruction with an account reconciliation monitoring instruction script in a preset database according to the similarity includes:

[0088] If the similarity is less than the preset similarity threshold, it means that the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database fail to match and are marked; if the similarity is not less than the preset similarity threshold, it means that the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database match successfully and generate a corresponding reconciliation detection processing script.

[0089] S3. Configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script.

[0090] Since the reconciliation monitoring processing script generated above can only execute the corresponding reconciliation data monitoring and cannot meet the needs of multi-module or multi-type data monitoring, the embodiment of the present invention configures the business logic of the reconciliation monitoring processing script to obtain the target reconciliation monitoring processing script, thereby realizing the configurability of reconciliation monitoring and reducing manpower and time costs.

[0091] Furthermore, the business logic of configuring the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:

[0092] Configure the compilation environment of the reconciliation monitoring script, obtain the configuration file of the business logic, compile the configuration file using a preset compiler, import the compiled configuration file into the compilation environment and run it to generate the target reconciliation monitoring processing script.

[0093] Optionally, Myeclipse is used to configure the compilation environment, the preset compilation program is compiled by Java language, and the configuration file includes: attributes of business logic, annotation content of business logic, and configuration item content of business logic.

[0094] S4. According to the target reconciliation monitoring processing script, the corresponding reconciliation data monitoring in the preset database is executed to obtain the reconciliation data monitoring result.

[0095] For example, if the target reconciliation monitoring processing script is a cmp script, the data transmitted by the external system will be compared with the corresponding reconciliation data in the database, such as salary reconciliation; if the target reconciliation monitoring processing script is a verify script, the data generated in the execution system will be compared with the corresponding reconciliation data in the database, such as fund reconciliation; if the target reconciliation monitoring processing script is an exception script, the daily data changes of the corresponding reconciliation data in the database will be monitored, such as project payment reconciliation.

[0096] Furthermore, another embodiment of the embodiment of the present invention also includes: transmitting the monitoring result of the reconciliation data to a front-end page for display, so as to intuitively and clearly understand the monitoring result of the reconciliation data.

[0097] The embodiment of the present invention performs format parsing on the acquired reconciliation monitoring instruction to obtain a standard reconciliation monitoring instruction, matches the standard reconciliation monitoring instruction with the reconciliation monitoring instruction script of the preset database, generates a reconciliation monitoring processing script, and implements the corresponding reconciliation data monitoring in the database according to the generated reconciliation monitoring processing script; secondly, the embodiment of the present invention configures the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script, thereby realizing the configurability of reconciliation monitoring, thereby reducing manpower and time costs; further, the embodiment of the present invention executes the corresponding reconciliation data monitoring in the database according to the target reconciliation monitoring processing script to obtain a reconciliation data monitoring result. Therefore, a reconciliation monitoring method proposed by the present invention can realize the configurability of reconciliation monitoring.

[0098] like Figure 4 FIG. 1 is a schematic diagram of a module of a reconciliation monitoring device provided in one embodiment of the present invention.

[0099] The reconciliation monitoring device 100 of the present invention can be installed in an electronic device. According to the functions to be implemented, the reconciliation monitoring device can include an acquisition module 101, a matching module 102, a configuration module 103 and an execution module 104. The module of the present invention can also be called a unit, which refers to a series of computer program segments that can be executed by an electronic device processor and can complete fixed functions, which are stored in the memory of the electronic device.

[0100] In this embodiment, the functions of each module / unit are as follows:

[0101] The acquisition module 101 is used to acquire an account reconciliation monitoring instruction.

[0102] In at least one embodiment of the present invention, the reconciliation monitoring instruction is used to query whether the stored data in the database is consistent with the business data generated by the corresponding actual scenario. The reconciliation monitoring instruction can be initiated by the front-end system, or it can be initiated by the user based on the actual business scenario. For example, the reconciliation monitoring instruction can be: fund reconciliation instructions, salary reconciliation instructions, and project payment reconciliation instructions, etc., which are not limited here. It should be emphasized that in order to further ensure the privacy and security of the above-mentioned reconciliation monitoring instructions, the above-mentioned reconciliation monitoring instructions can also be stored in a node of a blockchain.

[0103] Furthermore, in another optional embodiment of the present invention, before obtaining the reconciliation monitoring instruction, it also includes: when at least one initial reconciliation monitoring instruction to be processed is received, the format of the initial reconciliation monitoring instruction is parsed to obtain a standard reconciliation monitoring instruction, and the standard reconciliation monitoring instruction is verified, and the initial reconciliation monitoring instruction that has successfully been verified is selected as the reconciliation monitoring instruction. Through the verification, a large number of useless initial reconciliation monitoring instructions can be deleted to improve the timeliness of subsequent reconciliation data monitoring.

[0104] In one embodiment of the present invention, the at least one initial reconciliation monitoring instruction is format parsed, that is, the format of the initial reconciliation monitoring instruction is converted into a json (JavaScript Object Notation) format. The json format refers to a lightweight data exchange format that facilitates data reading and understanding.

[0105] In an optional embodiment, the format of the initial reconciliation monitoring instruction is converted into json format using the following method:

[0106] JSONObject getJSONObject(Instruct name){}->JSONObject paramzObject=rootObject.getJSONObject("paramz").

[0107] For details, see Figure 2 As shown, the verification of the standard reconciliation monitoring instruction includes:

[0108] S10. Obtain the assembly code of the standard reconciliation monitoring instruction.

[0109] The substantial content of the standard reconciliation monitoring instruction is binary data composed of 0 and 1, which is essentially a machine code. Since the machine code is not easily recognized by a computer, the embodiment of the present invention utilizes the Java language to compile the assembly code of the standard reconciliation monitoring instruction to generate the assembly code of the standard reconciliation monitoring instruction.

[0110] S11. Parse the instruction address in the assembly code and obtain the first field attribute of the instruction address.

[0111] In an optional embodiment, the href tag is called to parse the instruction address in the assembly code, that is, the url, and the reference method is used to obtain the first field attribute of the instruction address, wherein the first field attribute includes: field name, table name, and ID, etc.

[0112] S12. Acquire source data in a corresponding database according to the instruction address, and acquire a second field attribute of the source data.

[0113] Optionally, the present invention uses a SQL statement to obtain source data in a corresponding database according to the instruction address, and uses a get() function to obtain a second field attribute of the source data, wherein the second field attribute includes: field name, column name, table name, etc.

[0114] S13. Calculate the matching degree between the first field attribute and the second field attribute, and identify the verification result of the initial reconciliation monitoring instruction according to the matching degree.

[0115] In an optional embodiment, the matching degree between the first field attribute and the second field attribute is calculated using a currently known Euclidean distance formula.

[0116] Further, the identifying the verification result of the initial account reconciliation monitoring instruction according to the matching degree includes:

[0117] If the matching degree is less than the preset threshold, it means that the initial account reconciliation monitoring instruction verification has failed. If the matching degree is not less than the preset threshold, it means that the initial account reconciliation detection instruction verification has succeeded.

[0118] Optionally, the preset threshold is 0.6.

[0119] The matching module 102 is used to match the account reconciliation monitoring instruction with the account reconciliation monitoring instruction script in a preset database to generate an account reconciliation monitoring processing script.

[0120] Another embodiment of the present invention includes: storing the reconciliation monitoring instruction in a preset distributed storage function to quickly achieve subsequent matching with the reconciliation monitoring instruction script of a preset database.

[0121] Optionally, the preset distributed storage function is as follows:

[0122] instruct_id=(w1×(hash_str(instruction) / b1)+w2×(instruct_time(time) / b2))%Hash_Bucket

[0123] Among them, instruct_id represents the storage number of the target reconciliation monitoring instruction, hash_str(instruction) represents the object quantization function of the reconciliation monitoring instruction, and instruct_time(time) represents the time quantization function of the reconciliation monitoring instruction, b1 represents the dispersion degree of the object quantization function, b2 represents the dispersion degree of the time quantization function, w1 represents the coefficient of the object quantization function, and w2 represents the coefficient of the time quantization function.

[0124] Furthermore, the reconciliation monitoring instruction script is used to execute the monitoring of the reconciliation data in the database, and the reconciliation monitoring instruction script includes: a request parameter object (request) and a return parameter object (response).

[0125] The request object is the only legal way for the script program to obtain request data from the outside world. After parsing, a request message will be converted into a logical object request of the Service Request type. The request object may include user_id, req_seq, state, message, time_stamp, datas and other fields. Except for the user_id field, other fields are copied from the request message as is, except for the user_id field in the request message, whose user information type is User, and its content is the entity object of the user corresponding to the user_id.

[0126] The response object is the only legal way for the script to return information to the outside world. The response object also includes fields such as user_id, req_seq, state, message, time_stamp, datas, etc. Among them, req_seq is a read-only field written by the reconciliation monitoring command script engine before entering the reconciliation monitoring command script, and time_stamp is automatically filled in by the system according to the current time after exiting the reconciliation monitoring command script. The remaining values ​​need to be written by the writer during the running of the reconciliation monitoring command script.

[0127] Optionally, the preset database is a relational database, such as an Oracle database.

[0128] In an optional embodiment, a preset multi-mode matching algorithm is used to match the reconciliation monitoring instruction with the reconciliation monitoring instruction script in a preset database to generate a reconciliation monitoring processing script. The reconciliation monitoring processing script is used to perform the reconciliation data monitoring required for the reconciliation monitoring instruction. For example, if the reconciliation monitoring instruction is salary reconciliation monitoring, the reconciliation monitoring processing script performs the monitoring of salary reconciliation.

[0129] Optionally, the preset multi-mode matching algorithm includes: a Shift function and a Hash function. The Shift function is used to characterize the shift value of the data, and the range of the data to be matched can be determined according to the shift value. The Hash function is used to convert an input of any length into an output of a fixed length through hashing.

[0130] For details, see Figure 3 As shown, the preset multi-mode matching algorithm matches the account reconciliation monitoring instruction with the account reconciliation monitoring instruction script of the preset database, including:

[0131] S20. Calculate the hash value of the reconciliation monitoring instruction using the Hash function, and determine a pointer to the hash value; query the first id of the reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction based on the pointer; map the length of the first id to obtain the first index value of the reconciliation monitoring instruction script; and determine the first offset value of the movable position of the first index value using the Shift function.

[0132] S21. Obtain the second id of the reconciliation monitoring instruction script, map the length of the second id, obtain the second index value of the reconciliation monitoring instruction script, and use the Shift function to determine the second offset value of the movable position of the second index value.

[0133] S22. Calculate the similarity between the first offset value and the second offset value, and based on the similarity, match the reconciliation monitoring instruction with the reconciliation monitoring instruction script in the preset database to generate the reconciliation monitoring processing script.

[0134] In an optional embodiment, the similarity between the first offset value and the second offset value is calculated using the following method:

[0135]

[0136] Wherein, T(x,y) represents the similarity, x i Indicates the first offset value, y i represents the second offset value.

[0137] Furthermore, performing matching of the account reconciliation monitoring instruction with an account reconciliation monitoring instruction script in a preset database according to the similarity includes:

[0138] If the similarity is less than the preset similarity threshold, it means that the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database fail to match and are marked; if the similarity is not less than the preset similarity threshold, it means that the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database match successfully and generate a corresponding reconciliation detection processing script.

[0139] The configuration module 103 is used to configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script.

[0140] Since the reconciliation monitoring processing script generated above can only execute the corresponding reconciliation data monitoring and cannot meet the needs of multi-module or multi-type data monitoring, the embodiment of the present invention configures the business logic of the reconciliation monitoring processing script to obtain the target reconciliation monitoring processing script, thereby realizing the configurability of reconciliation monitoring and reducing manpower and time costs.

[0141] Furthermore, the business logic of configuring the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:

[0142] The compiling submodule 1030 is used to configure the compiling environment of the reconciliation monitoring script, obtain the configuration file of the business logic, and compile the configuration file using a preset compiling program;

[0143] The generation submodule 1031 is used to import the configuration file into the compilation environment and run it to generate the target reconciliation monitoring processing script.

[0144] Optionally, Myeclipse is used to configure the compilation environment, the preset compilation program is compiled by Java language, and the configuration file includes: attributes of business logic, annotation content of business logic, and configuration item content of business logic.

[0145] The execution module 104 is used to execute the corresponding reconciliation data monitoring in the preset database according to the target reconciliation monitoring processing script to obtain the reconciliation data monitoring result.

[0146] For example, if the target reconciliation monitoring processing script is a cmp script, the data transmitted by the external system will be compared with the corresponding reconciliation data in the database, such as salary reconciliation; if the target reconciliation monitoring processing script is a verify script, the data generated in the execution system will be compared with the corresponding reconciliation data in the database, such as fund reconciliation; if the target reconciliation monitoring processing script is an exception script, the daily data changes of the corresponding reconciliation data in the database will be monitored, such as project payment reconciliation.

[0147] Furthermore, another embodiment of the embodiment of the present invention also includes: transmitting the monitoring result of the reconciliation data to a front-end page for display, so as to intuitively and clearly understand the monitoring result of the reconciliation data.

[0148] The embodiment of the present invention performs format parsing on the acquired reconciliation monitoring instruction to obtain the target reconciliation monitoring instruction, matches the target reconciliation monitoring instruction with the reconciliation monitoring instruction script of the preset database, generates a reconciliation monitoring processing script, and implements the corresponding reconciliation data monitoring in the database according to the generated reconciliation monitoring processing script; secondly, the embodiment of the present invention configures the business logic of the reconciliation monitoring processing script to obtain the target reconciliation monitoring processing script, thereby realizing the configurability of reconciliation monitoring, thereby reducing manpower and time costs; further, the embodiment of the present invention executes the corresponding reconciliation data monitoring in the database according to the target reconciliation monitoring processing script to obtain the reconciliation data monitoring result. Therefore, a reconciliation monitoring device proposed by the present invention can realize the configurability of reconciliation monitoring.

[0149] like Figure 5 , which is a schematic diagram of the structure of an electronic device for implementing a method for reconciliation monitoring provided by an embodiment of the present invention.

[0150] The electronic device 1 may include a processor 10, a memory 11 and a bus, and may also include a computer program stored in the memory 11 and executable on the processor 10, such as a reconciliation monitoring program.

[0151] The memory 11 includes at least one type of readable storage medium, and the readable storage medium includes a flash memory, a mobile hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a magnetic memory, a disk, an optical disk, etc. The memory 11 may be an internal storage unit of the electronic device 1 in some embodiments, such as a mobile hard disk of the electronic device 1. The memory 11 may also be an external storage device of the electronic device 1 in other embodiments, such as a plug-in mobile hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), etc. equipped on the electronic device 1. Further, the memory 11 may also include both an internal storage unit of the electronic device 1 and an external storage device. The memory 11 may not only be used to store application software and various types of data installed in the electronic device 1, such as the code of the reconciliation monitoring program, etc., but also be used to temporarily store data that has been output or is to be output.

[0152] The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or a plurality of packaged integrated circuits with the same or different functions, including one or more central processing units (CPUs), microprocessors, digital processing chips, graphics processors, and combinations of various control chips, etc. The processor 10 is the control core (Control Unit) of the electronic device, and uses various interfaces and lines to connect various components of the entire electronic device, and executes or executes programs or modules (such as reconciliation monitoring programs, etc.) stored in the memory 11, and calls data stored in the memory 11 to execute various functions of the electronic device 1 and process data.

[0153] The bus may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is configured to realize connection and communication between the memory 11 and at least one processor 10, etc.

[0154] Figure 5 Only an electronic device with components is shown, and those skilled in the art will understand that Figure 5 The structure shown does not constitute a limitation on the electronic device 1, and may include fewer or more components than shown in the figure, or combine certain components, or arrange the components differently.

[0155] For example, although not shown, the electronic device 1 may also include a power source (such as a battery) for supplying power to each component. Preferably, the power source may be logically connected to the at least one processor 10 through a power management device, so that the power management device can realize functions such as charging management, discharging management, and power consumption management. The power source may also include any components such as one or more DC or AC power sources, recharging devices, power failure detection circuits, power converters or inverters, power status indicators, etc. The electronic device 1 may also include a variety of sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be repeated here.

[0156] Furthermore, the electronic device 1 may also include a network interface. Optionally, the network interface may include a wired interface and / or a wireless interface (such as a WI-FI interface, a Bluetooth interface, etc.), which is generally used to establish a communication connection between the electronic device 1 and other electronic devices.

[0157] Optionally, the electronic device 1 may further include a user interface, which may be a display, an input unit (such as a keyboard), or a standard wired interface or a wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, and an OLED (Organic Light-Emitting Diode) touch device. The display may also be appropriately referred to as a display screen or a display unit, which is used to display information processed in the electronic device 1 and to display a visual user interface.

[0158] It should be understood that the embodiment is for illustration only and the scope of the patent application is not limited to this structure.

[0159] The reconciliation monitoring program 12 stored in the memory 11 in the electronic device 1 is a combination of multiple instructions, and when running in the processor 10, it can achieve:

[0160] Obtain reconciliation monitoring instructions;

[0161] Matching the reconciliation monitoring instruction with the reconciliation monitoring instruction script in a preset database to generate a reconciliation monitoring processing script;

[0162] Configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;

[0163] According to the target reconciliation monitoring processing script, the corresponding reconciliation data monitoring in the preset database is executed to obtain the reconciliation data monitoring result.

[0164] Specifically, the specific implementation method of the processor 10 for the above instructions can refer to Figure 1 The description of the relevant steps in the corresponding embodiment is not repeated here. It should be emphasized that in order to further ensure the privacy and security of the above original data set, the above audit data can also be stored in a node of a blockchain.

[0165] Furthermore, if the module / unit integrated in the electronic device 1 is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. The computer-readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a mobile hard disk, a magnetic disk, an optical disk, a computer memory, and a read-only memory (ROM).

[0166] In the several embodiments provided by the present invention, it should be understood that the disclosed devices, apparatuses and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

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

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

[0169] It is obvious to those skilled in the art that the present invention is not limited to the details of the above exemplary embodiments, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.

[0170] Therefore, no matter from which point of view, the embodiments should be regarded as illustrative and non-restrictive, and the scope of the present invention is limited by the appended claims rather than the above description, so it is intended that all changes falling within the meaning and scope of the equivalent elements of the claims are included in the present invention. Any attached figure mark in the claims should not be regarded as limiting the claims involved.

[0171] The blockchain referred to in this invention is a new application mode of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.

[0172] In addition, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the system claim can also be implemented by one unit or device through software or hardware. The second and other words are used to indicate names, but not to indicate any particular order.

[0173] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solution of the present invention can be modified or replaced by equivalents without departing from the spirit and scope of the technical solution of the present invention.

Claims

1. A method for monitoring reconciliation, characterized in that: include: Obtain reconciliation monitoring instructions; Calculate the hash value of the reconciliation monitoring instruction and determine the pointer of the hash value; query the first id of the reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer; map the length of the first id to obtain the first index value of the reconciliation monitoring instruction script; and use a preset offset value function to determine the first offset value of the movable position of the first index value; Obtaining a second id of the reconciliation monitoring instruction script, mapping the length of the second id to obtain a second index value of the reconciliation monitoring instruction script, and using the preset offset value function to determine a second offset value of a movable position of the second index value; Calculating the similarity between the first offset value and the second offset value, and matching the account reconciliation monitoring instruction with an account reconciliation monitoring instruction script in a preset database according to the similarity, to generate an account reconciliation monitoring processing script; Configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script; According to the target reconciliation monitoring processing script, the corresponding reconciliation data monitoring in the preset database is executed to obtain the reconciliation data monitoring result.

2. The account reconciliation monitoring method according to claim 1, characterized in that: Before obtaining the reconciliation monitoring instruction, the method further includes: When at least one initial reconciliation monitoring instruction to be processed is received, the format of the at least one initial reconciliation monitoring instruction is parsed to obtain a standard reconciliation monitoring instruction, and the standard reconciliation monitoring instruction is verified, and the initial reconciliation monitoring instruction that succeeds in the verification is selected as the reconciliation monitoring instruction.

3. The account reconciliation monitoring method according to claim 2, characterized in that: The verifying of the standard reconciliation monitoring instruction includes: Obtaining the assembly code of the standard reconciliation monitoring instruction; Parsing the instruction address in the assembly code and obtaining the first field attribute of the instruction address; Acquire source data in a corresponding database according to the instruction address, and acquire a second field attribute of the source data; The matching degree between the first field attribute and the second field attribute is calculated, and the verification result of the standard reconciliation monitoring instruction is identified according to the matching degree.

4. The account reconciliation monitoring method according to claim 1, characterized in that: The calculating the similarity between the first offset value and the second offset value includes: The similarity between the first offset value and the second offset value is calculated using the following formula: in, represents the similarity, represents the first offset value, represents the second offset value.

5. The account reconciliation monitoring method according to any one of claims 1 to 4, characterized in that: The configuring the business logic of the reconciliation monitoring processing script to obtain the target reconciliation monitoring processing script includes: Configuring the compilation environment of the reconciliation monitoring processing script; The configuration file of the business logic is obtained, and the configuration file is compiled using a preset compiler, and the compiled configuration file is imported into the compilation environment and run to generate the target reconciliation monitoring processing script.

6. A reconciliation monitoring device, used to implement the reconciliation monitoring method according to any one of claims 1 to 5, characterized in that: The device comprises: The acquisition module is used to obtain the reconciliation monitoring instructions; A matching module, used to match the account reconciliation monitoring instruction with the account reconciliation monitoring instruction script in a preset database to generate an account reconciliation monitoring processing script; A configuration module, used to configure the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script; An execution module is used to execute the corresponding reconciliation data monitoring in the preset database according to the target reconciliation monitoring processing script to obtain the reconciliation data monitoring result.

7. The account reconciliation monitoring device according to claim 6, characterized in that: The configuration module includes: a compilation submodule, which is used to configure the compilation environment of the reconciliation monitoring processing script, obtain the configuration file of the business logic, and compile the configuration file using a preset compilation program; The generation submodule is used to import the compiled configuration file into the compilation environment and run it to generate the target reconciliation monitoring processing script.

8. An electronic device, characterized in that: The electronic device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the reconciliation monitoring method as described in any one of claims 1 to 5.

9. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the reconciliation monitoring method as described in any one of claims 1 to 5 is implemented.

Images