CN111666287A - Data auditing method based on block chain - Google Patents
Data auditing method based on block chain Download PDFInfo
- Publication number
- CN111666287A CN111666287A CN202010484189.1A CN202010484189A CN111666287A CN 111666287 A CN111666287 A CN 111666287A CN 202010484189 A CN202010484189 A CN 202010484189A CN 111666287 A CN111666287 A CN 111666287A
- Authority
- CN
- China
- Prior art keywords
- audit
- auditing
- result
- logic
- chain
- 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
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000012550 audit Methods 0.000 claims abstract description 121
- 238000013507 mapping Methods 0.000 claims abstract description 24
- 238000011161 development Methods 0.000 abstract description 5
- 230000005856 abnormality Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/64—Protecting data integrity, e.g. using checksums, certificates or signatures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data auditing method based on a block chain, which comprises the following steps: respectively constructing an auditing logic configuration table and an auditing result code mapping table, and performing uplink storage on the auditing logic configuration table and the auditing result code mapping table; establishing an auditing logic according to an auditing logic configuration table on the chain, and storing the auditing logic in a chain way; auditing a business data table according to the chain auditing logic, and acquiring an auditing result, wherein the auditing result comprises an auditing result code; chain storing the audit result; and obtaining the audit result description on an audit result code mapping table on the chain through the audit result codes. The unified audit logic configuration table is established, the audit logic can be quickly established through the audit logic configuration table, repeated development is avoided, the audit logic configuration table and the audit logic are stored in a chained mode through an intelligent contract, the audit logic configuration table and the audit logic have the property of being not falsifiable, and the reliability and the supervision performance of the audit result are improved.
Description
Technical Field
The invention relates to the technical field of data auditing, in particular to a data auditing method based on a block chain.
Background
With the vigorous development of the blockchain technology and the emphasis of the state level on the blockchain technology, the technical characteristics of weak centralization, distributed storage, non-falsification, intelligent contracts and the like of the blockchain are applied to the wide field.
Therefore, the technical advantages of the block chain are utilized to remodel the traditional industry, the technical problem of the traditional industry is solved, and the block chain technology becomes the key for the application of the block chain technology. Asynchronous information exists among different data statistics systems, so that data among the systems are inconsistent, and problems can be found only through user complaints or manual audit. Different auditing logics are needed to be used in different auditing scenes, such as telecom operators, smart cities and small and medium enterprises, the data structures are different, so that different auditing logics need to be applied.
Disclosure of Invention
In view of the above technical problems, the present invention provides a data auditing method based on block chains, which can quickly establish auditing logic and avoid repeated development.
The invention discloses a data auditing method based on a block chain, which comprises the following steps: respectively constructing an auditing logic configuration table and an auditing result code mapping table, and performing uplink storage on the auditing logic configuration table and the auditing result code mapping table; establishing an auditing logic according to an auditing logic configuration table on the chain, and storing the auditing logic in a chain way; auditing a business data table according to the chain auditing logic, and acquiring an auditing result, wherein the auditing result comprises an auditing result code; chain storing the audit result; and obtaining the audit result description on an audit result code mapping table on the chain through the audit result codes.
Preferably, the present invention further includes a method for constructing the service data table: constructing a service data table configuration table, and performing uplink storage on the service data table configuration table; establishing a service data table structure according to a service data structure and a service data table configuration table on a chain, and uplink-storing the service data table structure; and constructing a service data table according to the service data and the service data table structure on the chain, and uplink-storing the service data table.
Preferably, the service data table configuration table includes a data table name, a primary key, a table field and a remark.
Preferably, the audit logic configuration table comprises audit codes, audit logic table names, query conditions, result fields and audit operations.
Preferably, the audit logic includes audit codes, and the invention further includes a method for establishing an audit logic code table: and establishing an audit code table according to the audit codes and the meanings thereof, and uplink storing the audit code table.
Preferably, the invention further comprises a method for establishing the audit result table, wherein the method comprises the following steps: and establishing an audit result table according to the audit result and the audit result description, and uploading and storing the audit result table.
Preferably, the audit result code mapping table further includes a result type.
Preferably, the audit result codes further include error codes, and error descriptions are obtained from the audit result code mapping table on the chain through the error codes.
Preferably, the audit result code further includes an alarm code, and the alarm description is obtained from the audit result code mapping table on the chain through the alarm code.
Compared with the prior art, the invention has the beneficial effects that: a unified audit logic configuration table is established, audit logic can be quickly established through the audit logic configuration table, and repeated development is avoided; the audit logic configuration table and the audit logic are stored in a chain way through the intelligent contract, so that the audit logic has the property of being not falsified, and the reliability and the supervision of the audit result are improved.
Drawings
FIG. 1 is a schematic flow diagram of the present invention.
Detailed Description
In order to make the objects, 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 with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
The invention is described in further detail below with reference to the attached drawing figures:
a method for auditing data based on block chains, as shown in fig. 1, the method includes:
step 101: respectively constructing an auditing logic configuration table and an auditing result code mapping table, and performing uplink storage on the auditing logic configuration table and the auditing result code mapping table. And establishing a uniform audit model by constructing an audit logic configuration table.
Step 102: and establishing an auditing logic according to an auditing logic configuration table on the chain, and storing the auditing logic in a chain way. The audit logic configuration table is convenient for quickly constructing audit logic, and the audit logic can be an audit algorithm or a combination of the audit algorithms. The audit logic configuration table can also add new audit logic.
Step 103: auditing the service data table according to the chain auditing logic, and acquiring an auditing result, wherein the auditing result comprises an auditing result code. The service data table may be stored on a chain.
Step 104: and uploading and storing the audit result.
Step 105: and obtaining the audit result description on an audit result code mapping table on the chain through the audit result codes. And returning an audit result in the form of audit structure codes. The audit result is transmitted through the audit result code, and the audit efficiency or the data transmission efficiency is improved.
The uplink storage may store the data uplink via a smart contract. The invention establishes a unified audit logic configuration table, can quickly construct audit logic through the audit logic configuration table and avoids repeated development. The audit logic configuration table and the audit logic are stored and shared in a chain way through the intelligent contract, so that the audit logic has the property of being not falsified, and the reliability and the supervision performance of the audit result are improved.
The invention also comprises a method for constructing the service data table, which comprises the following steps:
step 110: and constructing a service data table configuration table, and uplink storing the service data table configuration table. And establishing a uniform service data table configuration template and uniform table fields.
Step 111: and constructing a service data table structure according to the service data and the service data table configuration table on the chain, and uplink-storing the service data table structure. And selecting required table fields from the service data table configuration template according to the service data to construct a structure of the service data table.
Step 112: and constructing a service data table according to the service data and the service data table structure on the chain, and uplink-storing the service data table.
And a unified business data table configuration template and a unified table field are established, so that audit among business data of different links and different systems is facilitated.
In a specific embodiment, the service data table configuration table includes a data table name, a primary key, a table field, and a remark. As shown in the following table:
| table name | Main key | Table field | Remarks for note |
| T_testTable | testID | Column1,…,ColumnN | test service data table |
The table field may be defined according to the content involved in the actual service, such as transaction time, unit price, amount, transaction amount, or commodity name.
The audit logic configuration table may include audit codes, table names, query conditions, result fields, and audit operations. As shown in the following table:
the audit logic configuration table is used for storing the audit algorithm, and can select one line from the audit logic configuration table to construct the audit logic or select multiple lines to be spliced into the audit logic.
The invention also comprises a method for establishing the audit logic code table, which comprises the following steps:
and establishing an audit code table according to the audit codes and the meanings thereof, and uplink storing the audit code table. The audit code is used for referring to a logic algorithm, but is inconvenient to read and analyze, so that the establishment of an audit code table is beneficial to analyzing the meaning of the audit code, such as the following table.
| Audit code | Means of | |
| 1 | 0-10000 | Configuring operation is carried out on different contact data under key value |
| 2 | 10001-20000 | The contact data under the key value and the configured value are configured |
| 3 | 20001-30000 | 1 configuration operation with configured value |
| 4 | 30001-40000 | Configuring operation is carried out on certain contact data under 1 result and key value |
The invention also comprises a method for establishing the audit result table, which comprises the following steps:
step 106: and establishing an audit result table according to the audit result and the audit result description, and uploading and storing the audit result table. And simultaneously storing the audit result description and the audit result obtained by combining the audit result with the audit structure mapping table in the audit result table.
The audit result code mapping table may also include a result type. And when the result meeting the auditing logic is found in the service data table, returning a normal value of the result type for quickly judging the auditing result.
In a specific embodiment, comparing A, B, C the D fields in the three service data tables, taking the D fields in the three service data tables as the auditing algorithm, the constructed result code mapping table is as follows:
| result_code | result_info | type |
| 11 | all three are equal | Is normal |
| 10 | A＝B！＝C | Abnormality (S) |
| 01 | A！＝B＝C | Abnormality (S) |
| 00 | A！＝B！＝C | Abnormality (S) |
And searching the result description in the result code mapping table according to the result code returned by the audit logic.
The audit result codes also comprise error codes and warning codes, error descriptions are obtained from the audit result code mapping table on the chain through the error codes, and warning descriptions are obtained from the audit result code mapping table on the warning code chain. The error code and the warning code are as follows.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (9)
1. A data auditing method based on a block chain is characterized by comprising the following steps:
respectively constructing an auditing logic configuration table and an auditing result code mapping table, and performing uplink storage on the auditing logic configuration table and the auditing result code mapping table;
establishing an auditing logic according to an auditing logic configuration table on the chain, and storing the auditing logic in a chain way;
auditing a business data table according to the chain auditing logic, and acquiring an auditing result, wherein the auditing result comprises an auditing result code;
chain storing the audit result;
and obtaining the audit result description on an audit result code mapping table on the chain through the audit result codes.
2. The block chain-based data auditing method of claim 1 further comprising the method of building a business data table:
constructing a service data table configuration table, and performing uplink storage on the service data table configuration table;
constructing a service data table structure according to service data and a service data table configuration table on a chain, and performing uplink storage on the service data table structure;
and constructing a service data table according to the service data and the service data table structure on the chain, and uplink-storing the service data table.
3. The method of claim 2, wherein the service data table configuration table comprises a data table name, a primary key, a table field and a remark.
4. The block chaining-based data auditing method of claim 1 where said auditing logical configuration table includes auditing codes, auditing logical table names, query conditions, result fields and auditing operations.
5. The method of claim 4, wherein the audit logic includes audit code, further comprising the step of building an audit logic code table:
and establishing an audit code table according to the audit codes and the meanings thereof, and uplink storing the audit code table.
6. The method of claim 1, further comprising the step of creating an audit result table by: and establishing an audit result table according to the audit result and the audit result description, and uploading and storing the audit result table.
7. The method of claim 1, wherein the audit result code mapping table further includes a result type.
8. The method of claim 1, wherein the audit result codes further include error codes, and error descriptions are obtained from an audit result code mapping table on the chain by the error codes.
9. The method as claimed in claim 1 or 8, wherein the audit result codes further include an alarm code, and the alarm description is obtained from the audit result code mapping table on the chain by the alarm code.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010484189.1A CN111666287A (en) | 2020-06-01 | 2020-06-01 | Data auditing method based on block chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010484189.1A CN111666287A (en) | 2020-06-01 | 2020-06-01 | Data auditing method based on block chain |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111666287A true CN111666287A (en) | 2020-09-15 |
Family
ID=72385407
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010484189.1A Pending CN111666287A (en) | 2020-06-01 | 2020-06-01 | Data auditing method based on block chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111666287A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116756262A (en) * | 2023-08-15 | 2023-09-15 | 北京博道焦点科技有限公司 | Electronic fence generation method and system based on map interest point auditing |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| CN110109900A (en) * | 2018-01-26 | 2019-08-09 | 北京京东尚科信息技术有限公司 | Data auditing method, system, electronic equipment and readable storage medium storing program for executing |
| CN110335022A (en) * | 2019-07-08 | 2019-10-15 | 中国联合网络通信集团有限公司 | Automatic auditing method, device, equipment and storage medium |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN111177758A (en) * | 2019-12-27 | 2020-05-19 | 国网上海市电力公司 | Distributed photovoltaic settlement method and system based on block chain |
| CN111727428A (en) * | 2017-11-20 | 2020-09-29 | 欧簿客科技股份有限公司 | Room inventory management system based on block chain |
-
2020
- 2020-06-01 CN CN202010484189.1A patent/CN111666287A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
| CN106971002A (en) * | 2017-04-18 | 2017-07-21 | 北京思特奇信息技术股份有限公司 | A kind of data auditing method and system |
| CN111727428A (en) * | 2017-11-20 | 2020-09-29 | 欧簿客科技股份有限公司 | Room inventory management system based on block chain |
| CN110109900A (en) * | 2018-01-26 | 2019-08-09 | 北京京东尚科信息技术有限公司 | Data auditing method, system, electronic equipment and readable storage medium storing program for executing |
| CN110335022A (en) * | 2019-07-08 | 2019-10-15 | 中国联合网络通信集团有限公司 | Automatic auditing method, device, equipment and storage medium |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
| CN111177758A (en) * | 2019-12-27 | 2020-05-19 | 国网上海市电力公司 | Distributed photovoltaic settlement method and system based on block chain |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116756262A (en) * | 2023-08-15 | 2023-09-15 | 北京博道焦点科技有限公司 | Electronic fence generation method and system based on map interest point auditing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210211471A1 (en) | Highly scalable four-dimensional web-rendering geospatial data system for simulated worlds | |
| JP6388655B2 (en) | Generation of multi-column index of relational database by data bit interleaving for selectivity | |
| CN103336790B (en) | Hadoop-based fast neighborhood rough set attribute reduction method | |
| CN107798038A (en) | Data response method and data response apparatus | |
| CN111506559A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN101027670B (en) | Method and information database structure with user defined priorities for faster data access | |
| CN103455335A (en) | Multilevel classification Web implementation method | |
| US10726005B2 (en) | Virtual split dictionary for search optimization | |
| CN110851663B (en) | Method and device for managing metadata | |
| CN104933621A (en) | Big data analysis system and method for guarantee ring | |
| CN114579584A (en) | Data table processing method and device, computer equipment and storage medium | |
| CN114780335A (en) | Correlation method and device of monitoring data, computer equipment and storage medium | |
| CN111666287A (en) | Data auditing method based on block chain | |
| CN111506552A (en) | Dynamic database design method and system of tree structure | |
| Adzic et al. | Data warehouse population platform | |
| CN111611230A (en) | Method and device for establishing main data system, computer equipment and storage medium | |
| CN117151045A (en) | Report processing method and device based on block chain and computer equipment | |
| CN114565443B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN116127154A (en) | Knowledge tag recommendation method and device, electronic equipment and storage medium | |
| CN112256566B (en) | Fresh-keeping method and device for test cases | |
| CN115270947A (en) | Standardized energy efficiency service model construction method, system, terminal and storage medium | |
| CN111026705A (en) | Building engineering file management method, system and terminal equipment | |
| CN113434508B (en) | Method and apparatus for storing information | |
| KR102084219B1 (en) | Connected data architecture of datalake framework | |
| CN116010424A (en) | Attribute configuration method, attribute configuration device, computer equipment, storage medium and program product |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200915 |
|
| RJ01 | Rejection of invention patent application after publication |