Visual FoxPro 9.0数据库管理系统在烟气分析中的扩展应用
Extended Application of Visual FoxPro 9.0 Database Management System to Tobacco Smoke Analysis
-
摘要: 为提高烟气分析过程数据处理的准确性和高效性,开发了基于Visual FoxPro 9.0数据采集管理系统。该系统采用RS232串行接口通信技术连接PC机与多台吸烟机,实现对RM200吸烟机的远程操作控制和数据采集;采用以太网通信技术远程访问和采集RM200A吸烟机和气相色谱仪数据;编制数据管理功能模块,实现对检测数据、过程数据、产品信息的管理和应用。应用效果表明,VFP 9.0数据库管理系统应用于烟气分析实验室,能够采集不同类型吸烟机和气相色谱的检测数据,并将过程数据汇集到VPF数据库平台上,数据处理流程实现了程序化、标准化,避免了人为错误,提高了工作效率和检测报告的准确性。Abstract: To improve the accuracy and efficiency of data processing in the process of tobacco smoke analysis, a data acquisition and management system was developed based on Visual FoxPro 9.0 database management system, wherein RS232 serial interface communication technology was used to connect PC with a number of smoking machines and perform remote control of and data acquisition from RM200 smoking machines, and Ethernet communication technology was used to remotely access and collect data from RM200A smoking machines and gas chromatograph. By programming data management module, the management and application of test data, process data and product information were carried out. The results of application in tobacco smoke analysis laboratory showed that the developed management system could collect test data from smoking machines and gas chromatograph of different types and converge process data on the VFP database platform, and the data processing flow was fully programmed and standardized. Possible errors caused by manual operations were avoided, work efficiency and the accuracy of test report were improved.
下载: