CN114580381A - Report automatic checking method and system, control device and storage medium - Google Patents
Report automatic checking method and system, control device and storage medium Download PDFInfo
- Publication number
- CN114580381A CN114580381A CN202210173790.8A CN202210173790A CN114580381A CN 114580381 A CN114580381 A CN 114580381A CN 202210173790 A CN202210173790 A CN 202210173790A CN 114580381 A CN114580381 A CN 114580381A
- Authority
- CN
- China
- Prior art keywords
- report
- verification
- index data
- checking
- index
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
- G06F40/226—Validation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report automatic checking method and system, a control device and a storage medium, wherein the report automatic checking method comprises the following steps: acquiring verification definition information, wherein the verification definition information comprises a report verification type and verification analysis logic; acquiring at least two index data to be checked from a report according to the report checking type; the acquired index data are processed according to the check analysis logic to obtain a check result, the design check efficiency is high, and the accuracy of the index data can be improved.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a method and a system for automatically checking a report, a control device and a storage medium.
Background
In the conventional report statistics, a worker needs to fill related data in each index of each report, however, because there are many items to be counted, careless mistakes are likely to occur, and after an administrator collects each report, the index data in each report needs to be checked one by one, however, different index data have different associations, and the administrator sometimes needs to associate a plurality of index data to know the correctness of the index data, so that the administrator needs to consume a lot of time during checking, and meanwhile, a checking error condition also exists.
Disclosure of Invention
The present invention is directed to solving at least one of the problems of the prior art. Therefore, the invention provides a report automatic checking method and system, a control device and a storage medium, which can automatically check index data in a report and improve the checking efficiency and the data accuracy.
According to the embodiment of the first aspect of the invention, the report automatic checking method comprises the following steps: acquiring verification definition information, wherein the verification definition information comprises a report verification type and verification analysis logic; acquiring at least two index data to be checked from a report according to the report checking type; and processing the acquired index data according to the verification analysis logic to obtain a verification result.
The automatic report form checking method provided by the embodiment of the invention at least has the following beneficial effects:
according to the automatic report checking method, a user can formulate checking definition information according to actual conditions, software obtains at least two index data needing checking from the report according to the report checking type in the checking definition information formulated by the user, and then the obtained index data are automatically processed according to checking analysis logic in the checking definition information formulated by the user to obtain a checking result.
According to some embodiments of the invention, the report check type comprises: the report checking method comprises the steps of checking types in a table, obtaining first selection information when the report checking type is the checking type in the table, selecting any one report according to the first selection information, and obtaining at least two pieces of index data to be checked in the selected report according to the first selection information; and the report checking type is the inter-report checking type, wherein when the report checking type is the inter-report checking type, second selection information is obtained, at least two reports are selected according to the second selection information, and at least one index data to be checked is obtained in each selected report according to the second selection information.
According to some embodiments of the present invention, in the case that at least one to-be-verified index data is obtained in each selected report according to the second selection information, the index types of the index data obtained in different reports are the same or different.
According to some embodiments of the present invention, the check analysis logic includes at least two index items and at least one operator, the index items point to the index data to be checked in a one-to-one correspondence, and a check result is obtained according to a relationship processing of the index items and the operator.
According to some embodiments of the present invention, the check analysis logic further comprises a comparator and a comparison item, and the check result is obtained according to the relation processing of the indicator item, the operator, the comparator and the comparison item.
According to some embodiments of the present invention, after the obtaining of the verification definition information, the index item is converted into an sql command to obtain the corresponding index data from the database.
According to some embodiments of the invention, after said obtaining the verification definition information, saving the verification analysis logic; and selecting the stored verification analysis logic according to the input information when the verification definition information is acquired next time.
According to a second aspect of the invention, a verification system comprises: the system comprises an input module, a verification module and a verification module, wherein the input module is used for acquiring verification definition information, and the verification definition information comprises a report verification type and verification analysis logic; the calling module is connected with the input module and used for acquiring at least two index data to be verified from a report according to the report verification type; and the processing output module is connected with the calling module and is used for processing the acquired index data according to the verification analysis logic to obtain a verification result.
The verification system provided by the embodiment of the invention at least has the following beneficial effects:
according to the verification system, a user inputs the verification definition information into the input module, the calling module calls corresponding index data from the report according to the report verification type, and the processing output module automatically processes the obtained index data according to the verification analysis logic in the verification definition information set by the user to obtain the verification result.
A control apparatus according to an embodiment of a third aspect of the present invention includes: one or more memories; one or more processors configured to execute one or more computer programs stored in the one or more memories, and further configured to execute a report automatic verification method disclosed in any of the above embodiments.
The computer-readable storage medium according to the fourth aspect of the present invention includes instructions, which when run on a computer, cause the computer to execute an automatic report verification method disclosed in any of the above embodiments.
Additional aspects and advantages of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
The above and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
FIG. 1 is a flowchart of an embodiment of a report automatic verification method according to the present invention;
FIG. 2 is a block diagram of a schematic configuration of one embodiment of a verification system of the present invention;
fig. 3 is a schematic block diagram of a control device according to an embodiment of the present invention.
Reference numerals:
the device comprises an input module 100, a calling module 200, a processing output module 300, a memory 400 and a processor 500.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
In the description of the present invention, it is to be understood that the positional or orientational descriptions referred to, for example, the terms "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc., are based on the positional or orientational relationships shown in the drawings and are for convenience of description and simplicity of description only, and do not indicate or imply that the referenced device or element must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention.
In the description of the present invention, a plurality of means is one or more, a plurality of means is two or more, and greater than, less than, more than, etc. are understood as excluding the essential numbers, and greater than, less than, etc. are understood as including the essential numbers. If the first and second are described for the purpose of distinguishing technical features, they are not to be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated or implicitly indicating the precedence of the technical features indicated.
In the description of the present invention, it should be noted that unless otherwise explicitly stated or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
As shown in fig. 1, an automatic report verification method according to an embodiment of the first aspect of the present invention includes:
s100, acquiring verification definition information, wherein the verification definition information comprises a report verification type and verification analysis logic;
s200, acquiring at least two index data to be checked from the report according to the report checking type;
and S300, processing the acquired index data according to a verification analysis logic to obtain a verification result.
It should be noted that each report may have a plurality of index data, for example, a report for a certain area of land has records of data of an occupied area, a building area, a greening area, and the like for each household, where the occupied area, the building area, and the greening area are indexes, and a numerical value recorded by each household for the index is index data, and a user may set a verification analysis logic to analyze and process different index data to determine the correctness of the numerical value.
It can be understood that each collected report can be stored in the database, and the user can input the report to be acquired and the position of the index in the report to be acquired in the verification definition information, and then verify the acquired index data.
The check definition information input by the user may be one or multiple pieces, and different check definition information may be used for checking different index data.
According to the automatic report checking method, a user can formulate checking definition information according to actual conditions, software obtains at least two index data needing checking from the report according to the report checking type in the checking definition information formulated by the user, and then the obtained index data are automatically processed according to checking analysis logic in the checking definition information formulated by the user to obtain a checking result.
In some embodiments of the present invention, the report verification type includes: the report checking method comprises the steps of checking types in a table, obtaining first selection information when the report checking type is the checking type in the table, selecting any one report according to the first selection information, and obtaining at least two pieces of index data to be checked in the selected report according to the first selection information; and the report verification type is the inter-report verification type, second selection information is obtained when the report verification type is the inter-report verification type, at least two reports are selected according to the second selection information, and at least one index data to be verified is obtained in each selected report according to the second selection information.
It should be noted that the plurality of index data may be obtained from one table, or may be obtained from a plurality of tables, respectively, where a user may set a report verification type as an in-table verification type through the first selection information, specifically, may input a report address to select any one report when setting the report verification type, and input a plurality of index addresses to select at least two indexes in the report, and in the verification process, obtain the index data in the selected index to perform verification.
The user may also set the report verification type as the inter-standard verification type through the second selection information, specifically, a plurality of reports may be selected by inputting a plurality of report addresses when the report verification type is set, and at least one index address is input for each report, it should be noted that, here, each report may have a plurality of index addresses, a plurality of index data is obtained, and then, in the verification process, the index data in the selected index is obtained for verification.
Before the verification definition information is acquired, a window for inputting corresponding selection information, report addresses and index addresses can be popped up on the interface.
In some embodiments of the present invention, in the step of obtaining at least one to-be-verified index data in each selected report according to the second selection information, the index types of the index data obtained in different reports are the same or different.
When a plurality of index data are acquired in the same report according to the first selection information, the types of indexes corresponding to the index data are generally different.
When the index data is respectively obtained in each selected report according to the second selection information, the index data of the same index type can be obtained for analysis, and the index data of different index types can also be obtained for analysis.
Specifically, for example, two reports for two areas of land have records of data such as occupied area, building area, greening area, etc. for each household, and the index data of the occupied area index in one report and the index data of the greening area index in the other report may be selected for logical analysis.
Or, in the report of the land of one area, there are records of data such as building area of each household, and the report of the building cost of the other land, where there are records of data such as building cost of each household, and index data of the building area in one report and index data of the building cost in the other report can be respectively obtained to perform logic analysis.
In some embodiments of the present invention, the report may be a report newly added by the user, or may be a historical report stored in a historical database.
In some embodiments of the present invention, the check analysis logic includes at least two index items and at least one operator, the index items point to the index data to be checked in a one-to-one correspondence, and a check result is obtained according to a relationship processing of the index items and the operator.
The indicator item may be a placeholder pointing to each indicator data according to an indicator address, so as to obtain the indicator data of each indicator, the operator may include one or more of an arithmetic operator and a logical operator, such as "+", "-", "and", "or", and the like, and a user may select a corresponding operator to match according to actual conditions, so as to form a checking and analyzing logic. And obtaining a checking result through the operation of a plurality of index data.
In some embodiments of the present invention, the check analysis logic further includes a comparator and a comparison item, and the check result is obtained according to the relationship processing of the indicator item, the operator, the comparator and the comparison item.
The comparator may be ">", "<", "═ or" or the like, the comparison item may be a threshold value for determination input by a user, through comparison, it may be determined whether the index data is qualified, after the index data is determined by the check analysis logic, if the index data is qualified, and if the index data is not qualified, the counter may add "1", accumulate the number of unqualified index data, and mark the unqualified index data.
After the verification result is obtained, an alarm can be given according to the accumulated number of the unqualified index data, for example, if the number of the unqualified index data is greater than or equal to 1, an alarm is given to remind a user that an error exists in the index data.
In some embodiments of the present invention, after the verification definition information is obtained, the index item is converted into an sql command to obtain the corresponding index data from the database.
It should be noted that the index item is used for pointing to each index through the address of the report and the address of the index to obtain index data, the report is stored in the database, the database structurally classifies each index data according to sql, the index item is converted into an sql command, the index data is queried in the database by using the sql command, and the database has good stability, query flexibility and accuracy.
In some embodiments of the invention, after obtaining the verification definition information, the verification analysis logic is saved; and selecting the stored verification analysis logic according to the input information when the verification definition information is acquired next time.
The system can store the verification analysis logic and the report verification type in the verification definition information input by the user every time, the user can select to input the verification analysis logic and the report verification type again when the verification definition information is obtained next time, the user can also select the stored verification analysis logic and the stored report verification type from the database, and the system is convenient and fast to use.
The verification system according to the embodiment of the second aspect of the present invention, as shown in fig. 2, includes: the input module 100 is configured to acquire verification definition information, where the verification definition information includes a report verification type and a verification analysis logic; the calling module 200 is connected with the input module 100, and the calling module 200 is used for acquiring at least two index data to be checked from the report according to the report checking type; and the processing output module 300 is connected with the invoking module 200, and the processing output module 300 is configured to process the acquired index data according to the verification analysis logic to obtain a verification result.
The input module 100 may be constituted by a keyboard, a mouse, a display, and the like, or the input module 100 may be constituted by a touch display.
The processing output module 300 may be composed of a processing chip such as a CPU and an accessory circuit, may acquire and process related data, and may present an operation interface and output a verification result through an external device such as a display screen.
The invoking module 200 may be a serial port and an invoking protocol program respectively connected to the processing output module 300, the input module 100, and the database, and may obtain relevant data from the database according to the instruction of the input module 100 and provide the relevant data to the processing output module 300.
According to the verification system, a user inputs verification definition information into the input module 100, the calling module 200 calls corresponding index data from the report according to the report verification type, and the processing and output module 300 automatically processes the obtained index data according to the verification analysis logic in the verification definition information set by the user to obtain a verification result.
A control apparatus according to an embodiment of the third aspect of the present invention, as shown in fig. 3, includes: one or more memories 400; one or more processors 500 for executing one or more computer programs stored in the one or more memories 400 and for executing a report automatic verification method disclosed in any of the above embodiments.
It should be noted that, for the specific implementation process of the present embodiment, reference may be made to the specific implementation process of the above method embodiment, and a description thereof is omitted here.
The computer-readable storage medium according to the fourth aspect of the present invention includes instructions, which when run on a computer, cause the computer to execute an automatic report verification method disclosed in any of the above embodiments.
It should be noted that, for the specific implementation process of the present embodiment, reference may be made to the specific implementation process of the above method embodiment, and a description thereof is omitted here.
The embodiments of the present application also disclose a computer program product, wherein, when the computer program product runs on a computer, the computer is caused to execute part or all of the steps of the method as in the above method embodiments.
Those skilled in the art will appreciate that all or part of the steps in the various methods of the above embodiments may be implemented by a program instructing associated hardware, the program may be stored in a computer-readable storage medium, which includes read-only memory (ROM), Random Access Memory (RAM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), one-time programmable read-only memory (PROM), an electronic erasable programmable read-only memory (EEPROM), a compact disc read-only memory (CD-ROM) or other optical disk storage, magnetic disk storage, tape storage, or any other medium readable by a computer that can be used to carry or store data.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
While embodiments of the present invention have been shown and described, it will be understood by those of ordinary skill in the art that: various changes, modifications, substitutions and alterations can be made to the embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.
Claims (10)
1. An automatic report verification method is characterized by comprising the following steps:
acquiring verification definition information, wherein the verification definition information comprises a report verification type and verification analysis logic;
acquiring at least two index data to be checked from a report according to the report checking type;
and processing the acquired index data according to the verification analysis logic to obtain a verification result.
2. The report automatic verification method according to claim 1, wherein the report verification type comprises:
the report checking method comprises the steps of checking types in a table, obtaining first selection information when the report checking type is the checking type in the table, selecting any one report according to the first selection information, and obtaining at least two pieces of index data to be checked in the selected report according to the first selection information;
and the report checking type is the inter-report checking type, wherein when the report checking type is the inter-report checking type, second selection information is obtained, at least two reports are selected according to the second selection information, and at least one index data to be checked is obtained in each selected report according to the second selection information.
3. The automatic report form verification method according to claim 2, characterized in that: in the step of acquiring at least one index data to be verified in each selected report according to the second selection information, the index types of the index data acquired in different reports are the same or different.
4. The automatic report form verification method according to claim 1, characterized in that: the check analysis logic comprises at least two index items and at least one operator, the index items point to the index data to be checked in a one-to-one correspondence mode, and a check result is obtained according to the relation processing of the index items and the operator.
5. The automatic report form verification method according to claim 4, characterized in that: the checking analysis logic also comprises a comparator and a comparison item, and a checking result is obtained according to the relation processing of the index item, the operator, the comparator and the comparison item.
6. The automatic report form verification method according to claim 4, characterized in that: and after the verification definition information is obtained, converting the index item into an sql command so as to obtain corresponding index data from the database.
7. The automatic report form verification method according to claim 1, wherein the automatic report form verification method comprises the following steps: after the verification definition information is obtained, storing verification analysis logic;
and selecting the stored verification analysis logic according to the input information when the verification definition information is acquired next time.
8. A verification system, comprising:
the input module is used for acquiring verification definition information, wherein the verification definition information comprises a report verification type and verification analysis logic;
the calling module is connected with the input module and used for acquiring at least two index data to be verified from a report according to the report verification type;
and the processing output module is connected with the calling module and is used for processing the acquired index data according to the verification analysis logic to obtain a verification result.
9. A control device, comprising:
one or more memories;
one or more processors for executing one or more computer programs stored in the one or more memories, and for performing an automatic report verification method according to any of claims 1 to 7.
10. A computer-readable storage medium comprising instructions which, when executed on a computer, cause the computer to perform a report autoverification method as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210173790.8A CN114580381A (en) | 2022-02-24 | 2022-02-24 | Report automatic checking method and system, control device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210173790.8A CN114580381A (en) | 2022-02-24 | 2022-02-24 | Report automatic checking method and system, control device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114580381A true CN114580381A (en) | 2022-06-03 |
Family
ID=81773427
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210173790.8A Pending CN114580381A (en) | 2022-02-24 | 2022-02-24 | Report automatic checking method and system, control device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114580381A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115620851A (en) * | 2022-12-19 | 2023-01-17 | 一临云(深圳)科技有限公司 | Data verification method and device, electronic equipment and readable storage medium |
-
2022
- 2022-02-24 CN CN202210173790.8A patent/CN114580381A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115620851A (en) * | 2022-12-19 | 2023-01-17 | 一临云(深圳)科技有限公司 | Data verification method and device, electronic equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5899986A (en) | Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer | |
| US8201135B2 (en) | Printed circuit board layout system and method thereof | |
| US20200257675A1 (en) | Method, apparatus, and system for evaluating a partition in a database | |
| CN111160855B (en) | Report automatic auditing method, device, equipment and storage medium | |
| CN114580381A (en) | Report automatic checking method and system, control device and storage medium | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN109670091A (en) | A kind of metadata intelligent maintenance method and apparatus based on data standard | |
| CN111061802B (en) | Power data management processing method, device and storage medium | |
| US20120173498A1 (en) | Verifying Correctness of a Database System | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| US20070011176A1 (en) | Business reporting under system failures | |
| CN111324781A (en) | Data analysis method, device and equipment | |
| CN110795493A (en) | Multi-level index data display method, device, equipment and storage medium | |
| CN111737295B (en) | Database cursor query method, device, equipment and storage medium | |
| CN106021046A (en) | Hard disk performance comparison method, device and server | |
| CN111881140A (en) | Data structure tree checking method, device, equipment and storage medium | |
| CN110502513A (en) | Collecting method, device, equipment and computer readable storage medium | |
| CN111124791A (en) | System testing method and device | |
| CN110874365A (en) | Information query method and related equipment thereof | |
| CN115878643A (en) | Method, device and application for automatically checking multiple databases based on button | |
| CN115617623A (en) | Performance index data visualization method and device, electronic equipment and storage medium | |
| CN115248782A (en) | Automatic testing method and device and computer equipment | |
| CN112700328B (en) | Automatic index analysis method, device, equipment and storage medium | |
| CN111641532B (en) | Communication quality detection method, device, server and storage medium | |
| CN114116729B (en) | Test data processing method and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |