etl workflow analysis and verification using backwards constraint propagation

	etl workflow analysis and verification using backwards constraint propagation
	Liu Jie ; Liang Senlin ; Ye Dan ; Wei Jun ; Huang Tao
	2009
会议名称	21st International Conference on Advanced Information Systems Engineering, CAiSE 2009
会议日期	43990
会议地点	Amsterdam, Netherlands
关键词	Information systems
页码	455-469
英文摘要	One major contribution of data warehouses is to support better decision making by facilitating data analysis, and therefore data quality is of primary importance. ETL is the process that extracts, transforms, and ultimately loads data into target warehouses. Although ETL workflows can be designed by ETL tools, data exceptions are largely left to human analysis and handled inadequately. Early detection of exceptions helps to improve the stability and efficiency of ETL workflows. To achieve this goal, a novel approach, Backwards Constraint Propagation (BCP), is proposed that automatically analyzes ETL workflows and verifies the target-end restrictions at their earliest points. BCP builds an ETL graph out of a given ETL workflow, encodes the target-end restrictions as integrity constraints, and propagates them backwards from target to sources through the ETL graph by applying constraint projection rules. It is showed that BCP supports most relational algebra operators and data transformation functions. © 2009 Springer Berlin Heidelberg.
收录类别	其他
会议主办者	University of Twente; Centre for Telematics and Information Technology; Netherlands Organisation for Scientific Research; Jacquard; Capgemini
会议录	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
会议录出版者	Germany
会议录出版地	Germany
语种	英语
ISSN号	3029743
ISBN号	3642021433
内容类型	会议论文
源URL	[http://124.16.136.157/handle/311060/8498]
专题	软件研究所_软件工程技术研究开发中心 _会议论文
推荐引用方式 GB/T 7714	Liu Jie,Liang Senlin,Ye Dan,et al. etl workflow analysis and verification using backwards constraint propagation[C]. 见:21st International Conference on Advanced Information Systems Engineering, CAiSE 2009. Amsterdam, Netherlands. 43990.