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

摘要：

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.

关键词： ETL GIS Data Warehouse Land and Resources

作者: Qin, Hanlin Jin, Xianzhen Zhang, Xianrong

作者单位: College of Zhijiang, Zhejiang University of Technology Hangzhou, China

会议类型: 国际会议

会议名称: 2012 Fifth International Symposium on Computational Intelligence and Design 第五届计算智能与设计国际会议 ISCID 2012

会议地点: 杭州

会议语种:英文

页码: 120-123

在线出版日期: 2012-10-28（万方平台首次上网日期，不代表论文的发表时间）