地理编码在空间数据仓库ETL中的应用

空间数据仓库可以有效地管理和利用空间信息以便支持空间分析和决策支持．在空间数据的抽取、转换和加载中如何有效地把非空间信息与空间信息融合起来，是空间数据仓库ETL实现的难点．将地理编码技术引入到空间数据仓库ETL中，给出了融合地理编码模块的ETL体系机构．同时为了提高地址匹配能力，将动态规划算法应用到地理编码地址匹配中，并对算法做了改进．给出了完整的应用示例。

Application of Geocoding in ETL of Spatial Data Warehouse

Spatial data warehouse is proposed to facilitate on-line spatial data analysis .The spatial data extraction,cleansing,transformation and loading represents a critical success factors for spatial data warehouse project. It is important to syncretize the spatial data and nonspatial data in the ETL.In this paper,the geocoding technology which assigning geographic coordinates to the actual address is introduced to implement ETL with a system structure. To improve the ability of address matching,the dynamic programming algorithmic is studied and improved ,and a full paradigm is given to illuminate the process.