地球信息科学学报 ›› 2013, Vol. 15 ›› Issue (1): 90-96.doi: 10.3724/SP.J.1047.2013.00090

• 地理信息系统平台设计 • 上一篇    下一篇

面向环境数据集的Spatial OLAP系统集成

邬群勇1, 刘梦鑫1, 李细杰1, 蔡旺华2   

  1. 1. 福州大学空间数据挖掘与信息共享教育部重点实验室 福建省空间信息工程研究中心, 福州 350002;
    2. 福建省环境信息中心, 福州 350003
  • 收稿日期:2012-10-15 修回日期:2012-12-17 出版日期:2013-02-25 发布日期:2013-02-25
  • 作者简介:邬群勇(1973-),男,博士,副研究员,研究方向为GIS与计算机应用。E-mail:qywu@fzu.edu.cn
  • 基金资助:

    国家自然科学基金项目(40801151);福建省自然科学基金项目(2012J01168)。

Environmental Datasets-oriented Spatial On-Line Analytical Processing System

WU Qunyong1, LIU Mengxin1, LI Xijie1, CAI Wanghua2   

  1. 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:2012-10-15 Revised:2012-12-17 Online:2013-02-25 Published:2013-02-25

摘要:

SOLAP是以空间数据仓库为基础,针对特定问题的联机空间数据访问和分析,实现SOLAP的前提是解决空间数据与非空间数据在空间数据仓库中的集成问题。首先,论文结合混合数据仓库架构模式,采用多层体系结构设计,提出和构建了一种面向环境数据集的空间OLAP系统的体系架构,包括"生产数据库—数据仓库层(基础业务库-主题数据库)-中间件层—BI综合分析层"等4个层次。接着,分析了环境数据集成和空间数据仓库建模过程,采用Oracle 11g来构建环境空间数据仓库,通过使用ODI工具的ETL功能实现环境属性数据集成。分析和构建了环境数据空间维度扩展的方法和模型,通过扩展行政区划维度表,使用Oracle Spatial sdo_geometry 抽象几何数据类型存储环境空间数据,实现了空间数据和数据仓库数据的一体化存储。分析了SOLAP系统中OLAP和GIS的集成问题,采用OBIEE作为OLAP工具,Oracle Mapviewer作为GIS组件、GIS服务和OLAP 服务在Web服务器中进行业务逻辑集成,对外提供统一的访问接口,实现OLAP和GIS的完全集成。最后,实现了一个环境数据集SOLAP原型系统,验证了论文的框架和模型。

关键词: Spatial OLAP, 空间数据仓库, 空间维度模式, 环境数据集

Abstract:

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.

Key words: environmental datasets, SOLAP, spatial dimensional schemas, spatial data warehouse