Rule checking method and device, equipment and storage medium

Abstract

This application provides a rule verification method, apparatus, device, and storage medium. The method includes: acquiring preset information of a database table to be verified; then, based on the current polling time interval, performing data verification on the verification fields of the database table where the verification status parameter is a set value; and finally, based on the data verification result and the current polling time interval, determining the latest polling time interval for the database table to be verified. This application solves the problem of low efficiency in verifying rules when they are updated in the prior art, improves the processing efficiency of rule verification, avoids the inefficiency caused by manually calling scripts to modify verification rules, and, by periodically polling the database table, the database only needs to be polled once within a polling time interval, avoiding the waste of computing resources caused by frequent database calls and verifications, and improving resource utilization efficiency.

Description

Technical Field

[0001] This application relates to the field of Internet technology, and in particular to a rule verification method, apparatus, device, and storage medium. Background Technology

[0002] In financial accounting systems, when submitting data to various settlement venues and regulatory agencies, data messages need to be configured according to the verification rules required by the settlement venues and regulatory agencies. Different settlement venues have different verification rules. In addition, the relevant verification rules may be modified after the interfaces of settlement venues and regulatory agencies are updated.

[0003] To cope with updates and changes in verification rules, after the verification rules required by the settlement venue or other locations change, business personnel need to configure the verification rules that need to be modified on the client side, and then the database side needs to verify the configured verification rules.

[0004] In existing technologies, the verification of validation rules usually requires manually calling the changed databases sequentially via SQL to configure the corresponding settings based on the modified validation rules. This results in frequent calls, a large amount of data processing resources being consumed, and low processing efficiency. Summary of the Invention

[0005] This application provides a rule verification method, apparatus, device, and storage medium to solve the problem of low efficiency in verifying rules when they are updated or changed in the prior art.

[0006] In a first aspect, embodiments of this application provide a rule verification method, which includes:

[0007] Retrieve the preset information of the database table to be verified, including the verification fields and the current polling time interval;

[0008] Based on the current polling time interval, perform data validation on the validation fields of the database table where the validation status parameter is set to a set value. The set value of the validation status parameter indicates that the validation rules of the database table have been updated.

[0009] Based on the data verification results and the current polling time interval, determine the latest polling time interval for the database table to be verified.

[0010] Optionally, the verification status parameters of the database table are determined as follows: in response to receiving a notification message from the client that the verification status parameters have been modified, the verification status parameters of the database table are determined, and the notification message includes the verification status parameters of the database table.

[0011] Optionally, based on the current polling time interval, data validation is performed on the validation fields in the database table where the validation status parameter is a set value, including: obtaining the latest validation rules for the database table where the validation status parameter is a set value based on the current polling time interval; and performing data validation on the validation fields in the database table based on the latest validation rules.

[0012] Optionally, based on the data verification results and the current polling time interval, the latest polling time interval of the database table to be verified is determined, including: determining the verification frequency of the database table to be verified based on the data verification results and the current polling time interval; and determining the latest polling time interval of the database table to be verified according to the preset correspondence between the verification frequency and the polling time interval and the verification frequency.

[0013] Optionally, the verification frequency of the database table to be verified is determined based on the data verification results and the current polling time interval, including: determining the number of verifications of the database table to be verified based on the data verification results and data verification records; and determining the verification frequency of the database table to be verified based on the number of verifications and the current polling time interval.

[0014] Optionally, after obtaining the preset information of the database table to be verified, the method further includes: determining that there is no database table whose verification status parameter has reached the set value; and determining the latest polling time interval based on the current polling time interval.

[0015] Optionally, the latest polling time interval is determined based on the current polling time interval, including: determining the latest polling time interval of the database table to be verified according to the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

[0016] Secondly, embodiments of this application provide a rule verification device, which includes:

[0017] The receiving module is used to obtain the preset information of the database table to be verified. The preset information includes the verification field and the current polling time interval.

[0018] The processing module is used to perform data validation on the validation fields of the database table with the validation status parameter set to a set value based on the current polling time interval. The validation status parameter set to a set value indicates that the validation rules of the database table have been updated.

[0019] The update module is used to determine the latest polling interval for the database table to be verified based on the results of data verification and the current polling interval.

[0020] Optionally, the processing module is specifically used to determine the verification status parameters of the database table in the following manner: in response to receiving a notification message from the client that the verification status parameters have been modified, the module determines the verification status parameters of the database table, wherein the notification message contains the verification status parameters of the database table.

[0021] Optionally, the processing module is specifically used to: obtain the latest verification rules for the database table whose verification status parameter is a set value based on the current polling time interval; and perform data verification on the verification fields in the database table based on the latest verification rules.

[0022] Optionally, the update module is specifically used to: determine the verification frequency of the database table to be verified based on the data verification result and the current polling time interval; and determine the latest polling time interval of the database table to be verified according to the preset correspondence between the verification frequency and the polling time interval and the verification frequency.

[0023] Optionally, the update module is specifically used to determine the number of times the database table to be verified needs to be verified based on the results of data verification and data verification records; and to determine the verification frequency of the database table to be verified based on the number of verifications and the current polling time interval.

[0024] Optionally, the processing module is further configured to, after obtaining the preset information of the database table to be verified, determine that there is no database table whose verification status parameter has reached the set value; and determine the latest polling time interval based on the current polling time interval.

[0025] Optionally, the processing module is specifically used to determine the latest polling time interval of the database table to be verified based on the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

[0026] Thirdly, embodiments of this application also provide a control device, which includes:

[0027] At least one processor;

[0028] and memory that is communicatively connected to at least one processor;

[0029] The memory stores instructions that can be executed by at least one processor, which, when executed by at least one processor, cause the control device to perform a rule verification method corresponding to any embodiment of the first aspect of the present application.

[0030] Fourthly, embodiments of this application also provide a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement a rule verification method as described in any of the first aspects of embodiments of this application.

[0031] The rule verification method, apparatus, device, and storage medium provided in this application obtain preset information of the database table to be verified, then perform data verification on the verification fields of the database table with the verification status parameter set to a current polling time interval, and finally determine the latest polling time interval of the database table to be verified based on the data verification result and the current polling time interval. Thus, by dynamically determining the polling interval of the database table and periodically polling the database table based on the polling interval, and verifying database tables with updated verification rules, automated rule verification is achieved. This eliminates the need for modification on the database side every time the verification rules change, improving processing efficiency and avoiding the inefficiency caused by manually calling scripts to modify verification rules. Furthermore, by periodically polling the database table, the database only needs to be polled once within a polling time interval, avoiding the waste of computing resources caused by frequent database calls and verifications, and improving resource utilization efficiency. Attached Figure Description

[0032] The accompanying drawings, which are incorporated in and form a part of this specification, illustrate embodiments consistent with this disclosure and, together with the description, serve to explain the principles of this disclosure.

[0033] Figure 1 An application scenario diagram of the rule verification method provided in the embodiments of this application;

[0034] Figure 2 A flowchart of a rule verification method provided in one embodiment of this application;

[0035] Figure 3 A flowchart illustrating a rule verification method provided in yet another embodiment of this application;

[0036] Figure 4 This is a schematic diagram of the structure of a rule verification device provided in yet another embodiment of this application;

[0037] Figure 5 This is a schematic diagram of the structure of a control device provided in yet another embodiment of this application.

[0038] The accompanying drawings have illustrated specific embodiments of this disclosure, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concepts of this disclosure to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0039] In the following description, when referring to the accompanying drawings, the same numbers in different drawings denote the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments are merely examples of apparatuses and methods consistent with some aspects of the embodiments of this application as detailed in the appended claims.

[0040] The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will now be described with reference to the accompanying drawings.

[0041] In existing financial accounting systems, data stored in database tables frequently needs to be uploaded to the interfaces of settlement venues or regulatory agencies. Because the verification rules of different settlement venues and regulatory agencies may differ—for example, different definitions for different business types—one regulatory agency might name a "locked amount" as "frozen amount" when defined by another. This necessitates that the financial accounting system adjust the relevant fields and structures of the reported data according to the verification rules of each settlement venue. If the verification rules of a regulatory agency change or are updated, business personnel need to configure the modified verification rules on the client side, and then the database side verifies the configured rules to ensure that the reconfigured rules are error-free on the database side (e.g., the modified configuration is not implemented in the corresponding database table, or there is a conflict between the configuration in the database table and the verification rules).

[0042] In existing technologies, the verification of validation rules usually requires manually calling the changed databases sequentially via SQL on the database side to perform the corresponding configuration and validation based on the modified validation rules. This results in frequent calls, a large amount of data processing resources being consumed, and low processing efficiency.

[0043] To address this issue, this disclosure provides a rule verification method that periodically polls each database table on the database side based on a preset polling time interval and performs data verification on the changed verification rules. This can greatly reduce the consumption of data processing resources and significantly improve data verification efficiency.

[0044] The application scenarios of the embodiments of this disclosure are explained below:

[0045] Figure 1 This diagram illustrates an application scenario of the rule validation method provided in this embodiment of the disclosure. For example... Figure 1 As shown, after the financial accounting system 100 receives the verification rules configured by the user 120 on the client 110, it will synchronize the calibration rules to the database 130 so that the database 130 can poll the database tables to perform data verification, so that the user 120 can report subsequent data based on the configured verification rules.

[0046] It should be noted that, Figure 1 In the scenario shown, only one of the financial accounting system, client, database, and user is used as an example for illustration. However, the embodiments of this application are not limited to this. That is to say, the number of financial accounting system, client, database, and user can be arbitrary.

[0047] The rule verification method provided in this application is described in detail below through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments.

[0048] Figure 2 This is a flowchart illustrating a rule verification method provided in one embodiment of this disclosure. Figure 2 As shown, the rule verification method provided in this embodiment includes the following steps:

[0049] Step S201: Obtain the preset information of the database table to be verified.

[0050] The preset information includes a validation field and the current polling time interval.

[0051] Specifically, these are the reports in the database of a financial accounting system, i.e., database tables.

[0052] Since different settlement venues and trading venues usually have their own independent systems and their external verification rules are usually different, financial accounting systems need to adjust the message format of the transaction data or the field settings of the corresponding data forms when transmitting transaction data to different settlement venues or trading venues, that is, to correspond to different verification rules.

[0053] Furthermore, depending on the specific business, the regulatory agency (or settlement venue, hereinafter referred to as the regulatory agency) may differ, and the database tables involved in reporting data according to the verification rules will also vary. These database tables are the database tables to be verified.

[0054] Verification rules are the format requirements corresponding to messages (including reported data) provided by regulatory agencies. The process of verifying the data corresponding to the messages based on the verification rules to determine whether the data meets the requirements of the verification rules is called rule verification.

[0055] Each database table includes multiple fields, such as date, amount, and project name. Some of these are internally used fields, such as remarks, internal handlers, and explanatory information. These fields are usually not included in the message and therefore are not fields that need to be validated. Other fields may need to be validated depending on the validation rules. These fields that need to be validated can be pre-stored in preset information on the database side. When performing rule validation, the preset information can be called to determine the specific fields (i.e., validation fields) required in each database table, and the corresponding data can be validated accordingly.

[0056] The polling interval is a pre-set interval for polling database tables. After a rule validation is completed, the polling interval is elapsed, and then the various reports in the database need to be polled again (i.e., check the corresponding data in each report to see if its status or specified parameters have reached the specified values).

[0057] The polling interval is dynamically adjusted based on the actual polling time interval and whether database tables are validated each time. The adjusted polling interval is then stored in a preset information file as the current polling interval. This avoids situations where the polling interval is too long or too short, leading to wasted computing resources or insufficient polling efficiency.

[0058] Step S202: Based on the current polling time interval, perform data validation on the validation fields in the database table where the validation status parameter is set to a certain value.

[0059] The verification status parameter is a set value used to indicate that the verification rules of the database table have been updated.

[0060] Specifically, the validation status parameter indicates whether a database table needs validation. Depending on whether the user updates the validation rules for the corresponding database table on the client side, the validation status parameter will have different values. If the validation rules are updated, the validation status parameter will be set to a set value (e.g., 1), which means that the database table needs validation. Otherwise, the validation status parameter will be set to a default value (e.g., 0), which means that the database table does not need validation.

[0061] The verification status parameters correspond to specific database tables. For example, the customer investment record table and the customer savings record table will each correspond to different verification status parameters.

[0062] After a database table with a verification status parameter set to a certain value has been verified, its corresponding verification status parameter will be restored to the default value (i.e., no verification is required).

[0063] Therefore, by setting validation status parameters, the database processor no longer needs to read the validation rules of all database tables one by one. It only needs to select the database table whose validation rules are updated (the table whose validation status parameter has the set value) based on the validation status parameters, read the corresponding validation rules (stored in the database after being entered on the client side), and validate the validation fields in the database table based on these rules. This significantly reduces the number of validation rule reads during database table polling (since it no longer needs to retrieve validation rules from the client), thereby reducing data processing volume and the number of connections between the database and client during polling, ultimately improving resource utilization and processing efficiency.

[0064] Each time polling is performed, the processor uses a built-in timer to determine the time interval between the current time and the last polling time, thereby controlling the frequency of polling on the database side.

[0065] Step S203: Based on the data verification results and the current polling time interval, determine the latest polling time interval for the database table to be verified.

[0066] Specifically, after each polling, the frequency of data verification can be determined based on whether data verification (or rule verification) is performed, the cumulative number of data verifications performed, and the current polling time interval. Therefore, the time for the next data verification can be re-determined based on the frequency of data verification (i.e., determined by the current time and the newly determined latest polling time interval).

[0067] The principle for determining the latest polling interval is mainly to ensure that the data verification frequency is within an ideal range. That is, if the verification frequency is too high, the latest polling interval will be extended; if the verification frequency is too low, the polling interval needs to be shortened to avoid users being unable to use the verification rules configured on the client in a timely manner.

[0068] The rule verification method provided in this disclosure obtains preset information of the database table to be verified, then performs data verification on the verification fields of the database table with the verification status parameter set to a certain value based on the current polling time interval. Based on the data verification result and the current polling time interval, the latest polling time interval of the database table to be verified is determined. Thus, by dynamically determining the polling interval of the database table and periodically polling the database table based on the polling interval, and verifying database tables with updated verification rules, automated rule verification is achieved. This eliminates the need for modification on the database side every time the verification rules change, improving processing efficiency and avoiding the inefficiency caused by manually calling scripts to modify verification rules. Furthermore, by periodically polling the database table, the database only needs to be polled once within a polling time interval, avoiding the waste of computing resources caused by frequent database calls and verifications, and improving resource utilization efficiency.

[0069] Figure 3 This is a flowchart illustrating a rule verification method provided in one embodiment of this disclosure. Figure 3 As shown, the rule verification method provided in this embodiment includes the following steps:

[0070] Step S301: Obtain the preset information of the database table to be verified.

[0071] The preset information includes a validation field and the current polling time interval.

[0072] Specifically, this step is related to Figure 2 The steps of S201 in the illustrated embodiment are the same and will not be repeated here.

[0073] Step S302: Based on the current polling time interval, obtain the latest verification rules for the database table with the verification status parameter set to the set value.

[0074] Specifically, when the processor confirms that the current time interval has been reached between the current time and the time of the last database table polling (when it was completed), it will poll each database table again.

[0075] The polling method involves checking the verification status parameters corresponding to each database table on the database side. If the verification status parameter is a default value, the database table is skipped, and the verification status parameters of the next database table are checked directly. If the verification status parameter is a set value, the system communicates with the client to obtain the latest verification rules for that database table configured by the client.

[0076] Furthermore, the validation status parameters of the database table are determined in the following way:

[0077] In response to receiving a notification from the client that the verification status parameters have been modified, the verification status parameters of the database table are determined.

[0078] The notification information includes the verification status parameters of the database table.

[0079] Specifically, the verification status parameters on the database side are related to the verification status parameters configured on the client side. That is, when the verification status parameters configured on the client side change from the default value to the set value, the verification status parameters on the database side will also change from the default value to the set value (through notification information); when the verification status parameters on the database side change from the set value to the default value (after the verification of the corresponding database table is completed), the verification status parameters on the client side will also change from the set value to the default value.

[0080] The client's verification status parameters are based on whether the user has configured verification rules involving the corresponding database tables on the client. After the user has made the configuration (whether it is deletion, addition, or modification), the client will automatically detect the database tables associated with the configured verification rules and set their corresponding verification status parameters to the set values.

[0081] Users may configure the same database table multiple times within a period of time. If the database does not perform rule validation during that period, the validation status parameter of the same database table will remain at the set value and will not change.

[0082] Step S303: Based on the latest verification rules, perform data verification on the verification fields in the database table.

[0083] Specifically, data validation is performed on the validation fields in the database that involve the latest validation rules. This includes verifying whether the field names conform to the latest validation rules (which are configured by the user on the client and synchronously saved to the database), and whether the data corresponding to the relevant fields meets the format requirements of the latest validation rules. For example, if a latest validation rule requires that the date connector in a date field be changed from " / " to "-", then it is necessary to determine whether the format of each date data in the date field has been modified accordingly.

[0084] If the validation fields in the database table are inconsistent with the latest validation rules, the validation fields will be adjusted based on the latest validation rules, such as the format correction mentioned above, until the validation fields in the database table are consistent with the latest validation rules.

[0085] Step S304: Based on the data verification results and the current polling time interval, determine the verification frequency of the database table to be verified.

[0086] Specifically, to ensure that data configured with the latest verification rules can be verified in a timely manner so that users can report data according to the latest verification rules, it is necessary to adjust the polling time interval so that the verification frequency is always within the set range to ensure the user experience.

[0087] Since the polling interval is directly related to the verification frequency, it is necessary to first determine the verification frequency and then further determine the polling interval.

[0088] Furthermore, methods for determining the verification frequency include:

[0089] Step 1 (not shown): Based on the data verification results and data verification records, determine the number of verifications required for the database table to be verified.

[0090] Specifically, after each polling cycle, the results of data validation are recorded. This record indicates whether data validation was performed during the current polling cycle (if no validation rules are updated within the current polling interval, data validation is not required). This record is called the data validation record. The number of database tables validated in this polling cycle, as recorded in the data validation record, determines the number of data validation cycles. For example, if data validation was performed on 3 database tables in this polling cycle, the number of data validation cycles is 3.

[0091] Step 2 (not shown): Determine the verification frequency of the database table to be verified based on the number of verifications and the current polling time interval.

[0092] Specifically, the verification frequency is used to evaluate the number of verifications within the time interval from the last polling to the current polling (i.e., the current polling time interval). Therefore, the ratio of the number of verifications to the current polling time interval can be directly used as the verification frequency.

[0093] Step S305: Determine the latest polling time interval for the database table to be verified based on the preset correspondence between the verification frequency and the polling time interval and the verification frequency.

[0094] Specifically, the more database tables that require data validation in this polling cycle, the more validation rules have changed within the current polling interval, and the greater the likelihood that users will wait for the validation rules to pass data validation before reporting. Therefore, it is necessary to control the number of validations occurring within each polling interval.

[0095] The specific method for determining this can be determined by pre-setting different relationships between the verification frequency and the polling time interval.

[0096] For example, ideally, to ensure at least three polls per hour, but no more than once per minute, the preset verification frequency and polling time interval can be represented as follows:

[0097]

[0098] Where T1 is the latest polling time interval, T0 is the current polling time interval, f is the verification frequency, f1 is the minimum verification frequency under ideal conditions (e.g., three times per hour), and f2 is the maximum verification frequency under ideal conditions (e.g., 60 times per hour). Thus, by dynamically adjusting the latest polling time interval, the verification frequency is effectively guaranteed to be under ideal conditions, avoiding excessive consumption of computing resources or excessive delays that would affect the use by those skilled in the art.

[0099] Step S306: Determine that there is no database table whose verification status parameter has reached the set value.

[0100] Specifically, if the user does not configure a verification rule within the current polling interval, the processor will face the situation where no verification status parameter reaches the set value even if it polls the database table. In this case, there is no need to communicate with the client, and no data verification is required for this poll.

[0101] Step S307: Determine the latest polling time interval based on the current polling time interval.

[0102] Specifically, since no data validation was performed in this polling, meaning the corresponding validation frequency is 0, it could be that the current polling interval is too short and needs to be extended; or it could be that the current polling interval is normal, but no validation rule update has been encountered. Therefore, it is necessary to combine the current polling interval with the ideal polling interval to determine the latest polling interval.

[0103] In some embodiments, the latest polling time interval of the database table to be verified is determined based on the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

[0104] For example, ideally, at least three polls should be performed every 24 hours, but no more than once every 10 minutes. The relationship between the preset verification frequency and the polling time interval can be expressed as follows:

[0105]

[0106] Where T1 is the latest polling time interval, T0 is the current polling time interval, and T... l For the shortest polling interval under ideal conditions (e.g., 10 minutes), T h The maximum check frequency under ideal conditions (e.g., 60 times per hour) is set. Therefore, by dynamically adjusting the latest polling time interval, the check frequency is effectively guaranteed to be under ideal conditions, avoiding excessive consumption of computing resources or excessive delays that would affect the use by those skilled in the art.

[0107] Steps S306 to S307 are optional steps parallel to steps S304 to S305. Those skilled in the art can select the corresponding steps to perform according to the actual situation.

[0108] The rule verification method provided in this disclosure, after obtaining preset information of the database tables to be verified, verifies each database table based on the latest verification rules, and re-determines the latest polling time interval according to the verification results and whether there are any updates to the verification rules. This allows for dynamic adjustment of the polling time, avoiding unnecessary resource waste caused by excessively high polling frequencies and excessively low polling frequencies leading to long user waiting times and poor real-time performance. Furthermore, it eliminates the need for frequent connections between the database and client, improving processing efficiency.

[0109] Figure 4 This is a schematic diagram of the structure of a rule verification device provided in one embodiment of this disclosure. Figure 4 As shown, the rule verification device 400 includes: a receiving module 410, a processing module 420, and an updating module 430.

[0110] in:

[0111] The receiving module 410 is used to obtain preset information of the database table to be verified, including the verification field and the current polling time interval.

[0112] The processing module 420 is used to perform data validation on the validation field of the database table with the validation status parameter set to a set value based on the current polling time interval. The validation status parameter set to a set value indicates that the validation rules of the database table have been updated.

[0113] The update module 430 is used to determine the latest polling time interval of the database table to be verified based on the data verification results and the current polling time interval.

[0114] Optionally, the processing module 420 is specifically used to determine the verification status parameters of the database table in the following manner: in response to receiving a notification message from the client that the verification status parameters have been modified, the processing module 420 determines the verification status parameters of the database table, wherein the notification message contains the verification status parameters of the database table.

[0115] Optionally, the processing module 420 is specifically used to: obtain the latest verification rules for the database table whose verification status parameter is a set value based on the current polling time interval; and perform data verification on the verification fields in the database table based on the latest verification rules.

[0116] Optionally, the update module 430 is specifically used to: determine the verification frequency of the database table to be verified based on the data verification result and the current polling time interval; and determine the latest polling time interval of the database table to be verified according to the preset correspondence between the verification frequency and the polling time interval and the verification frequency.

[0117] Optionally, the update module 430 is specifically used to: determine the number of times the database table to be verified is to be verified based on the data verification results and data verification records; and determine the verification frequency of the database table to be verified based on the number of verifications and the current polling time interval.

[0118] Optionally, the processing module 420 is further configured to, after obtaining the preset information of the database table to be verified, determine that there is no database table whose verification status parameter has reached the set value; and determine the latest polling time interval based on the current polling time interval.

[0119] Optionally, the processing module 420 is specifically used to determine the latest polling time interval of the database table to be verified based on the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

[0120] In this embodiment, the rule verification device, through the combination of various modules, can dynamically determine the polling interval of the database table, and periodically poll the database table based on the polling interval. It can also verify the database table where the verification rules have been updated, thereby achieving automated rule verification. This eliminates the need to modify the database every time the verification rules change, thus improving processing efficiency.

[0121] Figure 5 This is a schematic diagram of the structure of a control device provided in one embodiment of the present disclosure, as shown below. Figure 5 As shown, the control device 500 includes a memory 510 and a processor 520.

[0122] The memory 510 stores a computer program that can be executed by at least one processor 520. This computer program is executed by at least one processor 520 to enable the control device to implement the rule verification method provided in any of the above embodiments.

[0123] The memory 510 and the processor 520 can be connected via a bus 530.

[0124] The relevant explanations can be understood by referring to the corresponding descriptions and effects in the method embodiments, and will not be repeated here.

[0125] One embodiment of this disclosure provides a computer-readable storage medium having a computer program stored thereon, the computer program being executed by a processor to implement the rule verification method provided in any of the above method embodiments.

[0126] The computer-readable storage medium can be ROM, random access memory (RAM), CD-ROM, magnetic tape, floppy disk, and optical data storage device, etc.

[0127] One embodiment of this disclosure provides a computer program product comprising computer execution instructions that, when executed by a processor, are used to implement the rule verification method provided in any of the above embodiments.

[0128] In the several embodiments provided in this application, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple modules or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or modules may be electrical, mechanical, or other forms.

[0129] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the disclosure herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope of this application is indicated by the claims.

[0130] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope.

Claims

1. A rule checking method, characterized by, The rule verification method includes: Retrieve the preset information of the database table to be verified, including the verification fields and the current polling time interval; In response to receiving a notification from the client, the verification status parameter of the database table corresponding to the notification is set to a set value. The set value of the verification status parameter is used to indicate that the verification rules of the database table have been updated. In response to the arrival of the current polling time interval, determine whether there exists a database table whose verification status parameter is the set value; If it exists, the latest verification rule of the database table whose verification status parameter is the set value is obtained, and the verification field in the database table is verified based on the latest verification rule. After the data verification is completed, the verification status parameter of the database table is reset to the default value. The number of database tables that underwent data verification in the current polling is recorded through the data verification record, and the number of times the database table to be verified is determined; based on the number of verifications and the current polling time interval, the verification frequency of the database table to be verified is determined. Based on the preset correspondence between the verification frequency and the polling time interval, and the verification frequency, the latest polling time interval for the next round of verification is determined.

2. The rule verification method of claim 1, wherein, If it is determined that there is no database table whose verification status parameter is the set value, the latest polling time interval for the next round of verification is determined according to the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

3. A rule checking apparatus characterized by comprising: The rule verification device includes: The receiving module is used to obtain the preset information of the database table to be verified. The preset information includes the verification field and the current polling time interval. The processing module is configured to, in response to receiving a notification message from a client, set the verification status parameter of the database table corresponding to the notification message to a set value, wherein the set value indicates that the verification rules of the database table have been updated; and to, in response to reaching the current polling time interval, determine whether there exists a database table with the set value as the verification status parameter; if so, obtain the latest verification rules of the database table with the set value as the verification status parameter, and perform data verification on the verification field in the database table based on the latest verification rules, and reset the verification status parameter of the database table to the default value after completing the data verification. The update module is used to record the number of database tables that have undergone data verification in the current polling, determine the number of times the database table to be verified needs to be verified, and determine the verification frequency of the database table to be verified based on the number of verifications and the current polling time interval. It is also used to determine the latest polling time interval for the next round of verification based on the preset correspondence between the verification frequency and the polling time interval and the verification frequency.

4. The rule verification device according to claim 3, characterized in that, The processing module is further configured to, in the case that there is no database table whose verification status parameter is the set value, determine the latest polling time interval for the next round of verification based on the correspondence between the preset polling time interval range and the target polling time interval and the current polling time interval.

5. A control device, characterized in that, include: At least one processor; and a memory communicatively connected to the at least one processor; The memory stores instructions that can be executed by the at least one processor, which, when executed by the at least one processor, cause the control device to perform the rule verification method as described in any one of claims 1 to 2.

6. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the rule verification method as described in any one of claims 1 to 2.

Images