CN112508526A - Data auditing method and device - Google Patents
Data auditing method and device Download PDFInfo
- Publication number
- CN112508526A CN112508526A CN202011471420.XA CN202011471420A CN112508526A CN 112508526 A CN112508526 A CN 112508526A CN 202011471420 A CN202011471420 A CN 202011471420A CN 112508526 A CN112508526 A CN 112508526A
- Authority
- CN
- China
- Prior art keywords
- audited
- audit
- point
- data
- auditing
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 63
- 238000012550 audit Methods 0.000 claims abstract description 310
- 238000012545 processing Methods 0.000 claims description 29
- 238000004590 computer program Methods 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 4
- 239000000126 substance Substances 0.000 claims description 3
- 230000009286 beneficial effect Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application provides a data auditing method and device, wherein when data is audited and auditing triggering operation is received, auditing rules to be used are determined in an auditing rule configuration table; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited; after the identification of the point to be audited is determined, auditing the data of the point to be audited according to the auditing operation rule; the method and the device have the advantages that the auditing results corresponding to the to-be-audited points are output, automatic auditing of data is realized, auditing efficiency of the data is improved, and requirements of different fields for data auditing can be met by setting the auditing rule configuration table comprising the auditing rules of a plurality of auditing points, so that the method and the device have universal applicability.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data auditing method and device.
Background
In recent years, the data auditing plays more and more obvious roles of supervision and restriction in the economic field, and is applied to large, medium and small enterprises in various fields.
In the prior art, when data auditing is performed, a technician needs to first make a dedicated data auditing method according to the service types in the field, and then perform auditing processing on the data by using the dedicated data auditing method to obtain an auditing result.
However, the manual auditing method results in low efficiency of data auditing.
Disclosure of Invention
The embodiment of the invention provides a data auditing method and device, which can be used for automatically auditing data when auditing the data, improving the data auditing efficiency, meeting the requirements of different fields on auditing and having universal applicability.
In a first aspect, an embodiment of the present application provides a method for auditing data, where the method for auditing data includes:
when an audit trigger operation is received, the audit rule to be used is determined in an audit rule configuration table; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited.
And if the identification of the point to be audited is determined to exist, auditing the data of the point to be audited according to the auditing operation rule.
And outputting the auditing result corresponding to the point to be audited.
In a possible implementation manner, the auditing the data of the point to be audited according to the auditing operation rule includes:
searching the information of the point to be audited according to the identification of the point to be audited in an audit point configuration table; the audit point configuration table comprises information of a plurality of audit points, and the information of the points to be audited is used for indicating the storage positions of the data of the points to be audited.
And searching the data of the point to be audited according to the storage position of the data of the point to be audited.
And auditing the data of the points to be audited according to the auditing operation rule.
In a possible implementation manner, the auditing the data of the point to be audited according to the auditing operation rule includes:
and processing the data of the point to be audited according to the service type of the data of the point to be audited to obtain the processed data of the point to be audited.
And auditing the processed data of the points to be audited according to the auditing operation rule.
In a possible implementation manner, the information of the point to be audited includes a storage path of the point to be audited, a page number of the point to be audited, row information of the point to be audited, and column information of the point to be audited.
In a possible implementation manner, the searching for the data of the point to be audited according to the storage location of the data of the point to be audited includes:
and reading the data of the point to be audited in the TXT and EXCEL files according to the storage position of the data of the point to be audited.
In a possible implementation manner, before determining the audit rule to be used in the audit rule configuration table, the method further includes:
aiming at each audit point in a plurality of audit points, an audit rule corresponding to the data of the audit point is configured.
And establishing the audit rule configuration table according to the audit rules corresponding to the data of each audit point.
In a second aspect, an embodiment of the present application provides an apparatus for auditing data, where the apparatus for auditing data includes:
the determining unit is used for determining the audit rules to be used in the audit rule configuration table when the audit trigger operation is received; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited.
And the processing unit is used for auditing the data of the point to be audited according to the auditing operation rule if the identification of the point to be audited is determined to exist.
And the output unit is used for outputting the auditing result corresponding to the point to be audited.
In a possible implementation manner, the processing unit is specifically configured to search, in an audit point configuration table, information of the point to be audited according to the identifier of the point to be audited; the audit point configuration table comprises information of a plurality of audit points, and the information of the points to be audited is used for indicating the storage positions of the data of the points to be audited; searching the data of the point to be audited according to the storage position of the data of the point to be audited; and auditing the data of the points to be audited according to the auditing operation rule.
In a possible implementation manner, the processing unit is specifically configured to process the data of the point to be audited according to a service type to which the data of the point to be audited belongs, so as to obtain the processed data of the point to be audited; and auditing the processed data of the points to be audited according to the auditing operation rule.
In a possible implementation manner, the information of the point to be audited includes a storage path of the point to be audited, a page number of the point to be audited, row information of the point to be audited, and column information of the point to be audited.
In a possible implementation manner, the processing unit is specifically configured to read the data of the point to be audited in the TXT and EXCEL files according to the storage location of the data of the point to be audited.
In a possible implementation manner, the apparatus further includes a building unit:
the establishing unit is used for configuring an auditing rule corresponding to the data of the auditing points aiming at each auditing point in a plurality of auditing points; and establishing the audit rule configuration table according to the audit rules corresponding to the data of each audit point.
In a third aspect, an embodiment of the present application further provides a data auditing apparatus, where the data auditing apparatus may include a memory and a processor; wherein the content of the first and second substances,
the memory is used for storing the computer program.
The processor is configured to read the computer program stored in the memory, and execute the data auditing method in any one of the possible implementation manners of the first aspect according to the computer program in the memory.
In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, where a computer-executable instruction is stored in the computer-readable storage medium, and when a processor executes the computer-executable instruction, the method for auditing data in any one of the foregoing possible implementation manners of the first aspect is implemented.
Therefore, the data auditing method and device provided by the embodiment of the application determine the auditing rules to be used in the auditing rule configuration table when the data is audited and the auditing trigger operation is received; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited; after the identification of the point to be audited is determined, auditing the data of the point to be audited according to the auditing operation rule; the method and the device have the advantages that the auditing results corresponding to the to-be-audited points are output, automatic auditing of data is realized, auditing efficiency of the data is improved, and requirements of different fields for data auditing can be met by setting the auditing rule configuration table comprising the auditing rules of a plurality of auditing points, so that the method and the device have universal applicability.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
Fig. 1 is a schematic flowchart illustrating a data auditing method according to an embodiment of the present disclosure;
FIG. 2 is a flowchart illustrating another data auditing method according to an embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of a data auditing apparatus according to an embodiment of the present disclosure;
fig. 4 is a schematic structural diagram of another data auditing apparatus according to an embodiment of the present disclosure.
With the foregoing drawings in mind, certain embodiments of the disclosure have been shown and described in more detail below. These drawings and written description are not intended to limit the scope of the disclosed concepts in any way, but rather to illustrate the concepts of the disclosure to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
In the embodiments of the present invention, "at least one" means one or more, "a plurality" means two or more. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone, wherein A and B can be singular or plural. In the description of the present invention, the character "/" generally indicates that the former and latter associated objects are in an "or" relationship.
The technical scheme provided by the embodiment of the application can be applied to the audit scene of data. The audit of the data has the functions of supervision and restriction on the business of the enterprise and is an indispensable part for the normal operation of the enterprise. In the prior art, when data auditing is performed, a technician needs to first make a dedicated data auditing method according to the service types in the field, and then perform auditing processing on the data by using the dedicated data auditing method to obtain an auditing result. However, the manual auditing method results in low efficiency of data auditing.
In order to improve the auditing efficiency of the data, the financial staff determines the auditing method of the required data as the script operated in the computer system according to the service type, and the data in the financial statement can be automatically audited by only inputting the EXCEL table required to be audited into the computer system and operating the script. Although the automatic data auditing method can improve the data auditing efficiency, the method is only suitable for financial staff and cannot be generally applied to various fields.
In order to solve the problem that the auditing of the data cannot be universally applied, before the data is audited, an auditing point configuration table and an auditing rule configuration table can be established, in order to meet the requirements of various fields, the auditing point configuration table and the auditing rule configuration table can be set according to the requirements of different fields for auditing the data, and when the data is audited, the auditing rules in the auditing rule configuration table are firstly read, and the identification of the point to be audited is determined; and searching corresponding data of the points to be audited in the audit point configuration table according to the identification of the points to be audited, auditing the data of the points to be audited according to the audit rule, outputting the audit result, and processing the data of the points to be audited according to different service types before outputting the audit result so as to further meet the audit requirements of data in different fields.
Based on the technical concept, the embodiment of the application provides a data auditing method, and when auditing trigger operation is received, auditing rules to be used are determined in an auditing rule configuration table; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited; if the identification of the point to be audited is determined to exist, auditing the data of the point to be audited according to the auditing operation rule; and outputting an auditing result corresponding to the point to be audited.
The plurality of audit points can be audit points in the same technical field or audit points in different technical fields, and can be specifically set according to actual needs.
Therefore, in the embodiment of the application, when data audit is performed, the data of the audit points to be audited are audited by adopting the audit rules to be used determined in the audit rule configuration table, and the audit results corresponding to the audit points to be audited are output, so that automatic audit of the data is realized, the audit efficiency of the data is improved, and the audit rule configuration table comprising the audit rules of the plurality of audit points is set, so that the requirements of different fields on data audit can be met, and the universal applicability is realized.
Hereinafter, the auditing method for the data provided by the present application will be described in detail through specific embodiments. It is to be understood that the following detailed description may be combined with other embodiments, and that the same or similar concepts or processes may not be repeated in some embodiments.
Fig. 1 is a flowchart illustrating a data auditing method according to an embodiment of the present disclosure. The data auditing method can be executed by software and/or hardware devices, for example, the hardware device can be a data auditing device, and the data auditing device can be a terminal or a processing chip in the terminal. For example, referring to fig. 1, the data auditing method may include:
s101, when the audit trigger operation is received, the audit rule to be used is determined in the audit rule configuration table.
The audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited.
It can be understood that the audit rule configuration table needs to be pre-established before auditing data, and the method for establishing the audit rule configuration table includes: aiming at each audit point in a plurality of audit points, configuring an audit rule corresponding to the data of the audit point; and establishing an audit rule configuration table according to the audit rules corresponding to the data of each audit point.
For example, the audit rule configuration table may include, in addition to the audit rules of the plurality of audit points, that is, the identifiers of the points to be audited and the audit operation rules corresponding to the points to be audited, the audit rule identifiers, whether the identifiers are audited, the creator, the creation time, the service type, the remarks, and other contents, which may be specifically set according to actual needs.
For example, when the audit rule to be used is determined in the audit rule configuration table, whether the audit flag is set in the audit rule configuration table may be determined according to at least two possible implementation manners:
in a possible implementation manner, if the audit rule configuration table does not set the audit flag, all audit rules in the audit rule configuration table are read, all audit rules are determined as the audit rules to be used, and the flag of the to-be-audited point corresponding to the to-be-audited rule is determined.
In another possible implementation manner, if the audit rule configuration table is provided with the audit-whether identifier, whether the audit rule participates in the audit is judged first, and whether the audit rule is used is determined according to the audit-whether identifier corresponding to each audit rule; wherein, whether the audit mark comprises a participation audit mark and a non-participation audit mark; and reading the auditing rule corresponding to the auditing identification in the auditing rule configuration table, determining the auditing rule corresponding to the auditing identification to be the auditing rule to be used, and determining the identification of the point to be audited corresponding to the auditing rule to be used.
It should be noted that, whether the audit mark is set in the audit rule configuration table may implement screening of the audit rule, and avoid wasting time by auditing the unnecessary data, but when the amount of data to be audited is small, whether the audit mark is set in the audit rule configuration table may not be set.
After determining the audit rule to be used and the identifier of the point to be audited corresponding to the audit rule to be used, the following S102 may be executed:
s102, if the identification of the point to be audited is determined to exist, auditing the data of the point to be audited according to the auditing operation rule.
For example, after the identification of the point to be audited is determined to exist, when the data of the point to be audited is audited according to the auditing operation rule, the information of the point to be audited is searched in the auditing point configuration table according to the identification of the point to be audited; the audit point configuration table includes information of a plurality of audit points, and the information of the points to be audited includes a storage path of the points to be audited, a SHEET page number of the points to be audited, row information of the points to be audited, and column information of the points to be audited.
For example, the row information of the point to be audited includes a row type, a start row and an end row, where the row type has three possible description modes, which are a fixed row, a summary row and a keyword row, and here, the present application is only illustrated by using examples of the fixed row, the summary row and the keyword row, but the present application is not limited thereto.
For example, when the information of the point to be audited is searched according to the identifier of the point to be audited and the data of the point to be audited is determined, the storage path of the point to be audited can be searched according to the identifier of the point to be audited; finding a file where the data of the point to be audited is located according to a storage path of the data of the point to be audited, wherein the file where the data of the point to be audited is located can be a TXT file or an EXCEL file; and determining the data of the point to be audited in the file according to the SHEET page number, the row information and the row information of the data of the point to be audited.
After the data of the point to be audited is obtained, the data of the point to be audited can be audited directly according to the auditing operation rule, or the data of the point to be audited can be processed according to the service type of the data of the point to be audited, and then the processed data of the point to be audited can be audited according to the auditing operation rule. For example, the data of the point to be audited is processed for tax removal, and the specific data processing type can be set according to the service type, and the application is not limited in any way. And then auditing the processed data of the points to be audited according to the auditing operation rule. The audit operation rule may be four arithmetic operations or more complex arithmetic operations, and the embodiment of the present application is not limited in any way.
After auditing the processed data of the point to be audited according to the auditing operation rule, the following S103 may be executed:
s103, outputting an auditing result corresponding to the point to be audited.
Therefore, in the embodiment of the application, when data audit is performed, the data of the audit points to be audited are audited by adopting the audit rules to be used determined in the audit rule configuration table, and the audit results corresponding to the audit points to be audited are output, so that automatic audit of the data is realized, the audit efficiency of the data is improved, and the audit rule configuration table comprising the audit rules of the plurality of audit points is set, so that the requirements of different fields on data audit can be met, and the universal applicability is realized.
In order to facilitate understanding of the data auditing method provided in the embodiment of the present application, the technical solution provided in the embodiment of the present application will be described in detail below with reference to fig. 2 as an example, and fig. 2 is a schematic flow chart of another data auditing method provided in the embodiment of the present application.
Before auditing data, each audit point to be audited may be configured with an audit point configuration table, which is used to determine data of the audit point, as shown in table 1. The audit point configuration table comprises audit point identifications, file types, file paths, SHEET page numbers, line types, keywords, starting lines, ending lines, row serial numbers and data processing, wherein the identifications of 10 audit points in the table 1 are sequentially represented by numbers 1-10; the file types are TXT and EXCEL; the file path is a storage path of the file where the audit point is located; the serial number of the SHEET page is the serial number of the SHEET page in the EXCEL file where the audit point is located; the line type is three types of keyword line, fixed line and summary line, wherein when the line type is the keyword line, only the column serial number of the keyword is needed to be set, when the line type is the fixed line, only the initial line is needed to be set, and when the line type is the summary line, the initial line and the termination line are needed to be set; the data processing comprises two processing modes of meta-conversion processing (. about.0.01) and tax removing processing (/ 1.09). It should be understood that, when the file type is TXT, the column number is a number of a column separated by a separator (e.g., comma), and this application is only for illustration purpose, but does not represent that the application is limited thereto.
TABLE 1
It can be seen by combining table 1 that the file paths of all the audit points are E: \ government affairs, the SHEET pages are the first SHEET pages of the located EXCEL files, wherein the types of the files where the audit points 1, 3, 4, 8 and 9 are located are the EXCEL files, the line types are fixed lines, the data of the audit points 1, 3, 4, 8 and 9 are the data of the 5 th, 3 rd, 12 th, 8 th and 10 th lines of the located SHEET pages, and the data of the audit points 4 is subjected to tax removing processing (/1.09), and the data of the audit points 9 is subjected to meta-score processing (/ 0.01). The types of the lines of the audit points 2, 5 and 6 are summary lines, wherein the data of the audit points 2 are the lines 2 to 5 of the TXT file, the data of the audit points 5 are the lines 4 to 9 of the EXCEL file, and the data of the audit points 6 are the lines 1 to 10 of the TXT file. The types of the files of the audit points 7 and 10 are EXCEL files, the line types are keyword lines, wherein the keywords corresponding to the audit points 7 are 'total', and the position of the data of the audit points is the 30 th column of the files; the keyword corresponding to the audit point 10 is "contract liability", and the data of the audit point is the 10 th column of the document.
With respect to the 10 audit points shown in table 1, the audit rules corresponding to the data configuration of the 10 audit points according to the service requirements may be established according to the corresponding audit rules, which may be specifically shown in table 2, where table 2 is the audit rule corresponding to the data of the audit points shown in table 1. The audit rule configuration table comprises audit rule identification, whether audit is required, audit rule description, service types, audit operation rules, remarks, creators and creation time. It should be understood that the present application is only described by way of example that the audit rule configuration table includes the above information, but the present application is not limited thereto.
TABLE 2
According to the table 2, the audit rule identifications are a1, a2, A3, a4, a5 and a 6; whether the audit mark is marked by Y and N, wherein Y represents the participation of audit, and N represents the non-participation of audit; the audit rule description is used for briefly representing information such as time, personnel and/or serial numbers, and can be set by the user according to the requirement; the service type is e-government service and voice service, and the auditing operation rule is used for searching the auditing points and auditing the data of the auditing points; the remarks are settlement audit, acceptance and management audit and financial audit, which can be set according to the actual situation; the creator is here denoted zj 275; the creation time represents the creation time of the audit rule, and is respectively 10/2020 and 22/10/2020.
When the operation of starting audit is received, reading an audit rule configuration table shown in table 2, judging whether the audit rule participates in audit or not by using an audit identifier corresponding to the audit rule identifier, determining the audit rule to be used, if the audit rule identifier is corresponding to the audit identifier, judging that the audit rule does not participate in audit, and if the audit rule identifier is corresponding to the audit identifier, judging that the audit rule participates in audit; namely, the audit rules A3 and A5 in Table 2 do not participate in audit, and audit reports are directly output, and the audit rules A1, A2, A5 and A6 participate in audit, and the audit rules A1, A2, A5 and A6 are the audit rules to be used.
After the audit rules to be used are determined according to the audit rule configuration table, audit operation rules in the audit rules A1, A2, A5 and A6 to be used are obtained, and whether audit point identifications corresponding to the audit operation rules exist in the audit point configuration table of the table 1 or not is judged; determining an audit point identifier to be audited, wherein audit points 11 appearing in the audit rule A6 are not in table 1, so that the audit rule A6 cannot participate in audit, and directly outputting an audit report; and identifying the audit points corresponding to the audit rules A1, A2 and A5, and determining the audit points to be audited, namely the audit point 1, the audit point 2, the audit point 3, the audit point 5, the audit point 6, the audit point 7 and the audit point 10 in the table 1 are the audit points to be audited. Acquiring a storage path, a SHEET page number, row information and row information of each audit point, and determining data of the audit points; the storage path of the audit point comprises the file type and the file path of a file where each audit point is located, the row information comprises a row type, an initial row and a termination row, and the row information is the row serial number of a row where the audit point data is located; auditing the data of each auditing point according to the auditing operation rules in the auditing rule configuration table, and outputting an auditing report.
When the data of each audit point in the table 1 are audited according to the audit operation rule in the table 2, the audit operation rule 2 corresponding to the audit rule a2 is 5 to 6, and the audit operation rule 7 corresponding to the audit rule a5 is 10, the data of the audit point 1, the audit point 2, the audit point 3, the audit point 5, the audit point 6, the audit point 7, and the audit point 10 are audited according to the audit operation rule 1 to 3 corresponding to the audit rule a1, wherein the data of the audit point 2 and the audit point 6 are stored in the EXCEL file, and the data of other audit points are stored in the EXCEL file, that is, the audit method of the data provided by the application can not only realize the data between the same file types, but also realize the data between different file types, thereby realizing the automatic audit of the data, improving the audit efficiency of the data, and the audit rule configuration of the audit point 10 is set, the method can meet the requirements of different fields on data auditing and has universal applicability.
It can be understood that the output audit report may include, in addition to the audit result, the service type and the remark in the audit rule configuration table, which are used for annotating the audit result to facilitate searching the audit result.
Fig. 3 is a schematic structural diagram of a data auditing device 30 according to an embodiment of the present application, and for example, please refer to fig. 3, the data auditing device 30 may include:
the determining unit 301 is configured to determine an audit rule to be used in an audit rule configuration table when an audit trigger operation is received; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited.
The processing unit 302 is configured to audit data of the point to be audited according to the audit operation rule if it is determined that the identifier of the point to be audited exists.
The output unit 303 is configured to output an audit result corresponding to the point to be audited.
Optionally, the processing unit 302 is specifically configured to search, in the audit point configuration table, information of the point to be audited according to the identifier of the point to be audited; the audit point configuration table comprises information of a plurality of audit points, and the information of the points to be audited is used for indicating the storage positions of the data of the points to be audited; searching the data of the point to be audited according to the storage position of the data of the point to be audited; and auditing the data of the point to be audited according to the auditing operation rule.
Optionally, the processing unit 302 is specifically configured to process the data of the point to be audited according to the service type to which the data of the point to be audited belongs, so as to obtain the processed data of the point to be audited; and auditing the processed data of the points to be audited according to the auditing operation rule.
Optionally, the information of the point to be audited includes a storage path of the point to be audited, a page number of the point to be audited, row information of the point to be audited, and column information of the point to be audited.
Optionally, the processing unit 302 is specifically configured to read the data of the point to be audited in the TXT and EXCEL files according to the storage location of the data of the point to be audited.
Optionally, the data auditing apparatus 30 further includes a creating unit 304.
The establishing unit 304 is configured to configure an audit rule corresponding to data of an audit point for each audit point of a plurality of audit points; and establishing an audit rule configuration table according to the audit rules corresponding to the data of each audit point.
The data auditing device 30 provided in the embodiment of the present application may implement the technical solution of the data auditing method in any embodiment, and its implementation principle and beneficial effects are similar to those of the data auditing method, and reference may be made to the implementation principle and beneficial effects of the data auditing method, which are not described herein again.
Fig. 4 is a schematic structural diagram of another data auditing device 40 provided in the embodiment of the present application, and for example, please refer to fig. 4, the data auditing device 40 may include a processor 401 and a memory 402; wherein the content of the first and second substances,
the memory 402 is used for storing computer programs.
The processor 401 is configured to read the computer program stored in the memory 402, and execute the technical solution of the auditing method of the data in any of the above embodiments according to the computer program in the memory 402.
Alternatively, the memory 402 may be separate or integrated with the processor 401. When the memory 402 is a device independent from the processor 401, the data auditing apparatus 40 may further include: a bus for connecting the memory 402 and the processor 401.
Optionally, this embodiment further includes: a communication interface that may be connected to the processor 401 through a bus. The processor 401 may control the communication interface to implement the functions of receiving and sending the data by the auditing apparatus 40.
The data auditing device 40 shown in the embodiment of the present invention can execute the technical solution of the data auditing method in any embodiment, and the implementation principle and the beneficial effects thereof are similar to those of the data auditing method, and reference may be made to the implementation principle and the beneficial effects of the data auditing method, which are not described herein again.
The embodiment of the present invention further provides a computer-readable storage medium, where a computer execution instruction is stored in the computer-readable storage medium, and when a processor executes the computer execution instruction, the technical solution for implementing the data auditing method in any of the above embodiments is implemented, and the implementation principle and the beneficial effects of the technical solution are similar to those of the data auditing method, and reference may be made to the implementation principle and the beneficial effects of the data auditing method, which are not described herein again.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts shown as units may or may not be physical units, may be located in one position, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment. In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated module implemented in the form of a software functional module may be stored in a computer-readable storage medium. The software functional module is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to execute some steps of the methods according to the embodiments of the present invention.
It should be understood that the Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor, or in a combination of the hardware and software modules within the processor.
The memory may comprise a high-speed RAM memory, and may further comprise a non-volatile storage NVM, such as at least one disk memory, and may also be a usb disk, a removable hard disk, a read-only memory, a magnetic or optical disk, etc.
The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended ISA (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, the buses in the figures of the present invention are not limited to only one bus or one type of bus.
The computer-readable storage medium may be implemented by any type or combination of volatile or non-volatile memory devices, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (14)
1. A method for auditing data, comprising:
when an audit trigger operation is received, the audit rule to be used is determined in an audit rule configuration table; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited;
if the identification of the point to be audited is determined to exist, auditing the data of the point to be audited according to the auditing operation rule;
and outputting the auditing result corresponding to the point to be audited.
2. The method as claimed in claim 1, wherein the auditing the data of the point to be audited according to the auditing operation rules comprises:
searching the information of the point to be audited according to the identification of the point to be audited in an audit point configuration table; the audit point configuration table comprises information of a plurality of audit points, and the information of the points to be audited is used for indicating the storage positions of the data of the points to be audited;
searching the data of the point to be audited according to the storage position of the data of the point to be audited;
and auditing the data of the points to be audited according to the auditing operation rule.
3. The method as claimed in claim 2, wherein the auditing the data of the point to be audited according to the auditing operation rules comprises:
processing the data of the point to be audited according to the service type of the data of the point to be audited to obtain the processed data of the point to be audited;
and auditing the processed data of the points to be audited according to the auditing operation rule.
4. The method of claim 2,
the information of the point to be audited comprises a storage path of the point to be audited, a SHEET page number of the point to be audited, row information of the point to be audited and row information of the point to be audited.
5. The method as claimed in claim 4, wherein the searching for the data of the point to be audited according to the storage location of the data of the point to be audited comprises:
and reading the data of the point to be audited in the TXT and EXCEL files according to the storage position of the data of the point to be audited.
6. The method according to any of claims 1-5, wherein before determining the audit rules to be used in the audit rule configuration table, the method further comprises:
aiming at each audit point in a plurality of audit points, configuring an audit rule corresponding to the data of the audit point;
and establishing the audit rule configuration table according to the audit rules corresponding to the data of each audit point.
7. An apparatus for auditing data, comprising:
the determining unit is used for determining the audit rules to be used in the audit rule configuration table when the audit trigger operation is received; the audit rule configuration table comprises audit rules of a plurality of audit points, and the audit rules to be used comprise identifications of the points to be audited and audit operation rules corresponding to the points to be audited;
the processing unit is used for auditing the data of the point to be audited according to the auditing operation rule if the identification of the point to be audited is determined to exist;
and the output unit is used for outputting the auditing result corresponding to the point to be audited.
8. The apparatus of claim 7,
the processing unit is specifically used for searching the information of the point to be audited in an audit point configuration table according to the identification of the point to be audited; the audit point configuration table comprises information of a plurality of audit points, and the information of the points to be audited is used for indicating the storage positions of the data of the points to be audited; searching the data of the point to be audited according to the storage position of the data of the point to be audited; and auditing the data of the points to be audited according to the auditing operation rule.
9. The apparatus of claim 8,
the processing unit is specifically configured to process the data of the point to be audited according to the service type to which the data of the point to be audited belongs, so as to obtain the processed data of the point to be audited; and auditing the processed data of the points to be audited according to the auditing operation rule.
10. The apparatus of claim 8,
the information of the point to be audited comprises a storage path of the point to be audited, a SHEET page number of the point to be audited, row information of the point to be audited and row information of the point to be audited.
11. The apparatus of claim 10,
and the processing unit is specifically used for reading the data of the point to be audited in the TXT and EXCEL files according to the storage position of the data of the point to be audited.
12. The apparatus according to any of claims 7-11, characterized in that the apparatus further comprises a setup unit:
the establishing unit is used for configuring an auditing rule corresponding to the data of the auditing points aiming at each auditing point in a plurality of auditing points; and establishing the audit rule configuration table according to the audit rules corresponding to the data of each audit point.
13. The data auditing device is characterized by comprising a memory and a processor; wherein the content of the first and second substances,
the memory for storing a computer program;
the processor is used for reading the computer program stored in the memory and executing the data auditing method of any one of the claims 1-6 according to the computer program in the memory.
14. A computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, which when executed by a processor, implement the method for auditing data according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011471420.XA CN112508526B (en) | 2020-12-15 | 2020-12-15 | Data auditing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011471420.XA CN112508526B (en) | 2020-12-15 | 2020-12-15 | Data auditing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112508526A true CN112508526A (en) | 2021-03-16 |
| CN112508526B CN112508526B (en) | 2024-04-19 |
Family
ID=74973221
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011471420.XA Active CN112508526B (en) | 2020-12-15 | 2020-12-15 | Data auditing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112508526B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113986577A (en) * | 2021-10-25 | 2022-01-28 | 中国联合网络通信集团有限公司 | Data processing method, device and equipment based on timer |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050159969A1 (en) * | 2004-01-21 | 2005-07-21 | Sheppard Robert F. | Managing information technology (IT) infrastructure of an enterprise using a centralized logistics and management (CLAM) tool |
| CN101026647A (en) * | 2007-04-09 | 2007-08-29 | 中国网络通信集团公司 | Telecommunication income check dynamic hierarchical management system and method |
| CN101902532A (en) * | 2009-05-27 | 2010-12-01 | 北京汉铭通信有限公司 | Data auditing method and system of telecommunication services |
| CN105931016A (en) * | 2016-04-14 | 2016-09-07 | 北京思特奇信息技术股份有限公司 | Automatic daily audit method and system |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| EP3467740A1 (en) * | 2018-06-20 | 2019-04-10 | DataCo GmbH | Method and system for generating reports |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN111159171A (en) * | 2019-12-31 | 2020-05-15 | 中国铁塔股份有限公司 | Data auditing method and system |
| CN111639478A (en) * | 2020-06-05 | 2020-09-08 | 远光软件股份有限公司 | Automatic data auditing method and system based on EXCEL document |
| CN111651439A (en) * | 2020-04-29 | 2020-09-11 | 中国平安财产保险股份有限公司 | Data auditing method and device and computer readable storage medium |
-
2020
- 2020-12-15 CN CN202011471420.XA patent/CN112508526B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050159969A1 (en) * | 2004-01-21 | 2005-07-21 | Sheppard Robert F. | Managing information technology (IT) infrastructure of an enterprise using a centralized logistics and management (CLAM) tool |
| CN101026647A (en) * | 2007-04-09 | 2007-08-29 | 中国网络通信集团公司 | Telecommunication income check dynamic hierarchical management system and method |
| CN101902532A (en) * | 2009-05-27 | 2010-12-01 | 北京汉铭通信有限公司 | Data auditing method and system of telecommunication services |
| CN105931016A (en) * | 2016-04-14 | 2016-09-07 | 北京思特奇信息技术股份有限公司 | Automatic daily audit method and system |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| EP3467740A1 (en) * | 2018-06-20 | 2019-04-10 | DataCo GmbH | Method and system for generating reports |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN111159171A (en) * | 2019-12-31 | 2020-05-15 | 中国铁塔股份有限公司 | Data auditing method and system |
| CN111651439A (en) * | 2020-04-29 | 2020-09-11 | 中国平安财产保险股份有限公司 | Data auditing method and device and computer readable storage medium |
| CN111639478A (en) * | 2020-06-05 | 2020-09-08 | 远光软件股份有限公司 | Automatic data auditing method and system based on EXCEL document |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113986577A (en) * | 2021-10-25 | 2022-01-28 | 中国联合网络通信集团有限公司 | Data processing method, device and equipment based on timer |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112508526B (en) | 2024-04-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108376364B (en) | Payment system account checking method and device and terminal device | |
| CN112597153B (en) | Block chain-based data storage method, device and storage medium | |
| CN110377462B (en) | Interface testing method and device and terminal equipment | |
| CN111124479B (en) | Method and system for analyzing configuration file and electronic equipment | |
| CN109815112B (en) | Data debugging method and device based on functional test and terminal equipment | |
| CN111159497A (en) | Regular expression generation method and regular expression-based data extraction method | |
| CN112508526A (en) | Data auditing method and device | |
| CN111046393B (en) | Vulnerability information uploading method and device, terminal equipment and storage medium | |
| CN110851207B (en) | State transition management method and device, electronic equipment and storage medium | |
| CN110737678B (en) | Data searching method, device, equipment and storage medium | |
| CN116993523A (en) | Configurable account checking method, device, equipment and storage medium | |
| CN112835564A (en) | Code generation method and device | |
| CN110377276B (en) | Source code file management method and device | |
| CN111381905B (en) | Program processing method, device and equipment | |
| CN109324838B (en) | Execution method and execution device of single chip microcomputer program and terminal | |
| CN112764897B (en) | Task request processing method, device and system and computer readable storage medium | |
| CN113282347B (en) | Plug-in operation method, device, equipment and storage medium | |
| CN115375298A (en) | Receiving and paying processing method, system, terminal and medium considering service type | |
| CN110389977B (en) | Database connection creating method and device and terminal equipment | |
| CN111027196A (en) | Simulation analysis task processing method and device for power equipment and storage medium | |
| CN111538589B (en) | Operation optimization method, device, terminal and medium for embedded OS thread blocking queue | |
| CN111143095B (en) | Mobile device application program compatibility flash back prevention method and system | |
| CN112035501B (en) | User identifier updating method, device and equipment | |
| CN111773714B (en) | Game skill configuration method and device and game skill control method and device | |
| CN117290445A (en) | Data processing method, device, equipment and medium applied to item data synchronization |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |