CN112686759A - Account checking monitoring method, device, equipment and medium - Google Patents
Account checking monitoring method, device, equipment and medium Download PDFInfo
- Publication number
- CN112686759A CN112686759A CN202011645367.0A CN202011645367A CN112686759A CN 112686759 A CN112686759 A CN 112686759A CN 202011645367 A CN202011645367 A CN 202011645367A CN 112686759 A CN112686759 A CN 112686759A
- Authority
- CN
- China
- Prior art keywords
- monitoring
- reconciliation
- account checking
- instruction
- script
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The invention relates to the technical field of data security monitoring, and discloses a reconciliation monitoring method, which comprises the following steps: acquiring a reconciliation monitoring instruction; matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script; configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script; and executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result. The invention also relates to a block chain technology, and the reconciliation monitoring instruction can be deployed in a block link point. The invention can realize configurability of account checking monitoring.
Description
Technical Field
The invention relates to the technical field of data security monitoring, in particular to a reconciliation monitoring method and device, electronic equipment and a computer-readable storage medium.
Background
The reconciliation monitoring refers to an automatic data checking process performed to ensure the correctness and reliability of data in the data accounting process in the financial field. Reconciliation monitoring is currently used in many industries, such as securities, stocks, and funds.
But the following disadvantages exist in the prior reconciliation monitoring: the method can only be applied to fixed business scenes, such as fund reconciliation, a corresponding fund reconciliation monitoring module is specially arranged, if a new business is added, such as share reconciliation monitoring, a share reconciliation monitoring module needs to be newly developed, a new module needs to be developed every time a new business is added, so that the configurability of reconciliation monitoring is poor, and meanwhile, time and labor cost are consumed for business development every time.
Disclosure of Invention
The invention provides a method and a device for checking account monitoring, electronic equipment and a computer readable storage medium, and mainly aims to realize configurability of checking account monitoring.
In order to achieve the above object, the present invention provides a reconciliation monitoring method, which comprises:
acquiring a reconciliation monitoring instruction;
matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script;
configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;
and executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
Optionally, before acquiring the reconciliation monitoring instruction, the method further includes:
when at least one initial account checking monitoring instruction to be processed is received, format analysis is carried out on the initial account checking monitoring instruction to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is verified, and the initial account checking monitoring instruction which is successfully verified is selected as the account checking monitoring instruction.
Optionally, the verifying the standard reconciliation monitoring instruction includes:
acquiring an assembly code of the standard reconciliation monitoring instruction;
analyzing an instruction address in the assembly code, and acquiring a first field attribute of the instruction address;
acquiring source data in a corresponding database according to the instruction address, and acquiring a second field attribute of the source data;
and calculating the matching degree of the first field attribute and the second field attribute, and identifying the verification result of the standard reconciliation monitoring instruction according to the matching degree.
Optionally, the matching the reconciliation monitoring instruction with a reconciliation monitoring instruction script of a preset database includes:
calculating a hash value of the reconciliation monitoring instruction, determining a pointer of the hash value, inquiring a first id of a reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer, mapping the length of the first id to obtain a first index value of the reconciliation monitoring instruction script, and determining a first offset value of a movable position of the first index value by using a preset offset function;
acquiring a second id of the account checking monitoring instruction script, mapping the length of the second id to obtain a second index value of the account checking monitoring instruction script, and determining a second offset value of the movable position of the second index value by using the preset offset value function;
and calculating the similarity of the first deviation value and the second deviation value, and executing the matching of the account checking monitoring instruction and an account checking monitoring instruction script of the preset database according to the similarity to generate the account checking monitoring processing script.
Optionally, the calculating the similarity between the first offset value and the second offset value includes:
calculating a similarity of the first offset value and the second offset value using the following formula:
wherein T (x, y) represents the similarity, xiRepresents the first offset value, yiRepresenting the second offset value.
Optionally, the configuring the service logic of the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:
configuring a compiling environment of the reconciliation monitoring script;
and acquiring the configuration file of the business logic, compiling the configuration file by using a preset compiling program, importing the compiled configuration file into the compiling environment and running to generate the target reconciliation monitoring processing script.
In order to solve the above problem, the present invention further provides a reconciliation monitoring device, which includes:
the acquisition module is used for acquiring account checking monitoring instructions;
the matching module is used for matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script;
the configuration module is used for configuring the service logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;
and the execution module is used for executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
Optionally, the configuration module includes:
the compiling submodule is used for configuring the compiling environment of the reconciliation monitoring script, acquiring the configuration file of the business logic and compiling the configuration file by using a preset compiling program;
and the generation submodule is used for importing the compiled configuration file into the compiling environment and running the configuration file to generate the target reconciliation monitoring processing script.
In order to solve the above problem, the present invention also provides an electronic device, including:
a memory storing at least one instruction; and
and the processor executes the instructions stored in the memory to realize the account checking monitoring method.
In order to solve the above problem, the present invention further provides a computer-readable storage medium, in which at least one instruction is stored, and the at least one instruction is executed by a processor in an electronic device to implement the reconciliation monitoring method described in the above.
The format of the obtained account checking monitoring instruction is analyzed to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is matched with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script, and corresponding account checking data monitoring in the database can be realized according to the generated account checking monitoring processing script; secondly, the embodiment of the invention obtains the target account checking monitoring processing script by configuring the service logic of the account checking monitoring processing script, and can realize configurability of account checking monitoring, thereby reducing the labor and time cost; further, according to the target reconciliation monitoring processing script, the embodiment of the invention executes the corresponding reconciliation data monitoring in the database to obtain a reconciliation data monitoring result. Therefore, the account checking monitoring method, the account checking monitoring device, the electronic equipment and the computer readable storage medium can realize configurability of account checking monitoring.
Drawings
Fig. 1 is a schematic flow chart of a reconciliation monitoring method according to a first embodiment of the present invention;
fig. 2 is a schematic flowchart of a standard reconciliation monitoring instruction verification method according to a second embodiment of the present invention;
fig. 3 is a schematic flowchart of step S2 of the reconciliation monitoring method provided in fig. 1 according to the first embodiment of the present invention;
fig. 4 is a schematic block diagram of a reconciliation monitoring device according to a first embodiment of the present invention;
fig. 5 is a schematic internal structural diagram of an electronic device implementing a reconciliation monitoring method according to a first embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The execution subject of the reconciliation monitoring method provided by the embodiment of the application includes but is not limited to at least one of the electronic devices such as a server and a terminal which can be configured to execute the method provided by the embodiment of the application. In other words, the reconciliation monitoring method can be executed by software or hardware installed in the terminal device or the server device, and the software can be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.
The invention provides a reconciliation monitoring method. Fig. 1 is a schematic flow chart of a reconciliation monitoring method according to an embodiment of the present invention. The method may be performed by an apparatus, which may be implemented by software and/or hardware.
In this embodiment, the method for checking account monitoring includes:
and S1, acquiring a reconciliation monitoring instruction.
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 scene, and the reconciliation monitoring instruction may be initiated by a front-end system or may be initiated autonomously by a user based on the actual business scene. For example, the reconciliation monitoring instruction may be: and the capital reconciliation instruction, the wage reconciliation instruction, the project money reconciliation instruction and the like are not limited in the next time. It is emphasized that, in order to further ensure the privacy and security of the reconciliation monitoring instruction, the reconciliation monitoring instruction can also be stored in a node of a block chain.
Further, in another optional embodiment of the present invention, before acquiring the tie-out monitoring instruction, the method further includes: when at least one initial account checking monitoring instruction to be processed is received, format analysis is carried out on the initial account checking monitoring instruction to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is verified, the initial account checking monitoring instruction which is successfully verified is selected as the account checking monitoring instruction, and a large number of useless initial account checking monitoring instructions can be deleted through verification to improve timeliness of subsequent account checking data monitoring.
In one embodiment of the present invention, the format of the at least one initial reconciliation monitoring instruction is analyzed, that is, the format of the initial reconciliation monitoring instruction is converted into json (javascript Object notification) format. Wherein, the json format refers to a lightweight data exchange format, which is convenient for data reading and understanding.
In an alternative embodiment, the format of the initial tie-out monitoring instruction is converted into json format by the following method:
JSONObject getJSONObject(Instruct name){}->JSONObject paramzObject＝rootObject.getJSONObject(“paramz”)。
in detail, referring to fig. 2, the verifying the standard reconciliation monitoring instruction includes:
and S10, acquiring the assembly code of the standard reconciliation monitoring instruction.
The essential content of the standard reconciliation monitoring instruction is binary data consisting of 0 and 1, the essence of the standard reconciliation monitoring instruction is a machine code, and the machine code is not easy to be recognized by a computer, so that the compiling of the assembly code of the standard reconciliation monitoring instruction is carried out by utilizing Java language to generate the assembly code of the standard reconciliation monitoring instruction.
S11, analyzing the instruction address in the assembly code, and acquiring the first field attribute of the instruction address.
In an optional embodiment, calling the href tag parses out an instruction address, namely url, in the assembly code, and acquires a first field attribute of the instruction address by using a reference method, wherein the first field attribute comprises: field names, table names, and IDs, etc.
S12, obtaining the source data in the corresponding database according to the instruction address, and obtaining the second field attribute of the source data.
Optionally, according to the instruction address, the present invention obtains source data in a corresponding database by using an Sql statement, and obtains a second field attribute of the source data by using a get () function. Wherein the second field attribute comprises: field names, column names, table names, and the like.
And S13, calculating the matching degree of the first field attribute and the second field attribute, and identifying the verification result of the initial reconciliation monitoring instruction according to the matching degree.
In an alternative embodiment, the matching degree of the first field attribute and the second field attribute is calculated by using the euclidean distance formula of the currently known technology.
Further, the identifying a verification result of the initial reconciliation monitoring instruction according to the matching degree includes:
if the matching degree is smaller than a preset threshold value, the verification of the initial reconciliation monitoring instruction is failed, and if the matching degree is not smaller than the preset threshold value, the verification of the initial reconciliation detection instruction is successful.
Optionally, the preset threshold is 0.6.
And S2, matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script.
Another embodiment of the invention comprises: and storing the account checking monitoring instruction in a preset distributed storage function so as to quickly realize the subsequent matching with an account checking monitoring instruction script of a preset database.
Optionally, the preset distributed storage function is as follows:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein, instruction _ id represents a storage number of the target tie-out monitoring instruction, hash _ str (instruction) represents an object quantization function of the tie-out monitoring instruction, and instruction _ time (time) represents a time quantization function of the tie-out monitoring instruction, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
Further, the reconciliation monitoring instruction script is used for monitoring reconciliation data in a database, and the reconciliation monitoring instruction script comprises: a request parameter object (request) and a return parameter object (response).
The Request object is the only legal way for a script to obtain Request data from the outside, a Request message is converted into a Service Request type logical object Request after being analyzed, the Request object can comprise fields such as User _ id, req _ seq, state, message, time _ stamp, data and the like, except the User _ id field, other fields are copied from the Request message as they are, only the User _ id field in the Request message is the User information type of the User, and the content of the User information type is the entity object of the User corresponding to the User _ id.
The response object is the only legal way for the script to return information to the outside world, and the response object also comprises fields such as user _ id, req _ seq, state, message, time _ stamp, and data. The method comprises the steps that a statement of account checking instruction script is written into a statement of account checking instruction script engine before the statement of account checking instruction script is started, time _ stamp is automatically filled by a system according to current time after the statement of account checking instruction script is stopped, and the rest values need to be written by a writer in the running process of the statement of account checking instruction script.
Optionally, the preset database is a relational database, such as an Oracle database.
In an optional embodiment, the reconciliation monitoring instruction is matched with a reconciliation monitoring instruction script of a preset database by using a preset multi-pattern matching algorithm, so as to generate a reconciliation monitoring processing script. The reconciliation monitoring processing script is used for executing reconciliation data monitoring required by a corresponding reconciliation monitoring instruction, for example, the reconciliation monitoring instruction is payroll reconciliation monitoring, and the reconciliation monitoring processing script executes payroll reconciliation monitoring.
Optionally, the preset multi-pattern matching algorithm includes: the Shift function and the Hash function. The Shift function is used for representing a movable offset value of data, the range of the data to be matched can be determined according to the offset value, and the Hash function is used for changing input with any length into output with fixed length through hashing.
In detail, referring to fig. 3, the matching between the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database by the preset multi-pattern matching algorithm includes:
s20, calculating a Hash value of the reconciliation monitoring instruction by using the Hash function, determining a pointer of the Hash value, inquiring a first id of a reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer, mapping the length of the first id to obtain a first index value of the reconciliation monitoring instruction script, and determining a first deviation value of a movable position of the first index value by using the Shift function.
S21, acquiring 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 determining a second offset value of the movable position of the second index value by using the Shift function.
And S22, calculating the similarity between the first offset value and the second offset value, and executing the matching between the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database according to the similarity to generate the reconciliation monitoring processing script.
In an alternative embodiment, the similarity between the first offset value and the second offset value is calculated by:
wherein T (x, y) represents the similarity, xiDenotes a first offset value, yiRepresenting the second offset value.
Further, the performing matching of the reconciliation monitoring instruction and a reconciliation monitoring instruction script of a preset database according to the similarity includes:
if the similarity is smaller than a preset similarity threshold value, the reconciliation monitoring instruction is failed to be matched with the reconciliation monitoring instruction script of a preset database and marked, and if the similarity is not smaller than the preset similarity threshold value, the reconciliation monitoring instruction is successfully matched with the reconciliation monitoring instruction script of the preset database, and a corresponding reconciliation detection processing script is generated.
And S3, configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script.
Because the generated reconciliation monitoring processing script can only execute corresponding reconciliation data monitoring and cannot meet multi-module or multi-type data monitoring, the embodiment of the invention can obtain the target reconciliation monitoring processing script by configuring the service logic of the reconciliation monitoring processing script, can realize configurability of the reconciliation monitoring and can reduce the labor and time costs.
Further, the configuring the service logic of the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:
and configuring a compiling environment of the reconciliation monitoring script, acquiring a configuration file of the business logic, compiling the configuration file by using a preset compiling program, importing the compiled configuration file into the compiling environment and running to generate the target reconciliation monitoring processing script.
Optionally, the configuration of the compiling environment is implemented by using a Myeclipse, the preset compiler is compiled by using a Java language, and the configuration file includes: the attribute of the business logic, the annotation content of the business logic, the configuration item content of the business logic and the like.
And S4, executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
For example, if the target reconciliation monitoring processing script is a cmp script, executing comparison between external system transmission data and corresponding reconciliation data in a database, such as payroll reconciliation; if the target reconciliation monitoring processing script is a verify script, comparing data generated in the execution system with corresponding reconciliation data in a database, such as fund reconciliation and the like; and if the target account checking monitoring processing script is an exception script, monitoring the day-to-day data change of corresponding account checking data in the database, such as account checking of project money.
Further, another embodiment of the present invention further includes: and transmitting the account checking data monitoring result to a front-end page for displaying so as to visually and clearly know the account checking data monitoring result.
The format of the obtained account checking monitoring instruction is analyzed to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is matched with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script, and corresponding account checking data monitoring in the database can be realized according to the generated account checking monitoring processing script; secondly, the embodiment of the invention obtains the target account checking monitoring processing script by configuring the service logic of the account checking monitoring processing script, and can realize configurability of account checking monitoring, thereby reducing the labor and time cost; further, according to the target reconciliation monitoring processing script, the embodiment of the invention executes the corresponding reconciliation data monitoring in the database to obtain a reconciliation data monitoring result. Therefore, the account checking monitoring method provided by the invention can realize configurability of account checking monitoring.
Fig. 4 is a schematic block diagram of a reconciliation monitoring device according to an embodiment of the present invention.
The reconciliation monitoring device 100 of the invention can be installed in an electronic device. According to the realized functions, the reconciliation monitoring device can comprise an acquisition module 101, a matching module 102, a configuration module 103 and an execution module 104. The module of the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the obtaining module 101 is configured to obtain a reconciliation monitoring instruction.
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 scene, and the reconciliation monitoring instruction may be initiated by a front-end system or may be initiated autonomously by a user based on the actual business scene. For example, the reconciliation monitoring instruction may be: and the capital reconciliation instruction, the wage reconciliation instruction, the project money reconciliation instruction and the like are not limited in the next time. It is emphasized that, in order to further ensure the privacy and security of the reconciliation monitoring instruction, the reconciliation monitoring instruction can also be stored in a node of a block chain.
Further, in another optional embodiment of the present invention, before acquiring the tie-out monitoring instruction, the method further includes: when at least one initial account checking monitoring instruction to be processed is received, format analysis is carried out on the initial account checking monitoring instruction to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is verified, the initial account checking monitoring instruction which is successfully verified is selected as the account checking monitoring instruction, and a large number of useless initial account checking monitoring instructions can be deleted through verification to improve timeliness of subsequent account checking data monitoring.
In one embodiment of the present invention, the format of the at least one initial reconciliation monitoring instruction is analyzed, that is, the format of the initial reconciliation monitoring instruction is converted into json (javascript Object notification) format. Wherein, the json format refers to a lightweight data exchange format, which is convenient for data reading and understanding.
In an alternative embodiment, the format of the initial tie-out monitoring instruction is converted into json format by the following method:
JSONObject getJSONObject(Instruct name){}->JSONObject paramzObject＝rootObject.getJSONObject(“paramz”)。
in detail, referring to fig. 2, the verifying the standard reconciliation monitoring instruction includes:
and S10, acquiring the assembly code of the standard reconciliation monitoring instruction.
The essential content of the standard reconciliation monitoring instruction is binary data consisting of 0 and 1, the essence of the standard reconciliation monitoring instruction is a machine code, and the machine code is not easy to be recognized by a computer, so that the compiling of the assembly code of the standard reconciliation monitoring instruction is carried out by utilizing Java language to generate the assembly code of the standard reconciliation monitoring instruction.
S11, analyzing the instruction address in the assembly code, and acquiring the first field attribute of the instruction address.
In an optional embodiment, calling the href tag parses out an instruction address, namely url, in the assembly code, and acquires a first field attribute of the instruction address by using a reference method, wherein the first field attribute comprises: field names, table names, and IDs, etc.
S12, obtaining the source data in the corresponding database according to the instruction address, and obtaining the second field attribute of the source data.
Optionally, according to the instruction address, the present invention obtains source data in a corresponding database by using an Sql statement, and obtains a second field attribute of the source data by using a get () function. Wherein the second field attribute comprises: field names, column names, table names, and the like.
And S13, calculating the matching degree of the first field attribute and the second field attribute, and identifying the verification result of the initial reconciliation monitoring instruction according to the matching degree.
In an alternative embodiment, the matching degree of the first field attribute and the second field attribute is calculated by using the euclidean distance formula of the currently known technology.
Further, the identifying a verification result of the initial reconciliation monitoring instruction according to the matching degree includes:
if the matching degree is smaller than a preset threshold value, the verification of the initial reconciliation monitoring instruction is failed, and if the matching degree is not smaller than the preset threshold value, the verification of the initial reconciliation detection instruction is successful.
Optionally, the preset threshold is 0.6.
The matching module 102 is configured to match the reconciliation monitoring instruction with a reconciliation monitoring instruction script of a preset database, and generate a reconciliation monitoring processing script.
Another embodiment of the invention comprises: and storing the account checking monitoring instruction in a preset distributed storage function so as to quickly realize the subsequent matching with an account checking monitoring instruction script of a preset database.
Optionally, the preset distributed storage function is as follows:
instruct_id＝(w1×(hash_str(instruction)/b1)+w2×(instruct_time(time)/b2))％Hash_Bucket
wherein, instruction _ id represents a storage number of the target tie-out monitoring instruction, hash _ str (instruction) represents an object quantization function of the tie-out monitoring instruction, and instruction _ time (time) represents a time quantization function of the tie-out monitoring instruction, b1 represents a dispersion degree of the object quantization function, b2 represents a dispersion degree of the time quantization function, w1 represents coefficients of the object quantization function, and w2 represents coefficients of the time quantization function.
Further, the reconciliation monitoring instruction script is used for monitoring reconciliation data in a database, and the reconciliation monitoring instruction script comprises: a request parameter object (request) and a return parameter object (response).
The Request object is the only legal way for a script to obtain Request data from the outside, a Request message is converted into a Service Request type logical object Request after being analyzed, the Request object can comprise fields such as User _ id, req _ seq, state, message, time _ stamp, data and the like, except the User _ id field, other fields are copied from the Request message as they are, only the User _ id field in the Request message is the User information type of the User, and the content of the User information type is the entity object of the User corresponding to the User _ id.
The response object is the only legal way for the script to return information to the outside world, and the response object also comprises fields such as user _ id, req _ seq, state, message, time _ stamp, and data. The method comprises the steps that a statement of account checking instruction script is written into a statement of account checking instruction script engine before the statement of account checking instruction script is started, time _ stamp is automatically filled by a system according to current time after the statement of account checking instruction script is stopped, and the rest values need to be written by a writer in the running process of the statement of account checking instruction script.
Optionally, the preset database is a relational database, such as an Oracle database.
In an optional embodiment, the reconciliation monitoring instruction is matched with a reconciliation monitoring instruction script of a preset database by using a preset multi-pattern matching algorithm, so as to generate a reconciliation monitoring processing script. The reconciliation monitoring processing script is used for executing reconciliation data monitoring required by a corresponding reconciliation monitoring instruction, for example, the reconciliation monitoring instruction is payroll reconciliation monitoring, and the reconciliation monitoring processing script executes payroll reconciliation monitoring.
Optionally, the preset multi-pattern matching algorithm includes: the Shift function and the Hash function. The Shift function is used for representing a movable offset value of data, the range of the data to be matched can be determined according to the offset value, and the Hash function is used for changing input with any length into output with fixed length through hashing.
In detail, referring to fig. 3, the matching between the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database by the preset multi-pattern matching algorithm includes:
s20, calculating a Hash value of the reconciliation monitoring instruction by using the Hash function, determining a pointer of the Hash value, inquiring a first id of a reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer, mapping the length of the first id to obtain a first index value of the reconciliation monitoring instruction script, and determining a first deviation value of a movable position of the first index value by using the Shift function.
S21, acquiring 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 determining a second offset value of the movable position of the second index value by using the Shift function.
And S22, calculating the similarity between the first offset value and the second offset value, and executing the matching between the reconciliation monitoring instruction and the reconciliation monitoring instruction script of the preset database according to the similarity to generate the reconciliation monitoring processing script.
In an alternative embodiment, the similarity between the first offset value and the second offset value is calculated by:
wherein T (x, y) represents the similarity, xiDenotes a first offset value, yiRepresenting the second offset value.
Further, the performing matching of the reconciliation monitoring instruction and a reconciliation monitoring instruction script of a preset database according to the similarity includes:
if the similarity is smaller than a preset similarity threshold value, the reconciliation monitoring instruction is failed to be matched with the reconciliation monitoring instruction script of a preset database and marked, and if the similarity is not smaller than the preset similarity threshold value, the reconciliation monitoring instruction is successfully matched with the reconciliation monitoring instruction script of the preset database, and a corresponding reconciliation detection processing script is generated.
The configuration module 103 is configured to configure a service logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script.
Because the generated reconciliation monitoring processing script can only execute corresponding reconciliation data monitoring and cannot meet multi-module or multi-type data monitoring, the embodiment of the invention can obtain the target reconciliation monitoring processing script by configuring the service logic of the reconciliation monitoring processing script, can realize configurability of the reconciliation monitoring and can reduce the labor and time costs.
Further, the configuring the service logic of the reconciliation monitoring script to obtain a target reconciliation monitoring processing script includes:
the compiling submodule 1030 is configured to configure a compiling environment of the reconciliation monitoring script, acquire a configuration file of the business logic, and compile the configuration file by using a preset compiling program;
and a generating sub-module 1031, configured to import and run the configuration file into the compiling environment, and generate the target reconciliation monitoring processing script.
Optionally, the configuration of the compiling environment is implemented by using a Myeclipse, the preset compiler is compiled by using a Java language, and the configuration file includes: the attribute of the business logic, the annotation content of the business logic, the configuration item content of the business logic and the like.
The execution module 104 is configured to execute, according to the target reconciliation monitoring processing script, reconciliation data monitoring corresponding to the preset database to obtain a reconciliation data monitoring result.
For example, if the target reconciliation monitoring processing script is a cmp script, executing comparison between external system transmission data and corresponding reconciliation data in a database, such as payroll reconciliation; if the target reconciliation monitoring processing script is a verify script, comparing data generated in the execution system with corresponding reconciliation data in a database, such as fund reconciliation and the like; and if the target account checking monitoring processing script is an exception script, monitoring the day-to-day data change of corresponding account checking data in the database, such as account checking of project money.
Further, another embodiment of the present invention further includes: and transmitting the account checking data monitoring result to a front-end page for displaying so as to visually and clearly know the account checking data monitoring result.
The format of the obtained account checking monitoring instruction is analyzed to obtain a target account checking monitoring instruction, the target account checking monitoring instruction is matched with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script, and corresponding account checking data monitoring in the database can be realized according to the generated account checking monitoring processing script; secondly, the embodiment of the invention obtains the target account checking monitoring processing script by configuring the service logic of the account checking monitoring processing script, and can realize configurability of account checking monitoring, thereby reducing the labor and time cost; further, according to the target reconciliation monitoring processing script, the embodiment of the invention executes the corresponding reconciliation data monitoring in the database to obtain a reconciliation data monitoring result. Therefore, the account checking monitoring device provided by the invention can realize configurability of account checking monitoring.
Fig. 5 is a schematic structural diagram of an electronic device implementing a method for checking account according to an embodiment of the present invention.
The electronic device 1 may comprise a processor 10, a memory 11 and a bus, and may further comprise a computer program, such as a tie-up monitoring program, stored in the memory 11 and executable on the processor 10.
The memory 11 includes at least one type of readable storage medium, which includes flash memory, removable hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disk, optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a removable 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 Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device 1. The memory 11 may be used not only to store application software installed in the electronic device 1 and various types of data, such as codes of a reconciliation monitoring program, but also to temporarily store data that has been output or is to be output.
The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged 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. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the whole electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device 1 by running or executing programs or modules (such as a reconciliation monitoring program) stored in the memory 11 and calling data stored in the memory 11.
The bus may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
Fig. 5 only shows an electronic device with components, and it will be understood by a person skilled in the art that the structure shown in fig. 5 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than shown, or a combination of certain components, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and 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 are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The tie-out monitoring program 12 stored in the memory 11 of the electronic device 1 is a combination of instructions that, when executed in the processor 10, enable:
acquiring a reconciliation monitoring instruction;
matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script;
configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;
and executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
Specifically, the specific implementation method of the processor 10 for the instruction may refer to the description of the relevant steps in the embodiment corresponding to fig. 1, which is not described herein again. It is emphasized that the audit data may also be stored in a node of a block chain in order to further ensure the privacy and security of the original data set.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.
Claims (10)
1. A reconciliation monitoring method is characterized by comprising the following steps:
acquiring a reconciliation monitoring instruction;
matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script;
configuring the business logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;
and executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
2. The tie-out monitoring method of claim 1, wherein prior to obtaining the tie-out monitoring instruction, the method further comprises:
when at least one initial account checking monitoring instruction to be processed is received, format analysis is carried out on the at least one initial account checking monitoring instruction to obtain a standard account checking monitoring instruction, the standard account checking monitoring instruction is verified, and the initial account checking monitoring instruction which is successfully verified is selected as the account checking monitoring instruction.
3. The reconciliation monitoring method of claim 2 wherein the verifying the standard reconciliation monitoring instruction comprises:
acquiring an assembly code of the standard reconciliation monitoring instruction;
analyzing an instruction address in the assembly code, and acquiring a first field attribute of the instruction address;
acquiring source data in a corresponding database according to the instruction address, and acquiring a second field attribute of the source data;
and calculating the matching degree of the first field attribute and the second field attribute, and identifying the verification result of the standard reconciliation monitoring instruction according to the matching degree.
4. The reconciliation monitoring method of claim 1, wherein the matching of the reconciliation monitoring instruction with a reconciliation monitoring instruction script of a preset database comprises:
calculating a hash value of the reconciliation monitoring instruction, determining a pointer of the hash value, inquiring a first id of a reconciliation monitoring instruction script corresponding to the reconciliation monitoring instruction according to the pointer, mapping the length of the first id to obtain a first index value of the reconciliation monitoring instruction script, and determining a first offset value of a movable position of the first index value by using a preset offset function;
acquiring a second id of the account checking monitoring instruction script, mapping the length of the second id to obtain a second index value of the account checking monitoring instruction script, and determining a second offset value of the movable position of the second index value by using the preset offset value function;
and calculating the similarity of the first deviation value and the second deviation value, and executing the matching of the account checking monitoring instruction and an account checking monitoring instruction script of the preset database according to the similarity to generate the account checking monitoring processing script.
5. The reconciliation monitoring method of claim 4 wherein the calculating a similarity of the first offset value to the second offset value comprises:
calculating a similarity of the first offset value and the second offset value using the following formula:
wherein T (x, y) represents the similarity, xiRepresents the first offset value, yiRepresenting the second offset value.
6. The reconciliation monitoring method according to any one of claims 1 to 5, wherein the configuring the business logic of the reconciliation monitoring script to obtain a target reconciliation monitoring processing script comprises:
configuring a compiling environment of the reconciliation monitoring script;
and acquiring the configuration file of the business logic, compiling the configuration file by using a preset compiling program, importing the compiled configuration file into the compiling environment and running to generate the target reconciliation monitoring processing script.
7. An account reconciliation monitoring device, the device comprising:
the acquisition module is used for acquiring account checking monitoring instructions;
the matching module is used for matching the account checking monitoring instruction with an account checking monitoring instruction script of a preset database to generate an account checking monitoring processing script;
the configuration module is used for configuring the service logic of the reconciliation monitoring processing script to obtain a target reconciliation monitoring processing script;
and the execution module is used for executing corresponding account checking data monitoring in the preset database according to the target account checking monitoring processing script to obtain an account checking data monitoring result.
8. The tie-out monitoring device of claim 7, wherein the configuration module comprises:
the compiling submodule is used for configuring the compiling environment of the reconciliation monitoring script, acquiring the configuration file of the business logic and compiling the configuration file by using a preset compiling program;
and the generation submodule is used for importing the compiled configuration file into the compiling environment and running the configuration file to generate the target reconciliation monitoring processing script.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the tie-out monitoring method of any one of claims 1 to 6.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the reconciliation monitoring method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011645367.0A CN112686759A (en) | 2020-12-30 | 2020-12-30 | Account checking monitoring method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011645367.0A CN112686759A (en) | 2020-12-30 | 2020-12-30 | Account checking monitoring method, device, equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112686759A true CN112686759A (en) | 2021-04-20 |
Family
ID=75456972
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011645367.0A Pending CN112686759A (en) | 2020-12-30 | 2020-12-30 | Account checking monitoring method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112686759A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114356454A (en) * | 2022-01-06 | 2022-04-15 | 京东科技控股股份有限公司 | Account checking data processing method, account checking data processing device, account checking data storage medium and program product |
-
2020
- 2020-12-30 CN CN202011645367.0A patent/CN112686759A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114356454A (en) * | 2022-01-06 | 2022-04-15 | 京东科技控股股份有限公司 | Account checking data processing method, account checking data processing device, account checking data storage medium and program product |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112418798A (en) | Information auditing method and device, electronic equipment and storage medium | |
| CN114881616A (en) | Business process execution method and device, electronic equipment and storage medium | |
| CN111429121B (en) | Block chain-based electronic ticket processing method, device, equipment and storage medium | |
| CN112949278A (en) | Data checking method and device, electronic equipment and readable storage medium | |
| CN115543198A (en) | Method and device for lake entering of unstructured data, electronic equipment and storage medium | |
| CN113434542B (en) | Data relationship identification method and device, electronic equipment and storage medium | |
| CN114491646A (en) | Data desensitization method and device, electronic equipment and storage medium | |
| CN113468175A (en) | Data compression method and device, electronic equipment and storage medium | |
| CN112686759A (en) | Account checking monitoring method, device, equipment and medium | |
| CN113254446B (en) | Data fusion method, device, electronic equipment and medium | |
| CN113051171B (en) | Interface testing method, device, equipment and storage medium | |
| CN114896164A (en) | Interface optimization method and device, electronic equipment and storage medium | |
| CN114840388A (en) | Data monitoring method and device, electronic equipment and storage medium | |
| CN115102770A (en) | Resource access method, device and equipment based on user permission and storage medium | |
| CN114911479A (en) | Interface generation method, device, equipment and storage medium based on configuration | |
| CN112667244A (en) | Data verification method and device, electronic equipment and computer readable storage medium | |
| CN113469649A (en) | Project progress analysis method and device, electronic equipment and storage medium | |
| CN112380820A (en) | Automatic data backfilling method and device, electronic equipment and computer storage medium | |
| CN111859452A (en) | Page information checking method, device and equipment and computer readable storage medium | |
| CN113064797B (en) | Front-end monitoring method and device, electronic equipment and storage medium | |
| CN113434359B (en) | Data traceability system construction method and device, electronic device and readable storage medium | |
| CN115174698B (en) | Market data decoding method, device, equipment and medium based on table entry index | |
| CN114564413B (en) | Synchronous equipment testing method and device | |
| CN115033605A (en) | Data query method and device, electronic equipment and storage medium | |
| CN114006877A (en) | Message transmission method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |