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

Volume

3

fYear

2004

fDate

26-29 Aug. 2004

Firstpage

1616

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Machine Learning and Cybernetics, 2004. Proceedings of 2004 International Conference on

Print_ISBN

0-7803-8403-2

Type

conf

DOI

10.1109/ICMLC.2004.1382033

Filename

1382033