Author(s)

Jingting Wang, Bao Liu

Corresponding Author

Jingting Wang

Abstract

This paper takes the current business system of automobile department store chain sales service company as an example, and analyzes the problem that the data from multiple data sources cannot directly be loaded into the data warehouse by the current commercial ETL (Extraction-Transformation-Loading, ETL) tool. Firstly, it designs the logical model of ETL tool based on the metadata, then customizes the data cleaning method in ETL tool. Finally, the system experiments are carried out on ETL tool, and the experimental results and analysis are given. Through the development of the ETL tool, an interface is provided for the user-defined data cleaning function, which makes up for the shortage of the custom data cleaning function by the commercial ETL tool, thereby the use efficiency of ETL tool is improved.

Keywords

Data Warehouse, Structured Data, Extraction-Transformation-Loading(ETL), Metadata