{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T14:31:32Z","timestamp":1781101892399,"version":"3.54.1"},"reference-count":36,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,10,1]]},"abstract":"<p>Agricultural energy consumption is an important environmental and social issue. Several diagnosis tools have been proposed to define indicators for analyzing the large-scale energy consumption of agricultural farm activities (year, farm, production activity, etc.). In Bimonte, Boulil, Chanet and Pradel (2012), the authors define (i) new appropriate indicators to analyze agricultural farm energy-use performance on a detailed scale and (ii) show how Spatial Data Warehouse (SDW) and Spatial OnLine Analytical Processing (SOLAP) GeoBusiness Intelligence (GeoBI) technologies can be used to represent, store, and analyze these indicators by simultaneously producing graphical and cartographic reports. These GeoBI technologies allow for the analysis of huge volumes of georeferenced data by providing aggregated numerical values visualized by means of interactive tabular, graphical, and cartographic displays. However, existing data collection systems based on sensors are not well adapted for agricultural data. In this paper, the authors show the global architecture of our GeoBI solution and highlight the data collection process based on agricultural ad hoc sensor networks, the associated transformation and cleaning operations performed by means of Spatial Extract Transform Load (ETL) tools, and a new implementation of the system using a web-services-based loosely coupled SOLAP architecture to provide interoperability and reusability of the complex multi-tier GeoBI architecture. Moreover, the authors detail how the energy-use diagnosis tool proposed in Bimonte, Boulil, Chanet and Pradel (2012) theoretically fits with the sensor data and the SOLAP approach.<\/p>","DOI":"10.4018\/ijdsst.2013100101","type":"journal-article","created":{"date-parts":[[2014,4,23]],"date-time":"2014-04-23T09:20:46Z","timestamp":1398244846000},"page":"1-20","source":"Crossref","is-referenced-by-count":7,"title":["A New Sensor-Based Spatial OLAP Architecture Centered on an Agricultural Farm Energy-Use Diagnosis Tool"],"prefix":"10.4018","volume":"5","author":[{"given":"Sandro","family":"Bimonte","sequence":"first","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Aubi\u00e8re, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Marilys","family":"Pradel","sequence":"additional","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Montoldre, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Daniel","family":"Boffety","sequence":"additional","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Montoldre, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Aurelie","family":"Tailleur","sequence":"additional","affiliation":[{"name":"ARVALIS - Institut du v\u00e9g\u00e9tal, Service Agronomie Economie Environnement La Jailli\u00e8re, La Chapelle St Sauveur, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"G\u00e9raldine","family":"Andr\u00e9","sequence":"additional","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Montoldre, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rabi","family":"Bzikha","sequence":"additional","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Aubi\u00e8re, France"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jean-Pierre","family":"Chanet","sequence":"additional","affiliation":[{"name":"Irstea, l'Unit\u00e9 Recherche Technologies et Syst\u00e8mes d'information pour les Agrosyst\u00e8mes (TSCF), Aubi\u00e8re, France"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"ijdsst.2013100101-0","unstructured":"Abdullah, A., Brobst, S., Umer, M., & Khan, M. (2004). The case for an agri data warehouse: Enabling analytical exploration of integrated agricultural data. In Proceedings of International Conference on Databases and Applications 2004 (pp. 139-144). IASTED\/ACTA Press."},{"issue":"3","key":"ijdsst.2013100101-1","first-page":"229","article-title":"Data mining a new pilot agriculture extension data warehouse.","volume":"38","author":"A.Abdullah","year":"2006","journal-title":"Journal of Research and Practice in Information Technology"},{"key":"ijdsst.2013100101-2","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-8809(03)00115-4"},{"key":"ijdsst.2013100101-3","doi-asserted-by":"publisher","DOI":"10.4324\/9780203468029_chapter_3"},{"key":"ijdsst.2013100101-4","doi-asserted-by":"crossref","unstructured":"Bimonte, S., Boulil, K., Chanet, J.-P., & Pradel, M. (2012). Definition and analysis of new agricultural farm energetic indicators using spatial OLAP. In Proceedings of International Conference on Computational Science and Its Applications 2012 (pp. 373-385). Lecture Notes in Computer Science, 7334, Springer.","DOI":"10.1007\/978-3-642-31075-1_28"},{"key":"ijdsst.2013100101-5","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2010100103"},{"key":"ijdsst.2013100101-6","unstructured":"Bochu, J. L. (2002). PLANETE: m\u00e9thode pour l'analyse \u00e9nerg\u00e9tique de l'exploitation agricole et l'\u00e9valuation des \u00e9missions de gaz \u00e0 effet de serre. In Proceedings of Quels diagnostics pour quelles actions agroenvironnementales? (pp. 68-80). Solagro."},{"key":"ijdsst.2013100101-7","doi-asserted-by":"publisher","DOI":"10.3166\/isi.16.6.11-39"},{"key":"ijdsst.2013100101-8","unstructured":"Chanet, J. P., Boffety, D., Andr\u00e9, G., Humbert, T., Rameau, P., & Amamra, A. \u2026 Vigier, F. (2005). Wireless technologies for field data acquisition. In Proceedings of EFITA 2005."},{"key":"ijdsst.2013100101-9","unstructured":"Chanet, J. P., Boffety, D., Devaux, J. F., Hou, K., & Bouazdi, S. (2004). Communication et \u00e9quipements agricoles \u2013 Du r\u00e9seau embarqu\u00e9 au r\u00e9seau ad hoc sans fil pour l\u2019int\u00e9gration des \u00e9quipements agricoles dans des syst\u00e8mes d\u2019information \u00e9tendus. Ing\u00e9nierie EAT, Technologies pour les agrosyst\u00e8mes durables (pp. 177-190)."},{"issue":"2","key":"ijdsst.2013100101-10","first-page":"56","article-title":"On-line analytical processing in agriculture using multidimensional cubes.","volume":"62","author":"K.Chaturvedi","year":"2008","journal-title":"International Indian Society Agricltural Statistics Journal"},{"key":"ijdsst.2013100101-11","doi-asserted-by":"crossref","unstructured":"Chaudhary, S., Sorathia, V., & Laliwala, Z. (2004). Architecture of sensor based agricultural information system for effective planning of farm activities. In Proceedings of IEEE International Conference on Services Computing 2004 (pp. 93-100). IEEE.","DOI":"10.1109\/SCC.2004.1357994"},{"key":"ijdsst.2013100101-12","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-5877(02)00121-6"},{"key":"ijdsst.2013100101-13","unstructured":"Deurveilherd, D., Chiroleu, F., Chanet, M., Chanet, J. P., & Boffety, D. (2012). ICT for traceability of sugarcane harvesting operations in small farm. In Proceedings of International Conference on Agricultural Engineering 2012."},{"key":"ijdsst.2013100101-14","unstructured":"GeoMondrian. (2012). Geomondrian. Retrieved October 10, 2012, from http:\/\/www.spatialytics.org\/projects\/geomondrian\/"},{"key":"ijdsst.2013100101-15","unstructured":"Gras, R., Beno\u00eet, M., Deffontaines, J. P., Duru, M., Lafarge, M., Langlet, A., & Osty, P. L. (1989). Le Fait Technique en Agronomic: Activit\u00e9 Agricole, Concepts et M\u00e9thodes d'\u00c9tude. Paris, France: L'Harmattan."},{"key":"ijdsst.2013100101-16","author":"R.Kimball","year":"1996","journal-title":"The data warehouse toolkit: Practical techniques for building dimensional data warehouses"},{"key":"ijdsst.2013100101-17","unstructured":"Map4decision, (2012). Map4decision. Retrieved October 10, 2012, from http:\/\/www.intelli3.com\/"},{"key":"ijdsst.2013100101-18","doi-asserted-by":"publisher","DOI":"10.1109\/MCG.2004.1255801"},{"key":"ijdsst.2013100101-19","doi-asserted-by":"publisher","DOI":"10.1080\/13504509509469893"},{"key":"ijdsst.2013100101-20","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2007.09.009"},{"key":"ijdsst.2013100101-21","unstructured":"NoMagic. (2012). MagicDraw. Retrieved October 10, 2012, from http:\/\/www.nomagic.com\/products\/magicdraw.html"},{"key":"ijdsst.2013100101-22","doi-asserted-by":"publisher","DOI":"10.1016\/S0308-521X(01)00073-7"},{"key":"ijdsst.2013100101-23","unstructured":"Pinet, F., Miralles, A., Bimonte, S., Vernier, F., Caurler, N., Gouy, V., & Bernard, S. (2010). The use of UML to design agricultural data warehouses. In Proceedings of International Conference on Agricultural Engineering 2010."},{"key":"ijdsst.2013100101-24","unstructured":"Piron, E., Boffety, D., Andr\u00e9, G., & Vigier, F. (2003). Dispositif pour la transmission d\u2019informations provenant d\u2019au moins un capteur plac\u00e9 sur v\u00e9hicule tel qu\u2019une machine agricole. Technical Report FR031148."},{"key":"ijdsst.2013100101-25","unstructured":"PostGIS. (2012). PostGIS. Retrieved October 10, 2012, from http:\/\/postgis.net\/"},{"key":"ijdsst.2013100101-26","first-page":"16","article-title":"Quels indicateurs et solutions technologiques adapt\u00e9s pour \u00e9valuer finement les performances \u00e9nerg\u00e9tiques des exploitations agricoles? Sciences","volume":"7","author":"M.Pradel","year":"2012","journal-title":"Eaux et Territoires"},{"key":"ijdsst.2013100101-27","unstructured":"Radulescu, C., Radulescu, M., & Rahoveanu, A. (2009). A multidimensional data model and OLAP analysis for agricultural production. In Proceedings of International Conference on Mathematics and Computers in Business and Economics 2009."},{"key":"ijdsst.2013100101-28","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2008.04.009"},{"key":"ijdsst.2013100101-29","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2007.05.001"},{"key":"ijdsst.2013100101-30","unstructured":"SDI. (2012). Spatial data integrator. Retrieved October 10, 2012, from http:\/\/www.spatialdataintegrator.com\/"},{"key":"ijdsst.2013100101-31","unstructured":"SOLAGRO. (2007). Energie dans les exploitations agricoles: \u00e9tat des lieux en Europe et \u00e9l\u00e9ments de r\u00e9flexion pour la France. Technical Report ADEME\/ MAP 0671C0036."},{"key":"ijdsst.2013100101-32","doi-asserted-by":"publisher","DOI":"10.1016\/j.compag.2008.10.005"},{"key":"ijdsst.2013100101-33","doi-asserted-by":"publisher","DOI":"10.1111\/1467-9353.00155"},{"key":"ijdsst.2013100101-34","author":"L.Vilain","year":"2003","journal-title":"La m\u00e9thode IDEA, Indicateurs de durabilit\u00e9 des exploitations, guide d'utilisation"},{"key":"ijdsst.2013100101-35","doi-asserted-by":"publisher","DOI":"10.1177\/089443930001800406"}],"container-title":["International Journal of Decision Support System Technology"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=105928","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,7,12]],"date-time":"2023-07-12T06:15:06Z","timestamp":1689142506000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijdsst.2013100101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2013,10,1]]},"references-count":36,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2013,10]]}},"URL":"https:\/\/doi.org\/10.4018\/ijdsst.2013100101","relation":{},"ISSN":["1941-6296","1941-630X"],"issn-type":[{"value":"1941-6296","type":"print"},{"value":"1941-630X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,10,1]]}}}