An Efficient Data Warehouse for Crop Yield Prediction

Files in This Item:
File Description SizeFormat 
1807.00035v1.pdf585.6 kBAdobe PDFDownload
Title: An Efficient Data Warehouse for Crop Yield Prediction
Authors: Ngo, Vuong M.
Le-Khac, Nhien-An
Kechadi, M-Tahar
Permanent link:
Date: 27-Jun-2018
Online since: 2019-04-24T10:45:04Z
Abstract: Nowadays, precision agriculture combined with modern information and communications technologies, is becoming more common in agricultural activities such as automated irrigation systems, precision planting, variable rate applications of nutrients and pesticides, and agricultural decision support systems. In the latter, crop management data analysis, based on machine learning and data mining, focuses mainly on how to efficiently forecast and improve crop yield. In recent years, raw and semi-processed agricultural data are usually collected using sensors, robots, satellites, weather stations, farm equipment, farmers and agribusinesses while the Internet of Things (IoT) should deliver the promise of wirelessly connecting objects and devices in the agricultural ecosystem. Agricultural data typically captures information about farming entities and operations. Every farming entity encapsulates an individual farming concept, such as field, crop, seed, soil, temperature, humidity, pest, and weed. Agricultural datasets are spatial, temporal, complex, heterogeneous, non-standardized, and very large. In particular, agricultural data is considered as Big Data in terms of volume, variety, velocity and veracity. Designing and developing a data warehouse for precision agriculture is a key foundation for establishing a crop intelligence platform, which will enable resource efficient agronomy decision making and recommendations. Some of the requirements for such an agricultural data warehouse are privacy, security, and real-time access among its stakeholders (e.g., farmers, farm equipment manufacturers, agribusinesses, co-operative societies, customers and possibly Government agencies). However, currently there are very few reports in the literature that focus on the design of efficient data warehouses with the view of enabling Agricultural Big Data analysis and data mining. In this paper, we propose a system architecture and a database schema for designing and implementing a continental level data warehouse. Besides, some major challenges and agriculture dimensions are also reviewed and analysed.
Funding Details: Science Foundation Ireland
Type of material: Conference Publication
Publisher: ISPA
Keywords: Data warehouseConstellation schemaCrop yield predictionPrecision agriculture
Other versions:
Language: en
Status of Item: Not peer reviewed
Is part of: Proceedings of the 14th International Conference on Precision Agriculture
Conference Details: The 14th International Conference on Precision Agriculture, Montreal, Canada, 24-27 June 2018
Appears in Collections:Computer Science Research Collection

Show full item record

Google ScholarTM


This item is available under the Attribution-NonCommercial-NoDerivs 3.0 Ireland. No item may be reproduced for commercial purposes. For other possible restrictions on use please refer to the publisher's URL where this is made available, or to notes contained in the item itself. Other terms may apply.