Title :
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
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;
Conference_Titel :
Computational Intelligence and Design (ISCID), 2012 Fifth International Symposium on
Conference_Location :
Hangzhou
Print_ISBN :
978-1-4673-2646-9
DOI :
10.1109/ISCID.2012.38
