An Efficient Data Warehouse for Crop Yield Prediction
|Title:||An Efficient Data Warehouse for Crop Yield Prediction||Authors:||Ngo, Vuong M.
|Permanent link:||http://hdl.handle.net/10197/10118||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 warehouse; Constellation schema; Crop yield prediction; Precision agriculture||Other versions:||https://www.ispag.org/icpa||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
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.