{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,1,8]],"date-time":"2023-01-08T12:51:18Z","timestamp":1673182278151},"reference-count":39,"publisher":"IGI Global","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018,1,1]]},"abstract":"
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.<\/p>","DOI":"10.4018\/ijaeis.2018010102","type":"journal-article","created":{"date-parts":[[2017,11,8]],"date-time":"2017-11-08T15:53:01Z","timestamp":1510156381000},"page":"16-38","source":"Crossref","is-referenced-by-count":2,"title":["BI4IPM"],"prefix":"10.4018","volume":"9","author":[{"given":"Claudio","family":"Zaza","sequence":"first","affiliation":[{"name":"Departement of Economics, University of Foggia, Foggia, Italy"}]},{"given":"Sandro","family":"Bimonte","sequence":"additional","affiliation":[{"name":"IRSTEA, Aubi\u00e8re, France"}]},{"given":"Nicola","family":"Faccilongo","sequence":"additional","affiliation":[{"name":"Department of Economics, University of Foggia, Foggia, Italy"}]},{"given":"Piermichele","family":"La Sala","sequence":"additional","affiliation":[{"name":"Department of Economics, University of Foggia, Foggia, Italy"}]},{"given":"Francesco","family":"Cont\u00f2","sequence":"additional","affiliation":[{"name":"Department of Economics, University of Foggia, Foggia, Italy"}]},{"given":"Crescenzio","family":"Gallo","sequence":"additional","affiliation":[{"name":"Department of Clinical and Experimental Medicine, University of Foggia, Foggia, Italy"}]}],"member":"2432","reference":[{"key":"IJAEIS.2018010102-0","doi-asserted-by":"crossref","unstructured":"Barzman, M., B\u00e0rberi, P., Birch, A. N. E., Boonekamp, P., Dachbrodt-Saaydeh, S., Graf, B., \u2026 Sattin, M. (2015). Eight principles of integrated pest management. Agronomy for sustainable development, 35(4).","DOI":"10.1007\/s13593-015-0327-9"},{"key":"IJAEIS.2018010102-1","doi-asserted-by":"publisher","DOI":"10.4018\/IJAEIS.2016100103"},{"key":"IJAEIS.2018010102-2","doi-asserted-by":"publisher","DOI":"10.4018\/ijdsst.2013100101"},{"key":"IJAEIS.2018010102-3","doi-asserted-by":"publisher","DOI":"10.1016\/0308-521X(76)90019-6"},{"key":"IJAEIS.2018010102-4","doi-asserted-by":"publisher","DOI":"10.1016\/j.csi.2014.06.004"},{"key":"IJAEIS.2018010102-5","doi-asserted-by":"publisher","DOI":"10.1016\/j.ecoinf.2014.07.001"},{"key":"IJAEIS.2018010102-6","doi-asserted-by":"publisher","DOI":"10.4018\/ijaeis.2014100104"},{"key":"IJAEIS.2018010102-7","doi-asserted-by":"publisher","DOI":"10.1098\/rstb.2010.0390"},{"issue":"1","key":"IJAEIS.2018010102-8","first-page":"56","article-title":"On-line analytical processing in agriculture using multidimensional cubes.","volume":"62","author":"K.Chaturvedi","year":"2008","journal-title":"J. Ind. Soc. Agril. Statist"},{"key":"IJAEIS.2018010102-9","doi-asserted-by":"publisher","DOI":"10.1109\/SCC.2004.1357994"},{"key":"IJAEIS.2018010102-10","first-page":"71","article-title":"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.","volume":"309","year":"2009","journal-title":"J. Eur. Union"},{"key":"IJAEIS.2018010102-11","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2015.05.011"},{"key":"IJAEIS.2018010102-12","doi-asserted-by":"publisher","DOI":"10.1016\/j.agsy.2004.12.003"},{"key":"IJAEIS.2018010102-13","first-page":"1","article-title":"Data Warehouse Design and Management: Theory and Practice. IEEE MEMBERS. Dipartimento di Scienze Economiche","volume":"II","author":"C.Gallo","year":"2010","journal-title":"Matematiche e Statistiche Universit\u00e0 Di Foggia Largo Papa Giovanni Paolo"},{"key":"IJAEIS.2018010102-14","doi-asserted-by":"publisher","DOI":"10.1093\/eurrag\/jbi011"},{"key":"IJAEIS.2018010102-15","doi-asserted-by":"publisher","DOI":"10.15623\/ijret.2013.0203006"},{"key":"IJAEIS.2018010102-16","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376713"},{"key":"IJAEIS.2018010102-17","unstructured":"Italian Institute of Statics. (2010). Agricultural Census. Retrieved from http:\/\/dati-censimentoagricoltura.istat.it\/ (accessed 20.03.17)."},{"key":"IJAEIS.2018010102-18","unstructured":"Italian Institute of Statics. (2016). Area and Production. Retrieved 20.03.17 from www.istat.it\/it\/"},{"key":"IJAEIS.2018010102-19","doi-asserted-by":"publisher","DOI":"10.1111\/j.1365-2486.2005.00930.x"},{"key":"IJAEIS.2018010102-20","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2013.11.014"},{"key":"IJAEIS.2018010102-21","author":"R.Kimball","year":"2013","journal-title":"The data warehouse toolkit: The definitive guide to dimensional modeling"},{"key":"IJAEIS.2018010102-22","doi-asserted-by":"publisher","DOI":"10.1016\/0168-1699(86)90001-3"},{"key":"IJAEIS.2018010102-23","doi-asserted-by":"publisher","DOI":"10.1016\/j.protcy.2013.11.084"},{"key":"IJAEIS.2018010102-24","doi-asserted-by":"publisher","DOI":"10.1007\/s11119-009-9134-0"},{"key":"IJAEIS.2018010102-25","doi-asserted-by":"publisher","DOI":"10.1603\/0022-0493-93.6.1657"},{"key":"IJAEIS.2018010102-26","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2009.08.013"},{"key":"IJAEIS.2018010102-27","doi-asserted-by":"publisher","DOI":"10.1016\/j.ifacol.2016.10.060"},{"key":"IJAEIS.2018010102-28","doi-asserted-by":"publisher","DOI":"10.1007\/s12351-009-0069-z"},{"key":"IJAEIS.2018010102-29","doi-asserted-by":"publisher","DOI":"10.1016\/0308-521X(89)90017-6"},{"key":"IJAEIS.2018010102-30","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-8809(02)00036-1"},{"key":"IJAEIS.2018010102-31","doi-asserted-by":"crossref","unstructured":"Schaffner, J., Bog, A., Kr\u00fcger, J., & Zeier, A. (2008). A hybrid row-column OLTP database architecture for operational reporting. In Proceedings ofInternational Workshop on Business Intelligence for the Real-Time Enterprise (pp. 61-74). Springer Berlin Heidelberg.","DOI":"10.1007\/978-3-642-03422-0_5"},{"key":"IJAEIS.2018010102-32","doi-asserted-by":"publisher","DOI":"10.1016\/j.jclepro.2008.04.020"},{"key":"IJAEIS.2018010102-33","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2010.02.003"},{"key":"IJAEIS.2018010102-34","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2008.10.005"},{"key":"IJAEIS.2018010102-35","doi-asserted-by":"publisher","DOI":"10.1016\/0309-586X(76)90013-3"},{"key":"IJAEIS.2018010102-36","unstructured":"UN, D. (2013). World population prospects: The 2012 revision."},{"key":"IJAEIS.2018010102-37","doi-asserted-by":"publisher","DOI":"10.1016\/j.agsy.2013.07.005"},{"key":"IJAEIS.2018010102-38","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-62395-5_3"}],"container-title":["International Journal of Agricultural and Environmental Information Systems"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=192193","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,7]],"date-time":"2022-05-07T01:56:47Z","timestamp":1651888607000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJAEIS.2018010102"}},"subtitle":["A Business Intelligence System for the Analysis of Olive Tree's Integrated Pest Management"],"short-title":[],"issued":{"date-parts":[[2018,1,1]]},"references-count":39,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2018,1]]}},"URL":"http:\/\/dx.doi.org\/10.4018\/ijaeis.2018010102","relation":{},"ISSN":["1947-3192","1947-3206"],"issn-type":[{"value":"1947-3192","type":"print"},{"value":"1947-3206","type":"electronic"}],"subject":["Information Systems"],"published":{"date-parts":[[2018,1,1]]}}}