| 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 |
| 会议录名称 | Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) |
| 页码 | 455-469 |
| 会议日期 | 43990 |
| 会议地点 | Amsterdam, Netherlands |
| 收录类别 | 其他 |
| 出版地 | 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 |
| 摘要 | 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. |
| 关键词 | Information Systems |
| 主办者 | University of Twente; Centre for Telematics and Information Technology; Netherlands Organisation for Scientific Research; Jacquard; Capgemini |
| 语种 | 英语 |
| 内容类型 | 会议论文 |
| URI标识 | http://ir.iscas.ac.cn/handle/311060/8498 |
| 专题 | 软件工程技术研究开发中心 |
| 推荐引用方式 GB/T 7714 | Liu Jie,Liang Senlin,Ye Dan,et al. etl workflow analysis and verification using backwards constraint propagation[C]. Germany:Germany,2009:455-469. |
| 条目包含的文件 | ||||||
| 文件名称/大小 | 文献类型 | 版本类型 | 开放类型 | 使用许可 | ||
| etl workflow analysi（444KB） | 开放获取 | -- | 请求全文 | |||
除非特别说明，本系统中所有内容都受版权保护，并保留所有权利。
修改评论