国家级地质环境数据仓库的设计与实现  

Designing and Building the National Geo-Environment Monitoring Data Warehouse

作　　者：张鸣之[1] 喻孟良[1] 王勇[1] 李振华[2] 梅红波[3] 吴湘宁[4] 肖敦辉[3] 胡光道[3] 谭照华 

机构地区：[1]中国地质环境监测院信息室,北京100081 [2]中国地质大学计算机学院,湖北武汉430074 [3]中国地质大学资源学院,湖北武汉430074 [4]三峡库区地质灾害防治工作指挥部,湖北宜昌443000

出　　处：《地球科学（中国地质大学学报）》2013年第6期1347-1355,共9页Earth Science-Journal of China University of Geosciences

基　　金：中国地质调查局"环境地质调查数据集成与服务系统建设"项目(No.1212011220353);中国地质环境监测院"国家级地环节点系统地质环境数据仓库及数据仓库管理子系统研究"项目(No.2013194013)

摘　　要：目前由中国地质环境监测院具体实施的国家级地质环境信息化建设工作,以构建国家级地质环境数据中心,实现全国地质环境信息的大综合、大协作和大集成为总体目标.其数据来源多样、数据类型复杂,且体量巨大、结构性和非结构性数据并存.为实现快速、充分地挖掘提炼数据中蕴含的价值,基于大数据思想,运用数据仓库技术,将各类操作型数据面向业务分析整合,形成协同有序的数据中心,按业务进一步划分为地质灾害防治、地下水监测与保护、矿山地质环境监测评价等4个数据集市,每个集市下又包含若干主题或二级主题.应用该数据仓库横向打通了各业务系统的数据,实现了不同维、不同粒度、不同侧面查询和观察数据的功能,为业务分析和决策支持提供了数据保障,为捕获地质环境业务数据价值提出了新模式.China Institute of Geo-Environment Monitoring is building a national-level geological environment information platform, as an important part of a national data center aiming to collect, integrate and analyze the national geological environment data characterized by its huge size, multi-source, both structured and unstructured storage. In order to extract valuable information from the data center rapidly, a data warehouse based on the concept of big data is applied to integrate operational data into data center for professional analysis. The system running results show that the data warehouse, which consists of 8 data marts （geo-hazard prevention, underground water monitoring and protection, mining geology environment and etc） and each of them can be divided successively into various subjects and sub-subjects by loading data into star schema in multiple dimensions, different levels of granularities and various perspectives, can provide multi-dimensional data analysis and support decision-making, and therefore presents a new strategy on discovering valuable information from geo-environmental data.

关 键 词：大数据 数据仓库 数据集市 数据挖掘 地下水 地质环境评价 地质灾害 

分 类 号：P641.8[天文地球—地质矿产勘探]