面向火箭数据分析和故障诊断的数据仓库设计  

Design of Data Warehouse for Rocket Data Analysis and Fault Diagnosis

作　　者：陈卓 汪灏 平佳伟 邓闯 彭炳峰 徐昕 CHEN Zhuo;WANG Hao;PING Jiawei;DENG Chuang;Peng Bingfeng;XU Xin(Shanghai Aerospace Electronic Technology Institute,Shanghai 201109,China;School of Computer,Shanghai Jiao Tong University,Shanghai 200240,China;Aerospace System Engineering Shanghai,Shanghai 201109,China;School of Astronautics,Nanjing University of Aeronautics and Astronautics,Nanjing 210016,China)

机构地区：[1]上海航天电子技术研究所,上海201109 [2]上海交通大学计算机科学与工程系,上海200240 [3]上海宇航系统工程研究所,上海201109 [4]南京航空航天大学航天学院,南京210016

出　　处：《计算机测量与控制》2024年第1期51-56,共6页Computer Measurement &Control

摘　　要：针对运载火箭测试发射数据分散存储且数据利用不充分的问题,提出了以数据仓库技术对火箭的测试发射数据进行组织和存储管理,实现对火箭数据价值的深层次发掘;根据运载火箭数据的特点,提出了数据仓库基础层、源数据层、数据交互层、数据架构层、应用层、显示层6个层次的框架设计;通过面向火箭数据分析和故障诊断的数据清洗规则设计,对不同来源、不同格式的数据进行清洗和加载;对火箭的数据应用方向进行了探索,设计了包络分析、相关性分析、故障诊断等数据分析模块;用某型号火箭测试发射数据进行了验证,结果表明,数据仓库方案切实可行,为后续火箭数据的持续性管理和分析奠定了基础。In response to the problems of decentralized management and insufficient utilization of launch data for rocket testing,a data warehouse technology is proposed to organize and store the test and launch data of rockets,achieving the deep exploration of the rocket data.According to the characteristics of the carrier rocket data,it proposes six levels of framework design such as the data warehouse foundation layer,source data layer,data interaction layer,data architecture layer,application layer,and display layer;The different sources and format data are cleaned and loaded by the data cleaning rule design for the rocket data analysis and fault diagnosis;The direction of rocket data application is explored,which designs data analysis modules such as the envelope analysis,correlation analysis,and fault diagnosis.The validation is conducted using launch data from a certain type of rocket,and the results show that the data warehouse solution is feasible,and it provides a foundation for the continuous management and analysis of the rocket data in the future.

关 键 词：数据仓库 运载火箭 结构化数据 数据清洗 故障诊断 

分 类 号：V475.1[航空宇航科学与技术—飞行器设计]