基于ETL的多源异构空间数据集成技术研究

Research for Multi-Source Heterogeneous Spatial Data Integration Technology Based on ETL

深入分析了地理空间数据的多源性和异构性的来源以及ETL技术的原理。基于从海量的、复杂的基础地理信息数据和框架数据中提取行业相关应用的空间数据的目的,尝试将ETL技术和GIS技术结合的方法,对不同来源、尺度、类型、组织方式及软件支撑平台的基础地理空间数据,在预先定义好的抽取规则和转换规则基础上,通过数据的抽取、清洗、转换,最后装载到框架数据库的实验。实现了空间数据的共享和集成。

This paper analyzed the source of geospatial data ’s multi-source and heterogeneity In-depth,and stated the principle of ETL .For the purpose of extracting the spatial data from basic geographic information database and framework database massively and complexly about industry application .This paper tries to combines the ETL and GIS technologies , and carried out the test of data extraction ,cleansing ,conversion ,and finally loaded into a framework database with different sources,scale,type,organization and software support platform .This test completed at the environment of the extraction rules and transformation rules predefined .At last,this paper achieves the goal for spatial data sharing and integration .