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

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

作　　者：钱思思[1] 朱永生[1] 张优云[1] 闫玉平[1] 

机构地区：[1]西安交通大学现代设计及转子轴承系统教育部重点实验室,陕西西安710049

出　　处：《测控技术》2014年第9期105-109,共5页Measurement & Control Technology

基　　金：国家973计划项目(2011CB706606);国家自然科学基金重点基金资助(51035007)

摘　　要：针对LabVIEW在与专业数据库的连接、数据存取等方面难于实现的问题,根据基于LabVIEW开发的测试系统对数据存取方面的实际需要,提出一种应用LabVIEW工具软件包LabVIEW SQL Toolkit快速实现与专业数据库SQL Server连接的方法,并将此方法应用于基于LabVIEW平台开发的滑动轴承磨损试验测试与监测系统中,实现了对数据库中不同类型数据,尤其是大型二进制数据的快速、有效存取。测试结果表明,此方法方便、高效,对在LabVIEW开发环境中需要访问数据库的程序设计者具有重要的借鉴意义。Aiming at the deficiency of LabVIEW in connecting with a protesslonal database ano mamputaung 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 impor- tant reference for the programmers who need access to the database in the development environment of LabVIEW

关 键 词：LABVIEW 数据库 LABVIEW SQL TOOLKIT 

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