2012•Unpublished venueRequires access

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

Qin Hanlin, Xianzhen Jin, Zhang Xianrong

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.

About this research paper

What this paper is about

Why it matters

OpenAlex reports 18 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Data warehouse, Star schema, Computer science, Database, Online analytical processing, Schema (genetic algorithms), Data integration, Data source