Bimonte Sandro

Irstea − Copain
9 avenue Blaise Pascal − CS 20085
63178 Aubière − France
+33 4 73 44 06 66
Contact

ma page web est disponible ici : https://sites.google.com/site/sandrobimonte/home

Publications

Journal Articles (40)

L. Sautot, S. Bimonte, L. Journaux, B. Faivre
Multidimensional model design using data mining: A rapid prototyping methodology
International Journal of Data Warehousing and Mining 7 (1), 2017
abs doi web bib

Designing and building a Data Warehouse (DW), and associated OLAP cubes, are long processes, during which decision-maker requirements play an important role. But decision-makers are not OLAP experts and can find it difficult to deal with the concepts behind DW and OLAP. In order to simplify user participation in the design process, we provide a methodology to build a prototype of the future DW that decision-makers can “play” with. In this way, these users can more easily express their design requirements. In some cases, OLAP systems may possess useful features for data analysis but, unfortunately, these data may have a structure incompatible with a multidimensional schema. In our case study, the dimensional data had no hierarchical structure. We therefore integrated a DM process into our methodology, to discover hierarchies in dimension member attributes. To support DW design in this context, we propose: (i) a new rapid prototyping methodology, integrating two different DM algorithms, to define dimension hierarchies according to decision-maker knowledge; (ii) a complete UML Profile, to define a DW schema that integrates both the DM algorithms; (iii) a mapping process to transform multidimensional schemata according to the results of the DM algorithms; (iv) a tool implementing the proposed methodology; (v) a full validation, based on a real case study concerning bird biodiversity. In conclusion, we confirm the rapidity and efficacy of our methodology and tool in providing a multidimensional schema to satisfy decision-maker analytical needs.
close

@article{PUB00057138, author = {Sautot, L. and Bimonte, S. and Journaux, L. and Faivre, B.}, title = {Multidimensional model design using data mining: A rapid prototyping methodology }, journal = {International Journal of Data Warehousing and Mining}, volume = {7}, number = {1}, pages = {1-35}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00057138}, doi = {http://dx.doi.org/10.4018/IJDWM.2017010101}, year = {2017}, affiliation = { MONTPELLIER UR FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; CNRS DIJON FRA ; CNRS DIJON FRA}, abstract = {Designing and building a Data Warehouse (DW), and associated OLAP cubes, are long processes, during which decision-maker requirements play an important role. But decision-makers are not OLAP experts and can find it difficult to deal with the concepts behind DW and OLAP. In order to simplify user participation in the design process, we provide a methodology to build a prototype of the future DW that decision-makers can “play” with. In this way, these users can more easily express their design requirements. In some cases, OLAP systems may possess useful features for data analysis but, unfortunately, these data may have a structure incompatible with a multidimensional schema. In our case study, the dimensional data had no hierarchical structure. We therefore integrated a DM process into our methodology, to discover hierarchies in dimension member attributes. To support DW design in this context, we propose: (i) a new rapid prototyping methodology, integrating two different DM algorithms, to define dimension hierarchies according to decision-maker knowledge; (ii) a complete UML Profile, to define a DW schema that integrates both the DM algorithms; (iii) a mapping process to transform multidimensional schemata according to the results of the DM algorithms; (iv) a tool implementing the proposed methodology; (v) a full validation, based on a real case study concerning bird biodiversity. In conclusion, we confirm the rapidity and efficacy of our methodology and tool in providing a multidimensional schema to satisfy decision-maker analytical needs.}, }
close
S. Bimonte, N. Echcherki, L. Gineste
A system for the rapid design and implementation of personalized agricultural key performance indicators issued from sensor data
Computers and Electronics in Agriculture 130, 2016
abs doi web bib

Farm Management Information Systems provide decision-makers (farmers) with a set of predefined Key Performance Indicators (KPIs) that are issued manually from collected data or via sensors installed on farm equipment. However, agricultural decision-makers need ad-hoc KPIs issued from low-cost sensors. Therefore, we present our VBoxReporting system in this paper. VBoxReporting is a complete system that allows the rapid design and implementation of reporting KPIs issued from VBox data. VBox, which was developed by Exotic Systems, is a low-cost sensor for tracing the energy use of agricultural equipment. Once the indicators are modeled, VBoxReporting automatically generates all of the scripts required to load data from VBox and create the indicators. We also provide a usability study to validate our user interface layer.
close

@article{PUB00053477, author = {Bimonte, S. and Echcherki, N. and Gineste, L.}, title = {A system for the rapid design and implementation of personalized agricultural key performance indicators issued from sensor data}, title = {Un système pour la conception et l’implémentation rapide d'indicateurs de performance agricole issus de données des capteurs}, journal = {Computers and Electronics in Agriculture}, volume = {130}, pages = {1-12}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053477}, doi = {http://dx.doi.org/10.1016/j.compag.2016.09.010}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; EXOTIC SYSTEMS CLERMONT FERRAND FRA}, abstract = {Farm Management Information Systems provide decision-makers (farmers) with a set of predefined Key Performance Indicators (KPIs) that are issued manually from collected data or via sensors installed on farm equipment. However, agricultural decision-makers need ad-hoc KPIs issued from low-cost sensors. Therefore, we present our VBoxReporting system in this paper. VBoxReporting is a complete system that allows the rapid design and implementation of reporting KPIs issued from VBox data. VBox, which was developed by Exotic Systems, is a low-cost sensor for tracing the energy use of agricultural equipment. Once the indicators are modeled, VBoxReporting automatically generates all of the scripts required to load data from VBox and create the indicators. We also provide a usability study to validate our user interface layer.}, }
close
S. Bimonte, K. Boulil, F. Pinet
Cohérence logique dans les systèmes OLAP spatiaux : un état de l’art
International Journal of Geomatics and Spatial Analysis-Revue Internationale de Géomatique 26 (1), 2016
abs doi web bib

Les systèmes d'Entrepôts de Données et « OnLine Analytical Process » spatiaux (EDS et SOLAP) sont des technologies d'aide à la décision permettant l’agrégation et l'analyse multidimensionnelle de gros volumes de données spatiales. En réponse à des actions utilisateurs sur l'interface cliente (exploration), les systèmes SOLAP agrègent les données de l'EDS le long de différentes hiérarchies des dimensions pour calculer des indicateurs d'analyse à différents niveaux de détails. La qualité des indicateurs d'analyse dépend donc de trois facteurs : la qualité des données entreposées, la qualité des agrégations et la qualité de l’exploration des données. La qualité des données entreposées dépend de critères comme la précision, l'exhaustivité et la cohérence logique. La cohérence logique des données est généralement contrôlée par les contraintes d'intégrité qui définissent les conditions que les données doivent satisfaire. La qualité d'agrégation peut être ramenée à la cohérence logique entre les natures des éléments qui sont impliqués dans l'agrégation SOLAP (par ex., mesure, fonction d'agrégation). Cette cohérence d'agrégation est affectée par des problèmes structurels et de problèmes sémantiques. La qualité d'exploration dépend essentiellement de la consistance des requêtes utilisateur (par ex. quelles ont été les valeurs de température en URSS en 2010 ?). Dans cette article nous étendons la notion de cohérence logique des données aux deux autres composantes fondamentales des systèmes SOLAP, à savoir l'agrégation et la requête. Nous présentons un état de l'art et des travaux sur la définition des contraintes d’intégrité pour garantir la cohérence logique au niveau des trois composantes (données, agrégations, et requêtes), ainsi qu' une évaluation de ces travaux et de notre proposition par rapport à un ensemble de critères que nous avons définis. Cette évaluation montre que notre proposition satisfait tous les critères contrairement aux autres.
close

@article{PUB00050619, author = {Bimonte, S. and Boulil, K. and Pinet, F.}, title = {Cohérence logique dans les systèmes OLAP spatiaux : un état de l’art}, journal = {International Journal of Geomatics and Spatial Analysis-Revue Internationale de Géomatique}, volume = {26}, number = {1}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00050619}, doi = {http://dx.doi.org/10.3166/RIG.26.97-131}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE STRASBOURG FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Les systèmes d'Entrepôts de Données et « OnLine Analytical Process » spatiaux (EDS et SOLAP) sont des technologies d'aide à la décision permettant l’agrégation et l'analyse multidimensionnelle de gros volumes de données spatiales. En réponse à des actions utilisateurs sur l'interface cliente (exploration), les systèmes SOLAP agrègent les données de l'EDS le long de différentes hiérarchies des dimensions pour calculer des indicateurs d'analyse à différents niveaux de détails. La qualité des indicateurs d'analyse dépend donc de trois facteurs : la qualité des données entreposées, la qualité des agrégations et la qualité de l’exploration des données. La qualité des données entreposées dépend de critères comme la précision, l'exhaustivité et la cohérence logique. La cohérence logique des données est généralement contrôlée par les contraintes d'intégrité qui définissent les conditions que les données doivent satisfaire. La qualité d'agrégation peut être ramenée à la cohérence logique entre les natures des éléments qui sont impliqués dans l'agrégation SOLAP (par ex., mesure, fonction d'agrégation). Cette cohérence d'agrégation est affectée par des problèmes structurels et de problèmes sémantiques. La qualité d'exploration dépend essentiellement de la consistance des requêtes utilisateur (par ex. quelles ont été les valeurs de température en URSS en 2010 ?). Dans cette article nous étendons la notion de cohérence logique des données aux deux autres composantes fondamentales des systèmes SOLAP, à savoir l'agrégation et la requête. Nous présentons un état de l'art et des travaux sur la définition des contraintes d’intégrité pour garantir la cohérence logique au niveau des trois composantes (données, agrégations, et requêtes), ainsi qu' une évaluation de ces travaux et de notre proposition par rapport à un ensemble de critères que nous avons définis. Cette évaluation montre que notre proposition satisfait tous les critères contrairement aux autres.}, }
close
S. Bimonte, Negre. S.
Evaluation of user satisfaction with OLAP recommender systems: An application to RecoOLAP on a agricultural energetic consumption datawarehouse
Int. J. Business Information Systems 21 (1), 2016
abs web bib

OLAP and datawarehouse (DW) systems are technologies intended to support the decision-making process, enabling the analysis of a substantial volume of data. One of the goals of recommender systems is to help users navigate large amounts of data. OLAP recommender systems have recently been proposed in the literature because the multidimensional analysis process is often tedious because the user may not know what the forthcoming query should be. User satisfaction with these systems has not yet been investigated. Thus, this work is the first study of the usefulness of OLAP recommender systems from the decision maker’s point of view. Indeed, to the best of our knowledge, although several works have proposed OLAP recommender systems, they did not evaluate them against real-world data and users. With our experiments on a spatial DW concerning agricultural energetic consummation issued from the Energetic French Project.
close

@article{PUB00043933, author = {Bimonte, S. and Negre. S.}, title = {Evaluation of user satisfaction with OLAP recommender systems: An application to RecoOLAP on a agricultural energetic consumption datawarehouse}, title = {Évaluation de la satisfaction de l'utilisateur des systèmes de recommandation OLAP : utilisation de RecoOLAP sur un entrepôt de données concernant la consommation énergétique agricole}, journal = {Int. J. Business Information Systems}, volume = {21}, number = {1}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00043933}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE PARIS III FRA}, abstract = {OLAP and datawarehouse (DW) systems are technologies intended to support the decision-making process, enabling the analysis of a substantial volume of data. One of the goals of recommender systems is to help users navigate large amounts of data. OLAP recommender systems have recently been proposed in the literature because the multidimensional analysis process is often tedious because the user may not know what the forthcoming query should be. User satisfaction with these systems has not yet been investigated. Thus, this work is the first study of the usefulness of OLAP recommender systems from the decision maker’s point of view. Indeed, to the best of our knowledge, although several works have proposed OLAP recommender systems, they did not evaluate them against real-world data and users. With our experiments on a spatial DW concerning agricultural energetic consummation issued from the Energetic French Project.}, }
close
S. Bimonte
Current approaches, challenges and perspectives on Spatial OLAP for agri-environmental analysis
International Journal of Agricultural and Environmental Information Systems IJAEIS 7 (1), 2016
abs doi web bib

Spatial OLAP (SOLAP) systems are powerful GeoBusiness Intelligence tools for analysing massive volumes of geo-referenced datasets. Therefore, these technologies are receiving considerable attention in the research community and in the database industry as well. Applications of these technologies are current in several domains such as ad marketing, healthcare, and urban development, to name a few. Contrary to other application domains, in the context of agri-environmental data and analysis, SOLAP systems have been underexploited. Therefore, in this paper, we make an exhaustive survey of most of the published studies in the domain of the SOLAP analysis of agri-environmental data with an emphasis on the reasons why only few recent works investigate the use of SOLAP systems in the agri-environmental context. In particular, we focus on the complexity of the spatiomultidimensional model and its implementation. Moreover, based on surveying the state of the art in this domain, this paper identifies some general guidelines that must be considered by the scientific community to design and implement efficient SOLAP approaches to the analysis of geo-referenced agri-environmental datasets. Finally, open issues about warehousing and OLAPing agri-environmental data are also shown in the paper
close

@article{PUB00053479, author = {Bimonte, S.}, title = {Current approaches, challenges and perspectives on Spatial OLAP for agri-environmental analysis}, title = {Défis et solutions pour l'OLAP Spatial pour l'analyse agri-environnementale}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {7}, number = {1}, pages = {33-50}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053479}, doi = {http://dx.doi.org/10.4018/IJAEIS.2016100103}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial OLAP (SOLAP) systems are powerful GeoBusiness Intelligence tools for analysing massive volumes of geo-referenced datasets. Therefore, these technologies are receiving considerable attention in the research community and in the database industry as well. Applications of these technologies are current in several domains such as ad marketing, healthcare, and urban development, to name a few. Contrary to other application domains, in the context of agri-environmental data and analysis, SOLAP systems have been underexploited. Therefore, in this paper, we make an exhaustive survey of most of the published studies in the domain of the SOLAP analysis of agri-environmental data with an emphasis on the reasons why only few recent works investigate the use of SOLAP systems in the agri-environmental context. In particular, we focus on the complexity of the spatiomultidimensional model and its implementation. Moreover, based on surveying the state of the art in this domain, this paper identifies some general guidelines that must be considered by the scientific community to design and implement efficient SOLAP approaches to the analysis of geo-referenced agri-environmental datasets. Finally, open issues about warehousing and OLAPing agri-environmental data are also shown in the paper}, }
close
S. Bimonte, M. Schneider, O. Bousaid
Business intelligence indicators: Types, models and implementation
International Journal of Data Warehousing and Mining 12 (4), 2016
abs web bib

Nowadays, more and more data are available for decisional analysis and decision-making based on different indicators. Although different decision-making technologies have been developed, we note the lack of a conceptual framework for the definition and implementation of these indicators. In this paper, we propose a first classification of these indicators. Furthermore, motivated by the need for formalism for the definition of these indicators at a conceptual level, we present the Business Intelligence Indicators (BI2) UML profile to represent indicators for OLAP, OLTP and streaming technologies. We also present their implementation in existing industrial tools. In addition, we show how these indicators can coexist in the same environment to exchange data through a chaining model and its implementation.
close

@article{PUB00053480, author = {Bimonte, S. and Schneider, M. and Bousaid, O.}, title = {Business intelligence indicators: Types, models and implementation}, title = {Indicateurs de business intelligence : types, modèles et implémentation}, journal = {International Journal of Data Warehousing and Mining}, volume = {12}, number = {4}, pages = {75-95}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053480}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE CLERMONT FERRAND II UMR LIMOS FRA ; UNIVERSITE DE LYON II FRA}, abstract = {Nowadays, more and more data are available for decisional analysis and decision-making based on different indicators. Although different decision-making technologies have been developed, we note the lack of a conceptual framework for the definition and implementation of these indicators. In this paper, we propose a first classification of these indicators. Furthermore, motivated by the need for formalism for the definition of these indicators at a conceptual level, we present the Business Intelligence Indicators (BI2) UML profile to represent indicators for OLAP, OLTP and streaming technologies. We also present their implementation in existing industrial tools. In addition, we show how these indicators can coexist in the same environment to exchange data through a chaining model and its implementation.}, }
close
F. Johany, S. Bimonte
A framework for spatio-multidimensional analysis improved by chorems: Application to agricultural data
Lecture Notes in Business Information Processing, 2016
abs web bib

Spatial OLAP (SOLAP) systems are decision-support systems for the analysis of huge volumes of spatial data. Usually, SOLAP clients provide decision-makers with a set of graphical, tabular and cartographic displays to visualize warehoused spatial data. Geovisualization methods coupled with existing SOLAP systems are limited to interactive (multi) maps. However, a new kind of geovisualization method recently appears to provide summaries of geographic phenomena: the chorem-based methods. A chorem is theoretically defined as a schematized spatial representation, which eliminates any unnecessary details to the map comprehension. Therefore, in this paper we investigate the opportunity to integrate SOLAP and chorem systems in a unique decision support system. We propose the ChoremOLAP system that enriches SOLAP maps with chorems. We apply our proposal to agricultural data analysis, since both chorems and SOLAP have been rarely used in this application domain. Using open data provided by the FAO, we show how ChoremOLAP is well adapted in the agricultural context.
close

@article{PUB00053481, author = {Johany, F. and Bimonte, S.}, title = {A framework for spatio-multidimensional analysis improved by chorems: Application to agricultural data}, title = {Une méthodologie et un système pour l'analyse spatio-multidimensionnelle améliorée par les choremes: application aux données agricoles}, journal = {Lecture Notes in Business Information Processing}, pages = {59-80}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053481}, year = {2016}, affiliation = {INRA CLERMONT FERRAND UMR METAFORT FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial OLAP (SOLAP) systems are decision-support systems for the analysis of huge volumes of spatial data. Usually, SOLAP clients provide decision-makers with a set of graphical, tabular and cartographic displays to visualize warehoused spatial data. Geovisualization methods coupled with existing SOLAP systems are limited to interactive (multi) maps. However, a new kind of geovisualization method recently appears to provide summaries of geographic phenomena: the chorem-based methods. A chorem is theoretically defined as a schematized spatial representation, which eliminates any unnecessary details to the map comprehension. Therefore, in this paper we investigate the opportunity to integrate SOLAP and chorem systems in a unique decision support system. We propose the ChoremOLAP system that enriches SOLAP maps with chorems. We apply our proposal to agricultural data analysis, since both chorems and SOLAP have been rarely used in this application domain. Using open data provided by the FAO, we show how ChoremOLAP is well adapted in the agricultural context.}, }
close
L. Berrahou, N. Lalande, E. Serrano, G. Molla, L. Berti Equille, S. Bimonte, S. Bringay, F. Cernesson, C. Grac, D. Ienco, F. Le Ber, M. Teisseire
A quality-aware spatial data warehouse for querying hydroecological data
Computers & Geosciences 85 (part A), 2015
abs doi web bib

Addressing data quality issues in information systems remains a challenging task. Many approaches only tackle this issue at the extract, transform and load steps. Here we define a comprehensive method to gain greater insight into data quality characteristics within data warehouse. Our novel architecture was implemented for an hydroecological case study where massive French watercourse sampling data are collected. The method models and makes effective use of spatial, thematic and temporal accuracy, consistency and completeness for multidimensional data in order to offer analysts a "data quality" oriented framework. The results obtained in experiments carried out on the Saône River dataset demonstrated the relevance of our approach.
close

@article{PUB00045754, author = {Berrahou, L. and Lalande, N. and Serrano, E. and Molla, G. and Berti Equille, L. and Bimonte, S. and Bringay, S. and Cernesson, F. and Grac, C. and Ienco, D. and Le Ber, F. and Teisseire, M.}, title = {A quality-aware spatial data warehouse for querying hydroecological data}, journal = {Computers & Geosciences}, volume = {85}, number = {part A}, pages = {126-135}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00045754 / http://cemadoc.irstea.fr/exl-php/util/documents/accede_document.php}, doi = {http://dx.doi.org/10.1016/j.cageo.2015.09.012}, year = {2015}, affiliation = {IRSTEA MONTPELLIER UMR TETIS FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; IRD UR ESPACE-DEV MONTPELLIER FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; IRD UR ESPACE-DEV MONTPELLIER FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE MONTPELLIER II UMR 5506 LIRMM MONTPELLIER FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; LIVE STRASBOURG FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; ICUBE STRASBOURG FRA ; IRSTEA MONTPELLIER UMR TETIS FRA}, abstract = {Addressing data quality issues in information systems remains a challenging task. Many approaches only tackle this issue at the extract, transform and load steps. Here we define a comprehensive method to gain greater insight into data quality characteristics within data warehouse. Our novel architecture was implemented for an hydroecological case study where massive French watercourse sampling data are collected. The method models and makes effective use of spatial, thematic and temporal accuracy, consistency and completeness for multidimensional data in order to offer analysts a "data quality" oriented framework. The results obtained in experiments carried out on the Saône River dataset demonstrated the relevance of our approach.}, }
close
S. Bimonte, K. Boulil, A. Braud, S. Bringay, F. Cernesson, X. Dolques, M. Fabregue, C. Grac, N. Lalande, F. Le Ber, M. Teisseire
Un système décisionnel pour l’analyse de la qualité des eaux de rivières
Ingénierie des Systèmes d'Information 20 (3), 2015
abs doi web bib

Cet article décrit un système décisionnel développé pour permettre l’analyse des données concernant le fonctionnement des hydro-écosystèmes ; ces données sont nombreuses, diverses et issues de sources variées. Le système mis en place comporte une base de données intégrée, un entrepôt permettant l’exploration des dimensions associées aux données, et des outils de fouille permettant de répondre aux questions des hydro-écologues
close

@article{PUB00046020, author = {Bimonte, S. and Boulil, K. and Braud, A. and Bringay, S. and Cernesson, F. and Dolques, X. and Fabregue, M. and Grac, C. and Lalande, N. and Le Ber, F. and Teisseire, M.}, title = {Un système décisionnel pour l’analyse de la qualité des eaux de rivières}, title = {A decision-making system for the analysis of water quality of rivers}, journal = {Ingénierie des Systèmes d'Information}, volume = {20}, number = {3}, pages = { 143-167}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046020 / http://isi.revuesonline.com/article.jsp?articleId=20889}, doi = {http://dx.doi.org/10.3166/isi.20.3.143-167 }, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE TOURS FRA ; UNIVERSITE DE STRASBOURG FRA ; UNIVERSITE DE MONTPELLIER II UMR 5506 LIRMM MONTPELLIER FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; UNIVERSITE DE STRASBOURG FRA ; UNIVERSITE DE STRASBOURG FRA ; UNIVERSITE DE STRASBOURG FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; UNIVERSITE DE STRASBOURG FRA ; IRSTEA MONTPELLIER UMR TETIS FRA}, abstract = {Cet article décrit un système décisionnel développé pour permettre l’analyse des données concernant le fonctionnement des hydro-écosystèmes ; ces données sont nombreuses, diverses et issues de sources variées. Le système mis en place comporte une base de données intégrée, un entrepôt permettant l’exploration des dimensions associées aux données, et des outils de fouille permettant de répondre aux questions des hydro-écologues}, }
close
S. Bimonte, K. Boulil, A. Braud, S. Bringay, F. Cernesson, X. Dolques, M. Fabrègue, C. Grac, N. Lalande, F. Le Ber, M. Teisseire
A decisional system for analysing water quality of watercourses
Ingenierie des Systemes d'Information 20 (3), 2015
abs doi web bib

This article describes a decisional system developed to allow the analysis of data about hydro-ecosystem functioning; there are numerous and various data, from several sources. The implemented system includes an integrated database, a datawarehouse for exploring data dimensions, and data mining tools for answering hydroecologists' questions. / Cet article décrit un système décisionnel développé pour permettre l'analyse de données sur le fonctionnement des écosystèmes; Il existe de nombreuses et diverses données provenant de plusieurs sources. Le système implanté comprend une base de données intégrée, un datawarehouse pour explorer les dimensions des données et des outils de data mining pour répondre aux questions des hydroécologues.
close

@article{PUB00054282, author = {Bimonte, S. and Boulil, K. and Braud, A. and Bringay, S. and Cernesson, F. and Dolques, X. and Fabrègue, M. and Grac, C. and Lalande, N. and Le Ber, F. and Teisseire, M.}, title = {A decisional system for analysing water quality of watercourses}, journal = {Ingenierie des Systemes d'Information}, volume = {20}, number = {3}, pages = {143-167}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00054282 / https://www.scopus.com/inward/record.uri?eid=2-s2.0-84965133730&doi=10.3166%2fISI.20.3.143-167&partnerID=40&md5=1527e8545c46a9a5428db6983328664b}, doi = {http://dx.doi.org/10.3166/ISI.20.3.143-167}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; LI UNIVERSITE DE TOURS FRA ; ICUBE UNIVERSITE DE STRASBOURG ENGEES CNRS FRA ; UNIVERSITE DE MONTPELLIER II UMR 5506 LIRMM MONTPELLIER FRA ; AGROPARISTECH UMR TETIS MONTPELLIER FRA ; ICUBE UNIVERSITE DE STRASBOURG ENGEES CNRS FRA ; ICUBE UNIVERSITE DE STRASBOURG ENGEES CNRS FRA ; LIVE UNIVERSITE DE STRASBOURG ENGEES CNRS FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; ICUBE UNIVERSITE DE STRASBOURG ENGEES CNRS FRA ; -}, abstract = {This article describes a decisional system developed to allow the analysis of data about hydro-ecosystem functioning; there are numerous and various data, from several sources. The implemented system includes an integrated database, a datawarehouse for exploring data dimensions, and data mining tools for answering hydroecologists' questions. / Cet article décrit un système décisionnel développé pour permettre l'analyse de données sur le fonctionnement des écosystèmes; Il existe de nombreuses et diverses données provenant de plusieurs sources. Le système implanté comprend une base de données intégrée, un datawarehouse pour explorer les dimensions des données et des outils de data mining pour répondre aux questions des hydroécologues.}, }
close
K. Boulil, S. Bimonte, F Pinet
Conceptual model for spatial data cubes: A UML profile and its automatic implementation
Computer Standards & Interfaces 38, 2015
abs doi web bib

The increasing availability of geo-referenced data has increased the need to enrich OLAP with spatial analysis, leading to the concept of Spatial OLAP (SOLAP). The conceptual modelling of spatial data cubes requires the definition of two kinds of metadata: (i) warehouse metadata that model data structures that maintain integrated data from multiple data sources and (ii) aggregation1 metadata that specify how the warehoused data should be aggregated to meet the analysis goals of decision makers. In this paper we provide a review of existing conceptual spatial data cube models. We highlight some limits of these models concerning the aggregation model design, and their implementation in existing CASE tools and SOLAP architectures. Firstly, we propose a new UML (Unified Modeling Language) profile for modelling complex Spatial Data Warehouses and aggregations. Our profile is implemented in the MagicDraw CASE tool. Secondly, we propose a tool for the automatic implementation of conceptual spatial data cube models, designed using our profile, in a SOLAP architecture. In particular, our solution allows: (i) generating different logical representations of the SDW (Spatial Data Warehouse) model (star schema and snow-flake schema) and (ii) implementing complex SOLAP analysis indicators using MDX (MultiDimensional eXpressions language).
close

@article{PUB00046022, author = {Boulil, K. and Bimonte, S. and Pinet, F}, title = {Conceptual model for spatial data cubes: A UML profile and its automatic implementation}, title = {Modèle conceptuel de cubes de données spatiales : un profil UML et son application automatique}, journal = {Computer Standards & Interfaces}, volume = {38}, pages = {113-132}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046022}, doi = {http://dx.doi.org/10.1016/j.csi.2014.06.004}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {The increasing availability of geo-referenced data has increased the need to enrich OLAP with spatial analysis, leading to the concept of Spatial OLAP (SOLAP). The conceptual modelling of spatial data cubes requires the definition of two kinds of metadata: (i) warehouse metadata that model data structures that maintain integrated data from multiple data sources and (ii) aggregation1 metadata that specify how the warehoused data should be aggregated to meet the analysis goals of decision makers. In this paper we provide a review of existing conceptual spatial data cube models. We highlight some limits of these models concerning the aggregation model design, and their implementation in existing CASE tools and SOLAP architectures. Firstly, we propose a new UML (Unified Modeling Language) profile for modelling complex Spatial Data Warehouses and aggregations. Our profile is implemented in the MagicDraw CASE tool. Secondly, we propose a tool for the automatic implementation of conceptual spatial data cube models, designed using our profile, in a SOLAP architecture. In particular, our solution allows: (i) generating different logical representations of the SDW (Spatial Data Warehouse) model (star schema and snow-flake schema) and (ii) implementing complex SOLAP analysis indicators using MDX (MultiDimensional eXpressions language).}, }
close
E. Edoh-Alove, S. Bimonte, F. Pinet, Y. Bédard
New design approach to handle spatial vagueness in Spatial OLAP datacubes: Application to agri-environmental data
International Journal of Agricultural and Environmental Information Systems IJAEIS 6 (3), 2015
abs web bib

Spatial-OLAP (SOLAP) technologies are dedicated to multidimensional analysis of large volumes of (spatial) data. Spatial data are subject to different types of uncertainty, in particular spatial vagueness. Although several researches propose new models to cope with spatial vagueness, their integration in SOLAP systems is still in an embryonic state. Also, analyzing multidimensional data with metadata brought by the exploitation of the new models can be too complex and demanding for decision-makers. To help reduce spatial vagueness consequences on the exactness of SOLAP analysis queries, we present a new approach for designing SOLAP datacubes based on end-users' tolerance to the risks of misinterpretation of fact data. An experimentation of the new approach on agri-environmental data is also proposed
close

@article{PUB00045468, author = {Edoh-Alove, E. and Bimonte, S. and Pinet, F. and Bédard, Y.}, title = {New design approach to handle spatial vagueness in Spatial OLAP datacubes: Application to agri-environmental data}, title = {Une nouvelle approche de conception pour manipuler le vague spatial dans les cubes de données SOLAP : application aux données agri-environnementales}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {6}, number = {3}, pages = {34}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00045468}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE LAVAL CAN}, abstract = {Spatial-OLAP (SOLAP) technologies are dedicated to multidimensional analysis of large volumes of (spatial) data. Spatial data are subject to different types of uncertainty, in particular spatial vagueness. Although several researches propose new models to cope with spatial vagueness, their integration in SOLAP systems is still in an embryonic state. Also, analyzing multidimensional data with metadata brought by the exploitation of the new models can be too complex and demanding for decision-makers. To help reduce spatial vagueness consequences on the exactness of SOLAP analysis queries, we present a new approach for designing SOLAP datacubes based on end-users' tolerance to the risks of misinterpretation of fact data. An experimentation of the new approach on agri-environmental data is also proposed}, }
close
E. Edoh-Alove, S. Bimonte, F. Pinet
An UML profile and SOLAP datacubes multidimensional schemas transformation process for datacubes risk-aware design
International Journal of Data Warehousing and Mining 11 (4), 2015
abs web bib

Spatial Data Warehouses (SDWs) and Spatial On-Line Analytical Processing (SOLAP) systems are new technologies for the integration and the analysis of huge volume of data with spatial reference. Spatial vagueness is often neglected in these types of systems and the data and analysis results are considered reliable. In a previous work, we provided a new design method for SOLAP datacubes that allows the handling of vague spatial data analysis issues. The method consists of tailoring SOLAP datacubes schemas to end-users tolerance levels to identified potential risks of misinterpretation they encounter when exploiting datacubes containing vague spatial data. It this paper, we further our previous proposal by presenting different formal tools to support our method: It is an UML profile providing stereotypes needed to add vague, risks and tolerance levels information on datacubes schemas plus the formal definition of SOLAP datacubes schemas transformation process and functions.
close

@article{PUB00046021, author = {Edoh-Alove, E. and Bimonte, S. and Pinet, F.}, title = {An UML profile and SOLAP datacubes multidimensional schemas transformation process for datacubes risk-aware design}, title = {Un profile UML et un processus de transformation des schémas multidimensionnels SOLAP pour la conception des cubes SOLAP avec la prise en compte du risque}, journal = {International Journal of Data Warehousing and Mining}, volume = {11}, number = {4}, pages = {63-83}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046021}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data Warehouses (SDWs) and Spatial On-Line Analytical Processing (SOLAP) systems are new technologies for the integration and the analysis of huge volume of data with spatial reference. Spatial vagueness is often neglected in these types of systems and the data and analysis results are considered reliable. In a previous work, we provided a new design method for SOLAP datacubes that allows the handling of vague spatial data analysis issues. The method consists of tailoring SOLAP datacubes schemas to end-users tolerance levels to identified potential risks of misinterpretation they encounter when exploiting datacubes containing vague spatial data. It this paper, we further our previous proposal by presenting different formal tools to support our method: It is an UML profile providing stereotypes needed to add vague, risks and tolerance levels information on datacubes schemas plus the formal definition of SOLAP datacubes schemas transformation process and functions.}, }
close
M.A. Kang, M. Zaamoune, F. Pinet, S. Bimonte, P. Beaune
Performance optimization of grid aggregation in spatial data warehouses
International Journal of Digital Earth 8 (12), 2015
abs doi web bib

The problem of storage and querying of large volumes of spatial grids is an issue to solve. In this paper, we propose a method to optimize queries to aggregate raster grids stored in databases. In our approach, we propose to estimate the exact result rather than calculate the exact result. This approach reduces query execution time. One advantage of our method is that it does not require implementing or modifying functionalities of database management systems. Our approach is based on a new data structure and a specific model of SQL queries. Our work is applied here to relational data warehouses.
close

@article{PUB00042017, author = {Kang, M.A. and Zaamoune, M. and Pinet, F. and Bimonte, S. and Beaune, P.}, title = {Performance optimization of grid aggregation in spatial data warehouses}, title = {Optimisation des performances des agrégations de grilles dans les entrepôts de données spatiales }, journal = {International Journal of Digital Earth}, volume = {8}, number = {12}, pages = {970-988}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00042017}, doi = {http://dx.doi.org/10.1080/17538947.2014.962999}, year = {2015}, affiliation = {UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; AGAETIS CLERMONT FERRAND FRA }, abstract = {The problem of storage and querying of large volumes of spatial grids is an issue to solve. In this paper, we propose a method to optimize queries to aggregate raster grids stored in databases. In our approach, we propose to estimate the exact result rather than calculate the exact result. This approach reduces query execution time. One advantage of our method is that it does not require implementing or modifying functionalities of database management systems. Our approach is based on a new data structure and a specific model of SQL queries. Our work is applied here to relational data warehouses.}, }
close
Sautot L., S. Bimonte, L. Journaux, B. Faivre
Dimension enrichment with factual data during the design of multidimensional models: application to bird biodiversity
Lecture Notes in Business Information Processing 241, 2015
abs doi web bib

Data warehouses (DW) and OLAP systems are technologies allowing the on-line analysis of huge volume of data according to decision-makers' needs. Designing DW involves taking into account functional requirements and data sources (mixed design methodology). But, for complex applications, existing automatic design methodologies seem inecient. In some cases, decisionmakers need querying, as a dimension, data which have been defined as facts by actual automatic mixed approachs. Therefore, in this paper, we offer a new mixed renement methodology relevant to constellation multidimensional schema. The proposed methodolgy allows to decisionmakers to enrich a dimension with factual data. In order to validate our theoretical proposals, we have implemented an enrichment tool and we have tested it on a real case study from bird biodiversity
close

@article{PUB00046731, author = {Sautot, L., and Bimonte, S. and Journaux, L. and Faivre, B.}, title = {Dimension enrichment with factual data during the design of multidimensional models: application to bird biodiversity}, title = {Enrichissement de la dimension des données factuelles pour la conception de modèles multidimensionnels: application à la biodiversité des oiseaux }, journal = {Lecture Notes in Business Information Processing}, volume = {241}, pages = {280-299}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046731}, doi = {http://dx.doi.org/10.1007/978-3-319-29133-8_14}, year = {2015}, affiliation = {UNIVERSITE DE BOURGOGNE FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE BOURGOGNE FRA ; UNIVERSITE DE BOURGOGNE FRA}, abstract = {Data warehouses (DW) and OLAP systems are technologies allowing the on-line analysis of huge volume of data according to decision-makers' needs. Designing DW involves taking into account functional requirements and data sources (mixed design methodology). But, for complex applications, existing automatic design methodologies seem inecient. In some cases, decisionmakers need querying, as a dimension, data which have been defined as facts by actual automatic mixed approachs. Therefore, in this paper, we offer a new mixed renement methodology relevant to constellation multidimensional schema. The proposed methodolgy allows to decisionmakers to enrich a dimension with factual data. In order to validate our theoretical proposals, we have implemented an enrichment tool and we have tested it on a real case study from bird biodiversity}, }
close
S. Bimonte, K. Boulil, M. Pradel, G. André, J.P. Chanet
Analyse des indicateurs énergétiques des entreprises agricoles : une approche spatial OLAP
2014
abs doi web bib

Spatial data warehouses and Spatial OLAP systems are business solutions that can be used for environmental applications. Indeed, in order to better assess the impacts of human activities on the environment, many spatio-temporal data should be collected in order to calculate indicators at different levels of aggregation. Spatial OLAP tools are well adapted to analyze these indicators in a multi-dimensional way for identifying and implementing policies to improve practices in order to minimize impacts. In this study, we focus on farms energy consumption in order to identify the tasks and work environments that consume the most energy. We show how SOLAP tools can be used for the spatio-multidimensional analysis of these indicators, and the research issues related to agricultural data warehousing and analysis process.
close

@article{PUB00050618, author = {Bimonte, S. and Boulil, K. and Pradel, M. and André, G. and Chanet, J.P.}, title = {Analyse des indicateurs énergétiques des entreprises agricoles : une approche spatial OLAP}, pages = {37-65}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00050618}, doi = {http://dx.doi.org/10.3166/rig.24.37-65}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial data warehouses and Spatial OLAP systems are business solutions that can be used for environmental applications. Indeed, in order to better assess the impacts of human activities on the environment, many spatio-temporal data should be collected in order to calculate indicators at different levels of aggregation. Spatial OLAP tools are well adapted to analyze these indicators in a multi-dimensional way for identifying and implementing policies to improve practices in order to minimize impacts. In this study, we focus on farms energy consumption in order to identify the tasks and work environments that consume the most energy. We show how SOLAP tools can be used for the spatio-multidimensional analysis of these indicators, and the research issues related to agricultural data warehousing and analysis process.}, }
close
S. Bimonte, F. Pinet, M. Miralles, P. Papajorgji
Special section on "Spatial data warehouses and SOLAP"
Geoinformatica 18 (2), 2014
abs doi web bib

Data Warehouses (DW) and OnLine Analytical Processing (OLAP) tools are used in Business Intelligence (BI) applications in order to support decision-making processes. DWs are a specific type of database used to integrate, accumulate and analyze data from various sources. OLAP tools provide means to query and to analyze the warehoused information and produce online statistical summaries (indicators) at different levels of details. These indicators are computed using aggregate functions (e.g. Sum, Avg, Min, Max, etc.). Users can explore DWs by performing OLAP operations (e.g., Roll-up, Drill-down, etc.). Data mining algorithms can also be used in DWs, aiming towards improving data analysis; these techniques help to discern automatically the correlations and causal links between data. The increasing availability of geo-referenced data has made necessary the need to enrich OLAP with spatial analysis tools. OLAP systems were successfully adapted to solve problems in different areas of application and new kinds of decision support systems, named Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) tools have been made available. SDWs are a collection of geographical information supporting spatial analysis. SOLAP tools allow users to perform spatio-temporal exploration of data: these tools combine OLAP analysis with cartographic visualization capabilities of GIS systems. The relevance of SOLAP technology has been widely recognized in several application domains (e.g., marketing, agriculture, environmental risk management, etc.).
close

@article{PUB00000001, author = {Bimonte, S. and Pinet, F. and Miralles, M. and Papajorgji, P.}, title = {Special section on "Spatial data warehouses and SOLAP"}, title = {Section Spéciale sur les entrepôts de données spatiaux et le SOLAP}, journal = {Geoinformatica}, volume = {18}, number = {2}, pages = {269-272}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00000001}, doi = {http://dx.doi.org/10.1007/s10707-013-0196-9}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; CANADIAN INSTITUTE OF TECHNOLOGY TIRANA ALB}, abstract = {Data Warehouses (DW) and OnLine Analytical Processing (OLAP) tools are used in Business Intelligence (BI) applications in order to support decision-making processes. DWs are a specific type of database used to integrate, accumulate and analyze data from various sources. OLAP tools provide means to query and to analyze the warehoused information and produce online statistical summaries (indicators) at different levels of details. These indicators are computed using aggregate functions (e.g. Sum, Avg, Min, Max, etc.). Users can explore DWs by performing OLAP operations (e.g., Roll-up, Drill-down, etc.). Data mining algorithms can also be used in DWs, aiming towards improving data analysis; these techniques help to discern automatically the correlations and causal links between data. The increasing availability of geo-referenced data has made necessary the need to enrich OLAP with spatial analysis tools. OLAP systems were successfully adapted to solve problems in different areas of application and new kinds of decision support systems, named Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) tools have been made available. SDWs are a collection of geographical information supporting spatial analysis. SOLAP tools allow users to perform spatio-temporal exploration of data: these tools combine OLAP analysis with cartographic visualization capabilities of GIS systems. The relevance of SOLAP technology has been widely recognized in several application domains (e.g., marketing, agriculture, environmental risk management, etc.). }, }
close
S. Bimonte, M. Pradel, D. Boffety, A. Tailleur, G. André, R. Bzikaha, JP. Chanet
A new sensor-based Spatial OLAP architecture centered on an agricultural farm energy-use diagnosis
International Journal of Decision Support System Technology 5 (4), 2014
abs web bib

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.
close

@article{PUB00040803, author = {Bimonte, S. and Pradel, M. and Boffety, D. and Tailleur, A. and André, G. and Bzikaha, R. and Chanet, JP.}, title = {A new sensor-based Spatial OLAP architecture centered on an agricultural farm energy-use diagnosis}, title = {Une architecture SOLAP basé sur les capteurs et un outil ACV}, journal = {International Journal of Decision Support System Technology}, volume = {5}, number = {4}, pages = {1-20}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040803}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; ARVALIS INSTITUT DU VEGETAL LA CHAPELLE SAINT SAUVEUR FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {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.}, }
close
S. Bimonte, M. Kang, L. Paolino, M. Sebillo, M. Zaamoune, G. Vitiello
OLAPing Field Data: A theoretical and implementation framework
Fundamenta Informaticae 131, 2014
abs doi web bib

Integration of spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Usually, SOLAP models exploit discrete spatial data. Few works integrate continuous field data into dimensions and measures. In this paper, we provide a formal multidimensional model that supports measures and dimension as continuous field data, independently of their implementation. We provide also a proposal for a logical model allowing aggregation of field measures in a feasible ROLAP architecture.
close

@article{PUB00035375, author = {Bimonte, S. and Kang, M. and Paolino, L. and Sebillo, M. and Zaamoune, M. and Vitiello, G.}, title = {OLAPing Field Data: A theoretical and implementation framework}, title = {Analyse en ligne des données continues : un cadre théorique et d'implémentation}, journal = {Fundamenta Informaticae}, volume = {131}, pages = {1-25}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035375}, doi = {http://dx.doi.org/10.3233/FI-2012-0000}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; CNRS LIMOS UMR 6158 AUBIERE FRA ; UNIVERSITA DI SALERNO ITA ; UNIVERSITA DI SALERNO ITA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITA DI SALERNO ITA}, abstract = {Integration of spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Usually, SOLAP models exploit discrete spatial data. Few works integrate continuous field data into dimensions and measures. In this paper, we provide a formal multidimensional model that supports measures and dimension as continuous field data, independently of their implementation. We provide also a proposal for a logical model allowing aggregation of field measures in a feasible ROLAP architecture.}, }
close
S. Bimonte
A generic geovisualization model for spatial OLAP and its implementation in a standards-based architecture
Ingénierie des Systèmes d'Information, 2014
abs doi web bib

Spatial Data Warehouse (SDW) and Spatial On-Line Analytical Processing (SOLAP) systems are technologies intended to support geographic business intelligence. SOLAP clients provide a cartographic representation of facts on maps, and perform SOLAP operations through simple user interactions with the maps. Services are unassociated, loosely coupled units of functionality that are self-contained. A Service Oriented Architecture (SOA) is an architectural design pattern where each tier is defined by means of a set of web services. (Un)luckly, there is currently no standard approach to implement SOA solution for visualizing the results of SOLAP queries. Existing SOLAP clients are not flexible and provide closed ad-hoc implementation policies for the visualization of SOLAP queries, which is an important obstacle to interoperability. In this paper we propose a data model for the cartographic visualization of SOLAP queries. Based on this model, we present a new SOA architecture for SOLAP systems where the SOLAP client is totally based on standard data representations (e.g. XMLA, SLD, etc.), and cartographic visualization web services (XMLA, WMS, etc.).
close

@article{PUB00042045, author = {Bimonte, S.}, title = {A generic geovisualization model for spatial OLAP and its implementation in a standards-based architecture}, title = {Un modèle générique de geovisualisation pour le Spatial OLAP et son implémentation dans une architecture basée sur des standards}, journal = {Ingénierie des Systèmes d'Information}, number = {5}, pages = {97-118}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00042045}, doi = {http://dx.doi.org/DOI:10.3166/ISI.19.5.97-118}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data Warehouse (SDW) and Spatial On-Line Analytical Processing (SOLAP) systems are technologies intended to support geographic business intelligence. SOLAP clients provide a cartographic representation of facts on maps, and perform SOLAP operations through simple user interactions with the maps. Services are unassociated, loosely coupled units of functionality that are self-contained. A Service Oriented Architecture (SOA) is an architectural design pattern where each tier is defined by means of a set of web services. (Un)luckly, there is currently no standard approach to implement SOA solution for visualizing the results of SOLAP queries. Existing SOLAP clients are not flexible and provide closed ad-hoc implementation policies for the visualization of SOLAP queries, which is an important obstacle to interoperability. In this paper we propose a data model for the cartographic visualization of SOLAP queries. Based on this model, we present a new SOA architecture for SOLAP systems where the SOLAP client is totally based on standard data representations (e.g. XMLA, SLD, etc.), and cartographic visualization web services (XMLA, WMS, etc.).}, }
close
S. Bimonte, O. Boucelma, O. Machabert, S. Sellami
A generic Spatial OLAP model for evaluating natural hazards in a volunteered geographic information context
International Journal of Agricultural and Environmental Information Systems IJAEIS 5 (1), 2014
abs web bib

Spatial data warehouses (SDW) and spatial OLAP (SOLAP) systems are well-known business intelligence technologies that aim to support a multidimensional and online analysis for a large volume of geo-referenced datasets. SOLAP systems are already used in the context of natural hazards for analyzing sensor data and experts’ measurements. Recently, new data gathering tools coined as volunteered geographic information systems (VGI) have been adopted especially by non-expert users. Hence, (spatial) application development is facing a new challenge, which is the integration of expert-oriented data with citizen-provided data. In this paper, we propose a new generic spatio-multidimensional model based on the question/answer risk evaluation model that allows the integration of VGI data with classical SDW and SOLAP systems for the online analysis of natural hazards monitored by volunteers.
close

@article{PUB00043935, author = {Bimonte, S. and Boucelma, O. and Machabert, O. and Sellami, S.}, title = {A generic Spatial OLAP model for evaluating natural hazards in a volunteered geographic information context}, title = {Un modèle générique Spatial OLAP pour l'évaluation des risques naturels dans un contexte volontaire d'information géographique}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {5}, number = {1}, pages = {40-55}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00043935}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE AIX MARSEILLE FRA ; UNIVERSITE AIX MARSEILLE FRA ; UNIVERSITE AIX MARSEILLE FRA}, abstract = {Spatial data warehouses (SDW) and spatial OLAP (SOLAP) systems are well-known business intelligence technologies that aim to support a multidimensional and online analysis for a large volume of geo-referenced datasets. SOLAP systems are already used in the context of natural hazards for analyzing sensor data and experts’ measurements. Recently, new data gathering tools coined as volunteered geographic information systems (VGI) have been adopted especially by non-expert users. Hence, (spatial) application development is facing a new challenge, which is the integration of expert-oriented data with citizen-provided data. In this paper, we propose a new generic spatio-multidimensional model based on the question/answer risk evaluation model that allows the integration of VGI data with classical SDW and SOLAP systems for the online analysis of natural hazards monitored by volunteers.}, }
close
S. Bimonte, O. Boulcema, O Machabert, S. Sellami
A new Spatial OLAP approach for the analysis of volunteered geographic information
Computers Environment and Urban Systems 48, 2014
abs doi web bib

Volunteered Geographic Information (VGI) has great potential for enhancing analysts’ capabilities, assuming that VGI data quality issues, such as credibility and precision, are properly addressed. In this paper, we study the integration of VGI in Spatial OLAP (SOLAP) systems, which allow the integration and analysis of large volumes of good quality data. Using a real-world scenario, we highlight some similarities and differences among these two types of systems. We define a conceptual quality-oriented framework for warehousing and OLAPing VGI data. In particular, to address precision and credibility problems related to VGI data, we propose two new ETL operators: aggregation based on the VGI credibility and a filter based on the historical precision. We also define a new spatio-multidimensional model that provides decision makers with a global description of the quality of the aggregated data. To validate our proposal, we extend the classical relational SOLAP architecture using a standard VGI system.
close

@article{PUB00041340, author = {Bimonte, S. and Boulcema, O. and Machabert, O and Sellami, S.}, title = {A new Spatial OLAP approach for the analysis of volunteered geographic information}, title = {Une nouvelle approche Spatial OLAP pour l'analyse de données géographiques volontaires}, journal = {Computers Environment and Urban Systems}, volume = {48}, pages = {111-123}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041340}, doi = {http://dx.doi.org/10.1016/j.compenvurbsys.2014.07.006}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA}, abstract = {Volunteered Geographic Information (VGI) has great potential for enhancing analysts’ capabilities, assuming that VGI data quality issues, such as credibility and precision, are properly addressed. In this paper, we study the integration of VGI in Spatial OLAP (SOLAP) systems, which allow the integration and analysis of large volumes of good quality data. Using a real-world scenario, we highlight some similarities and differences among these two types of systems. We define a conceptual quality-oriented framework for warehousing and OLAPing VGI data. In particular, to address precision and credibility problems related to VGI data, we propose two new ETL operators: aggregation based on the VGI credibility and a filter based on the historical precision. We also define a new spatio-multidimensional model that provides decision makers with a global description of the quality of the aggregated data. To validate our proposal, we extend the classical relational SOLAP architecture using a standard VGI system.}, }
close
K. Boulil, S. Bimonte, F. Pinet
Spatial OLAP integrity constraints: From UML-Based specification to automatic implementation: Application to energetic data in agriculture
Journal of Decision Systems 23 (4), 2014
abs doi web bib

Spatial OLAP systems are Business Intelligence technologies allowing efficient and interactive analysis of large spatial data cubes. In this type of systems the correctness of analysis depends on: The warehoused data quality, how aggregations are performed and how data cubes are explored. In this paper we study quality control techniques (based on integrity constraints) related to exploration of spatial data cubes. We extend our UML framework previously proposed with a UML profile allowing the conceptual design of several classes of exploration integrity constraints. We also propose a tool for their automatic implementation. We validate our proposal in the context of a real case study concerning the analysis of energetic farm energetic indicators.
close

@article{PUB00040809, author = {Boulil, K. and Bimonte, S. and Pinet, F.}, title = {Spatial OLAP integrity constraints: From UML-Based specification to automatic implementation: Application to energetic data in agriculture}, title = {Contraintes d’intégrité SOLAP : du modèle UML à l’implémentation automatique}, journal = {Journal of Decision Systems}, volume = {23}, number = {4}, pages = {460-480}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040809}, doi = {http://dx.doi.org/10.1080/12460125.2014.934120}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial OLAP systems are Business Intelligence technologies allowing efficient and interactive analysis of large spatial data cubes. In this type of systems the correctness of analysis depends on: The warehoused data quality, how aggregations are performed and how data cubes are explored. In this paper we study quality control techniques (based on integrity constraints) related to exploration of spatial data cubes. We extend our UML framework previously proposed with a UML profile allowing the conceptual design of several classes of exploration integrity constraints. We also propose a tool for their automatic implementation. We validate our proposal in the context of a real case study concerning the analysis of energetic farm energetic indicators.}, }
close
K. Boulil, F. Le Ber, S. Bimonte, C. Grac, F. Cernesson
Multidimensional modeling and analysis of large and complex watercourse data: An OLAP-based solution
Ecological Informatics 24, 2014
abs doi web bib

This paper presents the application of Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to the field of water quality assessment. The European Water Framework Directive (DCE, 2000) underlined the necessity of having operational tools to help in the interpretation of the complex and abundant information regarding running waters and their functioning. Several studies have exemplified the interest in DWs for integrating large volumes of data and in OLAP tools for data exploration and analysis. Based on free software tools, we propose an extensible relational OLAP system for the analysis of physicochemical and hydrobiological watercourse data. This system includes: (i) two data cubes; (ii) an Extract, Transform and Load (ETL) tool for data integration; and (iii) tools for OLAP exploration. Many examples of OLAP analysis (thematic, temporal, spatiotemporal, and multiscale) are provided. We have extended an existing framework with complex aggregate functions that are used to define complex analysis indicators. Additional analysis dimensions are also introduced to allow their calculation and also for purposes of rendering information. Finally, we propose two strategies to address the problem of summarizing heterogeneous measurement units by: (i) transforming source data at the ETL tier, and (ii) introducing an additional analysis dimension at the OLAP server tier.
close

@article{PUB00041337, author = {Boulil, K. and Le Ber, F. and Bimonte, S. and Grac, C. and Cernesson, F.}, title = {Multidimensional modeling and analysis of large and complex watercourse data: An OLAP-based solution}, title = {Modelisation et analyse multidimensionnelle pour l'analyse des données des bassins versants}, journal = {Ecological Informatics}, volume = {24}, pages = {90-106}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041337}, doi = {http://dx.doi.org/10.1016/j.ecoinf.2014.07.001}, year = {2014}, affiliation = {UNIVERSITE DE STRASBOURG FRA ; UNIVERSITE DE STRASBOURG FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE STRASBOURG FRA ; AGROPARISTECH UMR TETIS MONTPELLIER FRA}, abstract = {This paper presents the application of Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to the field of water quality assessment. The European Water Framework Directive (DCE, 2000) underlined the necessity of having operational tools to help in the interpretation of the complex and abundant information regarding running waters and their functioning. Several studies have exemplified the interest in DWs for integrating large volumes of data and in OLAP tools for data exploration and analysis. Based on free software tools, we propose an extensible relational OLAP system for the analysis of physicochemical and hydrobiological watercourse data. This system includes: (i) two data cubes; (ii) an Extract, Transform and Load (ETL) tool for data integration; and (iii) tools for OLAP exploration. Many examples of OLAP analysis (thematic, temporal, spatiotemporal, and multiscale) are provided. We have extended an existing framework with complex aggregate functions that are used to define complex analysis indicators. Additional analysis dimensions are also introduced to allow their calculation and also for purposes of rendering information. Finally, we propose two strategies to address the problem of summarizing heterogeneous measurement units by: (i) transforming source data at the ETL tier, and (ii) introducing an additional analysis dimension at the OLAP server tier.}, }
close
E. Edoh-Alove, S. Bimonte, Y. Bedard, F. Pinet
A hybrid risk-aware design method for spatial datacubes handling spatial vague data: Implementation and validation
International Journal of Business Intelligence and Data Mining 9 (3), 2014
abs web bib

Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) are well-known Business Intelligence (BI) technologies that aim to support multidimensional and online analysis of huge volumes of data with spatial reference. Spatial vagueness is one of the most neglected imperfections of spatial data. Although several works propose new adhoc models for handling spatial vagueness, their implementation in Spatial Database Management Systems (DBMS) and SDW is still in an embryonic state. In this paper, we present a new design method for SOLAP datacubes that allows handling vague spatial data analysis issues. This method relies on a risk management method applied to the potential risks of data misinterpretation and decision-makers’ tolerance levels to those risks. We also present a tool implementing our method and a validation of the method is done based on the designed datacubes schemas testing.
close

@article{PUB00043932, author = {Edoh-Alove, E. and Bimonte, S. and Bedard, Y. and Pinet, F.}, title = {A hybrid risk-aware design method for spatial datacubes handling spatial vague data: Implementation and validation}, title = {Une méthode de conception hybride risque pour cubes de données spatiales spatiales: mise en ½uvre et validation}, journal = {International Journal of Business Intelligence and Data Mining}, volume = {9}, number = {3}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00043932}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE LAVAL CAN ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) are well-known Business Intelligence (BI) technologies that aim to support multidimensional and online analysis of huge volumes of data with spatial reference. Spatial vagueness is one of the most neglected imperfections of spatial data. Although several works propose new adhoc models for handling spatial vagueness, their implementation in Spatial Database Management Systems (DBMS) and SDW is still in an embryonic state. In this paper, we present a new design method for SOLAP datacubes that allows handling vague spatial data analysis issues. This method relies on a risk management method applied to the potential risks of data misinterpretation and decision-makers’ tolerance levels to those risks. We also present a tool implementing our method and a validation of the method is done based on the designed datacubes schemas testing.}, }
close
R. Perriot, J Pfeifer, L. Orazio, B. Bachelet, S. Bimonte, J. Darmont
Cost models for selecting materialized views in public clouds
International Journal of Data Warehousing and Mining 4 (1), 2014
abs web bib

Data warehouse performance is usually achieved through physical data structures such as indexes or materialized views. In this context, cost models can help select a relevant set of such performance optimization structures. Nevertheless, selection becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with monetary cost balancing overall query response time. This paper introduces new cost models that fit into the pay-as-you-go paradigm of cloud computing. Based on these cost models, an optimization problem is defined to discover, among candidate views, those to be materialized to minimize both the overall cost of using and maintaining the database in a public cloud and the total response time of a given query workload. We experimentally show that maintaining materialized views is always advantageous, both in terms of performance and cost.
close

@article{PUB00041333, author = {Perriot, R. and Pfeifer, J and Orazio, L. and Bachelet, B. and Bimonte, S. and Darmont, J.}, title = {Cost models for selecting materialized views in public clouds}, title = {Modèles de coûts pour la sélection des vues matérialisées dans les clouds publics}, journal = {International Journal of Data Warehousing and Mining}, volume = {4}, number = {1}, pages = {1-25}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041333}, year = {2014}, affiliation = {UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE LYON II FRA}, abstract = {Data warehouse performance is usually achieved through physical data structures such as indexes or materialized views. In this context, cost models can help select a relevant set of such performance optimization structures. Nevertheless, selection becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with monetary cost balancing overall query response time. This paper introduces new cost models that fit into the pay-as-you-go paradigm of cloud computing. Based on these cost models, an optimization problem is defined to discover, among candidate views, those to be materialized to minimize both the overall cost of using and maintaining the database in a public cloud and the total response time of a given query workload. We experimentally show that maintaining materialized views is always advantageous, both in terms of performance and cost.}, }
close
K. Boulil, F. Pinet, S. Bimonte, N. Carluer, C. Lauvernet, B. Cheviron, A. Miralles, J.P. Chanet
Guaranteeing the quality of multidimensional analysis in data warehouses of simulation results: application to pesticide transfer data produced by the MACRO Model
Ecological Informatics 16, 2013
abs web bib

Currently, the vital impact of environmental pollution on economic, social and health dimensions has been recognized. The need for theoretical and implementation frameworks for the acquisition, modeling and analysis of environmental data as well as tools to conceive and validate scenarios is becoming increasingly important. For these reasons, different environmental simulation models have been developed. Researchers and stakeholders need efficient tools to store, display, compare and analyze data that are produced by simulation models. One common way to manage simulation results is to use text files; however, text files make it difficult to explore the data. Spreadsheet tools (e.g., OpenOffice, MS Excel) can help to display and analyze model results, but they are not suitable for very large volumes of information. Recently, some studies have shown the feasibility of using Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to store model results and to facilitate model visualization, analysis and comparisons. These technologies allow model users to easily produce graphical reports and charts. In this paper, we address the analysis of pesticide transfer simulation results by warehousing and OLAPing data, for which the data results from the MACRO simulation model. This model simulates hydrological transfers of pesticides at the plot scale. We demonstrate how the simulation results can be managed using DW technologies. We also demonstrate how the use of integrity constraints can improve OLAP analysis. These constraints are used to maintain the quality of the warehoused data as well as to maintain the aggregations and queries, which will lead to better analysis, conclusions and decisions.
close

@article{PUB00038438, author = {Boulil, K. and Pinet, F. and Bimonte, S. and Carluer, N. and Lauvernet, C. and Cheviron, B. and Miralles, A. and Chanet, J.P.}, title = {Guaranteeing the quality of multidimensional analysis in data warehouses of simulation results: application to pesticide transfer data produced by the MACRO Model}, title = {Garantir la qualité de l'analyse multi-dimensionnelle dans les entrepôts de données de résultats de simulation : application aux données de transfert de pesticide produites par le modèle MACRO }, journal = {Ecological Informatics}, volume = {16}, pages = {41-52}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00038438 / http://www.sciencedirect.com/science/article/pii/S1574954113000307}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA LYON UR MALY FRA ; IRSTEA LYON UR MALY FRA ; IRSTEA MONTPELLIER UR IRMO UMR G-EAU FRA ; IRSTEA MONTPELLIER UR LCMO UMR TETIS FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Currently, the vital impact of environmental pollution on economic, social and health dimensions has been recognized. The need for theoretical and implementation frameworks for the acquisition, modeling and analysis of environmental data as well as tools to conceive and validate scenarios is becoming increasingly important. For these reasons, different environmental simulation models have been developed. Researchers and stakeholders need efficient tools to store, display, compare and analyze data that are produced by simulation models. One common way to manage simulation results is to use text files; however, text files make it difficult to explore the data. Spreadsheet tools (e.g., OpenOffice, MS Excel) can help to display and analyze model results, but they are not suitable for very large volumes of information. Recently, some studies have shown the feasibility of using Data Warehouse (DW) and On-Line Analytical Processing (OLAP) technologies to store model results and to facilitate model visualization, analysis and comparisons. These technologies allow model users to easily produce graphical reports and charts. In this paper, we address the analysis of pesticide transfer simulation results by warehousing and OLAPing data, for which the data results from the MACRO simulation model. This model simulates hydrological transfers of pesticides at the plot scale. We demonstrate how the simulation results can be managed using DW technologies. We also demonstrate how the use of integrity constraints can improve OLAP analysis. These constraints are used to maintain the quality of the warehoused data as well as to maintain the aggregations and queries, which will lead to better analysis, conclusions and decisions.}, }
close
H. Mahboubi, S. Bimonte, G. Deffuant, J.P. Chanet, F. Pinet
Semi-automatic design of spatial data cubes from simulation model results
International Journal of Data Warehousing and Mining 9 (1), 2013
abs doi web bib

In this paper we present a semi-automatic method for designing and generating spatial data cubes in order to visualize and analyze the results of simulation models. In our approach users choose their fact of analysis, then the system derives automatically a set of possible measures, dimensions of analysis, and generates the corresponding spatial data cubes. The analysis and visualization of the spatial data cubes are carried out using appropriate SOLAP tools. We also present the SimOLAP system, developed to validate our approach.
close

@article{PUB00037171, author = {Mahboubi, H. and Bimonte, S. and Deffuant, G. and Chanet, J.P. and Pinet, F.}, title = {Semi-automatic design of spatial data cubes from simulation model results}, title = {Conception semi automatique de cubes de données spatiales à partir de résultants de modèles de simulation }, journal = {International Journal of Data Warehousing and Mining}, volume = {9}, number = {1}, pages = {70-95}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00037171}, doi = {http://dx.doi.org/10.4018/jdwm.2013010104}, year = {2013}, affiliation = {OSIATIS GRENOBLE FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR LISC FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {In this paper we present a semi-automatic method for designing and generating spatial data cubes in order to visualize and analyze the results of simulation models. In our approach users choose their fact of analysis, then the system derives automatically a set of possible measures, dimensions of analysis, and generates the corresponding spatial data cubes. The analysis and visualization of the spatial data cubes are carried out using appropriate SOLAP tools. We also present the SimOLAP system, developed to validate our approach.}, }
close
S. Bimonte, M. Kang, M. Snoussi, O. Glorio, J. Trujillo
Un profil UML pour les entrepôts de données intégrant les réseaux spatiaux
Ingénierie des Systèmes d'Information 17 (1), 2012
abs web bib

Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems allow the storage and multidimensional analysis of huge volumes of geographic data. Existing SOLAP models do not take into account connectivity of spatial objects and consequently they do not natively integrate networks. In this paper, we propose a UML (Unified Modeling Language) profile for SDW integrating spatial networks. We implemented our UML profile using UML meta-model elements and OCL (Object Constraint Language) constraints with a Computer-Aided Software Engineering tool (MagicDraw). The implementation of the conceptual model in a database is presented using Oracle. / Les entrepôts de données spatiales (EDS) et les outils OLAP spatial (SOLAP) permettent le stockage et l'analyse multidimensionnelle d’une grande quantité de données géographiques. Les modèles existants SOLAP ne tiennent pas compte de la connectivité des objets spatiaux et par conséquent ils n’intègrent pas les données de type réseaux, comme les réseaux routiers et leurs méthodes d'analyse. Dans cet article, nous proposons un profil UML (Unified Modeling Language) pour les entrepôts de données intégrant des réseaux spatiaux. Nous mettons en ½oeuvre notre profil UML en se basant sur le méta-modèle d’UML et des contraintes OCL (Object Constraint Language) avec un atelier de génie logiciel (MagicDraw). Une implémentation du modèle conceptuel dans une base de données est présentée en utilisant Oracle.
close

@article{PUB00035347, author = {Bimonte, S. and Kang, M. and Snoussi, M. and Glorio, O. and Trujillo, J.}, title = {Un profil UML pour les entrepôts de données intégrant les réseaux spatiaux}, title = {A UML Profile for data warehouses integrating spatial networks}, journal = {Ingénierie des Systèmes d'Information}, volume = {17}, number = {1}, pages = {55-78}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035347}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE CLERMONT FERRAND II CNRS UMR 6158 LIMOS FRA ; UNIVERSITE DE GRENOBLE I UMR 5217 LIG LABORATOIRE D'INFORMATIQUE DE GRENOBLE FRA ; UNIVERSITY OF ALLICANTE ESP ; UNIVERSITY OF ALLICANTE ESP}, abstract = {Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems allow the storage and multidimensional analysis of huge volumes of geographic data. Existing SOLAP models do not take into account connectivity of spatial objects and consequently they do not natively integrate networks. In this paper, we propose a UML (Unified Modeling Language) profile for SDW integrating spatial networks. We implemented our UML profile using UML meta-model elements and OCL (Object Constraint Language) constraints with a Computer-Aided Software Engineering tool (MagicDraw). The implementation of the conceptual model in a database is presented using Oracle. / Les entrepôts de données spatiales (EDS) et les outils OLAP spatial (SOLAP) permettent le stockage et l'analyse multidimensionnelle d’une grande quantité de données géographiques. Les modèles existants SOLAP ne tiennent pas compte de la connectivité des objets spatiaux et par conséquent ils n’intègrent pas les données de type réseaux, comme les réseaux routiers et leurs méthodes d'analyse. Dans cet article, nous proposons un profil UML (Unified Modeling Language) pour les entrepôts de données intégrant des réseaux spatiaux. Nous mettons en ½oeuvre notre profil UML en se basant sur le méta-modèle d’UML et des contraintes OCL (Object Constraint Language) avec un atelier de génie logiciel (MagicDraw). Une implémentation du modèle conceptuel dans une base de données est présentée en utilisant Oracle. }, }
close
S. Bimonte, M. Bertolotto, J. Gensel, O. Bossuaid
Spatial OLAP and map generalization: Model and algebra
International Journal of Data Warehousing and Mining 8 (1), 2012
abs doi web bib

Map generalization can be used as a central component of spatial decision support systems to provide a simplified and more readable cartographic visualization of geographic information. Indeed, it supports the user mental process for discovering important and unknown geospatial relations, trends and patterns. Spatial OLA (SOLAP)integrates spatial data into OLAP and data warehouse systems. SOLAP models and tools are based on the concepts of spatial dimensions and measures that represent the axes and the subjects of the spatio-multidimensional analysis. Although powerful under some respect, current SOLAP models cannot support map generalization capabilities. This paper provides the first effort to integrate map generalization and OLAP. Firstly we define all modeling and querying requirements to do this integration, and then we present a SOLAP model and algebra that support map generalization concepts. Our approach extends SOLAP spatial hierarchies introducing multi-association relationships, supports imprecise measures, and it takes into account spatial dimensions constraints generated by multiple map generalization hierarchies.
close

@article{PUB00033114, author = {Bimonte, S. and Bertolotto, M. and Gensel, J. and Bossuaid, O.}, title = {Spatial OLAP and map generalization: Model and algebra}, title = {OLAP spatial et généralisation cartographique : un modèle et un algèbre }, journal = {International Journal of Data Warehousing and Mining}, volume = {8}, number = {1}, pages = {41}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00033114}, doi = {http://dx.doi.org/10.4018/jdwm.2012010102}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITY COLLEGE DUBLIN IRL ; LABORATOIRE INFORMATIQUE GRENOBLE FRA ; UNIVERSITE DE LYON II FRA}, abstract = {Map generalization can be used as a central component of spatial decision support systems to provide a simplified and more readable cartographic visualization of geographic information. Indeed, it supports the user mental process for discovering important and unknown geospatial relations, trends and patterns. Spatial OLA (SOLAP)integrates spatial data into OLAP and data warehouse systems. SOLAP models and tools are based on the concepts of spatial dimensions and measures that represent the axes and the subjects of the spatio-multidimensional analysis. Although powerful under some respect, current SOLAP models cannot support map generalization capabilities. This paper provides the first effort to integrate map generalization and OLAP. Firstly we define all modeling and querying requirements to do this integration, and then we present a SOLAP model and algebra that support map generalization concepts. Our approach extends SOLAP spatial hierarchies introducing multi-association relationships, supports imprecise measures, and it takes into account spatial dimensions constraints generated by multiple map generalization hierarchies.}, }
close
K. Boulil, S. Bimonte, F. Pinet
Un modèle UML et des contraintes OCL pour les entrepôts de données spatiales : de la représentation conceptuelle à l'implémentation
Ingénierie des Systèmes d'Information 16 (6), 2011
abs doi web bib

Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems represent an effec-tive solution to perform spatial analysis on geographical phenomena. However, the quality of such analysis heavily depends on the quality of stored data and how these data are explored: how the different indicators are computed (What aggregate functions are applied to summa-rize the measures and in what order these functions are applied?). In this context, a number of studies have been attempted to address the issues of data quality in SDW by using Integ-rity Constraints (IC). In this paper, motivated by the lack of Model Driven Architecture (MDA)-based implementations, we propose a conceptual framework based on two new clas-sifications to ease identification and implementation of SDW IC. Moreover, following an MDA approach, we propose the MDA-based modeling of most IC categories using the UML (Unified Modeling Language) and OCL (Object Constraint Language) standard languages; and show the automatic implementation of some IC classes using an MDA-based code gen-erator, called Spatial OCL2SQL. / Les Entrepôts de Données Spatiales (EDS) et les systèmes SOLAP représentent une solution efficace pour l'analyse spatiale de phénomènes géographiques. Cependant, la qualité de cette analyse dépend fortement de la qualité des données entreposées et de la manière dont l'exploration de ces données est réalisée : comment les différents indicateurs ou agrégats sont calculés ? (i.e. quels opérateurs d'agrégation sont appliqués aux différentes mesures ? Et dans quel ordre ils sont appliqués ?). Dans ce contexte, quelques travaux essaient de mieux maîtriser la qualité des informations dans les entrepôts de données (spatiales) par exemple par le biais de contraintes d'intégrité. Dans cet article, motivé par le manque d'implémentations basées sur une approche MDA (Model Driven Architecture), nous proposons un «framework» conceptuel basé sur deux nouvelles classifications pour faciliter l'identification et l'implémentation des contraintes d'EDS ; dans le cadre de l'approche MDA, nous proposons la modélisation et l'implémentation de la plupart des types de contraintes en utilisant les standards UML(Unified Modeling Language) et OCL (Object Constraint Language), et le générateur de code Spatial OCL2SQL.
close

@article{PUB00031873, author = {Boulil, K. and Bimonte, S. and Pinet, F.}, title = {Un modèle UML et des contraintes OCL pour les entrepôts de données spatiales : de la représentation conceptuelle à l'implémentation }, title = {A UML Model and OCL constraints for spatial data warehouses: From the conceptual design to the implementation }, journal = {Ingénierie des Systèmes d'Information}, volume = {16}, number = {6}, pages = {11-39}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00031873}, doi = {http://dx.doi.org/doi:10.3166/isi.16.6.11-39 }, year = {2011}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems represent an effec-tive solution to perform spatial analysis on geographical phenomena. However, the quality of such analysis heavily depends on the quality of stored data and how these data are explored: how the different indicators are computed (What aggregate functions are applied to summa-rize the measures and in what order these functions are applied?). In this context, a number of studies have been attempted to address the issues of data quality in SDW by using Integ-rity Constraints (IC). In this paper, motivated by the lack of Model Driven Architecture (MDA)-based implementations, we propose a conceptual framework based on two new clas-sifications to ease identification and implementation of SDW IC. Moreover, following an MDA approach, we propose the MDA-based modeling of most IC categories using the UML (Unified Modeling Language) and OCL (Object Constraint Language) standard languages; and show the automatic implementation of some IC classes using an MDA-based code gen-erator, called Spatial OCL2SQL. / Les Entrepôts de Données Spatiales (EDS) et les systèmes SOLAP représentent une solution efficace pour l'analyse spatiale de phénomènes géographiques. Cependant, la qualité de cette analyse dépend fortement de la qualité des données entreposées et de la manière dont l'exploration de ces données est réalisée : comment les différents indicateurs ou agrégats sont calculés ? (i.e. quels opérateurs d'agrégation sont appliqués aux différentes mesures ? Et dans quel ordre ils sont appliqués ?). Dans ce contexte, quelques travaux essaient de mieux maîtriser la qualité des informations dans les entrepôts de données (spatiales) par exemple par le biais de contraintes d'intégrité. Dans cet article, motivé par le manque d'implémentations basées sur une approche MDA (Model Driven Architecture), nous proposons un «framework» conceptuel basé sur deux nouvelles classifications pour faciliter l'identification et l'implémentation des contraintes d'EDS ; dans le cadre de l'approche MDA, nous proposons la modélisation et l'implémentation de la plupart des types de contraintes en utilisant les standards UML(Unified Modeling Language) et OCL (Object Constraint Language), et le générateur de code Spatial OCL2SQL.}, }
close
L. D'Orazio, S. Bimonte
Entreposage et analyse en ligne dans les nuages avec Pig
Ingénierie des Systèmes d'Information 16 (6), Ed. Hermès Lavoisier, 2011
abs doi web bib

Data warehouses and OLAP systems are decision support technologies for online analysis of large volumes of data. Cloud computing, driven by large companies such as Google, Microsoft or Amazon, has recently attracted attention. Consider analysis OLAP and data warehousing in such infrastructure becomes a major issue. The problems to be considered are those of conventional systems widely distributed (query large volumes of data, semantic and structural heterogeneity or variability), but from a new point of view that takes into account the particularities of these architectures: pay as you go model, elasticity and user-friendliness. In this paper, we initially investigate data warehouse storage issues. We propose to use multidimensional arrays for the storage of cloud-based data warehouses. Then, we focus on OLAP analysis by proposing new operators and optimization rules. Initial experiments show the value of our contributions. Finally, we list research perspectives on the definition of a theoretical framework and implementation for multidimensional storage and online analysis in the clouds. / Les entrepôts de données et les systèmes OLAP sont des technologies d'aide à la décision qui permettent d'analyser à la volée de gros volumes de données. L'informatique dans les nuages, sous l'impulsion des grandes compagnies telles que Google, Microsoft ou encore Amazon, a récemment suscité une attention particulière. Considérer l'analyse OLAP et l'entreposage de données au sein de telles infrastructures devient alors un enjeu majeur. Les problèmes devant être considérés sont ceux classiques des systèmes largement distribués (interrogation de gros volumes de données, hétérogénéité sémantique et structurelle ou encore variabilité), mais d'un nouveau point de vue devant considérer les spécificités de ces architectures : facturation à l'utilisation, élasticité et facilité d'utilisation. Dans ce papier, nous abordons dans un premier temps les règles de facturation à l'utilisation pour le stockage des entrepôts de données. Nous proposons d'utiliser des techniques de stockage pour nuages à base de tableaux multidimensionnels. Ensuite, nous nous intéressons à l'analyse OLAP en proposant de nouveaux opérateurs et des règles d'optimisation. De premières expérimentations montrent l'intérêt de nos contributions. Enfin, nous listons des perspectives de recherche concernant la définition d'un cadre théorique et d'implémentation pour l'entreposage et l'analyse en ligne dans les nuages.
close

@article{PUB00033256, author = {D'Orazio, L. and Bimonte, S.}, title = {Entreposage et analyse en ligne dans les nuages avec Pig}, title = {Warehousing and OLAP on clouds with Pig}, journal = {Ingénierie des Systèmes d'Information}, volume = {16}, number = {6}, publisher = {Ed. Hermès Lavoisier}, pages = {139-162}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00033256}, doi = {http://dx.doi.org/doi:10.3166/isi.16.6.139-162 }, year = {2011}, affiliation = {LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Data warehouses and OLAP systems are decision support technologies for online analysis of large volumes of data. Cloud computing, driven by large companies such as Google, Microsoft or Amazon, has recently attracted attention. Consider analysis OLAP and data warehousing in such infrastructure becomes a major issue. The problems to be considered are those of conventional systems widely distributed (query large volumes of data, semantic and structural heterogeneity or variability), but from a new point of view that takes into account the particularities of these architectures: pay as you go model, elasticity and user-friendliness. In this paper, we initially investigate data warehouse storage issues. We propose to use multidimensional arrays for the storage of cloud-based data warehouses. Then, we focus on OLAP analysis by proposing new operators and optimization rules. Initial experiments show the value of our contributions. Finally, we list research perspectives on the definition of a theoretical framework and implementation for multidimensional storage and online analysis in the clouds. / Les entrepôts de données et les systèmes OLAP sont des technologies d'aide à la décision qui permettent d'analyser à la volée de gros volumes de données. L'informatique dans les nuages, sous l'impulsion des grandes compagnies telles que Google, Microsoft ou encore Amazon, a récemment suscité une attention particulière. Considérer l'analyse OLAP et l'entreposage de données au sein de telles infrastructures devient alors un enjeu majeur. Les problèmes devant être considérés sont ceux classiques des systèmes largement distribués (interrogation de gros volumes de données, hétérogénéité sémantique et structurelle ou encore variabilité), mais d'un nouveau point de vue devant considérer les spécificités de ces architectures : facturation à l'utilisation, élasticité et facilité d'utilisation. Dans ce papier, nous abordons dans un premier temps les règles de facturation à l'utilisation pour le stockage des entrepôts de données. Nous proposons d'utiliser des techniques de stockage pour nuages à base de tableaux multidimensionnels. Ensuite, nous nous intéressons à l'analyse OLAP en proposant de nouveaux opérateurs et des règles d'optimisation. De premières expérimentations montrent l'intérêt de nos contributions. Enfin, nous listons des perspectives de recherche concernant la définition d'un cadre théorique et d'implémentation pour l'entreposage et l'analyse en ligne dans les nuages.}, }
close
H. Mahboubi, S. Bimonte, G. Deffuant
Analyzing demographic and economic simulation model results: a semi-automatic spatial OLAP approach
Lecture Notes in Computer Science 6782, 2011
abs doi web bib

In this paper, we present a semi-automatic SOLAP approach specially dedicated to the analysis of spatial model simulation results. We illustrate it on demographic and economic data of rural municipalities resulting from a model developed in the context of the european project PRIMA.
close

@article{PUB00033066, author = {Mahboubi, H. and Bimonte, S. and Deffuant, G.}, title = {Analyzing demographic and economic simulation model results: a semi-automatic spatial OLAP approach}, title = {Analyse des résultats de modèles de simulation démographiques et économiques : une approche OLAP Spatial semi-automatique }, journal = {Lecture Notes in Computer Science}, volume = {6782}, pages = {17-31}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00033066}, doi = {http://dx.doi.org/10.1007/978-3-642-21928-3_2}, year = {2011}, affiliation = {CEMAGREF CLERMONT FERRAND UR LISC FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR LISC FRA}, abstract = {In this paper, we present a semi-automatic SOLAP approach specially dedicated to the analysis of spatial model simulation results. We illustrate it on demographic and economic data of rural municipalities resulting from a model developed in the context of the european project PRIMA.}, }
close
F. Pinet, M.A. Kang, K. Boulil, S. Bimonte, G. De Sousa, C. Roussey, M. Schneider, J.P. Chanet
Using OCL to model constraints in data warehouses
International Journal of Technology Diffusion 2 (3), 2011
abs doi web bib

Recent research works propose to use the Object-Oriented (OO) approach such as UML to model data warehouses. First, the present paper overviews these recent OO techniques. They aim to describe the facts and the different analysis dimensions of the data. Second, we will propose a tutorial of the Object Constraint Language (OCL) and we will show how this language can be used to specify constraints in OO-based models of data warehouse. Up to now, OCL has been only applied to describe constraints in software applications and transactional databases. So, we demonstrate in this paper how to use OCL to represent the different types of data warehouse constraints. Our paper is addressed to researchers working in the fields of business intelligence and decision support systems, who wish to learn about the major possibilities that OCL offer in the context of data warehouse, and to find citations that will allow them to learn about this formalism in greater detail. We also provide general information about the possible types of implementation of multi-dimensional models and their constraints.
close

@article{PUB00034693, author = {Pinet, F. and Kang, M.A. and Boulil, K. and Bimonte, S. and De Sousa, G. and Roussey, C. and Schneider, M. and Chanet, J.P.}, title = {Using OCL to model constraints in data warehouses}, title = {Utilisation d'OCL pour modéliser les contraintes dans les entrepôts de données}, journal = {International Journal of Technology Diffusion}, volume = {2}, number = {3}, pages = {11}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00034693}, doi = {http://dx.doi.org/10.4018/jtd.2011070104}, year = {2011}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE CLERMONT FERRAND LIMOS ISIMA AUBIERE FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE CLERMONT FERRAND LIMOS ISIMA AUBIERE FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Recent research works propose to use the Object-Oriented (OO) approach such as UML to model data warehouses. First, the present paper overviews these recent OO techniques. They aim to describe the facts and the different analysis dimensions of the data. Second, we will propose a tutorial of the Object Constraint Language (OCL) and we will show how this language can be used to specify constraints in OO-based models of data warehouse. Up to now, OCL has been only applied to describe constraints in software applications and transactional databases. So, we demonstrate in this paper how to use OCL to represent the different types of data warehouse constraints. Our paper is addressed to researchers working in the fields of business intelligence and decision support systems, who wish to learn about the major possibilities that OCL offer in the context of data warehouse, and to find citations that will allow them to learn about this formalism in greater detail. We also provide general information about the possible types of implementation of multi-dimensional models and their constraints.}, }
close
S. Bimonte, A. Tchounikine, M. Miquel, F. Pinet
When spatial analysis meets OLAP: multidimensional model and operators
International Journal of Data Warehousing and Mining 6 (4), 2010
abs web bib

Introducing spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Existing SOLAP models do not completely integrate the semantic component of geographic information (alphanumeric attributes and relationships) or the flexibility of spatial analysis into multidimensional analysis. In this paper, the authors propose the GeoCube model and its associated operators to overcome these limitations. GeoCube enriches the SOLAP concepts of spatial measure and spatial dimension and take into account the semantic component of geographic information. The authors define geographic measures and dimensions as geographic and/or complex objects belonging to hierarchy schemas. GeoCube's algebra extends SOLAP operators with five new operators, i.e., Classify, Specialize, Permute, OLAP-Buffer and OLAP-Overlay. In addition to classical drill-and-slice OLAP operators, GeoCube provides two operators for navigating the hierarchy of the measures, and two spatial analysis operators that dynamically modify the structure of the geographic hypercube. Finally, to exploit the symmetrical representation of dimensions and measures, GeoCube provides an operator capable of permuting dimension and measure. In this paper, GeoCube is presented using environmental data on the pollution of the Venetian Lagoon.
close

@article{PUB00029287, author = {Bimonte, S. and Tchounikine, A. and Miquel, M. and Pinet, F.}, title = {When spatial analysis meets OLAP: multidimensional model and operators}, title = {Quand l'analyse spatiale rencontre l'OLAP : des opérateurs et un modèle multidimensionnel}, journal = {International Journal of Data Warehousing and Mining}, volume = {6}, number = {4}, pages = {33-60}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029287}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE LYON CNRS LIRIS FRA ; UNIVERSITE DE LYON CNRS LIRIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Introducing spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Existing SOLAP models do not completely integrate the semantic component of geographic information (alphanumeric attributes and relationships) or the flexibility of spatial analysis into multidimensional analysis. In this paper, the authors propose the GeoCube model and its associated operators to overcome these limitations. GeoCube enriches the SOLAP concepts of spatial measure and spatial dimension and take into account the semantic component of geographic information. The authors define geographic measures and dimensions as geographic and/or complex objects belonging to hierarchy schemas. GeoCube's algebra extends SOLAP operators with five new operators, i.e., Classify, Specialize, Permute, OLAP-Buffer and OLAP-Overlay. In addition to classical drill-and-slice OLAP operators, GeoCube provides two operators for navigating the hierarchy of the measures, and two spatial analysis operators that dynamically modify the structure of the geographic hypercube. Finally, to exploit the symmetrical representation of dimensions and measures, GeoCube provides an operator capable of permuting dimension and measure. In this paper, GeoCube is presented using environmental data on the pollution of the Venetian Lagoon.}, }
close
S. Bimonte, M. Schneider, F. Pinet, J.P. Chanet
Overlay-Drill across: a new drill across operator for spatial data warehouses
Journal of Decision Systems 19 (3), 2010
abs web bib

Spatial OLAP (SOLAP) integrates spatial data into OLAP and Data warehouse systems to exploit analysis capabilities associated to geographic information. SOLAP extends OLAP operators to navigate into spatial dimensions, and to cut the spatial data warehouse using spatial predicates. Integration of several heterogeneous spatial data warehouses is very useful for decision-makers since they can navigate into multiple data sources. In this paper, exploiting the continuous dimension of spatial data, we propose a new operator to merge spatial data warehouses without conformed spatial dimensions. This operator is based on the spatial analysis transformation called Overlay. We show its implementation in the Web-based SOLAP System GeWOlap.
close

@article{PUB00029285, author = {Bimonte, S. and Schneider, M. and Pinet, F. and Chanet, J.P.}, title = {Overlay-Drill across: a new drill across operator for spatial data warehouses}, title = {Forage de superposition : un nouvel opérateur de forage pour les entrepôts de données spatiales}, journal = {Journal of Decision Systems}, volume = {19}, number = {3}, pages = {261-290}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029285}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial OLAP (SOLAP) integrates spatial data into OLAP and Data warehouse systems to exploit analysis capabilities associated to geographic information. SOLAP extends OLAP operators to navigate into spatial dimensions, and to cut the spatial data warehouse using spatial predicates. Integration of several heterogeneous spatial data warehouses is very useful for decision-makers since they can navigate into multiple data sources. In this paper, exploiting the continuous dimension of spatial data, we propose a new operator to merge spatial data warehouses without conformed spatial dimensions. This operator is based on the spatial analysis transformation called Overlay. We show its implementation in the Web-based SOLAP System GeWOlap.}, }
close
S. Bimonte
A Web system for spatio-multidimensional analysis of geographic and complex data
International Journal of Agricultural and Environmental Information Systems IJAEIS 1 (2), 2010
abs doi web bib

Spatial OLAP (SOLAP) integrates spatial data into OLAP systems. SOLAP models define spatial dimensions and measures and spatio-multidimensional operators. In this paper we present the concepts of geographic and complex measures that allow for integrating geographic and complex information as subjects of analysis in spatial data warehouses. The concept of geographic measure extends the concept of spatial measure to the semantic component of geographic information. The concept of complex measure allows us to introduce complex data as subjects of multidimensional analysis. In order to reduce the gap in flexibility between spatial and multidimensional analysis, we first propose a symetrical representation of measures and dimensions. Then, we present a Web-based SOLAP prototype, GeWOlap, that enriches existing SOLAP tools by effectively and easily supporting symetrical geographic/complex measures and dimensions for modeling and visualization.
close

@article{PUB00027807, author = {Bimonte, S.}, title = {A Web system for spatio-multidimensional analysis of geographic and complex data}, title = {Un système WEB pour l'analyse spatio-multidimensionnelle de données géographiques et complexes}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {1}, number = {2}, pages = {42-67}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00027807}, doi = {http://dx.doi.org/10.4018/jaeis.2010070103}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial OLAP (SOLAP) integrates spatial data into OLAP systems. SOLAP models define spatial dimensions and measures and spatio-multidimensional operators. In this paper we present the concepts of geographic and complex measures that allow for integrating geographic and complex information as subjects of analysis in spatial data warehouses. The concept of geographic measure extends the concept of spatial measure to the semantic component of geographic information. The concept of complex measure allows us to introduce complex data as subjects of multidimensional analysis. In order to reduce the gap in flexibility between spatial and multidimensional analysis, we first propose a symetrical representation of measures and dimensions. Then, we present a Web-based SOLAP prototype, GeWOlap, that enriches existing SOLAP tools by effectively and easily supporting symetrical geographic/complex measures and dimensions for modeling and visualization.}, }
close
K. Boulil, S. Bimonte, H. Mahboubi, F. Pinet
Vers la définition des contraintes d'intégrité d'entrepôts de données spatiales avec OCL
Revue des Nouvelles Technologies de l'Information B6, 2010
abs web bib

Les Entrepôts de Données Spatiales (EDS) et les systèmes SOLAP représentent une solution efficace pour l'analyse spatiale de phénomènes géographiques. Cependant, la qualité de cette analyse dépend fortement de la qualité des données stockées. Dans ce contexte, quelques travaux se sont intéressés à la définition et la spécification des contraintes d'intégrité spécifiques aux EDS. Dans cet article, motivé par le manque d'implémentation basée sur une approche MDA (Model Driven Approach), nous proposons deux classifications de contraintes d'EDS ainsi que leurs spécifications et implémentations en utilisant le standard OMG OCL (Object Constraint Language).
close

@article{PUB00029286, author = {Boulil, K. and Bimonte, S. and Mahboubi, H. and Pinet, F.}, title = {Vers la définition des contraintes d'intégrité d'entrepôts de données spatiales avec OCL}, title = {Towards the definition of integrity constraints of spatial data warehouses with OCL}, journal = {Revue des Nouvelles Technologies de l'Information}, volume = {B6}, pages = {121-136}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029286 / http://www.cepadues.com/docs/942/RNTI%20B-6%20EDA10.pdf}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Les Entrepôts de Données Spatiales (EDS) et les systèmes SOLAP représentent une solution efficace pour l'analyse spatiale de phénomènes géographiques. Cependant, la qualité de cette analyse dépend fortement de la qualité des données stockées. Dans ce contexte, quelques travaux se sont intéressés à la définition et la spécification des contraintes d'intégrité spécifiques aux EDS. Dans cet article, motivé par le manque d'implémentation basée sur une approche MDA (Model Driven Approach), nous proposons deux classifications de contraintes d'EDS ainsi que leurs spécifications et implémentations en utilisant le standard OMG OCL (Object Constraint Language).}, }
close
H. Mahboubi, T. Faure, S. Bimonte, G. Deffuant, J.P. Chanet, F. Pinet
A multidimensional model for data warehouses of simulation results
International Journal of Agricultural and Environmental Information Systems IJAEIS 1 (2), 2010
abs doi web bib

This paper deals with the multidimensional modeling of a data warehouse for simulation results. It aims at answering new needs for data management which appear when exploring complex simulation models. Indeed, testing different parameter values and different versions of such models produces a huge volume of data, especially when simulations cover long time periods. These data must often be studied extensively at different levels of aggregation. We propose a generic multidimensional schema to analyze the results of a simulation model. This schema can guide modelers in designing specific data warehouses. We also propose an adaptation of an OLAP client tool in order to provide an adequate visualization of data. As an example, we implement a data warehouse for the analysis of results produced from a savanna simulation model, using a Relational OLAP architecture.
close

@article{PUB00029041, author = {Mahboubi, H. and Faure, T. and Bimonte, S. and Deffuant, G. and Chanet, J.P. and Pinet, F.}, title = {A multidimensional model for data warehouses of simulation results }, title = {Un modèle multidimensionnel pour les entrepôts de résultats de simulation}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {1}, number = {2}, pages = {1-19}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029041}, doi = {http://dx.doi.org/10.4018/jaeis.2010070101}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR LISC FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR LISC FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {This paper deals with the multidimensional modeling of a data warehouse for simulation results. It aims at answering new needs for data management which appear when exploring complex simulation models. Indeed, testing different parameter values and different versions of such models produces a huge volume of data, especially when simulations cover long time periods. These data must often be studied extensively at different levels of aggregation. We propose a generic multidimensional schema to analyze the results of a simulation model. This schema can guide modelers in designing specific data warehouses. We also propose an adaptation of an OLAP client tool in order to provide an adequate visualization of data. As an example, we implement a data warehouse for the analysis of results produced from a savanna simulation model, using a Relational OLAP architecture.}, }
close
S. Di Martino, S. Bimonte, M. Bertolotto, F. Ferrucci
Integrating Google Earth within OLAP Tools for Multidimensional Exploration and Analysis of Spatial Data
11th International Enterprise Information Systems Conference, ICEIS 2009, 06/05/2009-10/05/2009, Milano, ITA (p. 940-951), Lecture Notes in Business Information Processing 24, Springer, Berlin Heidelberg DEU, 2009
abs doi web bib

Spatial OnLine Analytical Processing solutions are a type of Business Information Tool meant to support a decision maker in extracting hidden knowledge from data warehouses containing spatial data. To date, very few SOLAP tools are available, each presenting some drawbacks reducing their flexibility. To overcome these limitations, we have developed a web-based SOLAP tool, obtained by suitably integrating into an ad-hoc architecture the Geobrowser Google Earth with a freely available OLAP engine, namely Mondrian. As a consequence, a decision maker can perform exploration and analysis of spatial data both through the Geobrowser and a Pivot Table in a seamlessly fashion. In this paper, we illustrate the main features of the system we have developed, together with the underlying architecture, using a simulated case study.
close

@article{PUB00026838, author = {Di Martino, S. and Bimonte, S. and Bertolotto, M. and Ferrucci, F.}, title = {Integrating Google Earth within OLAP Tools for Multidimensional Exploration and Analysis of Spatial Data}, title = {Intégration de Google Earth dans les outils OLAP pour l'exploration et l'analyse multidimensionnelle des données spatiales}, journal = {Lecture Notes in Business Information Processing}, volume = {24}, bookTitle = {11th International Enterprise Information Systems Conference, ICEIS 2009, 06/05/2009-10/05/2009, Milano, ITA}, address = {Berlin Heidelberg DEU}, publisher = {Springer}, pages = {940-951}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00026838 / http://www.springerlink.com/content/kr750r4112275760/}, doi = {http://dx.doi.org/10.1007/978-3-642-01347-8}, year = {2009}, affiliation = {UNIVERSITY OF NAPLES FEDERICO 2 ITA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITY COLLEGE DUBLIN IRL ; UNIVERSITY OF SALERNO ITA}, ISBNISSN = {ISBN 978-3-642-01346-1 }, abstract = {Spatial OnLine Analytical Processing solutions are a type of Business Information Tool meant to support a decision maker in extracting hidden knowledge from data warehouses containing spatial data. To date, very few SOLAP tools are available, each presenting some drawbacks reducing their flexibility. To overcome these limitations, we have developed a web-based SOLAP tool, obtained by suitably integrating into an ad-hoc architecture the Geobrowser Google Earth with a freely available OLAP engine, namely Mondrian. As a consequence, a decision maker can perform exploration and analysis of spatial data both through the Geobrowser and a Pivot Table in a seamlessly fashion. In this paper, we illustrate the main features of the system we have developed, together with the underlying architecture, using a simulated case study.}, }
close

Book Chapters (14)

M.A. Kang, F. Pinet, S. Bimonte, G. De Sousa, J.P. Chanet
Use of Sensor Data Warehouse for Soil Moisture Analysis
Automated enterprise systems for maximizing business performance (p. 43-57), IGI Global, 2015
abs doi web bib

More and more data are collected via sensors. Wireless networks can be implemented to facilitate the collection of sensors data and to reduce the cost of their acquisition. In this chapter, we present a general architecture combining Wireless Sensor Network (WSN) and Spatial Data Warehouse (SDW) technologies. This innovative solution is used to collect automatically sensor’s information and to facilitate the analysis of these data. The WSN used in this application has been deployed by Irstea and tested during several years in vineyards in South of France. The novel contribution presented in this chapter is related to the use of a SDW to manage data produced by geo-referenced sensor nodes. SDW is one of the most appropriate modern technologies for analyzing large data sets at different temporal and spatial scales. This type of databases is a specific category of information system used to integrate, accumulate and analyze information from various sources. These data are usually organized according to a multidimensional schema to facilitate the calculation of indicators. In this chapter, we introduce the development of a SDW storing the data collected by this WSN. The implemented data warehouse can allow users to aggregate and explore interactively data pro-duced by sensors. With this system, it is possible to visualize on a map the results of these aggregations.
close

@book{PUB00045471, author = {Kang, M.A. and Pinet, F. and Bimonte, S. and De Sousa, G. and Chanet, J.P.}, author = {Papajorgji, P. and Pinet, F. and Guimarães, A. and Papathanasiou, J.}, title = {Use of Sensor Data Warehouse for Soil Moisture Analysis}, title = {Utilisation des entrepôts de données de capteurs pour l'analyse de l'humidité du sol}, bookTitle = {Automated enterprise systems for maximizing business performance}, publisher = {IGI Global}, pages = {43-57}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00045471}, doi = {http://dx.doi.org/10.4018/978-1-4666-8841-4}, year = {2015}, affiliation = {UNIVERSITE DE CLERMONT FERRAND II UMR LIMOS FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {More and more data are collected via sensors. Wireless networks can be implemented to facilitate the collection of sensors data and to reduce the cost of their acquisition. In this chapter, we present a general architecture combining Wireless Sensor Network (WSN) and Spatial Data Warehouse (SDW) technologies. This innovative solution is used to collect automatically sensor’s information and to facilitate the analysis of these data. The WSN used in this application has been deployed by Irstea and tested during several years in vineyards in South of France. The novel contribution presented in this chapter is related to the use of a SDW to manage data produced by geo-referenced sensor nodes. SDW is one of the most appropriate modern technologies for analyzing large data sets at different temporal and spatial scales. This type of databases is a specific category of information system used to integrate, accumulate and analyze information from various sources. These data are usually organized according to a multidimensional schema to facilitate the calculation of indicators. In this chapter, we introduce the development of a SDW storing the data collected by this WSN. The implemented data warehouse can allow users to aggregate and explore interactively data pro-duced by sensors. With this system, it is possible to visualize on a map the results of these aggregations.}, }
close
F. Pinet, S. Bimonte, A. Miralles, F. Flouvat
Special issue on Information and Decision Support Systems for Agriculture and Environment
Ecological Informatics , Elsevier, 2015
abs web bib

Tasks such as monitoring and managing the ecological status of rivers, sharing environmental information, and helping farmers in their decision making are challenges for which information and decision support systems (DSS) represent effective solutions. New theoretical and technical challenges emerge from the integration of several scientific domains such as agronomy, ecology, mathematics, information technology and computer science. The objective of this special issue is to show how the latest advances in research in information and decision support systems can be applied to environmental and/or agricultural systems. This special issue has been organized in conjunction with the international workshop on Agricultural and Environmental Information and Decision Support Systems (AEIDSS 2013) held by the International Conference on “Computational Science and its Applications” (ICCSA 2013), June 24–27, 2013 (Ho Chi Minh City-Vietnam). The authors of the papers presented at this workshop have been invited to submit an extended version of their manuscript to this special issue, but the special issue call for papers was also open to external contributions. Twenty papers have been submitted to this special issue, and ten have been accepted for publication after revisions; each submission has been evaluated by three reviewers. The papers in this special issue address various current topics in informatics, such as data interoperability, linked open data, management of very large datasets, analysis of spatial and temporal information, and advanced formal methods for developing DSS. Here, we describe the main contributions found in the articles. The paper “Semantic Annotation of the CEREALAB database by the AGROVOC Linked Dataset” addresses linked open data. As indicated by the authors, the number of open data government initiatives is increasing worldwide, and new research is needed to help resource providers to publish and link their datasets. The authors have developed an experimental methodology to publish, link and enrich open data by performing automatic semantic annotation of schema elements. This approach is applied to the CEREALAB database, a public relational database designed for storing genotypic and phenotypic data on plant breeding. The authors of the paper entitled “A Knowledge Discovery Process for Spatiotemporal Data: Application to River Water Quality Monitoring” combine different methods to extract knowledge from water-quality data collected along rivers. The results can then be used to determine spatial indicators to assist experts in their interpretation of land use impacts on water quality. The paper “User Centered Ontology for Sri Lankan Farmers” proposes an ontological approach to provide context-specific information and knowledge to farmers based on their own context. As stated by the authors, a knowledge repository of agricultural information is proposed to respond to user queries, considering the context in which information is needed by farmers at different stages of the farming life cycle. The approach has been tested among farmers in Sri Lanka. The article “Evaluation of Urban Sprawl from space using open source technologies” presents a case study of analyzing urban sprawl using satellite data. The authors mention that these data are related to a coastal zone with the presence of sand and rocks, characterized by a fragmented ecosystem and small towns with an increasing rate of urbanization and soil consumption. Support vector machine algorithms are applied for satellite image classification, and open-source software is used. The paper “An Infrastructure-oriented Approach for supporting Biodiversity Research” presents D4Science, a data infrastructure that facilitates accessing and reusing biodiversity data. According to the authors, D4Science is an integrated and flexible environment based on existing databases and information systems. The authors highlight that the infrastructure facilitates the discovery, selection, access and processing of data. The paper “Model-Driven Engineering Applied to Crop Modelling” presents a framework to formalize mechanistic models of plant growth. This approach is based on a new domain-specific language dedicated to crop modeling and is used to facilitate the development of software applications for decision support systems. This framework allows modelers to generate software code automatically. The contribution entitled “Decision Support for Agri-Food Chains: A Reverse Engineering Argumentation-Based Approach” defines an objectives-driven decision support system defined for the end products of an agri-food chain. A reverse engineering technique and a logic-based formalization is proposed in the paper. The article “Increasing dependence on foreign water resources? An assessment of trends in global virtual water flows using a self-organizing time map” highlights that self-organizing time maps can be used to model, visualize and analyze virtual water fluxes. The virtual water is analyzed through the food trade in different countries. The final two papers show how data warehouse technology can be adapted, used and applied for environmental and ecological applications. The first of these papers proposes a method for the enrichment of phenotypic and genotypic data warehouse analysis, using question-answering systems. The main goal is to facilitate the decision making process in cereal breeding programs. The authors of the last paper propose to use hierarchical agglomerative clustering with the Gower similarity index to generate analysis dimensions in a data warehouse. The data set used is related to birds along the Loire River in France. As shown in these short des]criptions of the papers, this special issue presents new research advances in techniques related to information and DSS technologies, such as ontology-based systems, data warehouses, data mining and model-driven engineering. The application examples provided by the authors clearly show the role of these new technologies in the fields of agriculture, environment and ecology and their potential for the next few years
close

@book{PUB00046225, author = {Pinet, F. and Bimonte, S. and Miralles, A. and Flouvat, F.}, title = {Special issue on Information and Decision Support Systems for Agriculture and Environment}, title = {Numéro spécial sur les systèmes d'information et de décision pour l'agriculture et l'environnement}, volume = {26}, number = {2}, bookTitle = {Ecological Informatics}, publisher = {Elsevier}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046225 / http://www.sciencedirect.com/science/journal/15749541/26/supp/P2}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; UNIVERSITY OF NEW CALEDONIA NOUMEA NCL}, abstract = {Tasks such as monitoring and managing the ecological status of rivers, sharing environmental information, and helping farmers in their decision making are challenges for which information and decision support systems (DSS) represent effective solutions. New theoretical and technical challenges emerge from the integration of several scientific domains such as agronomy, ecology, mathematics, information technology and computer science. The objective of this special issue is to show how the latest advances in research in information and decision support systems can be applied to environmental and/or agricultural systems. This special issue has been organized in conjunction with the international workshop on Agricultural and Environmental Information and Decision Support Systems (AEIDSS 2013) held by the International Conference on “Computational Science and its Applications” (ICCSA 2013), June 24–27, 2013 (Ho Chi Minh City-Vietnam). The authors of the papers presented at this workshop have been invited to submit an extended version of their manuscript to this special issue, but the special issue call for papers was also open to external contributions. Twenty papers have been submitted to this special issue, and ten have been accepted for publication after revisions; each submission has been evaluated by three reviewers. The papers in this special issue address various current topics in informatics, such as data interoperability, linked open data, management of very large datasets, analysis of spatial and temporal information, and advanced formal methods for developing DSS. Here, we describe the main contributions found in the articles. The paper “Semantic Annotation of the CEREALAB database by the AGROVOC Linked Dataset” addresses linked open data. As indicated by the authors, the number of open data government initiatives is increasing worldwide, and new research is needed to help resource providers to publish and link their datasets. The authors have developed an experimental methodology to publish, link and enrich open data by performing automatic semantic annotation of schema elements. This approach is applied to the CEREALAB database, a public relational database designed for storing genotypic and phenotypic data on plant breeding. The authors of the paper entitled “A Knowledge Discovery Process for Spatiotemporal Data: Application to River Water Quality Monitoring” combine different methods to extract knowledge from water-quality data collected along rivers. The results can then be used to determine spatial indicators to assist experts in their interpretation of land use impacts on water quality. The paper “User Centered Ontology for Sri Lankan Farmers” proposes an ontological approach to provide context-specific information and knowledge to farmers based on their own context. As stated by the authors, a knowledge repository of agricultural information is proposed to respond to user queries, considering the context in which information is needed by farmers at different stages of the farming life cycle. The approach has been tested among farmers in Sri Lanka. The article “Evaluation of Urban Sprawl from space using open source technologies” presents a case study of analyzing urban sprawl using satellite data. The authors mention that these data are related to a coastal zone with the presence of sand and rocks, characterized by a fragmented ecosystem and small towns with an increasing rate of urbanization and soil consumption. Support vector machine algorithms are applied for satellite image classification, and open-source software is used. The paper “An Infrastructure-oriented Approach for supporting Biodiversity Research” presents D4Science, a data infrastructure that facilitates accessing and reusing biodiversity data. According to the authors, D4Science is an integrated and flexible environment based on existing databases and information systems. The authors highlight that the infrastructure facilitates the discovery, selection, access and processing of data. The paper “Model-Driven Engineering Applied to Crop Modelling” presents a framework to formalize mechanistic models of plant growth. This approach is based on a new domain-specific language dedicated to crop modeling and is used to facilitate the development of software applications for decision support systems. This framework allows modelers to generate software code automatically. The contribution entitled “Decision Support for Agri-Food Chains: A Reverse Engineering Argumentation-Based Approach” defines an objectives-driven decision support system defined for the end products of an agri-food chain. A reverse engineering technique and a logic-based formalization is proposed in the paper. The article “Increasing dependence on foreign water resources? An assessment of trends in global virtual water flows using a self-organizing time map” highlights that self-organizing time maps can be used to model, visualize and analyze virtual water fluxes. The virtual water is analyzed through the food trade in different countries. The final two papers show how data warehouse technology can be adapted, used and applied for environmental and ecological applications. The first of these papers proposes a method for the enrichment of phenotypic and genotypic data warehouse analysis, using question-answering systems. The main goal is to facilitate the decision making process in cereal breeding programs. The authors of the last paper propose to use hierarchical agglomerative clustering with the Gower similarity index to generate analysis dimensions in a data warehouse. The data set used is related to birds along the Loire River in France. As shown in these short des]criptions of the papers, this special issue presents new research advances in techniques related to information and DSS technologies, such as ontology-based systems, data warehouses, data mining and model-driven engineering. The application examples provided by the authors clearly show the role of these new technologies in the fields of agriculture, environment and ecology and their potential for the next few years}, }
close
F. Pinet, N. Carluer, C. Lauvernet, B. Cheviron, S. Bimonte, A. Miralles
Storage of simulation result data: A database perspective
Automated enterprise systems for maximizing business performance ; (p. 58-70), IGI Global, 2015
abs web bib

DBMS is a traditional technology for the storage of business application data. In this chapter, we show that this technology can be of interest in scientific fields. We present a survey of the emergence of the concept of simulation result database. Scientific simulation models become more complex, use more data and produce more outputs. Stochastic models can also be simulated. In this case, numerous simulations are run in order to discover a general trend in results. The replications of simulation increase again the amount of produced data, which makes exploration and analysis difficult. It is also often useful to compare the results obtained in using different model versions, scenarios or assumptions (for example different weather forecasts). In this chapter, we provide several examples of projects of simulation result databases. We show that the database technology can help to manage the large volumes of simulation outputs. We also illustrate this type of projects on environmental databases storing pesticide transfer simulation results. We conclude in highlighting some trends and future works.
close

@book{PUB00045470, author = {Pinet, F. and Carluer, N. and Lauvernet, C. and Cheviron, B. and Bimonte, S. and Miralles, A.}, title = {Storage of simulation result data: A database perspective}, title = {Stockage de données de résultats de simulation : une perspective de base de données}, bookTitle = {Automated enterprise systems for maximizing business performance ; }, publisher = {IGI Global}, pages = {58-70}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00045470}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA LYON UR MALY FRA ; IRSTEA LYON UR MALY FRA ; IRSTEA MONTPELLIER UMR G-EAU FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA MONTPELLIER UMR TETIS FRA}, abstract = {DBMS is a traditional technology for the storage of business application data. In this chapter, we show that this technology can be of interest in scientific fields. We present a survey of the emergence of the concept of simulation result database. Scientific simulation models become more complex, use more data and produce more outputs. Stochastic models can also be simulated. In this case, numerous simulations are run in order to discover a general trend in results. The replications of simulation increase again the amount of produced data, which makes exploration and analysis difficult. It is also often useful to compare the results obtained in using different model versions, scenarios or assumptions (for example different weather forecasts). In this chapter, we provide several examples of projects of simulation result databases. We show that the database technology can help to manage the large volumes of simulation outputs. We also illustrate this type of projects on environmental databases storing pesticide transfer simulation results. We conclude in highlighting some trends and future works.}, }
close
F. Pinet, S. Bimonte, A. Miralles, F. Le Ber
Special issue on agro-environmental decision support systems
Ecological Informatics vol.30 (p. 327-396), Elsevier, 2015
abs web bib

More and more agricultural and environmental data are now available. These data are produced by numerous methods: Terrestrial sensors, remote sensing systems, simulation models, Internet of things, etc. Agricultural and environmental Information Systems (IS) and Decision Support Systems (DSS) are two complementary approaches to use these data – their joint use allows managing information and making decisions based on their analysis in numerous applications for agriculture and environment. In the second edition of this special issue, we publish the latest advances in the field of informatics applied to agriculture and environment, focusing on the information and decision system technologies. The published papers range from the formal systems modelling to their development and experiments for decision-making. Several of these contributions show the combination of theoretical and practical methods issued from multidisciplinary research works. Different applications are presented in the fields of land use and pasture modelling, analyse of climate change impacts on agriculture, GM maize crop management, biotechnology and agriculture, fishery management. The communication and the interaction with users are two key points for the IS and DSS usability. The paper “An authoring tool for decision support systems in context questions of ecological knowledge” presents a new system to query more easily information and decision systems for biotechnology and agriculture. This method is based on a natural language interface in which the interactions between the user and the DSS reference the previous questions and answers. The system provides the capability to elide certain parts of the questions. The proposal is based on ontologies created semi-automatically by information integration. The architecture has been tested with information coming from the CEREALAB database and the Web (e.g., PubMed). The paper “Inference reasoning on fishers' knowledge using Bayesian causal maps” deals with a theoretical formalism for knowledge representation. The authors show how to use a new formalism called Bayesian causal map to model shellfish dredger activities and derive a decision systems allowing scenarios testing for fisheries management. Bayesian causal maps combine the advantages of cognitive maps and Bayesian networks. The resulting method is easy to use for expressing knowledge and for eliciting uncertain information. In the paper “Bayesian calibration of the Pasture Simulation model (PaSim) to simulate European grasslands under water stress”, the authors present a framework to interpret the model performance obtained with Bayesian calibration, in taking into account the case of a complex model for grassland. This model called PaSim is defined under certain climate conditions (precipitation reduction). The authors show an application for grasslands in Europe. In many places, urban zones tend to replace rural areas and it is important to be able to estimate the evolution of this tendency. In the paper “Supporting planning activities with the assessment and the prediction of urban sprawl using spatio-temporal analysis”, the authors analyse the spatio-temporal evolution of land and soil data. The authors introduce a model to measure variations occurred in land use, determine soil consumption and assess future trends. This model is applied to an Italian region. The managing of the coexistence between GM and non-GM maize crops is an important issue for numerous stakeholders. In the paper “Design of a decision support tool for managing coexistence between genetically modified and conventional maize at farm and regional levels”, the authors develop a model that can be used to inform the decision-maker on adventitious presence of GM grains in non-GM agricultural areas. Information are also provided about the uncertainty of the assessment and about the variability of adventitious presence. The implemented Web-based decision-support tool can compute the expected adventitious presence and its probability distribution in non-GM maize fields, according to distance and date. In “An open platform to assess vulnerabilities to climate change: An application to agricultural systems”, the authors introduce a new software platform for quantitative assessments support of vulnerability to climate change in agriculture. This software tool allows processing model-based inference related to agro-ecological system vulnerability to a variety of climate scenarios. A case study is introduced in the Massif Central region in France. The platform is used to characterize climate, soils and human management and to assess the vulnerability to climate change of grassland productivity at a fine geographical scale. In conclusion, this special issue describes some applications of information/decision systems and shows how these types of systems can help to manage the future challenges in the environmental and agricultural field. The world will have to face many challenges such as agricultural adaptation to climate change, land use evolution, coexistence of various agricultural systems, environmental constraints, etc. and information/decision systems will offer technical means to address these challenges.
close

@book{PUB00045549, author = {Pinet, F. and Bimonte, S. and Miralles, A. and Le Ber, F.}, title = {Special issue on agro-environmental decision support systems}, title = {Systèmes d'aide à la décision agro-environnmentale}, bookTitle = {Ecological Informatics vol.30}, publisher = {Elsevier}, pages = {327-396}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00045549}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; ENGEES STRASBOURG FRA}, abstract = {More and more agricultural and environmental data are now available. These data are produced by numerous methods: Terrestrial sensors, remote sensing systems, simulation models, Internet of things, etc. Agricultural and environmental Information Systems (IS) and Decision Support Systems (DSS) are two complementary approaches to use these data – their joint use allows managing information and making decisions based on their analysis in numerous applications for agriculture and environment. In the second edition of this special issue, we publish the latest advances in the field of informatics applied to agriculture and environment, focusing on the information and decision system technologies. The published papers range from the formal systems modelling to their development and experiments for decision-making. Several of these contributions show the combination of theoretical and practical methods issued from multidisciplinary research works. Different applications are presented in the fields of land use and pasture modelling, analyse of climate change impacts on agriculture, GM maize crop management, biotechnology and agriculture, fishery management. The communication and the interaction with users are two key points for the IS and DSS usability. The paper “An authoring tool for decision support systems in context questions of ecological knowledge” presents a new system to query more easily information and decision systems for biotechnology and agriculture. This method is based on a natural language interface in which the interactions between the user and the DSS reference the previous questions and answers. The system provides the capability to elide certain parts of the questions. The proposal is based on ontologies created semi-automatically by information integration. The architecture has been tested with information coming from the CEREALAB database and the Web (e.g., PubMed). The paper “Inference reasoning on fishers' knowledge using Bayesian causal maps” deals with a theoretical formalism for knowledge representation. The authors show how to use a new formalism called Bayesian causal map to model shellfish dredger activities and derive a decision systems allowing scenarios testing for fisheries management. Bayesian causal maps combine the advantages of cognitive maps and Bayesian networks. The resulting method is easy to use for expressing knowledge and for eliciting uncertain information. In the paper “Bayesian calibration of the Pasture Simulation model (PaSim) to simulate European grasslands under water stress”, the authors present a framework to interpret the model performance obtained with Bayesian calibration, in taking into account the case of a complex model for grassland. This model called PaSim is defined under certain climate conditions (precipitation reduction). The authors show an application for grasslands in Europe. In many places, urban zones tend to replace rural areas and it is important to be able to estimate the evolution of this tendency. In the paper “Supporting planning activities with the assessment and the prediction of urban sprawl using spatio-temporal analysis”, the authors analyse the spatio-temporal evolution of land and soil data. The authors introduce a model to measure variations occurred in land use, determine soil consumption and assess future trends. This model is applied to an Italian region. The managing of the coexistence between GM and non-GM maize crops is an important issue for numerous stakeholders. In the paper “Design of a decision support tool for managing coexistence between genetically modified and conventional maize at farm and regional levels”, the authors develop a model that can be used to inform the decision-maker on adventitious presence of GM grains in non-GM agricultural areas. Information are also provided about the uncertainty of the assessment and about the variability of adventitious presence. The implemented Web-based decision-support tool can compute the expected adventitious presence and its probability distribution in non-GM maize fields, according to distance and date. In “An open platform to assess vulnerabilities to climate change: An application to agricultural systems”, the authors introduce a new software platform for quantitative assessments support of vulnerability to climate change in agriculture. This software tool allows processing model-based inference related to agro-ecological system vulnerability to a variety of climate scenarios. A case study is introduced in the Massif Central region in France. The platform is used to characterize climate, soils and human management and to assess the vulnerability to climate change of grassland productivity at a fine geographical scale. In conclusion, this special issue describes some applications of information/decision systems and shows how these types of systems can help to manage the future challenges in the environmental and agricultural field. The world will have to face many challenges such as agricultural adaptation to climate change, land use evolution, coexistence of various agricultural systems, environmental constraints, etc. and information/decision systems will offer technical means to address these challenges.}, }
close
S. Bimonte, M. Kang
WikOLAP: Integration of wiki and OLAP Systems
John Wang, 2014
web bib

@book{PUB00040801, author = {Bimonte, S. and Kang, M.}, title = {WikOLAP: Integration of wiki and OLAP Systems}, title = {WikiOLAP : intégration d'un Wiki et un système OLAP}, publisher = {John Wang}, pages = {526-536}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040801}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; ISIMA AUBIERE FRA}, abstract = {}, }
close
S. Bimonte, F. Pinet, A. Miralles, P. Papajorgji
Spatial data warehouses and SOLAP
International journal geoinformatica. Special section on “Spatial data warehouses and SOLAP” , 2013
web bib

@book{PUB00040807, author = {Bimonte, S. and Pinet, F. and Miralles, A. and Papajorgji, P.}, title = {Spatial data warehouses and SOLAP}, title = {Olap spatial et entrepôts de données spatiales}, bookTitle = {International journal geoinformatica. Special section on “Spatial data warehouses and SOLAP”}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040807}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA MONTPELLIER UMR TETIS FRA ; UNIVERSITY TIRANA ALB}, abstract = {}, }
close
S. Bimonte, F. Pinet
Conception des entrepôts de données: de l'implémentation à la restitution.
Journal of Decision Systems Volume 21, Issue 1, January 2012, (p. 1-2), Taylor & Francis Online, 2012
abs web bib

Ce numéro spécial de la revue Journal of Decision Systems présente des travaux de recherche qui s’inscrivent dans le domaine des systèmes information d’aide à la décision et en particulier dans le cadre des Entrepôts de Données (ED).
close

@book{PUB00037145, author = {Bimonte, S. and Pinet, F.}, title = {Conception des entrepôts de données: de l'implémentation à la restitution.}, title = {Designing data warehouses: From the implementation to the restitution}, bookTitle = {Journal of Decision Systems Volume 21, Issue 1, January 2012,}, publisher = {Taylor & Francis Online}, pages = {1-2}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00037145}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Ce numéro spécial de la revue Journal of Decision Systems présente des travaux de recherche qui s’inscrivent dans le domaine des systèmes information d’aide à la décision et en particulier dans le cadre des Entrepôts de Données (ED). }, }
close
M. Bertolotto, S. Bimonte, S. Di Martino, F. Ferrucci, V. Leano
Spatial Online Analytical Processing of geographic data through the Google Earth Interface
Geocomputation, sustainability and environmental planning (p. 163-182), Springer-Verlag, Berlin, 2011
abs doi web bib

OnLine Analytical Processing (OLAP) tools act as support systems for decision makers to discover new knowledge hidden within data warehouses. In the spatial domain this capability is crucial. However, notwithstanding the pressing need for Spatial OLAP (SOLAP) tools, only very few are currently available. Such tools present several limitations in terms of their flexibility in the functionality and the analytical properties they provide. To overcome these limitations, we have developed a web-based SOLAP tool, which relies on the integration of a standard Geobrowser (Google Earth) with a freely available OLAP engine, namely Mondrian. Our system allows a decision maker to perform exploration and analysis of spatial data both through the Geobrowser and a Pivot Table in a seamlessly fashion. In this paper, we illustrate the main features of the system we have developed, together with the underlying architecture, using a simulated case study.
close

@book{PUB00026849, author = {Bertolotto, M. and Bimonte, S. and Di Martino, S. and Ferrucci, F. and Leano, V.}, author = {Murgante, B. and Borruso, G. and Lapucci, A.}, title = {Spatial Online Analytical Processing of geographic data through the Google Earth Interface}, title = {Analyse spatiale en ligne pour les données géographiques à travers Google Earth}, bookTitle = {Geocomputation, sustainability and environmental planning}, series = {Studies in Computational Intelligence vol.348}, address = {Berlin}, publisher = {Springer-Verlag}, pages = {163-182}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00026849}, doi = {http://dx.doi.org/10.1007/978-3-642-19733-8_10 }, year = {2011}, affiliation = {UNIVERSITY COLLEGE DUBLIN IRL ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITY OF NAPLES FEDERICO II ITA ; UNIVERSITY OF SALERNO ITA ; UNIVERSITY OF NAPLES FEDERICO II ITA}, ISBNISSN = {ISBN 978-3-642-19732-1}, abstract = {OnLine Analytical Processing (OLAP) tools act as support systems for decision makers to discover new knowledge hidden within data warehouses. In the spatial domain this capability is crucial. However, notwithstanding the pressing need for Spatial OLAP (SOLAP) tools, only very few are currently available. Such tools present several limitations in terms of their flexibility in the functionality and the analytical properties they provide. To overcome these limitations, we have developed a web-based SOLAP tool, which relies on the integration of a standard Geobrowser (Google Earth) with a freely available OLAP engine, namely Mondrian. Our system allows a decision maker to perform exploration and analysis of spatial data both through the Geobrowser and a Pivot Table in a seamlessly fashion. In this paper, we illustrate the main features of the system we have developed, together with the underlying architecture, using a simulated case study.}, }
close
A. Miralles, S. Bimonte
Special issue on environmental and agricultural data processing for water and territory management
International Journal of Agricultural and Environmental Information Systems IJAEIS 2 (2), IGI Global, Hershey, USA, 2011
abs web bib

Nowadays, new information and communication technologies make it possible to collect considerable amounts of geo-referenced data. These data are generated by remote sensing systems or other computer applications. In order to take benefits of these valuable data, some new solutions propose to integrate them into Information Systems and Decision Support Systems. These systems represent increasingly effective and performing tools to tackle issues concerning the processing of environmental data related to water and territory. Indeed, they allow taking into account characteristics of these complex data and phenomena (such as semantics, spatial components, etc.) and of environmental problems (social theories, simulation models, participative issues, etc.). The main goal of this special issue of International Journal of Agricultural and Environmental Information Systems is to collect recent advances in information and decision support systems for environmental applications developed for the management of the water and territory.
close

@book{PUB00034450, author = {Miralles, A. and Bimonte, S.}, title = {Special issue on environmental and agricultural data processing for water and territory management}, title = {Numéro spécial sur l'informatique environnementale et agricole pour la gestion de l'eau et des territoires}, journal = {International Journal of Agricultural and Environmental Information Systems IJAEIS}, volume = {2}, number = {2}, address = {Hershey, USA}, publisher = {IGI Global}, pages = {92}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00034450 / http://www.igi-global.com/journal/international-journal-agricultural-environmental-information/1160}, year = {2011}, affiliation = {CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Nowadays, new information and communication technologies make it possible to collect considerable amounts of geo-referenced data. These data are generated by remote sensing systems or other computer applications. In order to take benefits of these valuable data, some new solutions propose to integrate them into Information Systems and Decision Support Systems. These systems represent increasingly effective and performing tools to tackle issues concerning the processing of environmental data related to water and territory. Indeed, they allow taking into account characteristics of these complex data and phenomena (such as semantics, spatial components, etc.) and of environmental problems (social theories, simulation models, participative issues, etc.). The main goal of this special issue of International Journal of Agricultural and Environmental Information Systems is to collect recent advances in information and decision support systems for environmental applications developed for the management of the water and territory.}, }
close
F. Pinet, A. Miralles, S. Bimonte
Systèmes d'information pour l'environnement
Ingénierie des Systèmes d'Information 16 (3), Hermes, 2011
abs web bib

Notre société prend progressivement conscience qu'elle est confrontée à nombre de challenges environnementaux : minimiser les impacts négatifs de l'action de l'homme sur son environnement, préserver les écosystèmes, savoir contrôler la qualité de l'eau, prévoir et gérer les risques etc. L'ordinateur est devenu un outil puissant et incontournable pour aider à répondre à ces défis. Généralement, afin d'apporter des solutions, il est au préalable nécessaire de mieux comprendre l'environnement, ses interactions, évaluer l'impact précis de l'activité humaine sur son fonctionnement. Dans ce but, les technologies des SI permettent d'acquérir ou de simuler d'important volume de données, de les contrôler, de les capitaliser, de les analyser, de les partager, etc. L'objectif de ce numéro spécial est de présenter différents travaux récents dans le domaine de recherche des Systèmes d'Information pour l'Environnement (SIE). L'appel à communication de ce numéro a été lancé à la suite de la série d'ateliers « SIDE - Système d'Information et de Décision pour l'Environnement » associés au congrès Inforsid (http://inforsid.irit.fr/). Voici les articles qui ont été sélectionnés pour le numéro. Le premier présente un SIE pour le suivi et l'évaluation de la qualité des cours d'eau. L'objectif du système est d'organiser, partager et analyser des données sur les espèces présentes ainsi que sur des prélèvements physiques, chimiques et biologiques. Le second article concerne la mise en ½uvre d'architectures parallèles pour le traitement de gros volumes de données liées aux risques environnementaux. Les auteurs proposent un outil générique pour faciliter l'exécution de simulations en parallèle. Le troisième article présente différents exemples d'ontologies utilisées en agriculture. Il est souligné que le secteur agricole est en pleine mutation. Il doit en effet de plus en plus prendre en compte la dimension liée aux impacts environnementaux des pratiques. Dans ce contexte, les SIE se doivent d'échanger de manière massive des informations concernant la traçabilité, les acteurs doivent recueillir de plus en plus d'information pour améliorer leurs pratiques, etc. D'où la nécessité d'employer les ontologies. Le papier suivant introduit un SIE d'aide à la décision pour la gestion et la sauvegarde des écosystèmes. Cet outil se base sur les systèmes à événements discrets et exploite l'efficacité des techniques de model-checking pour répondre aux requêtes des utilisateurs, non par simulation, mais par la vérification de propriétés sur l'écosystème. Le dernier article propose une méthode pour la prédiction des crues fondée sur la découverte d'informations non connues a priori. Elle est basée sur la mise en ½uvre de variables agrégées et d'un algorithme génétique.
close

@book{PUB00032959, author = {Pinet, F. and Miralles, A. and Bimonte, S.}, title = {Systèmes d'information pour l'environnement}, title = {Environmental Information Systems}, journal = {Ingénierie des Systèmes d'Information}, volume = {16}, number = {3}, publisher = {Hermes}, pages = {139}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00032959 / http://isi.revuesonline.com/resnum.jsp?editionId=1517}, year = {2011}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Notre société prend progressivement conscience qu'elle est confrontée à nombre de challenges environnementaux : minimiser les impacts négatifs de l'action de l'homme sur son environnement, préserver les écosystèmes, savoir contrôler la qualité de l'eau, prévoir et gérer les risques etc. L'ordinateur est devenu un outil puissant et incontournable pour aider à répondre à ces défis. Généralement, afin d'apporter des solutions, il est au préalable nécessaire de mieux comprendre l'environnement, ses interactions, évaluer l'impact précis de l'activité humaine sur son fonctionnement. Dans ce but, les technologies des SI permettent d'acquérir ou de simuler d'important volume de données, de les contrôler, de les capitaliser, de les analyser, de les partager, etc. L'objectif de ce numéro spécial est de présenter différents travaux récents dans le domaine de recherche des Systèmes d'Information pour l'Environnement (SIE). L'appel à communication de ce numéro a été lancé à la suite de la série d'ateliers « SIDE - Système d'Information et de Décision pour l'Environnement » associés au congrès Inforsid (http://inforsid.irit.fr/). Voici les articles qui ont été sélectionnés pour le numéro. Le premier présente un SIE pour le suivi et l'évaluation de la qualité des cours d'eau. L'objectif du système est d'organiser, partager et analyser des données sur les espèces présentes ainsi que sur des prélèvements physiques, chimiques et biologiques. Le second article concerne la mise en ½uvre d'architectures parallèles pour le traitement de gros volumes de données liées aux risques environnementaux. Les auteurs proposent un outil générique pour faciliter l'exécution de simulations en parallèle. Le troisième article présente différents exemples d'ontologies utilisées en agriculture. Il est souligné que le secteur agricole est en pleine mutation. Il doit en effet de plus en plus prendre en compte la dimension liée aux impacts environnementaux des pratiques. Dans ce contexte, les SIE se doivent d'échanger de manière massive des informations concernant la traçabilité, les acteurs doivent recueillir de plus en plus d'information pour améliorer leurs pratiques, etc. D'où la nécessité d'employer les ontologies. Le papier suivant introduit un SIE d'aide à la décision pour la gestion et la sauvegarde des écosystèmes. Cet outil se base sur les systèmes à événements discrets et exploite l'efficacité des techniques de model-checking pour répondre aux requêtes des utilisateurs, non par simulation, mais par la vérification de propriétés sur l'écosystème. Le dernier article propose une méthode pour la prédiction des crues fondée sur la découverte d'informations non connues a priori. Elle est basée sur la mise en ½uvre de variables agrégées et d'un algorithme génétique.}, }
close
M. Visoli, S. Bimonte, S. Ternès, F. Pinet, J.P. Chanet
Towards a spatial decision support system for animal traceability
Computational methods applied to agricultural research: advances and applications (p. 389-411), IGI Global, 2011
abs doi web bib

Animal traceability is of great importance for many government and private organizations, in particular for economic and sanitary control purposes. Traditional tracking systems can memorize the main movements of cattle, and geolocate individual animals using RFID. We can now consider a new generation of traceability systems in which successive locations are automatically recorded several times per day for each animal. Such systems can be coupled with analysis techniques to help decision-making, and to validate or redirect hypotheses. Here we describe a spatial decision support system for animal geolocation acquisition and analysis of sanitary issues. In sanitary alerts, the system can use recorded animal movements to identify animals that have been in contact with a diseased animal. The system is applied to tracking beef cattle in the Brazilian production system as a case study. This work is part of the OTAG project for improving methods and geotechnology to record reliable and accurate data on beef production.
close

@book{PUB00029296, author = {Visoli, M. and Bimonte, S. and Ternès, S. and Pinet, F. and Chanet, J.P.}, title = {Towards a spatial decision support system for animal traceability}, title = {Vers un système d'aide à la décision spatiale pour la traçabilité animale}, bookTitle = {Computational methods applied to agricultural research: advances and applications}, publisher = {IGI Global}, pages = {389-411}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029296}, doi = {http://dx.doi.org/10.4018/978-1-61692-871-1.ch018}, year = {2011}, affiliation = {EMBRAPA AGRICULTURE INFORMATICS ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; EMBRAPA AGRICULTURE INFORMATICS ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, ISBNISSN = {ISBN13 9781616928711}, abstract = {Animal traceability is of great importance for many government and private organizations, in particular for economic and sanitary control purposes. Traditional tracking systems can memorize the main movements of cattle, and geolocate individual animals using RFID. We can now consider a new generation of traceability systems in which successive locations are automatically recorded several times per day for each animal. Such systems can be coupled with analysis techniques to help decision-making, and to validate or redirect hypotheses. Here we describe a spatial decision support system for animal geolocation acquisition and analysis of sanitary issues. In sanitary alerts, the system can use recorded animal movements to identify animals that have been in contact with a diseased animal. The system is applied to tracking beef cattle in the Brazilian production system as a case study. This work is part of the OTAG project for improving methods and geotechnology to record reliable and accurate data on beef production. }, }
close
S. Bimonte, M. Kang
Towards a model for the multidimensional analysis of field data
14th East-European Conference on Advances in Databases and Information Systems, ADBIS 2010, 20/09/2010-24/09/2010, Novi Sad, SRB / Advances in Databases and Information Systems (p. 58-78), Springer , 2010
abs doi web bib

Integration of spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Usually, SOLAP models exploit discrete spatial data. Few works integrate continuous field data into dimensions and measures. In this paper, we provide a multidimensional model that supports measures and dimension as continuous field data, independently of their implementation.
close

@book{PUB00029485, author = {Bimonte, S. and Kang, M.}, author = {Catania, B. and Ivanovic, M. and Thalheim, B.}, title = {Towards a model for the multidimensional analysis of field data}, title = {Vers un modèle pour l'analyse multidimensionnelle des champs continus}, bookTitle = {14th East-European Conference on Advances in Databases and Information Systems, ADBIS 2010, 20/09/2010-24/09/2010, Novi Sad, SRB / Advances in Databases and Information Systems}, series = {Lecture Notes in Computer Science}, publisher = {Springer }, pages = {58-78}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029485 / http://www.adbis2010.org/}, doi = {http://dx.doi.org/10.1007/978-3-642-15576-5_7}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA}, ISBNISSN = {ISBN 978-3-642-15575-8}, abstract = {Integration of spatial data into multidimensional models leads to the concept of Spatial OLAP (SOLAP). Usually, SOLAP models exploit discrete spatial data. Few works integrate continuous field data into dimensions and measures. In this paper, we provide a multidimensional model that supports measures and dimension as continuous field data, independently of their implementation.}, }
close
S. Bimonte, M. Villanova-Oliver, J. Gensel
A multidimensional model for correct aggregation of geographic measures
Evolving application domains of data warehousing and mining: trends and solutions (p. 162-183), IGI Global, 2010
abs doi web bib

Spatial OLAP refers to the integration of spatial data in multidimensional applications at physical, logical and conceptual levels. The multidimensional aggregation of geographic objects (geographic measures) exhibits theoretical and implementation problems. In this paper, we present a panorama of aggregation issues in multidimensional, geostatistic, GIS and Spatial OLAP models. Then, we illustrate how overlapping geometries and dependency of spatial and alphanumeric aggregation are necessary for correctly aggregating geographic measures. Consequently, we present an extension of the logical multidimensional model GeoCube (Bimonte et al., 2006) to deal with these issues.
close

@book{PUB00026848, author = {Bimonte, S. and Villanova-Oliver, M. and Gensel, J.}, author = {Furtado, P.}, title = {A multidimensional model for correct aggregation of geographic measures}, title = {Un modèle multidimensionnel pour l'agrégation correcte des mesures géographiques}, bookTitle = {Evolving application domains of data warehousing and mining: trends and solutions}, publisher = {IGI Global}, pages = {162-183}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00026848}, doi = {http://dx.doi.org/10.4018/978-1-60566-816-1.ch008}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; LABORATOIRE D'INFORMATIQUE GRENOBLE FRA ; LABORATOIRE D'INFORMATIQUE GRENOBLE FRA}, ISBNISSN = {ISBN 9781605668161}, abstract = {Spatial OLAP refers to the integration of spatial data in multidimensional applications at physical, logical and conceptual levels. The multidimensional aggregation of geographic objects (geographic measures) exhibits theoretical and implementation problems. In this paper, we present a panorama of aggregation issues in multidimensional, geostatistic, GIS and Spatial OLAP models. Then, we illustrate how overlapping geometries and dependency of spatial and alphanumeric aggregation are necessary for correctly aggregating geographic measures. Consequently, we present an extension of the logical multidimensional model GeoCube (Bimonte et al., 2006) to deal with these issues.}, }
close
M. Visoli, S. Ternès, S. Bimonte, F. Pinet, J.P. Chanet
Towards a spatial decision support system for animal traceability
New tools for precision livestock management (p. 38-41), Inter-American Institute for Cooperation on ; Agriculture(IICA)Procisur, Montevideo, Uruguay, URY, 2009
abs web bib

Présentation du système décisionnel développé dans le cadre du projet OTAG.
close

@book{PUB00028967, author = {Visoli, M. and Ternès, S. and Bimonte, S. and Pinet, F. and Chanet, J.P.}, title = {Towards a spatial decision support system for animal traceability}, bookTitle = {New tools for precision livestock management}, address = {Montevideo, Uruguay, URY}, publisher = {Inter-American Institute for Cooperation on ; Agriculture(IICA)Procisur}, pages = {38-41}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00028967 / http://www.otag-project.org/files/publications/OTAG-booklet-web.pdf}, year = {2009}, affiliation = {EMBRAPA INFORMATICA CAMPINAS BRA ; EMBRAPA INFORMATICA CAMPINAS BRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, ISBNISSN = {ISBN 13: 978-92-9248-148-3}, abstract = {Présentation du système décisionnel développé dans le cadre du projet OTAG.}, }
close

In Proceedings (51)

I. Ferrahi, S. Bimonte, K. Boukhalfa
A model&DBMS independent benchmark for data warehouses
EDA 2017 Business Intelligence & Big Data , 03/05/2017-05/05/2017, Lyon, FRA , 2017
abs web bib

NoSQL systems support new data models, which propose alternative models to the well-known relational models, and query languages. Due to the lack of a well-accepted logical model for Data Warehouses (DWs), some preliminaries works proposes extensions/redefinition of relational star and snow-flake schemata for NoSQL families. However, many other modeling possibilities remain unexplored, and it is difficult to compare these proposals because of the lack of a well-recognized benchmarking framework for DWs. In this paper, we propose a generic extension of the relational Star Schema Benchmark, called GenSSB, to handle any kind of DBMS in terms of logical models. We validate our framework by instantiating GenSSB for some different logical models and DBMSs
close

@inproceedings{PUB00057139, author = {Ferrahi, I. and Bimonte, S. and Boukhalfa, K.}, title = {A model&DBMS independent benchmark for data warehouses }, bookTitle = {EDA 2017 Business Intelligence & Big Data , 03/05/2017-05/05/2017, Lyon, FRA}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00057139}, year = {2017}, affiliation = {UNIVERSITY MHAMED BOUGARA BOUMERDES ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; LSI BAB EZZOUARE ALG}, abstract = {NoSQL systems support new data models, which propose alternative models to the well-known relational models, and query languages. Due to the lack of a well-accepted logical model for Data Warehouses (DWs), some preliminaries works proposes extensions/redefinition of relational star and snow-flake schemata for NoSQL families. However, many other modeling possibilities remain unexplored, and it is difficult to compare these proposals because of the lack of a well-recognized benchmarking framework for DWs. In this paper, we propose a generic extension of the relational Star Schema Benchmark, called GenSSB, to handle any kind of DBMS in terms of logical models. We validate our framework by instantiating GenSSB for some different logical models and DBMSs}, }
close
I. Ferrahi, S. Bimonte, K. Boukhalfa
Tableaux de bord adaptatifs pour le Spatial OLAP
EDA 2017 Business Intelligence & Big Data , 03/05/2017-05/05/2017, Lyon, FRA , 2017
abs web bib

Les entrepôts des données spatiales (EDS) et OLAP Spatial (SOLAP) intègrent les outils d’analyse spatiale et de géovisualisation offerts par les Systèmes d’Information Géographique (SIG) aux fonctionnalités OLAP. Peu de travaux étudient les problèmes de géovisualisation dans les systèmes SOLAP et aucun travail ne propose d’outils pour des affichages cartographiques SOLAP lisibles. Par conséquent, les décideurs font manuellement la configuration de la visualisation cartographique dans les outils SOLAP existants. Donc, nous présentons dans cet article une nouvelle méthodologie de géovisualisation pour les résultats des requêtes SOLAP qui donne des cartes lisibles.
close

@inproceedings{PUB00057141, author = {Ferrahi, I. and Bimonte, S. and Boukhalfa, K.}, title = {Tableaux de bord adaptatifs pour le Spatial OLAP }, bookTitle = {EDA 2017 Business Intelligence & Big Data , 03/05/2017-05/05/2017, Lyon, FRA}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00057141}, year = {2017}, affiliation = {UNIVERSITY MHAMED BOUGARA BOUMERDES ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; LSI BAB EZZOUARE ALG}, abstract = {Les entrepôts des données spatiales (EDS) et OLAP Spatial (SOLAP) intègrent les outils d’analyse spatiale et de géovisualisation offerts par les Systèmes d’Information Géographique (SIG) aux fonctionnalités OLAP. Peu de travaux étudient les problèmes de géovisualisation dans les systèmes SOLAP et aucun travail ne propose d’outils pour des affichages cartographiques SOLAP lisibles. Par conséquent, les décideurs font manuellement la configuration de la visualisation cartographique dans les outils SOLAP existants. Donc, nous présentons dans cet article une nouvelle méthodologie de géovisualisation pour les résultats des requêtes SOLAP qui donne des cartes lisibles.}, }
close
I. Ferrahi, S. Bimonte, M.A. Kang, K. Boukhalfa
Design and implementation of falling star: A non-redudant spatio-multidimensional logical model for document stores
International Conference on Enterprise Information Systems (ICEIS), 26/04/2017-29/04/2017, Porto, PRT , 2017
abs web bib

In the context of Spatial Big Data, some NoSQL spatial DBMSs have been developed to deal with the Spatiality, Velocity, Variety, and Volume of Spatial Big Data. In this context, some works recently study NoSQL logical Data Warehouse (DW) models. However, these proposals do not investigate storing and querying spatial data. Therefore, in this paper we, propose a new logical model for document Spatial DWs. Moreover, motivated by the expressivity, readability and interoperability offered by UML profile, we represent our model using a UML profile. Finally, we present an implementation in document Spatial DBMSs.
close

@inproceedings{PUB00057142, author = {Ferrahi, I. and Bimonte, S. and Kang, M.A. and Boukhalfa, K.}, title = {Design and implementation of falling star: A non-redudant spatio-multidimensional logical model for document stores }, bookTitle = {International Conference on Enterprise Information Systems (ICEIS), 26/04/2017-29/04/2017, Porto, PRT}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00057142}, year = {2017}, affiliation = {UNIVERSITY MHAMED BOUGARA OF BOUMERDES ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE CLERMONT FERRAND II UMR LIMOS FRA ; UNIVERSITY OF SCIENCES AND TECHNOLOGY ALG }, abstract = {In the context of Spatial Big Data, some NoSQL spatial DBMSs have been developed to deal with the Spatiality, Velocity, Variety, and Volume of Spatial Big Data. In this context, some works recently study NoSQL logical Data Warehouse (DW) models. However, these proposals do not investigate storing and querying spatial data. Therefore, in this paper we, propose a new logical model for document Spatial DWs. Moreover, motivated by the expressivity, readability and interoperability offered by UML profile, we represent our model using a UML profile. Finally, we present an implementation in document Spatial DBMSs. }, }
close
C. Zaza, S. Bimonte, C. Gallo, N. Faccilongo, P. La Sala, F. Contò
OLAP analysis of integrated pest management's defense rules:Application to olive crop in Apulia region
17th International Conference on Computational Science and Its Applications , 03/07/2017-06/07/2017, Trieste, ITA , 2017
abs web bib

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.
close

@inproceedings{PUB00057143, author = {Zaza, C. and Bimonte, S. and Gallo, C. and Faccilongo, N. and La Sala, P. and Contò, F.}, title = {OLAP analysis of integrated pest management's defense rules:Application to olive crop in Apulia region}, bookTitle = {17th International Conference on Computational Science and Its Applications , 03/07/2017-06/07/2017, Trieste, ITA}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00057143}, year = {2017}, affiliation = {UNIVERSITY OF FOGGIA ITA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITY OF FOGGIA ITA ; UNIVERSITY OF FOGGIA ITA ; UNIVERSITY OF FOGGIA ITA ; UNIVERSITY OF FOGGIA ITA}, abstract = {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.}, }
close
S. Bimonte
Open issues in Big Data warehouse design
12èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne , 09/05/2016-10/05/2016, Aix-en-Provence, FRA (p. 10), 2016
abs web bib

Data Warehouse and OLAP systems allow analyzing huge volumes of data represented according to the multidimensional model. In the era of Big Data, NoSQL systems have been proved to be an effective Business Intelligence solution. Some works recently study warehousing and OLAPing Big Data. (Un)Lucky these works exclusively investigate time performance related to the Volume and Velocity features of Big Data. Therefore, in this paper we investigate the impact of other Big Data features: Variety, Veracity and Value on warehousing and OLAP analysis. Then, we go beyond computation performance and we highlight new Big Data Warehouses design issues.
close

@inproceedings{PUB00050628, author = {Bimonte, S.}, title = {Open issues in Big Data warehouse design}, bookTitle = {12èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne , 09/05/2016-10/05/2016, Aix-en-Provence, FRA}, pages = {10}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00050628 / http://bda.lif.univ-mrs.fr/EDA2016/}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Data Warehouse and OLAP systems allow analyzing huge volumes of data represented according to the multidimensional model. In the era of Big Data, NoSQL systems have been proved to be an effective Business Intelligence solution. Some works recently study warehousing and OLAPing Big Data. (Un)Lucky these works exclusively investigate time performance related to the Volume and Velocity features of Big Data. Therefore, in this paper we investigate the impact of other Big Data features: Variety, Veracity and Value on warehousing and OLAP analysis. Then, we go beyond computation performance and we highlight new Big Data Warehouses design issues.}, }
close
S. Bimonte, A. Hassan
Une architecture orientée services pour l’OLAP Spatial
EDA 2016, Entrepôt de Données et Analyse en ligne, 09/05/2016-10/05/2016, Aix-en-Provence, FRA (p. 17-24), RNTI, 2016
abs web bib

Un système OLAP Spatial (SOLAP) vise à analyser interactivement les données géoréférencées. Il permet aux décideurs d’explorer et de visualiser les entrepôts de données spatiales en utilisant des tables multidimensionnelles « pivot table » et d’affichage cartographique des faits sur des cartes interactives. Dans cet article, nous présentons un prototype pour la visualisation cartographique des requêtes SOLAP. Ce prototype se base sur une architecture orientée services (SOA). Dans ce prototype, le client SOLAP est totalement basé sur des représentations de données standard et des services web de visualisation cartographique.
close

@inproceedings{PUB00053472, author = {Bimonte, S. and Hassan, A.}, title = {Une architecture orientée services pour l’OLAP Spatial}, title = {A web services architecture for Spatial OLAP}, volume = {B-12}, bookTitle = {EDA 2016, Entrepôt de Données et Analyse en ligne, 09/05/2016-10/05/2016, Aix-en-Provence, FRA}, publisher = {RNTI}, pages = {17-24}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053472 / http://editions-rnti.fr/?inprocid=1002251}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Un système OLAP Spatial (SOLAP) vise à analyser interactivement les données géoréférencées. Il permet aux décideurs d’explorer et de visualiser les entrepôts de données spatiales en utilisant des tables multidimensionnelles « pivot table » et d’affichage cartographique des faits sur des cartes interactives. Dans cet article, nous présentons un prototype pour la visualisation cartographique des requêtes SOLAP. Ce prototype se base sur une architecture orientée services (SOA). Dans ce prototype, le client SOLAP est totalement basé sur des représentations de données standard et des services web de visualisation cartographique.}, }
close
S. Bimonte, A. Hassan, P. Beanue
From design to visualization of spatial OLAP applications: A first prototyping methodology
The 4th International Workshop on MOdeling and REasoning for Business Intelligence, MORE-BI 201, Workshop of ER, 2016 , 14/11/2016-17/11/2016, Gifu, JPN (p. 113-123), Springer, 2016
abs web bib

The design of Spatial OLAP (SOLAP) applications consists of (i) Spatial Data Warehouse (SDW) model design and (ii) SOLAP visualization definition because a specific set of understandable and readable cartographic visualizations corresponds to a particular type of SOLAP query. Unfortunately few works investigate geovisualization issues in SOLAP systems and propose new methodologies to visualize spatio-temporal data, and no works investigate tools for readable SOLAP cartographic displays. Moreover, some works propose adhoc methodologies for DWs and SDWs exclusively based on data and user analysis requirements. Therefore, we present in this paper (i) a new geovisualization methodology for SOLAP queries that yields readable maps and (ii) a new prototyping design methodology for SOLAP applications that accounts for geovisualization requirements.
close

@inproceedings{PUB00053476, author = {Bimonte, S. and Hassan, A. and Beanue, P.}, title = {From design to visualization of spatial OLAP applications: A first prototyping methodology}, title = {De la conception à la visualisation des applications OLAP Spatial : une première méthodologie de prototypage}, bookTitle = {The 4th International Workshop on MOdeling and REasoning for Business Intelligence, MORE-BI 201, Workshop of ER, 2016 , 14/11/2016-17/11/2016, Gifu, JPN}, publisher = {Springer}, pages = {113-123}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053476}, year = {2016}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; AGAETIS CLERMONT FERRAND FRA}, abstract = {The design of Spatial OLAP (SOLAP) applications consists of (i) Spatial Data Warehouse (SDW) model design and (ii) SOLAP visualization definition because a specific set of understandable and readable cartographic visualizations corresponds to a particular type of SOLAP query. Unfortunately few works investigate geovisualization issues in SOLAP systems and propose new methodologies to visualize spatio-temporal data, and no works investigate tools for readable SOLAP cartographic displays. Moreover, some works propose adhoc methodologies for DWs and SDWs exclusively based on data and user analysis requirements. Therefore, we present in this paper (i) a new geovisualization methodology for SOLAP queries that yields readable maps and (ii) a new prototyping design methodology for SOLAP applications that accounts for geovisualization requirements.}, }
close
R. Djiroun, S. Bimonte
A data cube design and construction methodology based on OLAP queries
13th ACS/IEEE International Conference on Computer Systems and Applications AICCSA , 29/11/2016-02/12/2016, Agadir, MAR , 2016
abs web bib

Business Intelligence systems provide an effective solution for multidimensional online computing and analysis from large volumes of data. In the decision making process, analyzed data are typically stored in a set of cubes often heterogeneous. Most of the time, the structure of these cubes is unknown by decision makers. Our goal is to enable decision makers to express their need via a query in natural language. In this paper, we deal with the problem of data cube design and construction according to a user query where the expressed need is dispersed on more than one cube. We propose a cubes design and construction approach based on fusion of cubes containing a part of the user's need. We validate our approach via a tool, called "Design-Cubes-Query", that implements our approach and we show its use through a case study.
close

@inproceedings{PUB00053474, author = {Djiroun, R. and Bimonte, S.}, title = {A data cube design and construction methodology based on OLAP queries}, title = {Une méthodologie pour la conception et l’implémentation de cubes basée sur les requêtes OLAP}, bookTitle = {13th ACS/IEEE International Conference on Computer Systems and Applications AICCSA , 29/11/2016-02/12/2016, Agadir, MAR}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053474}, year = {2016}, affiliation = {LSI USTHB BAB EZZOUAR ALGER ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Business Intelligence systems provide an effective solution for multidimensional online computing and analysis from large volumes of data. In the decision making process, analyzed data are typically stored in a set of cubes often heterogeneous. Most of the time, the structure of these cubes is unknown by decision makers. Our goal is to enable decision makers to express their need via a query in natural language. In this paper, we deal with the problem of data cube design and construction according to a user query where the expressed need is dispersed on more than one cube. We propose a cubes design and construction approach based on fusion of cubes containing a part of the user's need. We validate our approach via a tool, called "Design-Cubes-Query", that implements our approach and we show its use through a case study.}, }
close
I. Ferrahi, S. Bimonte, K. Boukhalfa
Conception logique et physique des hiérarchies spatiales non strictes dans les entrepôts de données spatiales
SAGEO Spatial Analysis and Geomatics , 06/12/2016-09/12/2016, Nice, FRA , 2016
abs web bib

L’optimisation des performances des systèmes SOLAP ne cesse de susciter l’intérêt des chercheurs ces dernières années. Plusieurs techniques d’indexation ont été proposées pour atteindre cet objectif. La plupart des travaux effectués dans ce domaine s'est intéressée aux dimensions spatiales avec des hiérarchies spatiales strictes et peu de travaux se sont focalisés sur les hiérarchies spatiales non strictes. Nous montrons dans le présent article que les schémas logiques proposés dans la littérature ainsi que les techniques d’indexation ne sont pas adaptés aux hiérarchies spatiales non strictes. Nous proposons un nouveau schéma logique supportant les hiérarchies spatiales non strictes. Nous étendons ainsi l'index bitmap afin d'optimiser les requêtes définies sur des dimensions spatiales qui incluent ce type de hiérarchies spatiales. Nous montrons à travers une étude expérimentale l’efficacité de notre solution.
close

@inproceedings{PUB00053484, author = {Ferrahi, I. and Bimonte, S. and Boukhalfa, K.}, title = {Conception logique et physique des hiérarchies spatiales non strictes dans les entrepôts de données spatiales}, title = {Logical and physical design of non-strict spatial hierarchies of spatial data warehouses}, bookTitle = {SAGEO Spatial Analysis and Geomatics , 06/12/2016-09/12/2016, Nice, FRA}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00053484}, year = {2016}, affiliation = {UNIVERSITE M'HAMED BOUGARA ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DES SCIENCES ET DE LA TECHNOLOGIE HOUARI BOUMEDIENNE ALG}, abstract = {L’optimisation des performances des systèmes SOLAP ne cesse de susciter l’intérêt des chercheurs ces dernières années. Plusieurs techniques d’indexation ont été proposées pour atteindre cet objectif. La plupart des travaux effectués dans ce domaine s'est intéressée aux dimensions spatiales avec des hiérarchies spatiales strictes et peu de travaux se sont focalisés sur les hiérarchies spatiales non strictes. Nous montrons dans le présent article que les schémas logiques proposés dans la littérature ainsi que les techniques d’indexation ne sont pas adaptés aux hiérarchies spatiales non strictes. Nous proposons un nouveau schéma logique supportant les hiérarchies spatiales non strictes. Nous étendons ainsi l'index bitmap afin d'optimiser les requêtes définies sur des dimensions spatiales qui incluent ce type de hiérarchies spatiales. Nous montrons à travers une étude expérimentale l’efficacité de notre solution.}, }
close
L. Sautot, S. Bimonte, L. Journaux, A. Larrère, B. Faivre
Enrichissement de schéma multidimensionnel en constellation grâce à la classification ascendante hiérarchique
EGC 2016. 16ème conférence internationale francophone sur l'Extraction et la Gestion des Connaissances , 18/01/2016-22/01/2016, Reims, FRA (p. 6), 2016
abs web bib

Les hiérarchies sont des structures cruciales dans un entrepôt de données puisqu’elles permettent l’agrégation de mesures dans le but de proposer une vue analytique plus ou moins globale sur les données entreposées, selon le niveau hiérarchique auquel on se place. Cependant, peu de travaux s’intéressent à la construction de hiérarchies, via un algorithme de fouille de données, prenant en compte le contexte multidimensionnel de la dimension concernée. Dans cet article, nous proposons donc un algorithme, implémenté sur une architecture ROLAP, permettant d’enrichir une dimension avec des données factuelles.
close

@inproceedings{PUB00050617, author = {Sautot, L. and Bimonte, S. and Journaux, L. and Larrère, A. and Faivre, B.}, title = {Enrichissement de schéma multidimensionnel en constellation grâce à la classification ascendante hiérarchique}, bookTitle = {EGC 2016. 16ème conférence internationale francophone sur l'Extraction et la Gestion des Connaissances , 18/01/2016-22/01/2016, Reims, FRA}, pages = {6}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00050617}, year = {2016}, affiliation = {UNIVERSITE DE LYON CNRS LIRIS FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE BOURGOGNE FRA ; UNIVERSITE DE BOURGOGNE FRA ; UNIVERSITE DE BOURGOGNE FRA}, abstract = {Les hiérarchies sont des structures cruciales dans un entrepôt de données puisqu’elles permettent l’agrégation de mesures dans le but de proposer une vue analytique plus ou moins globale sur les données entreposées, selon le niveau hiérarchique auquel on se place. Cependant, peu de travaux s’intéressent à la construction de hiérarchies, via un algorithme de fouille de données, prenant en compte le contexte multidimensionnel de la dimension concernée. Dans cet article, nous proposons donc un algorithme, implémenté sur une architecture ROLAP, permettant d’enrichir une dimension avec des données factuelles.}, }
close
S. Bimonte, F. Johany, S. Lardon
A First Framework for Mutually Enhancing Chorem And Spatial OLAP Systems
International Conference on Data Management Technologies and Applications, 20/07/2015-22/07/2015, Colmar, FRA (p. 38-48), 2015
abs web bib

Spatial OLAP systems aim to interactively analyze huge volumes of geo-referenced data. They allow decision-makers to on-line explore and visualize warehoused spatial using pivot tables, graphical displays and interactive maps. On the other hand, it has been recently shown that chorem maps represent an excellent geovisualization technique to summarize spatial phenomena. Therefore, in this paper we introduce a framework being capable to merge the interactive analysis capability of SOLAP systems and the potentiality of a chorem-based visual notation in terms of visual summary. We also propose a general architecture based on standards to automatically extract and visualize chorems from SDWs according to our framework
close

@inproceedings{PUB00046017, author = {Bimonte, S. and Johany, F. and Lardon, S.}, title = {A First Framework for Mutually Enhancing Chorem And Spatial OLAP Systems}, title = {Un premier cadre pour le renforcement mutuellement des systemes SOLAP et Choremes }, bookTitle = {International Conference on Data Management Technologies and Applications, 20/07/2015-22/07/2015, Colmar, FRA}, pages = {38-48}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046017}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; INRA CLERMONT FERRAND UR MECF UMR METAFORT FRA ; INRA CLERMONT FERRAND UR MECF UMR METAFORT FRA}, abstract = {Spatial OLAP systems aim to interactively analyze huge volumes of geo-referenced data. They allow decision-makers to on-line explore and visualize warehoused spatial using pivot tables, graphical displays and interactive maps. On the other hand, it has been recently shown that chorem maps represent an excellent geovisualization technique to summarize spatial phenomena. Therefore, in this paper we introduce a framework being capable to merge the interactive analysis capability of SOLAP systems and the potentiality of a chorem-based visual notation in terms of visual summary. We also propose a general architecture based on standards to automatically extract and visualize chorems from SDWs according to our framework}, }
close
S. Bimonte
BI2 : un profil UML pour les indicateurs décisionnels
11èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, 02/04/2015-03/04/2015, Bruxelles, FRA (p. 1-16), RNTI, 2015
abs web bib

Aujourd’hui de plus en plus de données sont disponibles pour une analyse décisionnelle et reposent sur des indicateurs décisionnels. Bien que différentes technologies décisionnelles aient été développées, nous constatons le manque d’un cadre conceptuel pour la définition et l’implémentation de ces indicateurs. Dans ce papier, nous présentons une première classification de ces indicateurs. De plus, motivés par le besoin d’un formalisme pour la définition de ces indicateurs à un niveau conceptuel, nous présentons un profil UML BI2 qui permet de représenter des indicateurs OLAP, OLTP et stream. Nous présentons également leur implémentation dans les outils industriels existants.
close

@inproceedings{PUB00046018, author = {Bimonte, S.}, title = {BI2 : un profil UML pour les indicateurs décisionnels}, title = {BI2: A UML profile for decisional indicators}, volume = {B-11 }, bookTitle = {11èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, 02/04/2015-03/04/2015, Bruxelles, FRA}, publisher = {RNTI}, pages = { 1-16}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046018}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Aujourd’hui de plus en plus de données sont disponibles pour une analyse décisionnelle et reposent sur des indicateurs décisionnels. Bien que différentes technologies décisionnelles aient été développées, nous constatons le manque d’un cadre conceptuel pour la définition et l’implémentation de ces indicateurs. Dans ce papier, nous présentons une première classification de ces indicateurs. De plus, motivés par le besoin d’un formalisme pour la définition de ces indicateurs à un niveau conceptuel, nous présentons un profil UML BI2 qui permet de représenter des indicateurs OLAP, OLTP et stream. Nous présentons également leur implémentation dans les outils industriels existants.}, }
close
R. Djiroun, S. Bimonte, K. Boukhalfa
A first framework for top-K cubes queries
Modeling and Reasoning for Business Intelligence 2015, 19/10/2015-22/10/2015, Stockholm, SWE (p. 187-197), Springer, 2015
abs web bib

Data Warehouse (DW) and OLAP systems are effective solutions for the online analysis of large volumes of data structured as cubes. Usually organizations and enterprises require several cubes for their activities. In this context, we define a new kind of queries: “Top-k Cubes queries”. Top-K cubes queries allow searching the most relevant k-cubes among a collection of cubes. Then, in this paper we propose a first framework for Top-K cubes queries where queries are expressed in natural language to meet the easiness need of unskilled IT decision-makers. An implementation in a ROLAP architecture is also provided.
close

@inproceedings{PUB00046016, author = {Djiroun, R. and Bimonte, S. and Boukhalfa, K.}, title = {A first framework for top-K cubes queries}, title = {Un cadre pour les requêtes top-K cubes}, volume = {LNCS 9382}, bookTitle = {Modeling and Reasoning for Business Intelligence 2015, 19/10/2015-22/10/2015, Stockholm, SWE}, publisher = {Springer}, pages = {187-197}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046016}, year = {2015}, affiliation = {LSI USTHB ALGER ALG ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; LSI USTHB ALGER ALG}, abstract = {Data Warehouse (DW) and OLAP systems are effective solutions for the online analysis of large volumes of data structured as cubes. Usually organizations and enterprises require several cubes for their activities. In this context, we define a new kind of queries: “Top-k Cubes queries”. Top-K cubes queries allow searching the most relevant k-cubes among a collection of cubes. Then, in this paper we propose a first framework for Top-K cubes queries where queries are expressed in natural language to meet the easiness need of unskilled IT decision-makers. An implementation in a ROLAP architecture is also provided.}, }
close
L. Sautot, S. Bimonte, L. Journaux, B. Faivre
Mixed driven refinement design of multidimensional models based on agglomerative hierarchical clustering
17th International Conference on Enterprise Information Systems , 27/04/2015-30/04/2015, Barcelone, ESP (p. 547-555), 2015
abs web bib

Data warehouses (DW) and OLAP systems are business intelligence technologies allowing the on-line analysis of huge volume of data according to users’ needs. The success of DW projects essentially depends on the design phase where functional requirements meet data sources (mixed design methodology). However, when dealing with complex applications existing design methodologies seem inefficient since decision-makers define functional requirements that cannot be deduced from data sources (data driven approach) and/or they have not sufficient application domain knowledge (user driven approach). Therefore, in this paper we propose a new mixed refinement design methodology where the classical data-driven approach is enhanced with data mining to create new dimensions hierarchies. A tool implementing our approach is also presented to validate our theoretical proposal.
close

@inproceedings{PUB00044903, author = {Sautot, L. and Bimonte, S. and Journaux, L. and Faivre, B.}, title = {Mixed driven refinement design of multidimensional models based on agglomerative hierarchical clustering}, title = {Méthodologie mixte de conception de schémas multidimensionnels basée sur le clustering hiérarchique}, bookTitle = {17th International Conference on Enterprise Information Systems , 27/04/2015-30/04/2015, Barcelone, ESP}, pages = {547-555}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00044903}, year = {2015}, affiliation = {UNIVERSITE DE BOURGOGNE FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE BOURGOGNE FRA ; UNIVERSITE DE BOURGOGNE FRA}, abstract = {Data warehouses (DW) and OLAP systems are business intelligence technologies allowing the on-line analysis of huge volume of data according to users’ needs. The success of DW projects essentially depends on the design phase where functional requirements meet data sources (mixed design methodology). However, when dealing with complex applications existing design methodologies seem inefficient since decision-makers define functional requirements that cannot be deduced from data sources (data driven approach) and/or they have not sufficient application domain knowledge (user driven approach). Therefore, in this paper we propose a new mixed refinement design methodology where the classical data-driven approach is enhanced with data mining to create new dimensions hierarchies. A tool implementing our approach is also presented to validate our theoretical proposal.}, }
close
L. Sautot, S. Bimonte, L. Journaux, B. Faivre
Une nouvelle approche mixte d’enrichissement de dimensions dans un schéma multidimensionnel en constellation : application à la biodiversité des oiseaux
11èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, 02/04/2015-03/04/2015, Bruxelles, BEL (p. 65-80), RNTI, 2015
abs web bib

Les entrepôts de données (DW) et les systèmes OLAP sont des technologies d’analyse en ligne pour de grands volumes de données, basés sur les besoins des utilisateurs. Leur succès dépend essentiellement de la phase de conception où les exigences fonctionnelles sont confrontées aux sources de données (méthodologie de conception mixte). Cependant, les méthodes de conception existantes semblent parfois inefficaces, lorsque les décideurs définissent des exigences fonctionnelles qui ne peuvent être déduites à partir des sources de données (approche centrée sur les données), ou lorsque le décideur n’a pas intégré tous ces besoins durant la phase de conception (approche centrée sur l’utilisateur). Cet article propose une nouvelle méthodologie mixte d’enrichissement de schémas en constellation, où l’approche classique de conception est améliorée grâce à la fouille de données dans le but de créer de nouvelles hiérarchies au sein d’une dimension. Un prototype associé est également présenté.
close

@inproceedings{PUB00046019, author = {Sautot, L. and Bimonte, S. and Journaux, L. and Faivre, B.}, title = {Une nouvelle approche mixte d’enrichissement de dimensions dans un schéma multidimensionnel en constellation : application à la biodiversité des oiseaux}, title = {A new dimension enrichment mixed approach in a multidimensional constellation diagram: Application to bird biodiversity}, bookTitle = {11èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, 02/04/2015-03/04/2015, Bruxelles, BEL}, publisher = {RNTI}, pages = {65-80}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046019}, year = {2015}, affiliation = {CNRS DIJON FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; CNRS DIJON FRA ; AGROSUP DIJON FRA}, abstract = {Les entrepôts de données (DW) et les systèmes OLAP sont des technologies d’analyse en ligne pour de grands volumes de données, basés sur les besoins des utilisateurs. Leur succès dépend essentiellement de la phase de conception où les exigences fonctionnelles sont confrontées aux sources de données (méthodologie de conception mixte). Cependant, les méthodes de conception existantes semblent parfois inefficaces, lorsque les décideurs définissent des exigences fonctionnelles qui ne peuvent être déduites à partir des sources de données (approche centrée sur les données), ou lorsque le décideur n’a pas intégré tous ces besoins durant la phase de conception (approche centrée sur l’utilisateur). Cet article propose une nouvelle méthodologie mixte d’enrichissement de schémas en constellation, où l’approche classique de conception est améliorée grâce à la fouille de données dans le but de créer de nouvelles hiérarchies au sein d’une dimension. Un prototype associé est également présenté.}, }
close
S. Bimonte, O. Boucelma, O. Machabert, S. Sellami
From Volunteered Geographic Information to Volunteered Geographic OLAP: A VGI data quality-based approach
14th International Conference Computational Science and Its Applications (ICCSA 2014) , 30/06/2014-03/07/2014, Guimarães, PRT (p. 69-80), Springer, 2014
abs web bib

Volunteered Geographic Information (VGI) represents a valuable source of information. At the same time this data presents new data quality issues such as credibility. In this paper, we investigate the integration of VGI in Spatial OLAP (SOLAP) systems, which allow analyzing huge volume of geographic datasets. By means of a real case study, we highlight the similarities and differences of these two kinds of systems. We propose a methodology to handle VGI data quality issues during the warehousing and OLAPing phases. In particular, we define a new aggregation ETL operator based on the VGI credibility. We also present a spatio-multidimensional model that provides decision-makers with a general description of the correctness of the SOLAP aggregations.
close

@inproceedings{PUB00041328, author = {Bimonte, S. and Boucelma, O. and Machabert, O. and Sellami, S.}, title = {From Volunteered Geographic Information to Volunteered Geographic OLAP: A VGI data quality-based approach}, title = {De l'information géographique volontaire à l'OLAP géographique volontaire : une approche basée sur la qualité}, volume = {8582}, bookTitle = {14th International Conference Computational Science and Its Applications (ICCSA 2014) , 30/06/2014-03/07/2014, Guimarães, PRT}, publisher = {Springer}, pages = {69-80}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041328}, year = {2014}, affiliation = {IRSTEA UR TSCF FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA}, abstract = {Volunteered Geographic Information (VGI) represents a valuable source of information. At the same time this data presents new data quality issues such as credibility. In this paper, we investigate the integration of VGI in Spatial OLAP (SOLAP) systems, which allow analyzing huge volume of geographic datasets. By means of a real case study, we highlight the similarities and differences of these two kinds of systems. We propose a methodology to handle VGI data quality issues during the warehousing and OLAPing phases. In particular, we define a new aggregation ETL operator based on the VGI credibility. We also present a spatio-multidimensional model that provides decision-makers with a general description of the correctness of the SOLAP aggregations.}, }
close
S. Bimonte, J-P. Chanet, Capdeville J., A. Tailleur, M. Luciano
Une étude sur l’efficacité des méthodes de conception et d’implémentation pour les Entrepôts de Données par une méthodologie « requirement-based » : cas d’étude de la consommation d’énergie en agriculture
10ème journées francophone sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy (p. 119-128), RNTI, 2014
abs web bib

Les entrepôts de données et les systèmes OLAP permettent aux décideurs d’explorer et d’analyser d’énormes volumes de données modélisées suivant un modèle multidimensionnel et extraites de sources de données hétérogènes. En général, la conception d’un ED est compliqué, et demande du temps et de nombreuses ressources. De plus des experts en ED sont nécessaires pendant les phases de conception et d’implémentation. Dans cet article, nous présentons une nouvelle méthodologie et un outil permettant aux modélisateurs (ne connaissant pas les ED) de concevoir et d’implémenter des ED pour analyser eux-mêmes des données résultantes de simulation, sans l’intervention d’expert en ED.
close

@inproceedings{PUB00041330, author = {Bimonte, S. and Chanet, J-P. and Capdeville, J., and Tailleur, A. and Luciano, M.}, title = {Une étude sur l’efficacité des méthodes de conception et d’implémentation pour les Entrepôts de Données par une méthodologie « requirement-based » : cas d’étude de la consommation d’énergie en agriculture}, title = {A study of efficacity of desing and implementation methods for data warehoses using a requirement-based approach: Study case of agricultural energy consommations}, volume = {B.10}, bookTitle = {10ème journées francophone sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy}, publisher = {RNTI}, pages = {119-128}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041330}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; INSTITUT DE L'ELEVAGE CASTANET TOLOSAN FRA ; ARVALIS INSTITUT DU VEGETAL LA CHAPELLE SAINT SAUVEUR FRA ; ARVALIS INSTITUT DU VEGETAL LA CHAPELLE SAINT SAUVEUR FRA}, abstract = {Les entrepôts de données et les systèmes OLAP permettent aux décideurs d’explorer et d’analyser d’énormes volumes de données modélisées suivant un modèle multidimensionnel et extraites de sources de données hétérogènes. En général, la conception d’un ED est compliqué, et demande du temps et de nombreuses ressources. De plus des experts en ED sont nécessaires pendant les phases de conception et d’implémentation. Dans cet article, nous présentons une nouvelle méthodologie et un outil permettant aux modélisateurs (ne connaissant pas les ED) de concevoir et d’implémenter des ED pour analyser eux-mêmes des données résultantes de simulation, sans l’intervention d’expert en ED. }, }
close
S. Bimonte, O. Boucelma, O. Machabert, S. Sellami
Une approche spatio-multidimensionnelle pour l’analyse des aléas environnementaux
10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA , 05/06/2014-05/06/2014, Vichy, FRA (p. 67-76), RNTI, 2014
abs web bib

Les entrepôts de données spatiales et les systèmes SOLAP permettent l’analyse en ligne de gros volumes de données géo-référencées. Dans un contexte de gestion des risques naturels, ces systèmes ont été utilisés avec succès sur des données officielles dont la collecte suit un processus bien établi. Le développement récent d’outils collaboratifs pour la saisie de données géographiques, y compris par des utilisateurs non-experts a engendré un nouveau concept : celui de l’Information Géographique Volontaires (VGI), et a créé un besoin et une opportunité pour prendre en compte ces données dans un processus décisionnel. Dans cet article, nous décrivons un modèle et un système patiomultidimensionnel permettant l’utilisation conjointe des données VGI avec des systèmes SOLAP pour l’analyse des aléas environnementaux.
close

@inproceedings{PUB00041334, author = {Bimonte, S. and Boucelma, O. and Machabert, O. and Sellami, S.}, title = {Une approche spatio-multidimensionnelle pour l’analyse des aléas environnementaux}, title = {A spatio-multidimensional approach for the analysis of environmental hazards}, volume = {B.10}, bookTitle = {10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA , 05/06/2014-05/06/2014, Vichy, FRA}, publisher = {RNTI}, pages = {67-76}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041334}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA}, abstract = {Les entrepôts de données spatiales et les systèmes SOLAP permettent l’analyse en ligne de gros volumes de données géo-référencées. Dans un contexte de gestion des risques naturels, ces systèmes ont été utilisés avec succès sur des données officielles dont la collecte suit un processus bien établi. Le développement récent d’outils collaboratifs pour la saisie de données géographiques, y compris par des utilisateurs non-experts a engendré un nouveau concept : celui de l’Information Géographique Volontaires (VGI), et a créé un besoin et une opportunité pour prendre en compte ces données dans un processus décisionnel. Dans cet article, nous décrivons un modèle et un système patiomultidimensionnel permettant l’utilisation conjointe des données VGI avec des systèmes SOLAP pour l’analyse des aléas environnementaux.}, }
close
S. Bimonte, N. Dumoulin
SimOLAP: A system for the semi-automatic implementation of simulation datawarehouses
10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-06/06/2014, Vichy (p. 4), RNTI, 2014
abs web bib

Data Warehouses and OLAP systems allow decision-makers exploring and analyzing huge volumes of data modeled according the multidimensional model, and extracted from heterogeneous data sources. Usually, DW design is a complex, and time and resources consuming task. Then, DWexperts are necessary during design and implementation phases. In this paper, we present a new methodology and a tool allowing modelers (DW unskilled users) to design and implement DWs for analyzing simulation results data by themselves, without any intervention of DW experts.
close

@inproceedings{PUB00040995, author = {Bimonte, S. and Dumoulin, N.}, title = {SimOLAP: A system for the semi-automatic implementation of simulation datawarehouses}, title = {SimOLAP : un système pour l'implémentation semi-automatique d'entrepôts de données de simulation}, bookTitle = {10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-06/06/2014, Vichy}, publisher = {RNTI}, pages = {4}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040995}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR LISC FRA}, abstract = {Data Warehouses and OLAP systems allow decision-makers exploring and analyzing huge volumes of data modeled according the multidimensional model, and extracted from heterogeneous data sources. Usually, DW design is a complex, and time and resources consuming task. Then, DWexperts are necessary during design and implementation phases. In this paper, we present a new methodology and a tool allowing modelers (DW unskilled users) to design and implement DWs for analyzing simulation results data by themselves, without any intervention of DW experts.}, }
close
S. Bimonte, J.P. Chanet, J. Capdeville, Y. Lefrileux
Energetic assessment of dairy activities using OLAP systems
AgEng 2014 International conference on agricultural engineering, 06/07/2014-10/07/2014, Zurich , DEU (p. 10), 2014
abs web bib

Agricultural energy consumption is an important economic, environmental and social issue. The French national project EDEN aims at the analysis of energies consummations for two main activities: Agricultural productions and dairy activities using OLAP systems. In this paper, we focus on energetic assessment of dairy activities. We present a multidimensional model allowing for monitoring of energies used for dairy activities. The developed model is complex but in counterpart it allows for analysis of inputs, outputs and their relations of the dairy farm system. In this way decision-makers can understand and correlate energetic trends overall the global production process.
close

@inproceedings{PUB00040950, author = {Bimonte, S. and Chanet, J.P. and Capdeville, J. and Lefrileux, Y.}, title = {Energetic assessment of dairy activities using OLAP systems }, title = {Bilan énergétique des activités laitières en utilisant des systèmes OLAP}, bookTitle = {AgEng 2014 International conference on agricultural engineering, 06/07/2014-10/07/2014, Zurich , DEU}, pages = {10}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040950}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; INSTITUT DE L'ELEVAGE CASTANET TOLOSAN FRA ; INSTITUT DE L'ELEVAGE CASTANET TOLOSAN FRA}, abstract = {Agricultural energy consumption is an important economic, environmental and social issue. The French national project EDEN aims at the analysis of energies consummations for two main activities: Agricultural productions and dairy activities using OLAP systems. In this paper, we focus on energetic assessment of dairy activities. We present a multidimensional model allowing for monitoring of energies used for dairy activities. The developed model is complex but in counterpart it allows for analysis of inputs, outputs and their relations of the dairy farm system. In this way decision-makers can understand and correlate energetic trends overall the global production process. }, }
close
S. Bimonte, O. Machabert, O. Boucelma, S. Sellami
Une approche spatio-multidimensionnelle pour l’analyse des aléas environnementaux
Systèmes d’information pour l’environnement, 20/05/2014-23/05/2014, Lyon, FRA (p. 14), 2014
abs web bib

Les entrepôts de données spatiales et les systèmes SOLAP permettent l’analyse en ligne de gros volumes de données géo-référencées. Dans un contexte de gestion des risques naturels, ces systèmes ont été utilisés avec succès sur des données officielles dont la collecte suit un processus bien établi. Le développement récent d’outils collaboratifs pour la saisie de données géographiques, y compris par des utilisateurs non-experts a engendré un nouveau concept : celui de l’Information Géographique Volontaires (VGI), et a créé un besoin et une opportunité pour prendre en compte ces données dans un processus décisionnel. Dans cet article, nous décrivons un modèle et un système spatio-multidimensionnel permettant l’utilisation conjointe des données VGI avec des systèmes SOLAP pour l’analyse des aléas environnementaux.
close

@inproceedings{PUB00040927, author = {Bimonte, S. and Machabert, O. and Boucelma, O. and Sellami, S.}, title = {Une approche spatio-multidimensionnelle pour l’analyse des aléas environnementaux}, title = {A Spatial OLAP approach for evaluating natural hazards in a volunteered geographic information context}, bookTitle = {Systèmes d’information pour l’environnement, 20/05/2014-23/05/2014, Lyon, FRA}, pages = {14}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040927}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA ; UNIVERSITE D'AIX MARSEILLE FRA}, abstract = {Les entrepôts de données spatiales et les systèmes SOLAP permettent l’analyse en ligne de gros volumes de données géo-référencées. Dans un contexte de gestion des risques naturels, ces systèmes ont été utilisés avec succès sur des données officielles dont la collecte suit un processus bien établi. Le développement récent d’outils collaboratifs pour la saisie de données géographiques, y compris par des utilisateurs non-experts a engendré un nouveau concept : celui de l’Information Géographique Volontaires (VGI), et a créé un besoin et une opportunité pour prendre en compte ces données dans un processus décisionnel. Dans cet article, nous décrivons un modèle et un système spatio-multidimensionnel permettant l’utilisation conjointe des données VGI avec des systèmes SOLAP pour l’analyse des aléas environnementaux.}, }
close
E. Edoh-Alove, S. Bimonte, Y. Bédard
A new design method for managing spatial vagueness in classical relational Spatial OLAP Architectures
14th International Conference Computational Science and Its Applications (ICCSA 2014) , 30/06/2014-03/07/2014, Guimarães, PRT (p. 774-786), Springer, 2014
abs web bib

Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems are well-known Business Intelligence technologies that aim to support multidimensional and online analysis of huge volumes of datasets with spatial reference. Spatial vagueness is one of the most neglected imperfections of spatial data. Although several works propose new ad-hoc models for handling spatial vagueness in information systems, the implementation of those models in Spatial DBMS and SDW is still in an embryonic state. Thus, in this paper, we present a new design method for SOLAP datacubes that allows handling vague spatial data analysis issues. This method relies on a risk management method applied to the potential risks of data misinterpretation and decision-makers’ tolerance levels to those risks. We also present a system implementing our method
close

@inproceedings{PUB00041329, author = {Edoh-Alove, E. and Bimonte, S. and Bédard, Y.}, title = {A new design method for managing spatial vagueness in classical relational Spatial OLAP Architectures}, title = {Une nouvelle méthodologie pour la gestion du vague spatial dans les architectures Spatial OLAP classiques}, volume = { 8580}, bookTitle = {14th International Conference Computational Science and Its Applications (ICCSA 2014) , 30/06/2014-03/07/2014, Guimarães, PRT}, publisher = {Springer}, pages = {774-786}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041329}, year = {2014}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE LAVAL CAN}, abstract = {Spatial Data Warehouses (SDW) and Spatial OLAP (SOLAP) systems are well-known Business Intelligence technologies that aim to support multidimensional and online analysis of huge volumes of datasets with spatial reference. Spatial vagueness is one of the most neglected imperfections of spatial data. Although several works propose new ad-hoc models for handling spatial vagueness in information systems, the implementation of those models in Spatial DBMS and SDW is still in an embryonic state. Thus, in this paper, we present a new design method for SOLAP datacubes that allows handling vague spatial data analysis issues. This method relies on a risk management method applied to the potential risks of data misinterpretation and decision-makers’ tolerance levels to those risks. We also present a system implementing our method}, }
close
N. Koueya, S. Bimonte, E. Mephu Nguifo
Une nouvelle approche d’estimation pour les entrepôts de données multi-granulaires incomplètes
10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy, FRA (p. 129-144), RNTI, 2014
abs web bib

Les entrepôts de données contiennent souvent les mesures incomplètes, et cela peut influencer négativement sur le processus d’analyse. Les méthodes sont proposées dans la littérature pour estimer les faits incomplets ous manquants. Cependant, ces méthodes ne prennent pas en compte les caractéristiques essentielles des entrepôts de données à savoir la hiérarchie multidimensionnelle et la présence éventuelle des mesures agrégées. Nous proposons dans cet article une approche qui adapte les fonctions d’estimation existantes pour la prise en compte de ces caractéristiques.
close

@inproceedings{PUB00041335, author = {Koueya, N. and Bimonte, S. and Mephu Nguifo, E.}, title = {Une nouvelle approche d’estimation pour les entrepôts de données multi-granulaires incomplètes}, title = {A new approach for estimating data in incomplete and multi granular data warehouses}, volume = {B.10}, bookTitle = {10èmes journées francophones sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy, FRA}, publisher = {RNTI}, pages = {129-144}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041335}, year = {2014}, affiliation = {UNIVERSITE DE DSCHANG CAM ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA}, abstract = {Les entrepôts de données contiennent souvent les mesures incomplètes, et cela peut influencer négativement sur le processus d’analyse. Les méthodes sont proposées dans la littérature pour estimer les faits incomplets ous manquants. Cependant, ces méthodes ne prennent pas en compte les caractéristiques essentielles des entrepôts de données à savoir la hiérarchie multidimensionnelle et la présence éventuelle des mesures agrégées. Nous proposons dans cet article une approche qui adapte les fonctions d’estimation existantes pour la prise en compte de ces caractéristiques.}, }
close
H. Nazih, M. Kang, S. Bimonte
ProtOLAP : un système de prototypage rapide pour les entrepôts de données
10ème journées francophone sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy, FRA (p. 167-170), RNTI, 2014
abs web bib

Les approches disponibles pour concevoir un entrepôt de données, y compris celles adoptant les pratiques agiles, sont basées sur l’hypothèse que les données sources sont connues et disponibles à l’avance. Cette hypothèse n’est pas toujours vraie dans certains contextes. Pour pallier ces limites, nous proposons ProtOLAP, une méthodologie assistée par un outil de prototypage rapide.
close

@inproceedings{PUB00041336, author = {Nazih, H. and Kang, M. and Bimonte, S.}, title = {ProtOLAP : un système de prototypage rapide pour les entrepôts de données}, title = {ProtOLAP: A system for rapid data warehouse prototyping}, volume = {B.10}, bookTitle = {10ème journées francophone sur les Entrepôts de Données et l’Analyse en ligne EDA, 05/06/2014-05/06/2014, Vichy, FRA}, publisher = {RNTI}, pages = {167-170}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041336}, year = {2014}, affiliation = {UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Les approches disponibles pour concevoir un entrepôt de données, y compris celles adoptant les pratiques agiles, sont basées sur l’hypothèse que les données sources sont connues et disponibles à l’avance. Cette hypothèse n’est pas toujours vraie dans certains contextes. Pour pallier ces limites, nous proposons ProtOLAP, une méthodologie assistée par un outil de prototypage rapide.}, }
close
L. Sautot, S. Bimonte, L. Journaux, B. Faivre
A methodology and tool for rapid prototyping of data warehouses using data mining: Application to birds biodiversity
4th International Conference on Model & Data Engineering (MEDI’2014) , 24/09/2014-26/09/2014, Larnaca, CYP / Model and Data Engineering (p. 8), Springer, 2014
abs web bib

Data Warehouses (DWs) are large repositories of data aimed at supporting the decision-making process by enabling flexible and interactive analyses via OLAP systems. Rapid prototyping of DWs is necessary when OLAP applications are complex. Some work about the integration of Data Mining and OLAP systems has been done to enhance OLAP operators with mined indicators, and/or to define the DW schema. However, to best of our knowledge, prototyping methods for DWs do not support this kind of integration. Then, in this paper we present a new prototyping methodology for DWs, extending [3], where DM methods are used to define the DW schema. We validate our approach on a real data set concerning bird biodiversity
close

@inproceedings{PUB00041332, author = {Sautot, L. and Bimonte, S. and Journaux, L. and Faivre, B.}, title = {A methodology and tool for rapid prototyping of data warehouses using data mining: Application to birds biodiversity}, title = {Une méthodologie et un outil pour le prototypage rapide des entrepôts de données en utilisant le data mining : application à la biodiversité des oiseaux}, volume = {8748}, bookTitle = {4th International Conference on Model & Data Engineering (MEDI’2014) , 24/09/2014-26/09/2014, Larnaca, CYP / Model and Data Engineering}, publisher = {Springer}, pages = {8}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00041332}, year = {2014}, affiliation = {UNIVERSITE DE BOURGOGNE DIJON FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE BOURGOGNE DIJON FRA ; UNIVERSITE DE BOURGOGNE DIJON FRA}, ISBNISSN = {ISBN 978-3-319-11586-3}, abstract = {Data Warehouses (DWs) are large repositories of data aimed at supporting the decision-making process by enabling flexible and interactive analyses via OLAP systems. Rapid prototyping of DWs is necessary when OLAP applications are complex. Some work about the integration of Data Mining and OLAP systems has been done to enhance OLAP operators with mined indicators, and/or to define the DW schema. However, to best of our knowledge, prototyping methods for DWs do not support this kind of integration. Then, in this paper we present a new prototyping methodology for DWs, extending [3], where DM methods are used to define the DW schema. We validate our approach on a real data set concerning bird biodiversity}, }
close
S. Bimonte, K. Boulil, F. Pinet, M.A. Kang
Design of complex spatio-multidimensional models with the ICSOLAP UML Profile: An implementation in MagicDraw
15th International Conference on Enterprise Information Systems (ICEIS), 04/07/2013-07/07/2013, Angers, FRA (p. 310-315), 2013
abs web bib

Spatial Data Warehouse and SOLAP systems allow analyzing huge volume of georeferenced data. SOLAP applications are usually complex needing advanced static and dynamic modelling properties. In particular, SOLAP applications require: multi-granular measures and complex aggregations based on aggregate functions depending on dimensions, hierarchies and levels. In this demo paper, motivated by the lack of conceptual spatio-multidimensional models based on standard languages and supporting such complex modelling requirements, we present a new UML profile for complex spatial data cubes. We implement our profile in the commercial CASE tool called MagicDraw. Using a real environmental case study, we show the theoretical and technical effectiveness of our proposal.
close

@inproceedings{PUB00040429, author = {Bimonte, S. and Boulil, K. and Pinet, F. and Kang, M.A.}, title = {Design of complex spatio-multidimensional models with the ICSOLAP UML Profile: An implementation in MagicDraw }, bookTitle = {15th International Conference on Enterprise Information Systems (ICEIS), 04/07/2013-07/07/2013, Angers, FRA}, pages = {310-315}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040429}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE BLAISE PASCAL LIMOS CLERMONT FERRAND FRA}, abstract = {Spatial Data Warehouse and SOLAP systems allow analyzing huge volume of georeferenced data. SOLAP applications are usually complex needing advanced static and dynamic modelling properties. In particular, SOLAP applications require: multi-granular measures and complex aggregations based on aggregate functions depending on dimensions, hierarchies and levels. In this demo paper, motivated by the lack of conceptual spatio-multidimensional models based on standard languages and supporting such complex modelling requirements, we present a new UML profile for complex spatial data cubes. We implement our profile in the commercial CASE tool called MagicDraw. Using a real environmental case study, we show the theoretical and technical effectiveness of our proposal. }, }
close
S. Bimonte, E. Edoh-Alove, H. Nazih, M. Kang, S. Rizzi
ProtOLAP: Rapid OLAP prototyping with on-demand data supply
International workshop on Data warehousing and OLAP, 28/10/2013-28/10/2013, San Francisco, USA (p. 61-66), 2013
abs web bib

The approaches to data warehouse design are based on the assumption that source data are known in advance and available. While this assumption is true in common project situations, in some peculiar contexts it is not. This is the case of the French national project for analysis of energetic agricultural farms, that is the case study of this paper. Here, the above-mentioned methods can hardly be applied because source data can only be identified and collected once user requirements indicate a need. Besides, the users involved in this project found it very hard to express their analysis needs in abstract terms, i.e., without visualizing sample results of queries, which in turn would require availability of source data. To solve this deadlock we propose ProtOLAP, a tool-assisted fast prototyping methodology that enables quick and reliable test and validation of data warehouse schemata in situations where data supply is collected on users’ demand and users’ ICT skills are minimal. To this end, users manually feed sample realistic data into a prototype created by designers, then they access and explore these sample data using pivot tables to validate the prototype.
close

@inproceedings{PUB00040806, author = {Bimonte, S. and Edoh-Alove, E. and Nazih, H. and Kang, M. and Rizzi, S.}, title = {ProtOLAP: Rapid OLAP prototyping with on-demand data supply}, title = {ProtOLAP : Prototypage OLAP rapide avec des données à la demande}, bookTitle = {International workshop on Data warehousing and OLAP, 28/10/2013-28/10/2013, San Francisco, USA}, pages = {61-66}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040806}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; ISIMA AUBIERE FRA ; UNIVERSITY BOLOGNA ITA}, abstract = {The approaches to data warehouse design are based on the assumption that source data are known in advance and available. While this assumption is true in common project situations, in some peculiar contexts it is not. This is the case of the French national project for analysis of energetic agricultural farms, that is the case study of this paper. Here, the above-mentioned methods can hardly be applied because source data can only be identified and collected once user requirements indicate a need. Besides, the users involved in this project found it very hard to express their analysis needs in abstract terms, i.e., without visualizing sample results of queries, which in turn would require availability of source data. To solve this deadlock we propose ProtOLAP, a tool-assisted fast prototyping methodology that enables quick and reliable test and validation of data warehouse schemata in situations where data supply is collected on users’ demand and users’ ICT skills are minimal. To this end, users manually feed sample realistic data into a prototype created by designers, then they access and explore these sample data using pivot tables to validate the prototype.}, }
close
S. Bimonte, M. Kang, J. Trujillo
Integration of Spatial Networks in Data Warehouses: A UML Profile
13th International Conference Computational Science and Its Applications - ICCSA 2013, 24/06/2013-27/06/2013, Ho Chi Minh City, VNM (p. 253 -267 ), Springer-Verlag, 2013
abs web bib

Spatial Data Warehouses (SDW) and Spatial Online Analytical Processing (OLAP) systems are Business Intelligence technologies allowing efficient and interactive analysis of huge volume of geo-referenced data. Some efforts have been done to integrate complex spatial data such as field, generalized spatial data, etc., in such systems, at conceptual and physical levels. However, existing works do not support spatial networks (i.e. road networks), which define topological connections between spatial data. Thus, mandatory analysis capabilities offered by spatial networks cannot be introduced in the decision-making process powered by SOLAP systems. In this paper, motivated by relevance of using standards for the conceptual design of Data Warehouses and Geographic Information Systems, we propose a UML profile for data warehouses integrating spatial networks. We define our conceptual model in the Computer-Aided Software Engineering tool MagicDraw, and we propose a relational implementation in Oracle Spatial
close

@inproceedings{PUB00040808, author = {Bimonte, S. and Kang, M. and Trujillo, J.}, title = {Integration of Spatial Networks in Data Warehouses: A UML Profile}, title = {Intégration des réseaux spatiaux dans les entrepôts de données : un profil uml}, volume = {7974}, bookTitle = {13th International Conference Computational Science and Its Applications - ICCSA 2013, 24/06/2013-27/06/2013, Ho Chi Minh City, VNM}, publisher = {Springer-Verlag}, pages = {253 -267 }, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040808}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; ISIMA AUBIERE FRA ; UNIVERSITE ALICANTE ESP}, abstract = {Spatial Data Warehouses (SDW) and Spatial Online Analytical Processing (OLAP) systems are Business Intelligence technologies allowing efficient and interactive analysis of huge volume of geo-referenced data. Some efforts have been done to integrate complex spatial data such as field, generalized spatial data, etc., in such systems, at conceptual and physical levels. However, existing works do not support spatial networks (i.e. road networks), which define topological connections between spatial data. Thus, mandatory analysis capabilities offered by spatial networks cannot be introduced in the decision-making process powered by SOLAP systems. In this paper, motivated by relevance of using standards for the conceptual design of Data Warehouses and Geographic Information Systems, we propose a UML profile for data warehouses integrating spatial networks. We define our conceptual model in the Computer-Aided Software Engineering tool MagicDraw, and we propose a relational implementation in Oracle Spatial}, }
close
S. Bimonte, S. Sellami, O. Boucelma, B. Murgante
From volunteered geographic information to volunteered geographic OLAP: A new challenge
13e Conférence Francophone sur l'Extraction et la Gestion des Connaissances , 29/01/2013-01/02/2013, Toulouse, FRA (p. 2), 2013
abs web bib

Data acquisition technologies such as sensor networks, satellites, etc. has led to a deluge of geo-referenced data.geo-referenced data. To help decision makers, Spatial Data Mining and Spatial OLAP systems have been developed for exploring and synthesizing huge volume of geo-referenced heterogeneous data. These systems rely on closed, well-integrated and structured (according to an analysis goals model, the so-called spatio-multidimensional model) huge data sets. On the other hand, new geographic technologies such as geospatial positioning, web mapping and wikis gave birth to Collaborative Web-based maps systems that allow experts and amateurs (volunteers) to create and share thematic oriented geographic information, leading to the concept of Volunteered geographic information (VGI). While VGI systems are gaining momentum, they suffer from drawbacks such as weak data credibility and quality ; and they do not provide techniques to efficient handle analysis of historical data. As a result, there is a urgent need for investigating the integration of VGI into SOLAP : the work described in this paper attempts to fulfill this need.
close

@inproceedings{PUB00037698, author = {Bimonte, S. and Sellami, S. and Boucelma, O. and Murgante, B.}, title = {From volunteered geographic information to volunteered geographic OLAP: A new challenge}, title = {De l'information géographique volontaire à l'OLAP géographique volontaire : un nouveau défi}, bookTitle = {13e Conférence Francophone sur l'Extraction et la Gestion des Connaissances , 29/01/2013-01/02/2013, Toulouse, FRA}, pages = {2}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00037698}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; LSIS MARSEILLE FRA ; LSIS MARSEILLE FRA ; UNIVERSITA DEGLI STUDI DELLA BASILICATA ITA}, abstract = {Data acquisition technologies such as sensor networks, satellites, etc. has led to a deluge of geo-referenced data.geo-referenced data. To help decision makers, Spatial Data Mining and Spatial OLAP systems have been developed for exploring and synthesizing huge volume of geo-referenced heterogeneous data. These systems rely on closed, well-integrated and structured (according to an analysis goals model, the so-called spatio-multidimensional model) huge data sets. On the other hand, new geographic technologies such as geospatial positioning, web mapping and wikis gave birth to Collaborative Web-based maps systems that allow experts and amateurs (volunteers) to create and share thematic oriented geographic information, leading to the concept of Volunteered geographic information (VGI). While VGI systems are gaining momentum, they suffer from drawbacks such as weak data credibility and quality ; and they do not provide techniques to efficient handle analysis of historical data. As a result, there is a urgent need for investigating the integration of VGI into SOLAP : the work described in this paper attempts to fulfill this need.}, }
close
E. Donnat, D. Boffety, M. Pradel, A. Tailleur, S. Bimonte, J.P. Chanet
Évaluation fine des performances énergétiques des exploitations agricoles par l’utilisation des NTIC
Casdar Innovation et Partenariat. Résultats de l'appel à projets 2008, Journée de restitution , 06/06/2013-06/06/2013, Paris, FRA (p. 87-102), GIS Relance Agronomique, Paris, 2013
abs web bib

Les données utiles au calcul d’indicateurs de performances énergétiques des exploitations agricoles à différentes échelles nécessitent une collecte plus fine et un stockage plus important d’informations auxquels seules les avancées technologiques peuvent répondre. Un travail de recensement des solutions technologiques existantes montre que de plus en plus de solutions sont aujourd’hui disponibles, notamment sur les nouveaux agroéquipements, pour fournir un grand nombre de données utiles au calcul de ces indicateurs. Un important travail reste cependant à réaliser pour proposer aux agriculteurs des solutions bas-coûts, faciles à mettre en ½uvre et totalement adaptées à leurs besoins pour faciliter la mesure, la collecte et le stockage des informations de façon automatique et raisonnée. En matière de systèmes d’informations, la technologie des entrepôts de données spatiales fait émerger de nouvelles solutions pour le recueil et l’utilisation décisionnelle des données. Ces technologies permettent d’établir, sur des données collectées et archivées, toutes sortes d’indicateurs résultant d’opérations agrégées en fonction de différents critères (périodes de temps, types de machines ou d’outils, types de travaux, etc.), ainsi que des découvertes de relations causales et de classification de données. Les récentes avancées technologiques (capteurs embarqués, localisation GPS, communication et réseaux sans fil) et le déploiement de systèmes d’acquisition et d’information dans les entreprises agricoles permettent d’envisager aujourd’hui d’accéder en continu à des données de qualité, en quantité suffisante et à une échelle plus fine de gestion. L’intégration de ces solutions technologiques dans l’exploitation agricole contribuera à améliorer les connaissances sur l’évaluation des dépenses énergétiques et le pilotage énergétique par une gestion raisonnée des informations collectées à une échelle plus fine de temps (jour, semaine, mois, année civile, année culturale, cycle de production, etc.), d’espace (parcelle/bâtiment, etc.) et de production (culture/lot d’animaux, chantier, tâche, outil, opérateur, etc.).
close

@inproceedings{PUB00038522, author = {Donnat, E. and Boffety, D. and Pradel, M. and Tailleur, A. and Bimonte, S. and Chanet, J.P.}, title = {Évaluation fine des performances énergétiques des exploitations agricoles par l’utilisation des NTIC}, title = {The use of ICT for energy performance of farm}, bookTitle = {Casdar Innovation et Partenariat. Résultats de l'appel à projets 2008, Journée de restitution , 06/06/2013-06/06/2013, Paris, FRA}, address = {Paris}, publisher = {GIS Relance Agronomique}, pages = {87-102}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00038522}, year = {2013}, affiliation = {ACTA PARIS FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; ARVALIS INSTITUT DU VEGETAL LA CHAPELLE SAINT SAUVEUR FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Les données utiles au calcul d’indicateurs de performances énergétiques des exploitations agricoles à différentes échelles nécessitent une collecte plus fine et un stockage plus important d’informations auxquels seules les avancées technologiques peuvent répondre. Un travail de recensement des solutions technologiques existantes montre que de plus en plus de solutions sont aujourd’hui disponibles, notamment sur les nouveaux agroéquipements, pour fournir un grand nombre de données utiles au calcul de ces indicateurs. Un important travail reste cependant à réaliser pour proposer aux agriculteurs des solutions bas-coûts, faciles à mettre en ½uvre et totalement adaptées à leurs besoins pour faciliter la mesure, la collecte et le stockage des informations de façon automatique et raisonnée. En matière de systèmes d’informations, la technologie des entrepôts de données spatiales fait émerger de nouvelles solutions pour le recueil et l’utilisation décisionnelle des données. Ces technologies permettent d’établir, sur des données collectées et archivées, toutes sortes d’indicateurs résultant d’opérations agrégées en fonction de différents critères (périodes de temps, types de machines ou d’outils, types de travaux, etc.), ainsi que des découvertes de relations causales et de classification de données. Les récentes avancées technologiques (capteurs embarqués, localisation GPS, communication et réseaux sans fil) et le déploiement de systèmes d’acquisition et d’information dans les entreprises agricoles permettent d’envisager aujourd’hui d’accéder en continu à des données de qualité, en quantité suffisante et à une échelle plus fine de gestion. L’intégration de ces solutions technologiques dans l’exploitation agricole contribuera à améliorer les connaissances sur l’évaluation des dépenses énergétiques et le pilotage énergétique par une gestion raisonnée des informations collectées à une échelle plus fine de temps (jour, semaine, mois, année civile, année culturale, cycle de production, etc.), d’espace (parcelle/bâtiment, etc.) et de production (culture/lot d’animaux, chantier, tâche, outil, opérateur, etc.).}, }
close
E. Edoh Alove, S. Bimonte, F. Pinet, Y. Bédard
Exploitation du vague spatial dans le SOLAP : vers une approche de conception prenant en compte les risques d'usage
SAGEO 2013 Conférence Internationale de Géomatique et d'analyse spatiale, 23/09/2013-26/09/2013, Brest, FRA / Actes de la conférence Internationale de Géomatique et d'analyse spatiale. Thibaud R., Gourmelon, F. (Responsables scientifiques) (p. 347-358), 2013
abs web bib

Spatial OLAP (SOLAP) systems allow multidimensional analysis of huge volume of spatial data. Spatial vagueness is a usual spatial data imperfection. Several works propose new models for handling spatial vagueness. However, the implementation of those models in data cubes and their use with SOLAP tools are still in an embryonic state. Thus, we present in this paper a new approach for designing spatial data cubes based on users tolerance to the risks of data cubes misuses. / Les systèmes « Spatial OLAP » (SOLAP) permettent l’analyse multidimensionnelle de grands volumes de données spatiales. Le vague spatial est une imperfection courante des données. De nombreux travaux proposent de nouveaux modèles pour gérer le vague spatial. Néanmoins, l’implémentation de ces modèles dans les cubes de données et leur utilisation avec des outils SOLAP sont encore à l’état embryonnaire. Aussi, nous présentons dans cet article une nouvelle approche pour concevoir des cubes de données spatiales prenant en compte la tolérance des utilisateurs aux risques de mauvais usages des cubes.
close

@inproceedings{PUB00040430, author = {Edoh Alove, E. and Bimonte, S. and Pinet, F. and Bédard, Y.}, title = {Exploitation du vague spatial dans le SOLAP : vers une approche de conception prenant en compte les risques d'usage}, title = {Exploiting the spatial vagueness in SOLAP: Towards a design approach taking into account the risks of misuse}, bookTitle = {SAGEO 2013 Conférence Internationale de Géomatique et d'analyse spatiale, 23/09/2013-26/09/2013, Brest, FRA / Actes de la conférence Internationale de Géomatique et d'analyse spatiale. Thibaud R., Gourmelon, F. (Responsables scientifiques)}, pages = {347-358}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040430 / http://sageo2013.sciencesconf.org/conference/sageo2013/pages/SAGEO_2013_actes.pdf}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; CENTRE DE RECHERCHE EN GEOMATIQUE QUEBEC CAN}, abstract = {Spatial OLAP (SOLAP) systems allow multidimensional analysis of huge volume of spatial data. Spatial vagueness is a usual spatial data imperfection. Several works propose new models for handling spatial vagueness. However, the implementation of those models in data cubes and their use with SOLAP tools are still in an embryonic state. Thus, we present in this paper a new approach for designing spatial data cubes based on users tolerance to the risks of data cubes misuses. / Les systèmes « Spatial OLAP » (SOLAP) permettent l’analyse multidimensionnelle de grands volumes de données spatiales. Le vague spatial est une imperfection courante des données. De nombreux travaux proposent de nouveaux modèles pour gérer le vague spatial. Néanmoins, l’implémentation de ces modèles dans les cubes de données et leur utilisation avec des outils SOLAP sont encore à l’état embryonnaire. Aussi, nous présentons dans cet article une nouvelle approche pour concevoir des cubes de données spatiales prenant en compte la tolérance des utilisateurs aux risques de mauvais usages des cubes. }, }
close
E. Edoh-Alove, S. Bimonte, F. Pinet, Y. Bédard
Exploiting spatial vagueness in spatial OLAP: Towards a new hybrid risk-aware design approach
16th AGILE Conference on Geographic Information Science Geographic Information Science at the Heart of Europe, 14/05/2013-17/05/2013, Leuven, BEL (p. 4), 2013
abs web bib

Spatial OLAP systems allow multidimensional analysis of huge volume of spatial data. Spatial vagueness is one of the most transparent and current imperfections of spatial data. Although several works propose new ad-hoc models for handling spatial vagueness in Spatial DBMS, the implementation of those models in conventional systems and Spatial Data Warehouses (SDW) is still in an embryonic state. Thus, to help reduce that uncertainty and its consequences in SOLAP analysis, we present a new approach for designing spatial data cubes based on users tolerance to the risk of misusing datacubes.
close

@inproceedings{PUB00038434, author = {Edoh-Alove, E. and Bimonte, S. and Pinet, F. and Bédard, Y.}, title = {Exploiting spatial vagueness in spatial OLAP: Towards a new hybrid risk-aware design approach}, title = {Exploitation du vague spatial dans le Spatial-OLAP: vers une nouvelle approche de conception hybride consciente du risque}, bookTitle = {16th AGILE Conference on Geographic Information Science Geographic Information Science at the Heart of Europe, 14/05/2013-17/05/2013, Leuven, BEL}, pages = {4}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00038434}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE LAVAL CAN}, abstract = {Spatial OLAP systems allow multidimensional analysis of huge volume of spatial data. Spatial vagueness is one of the most transparent and current imperfections of spatial data. Although several works propose new ad-hoc models for handling spatial vagueness in Spatial DBMS, the implementation of those models in conventional systems and Spatial Data Warehouses (SDW) is still in an embryonic state. Thus, to help reduce that uncertainty and its consequences in SOLAP analysis, we present a new approach for designing spatial data cubes based on users tolerance to the risk of misusing datacubes.}, }
close
M.A. Kang, M. Zaamoune, F. Pinet, S. Bimonte, P. Beaune
Optimisation des performances des opérations d’agrégation au sein des entrepôts de grilles spatialisées
SAGEO 2013 Conférence Internationale de Géomatique et d'analyse spatiale, 23/09/2013-26/09/2013, Brest, FRA (p. 12), 2013
abs web bib

Le problème du stockage et du requêtage de gros volumes de grilles spatialisées est un verrou à traiter. Dans cet article, nous proposons une méthode pour optimiser les requêtes visant à agréger des grilles matricielles stockées dans des bases de données. Dans notre approche, nous proposons d’estimer le résultat réel plutôt que calculer le résultat exact. Ceci permet de gagner en temps d’exécution. Un avantage de notre méthode est qu’elle ne nécessite pas de re-implémenter une partie du système de gestion de base de données. Notre approche se base sur une nouvelle structure de données et sur un modèle spécifique de requêtes SQL. Nous appliquons ici nos travaux aux entrepôts de données relationnels.
close

@inproceedings{PUB00040432, author = {Kang, M.A. and Zaamoune, M. and Pinet, F. and Bimonte, S. and Beaune, P.}, title = {Optimisation des performances des opérations d’agrégation au sein des entrepôts de grilles spatialisées}, title = {Optimizing the performance of aggregation operations in warehoused spatial grids}, bookTitle = {SAGEO 2013 Conférence Internationale de Géomatique et d'analyse spatiale, 23/09/2013-26/09/2013, Brest, FRA}, pages = {12}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040432 / http://sageo2013.sciencesconf.org/}, year = {2013}, affiliation = {UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; AGAETIS CLERMONT FERRAND FRA}, abstract = {Le problème du stockage et du requêtage de gros volumes de grilles spatialisées est un verrou à traiter. Dans cet article, nous proposons une méthode pour optimiser les requêtes visant à agréger des grilles matricielles stockées dans des bases de données. Dans notre approche, nous proposons d’estimer le résultat réel plutôt que calculer le résultat exact. Ceci permet de gagner en temps d’exécution. Un avantage de notre méthode est qu’elle ne nécessite pas de re-implémenter une partie du système de gestion de base de données. Notre approche se base sur une nouvelle structure de données et sur un modèle spécifique de requêtes SQL. Nous appliquons ici nos travaux aux entrepôts de données relationnels.}, }
close
R. Perriot, J. Pfeiffer, L. d'Orazio, B. Bachelet, S. Bimonte, J. Darmont
Modèles de coût pour la sélection de vues matérialisées dans le nuage. Application aux Services Amazon EC2 et S3
Actes des 9èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, EDA 2013, Blois, France, Juin 13-14, 2013 (p. 53-68), Marcel, P., Blois, 2013
abs web bib

La performance des entrepôts de données est classiquement assurée grâce à des structures comme les index ou les vues matérialisées. Dans ce contexte, des modèles de coût permettent de sélectionner un ensemble pertinent de ce type de structures. Toutefois, cette sélection devient plus complexe dans les nuages informatiques, car en plus des temps de réponse, il faut simultanément optimiser le coût monétaire. Nous proposons dans cet article de nouveaux modèles de coût intégrant le paiement à la demande en vigueur dans les nuages. Sur la base de ces modèles, nous définissons un problème d’optimisation consistant à sélectionner, parmi des vues candidates, celles à matérialiser pour minimiser le coût d’interrogation et de maintenance, ainsi que le temps de réponse pour une charge de requêtes donnée. Dans un premier temps, nous optimisons les deux critères séparément : le temps est optimisé sous contrainte de coût et vice versa. Notre proposition est ensuite validée de manière expérimentale.
close

@inproceedings{PUB00040805, author = {Perriot, R. and Pfeiffer, J. and d'Orazio, L. and Bachelet, B. and Bimonte, S. and Darmont, J.}, title = {Modèles de coût pour la sélection de vues matérialisées dans le nuage. Application aux Services Amazon EC2 et S3}, title = {A cost model for selection of materialized view in the cloud using amazon ec2 and s3 services}, bookTitle = {Actes des 9èmes journées francophones sur les Entrepôts de Données et l'Analyse en ligne, EDA 2013, Blois, France, Juin 13-14, 2013}, address = {Blois}, publisher = {Marcel, P.}, pages = {53-68}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040805}, year = {2013}, affiliation = {ISIMA CLERMONT FERRAND FRA ; ISIMA CLERMONT FERRAND FRA ; ISIMA CLERMONT FERRAND FRA ; ISIMA CLERMONT FERRAND FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE LYON 2 FRA}, abstract = {La performance des entrepôts de données est classiquement assurée grâce à des structures comme les index ou les vues matérialisées. Dans ce contexte, des modèles de coût permettent de sélectionner un ensemble pertinent de ce type de structures. Toutefois, cette sélection devient plus complexe dans les nuages informatiques, car en plus des temps de réponse, il faut simultanément optimiser le coût monétaire. Nous proposons dans cet article de nouveaux modèles de coût intégrant le paiement à la demande en vigueur dans les nuages. Sur la base de ces modèles, nous définissons un problème d’optimisation consistant à sélectionner, parmi des vues candidates, celles à matérialiser pour minimiser le coût d’interrogation et de maintenance, ainsi que le temps de réponse pour une charge de requêtes donnée. Dans un premier temps, nous optimisons les deux critères séparément : le temps est optimisé sous contrainte de coût et vice versa. Notre proposition est ensuite validée de manière expérimentale.}, }
close
M. Zaamoune, S. Bimonte, F. Pinet, P. Beaune
Intégration des données champs continus incomplets dans l’OLAP : de la modélisation conceptuelle à l’implémentation
EDA 2013 9èmes journées francophones sur les Entrepôts de Données et l'Analyse en Ligne, 13/06/2013-14/06/2013, Blois, FRA (p. 10), 2013
abs web bib

Les champs continus sont des types de représentations utilisés pour modéliser des phénomènes tels que la température, la pollution ou l’élévation. Différents travaux se sont intéressés à l’intégration de ce type de représentations dans un système SOLAP. Ainsi, dans ce papier, nous proposons une modélisation ainsi qu’une implémentation des dimensions spatiales représentant des champs continus incomplets sous forme de grilles régulières à des résolutions différentes, afin de les intégrer dans un système SOLAP.
close

@inproceedings{PUB00040431, author = {Zaamoune, M. and Bimonte, S. and Pinet, F. and Beaune, P.}, title = {Intégration des données champs continus incomplets dans l’OLAP : de la modélisation conceptuelle à l’implémentation}, title = {Integration of incomplete continuous fields data in OLAP: From conceptual modeling to implementation}, bookTitle = {EDA 2013 9èmes journées francophones sur les Entrepôts de Données et l'Analyse en Ligne, 13/06/2013-14/06/2013, Blois, FRA}, pages = {10}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040431}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; AGAETIS CLERMONT FERRAND FRA}, abstract = {Les champs continus sont des types de représentations utilisés pour modéliser des phénomènes tels que la température, la pollution ou l’élévation. Différents travaux se sont intéressés à l’intégration de ce type de représentations dans un système SOLAP. Ainsi, dans ce papier, nous proposons une modélisation ainsi qu’une implémentation des dimensions spatiales représentant des champs continus incomplets sous forme de grilles régulières à des résolutions différentes, afin de les intégrer dans un système SOLAP.}, }
close
M. Zaamoune, S. Bimonte, F. Pinet, P. Beaune
A new relational spatial OLAP approach for multi-resolution and spatio-multidimensional analysis of incomplete field data
ICEIS 2013 INSTICC International Conference on Enterprise Information Systems, 03/07/2013-07/07/2013, Angers, FRA (p. 145-152), 2013
abs web bib

Integrating continuous spatial data into SOLAP systems is a new research challenge. Moreover, representation of field data at different scales or resolutions is often mandatory for an effective analysis. Thus, in this paper, we propose a logical model to integrate spatial dimensions representing incomplete field data at different resolutions in a classical SOLAP architecture.
close

@inproceedings{PUB00040428, author = {Zaamoune, M. and Bimonte, S. and Pinet, F. and Beaune, P.}, title = {A new relational spatial OLAP approach for multi-resolution and spatio-multidimensional analysis of incomplete field data}, title = {Une nouvelle approche Spatial OLAP relationnelle pour l'analyse spatio-multidimensionnelle et à multi-résolution des données champs continus incomplets}, bookTitle = {ICEIS 2013 INSTICC International Conference on Enterprise Information Systems, 03/07/2013-07/07/2013, Angers, FRA}, pages = {145-152}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00040428 / http://www.iceis.org/?y=2013}, year = {2013}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; AGAETIS CLERMONT FERRAND FRA}, abstract = {Integrating continuous spatial data into SOLAP systems is a new research challenge. Moreover, representation of field data at different scales or resolutions is often mandatory for an effective analysis. Thus, in this paper, we propose a logical model to integrate spatial dimensions representing incomplete field data at different resolutions in a classical SOLAP architecture.}, }
close
S. Bimonte, O. Boussaid, L. El Sarraj
New conceptual modeling requirements for stream data warehouses
INFORSID 30ème ed. , 29/05/2012-31/05/2012, Montpellier, FRA (p. 8), 2012
abs web bib

Spatial data warehouses (SDW) and Spatial OLAP (SOLAP) systems allow the storage and multidimensional analysis of huge volumes of geographic data. Existing SOLAP models do not take into account connectivity of spatial objects and consequently they do not natively integrate networks. In this paper, we propose a UML (Unified Modeling Language) profile for SDW integrating spatial networks. We implemented our UML profile using UML meta-model elements and OCL (Object Constraint Language) constraints with a Computer-Aided Software Engineering tool (MagicDraw). The implementation of the conceptual model in a database is presented using Oracle. / Les entrepôts de données spatiales (EDS) et les outils OLAP spatial (SOLAP) permettent le stockage et l'analyse multidimensionnelle d’une grande quantité de données géographiques. Les modèles existants SOLAP ne tiennent pas compte de la connectivité des objets spatiaux et par conséquent ils n’intègrent pas les données de type réseaux, comme les réseaux routiers et leurs méthodes d'analyse. Dans cet article, nous proposons un profil UML (Unified Modeling Language) pour les entrepôts de données intégrant des réseaux spatiaux. Nous mettons en oeuvre notre profil UML en se basant sur le méta-modèle d’UML et des contraintes OCL (Object Constraint Language) avec un atelier de génie logiciel (MagicDraw). Une implémentation du modèle conceptuel dans une base de données est présentée en utilisant Oracle.
close

@inproceedings{PUB00035348, author = {Bimonte, S. and Boussaid, O. and El Sarraj, L.}, title = {New conceptual modeling requirements for stream data warehouses}, title = {Besoins pours les entrepôts de données stream}, bookTitle = {INFORSID 30ème ed. , 29/05/2012-31/05/2012, Montpellier, FRA}, pages = {8}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035348}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE LYON II FRA ; UNIVERSITE DE LYON II FRA}, abstract = {Spatial data warehouses (SDW) and Spatial OLAP (SOLAP) systems allow the storage and multidimensional analysis of huge volumes of geographic data. Existing SOLAP models do not take into account connectivity of spatial objects and consequently they do not natively integrate networks. In this paper, we propose a UML (Unified Modeling Language) profile for SDW integrating spatial networks. We implemented our UML profile using UML meta-model elements and OCL (Object Constraint Language) constraints with a Computer-Aided Software Engineering tool (MagicDraw). The implementation of the conceptual model in a database is presented using Oracle. / Les entrepôts de données spatiales (EDS) et les outils OLAP spatial (SOLAP) permettent le stockage et l'analyse multidimensionnelle d’une grande quantité de données géographiques. Les modèles existants SOLAP ne tiennent pas compte de la connectivité des objets spatiaux et par conséquent ils n’intègrent pas les données de type réseaux, comme les réseaux routiers et leurs méthodes d'analyse. Dans cet article, nous proposons un profil UML (Unified Modeling Language) pour les entrepôts de données intégrant des réseaux spatiaux. Nous mettons en oeuvre notre profil UML en se basant sur le méta-modèle d’UML et des contraintes OCL (Object Constraint Language) avec un atelier de génie logiciel (MagicDraw). Une implémentation du modèle conceptuel dans une base de données est présentée en utilisant Oracle.}, }
close
S. Bimonte, K. Boulil, J.P. Chanet, M. Pradel
Definition and analysis of new agricultural farm energetic indicators using spatial OLAP
International Conference on Geographical Analysis, Urban Modeling, Spatial Statistics, 18/05/2012-20/05/2012, Salvador de Bahia, BRA (p. 14), 2012
abs web bib

Agricultural energy consumption is an important environmental and social issue. Several diagnoses have been proposed to define indicators for analyzing energy consumption at large scale of agricultural farm activities (year, farm, family of production, etc.). However, to define ad-hoc environmental energetic policies to better monitor and control energy consumption, new indicators at a most detailed scale are needed. Moreover, by defining detailed scale indicators, large quantities of geo-referenced data need to be collected to feed these energetic diagnoses. This huge volume of data represents another important limitation of systems that implement these diagnoses because they are usually based on classical data storage systems (such as spreadsheet tools and Database Management Systems). These systems do not allow for interactive analysis at different granularities/scales of huge volumes of data and do not provide any cartographic representation. By contrast, Spatial OLAP (SOLAP) and spatial data warehouse (SDW) systems allow for the analysis of huge volumes of geo-referenced data by providing aggregated numerical values visualized by means of interactive tabular, graphical and cartographic displays. Thus, in this paper, we (i) propose new appropriate indicators to analyze agricultural farm energy performance at a detailed scale and (ii) show how SDW and SOLAP technologies can be used to represent, store and analyze these indicators by simultaneously producing expressive reports.
close

@inproceedings{PUB00035350, author = {Bimonte, S. and Boulil, K. and Chanet, J.P. and Pradel, M.}, title = {Definition and analysis of new agricultural farm energetic indicators using spatial OLAP}, title = {Définition et analyse des nouveaux indicateurs énergétiques avec le spatial OLAP}, bookTitle = {International Conference on Geographical Analysis, Urban Modeling, Spatial Statistics, 18/05/2012-20/05/2012, Salvador de Bahia, BRA}, pages = {14}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035350}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Agricultural energy consumption is an important environmental and social issue. Several diagnoses have been proposed to define indicators for analyzing energy consumption at large scale of agricultural farm activities (year, farm, family of production, etc.). However, to define ad-hoc environmental energetic policies to better monitor and control energy consumption, new indicators at a most detailed scale are needed. Moreover, by defining detailed scale indicators, large quantities of geo-referenced data need to be collected to feed these energetic diagnoses. This huge volume of data represents another important limitation of systems that implement these diagnoses because they are usually based on classical data storage systems (such as spreadsheet tools and Database Management Systems). These systems do not allow for interactive analysis at different granularities/scales of huge volumes of data and do not provide any cartographic representation. By contrast, Spatial OLAP (SOLAP) and spatial data warehouse (SDW) systems allow for the analysis of huge volumes of geo-referenced data by providing aggregated numerical values visualized by means of interactive tabular, graphical and cartographic displays. Thus, in this paper, we (i) propose new appropriate indicators to analyze agricultural farm energy performance at a detailed scale and (ii) show how SDW and SOLAP technologies can be used to represent, store and analyze these indicators by simultaneously producing expressive reports.}, }
close
K. Boulil, S. Bimonte, F. Pinet
Un cadre conceptuel basé sur UML et Spatial OCL pour la définition des contraintes d’intégrité dans les systèmes SOLAP
8èmes Journées francophones sur les Entrepôts de Données et l'Analyse en ligne , 12/06/2012-13/06/2012, Bordeaux, FRA (p. 15), 2012
abs web bib

Les entrepôts de données spatiales et les systèmes Spatial OLAP sont des technologies d’aide à la décision permettant l’analyse en ligne des gros jeux de données géo-référencées. Dans un tel type de systèmes, la qualité de l’analyse dépend : de la qualité des données entreposées, de comment les agrégations sont effectuées, et de comment les données entreposées sont explorées. Dans cet article, nous proposons une méthode pour garantir la qualité de ces trois facteurs, fondée sur un profil UML et sur des contraintes d’intégrité définies avec Spatial OCL. Afin de valider notre proposition, nous proposons également une implémentation automatique dans une architecture ROLAP.
close

@inproceedings{PUB00035404, author = {Boulil, K. and Bimonte, S. and Pinet, F.}, title = {Un cadre conceptuel basé sur UML et Spatial OCL pour la définition des contraintes d’intégrité dans les systèmes SOLAP}, title = {A conceptual framework based on UML and Spatial OCAL to handle integrity constraints in SOLAP systems}, bookTitle = {8èmes Journées francophones sur les Entrepôts de Données et l'Analyse en ligne , 12/06/2012-13/06/2012, Bordeaux, FRA}, pages = {15}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035404}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Les entrepôts de données spatiales et les systèmes Spatial OLAP sont des technologies d’aide à la décision permettant l’analyse en ligne des gros jeux de données géo-référencées. Dans un tel type de systèmes, la qualité de l’analyse dépend : de la qualité des données entreposées, de comment les agrégations sont effectuées, et de comment les données entreposées sont explorées. Dans cet article, nous proposons une méthode pour garantir la qualité de ces trois facteurs, fondée sur un profil UML et sur des contraintes d’intégrité définies avec Spatial OCL. Afin de valider notre proposition, nous proposons également une implémentation automatique dans une architecture ROLAP.}, }
close
K. Boulil, S. Bimonte, F. Pinet
A UML & Spatial OCL based approach for handling quality issues in SOLAP systems
ICEIS 2012 14th International Conference on Enterprise Information Systems , 28/06/2012-01/07/2012, Wroclaw, POL (p. 6), 2012
abs web bib

Spatial Data warehouses and Spatial OLAP systems are Business Intelligence technologies allowing efficient and interactive analysis of large geo-referenced datasets. In such a kind of systems the goodness of analysis depends on: The warehoused data quality, how aggregations are performed, and how warehoused data are explored. In this paper, we propose a framework based on a UML profile and OCL-defined integrity constraints to grant quality in the whole SOLAP system. We also propose an automatic implementation in a classical ROLAP architecture to validate our proposal.
close

@inproceedings{PUB00035388, author = {Boulil, K. and Bimonte, S. and Pinet, F.}, title = {A UML & Spatial OCL based approach for handling quality issues in SOLAP systems }, title = {Une approche basée sur UML et Spatial OCL pour la gestion de la qualité dans les systèmes SOLAP}, bookTitle = {ICEIS 2012 14th International Conference on Enterprise Information Systems , 28/06/2012-01/07/2012, Wroclaw, POL}, pages = {6}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035388}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data warehouses and Spatial OLAP systems are Business Intelligence technologies allowing efficient and interactive analysis of large geo-referenced datasets. In such a kind of systems the goodness of analysis depends on: The warehoused data quality, how aggregations are performed, and how warehoused data are explored. In this paper, we propose a framework based on a UML profile and OCL-defined integrity constraints to grant quality in the whole SOLAP system. We also propose an automatic implementation in a classical ROLAP architecture to validate our proposal.}, }
close
V. Nguyen, L. d'Orazio, S. Bimonte, J. Darmont
Cost models for view materialization in the cloud
DANAC, 30/03/2012-30/03/2012, Berlin, DEU (p. 8), 2012
abs web bib

In classical databases, query performance is casually achieved through physical data structures such as caches, indexes and materialized views. In this context, many cost models help select a "best set" of such data structures. However, this selection task becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with the monetary cost of using the cloud balancing query response time. Thus, we define in this paper new cost models that fit into the pay-as-you-go paradigm of cloud computing. These cost models help achieve a multi-criteria optimization of the view materialization vs. CPU power consumption problem, under budget constraints. Finally, we present experimental results that provide a first validation of our contribution and show that cloud view materialization is always desirable.
close

@inproceedings{PUB00035351, author = {Nguyen, V. and d'Orazio, L. and Bimonte, S. and Darmont, J.}, title = {Cost models for view materialization in the cloud}, title = {Modèles de couts pour les vues matérialisées dans le Cloud}, bookTitle = {DANAC, 30/03/2012-30/03/2012, Berlin, DEU}, pages = {8}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035351}, year = {2012}, affiliation = {UNIVERSITE DE CAEN BASSE NORMANDIE FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE DE LYON II FRA}, abstract = {In classical databases, query performance is casually achieved through physical data structures such as caches, indexes and materialized views. In this context, many cost models help select a "best set" of such data structures. However, this selection task becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with the monetary cost of using the cloud balancing query response time. Thus, we define in this paper new cost models that fit into the pay-as-you-go paradigm of cloud computing. These cost models help achieve a multi-criteria optimization of the view materialization vs. CPU power consumption problem, under budget constraints. Finally, we present experimental results that provide a first validation of our contribution and show that cloud view materialization is always desirable.}, }
close
A. Miralles, F. Pinet, N. Carluer, F. Vernier, S. Bimonte, C. Lauvernet, V. Gouy
EIS pesticide: an information system for data and knowledge capitalization and analysis
Euraqua-PEER Scientific Conference, 26/10/2011-28/10/2011, Montpellier, FRA (p. 1), 2011
abs web bib

The European Parliament recently approved a new EU pesticides legislation. Member States must adopt National Action Plans for reducing the "risks and impacts" of pesticide use and take measures to protect the water resources. The French program Ecophyto 2018 targets a 50% reduction in pesticides use. The funding available for these mitigation measures have to be used in the most cost-effective way. As the characteristics of agricultural production differ across a catchment, policy instruments can lead to various results in terms of environmental effectiveness and implementation costs. Therefore defining policy priorities requires appropriate tools with results about ecological and social features of agricultural practices. The evaluation ex-ante of scenarios using agro-environmental indicators (AEI) and/or agro-hydrological models needs to implement an effective information system, able to take into account the characteristics of the ecosystem and of agricultural activities at embedded spatial scales. The trans-time-plot scale, a homogeneous part of watershed for agricultural practices through the time, is used for the calculation of indicators for small agricultural catchments. At a larger watershed scale, other spatially designed entities are used regarding typologies of farming systems and natural conditions, or areas of mitigation measures. The produced data model allows describing in the same database the agricultural practices at these embedded scales as well as a range of data relating to river basin characteristics. The agricultural practices (crop rotation, crop management, irrigation, fertilization, pesticides use) are described at the farm level for homogeneous plots or from a typology of farming systems built using surveys and institutional data. A dictionary gives detailed information about all the concepts used. The EIS system generated automatically from the business models offers tools for analysis. It has been tested with a data set collected on the Charente watershed and its sub-basins. Several axes of analyses have been defined (time, amount of pesticides sprayed, spatial aggregation). The tools implemented allow new possibilities for the analysis of data and the calculation of spatial indicators (AEI). The EIS system allows calculating a simple indicator of pesticide pressure. It is expected to implement the calculation of an institutional indicator at two embedded spatial scales.
close

@inproceedings{PUB00033341, author = {Miralles, A. and Pinet, F. and Carluer, N. and Vernier, F. and Bimonte, S. and Lauvernet, C. and Gouy, V. }, title = {EIS pesticide: an information system for data and knowledge capitalization and analysis}, title = {SIE pesticides : un système d'information innovant pour calculer des indicateurs agro-environnementaux}, bookTitle = {Euraqua-PEER Scientific Conference, 26/10/2011-28/10/2011, Montpellier, FRA}, pages = {1}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00033341}, year = {2011}, affiliation = {CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {The European Parliament recently approved a new EU pesticides legislation. Member States must adopt National Action Plans for reducing the "risks and impacts" of pesticide use and take measures to protect the water resources. The French program Ecophyto 2018 targets a 50% reduction in pesticides use. The funding available for these mitigation measures have to be used in the most cost-effective way. As the characteristics of agricultural production differ across a catchment, policy instruments can lead to various results in terms of environmental effectiveness and implementation costs. Therefore defining policy priorities requires appropriate tools with results about ecological and social features of agricultural practices. The evaluation ex-ante of scenarios using agro-environmental indicators (AEI) and/or agro-hydrological models needs to implement an effective information system, able to take into account the characteristics of the ecosystem and of agricultural activities at embedded spatial scales. The trans-time-plot scale, a homogeneous part of watershed for agricultural practices through the time, is used for the calculation of indicators for small agricultural catchments. At a larger watershed scale, other spatially designed entities are used regarding typologies of farming systems and natural conditions, or areas of mitigation measures. The produced data model allows describing in the same database the agricultural practices at these embedded scales as well as a range of data relating to river basin characteristics. The agricultural practices (crop rotation, crop management, irrigation, fertilization, pesticides use) are described at the farm level for homogeneous plots or from a typology of farming systems built using surveys and institutional data. A dictionary gives detailed information about all the concepts used. The EIS system generated automatically from the business models offers tools for analysis. It has been tested with a data set collected on the Charente watershed and its sub-basins. Several axes of analyses have been defined (time, amount of pesticides sprayed, spatial aggregation). The tools implemented allow new possibilities for the analysis of data and the calculation of spatial indicators (AEI). The EIS system allows calculating a simple indicator of pesticide pressure. It is expected to implement the calculation of an institutional indicator at two embedded spatial scales.}, }
close
S. Bimonte, E. Del Fatto, L. Paolino, M. Sebillo, G. Vitiello
A visual query language for spatial data warehouses
AGILE International Conference on Geographic Information Science, 11/05/2010-14/05/2010, Guimarães, PRT / Springer Lecture Notes on Geoinformation and Cartography (p. 18), Springer-Verlag, 2010
abs web bib

SOLAP systems are technologies intended to support geographic business intelligence. They allow exploring and analyzing a large amount of geo-referenced data usually through interactive browsing user interfaces. In this paper, we explore a new interactive methodology which supports users to query and aggregate this kind of structured data by means of specific visual notations. The widely recognized capability of visual query languages to bridge the gap between users' expertise and advanced query formulation adds effectiveness to the methodology, thus providing a useful support for posing correct SOLAP expressions by spatially arranging visual metaphors in a simple and intuitive way.
close

@inproceedings{PUB00027810, author = {Bimonte, S. and Del Fatto, E. and Paolino, L. and Sebillo, M. and Vitiello, G.}, title = {A visual query language for spatial data warehouses}, title = {Un langage visuel pour les entrepôts de données spatiales}, bookTitle = {AGILE International Conference on Geographic Information Science, 11/05/2010-14/05/2010, Guimarães, PRT / Springer Lecture Notes on Geoinformation and Cartography}, publisher = {Springer-Verlag}, pages = {18}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00027810}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF UMR TETIS FRA ; UNIVERSITA DI SALERNO ITA ; UNIVERSITA DI SALERNO ITA ; UNIVERSITA DI SALERNO ITA ; UNIVERSITA DI SALERNO ITA}, abstract = {SOLAP systems are technologies intended to support geographic business intelligence. They allow exploring and analyzing a large amount of geo-referenced data usually through interactive browsing user interfaces. In this paper, we explore a new interactive methodology which supports users to query and aggregate this kind of structured data by means of specific visual notations. The widely recognized capability of visual query languages to bridge the gap between users' expertise and advanced query formulation adds effectiveness to the methodology, thus providing a useful support for posing correct SOLAP expressions by spatially arranging visual metaphors in a simple and intuitive way.}, }
close
S. Bimonte, M. Kang
Un modèle multidimensionnel pour l'analyse en ligne des champs continus
Journées francophones sur les entrepôts de données et l'analyse en ligne, 11/06/2010-13/06/2010, Djerba, TUN (p. 121-136), 2010
abs web bib

L'intégration des données spatiales dans les modèles multidimensionnels conduit au concept d'OLAP Spatial (SOLAP). Les modèles SOLAP existants exploitent les données spatiales vectorielles. Peu de travaux intègrent les données spatiales continues (champs continus) en dimension et en mesure. Dans ce papier, nous proposons un modèle multidimensionnel qui utilise les champs continus comme mesures et dimensions indépendamment de leur implantation dans les SGBD Spatiaux.
close

@inproceedings{PUB00029486, author = {Bimonte, S. and Kang, M.}, title = {Un modèle multidimensionnel pour l'analyse en ligne des champs continus}, title = {Towards a model for the multidimensional analysis of fields data}, bookTitle = {Journées francophones sur les entrepôts de données et l'analyse en ligne, 11/06/2010-13/06/2010, Djerba, TUN}, pages = {121-136}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029486}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA}, abstract = {L'intégration des données spatiales dans les modèles multidimensionnels conduit au concept d'OLAP Spatial (SOLAP). Les modèles SOLAP existants exploitent les données spatiales vectorielles. Peu de travaux intègrent les données spatiales continues (champs continus) en dimension et en mesure. Dans ce papier, nous proposons un modèle multidimensionnel qui utilise les champs continus comme mesures et dimensions indépendamment de leur implantation dans les SGBD Spatiaux.}, }
close
K. Boulil, S. Bimonte, H. Mahboubi, F. Pinet
Towards the definition of spatial data warehouses integrity constraints with spatial OCL
ACM thirteenth international workshop on data warehousing and OLAP (DOLAP 2010) , 30/10/2010-30/10/2010, Toronto, CAN (p. 5), II-Yeol Song & Carlos Ordonez, 2010
abs web bib

Spatial Data Warehouse (SDW) and Spatial OLAP systems (SOLAP) are now an effective solution to perform multidimensional spatial analysis on geographical data. However, the quality of such analysis heavily depends on the quality of stored data. Due to this, some works have been attempted to address the issues of data quality of SDW using Integrity Constraints (IC). In this paper, we propose a conceptual framework for SDW IC based on two new classifications. Moreover, we describe the specification and implementation of some IC classes using the Object Constraint Language (OCL) and an automatic code generator, called Spatial OCL2SQL.
close

@inproceedings{PUB00029624, author = {Boulil, K. and Bimonte, S. and Mahboubi, H. and Pinet, F.}, title = {Towards the definition of spatial data warehouses integrity constraints with spatial OCL}, title = {Vers la définition des contraintes d'intégrité d'entrepôts de données spatiales avec spatial OCL}, bookTitle = {ACM thirteenth international workshop on data warehousing and OLAP (DOLAP 2010) , 30/10/2010-30/10/2010, Toronto, CAN}, publisher = {II-Yeol Song & Carlos Ordonez}, pages = {5}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029624}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Spatial Data Warehouse (SDW) and Spatial OLAP systems (SOLAP) are now an effective solution to perform multidimensional spatial analysis on geographical data. However, the quality of such analysis heavily depends on the quality of stored data. Due to this, some works have been attempted to address the issues of data quality of SDW using Integrity Constraints (IC). In this paper, we propose a conceptual framework for SDW IC based on two new classifications. Moreover, we describe the specification and implementation of some IC classes using the Object Constraint Language (OCL) and an automatic code generator, called Spatial OCL2SQL.}, }
close
L. D'Orazio, S. Bimonte
Intégration des tableaux multidimensionnels en pig pour l'entreposage de données sur les nuages
Journées francophones sur les entrepôts de données et l'analyse en ligne, 11/06/2010-13/06/2010, Djerba, TUN (p. 21-34), 2010
abs web bib

Data warehouses and OLAP systems are business intelligence technologies. They allow decision-makers to analyze on the fly huge volume of data represented according to the multidimensional model. Cloud computing on the impulse of ICT majors like Google, Microsoft and Amazon, has recently focused the attention. OLAP querying and data warehousing in such a context consists in a major issue. Indeed, problems to be tackled are basic ones for large scale distributed OLAP systems (large amount of data querying, semantic and structural heterogeneity) from a new point of view, considering specificities from these architectures (pay-as-you-go rule, elasticity, and user-friendliness). In this paper we address the pay-as you-go rules for warehousing data storage. We propose to use the multidimensional arrays storage techniques for clouds. First experiments validate our proposal. Then we list research perspectives. / Les entrepôts de données et les systèmes OLAP correspondent à des technologies d'aide à la décision. Ils permettent d'analyser à la volée de gros volumes de données représentés en fonction d'un modèle multidimensionnel. L'informatique dans les nuages, sous l'impulsion des grandes compagnies telles que Google, Microsoft ou encore Amazon, a récemment suscité une attention particulière. Considérer l'interrogation OLAP et les entrepôts de données au sein de telles infrastructures devient alors un enjeu majeur. Les problèmes devant être considérés sont ceux classiques des systèmes largement distribués (interrogation de gros volumes de données, hétérogénéité sémantique et structurelle ou encore variabilité), mais d'un nouveau point de vue devant considérer les spécificités de ces architectures (facturation à l'utilisation, élasticité et facilité d'utilisation). Dans ce papier nous abordons dans un premier temps les règles de facturation à l'utilisation pour le stockage des entrepôts de données. Nous proposons d'utiliser des techniques de stockage pour nuages à base de tableaux multidimensionnels. De premières expérimentations montrent l'intérêt de notre proposition. Ensuite, nous listons des perspectives de recherche.
close

@inproceedings{PUB00029487, author = {D'Orazio, L. and Bimonte, S.}, title = {Intégration des tableaux multidimensionnels en pig pour l'entreposage de données sur les nuages}, title = {Multidimensional arrays for warehousing data on clouds with pig}, bookTitle = {Journées francophones sur les entrepôts de données et l'analyse en ligne, 11/06/2010-13/06/2010, Djerba, TUN}, pages = {21-34}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029487}, year = {2010}, affiliation = {LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Data warehouses and OLAP systems are business intelligence technologies. They allow decision-makers to analyze on the fly huge volume of data represented according to the multidimensional model. Cloud computing on the impulse of ICT majors like Google, Microsoft and Amazon, has recently focused the attention. OLAP querying and data warehousing in such a context consists in a major issue. Indeed, problems to be tackled are basic ones for large scale distributed OLAP systems (large amount of data querying, semantic and structural heterogeneity) from a new point of view, considering specificities from these architectures (pay-as-you-go rule, elasticity, and user-friendliness). In this paper we address the pay-as you-go rules for warehousing data storage. We propose to use the multidimensional arrays storage techniques for clouds. First experiments validate our proposal. Then we list research perspectives. / Les entrepôts de données et les systèmes OLAP correspondent à des technologies d'aide à la décision. Ils permettent d'analyser à la volée de gros volumes de données représentés en fonction d'un modèle multidimensionnel. L'informatique dans les nuages, sous l'impulsion des grandes compagnies telles que Google, Microsoft ou encore Amazon, a récemment suscité une attention particulière. Considérer l'interrogation OLAP et les entrepôts de données au sein de telles infrastructures devient alors un enjeu majeur. Les problèmes devant être considérés sont ceux classiques des systèmes largement distribués (interrogation de gros volumes de données, hétérogénéité sémantique et structurelle ou encore variabilité), mais d'un nouveau point de vue devant considérer les spécificités de ces architectures (facturation à l'utilisation, élasticité et facilité d'utilisation). Dans ce papier nous abordons dans un premier temps les règles de facturation à l'utilisation pour le stockage des entrepôts de données. Nous proposons d'utiliser des techniques de stockage pour nuages à base de tableaux multidimensionnels. De premières expérimentations montrent l'intérêt de notre proposition. Ensuite, nous listons des perspectives de recherche.}, }
close
L. D'Orazio, S. Bimonte
Multidimensional arrays for warehousing data on clouds
Data Management in Grid and Peer-to-Peer Systems, 01/09/2010-02/09/2010, Bilbao, ESP , Hameurlain, Morvan, Tjoa , 2010
abs web bib

Data warehouses and OLAP systems are business intelligence technologies. They allow decision-makers to analyze on the fly huge volumes of data represented according to the multidimensional model. Cloud computing on the impulse of ICT majors like Google, Microsoft and Amazon, has recently focused the attention. OLAP querying and data warehousing in such a context consists in a major issue. Indeed, problems to be tackled are basic ones for large scale distributed OLAP systems (large amount of data querying, semantic and structural heterogeneity) from a new point of view, considering specificities from these architectures (pay-as-you-go rule, elasticity, and user-friendliness). In this paper we address the pay-as-you-go rules for warehousing data storage. We propose to use the multidimensional arrays storage techniques for clouds. First experiments validate our proposal.
close

@inproceedings{PUB00029484, author = {D'Orazio, L. and Bimonte, S.}, title = {Multidimensional arrays for warehousing data on clouds}, title = {Intégration des tableaux multidimensionnels pour l'entreposage de données sur les nuages}, bookTitle = {Data Management in Grid and Peer-to-Peer Systems, 01/09/2010-02/09/2010, Bilbao, ESP}, publisher = {Hameurlain, Morvan, Tjoa }, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029484}, year = {2010}, affiliation = {LIMOS UNIVERSITE BLAISE PASCAL CLERMONT FERRAND FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Data warehouses and OLAP systems are business intelligence technologies. They allow decision-makers to analyze on the fly huge volumes of data represented according to the multidimensional model. Cloud computing on the impulse of ICT majors like Google, Microsoft and Amazon, has recently focused the attention. OLAP querying and data warehousing in such a context consists in a major issue. Indeed, problems to be tackled are basic ones for large scale distributed OLAP systems (large amount of data querying, semantic and structural heterogeneity) from a new point of view, considering specificities from these architectures (pay-as-you-go rule, elasticity, and user-friendliness). In this paper we address the pay-as-you-go rules for warehousing data storage. We propose to use the multidimensional arrays storage techniques for clouds. First experiments validate our proposal.}, }
close
F. Pinet, A. Miralles, S. Bimonte, F. Vernier, N. Carluer, V. Gouy, S. Bernard
The use of UML to design agricultural data warehouses
AgEng 2010, International Conference on Agricultural Engineering, 06/09/2010-08/09/2010, Clermont-Ferrand, FRA (p. 10), 2010
abs web bib

Recent research works propose to use the Unified Modeling Language (UML) to design datawarehouses. First, the paper overviews these recent UML-based techniques. We show that UML can help system designers to build a data warehouse model. This type of model aims to describe the different analysis dimensions of the data. Second, we will also present different UML-based tools used during a project of agricultural data warehouse. The paper will introduce this data warehouse developed in France. Its goal is to allow analyzing spatially the use of pesticide in agriculture.
close

@inproceedings{PUB00029377, author = {Pinet, F. and Miralles, A. and Bimonte, S. and Vernier, F. and Carluer, N. and Gouy, V. and Bernard, S.}, title = {The use of UML to design agricultural data warehouses }, bookTitle = {AgEng 2010, International Conference on Agricultural Engineering, 06/09/2010-08/09/2010, Clermont-Ferrand, FRA}, pages = {10}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029377}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, ISBNISSN = {13 : 978-2-85362-684-2}, abstract = {Recent research works propose to use the Unified Modeling Language (UML) to design datawarehouses. First, the paper overviews these recent UML-based techniques. We show that UML can help system designers to build a data warehouse model. This type of model aims to describe the different analysis dimensions of the data. Second, we will also present different UML-based tools used during a project of agricultural data warehouse. The paper will introduce this data warehouse developed in France. Its goal is to allow analyzing spatially the use of pesticide in agriculture. }, }
close
M. Snoussi, S. Bimonte, M. Kang
Vers un profil UML pour les entrepôts de données intégrant les réseaux spatiaux
Sageo 2010, 17/11/2010-19/11/2010, Toulouse, FRA (p. 3), 2010
abs web bib

Spatial data warehouses and SOLAP systems allow the storage and multidimensional analysis of huge volume of spatial data. In order to enrich SOLAP analysis with analysis methods of spatial networks (i.e. roads network, etc.), in this paper we propose a UML profile to represent connectivity relationships between spatial members and spatial measures. / Les entrepôts de données spatiales et les systèmes SOLAP permettent de stocker et d'analyser les objets spatiaux au sein d'un entrepôt de données. Afin d'enrichir l'analyse SOLAP avec les méthodes d'analyse des réseaux spatiaux (i.e. réseaux routiers, etc.) nous proposons un profil UML pour représenter les relations de connectivité entre les mesures et les membres spatiaux.
close

@inproceedings{PUB00029490, author = {Snoussi, M. and Bimonte, S. and Kang, M.}, title = {Vers un profil UML pour les entrepôts de données intégrant les réseaux spatiaux}, title = {Towards the definition of a UML profile for data warehouses integrating spatial networks}, bookTitle = {Sageo 2010, 17/11/2010-19/11/2010, Toulouse, FRA}, pages = {3}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00029490}, year = {2010}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITE BLAISE PASCAL CLERMONT FERRAND LIMOS FRA}, abstract = {Spatial data warehouses and SOLAP systems allow the storage and multidimensional analysis of huge volume of spatial data. In order to enrich SOLAP analysis with analysis methods of spatial networks (i.e. roads network, etc.), in this paper we propose a UML profile to represent connectivity relationships between spatial members and spatial measures. / Les entrepôts de données spatiales et les systèmes SOLAP permettent de stocker et d'analyser les objets spatiaux au sein d'un entrepôt de données. Afin d'enrichir l'analyse SOLAP avec les méthodes d'analyse des réseaux spatiaux (i.e. réseaux routiers, etc.) nous proposons un profil UML pour représenter les relations de connectivité entre les mesures et les membres spatiaux. }, }
close
S. Bimonte, S. Di Martino, M. Bertolotto, F. Ferrucci, V. Leano, F. Pinet
GoOlap : vers l'analyse spatio-multidimensionnelle à l'aide du Geobrowser Google Earth
INFORSID 2009, 26/05/2009-29/05/2009, Toulouse, FRA , 2009
abs web bib

Les outils OLAP Spatial (SOLAP) existants n'intègrent pas encore complètement toutes les fonctionnalités de visualisation, d'interaction et d'analyse des SIG. Dans cet article, nous présentons l'implémentation d'un système SOLAP Web flexible, GoOlap, qui combine à la fois des fonctionnalités OLAP et des fonctionnalités évoluées de géovisualisation. Ce système intégre le geobrowser Google Earth avec le système OLAP Mondrian/JPivot. Google Earth enrichit les capacités d'analyse spatio-multidimensionnelles à travers la visualisation 3D, la « contextualisation » de l'application SOLAP et la personnalisation des affichages cartographiques.
close

@inproceedings{PUB00026844, author = {Bimonte, S. and Di Martino, S. and Bertolotto, M. and Ferrucci, F. and Leano, V. and Pinet, F.}, title = {GoOlap : vers l'analyse spatio-multidimensionnelle à l'aide du Geobrowser Google Earth}, title = {GoOlap: towards the spatio-multidimensional analysis by means of the geobrowser Google Earth}, bookTitle = {INFORSID 2009, 26/05/2009-29/05/2009, Toulouse, FRA}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00026844}, year = {2009}, affiliation = {CEMAGREF CLERMONT FERRAND UR TSCF FRA ; UNIVERSITY OF NAPLES FEDERICO II ITA ; UNVERSITY COLLEGE DUBLIN IRL ; UNIVERSITY OF SALERNO ITA ; UNIVERSITY OF NAPLES FEDERICO II ITA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Les outils OLAP Spatial (SOLAP) existants n'intègrent pas encore complètement toutes les fonctionnalités de visualisation, d'interaction et d'analyse des SIG. Dans cet article, nous présentons l'implémentation d'un système SOLAP Web flexible, GoOlap, qui combine à la fois des fonctionnalités OLAP et des fonctionnalités évoluées de géovisualisation. Ce système intégre le geobrowser Google Earth avec le système OLAP Mondrian/JPivot. Google Earth enrichit les capacités d'analyse spatio-multidimensionnelles à travers la visualisation 3D, la « contextualisation » de l'application SOLAP et la personnalisation des affichages cartographiques.}, }
close
M. Visoli, J.P. Chanet, F. Pinet, S. Bimonte
Uso de trajetorias na rastreanilidade bovina
SBIAgro 2009, 21/09/2009-25/09/2009, Viçosa, BRA (p. 5), 2009
abs web bib

Brazil is the one of the major producer and exporter in the world of bovine meat in an extremely competitive market. The requirements on the control of the origin and production of animals increase each time more and new solutions and alternatives must be explored to keep the production of meat and the market of exportation. In this aspect the animal traceability becomes important as half to assist in the guarantee of the register of the life of an animal, since its birth until its abates and exportation, including the permanence in farms and contacts with other animals. The OTAG Project (Operational Management and Geo-decisional Prototype you the Agricultural Track and Trace Production) foresees the use of electronic devices with GPS in animals, by means of electronic necklaces. From the data of animal movement, associates to other databases a series of information for diverse levels of users can be gotten. This work presents the use of trajectories for the identification of contacts between animals, from the georeferenced data of animal movement. The database of contacts between animals makes possible the identification of possible animals that had contaminated or can be contaminated from one determined occurrence of the foot-and-mouth disease, one of the illnesses that can reach the animals and harm the production of bovine meat.
close

@inproceedings{PUB00026729, author = {Visoli, M. and Chanet, J.P. and Pinet, F. and Bimonte, S.}, title = {Uso de trajetorias na rastreanilidade bovina}, title = {Utilisation de trajectoires pour la traçabilité bovine}, bookTitle = {SBIAgro 2009, 21/09/2009-25/09/2009, Viçosa, BRA}, pages = {5}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00026729}, year = {2009}, affiliation = {EMPRAPA INFORMATICA AGROPECUARIA CAMPINAS BRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {Brazil is the one of the major producer and exporter in the world of bovine meat in an extremely competitive market. The requirements on the control of the origin and production of animals increase each time more and new solutions and alternatives must be explored to keep the production of meat and the market of exportation. In this aspect the animal traceability becomes important as half to assist in the guarantee of the register of the life of an animal, since its birth until its abates and exportation, including the permanence in farms and contacts with other animals. The OTAG Project (Operational Management and Geo-decisional Prototype you the Agricultural Track and Trace Production) foresees the use of electronic devices with GPS in animals, by means of electronic necklaces. From the data of animal movement, associates to other databases a series of information for diverse levels of users can be gotten. This work presents the use of trajectories for the identification of contacts between animals, from the georeferenced data of animal movement. The database of contacts between animals makes possible the identification of possible animals that had contaminated or can be contaminated from one determined occurrence of the foot-and-mouth disease, one of the illnesses that can reach the animals and harm the production of bovine meat. }, }
close

Dissertations (1)

S. Bimonte
Entreposage et analyse en ligne des données spatiales : application aux données agro-environnementales
2015
abs web bib

Il a été estimé qu'environ 80% des données stockées dans les bases de données transactionnelles intègrent l'information géographique[12]. Les entrepôts de données spatiales (EDSs) et le Spatial OLAP (SOLAP) permettent d'analyser d'énormes volumes de données géoréférencées [1] [11]. Le SOLAP a été appliqué avec succès dans plusieurs domaines tels que le marketing, la santé [2], l'urbanisme, etc. Le succès des technologies SOLAP est principalement basé sur les capacités de ces systèmes à analyser de grandes bases de données de manière interactive, et de les présenter via des interfaces d'analyse visuelle simples et utilisables [2]. Dans ce mémoire, via une étude approfondie des travaux portants sur l'analyse SOLAP des données agro-environnementales (Chapitre 2), nous décrivons les principales questions de recherche liées à l'analyse multidimensionnelle des données agro-environnementales, en soulignant les questions théoriques et d’implémentation. Pour remédier à ces problèmes, nous avons proposé un nouveau cadre pour l'intégration et l’analyse des données agro-environnementales dans les systèmes SOLAP. En particulier, notre cadre proposition prend en charge la modélisation conceptuelle des données spatio-multidimensionnelles vectorielles (Chapitre 3) et continues (Chapitre 4), et la gestion des problèmes de qualité liés à la précision spatiale des données (Chapitre 5) et la cohérence logique. Deuxièmement, nous proposons une architecture SOLAP générique pour faire face à certains problèmes d’implémentation (intégration, entreposage, analyse et géovisualisation). Enfin, pour prendre en compte les compétences des décideurs agro-environnementales, et la complexité de ces applications, nous avons proposé une méthodologie de prototypage rapide basée sur notre modèle conceptuel.
close

@phdthesis{PUB00046024, author = {Bimonte, S.}, title = {Entreposage et analyse en ligne des données spatiales : application aux données agro-environnementales}, title = {Warehousing and online analysis of spatial data: Application for agri-environment data}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00046024}, year = {2015}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {Il a été estimé qu'environ 80% des données stockées dans les bases de données transactionnelles intègrent l'information géographique[12]. Les entrepôts de données spatiales (EDSs) et le Spatial OLAP (SOLAP) permettent d'analyser d'énormes volumes de données géoréférencées [1] [11]. Le SOLAP a été appliqué avec succès dans plusieurs domaines tels que le marketing, la santé [2], l'urbanisme, etc. Le succès des technologies SOLAP est principalement basé sur les capacités de ces systèmes à analyser de grandes bases de données de manière interactive, et de les présenter via des interfaces d'analyse visuelle simples et utilisables [2]. Dans ce mémoire, via une étude approfondie des travaux portants sur l'analyse SOLAP des données agro-environnementales (Chapitre 2), nous décrivons les principales questions de recherche liées à l'analyse multidimensionnelle des données agro-environnementales, en soulignant les questions théoriques et d’implémentation. Pour remédier à ces problèmes, nous avons proposé un nouveau cadre pour l'intégration et l’analyse des données agro-environnementales dans les systèmes SOLAP. En particulier, notre cadre proposition prend en charge la modélisation conceptuelle des données spatio-multidimensionnelles vectorielles (Chapitre 3) et continues (Chapitre 4), et la gestion des problèmes de qualité liés à la précision spatiale des données (Chapitre 5) et la cohérence logique. Deuxièmement, nous proposons une architecture SOLAP générique pour faire face à certains problèmes d’implémentation (intégration, entreposage, analyse et géovisualisation). Enfin, pour prendre en compte les compétences des décideurs agro-environnementales, et la complexité de ces applications, nous avons proposé une méthodologie de prototypage rapide basée sur notre modèle conceptuel. }, }
close

Technical Reports (3)

F. Pinet, S. Bimonte
Rapport sur les technologies SOLAP récentes
2012
abs web bib

L’objectif de cette étude réalisée pour la société Agaetis est de faire un point sur les récentes technologies SOLAP. Il s’agissait après avoir résumé les principes du SOLAP, de faire le tour des principaux outils proposés actuellement : repérer les prototypes de recherche et surtout tester les solutions opérationnelles. Nous avons aussi donné les tendances du domaine que l’on voit apparaître dans les derniers sujets de recherche, tout en donnant notre analyse sur les limites actuelles de la technologie SOLAP. Nous présenterons sous la forme de reviews, le résultat de nos tests de 11 solutions SOLAP (ou presque SOLAP).
close

@techreport{PUB00035966, author = {Pinet, F. and Bimonte, S.}, title = {Rapport sur les technologies SOLAP récentes}, title = {Report on New SOLAP Technologies}, pages = {53}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00035966}, year = {2012}, affiliation = {IRSTEA CLERMONT FERRAND UR TSCF FRA ; IRSTEA CLERMONT FERRAND UR TSCF FRA}, abstract = {L’objectif de cette étude réalisée pour la société Agaetis est de faire un point sur les récentes technologies SOLAP. Il s’agissait après avoir résumé les principes du SOLAP, de faire le tour des principaux outils proposés actuellement : repérer les prototypes de recherche et surtout tester les solutions opérationnelles. Nous avons aussi donné les tendances du domaine que l’on voit apparaître dans les derniers sujets de recherche, tout en donnant notre analyse sur les limites actuelles de la technologie SOLAP. Nous présenterons sous la forme de reviews, le résultat de nos tests de 11 solutions SOLAP (ou presque SOLAP). }, }
close
A. Miralles, F. Vernier, N. Carluer, F. Pinet, K. Faidix, C. Lauvernet, G. Molla, K. Petit, S. Bernard, V. Gouy, S. Bimonte, G. De Sousa, JP. Chanet
Un SIE Pesticides pour la réduction de l’impact des produits phytosanitaires sur l’environnement : rapport novembre 2010 (2ème année)
2010
abs web bib

L’objectif du projet SIE Pesticides est d’améliorer la production des connaissances des équipes thématiques en les dotant d’outils informatiques avant-gardistes conçus spécifiquement par les équipes informatiques. Ces dernières ont en charge en outre la structuration de la connaissance produite quasiment dès sa production. Les travaux ont en plus porté sur l'emboîtement d'échelle des bassins versants.
close

@techreport{PUB00034575, author = {Miralles, A. and Vernier, F. and Carluer, N. and Pinet, F. and Faidix, K. and Lauvernet, C. and Molla, G. and Petit, K. and Bernard, S. and Gouy, V. and Bimonte, S. and De Sousa, G. and Chanet, JP.}, title = {Un SIE Pesticides pour la réduction de l’impact des produits phytosanitaires sur l’environnement : rapport novembre 2010 (2ème année)}, pages = {18}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00034575}, year = {2010}, affiliation = {CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF LYON UR MALY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {L’objectif du projet SIE Pesticides est d’améliorer la production des connaissances des équipes thématiques en les dotant d’outils informatiques avant-gardistes conçus spécifiquement par les équipes informatiques. Ces dernières ont en charge en outre la structuration de la connaissance produite quasiment dès sa production. Les travaux ont en plus porté sur l'emboîtement d'échelle des bassins versants.}, }
close
A. Miralles, V. Gouy, F. Vernier, C. Lauvernet, F. Pinet, N. Carluer, S. Bernard, K. Petit, K. Faidix, G. Molla, JP. Chanet, G. De Sousa, S. Bimonte
Un SIE Pesticides pour la réduction de l’impact des produits phytosanitaires sur l’environnement : rapport octobre 2009 (1ère année)
2009
abs web bib

L’objectif du projet SIE Pesticides est d’améliorer la production des connaissances des équipes thématiques en les dotant d’outils informatiques avant-gardistes conçus spécifiquement par les équipes informatiques. Ces dernières ont en charge en outre la structuration de la connaissance produite quasiment dès sa production.
close

@techreport{PUB00034573, author = {Miralles, A. and Gouy, V. and Vernier, F. and Lauvernet, C. and Pinet, F. and Carluer, N. and Bernard, S. and Petit, K. and Faidix, K. and Molla, G. and Chanet, JP. and De Sousa, G. and Bimonte, S.}, title = {Un SIE Pesticides pour la réduction de l’impact des produits phytosanitaires sur l’environnement : rapport octobre 2009 (1ère année)}, pages = {24}, url = {http://irsteadoc.irstea.fr/cemoa/PUB00034573}, year = {2009}, affiliation = {CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF LYON UR QELY FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF LYON UR QELY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF LYON UR QELY FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF BORDEAUX UR ADBX FRA ; CEMAGREF LYON UR QELY FRA ; CEMAGREF MONTPELLIER UR LCMO UMR TETIS FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA ; CEMAGREF CLERMONT FERRAND UR TSCF FRA}, abstract = {L’objectif du projet SIE Pesticides est d’améliorer la production des connaissances des équipes thématiques en les dotant d’outils informatiques avant-gardistes conçus spécifiquement par les équipes informatiques. Ces dernières ont en charge en outre la structuration de la connaissance produite quasiment dès sa production.}, }
close

Irstea Motive

Bimonte Sandro

Publications

Journal Articles (40)

Book Chapters (14)

In Proceedings (51)

Dissertations (1)

Technical Reports (3)