Method and device for detecting report data, storage medium and electronic equipment

By comparing the original and updated data images of the report system, determining the difference area and performing detection tasks, the problem of data errors in the report system is solved, and the reliability and detection efficiency of report data are improved.

CN119166622AInactive Publication Date: 2024-12-20广州三七极耀网络科技有限公司
View PDF 7 Cites 0 Cited by

Patent Information

Application Number
CN202411267482.7
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-10
Publication Date
2024-12-20
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

Existing reporting systems are prone to data errors or format errors after adding preset filter conditions, resulting in incomplete detection or errors, and reducing the reliability and efficiency of report data.

Method used

By receiving reports, obtaining instructions, querying the data of the original and updated report system, generating images, performing image comparison and determining the difference area, and performing detection tasks based on the difference area, judging data differences and exceptions, and generating detection codes to correct logic.

Benefits of technology

It improves the accuracy and reliability of the updated report system output, improves detection efficiency, and ensures the integrity and accuracy of report data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119166622A_ABST
    Figure CN119166622A_ABST
Patent Text Reader

Abstract

The invention discloses a method and device for detecting report data, a storage medium and electronic equipment. In the method, a report obtaining instruction is received, report data corresponding to the report obtaining instruction is inquired from an original report system according to the report obtaining instruction to serve as first report data, and report data corresponding to the report obtaining instruction is inquired from an updated report system according to the report obtaining instruction to serve as second report data, and performing screenshot on the first report data to obtain a first report image, performing screenshot on the second report data to obtain a second report image, comparing the first report image with the second report image to determine a difference image area, and executing a detection task according to the difference image area.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

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

[0002] A reporting system is a software designed by combining computer technology with reporting methods and is specifically used for reporting data processing. Reporting systems are widely used in corporate management, data analysis, and financial reporting. The required data can be obtained by using various screening conditions preset in the reporting system.

[0003] Moreover, as business needs continue to change, technical personnel will add preset filtering conditions accordingly based on business needs. For example, if the business need of the operation staff is to obtain a report on the number of game users who download and the recharge amount within every hour of the day, the technical personnel will add filtering conditions at hourly intervals. However, adding new preset filtering conditions may cause errors in the reporting system program, resulting in some data content errors or data format errors in the reports output by the reporting system.

[0004] Currently, the updated report data is mainly tested by manual inspection. However, due to the large amount of report data, it is easy to have incomplete inspection or erroneous inspection results, which reduces the reliability and efficiency of the report data. Summary of the invention

[0005] The embodiments of this specification provide a method, device, storage medium and electronic device for detecting report data to partially solve the problems existing in the above-mentioned prior art.

[0006] The embodiments of this specification adopt the following technical solutions:

[0007] This specification provides a method for detecting report data, including:

[0008] Receive report acquisition instructions;

[0009] According to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the original report system as the first report data; and according to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the updated report system as the second report data, wherein the updated report system is updated based on the original report system;

[0010] Taking a screenshot of the first report data to obtain a first report image, and taking a screenshot of the second report data to obtain a second report image;

[0011] Comparing the first report image with the second report image to determine a difference image area;

[0012] A detection task is performed according to the difference image area.

[0013] Optionally, the step of comparing the first report image with the second report image to determine a difference image area specifically includes:

[0014] Performing text recognition on the first report image to determine the coordinate position corresponding to each data contained in the first report image, and using the data corresponding to the coordinate position as standard data;

[0015] According to the coordinate position, determine the data corresponding to the coordinate position in the second report image as the data to be detected;

[0016] The data to be detected is compared with the standard data to determine the difference image area.

[0017] Optionally, the method further comprises:

[0018] Determining whether the difference image area contains specified field data;

[0019] If included, the designated field data contained in the difference image area is displayed according to a preset display method.

[0020] Optionally, the step of performing a detection task according to the difference image area specifically includes:

[0021] determining, according to the difference image area, difference data included in the second report data relative to the first report data;

[0022] Determining associated data corresponding to the difference data in the second report data;

[0023] According to the associated data, a detection task is performed on the difference data.

[0024] Optionally, the step of comparing the first report image with the second report image to determine a difference image area specifically includes:

[0025] For each area included in the first report image, determine the area size of the area in the first report image, where different areas in the first report image contain different types of report data;

[0026] Determining in the second report image the regions that match the regions included in the first report image respectively, and adjusting in the second report image the region sizes of the regions that match the regions included in the first report image according to the region sizes of each region in the first report image in the first report image, to obtain an adjusted second report image;

[0027] A difference image area is determined according to the adjusted second report image.

[0028] Optionally, the step of determining the difference image area according to the adjusted second report image specifically includes:

[0029] Among the regions included in the adjusted second report image, a region having a region size different from other regions is determined as a determined difference image region.

[0030] Optionally, the method further comprises:

[0031] Determining abnormal data from the second report data according to the detection result obtained after executing the detection task;

[0032] Determine the field of the abnormal data in the second report data;

[0033] generating a prompt statement for the field;

[0034] Inputting the prompt statement into a preset model to generate a detection code for the field through the preset model;

[0035] The detection code is run in the updated reporting system to detect the reporting logic for generating the field value corresponding to the field in the updated reporting system.

[0036] This specification provides a detection report data device, including:

[0037] A receiving module, used for receiving a report acquisition instruction;

[0038] a query module, configured to query, according to the report acquisition instruction, from an original report system the report data corresponding to the report acquisition instruction as first report data, and query, according to the report acquisition instruction, from an updated report system as second report data, wherein the updated report system is updated based on the original report system;

[0039] A screenshot module, used to take a screenshot of the first report data to obtain a first report image, and to take a screenshot of the second report data to obtain a second report image;

[0040] A comparison module, used for comparing the first report image with the second report image to determine a difference image area;

[0041] An execution module is used to execute a detection task according to the difference image area.

[0042] This specification provides a computer-readable storage medium, wherein the storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned method for detecting report data is implemented.

[0043] The present specification provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the above-mentioned method for detecting report data is implemented.

[0044] At least one of the above technical solutions adopted in the embodiments of this specification can achieve the following beneficial effects:

[0045] In an embodiment of the present specification, a report acquisition instruction is received, and according to the report acquisition instruction, report data corresponding to the report acquisition instruction is queried from an original report system as first report data, and according to the report acquisition instruction, report data corresponding to the report acquisition instruction is queried from an updated report system as second report data, and then, a screenshot of the first report data is taken to obtain a first report image, and a screenshot of the second report data is taken to obtain a second report image, and the first report image is compared with the second report image to determine a difference image area, thereby performing a detection task according to the difference image area, wherein the updated report system is updated on the basis of the original report system.

[0046] In this method, by comparing the report image obtained from the original reporting system and the report image obtained from the updated reporting system, it is determined whether the report output from the updated reporting system is accurate, thereby improving the accuracy and reliability of the report output by the updated reporting system and further improving the detection efficiency of the reporting system. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0048] Figure 1 A flowchart of a method for detecting report data provided in an embodiment of this specification;

[0049] Figure 2 A flowchart of a method system for detecting report data provided in an embodiment of this specification;

[0050] Figure 3 A schematic diagram of the structure of a detection report data device provided in an embodiment of this specification;

[0051] Figure 4 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this specification. DETAILED DESCRIPTION

[0052] In order to make the purpose, technical solutions and advantages of this specification more clear, the technical solutions of this specification will be clearly and completely described below in combination with the specific embodiments of this specification and the corresponding drawings. Obviously, the described embodiments are only part of the embodiments of this specification, not all of them. Based on the embodiments in this specification, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this specification.

[0053] The technical solutions provided by the embodiments of this specification are described in detail below in conjunction with the accompanying drawings.

[0054] Figure 1 A flowchart of a method for detecting report data provided in an embodiment of this specification includes:

[0055] S100: receiving a report acquisition instruction.

[0056] For a method for detecting report data provided in this specification, a terminal device such as a desktop computer, a laptop computer, etc. can be used as an execution subject, or a server can be used as an execution subject. For the sake of ease of description, the following describes a method for detecting report data provided in this specification with only a terminal device as the execution subject.

[0057] First, the terminal device receives a report acquisition instruction, and obtains report data corresponding to the original report system and the updated report system through the report acquisition instruction.

[0058] The report acquisition instruction mentioned here may be a database query instruction corresponding to the original report system and a database query instruction corresponding to the updated report system, or may be a preset report address, each report address corresponding to a report.

[0059] S102: According to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the original report system as the first report data, and according to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the updated report system as the second report data, wherein the updated report system is updated based on the original report system.

[0060] In the embodiment of the present specification, after receiving the report acquisition instruction, the terminal device will query the report data corresponding to the report acquisition instruction from the original report system as the first report data, and query the report data corresponding to the report acquisition instruction from the updated report system as the second report data, that is, respectively obtain the report corresponding to the original report system and the report corresponding to the updated report system for the same set of data. In this way, in the subsequent process, by comparing the report data corresponding to the original report system with the report data corresponding to the updated report system, the accuracy of the report content output by the updated report system is detected.

[0061] Among them, the updated reporting system mentioned here is updated based on the original reporting system. Simply put, due to changes in business needs, the corresponding filtering conditions of the original reporting system need to be updated to meet the requirements of business personnel. For example, according to business needs, the report data of quarterly sales is newly added, then the filtering condition of quarterly sales needs to be added in the original reporting system accordingly.

[0062] It should be noted that the first report data and the second report data mentioned here are mostly the same report data or theoretically should be completely the same report data. The reason why the report data are mostly the same or theoretically should be completely the same is that if the data to be queried in the updated report system and the original report system are exactly the same, then theoretically the first report data and the second report data should be completely the same data. If the screening conditions in the updated report system are slightly adjusted compared to those in the original report system, then the first report data and the second report data should be mostly the same data, but with some differences.

[0063] For example, according to business needs, the updated reporting system adds two new filtering conditions, registration rate and average recharge amount per capita, to the original filtering conditions contained in the original reporting system. Therefore, when the terminal device detects the updated reporting system based on the newly added filtering conditions, the first report data and the second report data should be mostly the same, but there are some differences (that is, the second report data adds the registration rate of the queried game and the average recharge amount per capita).

[0064] S104: taking a screenshot of the first report data to obtain a first report image, and taking a screenshot of the second report data to obtain a second report image.

[0065] In an embodiment of the present specification, after the terminal device obtains the report data corresponding to the original reporting system and the report data corresponding to the updated reporting system in the above manner, it will respectively perform screenshot operations on the report data corresponding to the original reporting system and the report data corresponding to the updated reporting system, that is, take a screenshot of the first report data to obtain a first report image, and take a screenshot of the second report data to obtain a second report image.

[0066] Among them, the first report image and the second report image are both complete reports, and the method of selecting screenshots can be comprehensively considered in combination with factors such as actual needs, operating habits and system environment. For example, according to the actual complexity of obtaining screenshots, a preset screenshot tool can be used to obtain the first report image and the second report image, or according to the system environment and actual screenshot needs, a programming language can be used to automatically obtain the first report image and the second report image.

[0067] S106: Compare the first report image with the second report image to determine a difference image area.

[0068] After obtaining the first report image and the second report image through the above method, the terminal device will compare the first report image with the second report image to determine the difference image area.

[0069] Specifically, in this specification, before the terminal device compares the first report image with the second report image, in order to improve the accuracy of the image comparison result, it is necessary to perform image preprocessing on the first report image and the second report image to improve the image quality of the first report image and the second report image.

[0070] The image preprocessing required here may include steps such as grayscale conversion, image denoising and image cropping to improve image quality.

[0071] After obtaining the preprocessed first report image and the preprocessed second report image, the terminal device will perform text recognition on the preprocessed first report image and the preprocessed second report image respectively, and after obtaining the data contained in the first report image and the data contained in the second report image, since theoretically, the original report system and the updated report system should obtain the same report based on the same screening conditions, therefore, by comparing the data corresponding to the same position in the preprocessed first report image and the preprocessed second report image, it can be determined whether there is difference data in the second report image, that is, determine the difference image area.

[0072] To elaborate, the terminal device needs to determine the coordinate position corresponding to each data contained in the first report image, and use the data corresponding to the coordinate position as the standard data, so as to determine the data corresponding to the same coordinate position in the second report image according to the coordinate position, as the data to be detected, and then compare the data to be detected with the standard data to determine the difference image area.

[0073] In addition to the above method for determining the difference image region, other methods may also be used to determine the difference image region.

[0074] Specifically, for each area included in the first report image, the terminal device determines the area size of the area in the first report image, and determines the areas matching the areas included in the first report image in the second report image, and then adjusts the area size corresponding to the areas matching the areas included in the first report image in the second report image according to the area size of each area in the first report image in the first report image, so as to obtain the adjusted second report image. Thus, according to the adjusted second report image, the size difference of each area included in the adjusted second report image in area size is determined, and the difference image area is determined according to the size difference.

[0075] Among them, different areas in the first report image contain different types of report data and the area size corresponding to each area. It can be generally understood that the report contains multiple columns of data and multiple rows of data, each column of data is an area (of course, the areas can also be divided according to rows), and the data types contained in different areas can be numerical types or text data, etc., and the area size can be understood as the size of each column in the first report image, that is, the width of each column.

[0076] For example, assuming that the first report image contains three columns of data, namely the number of recharges, the recharge amount, and the average recharge amount per capita, as three areas, and the area size is 2 cm; the second report image contains four columns of data, namely the number of recharges, the recharge amount, the average recharge amount per capita, and the number of installations, and the area sizes are 2 cm, 3 cm, 2 cm, and 3 cm respectively; and the areas that match the first report image and the second report image are the number of recharges, the recharge amount, and the average recharge amount per capita, then according to the area size of the matching area contained in the first report, the area size of the corresponding area in the second report is adjusted to 2 cm.

[0077] It should be noted that the area sizes of the areas in the first report here can be set to the same size, and the area size of each area can be determined according to the data length of each column of data. The above example is only for ease of understanding.

[0078] That is, if there is an area in the second report image that does not match the first report image, the area size of the area in the second report image may be different from the area size of the matching area in the first report image, and the area is regarded as a difference area. That is, when the area sizes of the areas included in the first report image are the same, once the area sizes of the corresponding areas in the second report image are adjusted according to the area sizes of the areas in the first report image, the area with differences will obviously have an area size different from the area that can correspond to the first report image, and thus it can be determined as a difference image area.

[0079] In addition, the terminal device will also detect the data contained in the areas in the second report image that match the areas in the first report image (that is, the data contained in the areas of the second report image whose area sizes have been adjusted). If there is difference data in a certain area in the areas whose area sizes have been adjusted, then the area can be used as the difference area. Then, among the areas included in the adjusted second report image, the area that has a difference in area size with other areas and the area of ​​the adjusted area size that has difference data are determined as the determined difference image areas.

[0080] S108: Execute a detection task according to the difference image area.

[0081] After determining the difference image areas in the reports generated by the reporting system before and after the update, the terminal device will perform a detection task based on the difference image areas, and then determine the accuracy of the report output by the reporting system after the update through the detection results.

[0082] Specifically, in this specification, the terminal device determines the difference data contained in the second report data relative to the first report data based on the difference image area, determines the associated data corresponding to the difference data in the second report data, and performs a detection task on the difference data based on the associated data.

[0083] The associated data mentioned here refers to the data contained in the report output by the original reporting system (ie, the first report data) and having a logical reasoning relationship with the difference data. In this specification, it is assumed that the data contained in the report output by the original reporting system is accurate.

[0084] Therefore, it is actually necessary to verify whether the difference data is correct based on the above-mentioned associated data. For example, the difference data is the number of active online users each hour, and the associated data can be the number of active online users each day. The number of active online users each day can be used to verify whether the number of active online users each hour is correct.

[0085] In addition, during the actual business data analysis process, business personnel will focus on analyzing part of the data in the report data in order to analyze the business operation status based on this part of the data. Therefore, the terminal device will also determine whether the difference image area contains the specified field data. If it does, the specified field data contained in the difference image area will be displayed in a preset display method (such as bold, underline, etc.), where the specified field data here refers to the field data corresponding to the specified field in the header of the report.

[0086] For example, the table headers included in the second report area include the number of installations, the number of registrations, the number of recharges, and the recharge amount, while the actual report analysis will focus on the number of recharges and the recharge amount. Therefore, the designated fields are the number of recharges and the recharge amount. In order to meet the actual business analysis requirements, the terminal device is required to re-detect the field data corresponding to the designated fields included in the difference image area to ensure that the designated field data contained in the report output by the updated report system is more accurate.

[0087] In an embodiment of the present specification, the terminal device can also determine abnormal data from the second report data and the field of the abnormal data in the second report data based on the detection results obtained after executing the detection task, and generate a prompt statement for the field, thereby inputting the prompt statement into a preset model to generate a detection code for the field through the preset model, and then running the detection code in the updated reporting system to detect the report logic of generating field values ​​corresponding to the fields in the updated reporting system.

[0088] The form of the prompt statement mentioned here may be considered in combination with actual needs. For example, the prompt statement may be in the form of "please generate report logic for updating the report system to output corresponding field values ​​of abnormal data".

[0089] It should be noted that the report logic mentioned here is mainly used to represent the logical process of the updated report system from obtaining data to outputting report data, that is, after the updated report system obtains data, how to generate accurate reports based on the screening conditions contained in the updated report system and the data types contained in the obtained data. Therefore, this detection process can be understood as detecting some logical codes in the updated report system (mainly for the updated code part).

[0090] Furthermore, the terminal device will generate a detection report on erroneous data in the second report and erroneous data in the data focused on detection based on the detection results, that is, the difference areas in the second report image, and intuitively mark them in the second report image so that technical personnel can maintain the updated reporting system in combination with the detection code and report logic output by the preset model and the detection report, so as to promptly correct problems in the updated reporting system.

[0091] Figure 2 A flowchart of a method system for detecting report data provided in an embodiment of this specification.

[0092] exist Figure 2 From the steps included, it can be seen that the entire process of detecting report data is: first, there is the stage of receiving the report acquisition instruction, that is, the terminal device will receive the report acquisition instruction, and according to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the original report system, and query the report data corresponding to the report acquisition instruction from the updated report system; the second is the stage of obtaining the image of the report output by the report system before and after the update, that is, the terminal device will obtain the image of the report output by the original report system and the updated report system.

[0093] Furthermore, the third is the image preprocessing stage, that is, the terminal device performs image preprocessing on the report image corresponding to the original report system and the report image corresponding to the updated report system to improve the image quality; the fourth is the image comparison stage, after the terminal device obtains the report image corresponding to the original report system after image preprocessing and the report image corresponding to the updated report system, it performs text recognition on the images before and after the update to compare the images, so as to detect whether there is erroneous data in the report output by the updated report system, and determine the difference image based on the erroneous data; the fifth is the difference image detection stage, after the terminal device determines the difference image, it will detect the specified field data in the difference image, and display the existing erroneous specified field data in a preset display method; the sixth is the detection report generation stage, the terminal device will generate a detection report based on the difference image detection results, so that the technical personnel can maintain the updated report system based on the detection report.

[0094] By testing the accuracy of the reports output by the updated reporting system based on the reports output by the original reporting system, it is ensured that the updated reporting system can operate normally, and the reliability of the reports output by the updated reporting system is further improved. In turn, business personnel can use the more detailed report content provided by the updated reporting system to conduct more accurate data analysis, thereby improving the testing efficiency of the reporting system.

[0095] In addition, in the embodiment of the present specification, when there is a difference in the screening conditions between the updated report system and the original report system, the first report data and the second report data can also be aligned in the type of data content. That is, when there is a difference between the report data output by the original report system and the report data output by the updated report data, the difference data between the report data output by the original report system and the report data output by the updated report data can be determined first, and then, in the report data output by the original report system, the associated data related to the difference data can be determined, and then, based on the associated data, the field value of the field corresponding to the difference data can be inferred, and then, according to the inferred data, the report data output by the original report system can be completed to obtain the first report data.

[0096] After obtaining the first report data, the various data included in the second report data can be detected by the above-mentioned image comparison method to detect whether there is a problem with the updated report system.

[0097] Therefore, through the method provided in this manual, it is possible to detect not only whether the updated reporting system can accurately output the corresponding report under the original filtering conditions, but also whether the updated reporting system can accurately output the newly added report content, thereby improving the reliability of the report data and the accuracy of the report output by the reporting system, and further improving the detection efficiency of the reporting system.

[0098] The above is a method for detecting report data provided in an embodiment of this specification. Based on the same idea, this specification also provides corresponding devices, storage media and electronic devices.

[0099] Figure 3 A schematic diagram of a structure of a device for detecting report data provided in an embodiment of this specification, the device comprising:

[0100] Receiving module 301, used to receive a report acquisition instruction;

[0101] A query module 302 is used to query the report data corresponding to the report acquisition instruction from the original report system according to the report acquisition instruction as first report data, and query the report data corresponding to the report acquisition instruction from the updated report system according to the report acquisition instruction as second report data, wherein the updated report system is updated based on the original report system;

[0102] A screenshot module 303, configured to take a screenshot of the first report data to obtain a first report image, and to take a screenshot of the second report data to obtain a second report image;

[0103] A comparison module 304 is used to compare the first report image with the second report image to determine a difference image area;

[0104] The execution module 305 is used to execute the detection task according to the difference image area.

[0105] Optionally, the comparison module 304 is specifically used to perform text recognition on the first report image to determine the coordinate position corresponding to each data contained in the first report image, and use the data corresponding to the coordinate position as standard data; based on the coordinate position, determine the data corresponding to the coordinate position in the second report image as data to be detected; and compare the data to be detected with the standard data to determine the difference image area.

[0106] Optionally, the device further comprises:

[0107] The display module 306 is used to determine whether the difference image area contains the specified field data; if it does, the specified field data contained in the difference image area is displayed according to a preset display method.

[0108] Optionally, the execution module 305 is specifically used to determine, based on the difference image area, difference data contained in the second report data relative to the first report data; determine associated data corresponding to the difference data in the second report data; and perform a detection task on the difference data based on the associated data.

[0109] Optionally, the comparison module 304 is specifically used to determine, for each area included in the first report image, the area size of the area in the first report image, where different areas in the first report image contain different types of report data; determine in the second report image respectively areas that match the areas included in the first report image, and adjust in the second report image the area sizes of the areas that match the areas included in the first report image according to the area size of each area in the first report image in the first report image, to obtain an adjusted second report image; and determine the difference image area based on the adjusted second report image.

[0110] Optionally, the comparison module 304 is further configured to determine, among the regions included in the adjusted second report image, a region having a region size difference from other regions as the determined difference image region.

[0111] Optionally, the device further comprises:

[0112] The generation module 307 is used to determine abnormal data from the second report data according to the detection results obtained after executing the detection task; determine the field of the abnormal data in the second report data; generate a prompt statement for the field; input the prompt statement into a preset model to generate a detection code for the field through the preset model; run the detection code in the updated report system to detect the report logic for generating the field value corresponding to the field in the updated report system.

[0113] This specification also provides a computer-readable storage medium, wherein the storage medium stores a computer program, and when the computer program is executed by a processor, it can be used to perform the above Figure 1 A method for detecting report data is provided.

[0114] based on Figure 1 A method for detecting report data is shown, and the embodiment of this specification also provides Figure 4 The structural diagram of the electronic device shown in FIG. Figure 4 At the hardware level, the electronic device includes a processor, an internal bus, a network interface, a memory, and a non-volatile memory, and may also include other hardware required for the business. The processor reads the corresponding computer program from the non-volatile memory into the memory and then runs it to achieve the above Figure 1 A method for detecting report data.

[0115] Of course, in addition to software implementation, this specification does not exclude other implementation methods, such as logic devices or a combination of software and hardware, etc., that is to say, the executor of the following processing flow is not limited to each logic unit, but can also be hardware or logic devices.

[0116] In the 1990s, improvements to a technology could be clearly distinguished as hardware improvements (for example, improvements to the circuit structure of diodes, transistors, switches, etc.) or software improvements (improvements to the method flow). However, with the development of technology, many improvements to the method flow today can be regarded as direct improvements to the hardware circuit structure. Designers almost always obtain the corresponding hardware circuit structure by programming the improved method flow into the hardware circuit. Therefore, it cannot be said that an improvement in a method flow cannot be implemented using a hardware entity module. For example, a programmable logic device (PLD) (such as a field programmable gate array (FPGA)) is such an integrated circuit whose logical function is determined by the user's programming of the device. Designers can "integrate" a digital system on a PLD by programming it themselves, without having to ask a chip manufacturer to design and produce a dedicated integrated circuit chip. Moreover, nowadays, instead of manually making integrated circuit chips, this kind of programming is mostly implemented by "logic compiler" software, which is similar to the software compiler used when developing and writing programs, and the original code before compilation must also be written in a specific programming language, which is called hardware description language (HDL). There is not only one HDL, but many kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), Confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), Lava, Lola, MyHDL, PALASM, RHDL (Ruby Hardware Description Language), etc. The most commonly used ones are VHDL (Very-High-Speed ​​Integrated Circuit Hardware Description Language) and Verilog. Those skilled in the art should also know that it is only necessary to program the method flow slightly in the above-mentioned hardware description languages ​​and program it into the integrated circuit, and then it is easy to obtain the hardware circuit that implements the logic method flow.

[0117] The controller can be implemented in any appropriate manner, for example, the controller can take the form of a microprocessor or processor and a computer-readable medium storing a computer-readable program code (such as software or firmware) that can be executed by the (micro)processor, a logic gate, a switch, an application-specific integrated circuit (ASIC), a programmable logic controller, and an embedded microcontroller. Examples of controllers include, but are not limited to, the following microcontrollers: ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20, and Silicone Labs C8051F320. The memory controller can also be implemented as part of the control logic of the memory. Those skilled in the art also know that in addition to implementing the controller in a purely computer-readable program code manner, the controller can be implemented in the form of a logic gate, a switch, an application-specific integrated circuit, a programmable logic controller, and an embedded microcontroller by logically programming the method steps. Therefore, this controller can be considered as a hardware component, and the devices included therein for implementing various functions can also be regarded as structures within the hardware component. Or even, the devices for implementing various functions can be regarded as both software modules for implementing the method and structures within the hardware component.

[0118] The systems, devices, modules or units described in the above embodiments may be implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer. Specifically, the computer may be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

[0119] For the convenience of description, the above device is described in various units according to their functions. Of course, when implementing this specification, the functions of each unit can be implemented in the same or multiple software and / or hardware.

[0120] Those skilled in the art will appreciate that the embodiments of this specification may be provided as methods, systems, or computer program products. Therefore, this specification may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, this specification may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0121] This specification is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of this specification. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0122] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0123] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0124] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0125] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0126] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0127] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0128] Those skilled in the art will appreciate that the embodiments of this specification may be provided as methods, systems or computer program products. Therefore, this specification may take the form of a complete hardware embodiment, a complete software embodiment or an embodiment combining software and hardware. Moreover, this specification may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0129] This specification may be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. This specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules may be located in local and remote computer storage media, including storage devices.

[0130] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0131] The above description is only an embodiment of the present specification and is not intended to limit the present specification. For those skilled in the art, the present specification may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present specification shall be included in the scope of the claims of the present specification.

Claims

1. A method for detecting report data, characterized in that: include: Receive report acquisition instructions; According to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the original report system as the first report data; and according to the report acquisition instruction, query the report data corresponding to the report acquisition instruction from the updated report system as the second report data, wherein the updated report system is updated based on the original report system; Taking a screenshot of the first report data to obtain a first report image, and taking a screenshot of the second report data to obtain a second report image; Comparing the first report image with the second report image to determine a difference image area; A detection task is performed according to the difference image area.

2. The method according to claim 1, characterized in that The step of comparing the first report image with the second report image to determine the difference image area specifically includes: Performing text recognition on the first report image to determine the coordinate position corresponding to each data contained in the first report image, and using the data corresponding to the coordinate position as standard data; According to the coordinate position, determine the data corresponding to the coordinate position in the second report image as the data to be detected; The data to be detected is compared with the standard data to determine the difference image area.

3. The method according to claim 1, characterized in that The method further comprises: Determining whether the difference image area contains specified field data; If included, the designated field data contained in the difference image area is displayed according to a preset display method.

4. The method according to claim 1, characterized in that The step of performing the detection task according to the difference image area specifically includes: determining, according to the difference image area, difference data included in the second report data relative to the first report data; Determining associated data corresponding to the difference data in the second report data; According to the associated data, a detection task is performed on the difference data.

5. The method according to claim 1, characterized in that The step of comparing the first report image with the second report image to determine the difference image area specifically includes: For each area included in the first report image, determine the area size of the area in the first report image, where different areas in the first report image contain different types of report data; Determining in the second report image the regions that match the regions included in the first report image respectively, and adjusting in the second report image the region sizes of the regions that match the regions included in the first report image according to the region sizes of each region in the first report image in the first report image, to obtain an adjusted second report image; A difference image area is determined according to the adjusted second report image.

6. The method according to claim 5, characterized in that The step of determining the difference image area according to the adjusted second report image specifically includes: Among the regions included in the adjusted second report image, a region having a region size different from other regions is determined as a determined difference image region.

7. The method according to claim 1, characterized in that The method further comprises: Determining abnormal data from the second report data according to the detection result obtained after executing the detection task; Determine the field of the abnormal data in the second report data; Generate a prompt statement for the field; Inputting the prompt statement into a preset model to generate a detection code for the field through the preset model; The detection code is run in the updated reporting system to detect the reporting logic for generating the field value corresponding to the field in the updated reporting system.

8. A device for detecting report data, characterized in that: include: A receiving module, used for receiving a report acquisition instruction; a query module, configured to query, according to the report acquisition instruction, from an original report system the report data corresponding to the report acquisition instruction as first report data, and query, according to the report acquisition instruction, from an updated report system the report data corresponding to the report acquisition instruction as second report data, wherein the updated report system is updated based on the original report system; A screenshot module, used to take a screenshot of the first report data to obtain a first report image, and to take a screenshot of the second report data to obtain a second report image; A comparison module, used for comparing the first report image with the second report image to determine a difference image area; An execution module is used to execute a detection task according to the difference image area.

9. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

10. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the method described in any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • Report data verification method, system and device

    CN108614742A

  • Data table association update verification method and device,, electronic equipment and storage medium

    CN110347672A

  • Test data comparison method and device

    CN111782514A

  • Report loading and updating detection method and device, equipment and storage medium

    CN114185624A

  • Application error analysis from screenshot

    US20210256681A1