期刊文献+

基于状态空间搜索的ETL过程优化 被引量:4

Optimizing ETL processes based on state-space search
下载PDF
导出
摘要 针对Simitsis[1,2]等人提出的ETL过程优化算法中存在不足之处,提出了改进的启发式搜索算法,实验证明改进后的算法较好地降低了实际执行的代价,解决了原算法的短视性。 The paper analyzes the shortcomings of the Simitsis's algorithms towards the minimization of the execution of an ETL workflow.Improved algorithms are introduced,and the result of the simulation shows that the improved algorithms amend the per- formance attributes on execution cost and short sight.
出处 《计算机工程与应用》 CSCD 北大核心 2007年第26期169-173,共5页 Computer Engineering and Applications
关键词 ETL工作流 状态空间 变换 启发式搜索算法 ETL workflow state-space transformation heuristic search
  • 相关文献

参考文献6

  • 1Simitsis A,Vassiliadis P,Sellis T.Optimizing ETL processes in data warehouses[C]//Proceedings of 21st International Conference on Data Engineering( ICDE ) ,Tokyo, Japan, 2005 : 564-575.
  • 2Vassiliadis P,Simitsis A,Terrovitis M.A framework for the design ETL scenarios[C]//Proceedings of the 15th Conference on Advanced Information Systems Engineering(CAISE' 2003),Klagenfurt, Austria, 2003 : 520-535.
  • 3Microsoft.Data transformation services [EB/OL].[2003-03-19].http :// www.microsoft.con3/technet/community/events/sq12000/tnt1-78.mspx.
  • 4Oracle Corp.Oracle9i warehouse builder user's guide [EB/OL]. [2001 - 11-01 ].http ://otn. oracle.com/products/warehouse/content.html.
  • 5Jarke M,Koch J.Query optimization in database systems[C]//ACM Computing Surveys (CSUR), 1984,6 : 111-152.
  • 6Ozsu M T,Valduriez P.Principles of distributed database systems [M].American : Prentice Hall, 1991.

同被引文献22

  • 1唐朝舜,董玉德.八数码的启发式搜索算法及实现[J].安徽职业技术学院学报,2004,3(3):9-12. 被引量:4
  • 2史捷,鲍玉斌,刘运涛,张斌,孙焕良,于戈.数据仓库系统中任务调度策略研究[J].控制与决策,2005,20(1):109-112. 被引量:3
  • 3韩京宇,徐立臻,董逸生.ETL执行的流水线优化[J].小型微型计算机系统,2005,26(6):1013-1017. 被引量:15
  • 4吴远红.ETL执行过程的优化研究[J].计算机科学,2007,34(1):81-83. 被引量:21
  • 5Hironori Kasahara, Seinosuke Narita. Practical multiprocessor scheduling algorithms for efficient parallel processing[J]. IEEE Trans on Computers, 1984, 33(11): 1023-1029.
  • 6Edwin S H Hou, Nirwan Ansari. Genetic algorithm for multiprocessor scheduling[J]. IEEE Trans on Parallel and Distributed Systems, 1994, 5(2): 113-120.
  • 7Simitsis A, Vassiliadis P, Sellis T. Optimizing ETL processes in data warehouses[C]. Proc of 21st Int Conf on Data Engineering(ICDE). Tokyo, 2005: 564-575.
  • 8Simitsis A, Vassiliadis P, Sellis T. Optimizing ETL proces- ses in data warehouses [C]. Proc of 21st Int Conf on Data Engineer- ing (ICDE) . Tokyo, 2005 :564--575.
  • 9Inmon W H. Building the Data Warehouse [M]. 4th ed. Indiana, USA: Wiley Publications, 2005.
  • 10Hironori Kasahara, Seinosuke Narita. Practical multiprocessor scheduling algorithms for efficient parallel processing [J]. IEEE Trans on Computers, 1984, 33 (11) : 1023 - 1029.

引证文献4

二级引证文献19

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

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