Study On The Construction Of Agricultural Resource Information Database In Anhui State Farmland Group

Agricultural resources are the basis of material on agricultural production. In order to merge the overall planning of regional economic, PuJiWei farmland of Anhui Province state farms group bring its dominant position of natural and social resources into full play. Use the role of demonstration and guide on agricultural technology exert a beneficial influence in local and surrounding areas. Even form mainstay of specialty in larger area, for leading regional economic development. PuJiWei farmland has accumulated large amounts of agricultural resources data in daily agricultural production and business activities. Use these data to establish an agricultural resource database with full-scale, open, advanced and efficient. Not only can improve the use efficiency of agricultural production, but also reduce the environmental pollution caused by over-production. At the same time create a convenient database also can provide information support and decision-making support for other agricultural resources development with exploitation and utilization,assessment and planning. To create an agricultural resources database is an essential part in the modern agricultural production.This paper was to analyze and study the features of PuJiWei farmland's agricultural resources. Then, from the needs analysis, conceptual design and logical structure, following the common approach to the study of a database, we have done some research and device work to the targeted area. With the aid of Visual Studio 2008, we also have worked out some interrelated program, which can be used to identify a user, input and output data, check in statistics, and so can be an aid to make decisions. According to classification of related data and coding standard, the study designed and built Agricultural Resources database, including soil resources, water resources, climate resources, fertilizers information etc, and tested the key parts of the above agricultural resources in these tables: the survey of basic information in the sample lots, the survey of fertilizer-using, the results of soil test. Furthermore, the study also devised metadata and data dictionary, which have some connection with the agricultural resources database.This database would have some practical significance to management efficiency and rational use of agricultural resources and the efficiency improvement of the traditional agricultural resource management significance, Can provide decision-making information to the Administrator on how to achieve the farm intensification of agricultural production, the combination of large-scale economic and social benefits, and can be a foundation for the realization of agricultural resources data exchange and sharing either between different countries or between different regions. It may lay the groundwork for the implementation of the precision prerequisites agriculture, too. On the whole, It can be used as a practical tool both to the effective management of agricultural resources and resource use as for decision support.