Verification method and device for index data in business report and electronic equipment

Abstract

The invention relates to a verification method and device for index data in a business report and electronic equipment, and belongs to the technical field of data processing. Comprising the steps of obtaining to-be-verified index data; obtaining identification information and source identification information of a business report associated with the index data, and coordinate information of the index data in the business report, and taking the identification information, the source identification information and the coordinate information as association information of the index data; according to the associated information, performing standardization processing on the index data to obtain standard index data; the method comprises the steps of obtaining a preset verification rule of standard index data, verifying the standard index data based on the verification rule, and obtaining a verification result of the to-be-verified index data, thereby achieving the unification of the formats of the index data through the standardization processing of the index data, improving the readability of the index data, and improving the verification efficiency of the to-be-verified index data. And the standard index data is verified based on the verification rule, so that the accuracy and efficiency in the index data verification process are improved.

Description

Technical Field

[0001] The present disclosure relates to the field of data processing, and in particular to a method, device and electronic device for verifying indicator data in a business report. Background Art

[0002] With the continuous development of society, new demands are constantly being put forward for the monitoring of financial indicators. For example, all 1104 reports contain multiple indicators, and it is necessary to verify whether there are any abnormalities in the indicators every day. In related technologies, indicator data is often checked and analyzed after data problems are found during the reporting period. In addition, the existing indicators are formed according to each business report, and there is no unified rule, which leads to low efficiency in determining abnormal indicators and certain business risks. Therefore, how to improve the accuracy and efficiency of the verification of indicator data in business reports has become an urgent problem to be solved. Summary of the invention

[0003] The present disclosure provides a method, device, electronic device, computer-readable storage medium and computer program product for verifying indicator data in a business report, so as to at least solve the problem of low efficiency and accuracy in the process of verifying indicator data in a business report in the related art.

[0004] The technical solution of the present disclosure is as follows:

[0005] According to a first aspect of an embodiment of the present disclosure, a method for verifying indicator data in a business report is provided, the method comprising: obtaining indicator data to be verified; obtaining identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and using the identification information, the source identification information and the coordinate information as associated information of the indicator data; performing standardization processing on the indicator data according to the associated information to obtain standard indicator data; obtaining verification rules preset for the standard indicator data, verifying the standard indicator data based on the verification rules, and obtaining verification results of the indicator data to be verified.

[0006] According to a second aspect of an embodiment of the present disclosure, a device for verifying indicator data in a business report is provided, the device comprising: a first acquisition module, configured to obtain indicator data to be verified; a second acquisition module, configured to obtain identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and use the identification information, the source identification information and the coordinate information as associated information of the indicator data; a processing module, configured to perform standardization processing on the indicator data according to the associated information to obtain standard indicator data; and a verification module, configured to obtain verification rules preset for the standard indicator data, verify the standard indicator data based on the verification rules, and obtain verification results of the indicator data to be verified.

[0007] According to a third aspect of an embodiment of the present disclosure, an electronic device is provided, comprising: a processor; and a memory for storing instructions executable by the processor; wherein the processor is configured to execute the instructions to implement the method for verifying indicator data in a business report as described in the first aspect.

[0008] According to the fourth aspect of an embodiment of the present disclosure, a computer-readable storage medium is provided. When the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device can execute the method for verifying indicator data in a business report as described in the first aspect.

[0009] According to a fifth aspect of an embodiment of the present disclosure, a computer program product is provided, including a computer program, which, when executed by a processor, implements the method for verifying indicator data in a business report as described in the first aspect.

[0010] The technical solution provided by the embodiments of the present disclosure brings at least the following beneficial effects: by acquiring the indicator data to be verified, obtaining the identification information and source identification information of the business report associated with the indicator data, and the coordinate information of the indicator data in the business report, the identification information, source identification information and coordinate information are used as the associated information of the indicator data, and the indicator data is standardized according to the associated information to obtain standard indicator data, and the verification rules preset for the standard indicator data are obtained, and the standard indicator data is verified based on the verification rules to obtain the verification results of the indicator data to be verified. Therefore, the present disclosure realizes the unification of the indicator data format and improves the readability of the indicator data by standardizing the indicator data, and verifies the standard indicator data based on the verification rules, thereby improving the accuracy and efficiency of the indicator data verification process.

[0011] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.

[0013] Figure 1 It is a flowchart of a method for verifying indicator data in a business report according to the first embodiment of the present disclosure.

[0014] Figure 2 It is a flowchart of a method for verifying indicator data in a business report according to the second embodiment of the present disclosure.

[0015] Figure 3 It is a block diagram of a device for verifying indicator data in a business report according to the first embodiment of the present disclosure.

[0016] Figure 4 It is a block diagram of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

[0017] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.

[0018] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present disclosure. Instead, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0019] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this disclosure are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards.

[0020] It should be noted that the acquisition, transmission, storage, use, and processing of data in the technical solution of the present disclosure are in compliance with the relevant provisions of relevant laws and regulations. In the embodiments of the present disclosure, certain software, components, models, and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present disclosure, but it does not mean that the applicant has or will necessarily use the solution.

[0021] Figure 1 It is a flowchart of a method for verifying indicator data in a business report according to the first embodiment of the present disclosure.

[0022] like Figure 1 As shown, the method for verifying indicator data in a business report in the first embodiment of the present disclosure includes the following steps:

[0023] S101, obtaining indicator data to be verified.

[0024] It should be noted that the present disclosure does not limit the specific method for obtaining the indicator data to be verified, and it can be selected according to actual conditions.

[0025] Optionally, business source data tables can be collected from the business system and stored in different levels of the data warehouse. The data warehouse can provide business source data to the data mart. For example, the data warehouse provides data to the regulatory mart, and can summarize the business supplementary data, reflux structure data and the provided business source data, and unify the data caliber to obtain the indicator data to be verified.

[0026] S102, obtaining identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and using the identification information, source identification information and coordinate information as associated information of the indicator data.

[0027] In the disclosed embodiment, information extraction may be performed on the business report associated with the indicator data to obtain identification information and source identification information of the business report associated with the indicator data, as well as coordinate information of the indicator data in the business report.

[0028] The identification information of the business report is usually a unique identifier used to distinguish different business reports. For example, the identification information of the business report may be business report number information, business report name information, and the like.

[0029] The source identification information of the business report is used to indicate the source of the indicator data. For example, the identification information of the business report may be the source organization number information.

[0030] The coordinate information of the indicator data in the business report is used to locate the position of the indicator data in the business report. For example, the coordinate information may be row number information and column number information.

[0031] S103, standardizing the indicator data according to the associated information to obtain standard indicator data.

[0032] It should be noted that since the existing indicator data are formed according to the business reports they belong to and there are no unified rules, the verification and maintenance process is relatively difficult. In the embodiments of the present disclosure, the indicator data can be standardized based on the related information to obtain standard indicator data, thereby achieving the unification of the indicator data format and improving the readability of the indicator data.

[0033] In an embodiment of the present disclosure, the indicator value corresponding to the indicator data can be obtained, the combination order of identification information, source identification information, coordinate information and indicator value can be obtained, and the identification information, source identification information, coordinate information and indicator value can be combined according to the combination order to obtain standard indicator data.

[0034] For example, if the combination order is identification information, coordinate information, source identification information and index value, when the identification information is G0100, the coordinate information is C6, the source identification is 100000000, and the index value is 5000.00, then the standard index data is I_G0100_C6_100000000 5000.00.

[0035] S104, obtaining the verification rules preset for the standard indicator data, verifying the standard indicator data based on the verification rules, and obtaining the verification results of the indicator data to be verified.

[0036] In the embodiments of the present disclosure, a structured query language (SQL) script corresponding to the verification rules can be pre-written based on the verification rules preset for the standard indicator data, and the structured query language SQL script corresponding to the verification rules can be called to verify the standard indicator data to obtain the verification results of the indicator data to be verified.

[0037] Optionally, the standard indicator data can be processed through an SQL script to obtain characteristic values ​​of the standard indicator data, and the characteristic values ​​of the standard indicator data can be verified through verification rules. In response to the characteristic values ​​of the standard indicator data not meeting the verification rules, the verification result of the indicator data to be verified is determined to be abnormal. In response to the characteristic values ​​of the standard indicator data meeting the verification rules, the verification result of the indicator data to be verified is determined to be normal.

[0038] In summary, according to the method for verifying indicator data in business reports provided by the embodiments of the present disclosure, by obtaining the indicator data to be verified, obtaining the identification information and source identification information of the business report associated with the indicator data, and the coordinate information of the indicator data in the business report, the identification information, source identification information and coordinate information are used as the associated information of the indicator data, and the indicator data is standardized according to the associated information to obtain standard indicator data, and the verification rules preset for the standard indicator data are obtained. The standard indicator data is verified based on the verification rules, and the verification results of the indicator data to be verified are obtained. Therefore, the present disclosure realizes the unification of the indicator data format and improves the readability of the indicator data by standardizing the indicator data, and verifies the standard indicator data based on the verification rules, thereby improving the accuracy and efficiency of the indicator data verification process.

[0039] Figure 2 It is a flowchart of a method for verifying indicator data in a business report according to the second embodiment of the present disclosure.

[0040] like Figure 2 As shown, the method for verifying indicator data in a business report in the second embodiment of the present disclosure includes the following steps:

[0041] S201, obtaining indicator data to be verified.

[0042] S202, obtaining identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and using the identification information, source identification information and coordinate information as associated information of the indicator data.

[0043] For the relevant contents of step S201 to step S202, please refer to the above embodiment and will not be repeated here.

[0044] As a possible implementation method, based on the above implementation, the specific process of standardizing the indicator data according to the associated information in step S103 to obtain the standard indicator data includes steps S203 to S205:

[0045] S203, obtaining the indicator value corresponding to the indicator data.

[0046] The indicator value refers to the specific numerical value or result corresponding to the indicator data.

[0047] Optionally, the index data may be directly extracted to obtain the index value corresponding to the index data.

[0048] S204, obtaining a combination sequence of identification information, source identification information, coordinate information and indicator value.

[0049] Optionally, the priorities of identification information, source identification information, coordinate information and index value may be obtained, and the identification information, source identification information, coordinate information and index value may be sorted in descending order according to the priority, and the priority sorting result may be used as the combination order.

[0050] For example, if the result of sorting in descending order of priority is: identification information, coordinate information, source identification information, and indicator value, the above order is used as the combination order.

[0051] S205, combining the identification information, the source identification information, the coordinate information and the indicator value in a combination order to obtain standard indicator data.

[0052] In the embodiment of the present disclosure, after the combination order is obtained, the identification information, source identification information, coordinate information and indicator value may be combined according to the combination order to obtain standard indicator data.

[0053] For example, if the combination order is identification information, coordinate information, source identification information and index value, when the identification information is G0100, the coordinate information is C6, the source identification is 100000000, and the index value is 5000.00, then the standard index data is I_G0100_C6_100000000 5000.00.

[0054] S206, obtaining preset verification rules for standard indicator data.

[0055] In the embodiments of the present disclosure, based on the verification rules preset for the standard indicator data, a SQL script corresponding to the verification rules can be pre-written, and the structured query language SQL script corresponding to the verification rules can be called to verify the standard indicator data to obtain the verification results of the indicator data to be verified.

[0056] As a possible implementation method, based on the above implementation, the specific process of calling the structured query language SQL script corresponding to the verification rule in the above step to verify the standard indicator data and obtain the verification result of the indicator data to be verified includes steps S207 to S2010:

[0057] S207, processing the standard indicator data through the SQL script to obtain characteristic values ​​of the standard indicator data.

[0058] In the disclosed embodiment, the standard indicator data is batch processed through SQL scripts to obtain characteristic values ​​of the standard indicator data.

[0059] It should be noted that the characteristic values ​​of standard indicator data include but are not limited to year-on-year values, month-on-month values, cycle values, maximum values ​​and minimum values, etc.

[0060] S208, verifying the characteristic values ​​of the standard indicator data through verification rules.

[0061] In the embodiment of the present disclosure, after the characteristic value of the standard indicator data is obtained, the characteristic value of the standard indicator data can be verified by the verification rule to determine the verification result of the indicator data to be verified.

[0062] S209: In response to the characteristic value of the standard indicator data not meeting the verification rule, determining that the verification result of the indicator data to be verified is abnormal.

[0063] For example, for the month-on-month value of the standard indicator data, determine whether the month-on-month value of the standard indicator data is greater than or equal to 50%. If the month-on-month value of the standard indicator data is greater than or equal to 50%, the month-on-month value of the standard indicator data does not meet the verification rules, and the verification result of the indicator data to be verified is determined to be abnormal.

[0064] For example, for the year-on-year value of the standard indicator data, determine whether the year-on-year value of the standard indicator data is greater than or equal to 100%. If the month-on-month value of the standard indicator data is greater than or equal to 100%, the year-on-year value of the standard indicator data does not meet the verification rules, and the verification result of the indicator data to be verified is determined to be abnormal.

[0065] For example, for the periodic value of the standard indicator data, if the periodic value of the standard indicator data is 0 in this period, and the periodic value of the standard indicator data in the previous period is not 0, then the periodic value of the standard indicator data does not meet the verification rules, and the verification result of the indicator data to be verified is determined to be abnormal. If the periodic value of the standard indicator data is not 0 in this period, and the periodic value of the standard indicator data in the previous period is 0, then the periodic value of the standard indicator data does not meet the verification rules, and the verification result of the indicator data to be verified is determined to be abnormal. If the periodic value of the standard indicator data is less than 0, then the periodic value of the standard indicator data does not meet the verification rules, and the verification result of the indicator data to be verified is determined to be abnormal.

[0066] S2010 , in response to the characteristic value of the standard indicator data meeting the verification rule, determining that the verification result of the indicator data to be verified is normal.

[0067] In the embodiment of the present disclosure, after the characteristic value of the standard indicator data is acquired, in response to the characteristic value of the standard indicator data meeting all the verification rules, it is determined that the verification result of the indicator data to be verified is normal.

[0068] In an embodiment of the present disclosure, after determining the verification result of the indicator data to be verified, the label of the first indicator data with a normal verification result can be determined as a first label value, and the label is added to the first indicator data, and the label of the second indicator data with an abnormal verification result can be determined as a second label value, and the label is added to the second indicator data.

[0069] It should be noted that the present disclosure does not limit the setting of the first label value. Optionally, the first label value can be set to 0.

[0070] For example, the standard indicator data is I_G0100_C6_100000000 5000.00. If the characteristic value of the standard indicator data meets the verification rule (the verification result is normal), I_G0100_C6_100000000 5000.00 is the first indicator data, and a label is added to the first indicator data to obtain: I_G0100_C6_100000000 5000.00 0.

[0071] In an embodiment of the present disclosure, the abnormal type of the second indicator data is obtained, a mapping relationship table between the abnormal type and the abnormal label value is obtained, the mapping relationship table is queried, and the abnormal label value corresponding to the abnormal type is used as the second label value of the second indicator data.

[0072] For example, when the month-on-month value of the standard indicator data does not meet the verification rules, the abnormal type is determined to be the first abnormal type, and the abnormal label value is determined to be 1; when the year-on-year value of the standard indicator data does not meet the verification rules, the abnormal type is determined to be the second abnormal type, and the abnormal label value is determined to be 2; when the period value of the standard indicator data in this period is 0 and the period value of the standard indicator data in the previous period is not 0, the abnormal type is determined to be the third abnormal type, and the abnormal label value is determined to be 3; when the period value of the standard indicator data in this period is not 0 and the period value of the standard indicator data in the previous period was 0, the abnormal type is determined to be the fourth abnormal type, and the abnormal label value is determined to be 4; when the period value of the standard indicator data is less than 0, the abnormal type is determined to be the fifth abnormal type, and the abnormal label value is determined to be 5.

[0073] In the embodiment of the present disclosure, after obtaining the exception type and the exception label value corresponding to the exception type, a mapping relationship table between the exception type and the exception label value can be constructed. By querying the mapping relationship table, the exception label value corresponding to the exception type is used as the second label value of the second indicator data.

[0074] For example, the standard indicator data is I_G0100_C6_100000000 5000.00. If the month-on-month value of the standard indicator data does not meet the verification rule, I_G0100_C6_100000000 5000.00 is the second indicator data, and the abnormal type of the second indicator data is the first type. By querying the mapping relationship table, the abnormal label value is 1, and the label is added to the second indicator data to obtain: I_G0100_C6_100000000 5000.00 1.

[0075] In the disclosed embodiment, the second indicator data is summarized, an abnormal indicator data table constructed by the second indicator data is obtained, and the abnormal indicator data table is sent to the front end.

[0076] In the embodiment of the present disclosure, in order to improve the accuracy and timeliness of the verification of indicator data, the target identification information of the business report associated with the second indicator data can be obtained, and based on the target identification information and the second indicator data, abnormal prompt information can be generated, and the abnormal prompt information can be sent to the operation and maintenance personnel for tracking and investigation.

[0077] In summary, according to the verification method of indicator data in the business report provided by the embodiment of the present disclosure, by obtaining the indicator data to be verified, obtaining the identification information and source identification information of the business report associated with the indicator data, and the coordinate information of the indicator data in the business report, the identification information, the source identification information and the coordinate information are used as the associated information of the indicator data, the indicator value corresponding to the indicator data is obtained, the combination order of the identification information, the source identification information, the coordinate information and the indicator value is obtained, and the identification information, the source identification information, the coordinate information and the indicator value are combined according to the combination order to obtain the standard indicator data, and the verification rules preset for the standard indicator data are obtained. The SQL script processes the standard indicator data, obtains the characteristic value of the standard indicator data, verifies the characteristic value of the standard indicator data through the verification rules, and in response to the characteristic value of the standard indicator data not meeting the verification rules, determines that the verification result of the indicator data to be verified is abnormal, and in response to the characteristic value of the standard indicator data meeting the verification rules, determines that the verification result of the indicator data to be verified is normal. Therefore, the present disclosure realizes the unification of the indicator data format and improves the readability of the indicator data by standardizing the indicator data, and can obtain the verification results more quickly and accurately, which greatly reduces the extraction, conversion, and loading (Extract Transform Load, referred to as ETL) operation and maintenance work of the indicator data. The abnormal type and abnormal indicator data can be quickly located through the label value, which is conducive to the rapid processing of abnormal indicator data in the later stage and provides data support for subsequent business analysis.

[0078] Figure 3 It is a block diagram of a device for verifying indicator data in a business report according to the first embodiment of the present disclosure.

[0079] like Figure 3 As shown, the device 300 for verifying indicator data in a business report of an embodiment of the present disclosure includes: a first acquisition module 301 , a second acquisition module 302 , a processing module 303 and a verification module 304 .

[0080] The first acquisition module 301 is configured to acquire the indicator data to be verified;

[0081] The second acquisition module 302 is configured to acquire identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and use the identification information, the source identification information and the coordinate information as associated information of the indicator data;

[0082] The processing module 303 is configured to perform standardization processing on the indicator data according to the associated information to obtain standard indicator data;

[0083] The verification module 304 is configured to obtain the verification rules preset for the standard indicator data, verify the standard indicator data based on the verification rules, and obtain the verification results of the indicator data to be verified.

[0084] In one embodiment of the present disclosure, the processing module 303 is also configured to: obtain the indicator value corresponding to the indicator data; obtain the combination order of the identification information, the source identification information, the coordinate information and the indicator value; and combine the identification information, the source identification information, the coordinate information and the indicator value according to the combination order to obtain the standard indicator data.

[0085] In one embodiment of the present disclosure, the verification module 304 is further configured to: call a structured query language SQL script corresponding to the verification rule, verify the standard indicator data, and obtain the verification result of the indicator data to be verified.

[0086] In one embodiment of the present disclosure, the verification module 304 is further configured to: process the standard indicator data through the SQL script to obtain the characteristic value of the standard indicator data; verify the characteristic value of the standard indicator data through the verification rule; in response to the characteristic value of the standard indicator data not meeting the verification rule, determine that the verification result of the indicator data to be verified is abnormal; in response to the characteristic value of the standard indicator data meeting the verification rule, determine that the verification result of the indicator data to be verified is normal.

[0087] In one embodiment of the present disclosure, the device 300 is also configured to: determine that the label of the first indicator data with a normal verification result is a first label value, and add a label to the first indicator data; determine that the label of the second indicator data with an abnormal verification result is a second label value, and add a label to the second indicator data.

[0088] In one embodiment of the present disclosure, the device 300 is also configured to: obtain the abnormal type of the second indicator data; obtain a mapping relationship table between the abnormal type and the abnormal label value, query the mapping relationship table, and use the abnormal label value corresponding to the abnormal type as the second label value of the second indicator data.

[0089] In one embodiment of the present disclosure, after determining that the verification result of the indicator data to be verified is abnormal, the device 300 is also configured to: summarize the second indicator data, obtain an abnormal indicator data table constructed by the second indicator data; and send the abnormal indicator data table to the front end.

[0090] In one embodiment of the present disclosure, after determining that the verification result of the indicator data to be verified is abnormal, the device 300 is also configured to: obtain target identification information of the business report associated with the second indicator data; and generate abnormal prompt information based on the target identification information and the second indicator data.

[0091] Regarding the device in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.

[0092] In summary, the verification device for indicator data in business reports provided by the embodiments of the present disclosure obtains the indicator data to be verified, obtains the identification information and source identification information of the business report associated with the indicator data, and the coordinate information of the indicator data in the business report, and uses the identification information, source identification information and coordinate information as the associated information of the indicator data, and performs standardization processing on the indicator data according to the associated information to obtain standard indicator data, obtains the verification rules preset for the standard indicator data, verifies the standard indicator data based on the verification rules, and obtains the verification results of the indicator data to be verified. Therefore, the present disclosure realizes the unification of the indicator data format and improves the readability of the indicator data by performing standardization processing on the indicator data, and verifies the standard indicator data based on the verification rules, thereby improving the accuracy and efficiency in the indicator data verification process.

[0093] Figure 4 It is a block diagram of an electronic device according to an exemplary embodiment.

[0094] like Figure 4 As shown, the electronic device 400 includes:

[0095] The memory 410 and the processor 420, a bus 430 connecting different components (including the memory 410 and the processor 420), the memory 410 stores a computer program, and when the processor 420 executes the program, the method for verifying indicator data in the business report described in the embodiment of the present disclosure is implemented.

[0096] Bus 430 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnect (PCI) bus.

[0097] The electronic device 400 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by the electronic device 400, including volatile and non-volatile media, removable and non-removable media.

[0098] The memory 410 may also include computer system readable media in the form of volatile memory, such as random access memory (RAM) 440 and / or cache memory 450. The electronic device 400 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 460 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 not shown, usually called a "hard drive"). Although Figure 4 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 430 via one or more data medium interfaces. The memory 410 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present disclosure.

[0099] A program / utility 480 having a set (at least one) of program modules 470 may be stored, for example, in the memory 410, such program modules 470 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 470 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0100] The electronic device 400 may also communicate with one or more external devices 490 (e.g., keyboard, pointing device, display 491, etc.), one or more devices that enable a user to interact with the electronic device 400, and / or any device that enables the electronic device 400 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed through an input / output (I / O) interface 492. Furthermore, the electronic device 400 may also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN) and / or public network, such as the Internet) through a network adapter 493. Figure 4 As shown, the network adapter 493 communicates with other modules of the electronic device 400 via the bus 430. It should be understood that, although not shown in the figure, other hardware and / or software modules can be used in conjunction with the electronic device 400, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0101] The processor 420 executes various functional applications and data processing by running the programs stored in the memory 410 .

[0102] It should be noted that the implementation process and technical principles of the electronic device of this embodiment refer to the aforementioned explanation of the method for verifying indicator data in the business report of the embodiment of the present disclosure, and will not be repeated here.

[0103] In summary, the electronic device provided by the embodiment of the present disclosure can execute the verification method of indicator data in the business report as described above, by obtaining the indicator data to be verified, obtaining the identification information and source identification information of the business report associated with the indicator data, and the coordinate information of the indicator data in the business report, and using the identification information, source identification information and coordinate information as the associated information of the indicator data, and standardizing the indicator data according to the associated information to obtain standard indicator data, obtaining the verification rules preset for the standard indicator data, verifying the standard indicator data based on the verification rules, and obtaining the verification results of the indicator data to be verified. Therefore, the present disclosure realizes the unification of the indicator data format and improves the readability of the indicator data by standardizing the indicator data, and verifies the standard indicator data based on the verification rules, thereby improving the accuracy and efficiency of the indicator data verification process.

[0104] In order to implement the above embodiments, the present disclosure also proposes a computer-readable storage medium.

[0105] When the instructions in the computer-readable storage medium are executed by the processor of the electronic device, the electronic device can implement the verification method of the indicator data in the business report as described above. Optionally, the computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0106] In order to implement the above embodiments, the present disclosure also provides a computer program product, including a computer program, characterized in that when the computer program is executed by a processor, the method for verifying indicator data in the business report as described above is implemented.

[0107] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are to be considered exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.

[0108] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A method for verifying indicator data in a business report, characterized in that: The method comprises: Obtain the indicator data to be verified; Acquire identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and use the identification information, the source identification information, and the coordinate information as associated information of the indicator data; According to the associated information, the indicator data is standardized to obtain standard indicator data; The verification rules preset for the standard indicator data are obtained, the standard indicator data are verified based on the verification rules, and the verification results of the indicator data to be verified are obtained.

2. The method according to claim 1, characterized in that The step of performing standardization processing on the indicator data according to the associated information to obtain standard indicator data includes: Obtaining an indicator value corresponding to the indicator data; Acquire a combination order of the identification information, the source identification information, the coordinate information, and the indicator value; The identification information, the source identification information, the coordinate information and the indicator value are combined in the combination order to obtain the standard indicator data.

3. The method according to claim 1, characterized in that: The verifying the standard indicator data based on the verification rule to obtain the verification result of the indicator data to be verified includes: The structured query language SQL script corresponding to the verification rule is called to verify the standard indicator data to obtain the verification result of the indicator data to be verified.

4. The method according to claim 3, characterized in that The calling of the structured query language SQL script corresponding to the verification rule to verify the standard indicator data and obtain the verification result of the indicator data to be verified includes: Processing the standard indicator data through the SQL script to obtain characteristic values ​​of the standard indicator data; Verifying the characteristic value of the standard indicator data according to the verification rule; In response to the characteristic value of the standard indicator data not meeting the verification rule, determining that the verification result of the indicator data to be verified is abnormal; In response to the characteristic value of the standard indicator data conforming to the verification rule, it is determined that the verification result of the indicator data to be verified is normal.

5. The method according to claim 4, characterized in that The method further comprises: Determine that the label of the first indicator data whose verification result is normal is the first label value, and add the label to the first indicator data; Determine that the label of the second indicator data with an abnormal verification result is a second label value, and add a label to the second indicator data.

6. The method according to claim 5, characterized in that The label of the second indicator data for determining that the verification result is abnormal is a second label value, including: Obtaining the abnormal type of the second indicator data; Obtain a mapping relationship table between anomaly types and anomaly label values, query the mapping relationship table, and use the anomaly label value corresponding to the anomaly type as the second label value of the second indicator data.

7. The method according to claim 5 or 6, characterized in that: After determining that the verification result of the indicator data to be verified is abnormal, the method includes: Summarizing the second indicator data to obtain an abnormal indicator data table constructed by the second indicator data; The abnormal indicator data table is sent to the front end.

8. The method according to claim 5 or 6, characterized in that: After determining that the verification result of the indicator data to be verified is abnormal, the method includes: Obtaining target identification information of the business report associated with the second indicator data; Based on the target identification information and the second indicator data, abnormal prompt information is generated.

9. A device for verifying indicator data in a business report, characterized in that: The device comprises: A first acquisition module is configured to acquire indicator data to be verified; A second acquisition module is configured to acquire identification information and source identification information of a business report associated with the indicator data, and coordinate information of the indicator data in the business report, and use the identification information, the source identification information and the coordinate information as associated information of the indicator data; A processing module is configured to perform standardization processing on the indicator data according to the associated information to obtain standard indicator data; The verification module is configured to obtain the verification rules preset for the standard indicator data, verify the standard indicator data based on the verification rules, and obtain the verification results of the indicator data to be verified.

10. An electronic device, characterized in that: include: processor; a memory for storing instructions executable by the processor; Wherein, the processor is configured to execute the instructions to implement the method for verifying indicator data in the business report as described in any one of claims 1-8.

11. A computer-readable storage medium, when the instructions in the computer-readable storage medium are executed by a processor of an electronic device, enables the electronic device to execute the method for verifying indicator data in a business report as described in any one of claims 1-8.

12. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, a method for verifying indicator data in a business report as described in any one of claims 1-8 is implemented.

Images