中国科学院软件研究所机构知识库
Advanced  
ISCAS OpenIR  > 软件工程技术研究开发中心  > 会议论文
题名:
etl workflow analysis and verification using backwards constraint propagation
作者: Liu Jie ; Liang Senlin ; Ye Dan ; Wei Jun ; Huang Tao
会议文集: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
会议名称: 21st International Conference on Advanced Information Systems Engineering, CAiSE 2009
会议日期: 43990
出版日期: 2009
会议地点: Amsterdam, Netherlands
关键词: Information systems
出版者: Germany
出版地: Germany
收录类别: 其他
ISSN: 3029743
ISBN: 3642021433
部门归属: (1) University of Science and Technology of China, Anhui Hefei, China; (2) Institute of Software, Chinese Academy of Sciences, Beijing, China; (3) Department of Computer Science, State University of New York at Stony Brook, Stony Brook NY 11794, United States
主办者: University of Twente; Centre for Telematics and Information Technology; Netherlands Organisation for Scientific Research; Jacquard; Capgemini
英文摘要: 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.
语种: 英语
内容类型: 会议论文
URI标识: http://ir.iscas.ac.cn/handle/311060/8498
Appears in Collections:软件工程技术研究开发中心 _会议论文

Files in This Item:
File Name/ File Size Content Type Version Access License
etl workflow analysis and verification using backwards constraint propagation.pdf(444KB)----限制开放-- 联系获取全文

Recommended Citation:
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.
Service
Recommend this item
Sava as my favorate item
Show this item's statistics
Export Endnote File
Google Scholar
Similar articles in Google Scholar
[Liu Jie]'s Articles
[Liang Senlin]'s Articles
[Ye Dan]'s Articles
CSDL cross search
Similar articles in CSDL Cross Search
[Liu Jie]‘s Articles
[Liang Senlin]‘s Articles
[Ye Dan]‘s Articles
Related Copyright Policies
Null
Social Bookmarking
Add to CiteULike Add to Connotea Add to Del.icio.us Add to Digg Add to Reddit
所有评论 (0)
暂无评论
 
评注功能仅针对注册用户开放,请您登录
您对该条目有什么异议,请填写以下表单,管理员会尽快联系您。
内 容:
Email:  *
单位:
验证码:   刷新
您在IR的使用过程中有什么好的想法或者建议可以反馈给我们。
标 题:
 *
内 容:
Email:  *
验证码:   刷新

Items in IR are protected by copyright, with all rights reserved, unless otherwise indicated.

 

 

Valid XHTML 1.0!
Copyright © 2007-2017  中国科学院软件研究所 - Feedback
Powered by CSpace