A data verification method and system

Abstract

The present invention relates to the field of data verification technology, and relates to a data verification method and system. The method comprises obtaining entity attribute information; establishing a first data verification template according to the entity attribute information; designing the first data verification template in the form of two-dimensional table coordinates to obtain a second data verification template; presetting a verification formula for the second data verification template to obtain a third data verification template; and verifying data filled in the third data verification template according to the third data verification template. The present invention can perform real-time verification of filled-in data with higher flexibility and more applicable scenarios.

Description

Technical Field

[0001] The present invention relates to the technical field of data verification, and in particular to a data verification method and system. Background Art

[0002] Data verification is an important part of business management, especially in budget formulation, fund use and other fund management scenarios. It is necessary to determine whether the fund compilation is reasonable and whether the fund account allocation complies with relevant methods and constraints. Existing data verification mainly relies on manual verification and system built-in verification rules. The above two methods have the problems of low verification efficiency and poor flexibility. Summary of the invention

[0003] The object of the present invention is to provide a data verification method and system to improve the above-mentioned problem.

[0004] In order to achieve the above objectives, the present application provides the following technical solutions:

[0005] On the one hand, an embodiment of the present application provides a data verification method, the method comprising:

[0006] Get entity attribute information;

[0007] Establishing a first data verification template according to the entity attribute information;

[0008] The first data verification template is designed using a two-dimensional table coordinate form to obtain a second data verification template;

[0009] Presetting a verification formula for the second data verification template to obtain a third data verification template;

[0010] The data filled in the third data verification template is verified according to the third data verification template.

[0011] In a second aspect, an embodiment of the present application provides a data verification system, the system comprising:

[0012] Acquisition module, used to obtain entity attribute information;

[0013] A first processing module, used to establish a first data verification template according to the entity attribute information;

[0014] A second processing module is used to design the first data verification template using a two-dimensional table coordinate form to obtain a second data verification template;

[0015] A third processing module, configured to preset a verification formula for the second data verification template to obtain a third data verification template;

[0016] A verification module is used to verify the data filled in the third data verification template according to the third data verification template.

[0017] In a third aspect, an embodiment of the present application provides a data verification device, the device comprising a memory and a processor. The memory is used to store a computer program; the processor is used to implement the steps of the above data verification method when executing the computer program.

[0018] In a fourth aspect, an embodiment of the present application provides a readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the above-mentioned data verification method are implemented.

[0019] The beneficial effects of the present invention are:

[0020] The present invention establishes a first data verification template through entity attribute information, and can generate verification templates corresponding to multiple different entity attributes, thereby improving the applicable scenarios of data verification and enhancing flexibility. The first data template is then designed in the form of two-dimensional table coordinates to obtain a second data verification template, so that the verification data can accurately match the corresponding preset verification formula, thereby improving the accuracy of data verification. In addition, the present invention can customize complex verification formulas, and the verification logic is more complex to be suitable for different scenarios.

[0021] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or be understood by implementing the embodiments of the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the written description, claims, and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0023] Figure 1 The figure is a flow chart of the data verification method described in the embodiment of the present invention.

[0024] Figure 2 Schematic diagram of the structure of the data verification system described in the embodiment of the present invention.

[0025] Figure 3 Schematic diagram of the structure of the data verification device described in an embodiment of the present invention.

[0026] Labels in the figure: 901, acquisition module; 902, first processing module; 903, second processing module; 904, third processing module; 905, verification module; 9021, first acquisition unit; 9022, first processing unit; 9023, second processing unit; 9024, third processing unit; 9031, second acquisition unit; 9032, fourth processing unit; 9033, fifth processing unit; 9041, third acquisition unit; 9042, association unit; 9043, sixth processing unit; 9051, fourth acquisition unit; 9052, seventh processing unit; 9053, eighth processing unit; 90531, ninth processing unit; 90532, calculation unit; 90533, tenth processing unit; 800, data verification device; 801, processor; 802, memory; 803, multimedia component; 804, I / O interface; 805, communication component. DETAILED DESCRIPTION

[0027] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. The components of the embodiments of the present invention generally described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the present invention. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present invention.

[0028] It should be noted that similar reference numerals and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in the subsequent drawings. At the same time, in the description of the present invention, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance. Embodiment 1:

[0029] This embodiment provides a data verification method. It can be understood that a scenario can be laid out in this embodiment, for example: a scenario for verifying data related to a scientific research topic.

[0030] See also Figure 1 , the figure shows that the method includes step S1, step S2, step S3, step S4 and step S5.

[0031] Step S1, obtaining entity attribute information;

[0032] In this step, the entity attribute information includes but is not limited to the issuing unit, plan type and subject type.

[0033] Step S2: establishing a first data verification template according to the entity attribute information;

[0034] In this step, the template unique identifier is defined through a random number strategy and is bound to entity attributes related to the template.

[0035] The step S2 also includes step S21, step S22, step S23 and step S24, which specifically include:

[0036] Step S21, obtaining the data to be verified;

[0037] Step S22, determining the scientific research project category corresponding to the data verification template to be generated according to the data to be verified;

[0038] Step S23, determining entity attribute information according to the scientific research project category corresponding to the data verification template to be generated;

[0039] Step S24: Fill the entity attribute information into a preset data verification template to obtain a first data verification template.

[0040] In this embodiment, the entity attribute information that needs to be filled in the template is determined based on different scientific research project categories, and filled into the preset data verification template, so that different scientific research project categories correspond to different data verification templates. This not only realizes the rapid generation of data verification templates, but also improves the flexibility of data verification templates, and generates data verification templates that match different categories of scientific research projects.

[0041] Step S3, designing the first data verification template using a two-dimensional table coordinate form to obtain a second data verification template;

[0042] The step S3 also includes step S31, step S32 and step S33, which specifically include:

[0043] Step S31, obtaining the horizontal coordinate information and the vertical coordinate information of the first data verification template;

[0044] Step S32, determining field information according to the abscissa information and the ordinate information, wherein the field information includes field information of a first data verification template header;

[0045] Step S33: Generate a coordinate unique identifier for the field information of each header of the first data verification template using a random number strategy.

[0046] In this embodiment, the field information in the first data verification template is positioned in the form of two-dimensional table coordinates, which effectively ensures the accurate matching of the verification formula and the verification data during the data verification process.

[0047] Step S4, presetting a verification formula for the second data verification template to obtain a third data verification template;

[0048] The step S4 also includes step S41, step S42 and step S43, which specifically include:

[0049] Step S41, obtaining a first formula set, wherein the first formula set includes verification formulas required for all cells;

[0050] Step S42, associating the verification formula required for each cell with the corresponding cell;

[0051] Step S43: Generate a corresponding unique formula identifier for each verification formula through a random number strategy to obtain a third data verification template.

[0052] In this step, you can choose to edit the cell to customize the verification formula. A specific implementation method is to verify the funds of the scientific research project. The user edits the cell and defines the verification formula as: Total expenditure budget - Total = Total expenditure budget - Party A's appropriation + Total expenditure budget - Self-raised funds + Total expenditure budget - Other appropriations, and stores it in json format.

[0053] Step S5: verify the data filled in the third data verification template according to the third data verification template.

[0054] The step S5 also includes step S51, step S52 and step S53, which specifically include:

[0055] Step S51, obtaining the location information corresponding to the cell where the user fills in the data;

[0056] Step S52, determining a unique coordinate identifier corresponding to the cell according to the position information corresponding to the cell in which the user fills in the data;

[0057] Step S53: verify the data filled in the cell by the user according to the unique coordinate identifier.

[0058] The step S53 also includes step S531, step S532 and step S533, which specifically include:

[0059] Step S531, traverse the first formula set using a linear search algorithm to search for relevant formulas that use the data filled in the cell corresponding to the unique coordinate identifier as a result item to obtain a second formula set;

[0060] In this step, the first formula set is defined as C=[C1,C2,…,Cn], where C1 to Cn represent all the verification formulas in the third data verification template. The relevant formulas with the currently filled in data as the result item are searched in the first formula set, and the second formula set is located as D=[D1,D2,…,Dn].

[0061] Step S532, performing calculation according to the formula in the second formula set to obtain a calculation result;

[0062] In this step, the second formula set is traversed, and the formula text stored in the second formula set is replaced with the corresponding cell value using the operator as an identifier to calculate the check value.

[0063] Step S533: Compare the calculation result with the data filled in the cell by the user to obtain a verification result.

[0064] In this step, compare whether the check value is equal to the data filled in the cell. If they are equal, continue to traverse the formulas in the second formula set until the calculation results corresponding to each formula are checked. If they are not the same, a check error is prompted and the formulas in the second formula set that fail the check are listed. Embodiment 2:

[0065] like Figure 2 As shown, this embodiment provides a data verification system, which includes an acquisition module 901, a first processing module 902, a second processing module 903, a third processing module 904 and a verification module 905, which specifically includes:

[0066] Acquisition module 901, used to acquire entity attribute information;

[0067] A first processing module 902, configured to establish a first data verification template according to the entity attribute information;

[0068] The second processing module 903 is used to design the first data verification template using a two-dimensional table coordinate form to obtain a second data verification template;

[0069] A third processing module 904 is used to preset a verification formula for the second data verification template to obtain a third data verification template;

[0070] The verification module 905 is used to verify the data filled in the third data verification template according to the third data verification template.

[0071] In a specific implementation of the present disclosure, the first processing module 902 further includes a first acquisition unit 9021, a first processing unit 9022, a second processing unit 9023 and a third processing unit 9024, which specifically include:

[0072] A first acquisition unit 9021 is used to acquire data to be verified;

[0073] The first processing unit 9022 is used to determine the scientific research project category corresponding to the data verification template to be generated according to the data to be verified;

[0074] The second processing unit 9023 is used to determine entity attribute information according to the scientific research project category corresponding to the data verification template to be generated;

[0075] The third processing unit 9024 is used to fill the entity attribute information into a preset data verification template to obtain a first data verification template.

[0076] In a specific implementation of the present disclosure, the second processing module 903 further includes a second acquisition unit 9031, a fourth processing unit 9032 and a fifth processing unit 9033, which specifically include:

[0077] The second acquisition unit 9031 is used to acquire the horizontal coordinate information and the vertical coordinate information of the first data verification template;

[0078] The fourth processing unit 9032 is used to determine field information according to the horizontal coordinate information and the vertical coordinate information, where the field information includes field information of the first data verification template header;

[0079] The fifth processing unit 9033 is used to generate a coordinate unique identifier for the field information of each header of the first data verification template by using a random number strategy.

[0080] In a specific implementation of the present disclosure, the third processing module 904 further includes a third acquisition unit 9041, an association unit 9042 and a sixth processing unit 9043, which specifically include:

[0081] A third acquisition unit 9041 is used to acquire a first formula set, where the first formula set includes verification formulas required for all cells;

[0082] An associating unit 9042, used to associate the verification formula required for each cell with the corresponding cell;

[0083] The sixth processing unit 9043 is used to generate a corresponding formula unique identifier for each verification formula through a random number strategy to obtain a third data verification template.

[0084] In a specific implementation of the present disclosure, the verification module 905 further includes a fourth acquisition unit 9051, a seventh processing unit 9052 and an eighth processing unit 9053, which specifically include:

[0085] The fourth acquisition unit 9051 is used to acquire the position information corresponding to the cell where the user fills in the data;

[0086] The seventh processing unit 9052 is used to determine the coordinate unique identifier corresponding to the cell according to the position information corresponding to the cell filled in by the user;

[0087] The eighth processing unit 9053 is used to verify the data filled in the cell by the user according to the unique coordinate identifier.

[0088] In a specific implementation of the present disclosure, the eighth processing unit 9053 further includes a ninth processing unit 90531, a calculation unit 90532 and a tenth processing unit 90533, which specifically include:

[0089] A ninth processing unit 90531 is used to traverse the first formula set by using a linear search algorithm to search for a related formula that uses the data filled in the cell corresponding to the unique coordinate identifier as a result item, to obtain a second formula set;

[0090] A calculation unit 90532, configured to perform calculation according to the formula in the second formula set to obtain a calculation result;

[0091] The tenth processing unit 90533 is used to compare the calculation result with the data filled in the cell by the user to obtain a verification result.

[0092] It should be noted that, regarding the system in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here. Embodiment 3:

[0093] Corresponding to the above method embodiment, a data verification device is also provided in this embodiment. The data verification device described below and the data verification method described above can refer to each other.

[0094] Figure 3 FIG. 8 is a block diagram of a data checking device 800 according to an exemplary embodiment. Figure 3 As shown, the data verification device 800 may include: a processor 801 and a memory 802. The data verification device 800 may also include one or more of a multimedia component 803, an I / O interface 804, and a communication component 805.

[0095] The processor 801 is used to control the overall operation of the data verification device 800 to complete all or part of the steps in the above-mentioned data verification method. The memory 802 is used to store various types of data to support the operation of the data verification device 800. These data may include, for example, instructions for any application or method used to operate on the data verification device 800, and application-related data, such as contact data, sent and received messages, pictures, audio, video, etc. The memory 802 can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (Static Random Access Memory, referred to as SRAM), electrically erasable programmable read-only memory (Electrically Erasable Programmable Read-Only Memory, referred to as EEPROM), erasable programmable read-only memory (Erasable Programmable Read-Only Memory, referred to as EPROM), programmable read-only memory (Programmable Read-Only Memory, referred to as PROM), read-only memory (Read-Only Memory, referred to as ROM), magnetic memory, flash memory, magnetic disk or optical disk. The multimedia component 803 may include a screen and an audio component. The screen may be, for example, a touch screen, and the audio component is used to output and / or input audio signals. For example, the audio component may include a microphone, which is used to receive external audio signals. The received audio signal may be further stored in the memory 802 or sent through the communication component 805. The audio component also includes at least one speaker for outputting audio signals. The I / O interface 804 provides an interface between the processor 801 and other interface modules, and the above-mentioned other interface modules may be keyboards, mice, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 805 is used for wired or wireless communication between the data verification device 800 and other devices. Wireless communication, such as Wi-Fi, Bluetooth, Near Field Communication (NFC), 2G, 3G or 4G, or a combination of one or more of them, so the corresponding communication component 805 may include: Wi-Fi module, Bluetooth module, NFC module.

[0096] In an exemplary embodiment, the data verification device 800 can be implemented by one or more application specific integrated circuits (ASIC), digital signal processors (DSP), digital signal processing devices (DSPD), programmable logic devices (PLD), field programmable gate arrays (FPGA), controllers, microcontrollers, microprocessors or other electronic components to execute the above-mentioned data verification method.

[0097] In another exemplary embodiment, a computer-readable storage medium including program instructions is also provided, and when the program instructions are executed by a processor, the steps of the above-mentioned data verification method are implemented. For example, the computer-readable storage medium can be the above-mentioned memory 802 including program instructions, and the above-mentioned program instructions can be executed by the processor 801 of the data verification device 800 to complete the above-mentioned data verification method. Embodiment 4:

[0098] Corresponding to the above method embodiment, a readable storage medium is also provided in this embodiment. The readable storage medium described below and the data verification method described above can refer to each other.

[0099] A readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the data verification method of the above method embodiment are implemented.

[0100] The readable storage medium may specifically be a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, or other readable storage medium that can store program codes.

[0101] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

[0102] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any person skilled in the art can easily think of changes or substitutions within the technical scope disclosed by the present invention, which should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. A data verification method, characterized in that: include: Get entity attribute information; Establishing a first data verification template according to the entity attribute information; The first data verification template is designed using a two-dimensional table coordinate form to obtain a second data verification template; Presetting a verification formula for the second data verification template to obtain a third data verification template; Verifying the data filled in the third data verification template according to the third data verification template; The first data verification template is designed using a two-dimensional table coordinate form, including: Obtaining horizontal coordinate information and vertical coordinate information of the first data verification template; Determine field information according to the horizontal coordinate information and the vertical coordinate information, wherein the field information includes field information of a first data verification template header; A random number strategy is used to generate a coordinate unique identifier for the field information of each header of the first data verification template.

2. The data verification method according to claim 1, characterized in that: Establishing a first data verification template according to the entity attribute information includes: Get the data to be verified; Determine the scientific research project category corresponding to the data verification template to be generated according to the data to be verified; Determine entity attribute information according to the scientific research project category corresponding to the data verification template to be generated; Fill the entity attribute information into a preset data verification template to obtain a first data verification template.

3. The data verification method according to claim 1, characterized in that: A verification formula is preset for the second data verification template to obtain a third data verification template, including: Obtain a first formula set, wherein the first formula set includes verification formulas required for all cells; Associate the verification formula required for each cell with the corresponding cell; A corresponding formula unique identifier is generated for each verification formula through a random number strategy to obtain a third data verification template.

4. The data verification method according to claim 1, characterized in that: Verifying the data filled in the third data verification template according to the third data verification template includes: Get the location information of the cell where the user fills in the data; Determine the coordinate unique identifier corresponding to the cell according to the position information corresponding to the cell filled in by the user; The data filled in the cell by the user is verified according to the unique coordinate identifier.

5. A data verification system, characterized in that: include: Acquisition module, used to obtain entity attribute information; A first processing module, used to establish a first data verification template according to the entity attribute information; A second processing module is used to design the first data verification template using a two-dimensional table coordinate form to obtain a second data verification template; A third processing module, configured to preset a verification formula for the second data verification template to obtain a third data verification template; A verification module, used for verifying the data filled in the third data verification template according to the third data verification template; Wherein, the second processing module includes: A second acquisition unit, used to acquire the horizontal coordinate information and the vertical coordinate information of the first data verification template; a fourth processing unit, configured to determine field information according to the horizontal coordinate information and the vertical coordinate information, wherein the field information includes field information of a first data verification template header; The fifth processing unit is used to generate a coordinate unique identifier for the field information of each header of the first data verification template by using a random number strategy.

6. The data verification system according to claim 5, characterized in that: The first processing module comprises: A first acquisition unit, used to acquire data to be verified; A first processing unit, used to determine the scientific research project category corresponding to the data verification template to be generated according to the data to be verified; A second processing unit is used to determine entity attribute information according to the scientific research project category corresponding to the data verification template to be generated; The third processing unit is used to fill the entity attribute information into a preset data verification template to obtain a first data verification template.

7. The data verification system according to claim 5, characterized in that: The third processing module comprises: A third acquisition unit is used to acquire a first formula set, where the first formula set includes verification formulas required for all cells; An association unit is used to associate the verification formula required for each cell with the corresponding cell; The sixth processing unit is used to generate a corresponding formula unique identifier for each verification formula through a random number strategy to obtain a third data verification template.

8. The data verification system according to claim 5, characterized in that: The verification module comprises: A fourth acquisition unit, used to acquire location information corresponding to a cell where data is filled in by a user; A seventh processing unit, configured to determine a unique coordinate identifier corresponding to a cell according to the position information corresponding to the cell in which the user fills in the data; The eighth processing unit is used to verify the data filled in the cell by the user according to the unique coordinate identifier.

Images