基于LabVIEW的钻井工程无线监控系统英文翻译

Wireless monitoring system for drillingengineering based on LabVIEWDaode Zhang1, Wan Xu2 , Cheng Xu3School of Mechanical Engineering, Hubei University of Technology, Wuhan, 430068Abstract：The system is a wireless monitoring system for drilling engineering. It isbased on LabVIEW and NI WSN. Compared with the conventional drillingmonitoring system, WSN has many advantages such as easy to deploy andstructure is flexible. Aiming at the NI wireless nodes, the paper introduces theprocess of network configurations. The modular design is adopted to realizesystem demo, data acquisition, data query and data alarming. The system iscompact in structure and the experiment shows that the system works in thestable condition.Key words：Drilling engineering Wireless monitor LabVIEW WSN Database1. System Survey In the course of exploitation for oil gas resources, drilling engineering is a link of vital importance. The system uses the wireless nodes to monitor the drilling site. As shown in figure 1,hardware system consists of two NI WSN-3202 analog quantities input Measurement node, one NI WSN-3212 thermocouple, and the Ethernet Gateway WSN-9791 based on IEEE802.15.4 protocol. Sensor is used to measure the liquid levels, determinations of hydrogen sulfide, SPP, temperature, hookheight and hook load. In software designing, we use LabVIEW 2010 to design the field client. The gateway and node were set by MAX. The data collected is transmitted to computer by the Ethernet. It put the collected data shown on the virtual instrument and Real-time curve through LabVIEW beautiful instrument interface and Variety of data display, and uses the collected data to Access database by applying LabSQL. And the software uses registered users event structure to give an alarm to overrun data.2. Hardware System Design2.1Ethernet gateway and the node Hardware system is characteristic of using NI WSN system, this makes wiring simple, conveniently , high reliability, it extremely suitable for oilfield engineering . In NI WSN system, Gateway is equivalent to a network coordinator, it is responsible for managing the node authentication, message buffer, and it build bridges between IEEE 802.15.4 wireless networks and Wired Ethernet networks. In the Ethernet network, you can use a variety of NI software to collection measuring data、 process 、analysis and display. The NI WSN-9791 etheric gateway is a transmission equipment, but it does not provide on-board storage functions and programming functions, and mainly used for coordinating communication between Distributed measuring node WSN-32xx and main controller. The gateway uses 2.4GHz, IEEE 802.15.4 protocol to Obtain measurement data from 10/100 Mb/s Ethernet port, it can connect Windows or LabVIEW real-time master controller flexibly. （see Figure 2） The NI WSN measurement node is characteristic of the sensors connected directly、reliable communications、industrial rating standard. Measurement nodes can be powered by batteries and last for 3 years It through WSN device driver to add gateway node LabVIEW to measuring system, and through the LabVIEW WSN modules graphical programming environment to formulate node behavior. The NI WSN-3202 analog quantity input and measurement nodes 4 10V analogue input channel and 4-way digital channels, The device provide 12V 20mA output power can directly driver sensor which need external power. NI WSN-3212 Thermocouple measurement node provides 4 roads 24 for the thermocouples input channel and digital channel 4 road two-way digital channels. It gen can directly connected J K R S etc thermocouples. 2.1 WSN network configurationIt through Measurement & Automation（MAX） make allocations to NI WSN system. Configuration process is as follows：1. Run max, Refresh remote system, locate wireless gateway node NI-WSN9791-0148AA02 2. System settings, set normal system, setting gateway node name, etc, and generally not be modified. 3. Network settings, Configuration gateway node IP, gateway, etc. In order to communicate with pc via Ethernet. 4. WSN Nodes, Used to add and delete wireless child nodes, need to enter the node type and ID, and can also update Internal firmware to set the to terminal nodes or routing nodes. 5. Gateway Firmware, Used to update firmware inside of the wireless gateway nodes. Configuration completed in WSN Nodes click refresh can see configured wireless Nodes. 3. Software System Design System software design is based on LabVIEW2010, system takes full advantage of LabVIEWs flexible expression of the data to give the data collected a visual display, and also use the Access database stores collection data. Software system architecture is shown in Figure 33.1 User ManagementUser management module, including adding users, view users, modify users and delete users. Its main advantages are as follows：It can effectively protect private data. It can protect the program itself. User management module uses the Access database to save user permissions、last login time、user name and password. As is shown in Figure 4, This module is the advantage is added user permissions and last login time, only administrators can add users , and administrators can view all user information .Normal users can only see the user information. Administrators can modify users permissions; normal users can only modify the users password. Administrators can delete other users, but normal users can only delete themselves. In no login, tab labels hidden. Select card and other buttons are disabled.3.2 System DemonstrationSystem demonstration module can clearly reflect the operation of all the system, and intuitive show operation process in the data of each control point .as is shown in Fig. 5.System demonstration animation uses custom controls. In fact it is composed by pictures drop-down list.3.3 Display and Save of Real-time DataThe analogue data of the system can be obtained directly through the I/O variables acquisition in the wireless nodes, as shown in figure 6. As required, the real-time acquisition data collected is being plotted into the fluctuations and save to Access data base. This module is similar to the waveform recorder which can report the trend of analog quantities in real-time and also has a data saving function. When waveform is on display, in order to show the waveform of the analog quantities in real-time, the waveform chart control should be adopted and the refreshing mode should be set as oscilloscope chart in the setting of waveform chart property. We should set the scale of the X axis as the absolute time in the system format 4. Also, the X scale offset should be set as current time in the property nodes of waveform chart. When the above conditions are fulfilled, X axis would be synchronic with the current time and the waveform chart would indicate the current wave of the gathering data by refreshing in real-time, as shown in figure 7. When stopping the new startup, the system needs to erase the data waveform of last operation. Therefore, it need initialize the waveform chart. That is to say, the historical data in the property nodes of waveform chart need to be initialized by using empty arrays. By the application of LabSQL toolkit, we insert and modify data for Access database to realize the data save. And the saving data includes serial numbers, time, liquid levels, determinations of hydrogen sulfide, etc. We use SQL statement INSERT to save the collected data to database. Taking the efficiency of making use of PCs storage space into account, the system only saves the last 48 hours data. When over capacity, we can use DELETE to delete the first data and UPDATE to update the last data.3.4 Data QueryThe data query of this system uses time inquires. And the queried data would be showed on the form and drawn into the historical data curves. When clicking the data query button, the dialog box would pop up and clew that inputting the time according to the certain format. As the storage formats of time in the database is 2011-04-22 00:49:00. In order to facilitate the users data query by entering a simple time format, the system involves the conversion of time format.3.5 Data AlarmAlarm subsystem is the significant part of all kinds of data acquisition, monitoring and virtual instrument system. The user would benefit from an alarm subsystem equipped with perfect functions in discovering, analyzing and processing problems timely 5. And registered event structure is used to realize the alarm subsystem. When the collected data goes beyond the upper limit or goes below the lower limit, it produces user events. Then, data alarm lamp begins to flicker. The alarm lamps flickering is actually a switch between the flashing prospects of Boolean display control and the TRUE color. In Tools Options Environment, we can modify the flashing prospects to red. Also, when changing the millisecond of flashing delay to 100 and the overrun data appears, the alarm lamp would flicker on the frequency of 100 milliseconds. When clicking on the shining alarm lamp, the alarm data record form can be checked. And the form would record the overrun data and the create time of overrun data. When clicking on the CLEANUP, the alarm data record form would be empty.4. ConclusionThe system is aimed at the scene of the oilfield drilling engineering data moni