利用LabVIEW SQL Toolkit对不同类型数据存取操作的方法研究

针对LabVIEW在与专业数据库的连接、数据存取等方面难于实现的问题,根据基于LabVIEW开发的测试系统对数据存取方面的实际需要,提出一种应用LabVIEW工具软件包LabVIEW SQL Toolkit快速实现与专业数据库SQL Server连接的方法,并将此方法应用于基于LabVIEW平台开发的滑动轴承磨损试验测试与监测系统中,实现了对数据库中不同类型数据,尤其是大型二进制数据的快速、有效存取。测试结果表明,此方法方便、高效,对在LabVIEW开发环境中需要访问数据库的程序设计者具有重要的借鉴意义。

Research on the Method of Realizing the Access Operations of Different Types of Data Using LabVIEW SQL Toolkit

Aiming at the deficiency of LabVIEW in connecting with a professional database and manipulating data difficultly,and according to the actual need of a LabVIEW test system in data accessing,a method used toolbox of LabVIEW-LabVIEW SQL Toolkit is applied to realize the fast link between LabVIEW and SQL Server.This method is used in the development of the wear test and monitoring system for sliding bearing based on LabVIEW to realize the storage and reading of different types of data from database,especially for rapid and effective access of the large binary data.Test shows that this method is convenient and efficient,provides important reference for the programmers who need access to the database in the development environment of LabVIEW.