LabVIEW访问Oracle数据库在MES中的应用  

Application of LabVIEW Access Oracle Database in MES

作　　者：郭全民[1] 李东[1] 王健[1] 

机构地区：[1]西安工业大学电子信息工程学院,西安710021

出　　处：《微处理机》2016年第1期28-31,共4页Microprocessors

摘　　要：通过放大变换测试系统,研究如何将产品测试信息上传到数据库中,实现产品信息的查阅及测试指令的下达。通过结合使用Lab VIEW[1]和现场制造执行系统(MES)实现的对被测产品的数据采集和数据上传,并将测试数据保存到Oracle数据库中。通过使用Lab VIEW中的Database工具包,了解如何使用简单的SQL语言实现对Oracle数据库中数据的操作及与Oracle数据库的连接。通过局域网实现对Oracle数据库中被测产品指令的下达以及被测数据的插入、更新、删除等操作,从而实现对被测产品的远程监控[2]。最终使用Lab VIEW软件编写操作界面实现对被测系统的控制。By enlarging transform test system,this paper studies how to upload product test information to the database to access to the information of products and give a testing instruction. Combining with LabVIEW and manufacturing execution system (MES ),the data of collection and uploading dynamically are realized and saved in the Oracle database.By means of the Database in the LabVIEW,a simple SQL language is used for operating the Oracle data in the Database and connecting the Oracle Database.Through the local area network (LAN),the instructions of the tested products in Oracle database and the operations such as date insertion,data update and data deleting are conducted to realize the remote controlling of the products tested.Finally,the operation interface is written to control the tested system by LabVIEW software.

关 键 词：虚拟仪器 制造执行系统 ORACLE数据库 数据采集 测试系统 

分 类 号：TP274[自动化与计算机技术—检测技术与自动化装置]