Research on ETL Method of Land and Resources Data

摘要

Data Warehouse Technology is the key technical method for Land and Resources industry to informationize and make a scientific management and decision-making, nevertheless the ETL process is an important part of the Data Warehouse's establishment. Based on the analysis of characteristics of land and resources data, the visualized ETL tools and SQL language are adopted jointly according to land and resources' attribute data; meanwhile the GIS desktop tools and SQL language are used according to the spatial data. The detailed technical procedures of these two ETL methods were thoroughly discussed in this paper.