SQLite在飞艇监控中的应用与优化

为了提高飞艇测控中监视数据的管理水平,简化数据库操作的复杂度,提高数据存储和访问的速率,提出了在飞艇监控中使用轻量级数据库系统SQLite的方案。并针对监视系统中实时性要求高的特点,提出了四点SQLite性能优化策略,有效提高了SQLite数据库的访问速度。通过测试与连续试验表明,SQLite能够满足飞艇监控对数据实时存储及数据持久保存与管理的需求。该方案已经成功应用于某型号飞艇集成演示验证系统中。

Optimization and Application of SQLite in Monitoring and Control System of Airship

In order to improve data management in airship monitoring and control system,simplify the complexity in database operation,and improve the performance of data storage and access,the application of SQLite database in the monitoring and control system is introduced.According to the real time requirement, four optimization principles are proposed to improve the SQLite’s performance.The test and continuous ex-periment show that the SQLite database is a good substitute for commercial DBMS and can meet the data storage and management requirement in the airship monitoring and control system.This design is applied in a certain airship successfully.