首页 | 本学科首页   官方微博 | 高级检索  
     

ETL中数据清洗技术在税务系统中的应用
引用本文:王时绘,伍江磊.ETL中数据清洗技术在税务系统中的应用[J].适用技术之窗,2011(11):65-67.
作者姓名:王时绘  伍江磊
作者单位:[1]湖北大学数学与计算机学院软件研究所,湖北武汉430062 [2]湖北大学数学与计算机学院,湖北武汉430062
摘    要:ETL即数据抽取、转换、装载的过程,它是构建数据仓库的重要环节,而数据仓库是面向主题的、集成的、稳定的且随时间不断变化的数据集合。数据清洗是一个减少错误和不一致性、解决对象识别的过程,目前有很多数据清洗研究和ETL研究,但是如何在ETL过程中进行有效的数据清洗,此方面研究不多。本文将以此为问题出发点,探讨ETL中的数据清洗技术在税务系统(贵州省省直属局和九个地市州的原始数据)中的应用。

关 键 词:ETL  中间数据库  目标数据库  MIS系统(管理信息系统)

Data Cleaning Technology of ETL Tax System in the Application
Wang Shihui Wu Jianglei.Data Cleaning Technology of ETL Tax System in the Application[J].Science & Technology Plaza,2011(11):65-67.
Authors:Wang Shihui Wu Jianglei
Affiliation:Wang Shihui Wu Jianglei(1.Mathematics and Computer College Software Institute,Hubei University,Hubei Wuhan 430062; 2.Mathematics and Computer College,Hubei University,Hubei Wuhan 430062)
Abstract:ETL namely data extraction,conversion,loading process.It is the building the important link of the data warehouse.The data warehouse is the theme for,integrated,stable and the changed with time data set. Data cleaning is a reducing errors and inconsistencies,and solve the object recognition process.At present there are many data cleaning research and study,but how to ETL ETL process of effective data cleaning,this research is not much.This paper will be based on the starting point,this paper discusses the problem of cleaning technology in data ETL tax system(guizhou province ZhiShuJu and nine cities and states of the original data) application.
Keywords:Extraction-Transformation-Loading  Staging Database  Target Database  Management Information System
本文献已被 维普 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号