基于LabVIEW的数据库访问技术在测试系统中的应用  

Application of database access technology based on LabVIEW in test system

作　　者：才旺 尹明德[1] 肖杰 王立成 杨明 CAI Wang;YIN Mingde;XIAO Jie;WANG Licheng;YANG Ming(Nanjing University of Aeronautics and Astronautics, Nanjing 210016, China;Nanjing Shengjie International Manufacting CO. , INC, Nanjing 211221, China)

机构地区：[1]南京航空航天大学机电学院,南京210016 [2]南京胜捷电机制造有限公司,南京211221

出　　处：《工业仪表与自动化装置》2020年第4期77-80,共4页Industrial Instrumentation & Automation

摘　　要：该文介绍了冷却风机在性能试验过程中需要采集的测量参数,并提出了基于Access数据库的试验数据管理系统。该试验数据管理系统以LabVIEW编程软件和LabSQL工具包为基础,通过数据库访问技术,实现对冷却风机性能试验数据的存储和管理。数据库的连接方式采用DSN连接,对数据库操作的执行程序基于SQL语句进行编写。通过将该方法应用于测试系统,实现了新建表、数据写入、数据读取、数据删除等功能。结果表明,通过LabSQL进行数据库访问可以有效提升试验数据存储和查询的效率,使试验数据管理更加便捷。The measurement parameters needed to be collected during the performance test of the cooling fan are introduced,and a test data management system based on the Access database is proposed.The test data management system is based on LabVIEW programming software and LabSQL toolkit,and uses database access technology to realize the storage and management of cooling fan performance test data.The database connection method uses DSN connection,and the execution program for database operations is written based on SQL statements.By applying this method to a test system,functions such as creating a new table,writing data,reading data,and deleting data are implemented.The results show that database access through LabSQL can effectively improve the efficiency of test data storage and query,and make the management of test data more convenient.

关 键 词：数据库 数据存储 LABVIEW LABSQL 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]