CN114372293A - Blockchain-based data approval method, device, equipment and storage medium - Google Patents

Abstract

The application discloses a block chain-based data approval method, a block chain-based data approval device, equipment and a storage medium, wherein the method comprises the following steps: responding to a data insertion request for a block chain database table, and acquiring to-be-audited data and a type of the block chain database table; determining a corresponding approval processing strategy based on the type of the block chain database table to obtain an approval result of the to-be-approved data; the block chain database table type comprises a user data table and a data summary table, the user data table has an operation authority of a user side and is used for storing business data of users, and the data summary table has an operation authority of a management platform and is used for storing business data of all users; and inserting the approval record of the data to be approved into the data confirmation table corresponding to the database table type according to the approval result. According to the scheme, the data authority on the chain is clear, data isolation is achieved, the examination and approval process is operated on the chain, traceability and verification of data are guaranteed, and the credibility of all examination and approval processes is higher.

Description

Blockchain-based data approval method, device, equipment and storage medium

technical field

The present invention generally relates to the technical field of blockchain, and specifically relates to a method, device, device and storage medium for data approval based on blockchain.

Background technique

With the continuous development of computer technology, digital office business has been widely used in people's daily life, wherein the digital office business may include an office automation approval process. At present, common office automation approval processes include: financial approval processes, administrative affairs approval processes, and business-related approval processes. In order to better realize office automation, it is particularly important to automate the approval process.

At present, the approval operation in related technologies adopts a centralized approval process, and the generated approval process data is stored in a central database. However, the central database may be hacked, leaked or stolen, which increases the risk of transaction data being tampered with. Risk, there is a problem of untrustworthiness, and the fairness, transparency and validity of transaction data cannot be guaranteed.

SUMMARY OF THE INVENTION

In view of at least one of the above-mentioned defects or deficiencies in the prior art, it is desirable to provide a blockchain-based data approval method, apparatus, device and storage medium.

In a first aspect, the present invention provides a blockchain-based data approval method, the method comprising:

In response to a data insertion request to the blockchain database table, obtain the data to be approved and the type of the blockchain database table;

Based on the block chain database table type, a corresponding approval processing strategy is determined, and the approval result of the data to be approved is obtained; the block chain database table type includes a user data table and a data summary table, and the user data table has The operation authority of the user terminal is used to store the business data of the user, and the data summary table has the operation authority of the management platform, and is used to store the business data of all users;

According to the approval result, the approval record of the data to be approved is inserted into the data confirmation table corresponding to the database table type.

In one embodiment, a corresponding approval processing strategy is determined based on the block chain database table type, and an approval result of the data to be approved is obtained, including:

If the type of the blockchain database table is a user data table, the smart contract node monitors the user data table, synchronizes the pending data in the user data table to the data master table, and obtains the first approval result ;

If the type of the blockchain database table is a data summary table, the smart contract node monitors the data summary table, synchronizes the data to be approved in the data summary table to the user data table, and obtains a second approval result .

In one embodiment, the data to be approved in the user data table is synchronized to the data summary table to obtain a first approval result, including:

Synchronizing the data to be approved in the user data table to the general data table, so that the management platform performs query and review processing on the data to be approved, and determines the first approval result;

The first approval result is acquired, where the first approval result is used to represent whether the data to be approved is incorrect.

In one embodiment, the data to be approved in the general data table is synchronized to the user data table to obtain a second approval result, including:

obtaining the user ID corresponding to the data to be approved;

Synchronizing the data to be approved in the general data table to the user data table corresponding to the user identifier, so that the user terminal performs query and review processing on the data to be approved, and determines a second approval result;

The second approval result is obtained, where the second approval result is used to represent whether the data to be approved is incorrect.

In one embodiment, according to the approval result, inserting the approval record of the data to be approved in the data confirmation table corresponding to the database table type, including:

When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is correct, determine that the data confirmation table corresponding to the data summary table is the management confirmation table, and report to all Insert a confirmation record into the management confirmation form described above;

When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is incorrect, determine that the data confirmation table corresponding to the data summary table is the management confirmation table, and send it to the management confirmation table. A rejection record is inserted into the management confirmation form.

In one embodiment, according to the approval result, inserting the approval record of the data to be approved in the data confirmation table corresponding to the database table type, including:

When the approval result is the second approval result and the second approval result is used to indicate that the data to be approved is correct, determine that the data confirmation table corresponding to the user data table is the user confirmation table, and report to all Insert a confirmation record into the user confirmation form described above;

When the approval result is the second approval result and the second approval result is used to indicate that the data to be approved is incorrect, it is determined that the data confirmation table corresponding to the user data table is the user confirmation table, and sent to A rejection record is inserted into the user confirmation form.

In one embodiment, after inserting the approval record into the management confirmation form, the method further includes:

Monitor the management confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table.

In one embodiment, after inserting the approval record into the user confirmation form, the method further includes:

Monitor the user confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table.

In a second aspect, the present invention provides a block chain-based data approval device, the device comprising:

an acquisition module, configured to acquire the data to be approved and the type of the block chain database table in response to a data insertion request to the block chain database table;

The processing module is used to determine the corresponding approval processing strategy based on the block chain database table type, and obtain the approval result of the data to be approved; the block chain database table type includes a user data table and a data summary table. The user data table has the operation authority through the user, and is used to store the business data of the user, and the data summary table has the operation authority for the management platform, and is used to store the business data of all users;

The inserting module is configured to insert the approval record of the data to be approved into the data confirmation table corresponding to the database table type according to the approval result.

In a third aspect, an embodiment of the present application provides a computer device, including a memory and a processor, the memory stores a computer program, and the processor implements the above-mentioned blockchain-based data approval when executing the computer program method.

In a fourth aspect, embodiments of the present application provide a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the above-mentioned blockchain-based data approval method is implemented.

To sum up, a blockchain-based data approval method, device, equipment and storage medium provided by this application can obtain the data to be approved and the blockchain database by responding to the data insertion request to the blockchain database table Table type, and based on the block chain database table type, determine the corresponding approval processing strategy, and obtain the approval result of the data to be approved. The block chain database table type includes user data table and data summary table, wherein the user data table has user data The operation authority of the terminal is used to store the user's business data. The data master table has the operation authority of the management platform to store the business data of all users. Then, according to the approval result, insert the pending approval into the data confirmation table corresponding to the database table type. Data approval records. In this technical solution, by combining the business approval process with the blockchain database table, the data authority on the chain is clear and data isolation is realized. The business data of all users in the data summary table can be viewed through the management platform. The terminal checks its own data, and the approval process is all processed on the chain. The data confirmation table is used to record the approval record, which ensures the traceability and verifiability of the data. Due to the immutability and timestamp characteristics of the blockchain, the entire approval process is More credibility.

Description of drawings

Other features, objects and advantages of the present application will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings:

1 is a schematic structural diagram of a blockchain-based data approval system provided by an embodiment of the present invention;

2 is a schematic flowchart of a blockchain-based data approval method provided by an embodiment of the present invention;

3 is a schematic flowchart of a blockchain-based data approval method provided by an embodiment of the present invention;

4 is a schematic flowchart of a blockchain-based data approval method provided by another embodiment of the present invention

FIG. 5 is a schematic flowchart of a blockchain-based data approval method provided by an embodiment of the present invention

6 is a schematic flowchart of a blockchain transaction auditing device provided by an embodiment of the present invention;

FIG. 7 is a schematic structural diagram of a computer system according to an embodiment of the present invention.

Detailed ways

The present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the related invention, but not to limit the invention. In addition, it should be noted that, for the convenience of description, only the parts related to the invention are shown in the drawings.

It should be noted that the embodiments in the present application and the features of the embodiments may be combined with each other in the case of no conflict. The present application will be described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.

As mentioned in the background art, with the continuous development of the office business, it is necessary to improve the collaborative office ability through the approval process, so as to realize the orderly office. At present, common office automation approval processes include: financial approval process, administrative affairs approval process, business-related approval process, etc. Among them, the financial approval process may include expense reimbursement, loan repayment approval, work and payment, payment income approval, etc.; administrative approval process may include leave, business trip approval, overtime approval, etc.; business-related approval processes may include, for example, order approval. process, procurement approval process, contract approval process, etc.

At present, the approval operation in related technologies adopts a centralized approval process, and the generated approval process data is stored in a central database. However, the central database may be hacked, leaked or stolen, which increases the risk of transaction data being tampered with. Risk, there is a problem of untrustworthiness, and the fairness, transparency and validity of transaction data cannot be guaranteed.

Based on the above defects, the present application provides a blockchain-based data approval method, device, device and storage medium. Compared with the existing technology, in this technical solution, by combining the business approval process with the blockchain database table, the data authority on the chain is clear, and data isolation is realized, and the business of all users in the data summary table can be viewed through the management platform. For data, users can only view their own data on the client side, and the approval process is all on-chain operations. The data confirmation table is used to record the approval records, which ensures the traceability and verifiability of the data. Due to the immutability and time constraints of the blockchain The stamp feature makes the entire approval process more credible.

It can be understood that the blockchain-based data approval method provided in this application can be applied to a blockchain-based data approval system. Figure 1 is a system structure diagram under the application scenario of the application. Platform 20 and Blockchain 30. The blockchain 30 communicates with the client 10 and the management platform 20 respectively.

The above-mentioned client 10 may be a client used by the initiator of the data to be approved in the business approval process, and the data to be approved may be reimbursement data, for example. The above-mentioned management platform 20 may be the executor of managing the business data of all users, may be a node in the blockchain network, or may not be a node in the blockchain network, it communicates with each node in the blockchain network connect. The above-mentioned blockchain 30 may be a ChainSQL chain. By building a table on the blockchain, the user's operations are recorded through a database table.

It should be noted that the above-mentioned ChainSQL is a database application platform based on blockchain. The operation of database tables is reached on the blockchain network in the form of transactions, and then stored on the blockchain nodes and the local database. Each data center provides service functions at the same time, and the data center will no longer be divided into active and standby data centers. Each data center is a production center and "backup" for each other, which not only improves the service efficiency of the data center, but also ensures the data center. safe operation.

The above-mentioned blockchain 30 includes a plurality of blockchain nodes, the blockchain nodes may include smart contract nodes, and communication can be performed between every two blockchain nodes. Optionally, the above-mentioned client 10 and management platform 20 may run on a terminal device, and the terminal device may be a mobile portable terminal such as a notebook computer, a tablet computer, a desktop computer, a smart phone, or the like, or the electronic device may be a smart glasses, A smart wearable device such as a smart watch is not specifically limited in this embodiment. The above-mentioned blockchain 30 may be a server, a server cluster composed of multiple servers, or a cloud computing service center.

The client 10 is used to send a data insertion request to the blockchain database to the blockchain 30, where the data insertion request includes the type of the blockchain database table and is used to synchronize the pending data in the data master table to the user data When it is in the table, query and review the data to be approved.

The management platform 20 is used to send a data insertion request to the blockchain database to the blockchain 30, where the data insertion request includes the type of the blockchain database table, and is used to synchronize the pending data in the user data table to the data master. When it is in the table, query and review the data to be approved.

The block chain 30 is used to obtain the data to be approved and the block chain database table type in response to the data insertion request of the block chain database table, and determine the corresponding approval processing strategy based on the block chain database table type, and obtain the data to be approved and the approval record for inserting the data to be approved in the data confirmation table corresponding to the database table type according to the approval result.

Optionally, a communication connection may be established between the terminal device and the server through a wired or wireless network. Optionally, the above-mentioned wireless network or wired network uses standard communication technologies and/or protocols. The network is usually the Internet, but can be any network, including but not limited to Local Area Network (LAN), Metropolitan Area Network (MAN), Wide Area Network (WAN), mobile, wired or wireless network , private network, or any combination of virtual private networks.

For ease of understanding and description, the block chain-based data approval method, apparatus, device, and storage medium provided by the embodiments of the present application are described in detail below with reference to FIG. 2 to FIG. 7 .

FIG. 2 is a schematic flowchart of a blockchain-based data approval method provided by an embodiment of the present application. As shown in FIG. 2 , the method can be applied to nodes in a blockchain network, and the method includes:

S101. Acquire the data to be approved and the type of the blockchain database table in response to the data insertion request to the blockchain database table.

Specifically, when the client needs to conduct business process approval processing based on the blockchain, it needs to register on the management platform first, and an on-chain identity can be generated on the client. The on-chain identity can be a wallet address, and then through the management The platform binds the system identity to the on-chain identity to activate the user's on-chain identity, thereby realizing the user's registration on the blockchain.

After the registration process is completed, an on-chain database table and a data confirmation table may be created for the user, the database table may be a user data table, and the corresponding data confirmation table may be a user confirmation table. Among them, the naming rule of the user data table is: data_user number; the naming rule of the user confirmation table is confirm_user number. The user has the operation authority to operate the user confirmation table and the user data table, and can perform the insert operation on the user confirmation table and the user data table through the user terminal.

It should be noted that the above user data table is used to store the user's service data, and the user confirmation table is used to store the user's confirmation information for the service data, and the confirmation information may include key fields in the service data and data identifiers of the service data. For example, when the business data is reimbursement data, the confirmation information may be reimbursement time and reimbursement amount.

It can be understood that the above-mentioned blockchain may also include a data summary table and a management confirmation table, wherein the management platform has the operation authority to operate the data summary table and the management confirmation table. The management confirmation table performs the insert operation. The above-mentioned data summary table is used to store the business data of all users, and the management confirmation table is used to store the confirmation information of all users on the business data, and the confirmation information may include key fields in the business data of all users and data identifiers of the business data.

When the user needs to approve the data to be approved, he can send a data insertion request to the blockchain database table to the blockchain, the data insertion request includes the data to be approved, so that the blockchain responds Data insertion request, insert pending approval data into the user data table to obtain pending approval data and blockchain database table type. The block chain database table type may include user data table and data summary table. Wherein, the data to be approved includes a unique identification id, and the data to be approved is in a state of to be reviewed.

Optionally, when the management platform needs to perform approval processing on the approval data, it can send a data insertion request to the blockchain database table to the blockchain, where the data insertion request includes the data to be approved, so that the blockchain responds to the request to the blockchain. The data insertion request of the block chain database table, insert the pending data into the data master table to obtain the pending data and the block chain database table type.

In this step, by creating a blockchain database table, user data table, management confirmation table and user confirmation table, that is, by creating a total table and sub-tables, data isolation is achieved, the problem of authorized user restrictions is solved, and the data integrity is ensured. safety.

S102. Determine the corresponding approval processing strategy based on the block chain database table type, and obtain the approval result of the data to be approved; the block chain database table type includes a user data table and a data summary table. In order to store the user's business data, the data summary table has the operation authority of the management platform and is used to store the business data of all users.

Specifically, when the block chain database table type is determined, a corresponding approval processing strategy can be determined according to the block chain database table type. For example, the approval processing strategy can include a first approval processing strategy and a second approval processing strategy, wherein , the first approval processing strategy is the approval processing strategy corresponding to the user data table, and the second approval processing strategy is the approval processing strategy corresponding to the data master table. The first approval processing strategy and the second approval processing strategy are different.

S103 , according to the approval result, insert the approval record of the data to be approved in the data confirmation table corresponding to the database table type.

After the corresponding approval processing strategy is determined, the approval processing is performed on the data to be approved, thereby obtaining the approval result. Among them, when the blockchain database table type is user data table, the smart contract node monitors the user data table, and synchronizes the pending data in the user data table to the data master table, so as to obtain the first approval result; if the blockchain If the database table type is the data summary table, the smart contract node monitors the data summary table, synchronizes the pending approval data in the data summary table to the user data table, and obtains the second approval result.

Further, according to the approval result, the approval record of the data to be approved can be inserted into the data confirmation table corresponding to the database table type. Wherein, when the database table type is a user data table, the corresponding data confirmation table is a user confirmation table; when the database table type is a data summary table, the corresponding data confirmation table is a management confirmation table. The above approval result is used to indicate whether the data to be approved is incorrect. The approval record may include a confirmation record or a rejection record of the data to be approved.

In this step, row-level control and table-level control can be implemented for database tables, and a synchronous update operation of data approval records is implemented, which makes it more adaptable and applicable to different business scenarios.

Among them, row-level control refers to the ability of database access control to be precise to the row-level of the data table so that the database can achieve row-level access control.

The blockchain-based data approval method provided by this application obtains the data to be approved and the type of the blockchain database table by responding to a data insertion request to the blockchain database table, and determines the corresponding data based on the type of the blockchain database table. Approval processing strategy, get the approval result of the data to be approved, the block chain database table types include user data table and data summary table, where the user data table has the operation authority of the user side, and is used to store the user's business data. The table has the operation authority of the management platform and is used to store the business data of all users. Then, according to the approval result, the approval record of the data to be approved is inserted into the data confirmation table corresponding to the database table type. In this technical solution, by combining the business approval process with the blockchain database table, the data authority on the chain is clear and data isolation is realized. The business data of all users in the data summary table can be viewed through the management platform. The terminal checks its own data, and the approval process is all processed on the chain. The data confirmation table is used to record the approval records, which ensures the traceability and verifiability of the data. Due to the immutability and timestamp characteristics of the blockchain, all approval processes are More credibility.

Optionally, as an implementable manner, FIG. 3 is a schematic flowchart of the blockchain-based data approval method provided by the embodiment of the present application. As shown in Figure 3, the method includes:

S201. If the block chain database table type is a user data table, monitor the user data table through the smart contract node, and synchronize the pending data in the user data table to the data master table.

S202, the management platform performs query and review processing on the data to be approved, and determines the first approval result.

S203. When the first approval result is used to indicate that the data to be approved is correct, determine the data confirmation table corresponding to the data summary table as the management confirmation table, and insert a confirmation record into the management confirmation table.

S204. When the first approval result is used to indicate that the data to be approved is incorrect, determine the data confirmation table corresponding to the data summary table as the management confirmation table, and insert a rejection record into the management confirmation table.

S205, monitor the management confirmation table through the smart contract node, and update the review status of the data to be approved in the data master table and the user data table.

Specifically, as shown in Figure 4, when the client sends a data insertion request to the blockchain database table, obtains the data to be approved and the blockchain database table type, and then determines that the blockchain database table type is the user data table , in response to the data insertion request, insert the data to be approved into the user data table, the data to be approved has a unique identity, and the status is to be reviewed, and then monitor the user data table through the smart contract node, and put the user data table in the user data table. The data to be approved is synchronized to the data master table, and the data to be approved is in the state to be reviewed, and then the management platform is used to query and review the data to be approved to check whether the data to be approved is incorrect, so as to obtain the first approval result.

Wherein, when the first approval result is used to represent that the data to be approved is correct, the data confirmation table corresponding to the data summary table is determined as the management confirmation table, and the approval record is inserted into the management confirmation table. When the first approval result is used to indicate that the data to be approved is incorrect, the data confirmation table corresponding to the data summary table is determined as the management confirmation table, and a rejection record is inserted into the management confirmation table. And the confirmation record or rejection record is associated with the data identifier of the data to be approved. Then monitor the management confirmation table through the smart contract node, update the review status of the pending data in the data master table and the user data table, and update the review status to the reviewed status.

It should be noted that a smart contract is a "computer transaction agreement that executes the terms of the contract", all users on the blockchain can see the smart contract based on the blockchain, and the smart contract node is the node in the blockchain that executes the smart contract , which is used to monitor data changes in the blockchain database table and data confirmation table. A smart contract is a special protocol that can be used when formulating contracts in the blockchain. It contains code functions, and can also interact with other contracts, make decisions, store data, and send ether.

In this embodiment, when the data to be approved is inserted into the user data table, the data to be approved in the user data table can be synchronized to the data master table, and then the corresponding approval record is inserted into the corresponding management confirmation table, thereby realizing the The smart contract synchronously confirms the status of the data to be approved, and the approval process is all operated on the chain, achieving traceable and verifiable effects.

As another achievable manner, FIG. 5 is a schematic flowchart of the blockchain-based data approval method provided by the embodiment of the present application. As shown in Figure 5, the method includes:

S301. If the block chain database table type is a data summary table, monitor the data summary table through the smart contract node, and synchronize the data to be approved in the data summary table to the user data table.

S302. The client performs query and review processing on the data to be approved, and determines a second approval result.

S303. When the second approval result is used to indicate that the data to be approved is correct, determine the data confirmation table corresponding to the user data table as the user confirmation table, and insert a confirmation record into the user confirmation table.

S304. When the second approval result is used to indicate that the data to be approved is incorrect, determine the data confirmation table corresponding to the user data table as the user confirmation table, and insert a rejection record into the user confirmation table.

S305. Monitor the user confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table.

Specifically, please continue to refer to Figure 5. When the management platform sends a data insertion request to the blockchain database table, obtains the data to be approved and the blockchain database table type, and then determines that the blockchain database table type is the data total table, in response to the data insertion request, insert the data to be approved into the data summary table, the data to be approved has a unique identity, and the status is pending review, and then monitor the data summary table through the smart contract node to obtain the data to be approved For the corresponding user ID, synchronize the data to be approved in the data master table to the user data table corresponding to the user ID, and the data to be approved is in the pending review state, and then query and review the data to be approved through the client to query Check whether the data to be approved is incorrect to obtain the second approval result.

Wherein, when the second approval result is used to indicate that the data to be approved is correct, the data confirmation table corresponding to the user data table is determined as the user confirmation table, and a confirmation record is inserted into the user confirmation table. When the second approval result is used to indicate that the data to be approved is incorrect, the data confirmation table corresponding to the user data table is determined as the user confirmation table, and a rejection record is inserted into the user confirmation table. And the confirmation record or rejection record is associated with the data identifier of the data to be approved. Then monitor the user confirmation table through the smart contract node, update the review status of the data to be approved in the data summary table and the user data table, and update the review status to the reviewed status.

In this embodiment, when the data to be approved is inserted into the data summary table, the pending data in the data summary table can be synchronized to the user data table, and then the corresponding approval record is inserted into the corresponding user confirmation table, thereby realizing the The smart contract synchronously confirms the status of the data to be approved, and the approval process is all operated on the chain, which achieves traceable and verifiable effects, and can be applied to different business scenarios with strong scalability.

It should be noted that although the operations of the methods of the present invention are depicted in the figures in a particular order, this does not require or imply that the operations must be performed in that particular order, or that all illustrated operations must be performed to achieve desirable results . Rather, the steps depicted in the flowcharts may change the order of execution. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined to be performed as one step, and/or one step may be decomposed into multiple steps to be performed.

On the other hand, FIG. 6 is a schematic structural diagram of a blockchain-based data approval apparatus provided by an embodiment of the present application. As shown in Figure 6, the device includes:

The obtaining module 10 is used for obtaining the data to be approved and the type of the blockchain database table in response to the data insertion request to the blockchain database table;

The processing module 20 is used to determine the corresponding approval processing strategy based on the block chain database table type, and obtain the approval result of the data to be approved; the block chain database table type includes a user data table and a data summary table, and the user data table is obtained by the user The operation authority is used to store the user's business data, and the data summary table has the operation authority for the management platform and is used to store the business data of all users;

The inserting module 30 is configured to insert the approval record of the data to be approved into the data confirmation table corresponding to the database table type according to the approval result.

Optionally, the above-mentioned processing module 20 is specifically used for:

If the block chain database table type is user data table, monitor the user data table through the smart contract node, synchronize the pending data in the user data table to the data master table, and obtain the first approval result;

If the block chain database table type is the data summary table, the smart contract node monitors the data summary table, synchronizes the pending data in the data summary table to the user data table, and obtains the second approval result.

Optionally, the above-mentioned processing module 20 is specifically used for:

Synchronize the data to be approved in the user data table to the data master table, so that the management platform performs query and review processing on the data to be approved, and determines the first approval result;

The first approval result is obtained, and the first approval result is used to represent whether the data to be approved is incorrect.

Optionally, the above-mentioned processing module 20 is specifically used for:

Obtain the user ID corresponding to the data to be approved;

Synchronizing the to-be-approved data in the data master table to the user data table corresponding to the user ID, so that the user terminal performs query and review processing on the to-be-approved data, and determines the second approval result;

The second approval result is obtained, and the second approval result is used to represent whether the data to be approved is incorrect.

Optionally, the above-mentioned insertion module 30 is specifically used for:

When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is correct, determine the data confirmation table corresponding to the data summary table as the management confirmation table, and insert the confirmation record into the management confirmation table;

When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is incorrect, the data confirmation table corresponding to the data summary table is determined as the management confirmation table, and a rejection record is inserted into the management confirmation table.

Optionally, the above-mentioned insertion module 30 is specifically used for:

When the approval result is the second approval result and the second approval result is used to represent that the data to be approved is correct, determine that the data confirmation table corresponding to the user data table is the user confirmation table, and insert a confirmation record into the user confirmation table;

When the approval result is the second approval result and the second approval result is used to indicate that the data to be approved is incorrect, the data confirmation table corresponding to the user data table is determined as the user confirmation table, and a rejection record is inserted into the user confirmation table.

Optionally, the above device is also used for:

Monitor the management confirmation table through smart contract nodes, and update the review status of the data to be approved in the data master table and user data table.

Optionally, the above device is also used for:

Monitor the user confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table.

The blockchain-based data approval device provided in this embodiment can execute the embodiments of the above method, and the implementation principle and technical effect thereof are similar, and are not repeated here.

Referring next to FIG. 7 , it shows a schematic structural diagram of a computer system 600 suitable for implementing the embodiments of the present application, and the computer system may be applied to a server.

As shown in FIG. 7 , the computer system 600 includes a central processing unit (CPU) 601 that can be loaded into a random access memory (RAM) 603 according to a program stored in a read only memory (ROM) 602 or a program from a storage section 603 Instead, various appropriate actions and processes are performed. In the RAM 603, various programs and data necessary for the operation of the system 600 are also stored. The CPU 601 , the ROM 602 and the RAM 603 are connected to each other through a bus 604 . An input/output (I/O) interface 605 is also connected to bus 604 .

The following components are connected to the I/O interface 605: an input section 606 including a keyboard, a mouse, etc.; an output section 607 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 608 including a hard disk, etc. ; and a communication section 609 including a network interface card such as a LAN card, a modem, and the like. The communication section 609 performs communication processing via a network such as the Internet. A drive 610 is also connected to the I/O interface 605 as needed. A removable medium 611, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is mounted on the drive 610 as needed so that a computer program read therefrom is installed into the storage section 608 as needed.

In particular, according to an embodiment of the blockchain-based data approval method disclosed in the present application, the process described above with reference to FIG. 6 may be implemented as a computer software program. For example, embodiments of the master control module disclosed herein include a computer program product including a computer program tangibly embodied on a machine-readable medium, the computer program including a program for performing the methods of FIGS. 2-4 code. In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 605, and/or installed from the removable medium 611.

It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium, or any combination of the above two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples of computer readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable Programmable read only memory (EPROM or flash memory), fiber optics, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In this application, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

In this application, however, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device . Program code embodied on a computer readable medium may be transmitted using any suitable medium including, but not limited to, wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

The flowchart and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of various computer systems, methods and computer program products in accordance with the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code that contains one or more functions for implementing the specified logical function(s) executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the blocks may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It is also noted that each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented in dedicated hardware-based systems that perform the specified functions or operations , or can be implemented in a combination of dedicated hardware and computer instructions.

The units or modules involved in the embodiments of the present application may be implemented in a software manner, and may also be implemented in a hardware manner. The described unit or module can also be provided in the processor, for example, it can be described as: a processor includes an acquisition module, a processing module and an insertion module. Among them, the names of these units or modules do not constitute a limitation on the unit or module itself, for example, the acquisition module can also be described as "used to respond to a data insertion request to a blockchain database table, Obtain pending data and the type of the blockchain database table".

As another aspect, the present application also provides a computer-readable storage medium, and the computer-readable storage medium may be the computer-readable storage medium included in the aforementioned apparatus in the foregoing embodiment; computer-readable storage medium in the device. The computer-readable storage medium stores one or more programs, and the aforementioned programs are used by one or more processors to execute the blockchain-based data approval method described in this application, and specifically execute:

In response to a data insertion request to the blockchain database table, obtain the data to be approved and the type of the blockchain database table;

Based on the block chain database table type, a corresponding approval processing strategy is determined, and the approval result of the data to be approved is obtained; the block chain database table type includes a user data table and a data summary table, and the user data table has The operation authority of the user terminal is used to store the business data of the user, and the data summary table has the operation authority of the management platform, and is used to store the business data of all users;

According to the approval result, the approval record of the data to be approved is inserted into the data confirmation table corresponding to the database table type.

To sum up, a blockchain-based data approval method, device, equipment and storage medium provided by this application can obtain the data to be approved and the blockchain database by responding to the data insertion request to the blockchain database table Table type, and based on the block chain database table type, determine the corresponding approval processing strategy, and obtain the approval result of the data to be approved. The block chain database table type includes user data table and data summary table, wherein the user data table has user data The operation authority of the terminal is used to store the user's business data. The data summary table has the operation authority of the management platform to store the business data of all users. Then, according to the approval result, insert the pending approval into the data confirmation table corresponding to the database table type. Data approval records. In this technical solution, by combining the business approval process with the blockchain database table, the data authority on the chain is clear and data isolation is realized. The business data of all users in the data summary table can be viewed through the management platform. The terminal checks its own data, and the approval process is all processed on the chain. The data confirmation table is used to record the approval records, which ensures the traceability and verifiability of the data. Due to the immutability and timestamp characteristics of the blockchain, all approval processes are More credibility.

It should be noted that although several modules or units of the apparatus for action performance are mentioned in the above detailed description, this division is not mandatory. Indeed, according to embodiments of the present disclosure, the features and functions of two or more modules or units described above may be embodied in one module or unit. Conversely, the features and functions of one module or unit described above may be further divided into multiple modules or units to be embodied.

Additionally, although the various steps of the methods of the present disclosure are depicted in the figures in a particular order, this does not require or imply that the steps must be performed in the particular order or that all illustrated steps must be performed to achieve the desired result. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into one step for execution, and/or one step may be decomposed into multiple steps for execution, and the like. From the description of the above embodiments, those skilled in the art can easily understand that the exemplary embodiments described herein may be implemented by software, or may be implemented by software combined with necessary hardware.

Claims (11)

1. A block chain-based data approval method, characterized in that, comprising: In response to a data insertion request to the blockchain database table, obtain the data to be approved and the type of the blockchain database table; Based on the block chain database table type, a corresponding approval processing strategy is determined, and the approval result of the data to be approved is obtained; the block chain database table type includes a user data table and a data summary table, and the user data table has The operation authority of the user terminal is used to store the business data of the user, and the data summary table has the operation authority of the management platform, and is used to store the business data of all users; According to the approval result, the approval record of the data to be approved is inserted into the data confirmation table corresponding to the database table type. 2. The method according to claim 1, wherein, based on the block chain database table type, determining a corresponding approval processing strategy, and obtaining the approval result of the data to be approved, comprising: If the type of the blockchain database table is a user data table, the smart contract node monitors the user data table, synchronizes the pending data in the user data table to the data master table, and obtains the first approval result ; If the type of the blockchain database table is a data summary table, the smart contract node monitors the data summary table, synchronizes the data to be approved in the data summary table to the user data table, and obtains a second approval result . 3. The method according to claim 2, wherein the data to be approved in the user data table is synchronized to the data summary table to obtain a first approval result, comprising: Synchronizing the data to be approved in the user data table to the general data table, so that the management platform performs query and review processing on the data to be approved, and determines the first approval result; The first approval result is acquired, where the first approval result is used to represent whether the data to be approved is incorrect. 4. The method according to claim 2, wherein the data to be approved in the data master table is synchronized to the user data table to obtain a second approval result, comprising: obtaining the user ID corresponding to the data to be approved; Synchronizing the data to be approved in the general data table to the user data table corresponding to the user identifier, so that the user terminal performs query and review processing on the data to be approved, and determines a second approval result; The second approval result is acquired, where the second approval result is used to represent whether the data to be approved is incorrect. 5. The method according to claim 3, wherein, according to the approval result, inserting the approval record of the data to be approved in the data confirmation table corresponding to the database table type, comprising: When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is correct, determine that the data confirmation table corresponding to the data summary table is the management confirmation table, and report to all Insert a confirmation record into the management confirmation form described above; When the approval result is the first approval result and the first approval result is used to indicate that the data to be approved is incorrect, determine that the data confirmation table corresponding to the data summary table is the management confirmation table, and send it to the management confirmation table. A rejection record is inserted into the management confirmation form. 6. The method according to claim 4, wherein, according to the approval result, inserting the approval record of the data to be approved in the data confirmation table corresponding to the database table type, comprising: When the approval result is the second approval result and the second approval result is used to indicate that the data to be approved is correct, determine that the data confirmation table corresponding to the user data table is the user confirmation table, and report to all Insert a confirmation record into the user confirmation form described above; When the approval result is the second approval result and the second approval result is used to indicate that the data to be approved is incorrect, it is determined that the data confirmation table corresponding to the user data table is the user confirmation table, and sent to A rejection record is inserted into the user confirmation form. 7. The method according to claim 5, wherein after inserting the approval record into the management confirmation table, the method further comprises: Monitor the management confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table. 8. The method according to claim 6, wherein after inserting the approval record into the user confirmation table, the method further comprises: Monitor the user confirmation table through the smart contract node, and update the review status of the data to be approved in the data summary table and the user data table. 9. A block chain-based data approval device, characterized in that it comprises: an acquisition module, configured to acquire the data to be approved and the type of the block chain database table in response to a data insertion request to the block chain database table; The processing module is used to determine the corresponding approval processing strategy based on the block chain database table type, and obtain the approval result of the data to be approved; the block chain database table type includes a user data table and a data summary table. The user data table has the operation authority through the user, and is used to store the business data of the user, and the data summary table has the operation authority for the management platform, and is used to store the business data of all users; The inserting module is configured to insert the approval record of the data to be approved into the data confirmation table corresponding to the database table type according to the approval result. 10. A computer device, comprising a memory, a processor, and a computer program stored in the memory and running on the processor, wherein the processor implements any one of claims 1-8 when the processor executes the program. one of the methods described. 11. A computer-readable storage medium having stored thereon a computer program that, when executed by a processor, implements the method of any one of claims 1-8.

Images