Smart terminals, with their portability and powerful computing capabilities, have been widely applied across various fields. They are particularly prevalent in new power systems, where they are extensively used for tasks such as equipment monitoring, data collection, and remote control. These application scenarios demand enhanced storage and data processing capabilities from databases. Given the increasingly complex deployment scenarios, smart terminals face challenges such as large data volumes, diverse data types, limited storage space, and constrained processing performance. Efficiently storing and processing large amounts of data under resource constraints has become a significant challenge. This paper investigates high-performance database storage technologies tailored for smart terminals and proposes an integrated database storage architecture and optimisation scheme that adapts to the characteristics of the smart terminal environment. We have developed a database framework specifically designed for the data processing characteristics of smart terminals, employing lightweight rule engine-based data cleaning techniques and the FVD-SDT algorithm-based data compression technology. Experimental results demonstrate that the proposed methods significantly improve storage space utilization and data processing efficiency, providing technical support for the application of smart terminals in new power systems, industrial IoT, and similar scenarios.