Environmental Datasets-oriented Spatial On-Line Analytical Processing System

  • 1. Key Laboratory of Spatial Data Mining and Information Sharing(Fuzhou University),Ministry of Educaiton, Spatial Information Research Center of Fujian Province, Fujian 350002, China;
    2. Enviroment Infromation Center of Fujian Province, Fuzhou 350003, China

Received date: 2012-10-15

  Revised date: 2012-12-17

  Online published: 2013-02-25


SOLAP is based on the spatial data warehouse and is a kind of on-line spatial data access and analysis for a specific problem. The premise of implementation of SOLAP is to solve the integration problems between the spatial data and non-spatial data in spatial data warehouse. First, the authors analyzed the advantages and disadvantages of the atomic level architectures and the bus architecture of data warehouse, and put forward the hybrid data warehouse architecture. We discussed the hybrid data warehouse architecture model, used the multilayer system artchitecture, and put forward a kind of environment datasets-oriented spatial OLAP system framework, including the production database layer, data warehouse layer (basic business database-subject database)-middleware layer and Business Intellegence (BI) comprehensive analysis layer as well. The production database layer is the basic database for supporting various operations in environmental protection. The data warehouse layer includes the basic business database and the subject data warehouse. The fusion middleware layer mainly includes BI server, Presentation Server and MapViewer Server, that is the B I business logic laye between the application layer and the data warehouse layer. The BI comprehensive analysis layer provides all kinds of query analysis through the interaction between the middleware layer and the data warehouse layer. Then, we analyzed the environmental data integration and spatial data warehouse modeling process, and achieved environmental attribute data integration, which used PowerDesinger 12.5 for data modeling, used Oracle 11g to build environmental spatial data warehouse, and used the Oracle Data Integrator tools. We analyzed and constructed the environmental data spatial dimension extension method and model, which extended the administrative divisions dimension table. We used the Oracle Spatial sdo_geometry abstract data type to realize spatial environment data storage, spatial data and data warehouse data integration storage. And, the integration problem was discussed between OLAP and GIS. The authors implemented the fully integration between OLAP and GIS which uses OBIEE as a OLAP tool, Oracle Mapviewer as GIS component. The GIS service and OLAP service were integrated at the Web server to provide a unified access interface. In the end, the environmental datasets SOLAP prototype system was implemented, which validated the SOLAP framework and the system model.

Cite this article

WU Qun-Yong, LIU Meng-Xin, LI Xi-Jie, CA Wang-Hua . Environmental Datasets-oriented Spatial On-Line Analytical Processing System[J]. Journal of Geo-information Science, 2013 , 15(1) : 90 -96 . DOI: 10.3724/SP.J.1047.2013.00090


[1] Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology[J]. SIGMOD Record, 1997(26):65-74.

[2] Bédard Y, Rivest S, Proulx M-J. Spatial On-Line Analytical Processing (SOLAP): Concepts, architectures, and solutions from a geomatics engineering perspective[M]. Data Warehouses and OLAP: Concepts, Architecture, and Solution, 2006.

[3] Bimonte R, Tchounikine A, and Miquel M. Spatial OLAP: Open issues and a Web Based prototype [C].10th AGILE International Conference on Geographic Information Science, 2007.

[4] Bimonte S, Tchounikine A, Bertolotto M. Integration of geographic information into multidimensional models [C]. The International Conference on Computational Science and Its Applications. ICCSA 2008, Perugia, Italy, 2008, 316-329.

[5] Silva J da, Oliveira A G de, Fidalgo R N, et al. Modelling and querying geographical data warehouses[J]. Information Systems, 2010(35):592-614.

[6] Pestana G, Silva M M Da, Bedard Y. Spatial OLAP modeling: An overview base on spatial objects changing over time [C]. The IEEE 3rd International Conference on Computational Cybernetics, Mauritius, 2005,149-154.

[7] Rivest S, Bédard Y, Proulx M-J, et al. SOLAP: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data[J]. Journal of the International Society for Photogrammetry and Remote Sensing (ISPRS) "Advances in spatio-temporal analysis and representation", 2005, 60(1):17-33.

[8] Fidalgo R N, Times V C, Silva J and Souza F F. Geodwframe: A framework for guiding the design of geographical dimensional schemas, data warehousing and knowledge discovery[J]. Computer Sciences, 2004(3181):26-37.

[9] 樊博,李海刚,孟庆国.空间数据立方体的建模方法研究[J].计算机工程,2007,33(8):7-8,15.

[10] 肖敏,陈岭,夏海元,等.基于数据仓库内在特征的OLAP关键词查询[J].浙江大学学报(工学版),2012,46,(6):974-979.

[11] 何瑞珍,李小勇,孟庆法,等.基于3S的森林立地分类决策支持系统设计[J].西北林学院学报,2011,26(4):172-174.

[12] Ariyachandra T, Watson H. Key organizational factors in data warehouse architecture selection[J]. Decision Support Systems, 2010(49):200-212.

[13] 张曙明.论数据仓库的数据架构设计[J].信息通信技术,2009(3):11-16.

[14] Silva J da, Oliveira A G de, Fidalgo R N, et al. Modelling and querying geographical data warehouses[J]. Information Systems, 2010(35):592-614.

[15] Wu X C. Data center integration development technology: The next generation GIS architecture and development model, Diqiu Kexue-Zhongguo Dizhi Daxue Xuebao/Earth Science[J]. Journal of China University of Geosciences, 2009(34):540-546.

[16] Xiao Y K, Ji C L. Management of air quality monitor data with data warehouse and GIS [C]. 2009 WRI World Congress on Computer Science and Information Engineering, CSIE 2009, March 31, 2009-April 2, 2009, Los Angeles, CA, United States, 2009,148-152.