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

Application of Geocoding in ETL of Spatial Data Warehouse

作　　者：陈细谦[1] 迟忠先[1] 昃宗亮[1] 苏立强[1] 

机构地区：[1]大连理工大学计算机系,辽宁大连116024

出　　处：《小型微型计算机系统》2005年第4期628-630,共3页Journal of Chinese Computer Systems

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

关 键 词：地理编码 空间数据仓库 ETL 动态规划 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]