期刊文献+
任意字段
题名或关键词
题名
关键词
文摘
作者
第一作者
机构
刊名
分类号
参考文献
作者简介
基金资助
栏目信息

ETL执行过程的优化研究 被引量：21

The Research of Optimizing ETL Execution Process
下载PDF
导出
摘要 提出了一个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
分类号 TP311.13 [自动化与计算机技术—计算机软件与理论]
  • 相关文献

参考文献7

  • 1Vassiliadis P.Conceptual Modeling for ETL Process[C].In:Proc.5th International Workshop on Data Warehousing and OLAP (DOLAP 2002),McLean,VA,USA,2002
  • 2Milo T,Zohar.Using schema matching to simplify heterogeneous data translation[C].In:Proceedings of the 24th International conference on Very Large databases.New York:Morgan Kaufmann,2004
  • 3Vassiliadis P.Modeling ETL Activities as Graphs[C].CAiSE '02,Toronto,Canada,2002.52～61
  • 4Yan Ling Ling,Miller R J.Data-Driven Understanding and Refinement of Schema Mappings[C].ACM SIGMOD,Santa Barbara,California,USA,2001
  • 5Cui YingWei,Widom J.Lineage Tracing for General Data Warehouse Transformations[C].In:Proceedings of the 27th VLDB conference,Roma,Italy,2001
  • 6王木林.基于SQL优化提高数据仓库的ETL效率的方案[J].中国科技信息,2005(18A):95-95. 被引量：2
  • 7韩京宇,徐立臻,董逸生.ETL执行的流水线优化[J].小型微型计算机系统,2005,26(6):1013-1017. 被引量：15

二级参考文献7

  • 1Panos Vassiliadis, Chrstoph Quix, Yannis Vassiliou et al. A model for data warehouse operational processes[C]. The 12th Conference on Advanced Information Systems Engineering(CAISE'00),Stockholm, Sweden, 2000.
  • 2Panos Vassiliadis, Zografoula Vagena, Spiros Skiadopoulos et al. ARKTOS: towards the modeling , design,control and execution of ETL processes[J]. Information Systems, 2001, 26(8):537-561.
  • 3Timos K Sellie. Multiple-query optimization[J]. ACM trans-actions on database system, 1998,13 (1): 23- 52.
  • 4Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos. Conceptual modeling for ETL processes[C]. Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP,2002:14-21.
  • 5Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos. Modeling ETL activities as graphs [C]. In Proc. of 4th International Workshop on the Design and Management of Data Warehouses,Toronto Canada, 2002: 52-61.
  • 6Bouzeghoub M, Fabret F, Matulovic M. Modeling data warehouse refreshment process as a workflow application [C]. In Proc. Intl. Workshop on Design and Management of Data Warehouses, Heidelberg, Germany, 1999.
  • 7唐恒 赵传立.排序引论[M].北京:科学出版社,2002..

共引文献14

同被引文献113

引证文献21

二级引证文献109

计算机科学
2007年 第1期

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部