Quality Ananlysis and ETL Processing of the Sales Data in a Certain Supermarket Chain

被引：0

作者：

Chen, Jiangping ^{[1
]}

Yu, Zhenguo ^{[1
]}

Cai, Ying ^{[1
]}

Xiang, Jiangfan ^{[1
]}

Dong, Wei ^{[2
]}

Ni, Yuzhen ^{[2
]}

机构：

[1] Zhejiang Univ City Coll, Hangzhou 310015, Zhejiang, Peoples R China

[2] Zhejiang Gangxiao Supermarket Co Ltd, Shaoxing 312000, Peoples R China

来源：

PROCEEDINGS OF THE 5TH INTERNATIONAL CONFERENCE ON COOPERATION AND PROMOTION OF INFORMATION RESOURCES IN SCIENCE AND TECHNOLOGY(COINFO 10) | 2010年

关键词：

data quality; supermarket; error; data warehouse; SSIS; SQL Server; ETL;

D O I：

暂无

中图分类号：

TP39 [计算机的应用];

学科分类号：

081203 ; 0835 ;

摘要：

This paper studied the quality of sales data from a certain supermarket chain, and analyzed the causes of the data errors. It also designed the approaches for checking, verifying the data, and built a SSIS pack for ETL and setting up a data warehouse by Microsoft SQL Server system.

引用

页码：315 / +

页数：2