Publications, data, tools


  1. Sandro Bimonte, Ali Hassan, Lucile Sautot: Entreposage et analyse en ligne des données de biodiversité. Atelier DEMO, SAGEO 2017, 6 Novembre 2017, ROUEN, France
  2.  Bimonte, S. Besnard, A., Edoh-Alove, E., Hassan, A., Prince, K., Sakka, A., Zarate, P.  VGI users & data centered methods for the analysis of farmland biodiversity indicators open issues. AGILE 2018, AGILE 2018 – Lund, June 12-15, 2018
  3. Vincenzo Del Fatto, Sandro Bimonte, Ali Hassan, Monica Sebillo:
    A Preliminary Study of Metrics and Methods for Readable Spatial OLAP Maps: VGI4Bio Case Study. IV 2018: 303-308
  4. Sandro Bimonte, Amir Sakka, Lucile Sautot. 2018. From crowdsourced requirements to analysis of VGI data: Open issues. Inforsid 2018 workshop Data Intelligence
  5. Sandro Bimonte, Amir Sakka, Lucile Sautot. 2018. A new methodology for Elicitation of Data Warehouse Requirements based on the Pivot Table Formalism. EDA18, Tanger Maroc
  6. Amir Sakka, Sandro Bimonte, Lucile Sautot, Guy Camilleri, Pascale Zaraté, Aurelien Besnard: A Volunteer Design Methodology of Data Warehouses. ER 2018: 286-300
  7. Sakka, A., Bimonte, S., Zaraté, P., Camilleri, G., Sautot, L., Besnard, Résolution collaborative des conflits des besoins d’analyse OLAP Spatial des données issues des observatoires citoyens. SAGEO 2018, Montpellier, France, p.77-82
  8. Bimonte, S. S. Rizzi, Sautot, L., Fontaine, B. Volunteered multidimensional design to the test: The Farmland Biodiversity VGI4Bio project’s experiment. DOLAP2019
  9. Porcher E, Vermeersch R.L., Billaud O, Pinard C. 2019. Observer pour comprendre les interactions de la biodiversité avec les pratiques agricoles : premiers résultats de l’Observatoire Agricole de la Biodiversité. Innovations Agronomiques, volume 75 (to appear)
  10. Princé, K., Coron, C., Fontaine, B.,  Porcher, E. Capitalizing on opportunistic data to refine bird population estimates. Bird Numbers 2019 Conference, 8-13 Avril 2019, Évora, Portugal
  11. Sakka, A., Bosetti, G., Grigera, J., Camilleri, G., Fernández, A.,  Zaraté, P., Bimonte, S., Sautot, L.
    UX Challenges in GDSS: An Experience Report. GDN 2019: 67-79
  12. SAUTOT, L., BIMONTE, S., JOURNAUX. A semi-automatic design methodology for Data Warehouse and Big Data Warehouse transforming facts into dimensions. Transactions on Knowledge and Data Engineering (To appear)
  13. Bimonte, S., Pinet. F. Une nouvelle méthodologie pour l’anonymisation des entrepôts de données spatiales : application aux données debiodiversité dans le contexte agricole. EDA 2019. Revue des Nouvelles Technologies de l’Information vol.RNTI-B-15, pp.15-30
  14. Edoh-Alove, E., Besnard, A., Brenon, C., Bimonte, S., Fontaine, B., Hassan, A., Hifdi, Y.,  Preud’homme, R., Rakotoniaina, I., Sakka, A. Analyse en ligne des données de biodiversité en milieu agricole. SAGEO 2019
  15. Bimonte, S., Hifdi, Y., Maliari, M., Rizzi S , Patrick M. To Each His Own: Accommodating Data Variety by a Multimodel Star Schema. DOLAP 2020 
  16. Deguines, N., Princé, K., Prévot, A-C., Fontaine, B. Assessing the emergence of pro-biodiversity practices in citizen scientists of a backyard butterfly survey. Science of The Total Environment (To appear)
  17. Bimonte, S., L. Antonelli, S., Rizzi. Requirement-Driven Data Warehouse Design Based on Enhanced Pivot Tables. Journal Requirements Engineering (To appear)
  18. Bimonte, S. Volunteer design of Data Warehouse (Tutorial). CAISE 2020
  19. Bimonte, S., Ren, L., Koueya, N. A linear programming-based framework for handling missing data in multi-granular data warehouses. Data & Knowledge Engineering (To appear)
  20. Plazas, J., Bimonte, S., Schneider, M., de Vaulx, C.,  Corrales, J. C.. A New Design Methodology for Self-Service Business Intelligence over On-Demand IoT Data. 24th European conference on Advances in Databases and Information Systems (ADBIS 2020) (To appear)
  21. Bimonte S., Flouvat, F., Fontaine, B., Hassan, A., Rouillier, N., Billaud, O.  Collect and analysis of agro-biodiversity data in a participative context: A Business Intelligence Framework. Ecological Informatics (To appear)
  22. Julián Eduardo PlazasSandro BimonteChristophe de VaulxMichel SchneiderQuang-Duy NguyenJean-Pierre ChanetHongling ShiKun Mean HouJuan Carlos Corrales:
    A Conceptual Data Model and Its Automatic Implementation for IoT-Based Business Intelligence Applications. IEEE Internet Things J. 7(10): 10719-10732 (2020)
  23. Bimonte, S., Gallinucci, E., Marcel, P., Rizzi, S. Data Variety, Come As You Are in Multi-model Data Warehouses. Information Systems (to appear)
  24. Sakka, A., Bimonte, S., Rizzi, S., Sautot, L., Pinet, F., Bertolotto, M., Besnard, A., Rouillier, N. A profile-aware methodological framework for collaborative multidimensional modeling. Data & Knowledge Engineering Journal (to appear)
  25. Sakka, A., Bimonte, S., Sautot, L., Pinet, F. Volunteer Data Warehouse: State of Art. International Journal of Data Warehousing and Mining (to appear)
  26. Princé, Karine, Calenge Clément, Giraud Christophe, Julliard Romain. Le « quality data » pour calibrer le « big data » : application aux suivis de biodiversité. (in review)

  27. Bimonte, S., Edoh-Alove, E., Coulibaly, A.F.  Map4OLAP: A web-based tool for interactive map visualization of OLAP queries. Workshop Big Spatial Data 2021 at 2021 IEEE International Conference on Big Data 2021 (Demo paper)


  • ProtOLAP. ProtOLAP: a software for automatic generation of Postgres SQL and XML Mondrian from UML profile ICSOLAP with Magic Draw 19.0 Download here
  • Map4OLAP.Map4OLAP: A web-based tool for interactive map visualization of OLAP queries. A video here


  • Multi-Model Data Warehouse dataset  Download here
  • All Data Warehouses developped are available here