基于异构数据集成技术的农业信息综合管理网络平台开发

针对中国当前农业无线监测中农业信息化标准尚未建立,监测终端各不相同,监测系统数据结构兼容性差的问题,该文围绕异构数据规范化设计和管理,开发了面向差异化农业信息监测终端的一体化网络平台。根据异构网络数据特点,将不同监测终端上传的数据格式标准化;基于XML(extensible markup language)和Visual Basic 6.0开发了标准化网管数据接口,将不同终端数据按照通讯协议的标准格式解析、存储数据;基于PHP、My SQL数据库和服务器及网站网页技术设计并搭建了远程监测平台。利用开沟机监测终端进行田间试验,监测耕深和跟踪机具,试验表明:网管数据接口能实时接收并正确解析终端数据;监测平台可实现远程数据的曲线显示、数据导出和控制终端的远程控制、轨迹绘制的功能;通过导出数据的轨迹和平台显示轨迹对比,轨迹精确。该研究解决了监测系统异构数据及终端硬件差异问题,把单机测控应用扩展至广域网,可应用于农机信息的远程实时监测和远程控制,对现代化农业信息化共享有着重要作用。

Development of integrated network platform for heterogeneous agricultural information remote monitoring terminal

Abstract: Because of lack of agriculture informatization standard in Chinese agricultural wireless monitoring, variability of monitoring terminals and weak compatibility of monitoring system data structure, this research focused on standard design and management of heterogeneous data and developed integrated network platform for heterogeneous agricultural information remote monitoring systems. The establishment of integrated network platform was mainly on account of the following points. Firstly, communication protocol for collected data was carried out to standardize data formats of different monitoring terminals in view of data characteristics of heterogeneous network. Secondly, standardized data management interface was set up based on XML (extensible markup language) and VB (Visual Basic) 6.0. could parse data and store data from different monitoring terminals according to standard format of communication protocol. Thirdly, remote-monitoring platform was designed and built on the basis of PHP (hypertext preprocessor) language, MySQL (microsoft structure quest language) database, as well as server and website technology. Monitoring system consists of 3 parts: information monitoring terminals, data interface and network platform. Information monitoring terminals collect information of sensors and process original data preliminarily. In the meantime, monitoring terminals are supposed to integrate data according to communication protocol and send data to server. Data management interface is the core of concentrated processing of monitoring data and heterogeneous network data interaction. It is the bridge between monitoring terminals and server database and is tied to communication server. Moreover, its main task is to parse data and transform data by formulas from XML file. Network platform is used to display data and import some setting information. It is a connection channel between monitoring system and clients. Field test was conducted in Yanqing County, Beijing on May 18th, 2016. The test utilized trench depth and position during operation of trencher as monitoring targets. The purpose of test is to verify whether the accuracy of collected data and real-time capacity of data transmission can meet the requirement. In the field test, monitoring terminal collected original data from sensors and integrated data according to the standard format of communication protocol after preliminary treatment. Angle difference and longitude and latitude data were taken as channel data and sent to server interface. Angle difference was channel data monitored, whereas data that needed to be displayed was trench depth. As a result, angle difference needed to be transformed to trench depth by their correlation. The correlation was written to XML file in the form of formula. Data management interface parsed data, calculated trench depth through the formula and stored processed channel data to corresponding sheet in MySQL database. Network platform could invoke trench depth, longitude and latitude in the database. Trench depth could be displayed by means of graphs and tables and from graphs and tables it could be exported to Excel. Longitude and latitude were used to track trencher from platform. The test showed that data management interface could receive and parse data from monitoring terminal in real time, platform could display monitoring data accurately and position track was precise. We can conclude that this research solves problems on heterogeneous network and terminal hardware difference of monitoring system and realizes remote real-time monitoring and remote control of agricultural machinery information.