Title :
Applying DP to ETL of spatial data warehouse
Author :
Chen, Xi-qian ; Chi, Zhong-Xian ; Xiu-Kun Cao
Author_Institution :
Dept. of Comput. Sci., Dalian Univ. of Technol., China
Abstract :
Spatial data warehouse is proposed to facilitate the spatial OLAP and the spatial DM. The spatial data ETL(extraction, cleansing, transformation and loading) plays an important roll in spatial data warehouse. The spatial data ETL should syncretize the spatial data and non-spatial data in the process, which distinguishes it from the traditional ET. The geocoding technique, which assigning geographic coordinates to the actual address is commonly used to solve the problem. To enhance the address matching ability of geocoding, we apply the dynamic programming algorithm, which contributes much to the biological sequence comparison. A full paradigm is given to illuminate the process.
Keywords :
data mining; data warehouses; dynamic programming; geographic information systems; visual databases; DP; biological sequence; data cleansing; data extraction; data loading; data processing; data transformation; dynamic programming algorithm; geocoding technique; geographic coordinates; spatial OLAP; spatial data warehouse; Computer science; Data mining; Data warehouses; Decision making; Delta modulation; Dynamic programming; Filling; Helium; Heuristic algorithms; Spatial databases;
Conference_Titel :
Machine Learning and Cybernetics, 2004. Proceedings of 2004 International Conference on
Print_ISBN :
0-7803-8403-2
DOI :
10.1109/ICMLC.2004.1382033
