OLAP Analysis of Integrated Pest Management’s Defense Rules: Application to Olive Crop in Apulia Region

  • Claudio ZazaEmail author
  • Sandro Bimonte
  • Crescenzio Gallo
  • Nicola Faccilongo
  • Piermichele La Sala
  • Francesco Contò
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10405)


The Agri-Food sector is facing global challenges. The first concerns feeding a world population that in 2050, according to UN projections, will reach 9.3 billion people. The second challenge is the request by consumers for high quality products obtained by more sustainable, safely and clear agri-food chains. The Integrated Pest Management (IPM) could be an important instrument to help farmers to face these challenges. The IPM requires the simultaneous use of different crop protection techniques for the control of pests through an ecological and economic approach. This work explores the possibility to develop a framework that combines the Information and Communication Technologies (ICTs) with the IPM principles, in order to support the farmers in the decisional process, improving environmental and production performances. The proposed ICT tool is On-Line Analytical Processing (OLAP), which allows performing analysis in the domain of time and space verifying for a single farm the respect of the IPM technical specifications.


Data warehouse OLAP Integrated Pest Management Olive crop 


  1. 1.
    Aktar, W., Sengupta, D., Chowdhury, A.: Impact of pesticides use in agriculture: their benefits and hazards. Interdisc. Toxicol. 2, 1–12 (2009)CrossRefGoogle Scholar
  2. 2.
    Barzman, M., Bàrberi, P., Birch, A.N.E., Boonekamp, P., Dachbrodt-Saaydeh, S., Graf, B., Hommel, B., Jensen, J.E., Kiss, J., Kudsk, P., Lamichhane, J.R., Messéan, A., Moonen, A.-C., Ratnadass, A., Ricci, P., Sarah, J.-L., Sattin, M.: Eight principles of integrated pest management. Agron. Sustain. Dev. 35, 1199–1215 (2015). doi: 10.1007/s13593-015-0327-9 CrossRefGoogle Scholar
  3. 3.
    Bimonte, S.: Current approaches, challenges, and perspectives on spatial OLAP for agri-environmental analysis. IJAEIS 7, 32–49 (2016)Google Scholar
  4. 4.
    Bimonte, S., Pradel, M., Boffety, D., Tailleur, A., André, G., Bzikha, R., Chanet, J.P.: A New sensor-based spatial OLAP architecture centered on an agricultural farm energy-use diagnosis tool. Int. J. Dec. Supp. Syst. Technol. 5, 1–20 (2013)CrossRefGoogle Scholar
  5. 5.
    Boulil, K., Bimonte, S., Pinet, F.: Conceptual model for spatial data cubes: A UML profile and its automatic implementation. Comput. Stand. Interfaces 38, 113–132 (2015)CrossRefGoogle Scholar
  6. 6.
    Chandler, D., Bailey, A.S., Tatchell, G.M., Davidson, G., Greaves, J., Grant, W.P.: The development, regulation and use of biopesticides for integrated pest management. Philos. Trans. Roy. Soc. Lond. B: Biol. Sci. 366, 1987–1998 (2011)CrossRefGoogle Scholar
  7. 7.
    Chaturvedi, K., Rai, A., Dubey, V., Malhotra, P.: On-line analytical processing in agriculture using multidimensional cubes. Int. Indian Soc. Agric. Stat. J. 62, 56–64 (2008)Google Scholar
  8. 8.
    Chaudhary, S., Sorathia, V., Laliwala, Z.: Architecture of sensor based agricultural information system for effective planning of farm activities. In: IEEE International Conference on Services Computing 2004, pp. 93–100 (2004)Google Scholar
  9. 9.
    de Olde, E.M., Oudshoorn, F.W., Bokkers, E.A., Stubsgaard, A., Sørensen, C.A., de Boer, I.J.: Assessing the sustainability performance of organic farms in Denmark. Sustainability 8, 957 (2016). doi: 10.3390/su8090957 CrossRefGoogle Scholar
  10. 10.
    Deytieux, V., Munier-Jolain, N., Caneill, J.: Assessing the sustainability of cropping systems in single-and multi-site studies. A review of methods. Eur. J. Agron. 72, 107–126 (2016)CrossRefGoogle Scholar
  11. 11.
    Dong, F., Mitchell, P.D., Colquhoun, J.: Measuring farm sustainability using data envelope analysis with principal components: the case of Wisconsin cranberry. J. Environ. Manage. 147, 175–183 (2015)CrossRefGoogle Scholar
  12. 12.
    European Parliament. Directive 2009/128/EC of the European Parliament and of the Council of 21 October 2009 establishing a framework for Community action to achieve the sustainable use of pesticides. Off. J. Eur. Union 309, 71–86 (2009)Google Scholar
  13. 13.
    Fountas, S., Carli, G., Sørensen, C.G., Tsiropoulos, Z., Cavalaris, C., Vatsanidou, A., Liakos, B., Canavari, M., Wiebensohn, J., Tisserye, B.: Farm management information systems: Current situation and future perspectives. Comput. Electron. Agric. 115, 40–50 (2015)CrossRefGoogle Scholar
  14. 14.
    Gallo, C., De Bonis, M., Perilli, M.: Data Warehouse Design and Management: Theory and Practice. Department of Economics, University of Foggia, Italy, Quaderno n. 07/2010, pp. 1–18 (2010).
  15. 15.
    Grunert, K.G.: Food quality and safety: consumer perception and demand. Eur. Rev. Agric. Econ. 32, 369–391 (2005)CrossRefGoogle Scholar
  16. 16.
    Gupta, A., Mazumdar, B.: Multidimensional schema for agricultural data warehouse. Int. J. Res. Eng. Technol. 2, 245–253 (2013)CrossRefGoogle Scholar
  17. 17.
    ISTAT. Italian Institute of Statics (ISTAT) Agricultural Census (2010). Accessed 20 Mar 2017
  18. 18.
    ISTAT. Italian Institute of Statics (ISTAT) “Superfici e Produzioni” (2016). Accessed 20 Mar 2017
  19. 19.
    Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. Wiley, New York (2013)Google Scholar
  20. 20.
    Langeveld, J.W.A., Verhagen, A., Neeteson, J.J., Van Keulen, H., Conijn, J.G., Schils, R.L.M., Oenema, J.: Evaluating farm performance using agri-environmental indicators: recent experiences for nitrogen management in The Netherlands. J. Environ. Manage. 82, 363–376 (2007). doi: 10.1016/j.jenvman.2005.11.021 CrossRefGoogle Scholar
  21. 21.
    Meul, M., Van Passel, S., Nevens, F., Dessein, J., Rogge, E., Mulier, A., Van Hauwermeiren, A.: MOTIFS: a monitoring tool for integrated farm sustainability. Agron. Sustain. Dev. 28, 321–332 (2008)CrossRefGoogle Scholar
  22. 22.
    Navrozidis, E.I., Vasara, E., Karamanlidou, G., Salpiggidis, G.K., Koliais, S.I.: Biological control of Bactroceraoleae (Diptera: Tephritidae) using a Greek Bacillus thuringiensis isolate. J. Econ. Entomol. 93, 1657–1661 (2000)CrossRefGoogle Scholar
  23. 23.
    Pinet, F., Schneider, M.: Precise design of environmental data warehouses. Oper. Res. Int. J. 10, 349–369 (2010)CrossRefGoogle Scholar
  24. 24.
    Prokopy, R.J.: Two decades of bottom-up, ecologically based pest management in a small commercial apple orchard in Massachusetts. Agr. Ecosyst. Environ. 94, 299–309 (2003)CrossRefGoogle Scholar
  25. 25.
    Reig-Martínez, E., Gómez-Limón, J.A., Picazo-Tadeo, A.J.: Ranking farms with a composite indicator of sustainability. Agric. Econ. 42, 561–575 (2011). doi: 10.1111/j.1574-0862.2011.00536.x CrossRefGoogle Scholar
  26. 26.
    Rodrigues, G.S., Rodrigues, I.A., de Almeida Buschinelli, C.C., de Barros, I.: Integrated farm sustainability assessment for the environmental management of rural activities. Environ. Impact Assess. Rev. 30, 229–239 (2010). doi: 10.1016/j.eiar.2009.10.002 CrossRefGoogle Scholar
  27. 27.
    Seuring, S., Müller, M.: From a literature review to a conceptual framework for sustainable supply chain management. J. Clean. Prod. 16, 1699–1710 (2008)CrossRefGoogle Scholar
  28. 28.
    United Nation. World Population Prospects: The 2010 Revision. Department of Economic and Social Affairs. Population Division, New York (2010)Google Scholar
  29. 29.
    Vernier, F., Miralles, A., Pinet, F., Carluer, N., Gouy, V., Molla, G., Petit, K.: Pesticides: An environmental information system to characterize agricultural activities and calculate agro-environmental indicators at embedded watershed scales. Agric. Syst. 122, 11–21 (2013)CrossRefGoogle Scholar
  30. 30.
    WCED U: Our Common Future. World Commission on Environment and Development Oxford University Press, Oxford (1987)Google Scholar

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  • Claudio Zaza
    • 1
    Email author
  • Sandro Bimonte
    • 2
  • Crescenzio Gallo
    • 3
  • Nicola Faccilongo
    • 1
  • Piermichele La Sala
    • 1
  • Francesco Contò
    • 1
  1. 1.Department of EconomicsUniversity of FoggiaFoggiaItaly
  2. 2.TSCFIrsteaAubiereFrance
  3. 3.Department of Clinical and Experimental MedicineUniversity of FoggiaFoggiaItaly

Personalised recommendations