In this article, our research aims to set up a geo-decisional system, more precisely we are particularly interested in the spatial analysis system of agricultural production in Madagascar. For this, we used the spatia...In this article, our research aims to set up a geo-decisional system, more precisely we are particularly interested in the spatial analysis system of agricultural production in Madagascar. For this, we used the spatial data warehouse technique based on the SOLAP spatial analysis tool. After having defined the concepts underlying these systems, we propose to address the research issues related to them from four points of view: needs study of the Malagasy Ministry of Agriculture, modeling of a multidimensional conceptual model according to the MultiDim model and the implementation of the system studied using GeoKettle, PostGIS, GeoServer, SPAGO BI and Géomondrian technologies. This new system helps improve the decision-making process for agricultural production in Madagascar.展开更多
In this paper, we first briefly introduce the concepts of clickstream data and data warehouse, analyze twoexisting clickstream star schema click star schema and session star schema in webhouse, then induce a new mod-e...In this paper, we first briefly introduce the concepts of clickstream data and data warehouse, analyze twoexisting clickstream star schema click star schema and session star schema in webhouse, then induce a new mod-el transaction star model based on them, and expressed the method of bringing out the model. Comparing withthe two schemas mentioned above, its most apparent speciality is that it includes a series of meaningful page-view se-quence rather than a single click. Thus, on the one hand it improves the query performance of data, on the other handit is in favor of executing more deepen analysis data mining, and simplifies the process of data pretreatment. Atlast ,the paper verifies its' feasibility and validity using association rules based on the model.展开更多
数据仓库和联机分析处理 (OL AP)是第三代数据库系统的两个重要新技术。由于没有对 OL AP形成准确的、共同认可的数据概念模型 ,造成目前一些支持 OL AP的数据模型都有一些不合理的限制 ,除非这些模型重新设计 ,否则不能回答特殊类型的...数据仓库和联机分析处理 (OL AP)是第三代数据库系统的两个重要新技术。由于没有对 OL AP形成准确的、共同认可的数据概念模型 ,造成目前一些支持 OL AP的数据模型都有一些不合理的限制 ,除非这些模型重新设计 ,否则不能回答特殊类型的询问。在此基础上 ,形式化地定义了一种基于关系的简单、直观的描述复杂大型数据的星型数据模型 ,并设计了 2个简单的星型关系代数以支持在该数据模型上的 OL AP操作。展开更多
文摘In this article, our research aims to set up a geo-decisional system, more precisely we are particularly interested in the spatial analysis system of agricultural production in Madagascar. For this, we used the spatial data warehouse technique based on the SOLAP spatial analysis tool. After having defined the concepts underlying these systems, we propose to address the research issues related to them from four points of view: needs study of the Malagasy Ministry of Agriculture, modeling of a multidimensional conceptual model according to the MultiDim model and the implementation of the system studied using GeoKettle, PostGIS, GeoServer, SPAGO BI and Géomondrian technologies. This new system helps improve the decision-making process for agricultural production in Madagascar.
文摘In this paper, we first briefly introduce the concepts of clickstream data and data warehouse, analyze twoexisting clickstream star schema click star schema and session star schema in webhouse, then induce a new mod-el transaction star model based on them, and expressed the method of bringing out the model. Comparing withthe two schemas mentioned above, its most apparent speciality is that it includes a series of meaningful page-view se-quence rather than a single click. Thus, on the one hand it improves the query performance of data, on the other handit is in favor of executing more deepen analysis data mining, and simplifies the process of data pretreatment. Atlast ,the paper verifies its' feasibility and validity using association rules based on the model.
文摘数据仓库和联机分析处理 (OL AP)是第三代数据库系统的两个重要新技术。由于没有对 OL AP形成准确的、共同认可的数据概念模型 ,造成目前一些支持 OL AP的数据模型都有一些不合理的限制 ,除非这些模型重新设计 ,否则不能回答特殊类型的询问。在此基础上 ,形式化地定义了一种基于关系的简单、直观的描述复杂大型数据的星型数据模型 ,并设计了 2个简单的星型关系代数以支持在该数据模型上的 OL AP操作。
