Block chain data storage and query method, device and equipment and storage medium

Abstract

The invention relates to the field of block chains, in particular to the field of block structure improvement, and discloses block chain data storage and query method, device and equipment and a storage medium. The block chain data storage and query method comprises the steps: generating an index database; obtaining a target structured query language (SQL) statement, wherein the target SQL statement is a legal statement conforming to an SQL grammar rule; analyzing the target SQL statement according to a preset algorithm to obtain an abstract syntax tree; generating a logic execution plan according to the abstract syntax tree, wherein the logic execution plan comprises a data insertion plan, a data modification plan and a data query plan; and performing read-write operation on the block chain distributed database according to the logic generation plan and the index database to obtain a read-write result, the block chain distributed database being used for storing and querying data. By packaging the block chain bottom layer interface, the block chain data storage and query method uses the SQL statements and the index database to achieve data chaining storage and query, can lower thedevelopment threshold, and can improve the retrieval and development efficiency.

Description

technical field [0001] The invention relates to the field of block structure improvement, in particular to a block chain data storage and query method, device, equipment and storage medium. Background technique [0002] Blockchain (block chain, BC) is an intelligent peer-to-peer network that uses distributed databases to identify, disseminate and record information, also known as the value Internet. Blockchain is essentially a decentralized database. Blockchain Contains a list called blocks, with continuously growing and neatly arranged records. Each block contains a timestamp and a link to the previous block. The blockchain makes the data immutable. Once recorded, the data in a block is irreversible. [0003] Blockchain distributed storage data is of key-value type. Although the bottom layer of blockchain technology also provides interfaces for data operations, these interfaces are relatively simple, and the transaction information stored in the block is basically in the f...

AI Technical Summary

Problems solved by technology

[0005] The main purpose of the present invention is to solve the problem of insufficient support of blockchain for complex queries and low retrieval efficiency. At the same time, it solves the problem of modifying data storage from a relational database to a blockchain distributed database, which requires rewriting data query and storage logic codes , leading to the problems of heavy development workload, long time-consuming and low development efficiency

Images