FlyDB: Query Optimization of Blockchain System Based on Hybrid Storage Architecture

The hybrid storage architecture incorporates a blockchain dual-index structure optimized for byte addressing in non-volatile memory, low-latency features, and the large capacity of SSD. This paper presents a novel LSM-Tree architecture that leverages the byte-addressing characteristics of non-volatile memory. The layers of the level 0 and level 1 are stored in non-volatile memory while employing a local key-value separation strategy to minimize read and write operations during compaction. A logic compression strategy is proposed to handle data compression tasks efficiently. A dual-index structure design is introduced for users to address the scope and multi-keyword queries in the blockchain system. During the compression process, keyword switching occurs during data reordering, ensuring that data within the same SSTable is rearranged according to user preferences. By effectively harnessing the advantages of each level in the hybrid storage architecture, this design significantly reduces both databases write time and the response time for complex queries.