Research on Extract, Transform and Load(ETL) in Land and Resources Star Schema Data Warehouse

Author

Qin Hanlin ; Jin Xianzhen ; Zhang Xianrong

Author_Institution

Coll. of Zhijiang, Zhejiang Univ. of Technol., Hangzhou, China

Volume

1

fYear

2012

fDate

28-29 Oct. 2012

Firstpage

120

Lastpage

123

Abstract

The extract, transform and Load (ETL) tool is extracting data from multiple, heterogeneous data source, transforming data, and finally loading data into the data warehouse. It is the foundation of any data warehouse, data mining and business intelligence. The land and resources system usually adopts star schema database, so it is difficult to transform the data from source database to target warehouse. This paper research the key technologies of ETL, including data extracting,data transforming, data incremental loading and break-points transmission.

Keywords

data mining; data warehouses; geographic information systems; ETL tool; break-points transmission; data extracting; data incremental loading; data transforming; extract-transform-and-load; land-and-resources star schema data warehouse; star schema database; Data mining; Data models; Data warehouses; Databases; Load modeling; Loading; Transforms; ETL; GIS; Data Warehouse; Land and Resources;

fLanguage

English

Publisher

ieee

Conference_Titel

Computational Intelligence and Design (ISCID), 2012 Fifth International Symposium on

Conference_Location

Hangzhou

Print_ISBN

978-1-4673-2646-9

Type

conf

DOI

10.1109/ISCID.2012.38

Filename

6406933