摘要
通过分析航天领域现有型号试验数据的特点,发现传统关系型数据库已不能满足日益激增的海量试验数据的存储与管理需求。针对现有试验数据量级大、写入吞吐低、访问效率差等特点,提出了一种基于时序数据库的试验数据存储管理方法。通过在传统关系型数据库与时序数据库中对型号试验数据的读写性能进行对比分析,发现基于时序数据库的数据写入与数据查询性能均明显优于关系型数据库,且具有快速存储、快速读取功能。将该方法应用于试验数据管理系统和数据处理显示与分析系统,能够满足系统对试验数据处理的实时写入、快速读取等需求。
The characteristics of existing project test data in the aerospace field are analyzed and then the results show that the traditional relational database can no longer meet the storage and management de⁃mands of ever⁃increasing massive test data.Aiming at the characteristics of large magnitude,low write throughput and poor access efficiency of existing test data,a test data storage management method based on time series database is proposed.By comparing and analyzing the reading and writing performance of aero⁃space project test data in traditional relational database and time series database,it is verified that the per⁃formance of data writing and data query based on time series database is obviously better than that of rela⁃tional database,and it has the capabilities of fast saving and fast accessing.This method is applied to test data management system and data processing display and analysis system,which can meet the requirements of real⁃time writing and fast reading of test data processing.
作者
曹雪君
姚娜
王天秀
童心
范景怡
CAO Xuejun;YAO Na;WANG Tianxiu;TONG Xin;FAN Jingyi(Beijing Aerospace Automatic Control Institute,Beijing 100854,China)
出处
《航天控制》
CSCD
2024年第1期51-57,共7页
Aerospace Control
关键词
时序数据库
试验数据
航天
Time series database
Test data
Aerospace
