摘要
提出了一个ETL(Extraction-Transformation-Loading)优化框架并对ETL过程的逻辑优化进行了研究,把优化问题建模成状态空间搜索问题。每个ETL工作流看作一种状态,通过一系列正确的状态变换来构造状态空间,并且提出算法来获得最小执行时间的ETL工作流。理论分析和实践表明其具有良好效果。
An optimization framework is provided in the paper , and the logical optimization of ETL processes is researched. The optimization problem is modeled as a state-space search problem. Each ETL workflow is considered as a state and the state space is fabricated through a set of correct state transitions. Moreover, algorithms are provided towards the minimization of the execution cost of an ETL workflow. The theory and experiment result prove it to be efficient.
出处
《计算机科学》
CSCD
北大核心
2007年第1期81-83,共3页
Computer Science
基金
浙江省教育厅项目(20050113)
浙江海洋学院项目(X05LQ07)
关键词
ETL
工作流
优化
ETL, Workflow, Optimization