Development of Data Management Software for Torpedo Power Test
-
摘要: 目前国内外的数据分析系统基本上都是利用文件夹来存储测试数据, 数据管理方式落后、采集设置和分析调取耗时费力。为了解决以文件夹管理数据的弊端并提高采集分析软件各功能模块之间的信息交互性, 文中采用Access结合LabVIEW设计开发出一套鱼雷动力试验数据管理软件。在Access中设计了数据库模型及各个数据表之间的关系, 在LabVIEW中开发了数据库维护工具、数据库与各功能模块的接口程序, 实现了对数据库中各表的查询、修改、删除及数据的导入导出。该软件极大地提高了鱼雷动力试验数据的管理效率和水平。Abstract: At present, data analysis systems usually use folder to store test data, but this manner is insufficient for data management and spends more time in data acquisition, analysis and access. Therefore, a data management software for torpedo power test is developed based on LabVIEW and Access to improve information interaction among modules in the acquisition and analysis software. In Access a database model and the relationship among datasheets are designed, and in LabVIEW database maintenance tool and interface program between database and function modules are developed. Thus query, modification, deletion, and data input/output operations on datasheets are implemented with higher efficiency.
-
Key words:
- torpedo power test /
- database /
- data management /
- LabVIEW /
- Access
-
[1] 刘立辉, 孟庆鑫. 基于动态链接库的复杂信息系统分层框架设计[J]. 计算机与信息技术, 2009(5): 39-45.Liu Li-Hui, Meng Qing-Xin. Designing of the Complete Layered Information System Based on LabVIEW[J]. Computer & Information Technology, 2009(5): 39-45. [2] 孙炜强, 王德明, 马义平. LabVIEW与数据库在柱状静态参数测量系统中的应用[J]. 仪表技术, 2014(10): 47-54.Sun Wei-Qiang, Wang De-Ming, Ma Yi-Ping. Application of LabVIEW and Database in Static Parameter Measurement System of Columnar Parts[J]. Instrumentation Technology, 2014(10): 47-54. [3] 熊宗接, 毕鹏. 利用数据库在LabVIEW中实现自动测试[J]. 国外电子测量技术, 2007, 26(8): 56-59.Xiong Zong-Jie, Bi Peng. Auto Test in the LabVIEW Environment by Using Data Base[J]. Foreign Electronic Measurement Technology, 2007, 26(8): 56-59. [4] 张捍东, 纪文志. 数据采集系统中的LabVIEW数据库访问技术[J]. 工业仪表与自动化装置, 2009(4): 63-66.Zhang Han-Dong, Ji Wen-Zhi. The Database Access Technology Based on LabVIEW in Data Acquisition System[J]. Industrial Instrumentation & Automation, 2009(4): 63-66. [5] 吴刚, 施建礼, 焦吉祥. 基于LabSQL的故障诊断系统研究[J]. 机床与液压, 2013, 41(17): 183-187.Wu Gang, Shi Jian-Li, Jiao Ji-Xiang. Study on Fault Diagnose System Based on LabSQL[J]. Machine Tool & Hydraulics, 2013, 41(17): 183-187. [6] 陈树学, 刘萱. LabVIEW宝典[M]. 北京: 电子工业出版社, 2011. [7] 查志武, 史小锋, 钱志博. 鱼雷热动力技术[M]. 北京: 国防工业出版社, 2006. [8] 李江伟, 汪锐, 汪仁煌, 等. 基于Labview的便携式大型旋转机械故障诊断系统的数据管理[J]. 自动化仪表, 2001, 22(8): 12-14.Li Jiang-Wei, Wang Rui, Wang Ren-Huang, et al. The Labview Based Portable Data Management for Fault Diagnosis System of Large Rotating Machines[J]. Process Automation Instrumentation, 2001, 22(8): 12-14. [9] 丰伟伟, 杨世文, 南金瑞, 等. 基于LABVIEW中TDMS文件和SQL数据库数据处理速度的研究[J]. 仪器仪表与分析检测, 2011(1): 10-12.Feng Wei-Wei, Yang Shi-Wen, Nan Jin-Rui, et al. The Data Processing Speed Research of TDMS File and SQL Database in LabVIEW[J]. Instrumentation Analysis Monitoring, 2011(1): 10-12. [10] 张鹏, 赵剡, 基于LabVIEW的位标器性能测试系统[J]. 计量与测试系统, 2011, 38(1): 60-64.Zhang Peng, Zhao Yan. Coordinator Performance Testing System Base on LabVIEW[J]. Metrology & Measurement Technique, 2011, 38(1): 60-64. [11] 刘有耀, 李彬. 基于Hadoop的测试数据处理系统设计与实现[J]. 计算机技术与应用, 2015, 41(7): 140-143.Liu You-Yao, Li Bin. The Design and Implementation of Test Data Processing System Based on Hadoop[J]. Application of Electronic Technique, 2015, 41(7): 140-143.
点击查看大图
计量
- 文章访问数: 1219
- HTML全文浏览量: 2
- PDF下载量: 449
- 被引次数: 0