Query Optimization Mechanism for Blockchain-Based Efficient Data Traceability

Efficient traceability query processing is of utmost importance in blockchain systems. However, existing methods suffer from efficiency challenges, necessitating immediate optimization. Prior research primarily focuses on introducing complex data structures to alleviate storage system burdens in scenarios with frequent traceability requests. Unfortunately, these optimizations impose a substantial maintenance burden on full nodes, making it challenging to strike a balance between traceability efficiency and resource consumption. Through an analysis of traceability query processing methods in existing blockchain full nodes, this paper proposes a novel optimization scheme based on a multilevel cache. This scheme replaces repetitive and inefficient disk I/O operations with efficient in-memory operations, thereby significantly enhancing the efficiency of traceability queries. Additionally, the multilevel cache structure minimizes the memory overhead associated with maintaining the cache in full nodes, achieving an optimal trade-off between traceability efficiency and resource consumption while alleviating the burden on full nodes. Experimental validation confirms the effectiveness of the proposed efficiency optimization scheme for traceability queries in full nodes. The results demonstrate its ability to enhance the overall performance of traceability query processing, contributing to improved efficiency and scalability in blockchain systems.