A method, device and application for easily checking the validity of data application indicators

Abstract

This application proposes a method, device and application for easily checking the validity of data application indicators. It designs an indicator configuration table for the indicators to be audited, connects to the database through a python script and assigns the fields in the indicator configuration table to the python script, uses python to calculate the result value of each indicator to be audited and generates a result table, and checks the quality of the indicators to be audited based on the difference types in the result table, thereby achieving the effect of easily checking the quality of the indicators to be audited. At the same time, data inspection can be carried out during the data operation process, thereby improving the effectiveness of data quality inspection.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a method, device and application for easily checking the validity of data application indicators. Background Art

[0002] The development of digital government has yielded remarkable results. The efficiency of integrated government services and oversight has been significantly enhanced. New service management models such as "one-stop service," "one-stop visit," "one-stop management," and "one-stop collaboration" have become widespread. The digital business environment continues to improve, and the level of online government services has leapt into the ranks of the world's leading organizations. This success is inseparable from the data warehouse construction and data governance efforts of local big data bureaus.

[0003] Through data integration and governance, a strong data foundation is provided for digital government and city management, while centralized intelligence provides insights into daily city operations. With the advancement of digital reform, smart city intelligent operation centers have become a common data application display. Currently, most display sides do not perform data quality checks before display. The general practice is only to check data volume and data fluctuations during data collection synchronization and data model development. This can only guarantee the quality of a single data model and cannot perform validity checks on specific data application indicators. Therefore, it is impossible to guarantee the correctness of data application indicators, and it is impossible to achieve early detection and early processing. In most cases, manual intervention can only be carried out after anomalies are discovered in the data application display.

[0004] In the existing smart city intelligent operation center, for example, the smart urban management operation analysis topic includes: real-time events, street statistics, type statistics, common problems analysis, high-incidence problems, repeated problems and other indicators. At present, the data warehouse development from data collection, governance, and application interface is based on the big data governance platform. In some platforms that do not have data quality inspection or only support data table quality inspection, the quality of the data warehouse development process cannot be guaranteed. Although there is monitoring of scheduling tasks during the data warehouse development process, if there are errors, you can view the errors and interrupt the tasks, but there will also be some problems with the source data itself, such as business system migration and database deactivation. This situation will not affect the scheduling tasks of the data warehouse. Therefore, the data quality cannot be fully exposed in the scheduling, which will cause abnormal data to continue to be displayed in the data application. Summary of the Invention

[0005] The embodiments of the present application provide a method, device, and application for easily checking the validity of data application indicators, which utilize the Python programming language to achieve the effect of easily checking the validity of data application indicators.

[0006] In the first aspect, an embodiment of the present application provides a method for easily checking the validity of data application indicators, the method comprising: filling in an indicator configuration table stored in a database based on the indicators to be audited, wherein the indicator configuration table is configured with at least the identification information, calculation logic, cycle, indicator status and difference type of the indicators to be audited; connecting to the database using a python script, and introducing a time module into the python script; reading the indicator configuration table to assign values ​​to corresponding fields in the python script; running the current value calculation logic of each indicator to be audited, and replacing the time variable in the current value calculation logic with the current time of the time module to obtain a result value of each indicator to be audited; summarizing the result values ​​of all indicators to be audited to obtain a result table, and checking the quality of each indicator to be audited based on the result table.

[0007] In the second aspect, an embodiment of the present application provides a device for easily checking the validity of data application indicators, including: an indicator configuration table design unit, used to fill in the indicator configuration table stored in the database based on the indicator to be audited, wherein the indicator configuration table is configured with at least the identification information, calculation logic, cycle, indicator status and difference type of the indicator to be audited; a connection unit, used to connect to the database using a python script, and a time module is introduced into the python script; a reading unit, used to read the indicator configuration table to assign values ​​to corresponding fields in the python script; a calculation unit, used to run the current value calculation logic of each indicator to be audited, and use the time module to replace the time variable in the current value calculation logic to obtain the result value of each indicator to be audited; a verification unit, used to summarize the result values ​​of all indicators to be audited to obtain a result table, and verify the quality of each indicator to be audited based on the result table.

[0008] In a third aspect, an embodiment of the present application provides an electronic device comprising a memory and a processor, wherein the memory stores a computer program, and the processor is configured to run the computer program to execute the method for easily checking the validity of data application indicators.

[0009] In a fourth aspect, an embodiment of the present application provides a computer program product, comprising a software code portion. When the computer program product is run on a computer, the software code portion is used to execute the method for easily checking the validity of data application indicators according to the claim.

[0010] The main contributions and innovations of the present invention are as follows:

[0011] Design an indicator configuration table for the indicators to be audited, connect to the database through a python script and assign the fields in the indicator configuration table to the python script, use python to calculate the result value of each indicator to be audited and generate a result table, and check the quality of the indicators to be audited based on the difference type in the result table, so as to achieve the effect of easily checking the quality of the indicators to be audited. At the same time, data inspection can be carried out during the data operation process, which improves the effectiveness of data quality inspection.

[0012] The details of one or more embodiments of the present application are set forth in the following drawings and description to make other features, objects, and advantages of the present application more readily apparent. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0014] Figure 1 is a flowchart of a method for conveniently checking the validity of data application indicators according to an embodiment of the present application;

[0015] Figure 2 is a schematic diagram of an indicator configuration table according to an embodiment of the present application;

[0016] Figure 3 is a schematic diagram of a result table according to one embodiment of the present application;

[0017] Figure 4 2 is a schematic structural diagram of a device for conveniently checking the validity of data application indicators according to an embodiment of the present application;

[0018] Figure 5 Schematic diagram of the hardware structure of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0019] Exemplary embodiments will be described in detail herein, with examples illustrated in the accompanying drawings. In the following description, when referring to the drawings, identical numerals in different figures represent identical or similar elements, unless otherwise indicated. The implementations described in the following exemplary embodiments are not intended to represent all implementations consistent with one or more embodiments of this specification. Rather, they are merely examples of apparatuses and methods consistent with certain aspects of one or more embodiments of this specification, as detailed in the appended claims.

[0020] It should be noted that in other embodiments, the steps of the corresponding method are not necessarily performed in the order shown and described in this specification. In some other embodiments, the method may include more or fewer steps than those described in this specification. In addition, a single step described in this specification may be broken down into multiple steps for description in other embodiments, and multiple steps described in this specification may be combined into a single step for description in other embodiments.

[0021] Before introducing the technical solution of this program, we first introduce the explanation of the professional terms involved in this program:

[0022] Python: It provides efficient high-level data structures and simple, effective object-oriented programming. It is simple, easy to learn, read, and maintain. It has a wide range of programming applications and is fast. It is also free and open source software.

[0023] Example 1

[0024] like Figure 1 As shown, this application aims to propose a method for easily checking the validity of data application indicators, including the following steps:

[0025] Filling in an indicator configuration table stored in a database based on the indicator to be audited, wherein the indicator configuration table at least configures the identification information, calculation logic, cycle, indicator status, and difference type of the indicator to be audited;

[0026] Using a python script to connect to the database, the python script introduces a time module;

[0027] Read the indicator configuration table to assign values ​​to corresponding fields in the python script;

[0028] Run the current value calculation logic of each indicator to be audited, and replace the time variable in the current value calculation logic with the current time of the time module to obtain the result value of each indicator to be audited;

[0029] The result values ​​of all indicators to be audited are summarized to obtain a result table, and the quality of each indicator to be audited is verified based on the result table.

[0030] In this solution, users select indicators to be audited based on actual needs, and each indicator to be audited has its own data rationality. If the uploaded data obviously does not meet the data rationality, it means that the data is invalid. Based on the indicator to be audited and its data rationality, the verification type of the indicator to be audited can be obtained, and then the indicator validity of the indicator to be audited can be checked.

[0031] For example, in a project analyzing smart urban management operations, the user selects the following metrics for audit: today's number of reports, today's number of cases filed, today's number of cases closed, total number of reports, total number of cases filed, and total number of cases closed. Common irregularities in this audited data include: the total number of reports being 0, today's total number of reports being less than yesterday's and today's total number of reports. Specific verification types for this audited data include: determining if the data volume is zero, determining if data fluctuations are detected, and determining if enumerated values ​​are present.

[0032] That is, in the step of "filling the indicator configuration table stored in the database based on the indicator to be audited," the indicator to be audited is obtained, and the verification type of the indicator to be audited is determined based on the rationality of the data of the indicator to be audited. The indicator configuration table stored in the database is filled based on the verification type. The verification types include, but are not limited to, determining whether the data volume is zero, determining whether the data fluctuates, and determining whether the data value is enumerated.

[0033] The indicator configuration table is filled with the indicator configuration information corresponding to each indicator to be audited. The identification information of the indicator to be audited is used to uniquely identify the corresponding indicator to be audited. The calculation logic can also include current value calculation logic and target value calculation logic. The current value calculation logic records the current value calculation logic of the indicator to be audited, the target value calculation logic records the target value calculation logic of the indicator to be audited, the cycle records the audit cycle of the indicator to be audited, the indicator status records the indicator status of the indicator to be audited, and the difference type records the verification type of the indicator to be audited.

[0034] In this solution, the identification information of the indicator to be audited includes the indicator code to be audited, the indicator name to be audited and the business indicator name. The indicator code to be audited is a four-digit code that can be used to identify the uniqueness of the data table. The indicator name to be audited identifies the name of the indicator to be audited, and the business indicator name to be audited identifies the business meaning of the indicator to be audited. The current value calculation logic and / or the target value calculation logic are written as SQL statements containing variables. The indicator status is filled in with "valid" and "invalid" states. When the data meets the rationality, it is "valid"; the difference type corresponds to the verification type, and the corresponding verification type can be coded to refer to it.

[0035] In some embodiments, the indicator configuration table may further configure an alarm threshold for the indicators to be audited whose data volatility needs to be audited, and the alarm threshold serves as a verification standard for the data fluctuation value.

[0036] For example, Figure 2 As shown in the following figure, a configured indicator configuration table is provided. Figure 2As shown in the figure, the SQL statement is filled in for the current value calculation logic of the audited indicator "Today's Reported Data Verification". The target value calculation logic is empty, the alarm threshold is 0, the cycle is day, the indicator status is "valid", and the difference type is "1", which corresponds to the verification type of judging the data volume as 0.

[0037] A major highlight of this solution is that it uses Python statements to achieve lightweight data application indicator checks. Correspondingly, this solution introduces Python scripts to connect to the database.

[0038] In this solution, the time module introduced in the Python script is mainly used for parameter calculation. The current time can be used to replace the time variable in the calculation logic.

[0039] For example, in the calculation logic, create_dt = ${curDate}, where curDate is a time variable: the current date (YYYY-MM-DD). The time variables are assigned values: curDate = the current date, such as 2022-02-01; curMonth = the current date, such as 2022-02.

[0040] In some embodiments, the Python script connects to a database module, uses the database module to connect to the database and reads the configuration information in the indicator configuration table. In this case, the IP address, port, database name, account number, password, queue, and other information need to be entered to log in to the database using the database module.

[0041] In the step of "reading the indicator configuration table to assign values ​​to corresponding fields in the python script", the fields corresponding to the indicator configuration table are written in the python script, and the configuration information in the indicator configuration table read is assigned as values ​​to the corresponding fields.

[0042] The corresponding relationship between the fields in the Python script and the indicator configuration table is shown in Table 1 below:

[0043] Table 1 Correspondence between fields in the Python script and the indicator configuration table

[0044]

[0045]

[0046] It is worth mentioning that the field names in the Python script and the indicator configuration table are in a corresponding relationship. That is to say, changing the content of the indicator configuration table requires changing the field content of the corresponding Python script.

[0047] In the step of "running the calculation logic of each indicator to be audited, and using the current time of the time module to replace the time variable in the calculation logic to obtain the result value of each indicator to be audited", the current time of the time module of the python script is used to replace the time variable in the calculation logic of each indicator to be audited, and the result value of the indicator to be audited is calculated based on the calculation logic.

[0048] Specifically, if the calculation logic of each indicator to be audited is the current value calculation logic, the time module is used to replace the time variable in the current value calculation logic to obtain the current value of each indicator to be audited; if the calculation logic of each indicator to be audited is the target value calculation logic, the time module is used to replace the time variable in the target value calculation logic to obtain the target value of each indicator to be audited; of course, for the indicators to be audited that are configured with both the current value calculation logic and the target value calculation logic, the current value and target value of each indicator to be audited can be calculated at the same time.

[0049] In the step of "summarizing the result values ​​of all indicators to be audited to obtain a result table", the result table is configured with at least the identification information, result value, data date and difference type of the indicator to be audited.

[0050] The identification information of the indicator to be audited continues to use the identification information of the indicator to be audited in the indicator configuration table, the difference type continues to use the difference type in the indicator configuration table, the result value continues to use the result value calculated in the previous step, and the data date is the time when the result value is obtained.

[0051] In some embodiments, the result value includes a current value and a target value. In this case, the result table additionally includes a difference rate and a difference value, wherein the difference value is the difference between the current value and the target value, and the difference rate is the ratio of the difference value to the current value.

[0052] For example, Figure 3 As shown, Figure 3 A result table of an embodiment is provided, wherein the fields of the result table include: audit indicator code, audit indicator name, business indicator name, current value, target value, difference rate, difference value, difference type, data date, and remarks.

[0053] In the step of "verifying the quality of each indicator to be audited based on the result table," since the result table records the difference type for each indicator to be audited, the quality of the indicator to be audited is verified based on the difference type. Specifically, the corresponding field data in the result table is judged based on the difference type. If it does not meet the requirements, the indicator to be audited is judged as non-compliant.

[0054] Specifically, if the difference type is a judgment that the data volume is 0, then determine whether the result value is 0. If it is 0, it is a non-compliant indicator; if the difference type is a data fluctuation judgment data, then determine whether the difference value meets the alarm warning. If it does not meet the requirements, it is a non-compliant indicator; if the difference data is an enumeration value judgment, then determine whether the result value meets the enumeration value. If it does not meet the requirements, it is a non-compliant indicator.

[0055] In some preferred embodiments, if the quality of the audited indicator is found to be non-compliant based on the difference type, a report is generated for the non-compliant audited data and the corresponding result value. For example, the generated report is:

[0056] The number of reports (audit indicator name) today (period) is 0 (result value), please handle it in time.

[0057] The processing speed (audit indicator name) this month (cycle) has exceeded the predetermined threshold (result value, difference rate). Please handle it in a timely manner.

[0058] The solution provided by the present invention can improve the quality of data indicators and customer satisfaction in some platforms that do not have data quality checks or only support quality checks on data tables, and effectively avoid quality problems that cannot be fully exposed in scheduling due to problems with the source data itself, such as business system migration, database deactivation, etc.

[0059] Example 2

[0060] Based on the same concept, Figure 4 , the present application also proposes a device for conveniently checking the validity of data application indicators, comprising:

[0061] The indicator configuration table design unit 301 is used to fill in the indicator configuration table stored in the database based on the indicator to be audited, wherein the indicator configuration table is configured with at least the identification information, calculation logic, cycle, indicator status and difference type of the indicator to be audited;

[0062] A connection unit 302 is configured to connect to the database using a Python script, wherein a time module is introduced into the Python script;

[0063] The reading unit 303 is used to read the indicator configuration table to assign values ​​to corresponding fields in the Python script;

[0064] The calculation unit 304 is configured to run the current value calculation logic of each indicator to be audited, and replace the time variable in the current value calculation logic with the time module to obtain the result value of each indicator to be audited;

[0065] The checking unit 305 is configured to summarize the result values ​​of all indicators to be audited to obtain a result table, and check the quality of each indicator to be audited based on the result table.

[0066] The technical contents of the second embodiment that are the same as those of the first embodiment will not be described in detail here.

[0067] Example 3

[0068] This embodiment also provides an electronic device, referring to Figure 4 , including a memory 404 and a processor 402, wherein the memory 404 stores a computer program, and the processor 402 is configured to run the computer program to execute the steps in any of the above-mentioned method embodiments for easily checking the validity of data application indicators.

[0069] Specifically, the processor 402 may include a central processing unit (CPU), or an application-specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiments of the present application.

[0070] Among them, the memory 404 may include a large-capacity memory 404 for data or instructions. By way of example and not limitation, the memory 404 may include a hard disk drive (HDD), a floppy disk drive, a solid-state drive (SSD), a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive, or a combination of two or more of these. Where appropriate, the memory 404 may include a removable or non-removable (or fixed) medium. Where appropriate, the memory 404 may be inside or outside the data processing device. In a specific embodiment, the memory 404 is a non-volatile memory. In a specific embodiment, the memory 404 includes a read-only memory (ROM) and a random access memory (RAM). Where appropriate, the ROM may be a mask-programmed ROM, a programmable ROM (Programmable Read-Only Memory, abbreviated as PROM), an erasable PROM (Erasable Programmable Read-Only Memory, abbreviated as EPROM), an electrically erasable PROM (Electrically Erasable Programmable Read-Only Memory, abbreviated as EEPROM), an electrically alterable ROM (Electrically Alterable Read-Only Memory, abbreviated as EAROM) or a flash memory (FLASH) or a combination of two or more of these. In appropriate circumstances, the RAM can be a static random access memory (SRAM) or a dynamic random access memory (DRAM), wherein the DRAM can be a fast page mode dynamic random access memory 404 (FPMDRAM), an extended data output dynamic random access memory (EDODRAM), a synchronous dynamic random access memory (SDRAM), etc.

[0071] The memory 404 may be used to store or cache various data files that need to be processed and / or communicated, as well as computer program instructions for a method of conveniently checking the validity of data application indicators that may be executed by the processor 402 .

[0072] The processor 402 reads and executes computer program instructions stored in the memory 404 to implement any one of the methods for conveniently checking the validity of data application indicators in the above embodiments.

[0073] Optionally, the electronic device may further include a transmission device 406 and an input / output device 408 , wherein the transmission device 406 is connected to the processor 402 , and the input / output device 408 is connected to the processor 402 .

[0074] Transmission device 406 can be used to receive or send data via a network. Specific examples of the aforementioned network may include a wired or wireless network provided by a communications provider of the electronic device. In one embodiment, the transmission device includes a network interface controller (NIC), which can be connected to other network devices via a base station to enable communication with the Internet. In one embodiment, transmission device 406 can be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0075] The input / output device 408 is used to input or output information. In this embodiment, the input information may be indicators to be audited, and the output information may be a result table.

[0076] Optionally, in this embodiment, the processor 402 may be configured to execute the following steps through a computer program:

[0077] Filling in an indicator configuration table stored in a database based on the indicator to be audited, wherein the indicator configuration table at least configures the identification information, calculation logic, cycle, indicator status, and difference type of the indicator to be audited;

[0078] Using a python script to connect to the database, the python script introduces a time module;

[0079] Read the indicator configuration table to assign values ​​to corresponding fields in the python script;

[0080] Run the current value calculation logic of each indicator to be audited, and use the time module to replace the time variable in the current value calculation logic to obtain the result value of each indicator to be audited;

[0081] The result values ​​of all indicators to be audited are summarized to obtain a result table, and the quality of each indicator to be audited is verified based on the result table.

[0082] It should be noted that the specific examples in this embodiment can refer to the examples described in the above embodiments and optional implementation modes, and this embodiment will not be repeated here.

[0083] In general, various embodiments may be implemented in hardware or dedicated circuitry, software, logic, or any combination thereof. Some aspects of the invention may be implemented in hardware, while other aspects may be implemented in firmware or software that may be executed by a controller, microprocessor, or other computing device, but the invention is not limited thereto. Although various aspects of the invention may be shown and described as block diagrams, flow charts, or using some other graphical representation, it should be understood that, as non-limiting examples, the blocks, devices, systems, techniques, or methods described herein may be implemented in hardware, software, firmware, dedicated circuitry or logic, general-purpose hardware or a controller or other computing device, or some combination thereof.

[0084] Embodiments of the present invention can be implemented by computer software, which is executable by the data processor of the mobile device, such as in the processor entity, or is implemented by hardware, or is implemented by a combination of software and hardware. Computer software or programs (also referred to as program products) including software routines, applets and / or macros can be stored in any device-readable data storage medium, and they include program instructions for performing specific tasks. The computer program product can include one or more computer executable components configured to perform the embodiment when the program is running. One or more computer executable components can be at least one software code or a part thereof. In addition, at this point, it should be noted that any box of the logic flow in the figure can represent a program step, or interconnected logical circuits, boxes and functions, or a combination of program steps and logical circuits, boxes and functions. The software can be stored in physical media such as memory chips or storage blocks implemented in the processor, magnetic media such as hard disks or floppy disks, and optical media such as, for example, DVDs and their data variants, CDs. Physical media is non-transient media.

[0085] Those skilled in the art should understand that the technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0086] The above embodiments merely illustrate several embodiments of the present application. While the descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the present application. It should be noted that a person of ordinary skill in the art may make various modifications and improvements without departing from the spirit of the present application, all of which fall within the scope of protection of the present application. Therefore, the scope of protection of the present application shall be determined by the appended claims.

Claims

1. A method for conveniently checking the validity of data application indicators, characterized in that: The following steps are involved: Filling in an indicator configuration table stored in a database based on the indicator to be audited, wherein the indicator configuration table at least configures the identification information, calculation logic, cycle, indicator status, and difference type of the indicator to be audited; Using a python script to connect to the database, the python script introduces a time module; Read the indicator configuration table to assign values ​​to corresponding fields in the python script; Run the current value calculation logic of each indicator to be audited, and use the current time of the time module to replace the time variable in the current value calculation logic to obtain the result value of each indicator to be audited; The result values ​​of all indicators to be audited are summarized to obtain a result table, wherein the result table is configured with at least the identification information, result value, data date and difference type of the indicator to be audited, the result value includes the current value and the target value, and the result table is additionally configured with a difference rate and a difference value, the difference value is the difference between the current value and the target value, and the difference rate is the ratio of the difference value to the current value. The quality of each indicator to be audited is checked according to the result table, and the difference type for each indicator to be audited is recorded in the result table. The corresponding field data in the result table is judged based on the difference type. If it does not meet the requirements, the indicator to be audited is judged to be a non-compliant indicator.

2. The method for conveniently checking the validity of data application indicators according to claim 1, characterized in that: In the step of "filling in the indicator configuration table stored in the database based on the indicator to be audited", the indicator to be audited is obtained, and the verification type of the indicator to be audited is determined based on the data rationality of the indicator to be audited, and the indicator configuration table stored in the database is filled in based on the verification type.

3. The method for conveniently checking the validity of data application indicators according to claim 1, characterized in that: The identification information of the indicator to be audited is used to uniquely identify the corresponding indicator to be audited, the calculation logic at least includes current value calculation logic, and the difference type records the verification type of the indicator to be audited.

4. The method for conveniently checking the validity of data application indicators according to claim 1, characterized in that: In the step of "reading the indicator configuration table to assign values ​​to corresponding fields in the Python script", the fields corresponding to the indicator configuration table are written in the Python script, and the configuration information in the indicator configuration table read is assigned as values ​​to the corresponding fields.

5. A device for conveniently checking the validity of data application indicators, characterized in that: include: An indicator configuration table design unit is used to fill in an indicator configuration table stored in a database based on the indicator to be audited, wherein the indicator configuration table is configured with at least the identification information, calculation logic, cycle, indicator status, and difference type of the indicator to be audited; A connection unit, configured to connect to the database using a Python script, wherein a time module is introduced into the Python script; A reading unit, configured to read the indicator configuration table to assign values ​​to corresponding fields in the Python script; A calculation unit, configured to run the current value calculation logic of each indicator to be audited, and replace the time variable in the current value calculation logic with the time module to obtain the result value of each indicator to be audited; The verification unit is used to summarize the result values ​​of all indicators to be audited to obtain a result table, wherein the result table is configured with at least the identification information, result value, data date and difference type of the indicator to be audited, the result value includes the current value and the target value, and the result table is additionally configured with a difference rate and a difference value, the difference value is the difference between the current value and the target value, and the difference rate is the ratio of the difference value to the current value. The quality of each indicator to be audited is verified based on the result table, the difference type for each indicator to be audited is recorded in the result table, and the corresponding field data in the result table is judged based on the difference type. If it does not comply with the regulations, the indicator to be audited is judged to be a non-compliant indicator.

6. An electronic device comprising a memory and a processor, characterized in that: The memory stores a computer program, and the processor is configured to run the computer program to execute the method for conveniently checking the validity of data application indicators according to any one of claims 1 to 4.

7. A computer program product, characterized in that It comprises a software code portion, and when the computer program product is run on a computer, the software code portion is used to execute the method for conveniently checking the validity of data application indicators according to any one of claims 1 to 4.

Images