Data processing method and related equipment

Abstract

The invention provides a data processing method. The method comprises the steps that a terminal connects first primary key field data and second primary key field data of relational data to be processed through characters to obtain key field data of target non-relational data; and then, the terminal calls a target data operation program according to the type of the target data operation, and performs target data operation on the block chain based on the target non-relational data. Then, the terminal updates a local database according to a data operation result returned by the target data operation program, and the local database is a relational database. According to the method, storage, insertion, deletion, query, modification and other basic operations of the relational data on the block chain are realized, so that the relational data can utilize the characteristics of traceability and tamper-proofing in the block chain technology.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a data processing method, a data processing device, a computer equipment, and a computer-readable storage medium. Background Art

[0002] Blockchain is a decentralized, distributed public ledger technology based on cryptographic principles. Through the joint participation of multiple nodes in the network in data maintenance and updating, it ensures the security, transparency, immutability and traceability of information.

[0003] In the blockchain network, each block includes a certain number of transaction records, and these transactions will change the global state of the blockchain system after execution. The state of the blockchain system can be stored in the blockchain state database, which is conducive to the management of the blockchain system and the maintenance of the stability of the system.

[0004] However, the current blockchain state database on the blockchain is a non-relational database that only supports the storage of transaction data in a non-relational form and cannot store relational data. As a result, massive relational data cannot use blockchain technology to obtain traceability and tamper-proof characteristics. Summary of the invention

[0005] The present application provides a data processing method, which can store relational data on a blockchain through conversion, so that the relational data can also obtain traceability and tamper-proof characteristics.

[0006] In a first aspect, the present application provides a data processing method. The method can be applied to any processing device with data processing capabilities, such as a terminal. The terminal can be a desktop computer, a laptop computer, or a smart phone.

[0007] Specifically, the terminal connects the first primary key field data and the second primary key field data of the relational data to be processed by characters to obtain the key field data of the target non-relational data. Then, the terminal calls the target data operation program according to the type of the target data operation, and performs the target data operation on the blockchain based on the target non-relational data. Then, the terminal updates the local database according to the data operation result returned by the target data operation program, wherein the local database is a relational database.

[0008] In some possible implementations, the type of the target data operation is inserting data, and the method further includes:

[0009] The remaining field data of the relational data to be processed is used as the value field data of the target non-relational data.

[0010] In some possible implementations, the type of the target data operation is deleting data, and the method further includes:

[0011] The value field data of the target non-relational data is marked as deleted.

[0012] In some possible implementations, the type of the target data operation is query data, and calling a target data operation program to perform the target data operation on the blockchain based on the target non-relational data includes:

[0013] Call the data query program to query the data in the blockchain based on all or part of the field data in the key field data of the target non-relational data as the query condition.

[0014] In some possible implementations, the type of the target data operation is to modify data, the relational data to be processed includes modified non-primary key data, key field data of the target non-relational data is not modified, and the method further includes:

[0015] The modified non-primary key data in the to-be-processed relational data is used as value field data of the target non-relational data.

[0016] In some possible implementations, the type of the target data operation is data modification, the relational data to be processed includes modified primary key data, key field data of the target non-relational data is modified, and the method further includes:

[0017] Get unmodified non-relational data;

[0018] At this time, the calling of the target data operation program to perform the target data operation on the blockchain based on the target non-relational data includes:

[0019] Calling a data deletion program to perform a data deletion operation on the blockchain based on the unmodified non-relational data;

[0020] Call the data insertion program to insert data into the blockchain based on the target non-relational data.

[0021] In some possible implementations, the method further includes:

[0022] The update result of the local database is displayed to the user.

[0023] In a second aspect, the present application provides a data processing device. The device includes:

[0024] The first processing module is used to obtain the key field data of the target non-relational data by character concatenation of the first primary key field data and the second primary key field data of the relational data to be processed;

[0025] A second processing module is used to call a target data operation program according to the type of the target data operation, and perform the target data operation on the blockchain based on the target non-relational data;

[0026] The updating module is used to update the local database according to the data operation result returned by the target data operation program, and the local database is a relational database.

[0027] In some possible implementations, the type of the target data operation is inserting data, and the first processing module is further configured to:

[0028] The remaining field data of the relational data to be processed is used as the value field data of the target non-relational data.

[0029] In some possible implementations, the type of the target data operation is deleting data, and the first processing module is further configured to:

[0030] The value field data of the target non-relational data is marked as deleted.

[0031] In some possible implementations, the type of the target data operation is query data, and when the target data operation program is called to perform the target data operation on the blockchain based on the target non-relational data, the second processing module is specifically used to:

[0032] Call the data query program to query the data in the blockchain based on all or part of the field data in the key field data of the target non-relational data as the query condition.

[0033] In some possible implementations, the type of the target data operation is to modify data, the relational data to be processed includes modified non-primary key data, the key field data of the target non-relational data is not modified, and the first processing module is further used to:

[0034] The modified non-primary key data in the to-be-processed relational data is used as value field data of the target non-relational data.

[0035] In some possible implementations, the type of the target data operation is data modification, the relational data to be processed includes modified primary key data, key field data of the target non-relational data is modified, and the first processing module is further configured to:

[0036] Get unmodified non-relational data;

[0037] At this time, when the target data operation program is called to perform the target data operation on the blockchain based on the target non-relational data, the second processing module is further used to:

[0038] Calling a data deletion program to perform a data deletion operation on the blockchain based on the unmodified non-relational data;

[0039] Call the data insertion program to insert data into the blockchain based on the target non-relational data.

[0040] In some possible implementations, the device further includes a display module, and the display module is specifically configured to:

[0041] The update result of the local database is displayed to the user.

[0042] In a third aspect, the present application provides a device, wherein the device includes a processor and a memory.

[0043] The processor is used to execute instructions stored in the memory so that the device performs the data processing method as described in the first aspect or any implementation manner of the first aspect.

[0044] In a fourth aspect, the present application provides a computer-readable storage medium. The computer-readable storage medium includes instructions, which, when executed on a device, enable the device to execute the data processing method as described in the first aspect or any implementation of the first aspect.

[0045] In a fifth aspect, the present application provides a computer program product comprising instructions, which, when executed on a device, enables the device to execute the data processing method described in the first aspect or any one of the implementations of the first aspect.

[0046] Based on the implementations provided in the above aspects, this application can also be further combined to provide more implementations.

[0047] It can be seen from the above technical solutions that the embodiments of the present application have at least the following advantages:

[0048] The method obtains the key field data of non-relational data according to the primary key field data of the relational data to be processed, and calls the target data operation program according to the type of the target data operation, and performs the target data operation on the blockchain based on the converted target non-relational data, thereby realizing the storage of relational data on the blockchain, as well as basic operations such as insertion, deletion, query and modification, so that the relational data can utilize the traceability and tamper-proof characteristics of the blockchain technology. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0050] Figure 1 A flowchart of a data processing method disclosed in an embodiment of the present application;

[0051] Figure 2 A storage form of relational data on a blockchain disclosed in an embodiment of the present application;

[0052] Figure 3 A schematic diagram of a data operation method disclosed in an embodiment of the present application;

[0053] Figure 4 A schematic diagram of the structure of a data processing device disclosed in an embodiment of the present application. DETAILED DESCRIPTION

[0054] The scheme in the embodiments provided in this application will be described below in conjunction with the drawings in this application.

[0055] The terms used in the following embodiments are only for the purpose of describing specific embodiments and are not intended to be limiting of the present application. The terms "first" and "second" in the embodiments of the present application are only used for descriptive purposes and cannot be understood as indicating or implying relative importance, operation time sequence, or implicitly indicating the number of indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include one or more of the features.

[0056] In order to facilitate understanding of the technical solution of the present application, some technical terms involved in the present application are first introduced.

[0057] Blockchain is a decentralized, distributed public ledger technology based on cryptographic principles. Through the joint participation of multiple nodes in the network in data maintenance and updating, it ensures the security, transparency, immutability and traceability of information. Each block contains multiple transactions or information records generated within a certain period of time, as well as a unique fingerprint (hash value) pointing to the previous block, forming a chain structure in which blocks are connected in chronological order.

[0058] The blockchain state database refers to the database used to store the current system state in the blockchain system, and is an important component of blockchain technology. In the blockchain network, each block includes a certain number of transaction records. After the execution of these transactions, the global state of the system will change. This state can be reflected in various forms such as account balances and state variables of smart contracts. When a new transaction is confirmed in the network and packaged into a block, the transaction processing process will cause the state transfer function to act on the current state and generate a new system state. This latest state will be stored in the blockchain state database, and all nodes participating in the blockchain network will synchronize this state information.

[0059] Since the state of blockchain transactions is distributed and decentralized, it is suitable for the distributed storage of non-relational databases and has good scalability and flexibility. Therefore, many open blockchain frameworks, such as Hyperledger, only support the storage of non-relational databases and non-relational data. As a result, massive relational data cannot take advantage of the security, transparency, immutability and traceability of blockchain technology.

[0060] In view of this, an embodiment of the present application provides a data processing method, which includes: the terminal connects the first primary key field data and the second primary key field data of the relational data to be processed by characters to obtain the key field data of the target non-relational data. Then, the terminal calls the target data operation program according to the type of the target data operation, and performs the target data operation on the blockchain based on the target non-relational data. Then, the terminal updates the local database according to the data operation result returned by the target data operation program, wherein the local database is a relational database.

[0061] The method obtains the key field data of non-relational data according to the primary key field data of the relational data to be processed, and calls the target data operation program according to the type of the target data operation, and performs the target data operation on the blockchain based on the converted target non-relational data, thereby realizing the storage of relational data on the blockchain, as well as basic operations such as insertion, deletion, query and modification, so that the relational data can utilize the traceability and tamper-proof characteristics of the blockchain technology.

[0062] Next, the data processing method provided in the embodiment of the present application will be introduced with reference to the accompanying drawings.

[0063] See also Figure 1 This is a flow chart of a data processing method disclosed in an embodiment of the present application, the method comprising:

[0064] S102: The terminal connects the first primary key field data and the second primary key field data of the relational data to be processed by characters to obtain the key field data of the target non-relational data.

[0065] Relational data refers to data that is organized and stored according to a relational model. The characteristic of relational data is that the data exists in the form of tables. Each table consists of rows and columns. Each row represents a record, and each column represents an attribute or field. Each record has a unique identifier (primary key), and multiple tables can be related to each other through fields (foreign keys) that share the same value, forming a complex data relationship. Relational databases (such as MySQL, Oracle, and SQLServer) use SQL (Structured Query Language) as the standard language for querying and manipulating data, emphasizing data consistency, integrity, and transaction processing capabilities.

[0066] Non-relational data refers to data that is not organized in a strict table format and association constraints. It is more suitable for storing unstructured or semi-structured data types. Non-relational databases (NoSQL) include many types, such as document databases (such as MongoDB), key-value stores (such as Redis), column family databases (such as HBase), graph databases (such as Neo4j), etc. These databases are designed to provide high scalability, flexibility, and high performance. They usually do not follow the ACID principle (atomicity, consistency, isolation, and persistence), but they show advantages in processing large-scale data and high concurrent access, and the data model can be changed more freely according to needs.

[0067] Non-relational databases can use different data structures to store data, such as key-value structures. The key-value structure is simple and flexible, and is widely used in multiple scenarios such as cache data, configuration management information, and real-time data processing. Each data item in the key-value structure consists of a unique key and an associated value. The key field is usually a unique identifier that can be a string, a number, or even binary data; the value field can be any form of data.

[0068] like Figure 2As shown, the terminal can convert relational data into non-relational data of a key-value structure. Specifically, the terminal can connect the first primary key field data and the second primary key field data of the relational data to be processed by characters to obtain the key field data of the target non-relational data. Among them, the relational data to be processed can be provided by a local database or obtained by the terminal in other ways. This application does not limit how to obtain the relational data to be processed.

[0069] for Figure 2 The terminal can concatenate the primary key data id and the data corresponding to name by using "|#" as a separator, and use the concatenated string as the key of the block data. For example, when the data corresponding to id is "1" and the data corresponding to name is "Li Ming", the terminal can use the concatenated string of "1|#Li Ming" as the key of the block data. In this way, it can be stored in a non-relational database that supports the key-value structure on the blockchain.

[0070] S104: The terminal calls the target data operation program according to the type of the target data operation, and performs the target data operation on the blockchain based on the target non-relational data.

[0071] The data operation program can be a smart contract, which is a computer program that automatically executes the terms of the contract and is embedded in the blockchain network. Smart contracts automatically perform corresponding tasks, such as transferring funds, issuing assets, or performing certain operations. The characteristics of smart contracts are that they are self-executing, transparent, fair, and tamper-proof. They can ensure the execution of contract terms without the intervention of middlemen, reducing trust costs and human errors. With the support of blockchain technology, smart contracts can provide a safe and reliable transaction environment and are suitable for a variety of application scenarios, including financial transactions, supply chain management, voting systems, and property rights confirmation.

[0072] like Figure 3 As shown, the terminal can write the converted key-value data into the blockchain through a smart contract. The smart contract may include at least one of an insert data program, a delete data program, a select data program, and an update data program.

[0073] In some possible implementations, the terminal can perform the insert data operation based on the smart contract. At this time, the terminal also needs to use the remaining field data of the relational data to be processed, that is, the foreign key field data, as the value field data of the target non-relational data. Among them, the remaining field data also needs to be spliced ​​with "|#". Then, the terminal can call the insert data program to write the relational data to the blockchain.

[0074] In some possible implementations, the terminal can perform a data deletion operation based on a smart contract. At this time, the terminal also needs to mark the data in the value field of the non-relational data as the deletion status. For example, the value field can be marked as "!DELECT" to indicate a deletion operation. Then, the terminal can call a data deletion program to delete the corresponding block data.

[0075] In some possible implementations, the terminal can perform a data query operation based on a smart contract. At this time, the terminal can call a data query program and use all or part of the field data in the key field data of the non-relational data as the query condition to query the data in the blockchain. This method supports fuzzy queries. For example, for Figure 2 the data shown, when querying all data with the name "Li Ming", the query condition with the key of "%|#Li Ming" can be used for querying.

[0076] In some possible implementations, the terminal can perform a data modification operation based on a smart contract.

[0077] Among them, in some possible implementations, the relational data to be processed includes the modified non-primary key data, that is, the key field data of the non-relational data is not modified. The terminal can use the modified non-primary key data as the data in the value field of the non-relational data, and then call a data modification program to modify the data in the chain.

[0078] In some other possible implementations, the relational data to be processed includes the modified primary key data, that is, the key field data of the non-relational data is modified. The terminal can obtain the unmodified non-relational data, call a data deletion program to delete the corresponding data on the blockchain. Among them, the key of the unmodified non-relational data can be a string concatenated by the primary key data before modification. Then, the terminal can call an data insertion program to insert the modified non-relational data into the blockchain. Among them, the key of the modified non-relational data is a string concatenated by the modified primary key data.

[0079] It should be noted that the above insertion, deletion, and modification operations add a new block at the end of the blockchain and perform data operations in the new block. Therefore, they do not affect the immutability of the original blockchain data.

[0080] S106: The terminal updates the local database according to the data operation result returned by the target data operation program.

[0081] The terminal can use SQL to update the local relational database according to the above program, such as the data operation results returned by the smart contract. In this way, the on-chain data can be synchronized with the local data, thereby ensuring the synchronization of data information.

[0082] In some possible implementations, the terminal can also display the local database update results to the user through a display interface, so that the user can view the on-chain data information in real time, which is conducive to the analysis and management of the blockchain system.

[0083] Based on the above description, an embodiment of the present application provides a data processing method, which obtains key field data of non-relational data based on the primary key field data of the relational data to be processed, and calls the target data operation program according to the type of the target data operation, and performs target data operations on the blockchain based on the target non-relational data obtained by conversion, thereby realizing the storage of relational data on the blockchain, as well as basic operations such as insertion, deletion, query and modification, so that the relational data can utilize the traceability and tamper-proof characteristics of blockchain technology.

[0084] The data processing method provided in the embodiment of the present application is introduced in detail above. Next, the data processing device and equipment provided in the embodiment of the present application will be introduced in conjunction with the accompanying drawings.

[0085] See also Figure 4 A data processing device 400 is shown. The device comprises:

[0086] The first processing module 402 is used to obtain the key field data of the target non-relational data by character concatenation of the first primary key field data and the second primary key field data of the relational data to be processed;

[0087] The second processing module 404 is used to call the target data operation program according to the type of the target data operation, and perform the target data operation on the blockchain based on the target non-relational data;

[0088] The updating module 406 is used to update the local database according to the data operation result returned by the target data operation program, and the local database is a relational database.

[0089] In some possible implementations, the type of the target data operation is inserting data, and the first processing module 402 is further configured to:

[0090] The remaining field data of the relational data to be processed is used as the value field data of the target non-relational data.

[0091] In some possible implementations, the type of the target data operation is deleting data, and the first processing module 402 is further configured to:

[0092] Mark the value field data of the target non-relational data as deleted.

[0093] In some possible implementations, when the type of the target data operation is querying data and the target data operation program is called to perform the target data operation on the blockchain based on the target non-relational data, the second processing module 404 is specifically used to:

[0094] Call the data query program to query the data in the blockchain based on all or part of the field data in the key field data of the target non-relational data as the query condition.

[0095] In some possible implementations, the type of the target data operation is to modify data, the relational data to be processed includes modified non-primary key data, and the key field data of the target non-relational data is not modified. The first processing module 402 is further used to:

[0096] The modified non-primary key data in the relational data to be processed is used as the value field data of the target non-relational data.

[0097] In some possible implementations, the type of the target data operation is to modify data, the relational data to be processed includes modified primary key data, the key field data of the target non-relational data is modified, and the first processing module 402 is further used to:

[0098] Get unmodified non-relational data;

[0099] At this time, when the target data operation program is called and the target data operation is performed on the blockchain based on the target non-relational data, the second processing module 404 is further used to:

[0100] Call the data deletion program to delete data from the blockchain based on unmodified non-relational data;

[0101] Call the data insertion program to insert data into the blockchain based on the target non-relational data.

[0102] In some possible implementations, the device further includes a display module, and the display module is specifically configured to:

[0103] The update result of the local database is displayed to the user.

[0104] The present application provides a device for implementing a data processing method. The device includes a processor and a memory. The processor and the memory communicate with each other. The processor is used to execute instructions stored in the memory so that the device executes the data processing method.

[0105] The present application provides a computer-readable storage medium, wherein instructions are stored in the computer-readable storage medium, and when the computer-readable storage medium is run on a device, the device executes the above-mentioned data processing method.

[0106] The present application provides a computer program product including instructions, which, when executed on a device, enables the device to execute the above-mentioned data processing method.

[0107] It should also be noted that the device embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed over multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, in the drawings of the device embodiments provided by the present application, the connection relationship between the modules indicates that there is a communication connection between them, which may be specifically implemented as one or more communication buses or signal lines.

[0108] Through the description of the above implementation mode, the technicians in the field can clearly understand that the present application can be implemented by means of software plus necessary general hardware, and of course, it can also be implemented by special hardware including special integrated circuits, special CPUs, special memories, special components, etc. In general, all functions completed by computer programs can be easily implemented by corresponding hardware, and the specific hardware structure used to implement the same function can also be various, such as analog circuits, digital circuits or special circuits. However, for the present application, software program implementation is a better implementation mode in more cases. Based on such an understanding, the technical solution of the present application is essentially or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a readable storage medium, such as a computer floppy disk, a U disk, a mobile hard disk, a ROM, a RAM, a disk or an optical disk, etc., including a number of instructions to enable a computer device (which can be a personal computer, a training device, or a network device, etc.) to execute the methods described in each embodiment of the present application.

[0109] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product.

[0110] The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from a website site, a computer, a training device, or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, training device, or data center. The computer-readable storage medium may be any available medium that a computer can store or a data storage device such as a training device, a data center, etc. that includes one or more available media integrations. The available medium may be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state drive (SSD)), etc.

[0111] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A data processing method, characterized in that: The method comprises: The first primary key field data and the second primary key field data of the relational data to be processed are connected by characters to obtain the key field data of the target non-relational data; According to the type of the target data operation, the target data operation program is called to perform the target data operation on the blockchain based on the target non-relational data; According to the data operation result returned by the target data operation program, the local database is updated, and the local database is a relational database.

2. The method according to claim 1, characterized in that The type of the target data operation is inserting data, and the method further includes: The remaining field data of the relational data to be processed is used as the value field data of the target non-relational data.

3. The method according to claim 1, characterized in that The type of the target data operation is deleting data, and the method further includes: The value field data of the target non-relational data is marked as deleted.

4. The method according to claim 1, characterized in that: The type of the target data operation is query data, and the calling of the target data operation program performs the target data operation on the blockchain based on the target non-relational data, including: Call the data query program to query the data in the blockchain based on all or part of the field data in the key field data of the target non-relational data as the query condition.

5. The method according to claim 1, characterized in that The type of the target data operation is to modify data, the relational data to be processed includes modified non-primary key data, the key field data of the target non-relational data is not modified, and the method further includes: The modified non-primary key data in the to-be-processed relational data is used as value field data of the target non-relational data.

6. The method according to claim 1, characterized in that The type of the target data operation is to modify data, the relational data to be processed includes modified primary key data, the key field data of the target non-relational data is modified, and the method further includes: Get unmodified non-relational data; The calling of the target data operation program to perform the target data operation on the blockchain based on the target non-relational data includes: Calling a data deletion program to perform a data deletion operation on the blockchain based on the unmodified non-relational data; Call the data insertion program to insert data into the blockchain based on the target non-relational data.

7. The method according to any one of claims 1 to 6, characterized in that The method further comprises: The update result of the local database is displayed to the user.

8. A data processing device, characterized in that: The device comprises: The first processing module is used to obtain the key field data of the target non-relational data by character concatenation of the first primary key field data and the second primary key field data of the relational data to be processed; A second processing module is used to call a target data operation program according to the type of the target data operation, and perform the target data operation on the blockchain based on the target non-relational data; The updating module is used to update the local database according to the data operation result returned by the target data operation program, and the local database is a relational database.

9. A computer device, characterized in that: The computer equipment comprises: Memory for storing computer programs or computer instructions; A processor, configured to execute a computer program or computer instruction stored in the memory, so that the computer device executes the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store a computer program, and when the computer program is executed, it is used to implement the method according to any one of claims 1 to 7.

Images