CN111177272A - Block chain-based big data credible auditing method - Google Patents
Block chain-based big data credible auditing method Download PDFInfo
- Publication number
- CN111177272A CN111177272A CN201911418047.9A CN201911418047A CN111177272A CN 111177272 A CN111177272 A CN 111177272A CN 201911418047 A CN201911418047 A CN 201911418047A CN 111177272 A CN111177272 A CN 111177272A
- Authority
- CN
- China
- Prior art keywords
- database
- block chain
- hash value
- original text
- operation result
- 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
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/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
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
-
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention discloses a big data credible auditing method based on a block chain, which comprises the following steps: associating the database with the block chain, uploading the database corresponding to the SQL original text, operating the uploaded SQL statement by the database, storing the hash value of the database and the hash value of the result during operation into the block chain, and returning the operation result; when a query request aiming at the operation is received, comparing the database hash value and the SQL original text hash value stored in the block chain during the operation with the database hash value and the SQL original text hash value during the current request, and displaying the operation result. When the operation result is questioned or the query comparison is inconsistent, the hash value of the database, the hash value of the SQL original text and the hash value of the operation result are compared at the same time, so that the data of the whole flow is ensured to be real and reliable, the database does not need to operate according to the SQL original text again, the auditing efficiency can be effectively improved, and the auditing flow is simplified.
Description
Technical Field
The invention relates to the technical field of block chains, in particular to a big data credible auditing method based on a block chain.
Background
The block chain technology is a novel decentralized protocol, digital currency transactions or other data can be safely stored, information cannot be forged and tampered, transaction confirmation on the block chain is completed by all nodes on the block chain together, consistency of the transaction confirmation is guaranteed through a consensus algorithm, a public account book is maintained on the block chain and used for storing balance of all users on a block chain network, the public account book is located on a storage block, and any node is visible, so that the condition that the transaction or other data cannot be forged and tampered is guaranteed.
Audit, as a surveillance mechanism, plays an important role in modern society. Currently, as networks evolve, the types of content audited are increasing. In the conventional audit, the following problems mainly exist:
in the existing auditing implementation process, a large amount of collected certification materials are required, most of the certification materials are required to be printed as paper documents and then signed and stamped, and even structured data recorded by an electronic system is usually required to be copied to an optical disc or a U disc and then imported into an auditing unit database. This is done, on the one hand, to keep a record of the current evidence document at the time of the audit, in the form of a signature or stamp as proof of responsibility, and, on the other hand, to prevent subsequent tampering with the evidence material in the simplest manner. However, the paper material has natural defects, for example, the paper material is easily damaged and lost, information query is difficult, tampering or loss may occur in the layer-by-layer summary process, multidimensional data statistical analysis is difficult to achieve, and the like.
Disclosure of Invention
The invention aims to provide a block chain-based big data credible auditing method aiming at the defects in the existing auditing process. The block chain technology has natural advantages in the aspects of preventing data tampering and guaranteeing data traceability. The chain type storage structure, the consensus algorithm for guaranteeing the data consistency and the multi-level authority control mechanism can assist in reliable storage of audit evidence. Meanwhile, after the data are linked, favorable conditions are provided for data summarization, statistics and analysis.
The purpose of the invention is realized by the following technical scheme:
a big data credible auditing method based on a block chain comprises the following steps:
(1) the database and the blockchain are associated.
(2) And uploading the SQL original text to a database by the user, and operating by the database according to the SQL original text and returning an operation result to the user. And the block chain synchronously stores the SQL original text, the hash value of the database during operation and the hash value of the operation result, adds a timestamp to ensure that the storage time cannot be tampered, and serves as an identifier of the block chain system for comparison and use of subsequent files and database data. And after the block chain is successfully stored, returning an uploading successful message to the user, returning the SQL (structured query language) original text hash value, the timestamp, the block ID and the transaction ID, simultaneously displaying table data obtained by database operation, namely an operation result to a front-end page, and checking the database operation result through a visual page by the user.
(3) And inquiring and auditing the operation result:
when a user initiates a query request for the operation, the hash value of the database and the hash value of the SQL original text during the operation, which are stored in the block chain, are compared with the hash value of the database and the hash value of the SQL original text during the current request, if the comparison is successful, the operation result is displayed in a front-end page, and the user checks the operation result of the database through a visual page.
When the operation result stored in the database is doubted or the query comparison is inconsistent, an audit request can be sent to the block chain, and the current hash values of the current database, the SQL original text and the operation result are calculated. Comparing the current hash values of the current database, the SQL original text and the operation result with the original hash values stored on the block chain respectively, and if the comparison is successful, indicating that the data is not tampered; if the comparison fails, the data is possibly tampered. The database then marks the inconsistent data fields. By the method, when the user suspects the operation result, the operation is not required to be executed by the database, and the consistency of the operation result can be ensured by comparing the hash values.
Further, the step (1) is specifically: each node of the block chain is associated with a corresponding database by filling in database information, and a database hash value is stored by a consensus algorithm; the block chain returns the associated information to the user. Wherein the database information includes: database connection name, database type, database user name, database password, IP address, database name, port number, and the like. The block chain association information includes: a blockchain name, a node name prefix, a server IP address.
Further, in the step (2), a single-point operation or a consensus operation may be selected when the blockchain is stored synchronously.
Further, in the step (1), the user uploads the file, receives the information and initiates a check and audit request through the client.
The invention has the beneficial effects that: the invention can solve the problem of difficult verification process of the diversity of the evidence file types through block chain verification, and designs a double-writing scheme of storing evidence under a chain and storing evidence on the chain. Specifically, for structured data, the file hash stored on the chain is used as a reliability proof for verifying the file stored under the chain (namely, the database), so that the file information of the audit evidence is completely reserved, and the audit is available for inquiring and downloading, and meanwhile, the audit on whether the data is tampered is provided. The invention ensures the truthful and reliable data of the whole flow by simultaneously comparing the hash value of the database, the hash value of the SQL original text and the hash value of the operation result, and the database does not need to operate according to the SQL original text again, thereby effectively improving the auditing efficiency and simplifying the auditing flow.
Drawings
FIG. 1 is a flow chart of a block chain data writing procedure according to the present invention;
Detailed Description
The present invention will be described in detail below with reference to the drawings and specific embodiments, and the objects and effects of the present invention will become more apparent.
As shown in fig. 1, a big data trusted auditing method based on a block chain includes the following steps:
the method comprises the following steps: associating the database with the blockchain:
optionally, in the big data trusted auditing method based on the block chain technology, each block chain node associates a corresponding database by filling in database information, stores a database hash value by a consensus algorithm, and returns associated information to a user after the consensus is stored. Wherein the database information includes: database connection name, database type, database user name, database password, IP address, database name, port number, and the like. The block chain association information includes: a blockchain name, a node name prefix, a server IP address. In addition, a client can be set, and a user uploads files, receives information and initiates inquiry and audit requests through the client.
Step two: uploading SQL original text to an associated database, performing corresponding operation on the database, and performing corresponding data storage on a block chain:
and the user uploads the SQL original text to the database through the client, the associated database performs operation according to the SQL original text, and the operation result is returned to the client. And the block chain synchronously stores the SQL original text, the SQL original text hash value, the database hash value during operation and the operation result hash value, adds a timestamp to guarantee that the time cannot be tampered, and serves as an identifier of the block chain system for comparison and use of subsequent files and database data. And after the block chain is successfully stored, returning an uploading successful message to the client, returning a hash value, a timestamp, a block ID and a transaction ID, simultaneously displaying the table data obtained by operation to a front-end page of the client, and checking the operation result of the database by a user through a visual page.
When the block chain synchronously stores all the hash values, single-point operation or consensus operation can be selected, wherein the single-point operation means that a single node stores all the hash values, and the consensus operation means that all the nodes (the default is four) of the block chain store all the hash values after consensus. The consensus operation has higher reliability, the single-point operation has higher calculation speed, and the selection can be carried out according to the requirement.
Step three: and inquiring and auditing the operation result:
when a user initiates a query request for the database operation, the system compares the database hash value and the SQL original text hash value stored in the block chain during operation with the database hash value and the SQL original text hash value during the current request respectively, if the comparison is successful, the operation result is displayed in a front-end page, and the user checks the database operation result through a visual page. If the comparison fails, prompting: the comparison of the data before and after is inconsistent, and the possibility of data tampering exists. Then, the user needs to check the authenticity of the data, the SQL original text, or the audit result stored in the database, and can directly send an audit request to the blockchain and calculate the current hash values of the current database, the SQL original text, and the operation result. Comparing the current hash values of the current database, the SQL original text and the operation result with the original hash values stored on the block chain respectively, and if the comparison is successful, indicating that the data is not tampered; if the comparison fails, the database data may be tampered. If the displayed operation result is in doubt, an audit request can be initiated by the block chain, and the operation result is audited. The invention ensures the truthful and reliable data of the whole flow by simultaneously comparing the hash value of the database, the hash value of the SQL original text and the hash value of the operation result, and the database does not need to operate according to the SQL original text again, thereby effectively improving the auditing efficiency and simplifying the auditing flow.
Claims (4)
1. A big data credible auditing method based on a block chain is characterized by comprising the following steps:
(1) the database and the blockchain are associated.
(2) And uploading the SQL original text to a database by the user, operating by the database according to the SQL original text, and storing an operation result into the database. And synchronously storing the SQL original text, the hash value of the database during operation and the hash value of the operation result by the block chain, and adding a timestamp. And after the block chain is successfully stored, returning an uploading successful message to the user, returning the SQL original text hash value, the timestamp, the block ID and the transaction ID, and simultaneously displaying table data obtained by database operation, namely an operation result to a front-end page.
(3) And inquiring and auditing the operation result:
when a user initiates a query request for the operation of the database, the hash value of the database and the hash value of the SQL original text stored in the block chain during the operation are respectively compared with the hash value of the database and the hash value of the SQL original text during the current request, if the comparison is successful, the operation result is displayed in a front-end page, and the user checks the operation result of the database through a visual page.
When the operation result stored in the database is doubted or the query comparison is inconsistent, an audit request can be sent to the block chain, and the current hash values of the current database, the SQL original text and the operation result are calculated. Comparing the current hash values of the current database, the SQL original text and the operation result with the original hash values stored on the block chain respectively, and if the comparison is successful, indicating that the data is not tampered; if the comparison fails, the data is possibly tampered.
2. The block chain-based big data credible auditing method according to claim 1, characterized in that the step (1) is specifically: each node of the block chain is associated with a corresponding database by filling in database information, and a database hash value is stored by a consensus algorithm; the block chain returns the associated information to the user. Wherein the database information includes: database connection name, database type, database user name, database password, IP address, database name, port number, and the like. The block chain association information includes: a blockchain name, a node name prefix, a server IP address.
3. The block chain based big data credible auditing method according to claim 1, characterized in that in step (2), single point operation or consensus operation can be selected when the block chains are stored synchronously.
4. The block chain-based big data trusted auditing method according to claim 1 where a user uploads files, receives information, and initiates query and audit requests through a client.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911418047.9A CN111177272B (en) | 2019-12-31 | 2019-12-31 | Big data credible audit method based on block chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911418047.9A CN111177272B (en) | 2019-12-31 | 2019-12-31 | Big data credible audit method based on block chain |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111177272A true CN111177272A (en) | 2020-05-19 |
| CN111177272B CN111177272B (en) | 2023-09-08 |
Family
ID=70657676
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911418047.9A Active CN111177272B (en) | 2019-12-31 | 2019-12-31 | Big data credible audit method based on block chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111177272B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347119A (en) * | 2020-09-18 | 2021-02-09 | 杭州安恒信息安全技术有限公司 | Data storage method and device applied to auditing system and computer equipment |
| CN112685779A (en) * | 2020-12-31 | 2021-04-20 | 天津南大通用数据技术股份有限公司 | Static credibility judgment method for executing main keywords of select statement based on database |
| CN112734581A (en) * | 2021-01-12 | 2021-04-30 | 广州市讯奇数码科技有限公司 | 5G block chain social security data application system |
| CN112948898A (en) * | 2021-03-31 | 2021-06-11 | 北京众享比特科技有限公司 | Method for preventing application data from being tampered in block chain and security module |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874440A (en) * | 2017-02-07 | 2017-06-20 | 杭州秘猿科技有限公司 | A kind of block chain state storage method based on SQL database |
| CN108038389A (en) * | 2017-12-08 | 2018-05-15 | 福建亿榕信息技术有限公司 | Method and device based on the storage e-file audit-trail daily record of block chain |
| CN108446407A (en) * | 2018-04-12 | 2018-08-24 | 北京百度网讯科技有限公司 | Database audit method based on block chain and device |
| CN109064120A (en) * | 2018-07-10 | 2018-12-21 | 马上游科技股份有限公司 | Tourism electric contract number deposit system based on region chain and deposit card method |
| WO2019101224A2 (en) * | 2019-02-28 | 2019-05-31 | Alibaba Group Holding Limited | System and method for blockchain-based authentication |
| KR20190079324A (en) * | 2017-12-27 | 2019-07-05 | 에이치닥테크놀로지 주식회사 한국영업소 | Method and system for enhancing integrity of batabase based on the block chain system |
| WO2019184210A1 (en) * | 2018-03-27 | 2019-10-03 | 深圳春沐源控股有限公司 | Multi-warehouse data management method based on block chain and related device |
| US20190354607A1 (en) * | 2018-05-18 | 2019-11-21 | Factom | Personal Blockchain Services |
-
2019
- 2019-12-31 CN CN201911418047.9A patent/CN111177272B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874440A (en) * | 2017-02-07 | 2017-06-20 | 杭州秘猿科技有限公司 | A kind of block chain state storage method based on SQL database |
| CN108038389A (en) * | 2017-12-08 | 2018-05-15 | 福建亿榕信息技术有限公司 | Method and device based on the storage e-file audit-trail daily record of block chain |
| KR20190079324A (en) * | 2017-12-27 | 2019-07-05 | 에이치닥테크놀로지 주식회사 한국영업소 | Method and system for enhancing integrity of batabase based on the block chain system |
| WO2019184210A1 (en) * | 2018-03-27 | 2019-10-03 | 深圳春沐源控股有限公司 | Multi-warehouse data management method based on block chain and related device |
| CN108446407A (en) * | 2018-04-12 | 2018-08-24 | 北京百度网讯科技有限公司 | Database audit method based on block chain and device |
| US20190354607A1 (en) * | 2018-05-18 | 2019-11-21 | Factom | Personal Blockchain Services |
| CN109064120A (en) * | 2018-07-10 | 2018-12-21 | 马上游科技股份有限公司 | Tourism electric contract number deposit system based on region chain and deposit card method |
| WO2019101224A2 (en) * | 2019-02-28 | 2019-05-31 | Alibaba Group Holding Limited | System and method for blockchain-based authentication |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347119A (en) * | 2020-09-18 | 2021-02-09 | 杭州安恒信息安全技术有限公司 | Data storage method and device applied to auditing system and computer equipment |
| CN112685779A (en) * | 2020-12-31 | 2021-04-20 | 天津南大通用数据技术股份有限公司 | Static credibility judgment method for executing main keywords of select statement based on database |
| CN112734581A (en) * | 2021-01-12 | 2021-04-30 | 广州市讯奇数码科技有限公司 | 5G block chain social security data application system |
| CN112948898A (en) * | 2021-03-31 | 2021-06-11 | 北京众享比特科技有限公司 | Method for preventing application data from being tampered in block chain and security module |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111177272B (en) | 2023-09-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177272B (en) | Big data credible audit method based on block chain | |
| CN110785760B (en) | Method and system for registering digital documents | |
| US20220209958A1 (en) | Systems and methods for state of data management | |
| US9876779B2 (en) | Document verification with distributed calendar infrastructure | |
| CN107295002B (en) | Cloud data storage method and server | |
| CN106874461B (en) | A kind of workflow engine supports multi-data source configuration security access system and method | |
| US8977860B2 (en) | Method and apparatus for tamper proof camera logs | |
| US7373345B2 (en) | Additional hash functions in content-based addressing | |
| US8549303B2 (en) | Apparatus, system and method for electronically signing electronic transcripts | |
| CN109543065B (en) | Video active identification method combined with block chain | |
| US20050177715A1 (en) | Method and system for managing identities in a peer-to-peer networking environment | |
| US20130232137A1 (en) | Method and apparatus for analysing data packets | |
| CN114079660A (en) | High-performance distributed storage area data, timestamp, cross-link communication and data cooperation method | |
| WO2019233614A1 (en) | A method for registration of data in a blockchain database and a method for verifying data | |
| CN111831740B (en) | Synchronization of peers | |
| WO2020237874A1 (en) | Project data verification method, device, computer apparatus and storage medium | |
| US7519822B2 (en) | Method and apparatus for processing descriptive statements | |
| US8996483B2 (en) | Method and apparatus for recording associations with logs | |
| US7689900B1 (en) | Apparatus, system, and method for electronically signing electronic transcripts | |
| CN111414417B (en) | Video copyright management method based on block chain | |
| US20080243753A1 (en) | Method and Apparatus for Archiving Media Using a Log | |
| US20020087536A1 (en) | Methods for reproducing and recreating original data | |
| CN114462998A (en) | Log tamper-proofing method, system and storage medium | |
| EP1975822A1 (en) | Method and apparatus for recording associations with logs | |
| CN114866257A (en) | Method, device and storage medium for distributed storage and double-verification block chain |
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 |