An Optimization Method for Blockchain Electronic Transaction Queries Based on Indexing Technology

Due to the advantages of non-tampering, non-forgery and anonymity of blockchain, it is gradually being used in electronic trading systems. However, there is a problem of low efficiency of querying historical information in the traditional blockchain electronic transaction system, which cannot meet the user’s basic query needs. To better solve this problem, we propose an index-based blockchain electric transaction query scheme in this paper. We construct the index directory of the BKV (B-Key-Value) Tree storage structure by modifying the storage of the B-tree, and based on the BKV tree, we store the transaction order number and the corresponding block number in form of key-value pairs by combining the characteristics of the blockchain system. At the same time, we also design the blockchain structure and query algorithm based on the BKV index directory. Theory and experiments show that the index-based blockchain electrical transaction query scheme can reduce the electrical transaction query time, thus effectively improve the efficiency of the electrical transaction query and improve the user’ experience with the blockchain electronic trading system.