BI4IPM: A Business Intelligence System for the Analysis of Olive Tree's Integrated Pest Management

The Agri-Food sector is facing global challenges. The first challenge is feeding a world population that will reach 9.3 billion people in 2050, according to UN projections. The second challenge is the demand from consumers for high-quality products obtained through more sustainable, safe and clear agri-food chains. Integrated pest management (IPM) could be an important instrument for helping farmers face these challenges. IPM requires the simultaneous use of different crop protection techniques to control pests through an ecological and economic approach. This work explores the possibility of developing a framework that combines business intelligence (BI) technologies with IPM principles to support farmers in the decisional process, thereby decreasing environmental cost and improving production performance. The proposed BI system is called BI4IPM, and it combines on-line transaction processing (OLTP) with on-line analytical processing (OLAP) to verify adherence to the IPM technical specifications.