Database Design for IoT-based Greenhouse Systems

Since 2000s, proper utilization of IoT (Internet of Things) technology is a key factor for a firm to become more competitive, and this stream is not exceptional for the food and agriculture industry. Along with this stream, Korea government organization, for example MAFRA (Ministry of Agriculture, Food and Rural Affairs), elected to adopt IoT technology, such as USN and RFID technologies, in the food and agriculture industry. Based on the IoT technology, MAFARA launched six "IoT based farm" project in 2007. IoT based farm project includes IoT based greenhouse system project, and it shows drastic efficiency in terms of cost reduction. When it comes to the productivity, however, the effect of IoT based greenhouse system is still ambiguous. In this regard, this study conducted systems analysis and design for IoT based tomato greenhouse in order to help farmers' decision making related to the productivity by establishing standardized database structure and designing output form to analyze productivity indices. Proposed systems analysis and design can be utilized as a data analysis tools by farmers. Productivity data from the proposed systems is can be used by researchers to identify the relationship among environment, plant growth and productivity. Policy makers also can refer to the data and output forms to predict the quantity of fruit during certain period and to revise production guideline more precisely.