The Database Design Of Xinjiang Production And Construction Corps Cotton-picking Machine Monitoring Dispatching Service System

With the deepening development of Modern Agricultural mechanization and thestrengthening efforts of Corps to promote cotton picker machine, cotton picker will increase dayby day. onboard monitoring terminal for cotton-picking machine operation location informationautomatically and state data real-time acquisition and monitoring of cotton in xinjiang productionand construction corps mining machine scheduling scheduling management service system,involved in the system of large amount of data, data, many kinds, and they need to operation datastatistics processing, storage, call, such as server database design system, to provide scientific,intelligent cotton-picking machine company means of monitoring and management.According to the Xinjiang cotton picker traditional operation management mode, based onthe background of Xinjiang western Yin Li cotton picker machine company, on the basis of thecotton picker’s working processes and company’s internal management, this paper combined withGIS software and computer software designed a cotton picker machine monitoring anddispatching service system database，to achieve another efficient and convenient management ofthe cotton picker. The main contents are as follows:1.Based database design shall be carried out in accordance with the basic theory of relationaldatabase design, including concept design、logical design and physical database design, databasesystem consists of two layers of C/S architecture, the client program development based on.netplatform, using C#language to realize the database through ADO connection and application,complete the. Net platform to the database storage and management operation, realize thecotton-picking machine information management, project management, personnel management,order management, driver management, fuel management, track playback, operation data statisticsanalysis, etc, and analyze the cotton-picking machine efficiency, completed the cotton-pickingmachine monitoring management.2.Spatial database design, the graph background in remote sensing image data, at theinterface of ArcGIS demonstration zone round field plots of farmland, field road of the spatial dataacquisition, processing, by adding the fields in the storage of attribute data in the table to extendthe farmland property sheet roads, realization of spatial data storage integrity, using MapInfosoftware to complete the road vector quantization process, writing applications using MAPXcontrol demonstration data mapping and visualization space, meet the demand for cotton-pickingmachine operation location service.3.Client system combining the development of relational database and spatial database, andto achieve job management query and cotton-picking machine monitoring scheduling services,focus on monitoring accuracy, improve cotton-picking machine operation convenient equipmentmaintenance work; Establishing demonstration zone round field field road, MapInfo map path forcotton-picking machine field job scheduling services guide, improve working efficiency.When the database system application achieved, it using the SQL Server2005databaseproduct for functional verification, the database can basically meet the needs of cotton pickeroperations， verified the correctness of the database on the cotton picker with the actual jobinformation management application effect.