CN111177272B - Big data credible audit method based on block chain - Google Patents
Big data credible audit method based on block chain Download PDFInfo
- Publication number
- CN111177272B CN111177272B CN201911418047.9A CN201911418047A CN111177272B CN 111177272 B CN111177272 B CN 111177272B CN 201911418047 A CN201911418047 A CN 201911418047A CN 111177272 B CN111177272 B CN 111177272B
- Authority
- CN
- China
- Prior art keywords
- database
- hash value
- blockchain
- sql
- 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.)
- Active
Links
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Computer Security & Cryptography (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Computer Hardware Design (AREA)
- General Health & Medical Sciences (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a big data credible audit method based on a block chain, which comprises the following steps: the method comprises the steps of associating a database with a blockchain, uploading a database corresponding to SQL original text, operating the database aiming at the uploaded SQL statement, storing a database hash value and a result hash value in the blockchain during operation, and returning an operation result; when a query request for the operation is received, comparing the database hash value and the SQL original text hash value stored in the blockchain during 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 in doubt 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 process can be 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 process is simplified.
Description
Technical Field
The invention relates to the technical field of blockchains, in particular to a big data credible audit method based on a blockchain.
Background
The blockchain technology is characterized in that the blockchain is a novel decentralization protocol, digital currency transaction or other data can be safely stored, information cannot be forged and tampered, transaction confirmation on the blockchain is completed by all nodes on the blockchain together, consistency is guaranteed by a consensus algorithm, a public account book is maintained on the blockchain and used for storing balances of all users on a blockchain network, the public account book is located on a storage block, and any node is visible, so that the situation that the transaction cannot be forged and tampered is guaranteed.
Audit plays an important role in modern society as a supervisory mechanism. Currently, as networks evolve, the variety of audited content is also increasing. In traditional auditing, the following problems are mainly present:
in the existing auditing implementation process, a large amount of proving materials need to be collected, and most of proving materials need to be printed into paper files to be signed and stamped, and even structured data recorded by an electronic system also needs to be copied into an optical disk or a U disk and then imported into an auditing unit database. On one hand, the method is to save the current evidence file record of the audit time, take a signature or stamping mode as the responsibility attribution evidence, and on the other hand, the method is also in the simplest mode to prevent the follow-up tampering of the evidence material. However, the paper material has natural defects, such as easy damage and loss of the paper material, difficult information inquiry, possible tampering or loss in the layer-by-layer summarization process, difficult achievement of multidimensional data statistical analysis, and the like.
Disclosure of Invention
The invention aims to provide a big data credible auditing method based on a blockchain aiming at the defects in the existing auditing process. The blockchain 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 consistency of data and the multi-level authority control mechanism can assist the reliable storage of audit evidence. Meanwhile, after the data is uplink, favorable conditions are provided for summarizing, counting and analyzing the data.
The invention aims at realizing the following technical scheme:
a big data credible audit method based on a block chain comprises the following steps:
(1) The database and blockchain are associated.
(2) And uploading the SQL text to a database by the user, operating the database according to the SQL text, and returning an operation result to the user. The block chain synchronously stores SQL original text, SQL original text hash value, database hash value during operation and hash value of operation result, and is tamper-proof after time stamping, and is used as the identification of the block chain system for comparison of subsequent files and database data. After the block chain is successfully stored, a message of successful uploading is returned to the user, an SQL original text hash value, a time stamp, a block ID and a transaction ID are returned, and meanwhile, table data obtained by database operation, namely an operation result, is displayed in a front-end page, and the user views the database operation result through a visual page.
(3) Inquiring and auditing the operation result:
when a user initiates a query request for the operation, comparing the database hash value and the SQL original text hash value stored in the blockchain during the operation with the database hash value and the SQL original text hash value during the current request, and displaying the operation result to a front page if the comparison is successful, and the user checks the database operation result through a visual page.
When the operation results stored in the database are doubtful or inconsistent in query comparison, an audit request can be initiated to the blockchain, and the current database, SQL text and the current hash value of the operation result are calculated. Comparing the current hash value of the current database, the SQL original text and the operation result with the original hash value 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 may be tampered. The database marks inconsistent data fields. In this way, when the user doubts the operation result, the database is not required to execute the operation again, and the consistency of the operation result can be ensured through the comparison of the hash values.
Further, the step (1) specifically comprises the following steps: each node of the block chain associates a corresponding database by filling in database information and stores a database hash value by a consensus algorithm; the blockchain 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, etc. The blockchain association information includes: blockchain names, node name prefixes, server IP addresses.
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 the checksum audit request through the client.
The beneficial effects of the invention are as follows: the invention can solve the problem of difficult verification process of the diversity of the evidence file types through the block chain verification, and designs a double-writing scheme through the under-chain storage and the on-chain storage. Specifically, for structured data, the hash of the file stored on the chain is used as a reliability evidence for verifying the file stored under the chain (namely, the database), so that the audit evidence file information is ensured to be fully reserved, can be inquired and downloaded, and meanwhile, the audit of whether the data is tampered is provided. The invention ensures the reality and reliability of the data of the whole process 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, the database does not need to operate according to the SQL original text again, the auditing efficiency can be effectively improved, and the auditing process is simplified.
Drawings
FIG. 1 is a flowchart illustrating a blockchain data writing procedure in accordance with the present invention;
Detailed Description
The objects and effects of the present invention will become more apparent from the following detailed description of the present invention with reference to the accompanying drawings and specific embodiments.
As shown in FIG. 1, the big data trusted audit method based on the blockchain comprises the following steps:
step one: associating a database and blockchain:
optionally, in the big data trusted audit method based on the blockchain technology, each blockchain 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 consensus storage is completed. Wherein the database information includes: database connection name, database type, database user name, database password, IP address, database name, port number, etc. The blockchain association information includes: blockchain names, node name prefixes, server IP addresses. In addition, a client can be set, and a user uploads a file, receives information and initiates a query and audit request through the client.
Step two: uploading SQL text to an associated database, performing corresponding operation by the database, and storing corresponding data by a blockchain:
and uploading the SQL text to the database by the user through the client, operating the related database according to the SQL text, and returning the operation result to the client. The block chain synchronously stores SQL original text, SQL original text hash value, database hash value and operation result hash value during operation, and is tamper-proof after being time stamped, and the block chain is used as an identifier of a block chain system for comparison of subsequent files and database data. After the block chain is successfully stored, a message of successful uploading is returned to the client, a hash value, a time stamp, a block ID and a transaction ID are returned, meanwhile, the calculated form data are displayed in a front-end page of the client, and a user views a database operation result through a visual page.
When the block chain synchronously stores all the hash values, single-point operation or common-knowledge operation can be selected, wherein the single-point operation is that a single node stores all the hash values, and the common-knowledge operation is that all the nodes (default to four) of the block chain store all the hash values after common-knowledge. The reliability of the consensus operation is higher, the calculation speed of the single-point operation is faster, and the single-point operation can be selected according to the requirement.
Step three: inquiring and auditing the operation result:
when a user initiates a query request for the operation of the database through a client, the system compares the database hash value and the SQL original text hash value stored in the blockchain during operation with the database hash value and the SQL original text hash value during the current request respectively, and 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 front and back comparison of the data is inconsistent, and the data is possibly tampered. The user needs to check the authenticity of the data, the SQL text or the audit result stored in the database, and can directly initiate an audit request to the blockchain, and calculate the current hash value of the current database, the SQL text and the operation result. Comparing the current hash value of the current database, the SQL original text and the operation result with the original hash value 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 with. If the displayed operation result is doubtful, the blockchain can also initiate an audit request to audit the operation result. The invention ensures the reality and reliability of the data of the whole process 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, the database does not need to operate according to the SQL original text again, the auditing efficiency can be effectively improved, and the auditing process is simplified.
Claims (4)
1. The big data credible audit method based on the block chain is characterized by comprising the following steps:
(1) Associating a database and a blockchain;
(2) Uploading SQL text to a database by a user, operating the database according to the SQL text, and storing an operation result into the database; the block chain synchronously stores SQL original text, SQL original text hash value, database hash value during operation and hash value of operation result and adds a time stamp; after the block chain is successfully stored, returning a message which is successfully uploaded to a user, returning an SQL original text hash value, a time stamp, a block ID and a transaction ID, and displaying form data obtained by database operation, namely an operation result, into a front-end page;
(3) Inquiring and auditing the operation result:
when a user initiates a query request for the operation of the database, comparing the database hash value and the SQL original text hash value stored in the blockchain during the operation with the database hash value and the SQL original text hash value during the current request respectively, and displaying an operation result to a front page if the comparison is successful, wherein the user checks the database operation result through a visual page;
when the operation results stored in the database are doubtful or inconsistent in query comparison, an audit request can be initiated to the blockchain, and the current database, the SQL text and the current hash value of the operation result are calculated; comparing the current hash value of the current database, the SQL original text and the operation result with the original hash value 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 may be tampered.
2. The blockchain-based big data trusted audit method of claim 1, wherein the step (1) specifically is: each node of the block chain associates a corresponding database by filling in database information and stores a database hash value 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; the blockchain association information includes: blockchain names, node name prefixes, server IP addresses.
3. The blockchain-based big data trusted audit method of claim 1, wherein in step (2), a single point operation or a consensus operation is selected when the blockchains are stored synchronously.
4. The blockchain-based big data trusted audit method of claim 1, wherein 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 CN111177272A (en) | 2020-05-19 |
| CN111177272B true 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) |
Families Citing this family (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 (7)
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 (7)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111177272A (en) | 2020-05-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177272B (en) | Big data credible audit method based on block chain | |
| CN110495132B (en) | System and method for generating, uploading and executing code blocks within distributed network nodes | |
| US11233657B2 (en) | Method and system for registering digital documents | |
| US9305055B2 (en) | Method and apparatus for analysing data packets | |
| US8549303B2 (en) | Apparatus, system and method for electronically signing electronic transcripts | |
| CN109543065B (en) | Video active identification method combined with block chain | |
| US8977860B2 (en) | Method and apparatus for tamper proof camera logs | |
| JP2020511059A (en) | Information authentication method and system | |
| CN110647503A (en) | Distributed storage method and device | |
| KR20200106000A (en) | System and method for implementing blockchain-based digital certificate | |
| EP2244418A1 (en) | Database security monitoring method, device and system | |
| CN107196934A (en) | A kind of cloud data managing method based on block chain | |
| CN106874461A (en) | A kind of workflow engine supports multi-data source configuration security access system and method | |
| US20040220975A1 (en) | Additional hash functions in content-based addressing | |
| CN108009445B (en) | Semi-centralized trusted data management system | |
| JP2017098806A (en) | Existence proof program and existence proof server for electronic data | |
| EP1698100A1 (en) | System and method for generating a digital certificate | |
| CN110061843B (en) | Block height creating method, device and equipment in chain type account book | |
| US20040221162A1 (en) | Method and systems to facilitate online electronic notary, signatures and time stamping | |
| CN110532529A (en) | A kind of recognition methods of file type and device | |
| CN107292770A (en) | A kind of construction information management method and system based on planar bar code technology | |
| US7689900B1 (en) | Apparatus, system, and method for electronically signing electronic transcripts | |
| CN110347678B (en) | Financial data storage method, system, device and equipment | |
| CN109918451A (en) | Data base management method and system based on block chain | |
| CN111367481B (en) | Electronic printing file generation method, device and system |
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 |