A PDA-based record-keeping and decision-support system for traceability in cucumber production

For the small-scale and scattered fresh cucumber production in China, the result that production record-keeping and its transfer are inefficient have prevented the wide application of traceability systems in China. With the mobility and computability, Personal Digital Assistant (PDA) provides a new way for agricultural information collection to solve the above problems. Thus a PDA-based Record-keeping and Decision-support System (PRDS) for traceability in cucumber production was developed on Windows Mobile platform invoking a Geographic Information System (GIS) control. For improving the decision making feasibility of PRDS, the fertilization recommendation model and pesticide usage early warning model were developed by using the Technical Specification of Balanced Fertilization by Soil Testing and the Guideline for Safety Application of Pesticides in China. The architecture of PRDS was provided. With Unified Modeling Language (UML), a requirement model including two types of users and 17 use cases was described, and a static class model was also designed, which consisted of table class, table operation class, algorithm class and interface class. Based on these models, the functions of system setup, map management, data management, production record-keeping and decision-support and query, etc., were implemented by adopting Hosting MapInfo MapX Mobile Controls on the .NET Compact Framework 2.0, and the data synchronization was realized by Remote Data Access (RDA). Two agricultural production enterprises were chosen as case study to evaluate the system by questionnaires. The results show that the efficiency of production record-keeping and decision-support is improved by the simple and friendly system. (C) 2009 Elsevier B.V. All rights reserved.