Design of ETL Process on Spatio-temporal Data and Study of Quality Control - Computer and Computing Technologies in Agriculture IV - Part I
Conference Papers Year : 2011

Design of ETL Process on Spatio-temporal Data and Study of Quality Control

Abstract

In order to use the space-time data mining technology to conduct operation research in WuLiangSuHai Eutrophication, the water quality sensor parameters of heterogeneous data which reflect the characteristics should set up a spatial data warehouse through ETL process, and water quality sensors for quality control of spatial and temporal data plays a vital role in building an effective analytical environment. The paper designs the ETL process from the data and water quality sensors artificial duty and other heterogeneous data sources spatial data, and proposes data quality control strategy based on the incremental frequency rule engine and the space the inverse distance weighting on the Combination. Experiments show that the incremental frequency rule engine could more effectively find the missing sensor data and abnormal, Space inverse distance weighting method can find the missing data and outliers in the errors within the allowed interpolation processing, ETL procedure is effective and feasible.
Fichier principal
Vignette du fichier
978-3-642-18333-1_57_Chapter.pdf (53.52 Ko) Télécharger le fichier
Origin Files produced by the author(s)
Loading...

Dates and versions

hal-01559580 , version 1 (10-07-2017)

Licence

Identifiers

Cite

Buyu Wang, Changyou Li, Xueliang Fu, Meian Li, Dongqing Wang, et al.. Design of ETL Process on Spatio-temporal Data and Study of Quality Control. 4th Conference on Computer and Computing Technologies in Agriculture (CCTA), Oct 2010, Nanchang, China. pp.487-494, ⟨10.1007/978-3-642-18333-1_57⟩. ⟨hal-01559580⟩
91 View
83 Download

Altmetric

Share

More