English

应用科学学报 ›› 2005, Vol. 23 ›› Issue (3): 300-304.

• 论文 • 上一篇    下一篇

基于数据水平分割的ETL执行优化

韩京宇, 徐立臻, 董逸生   

  1. 东南大学计算机科学与工程系, 江苏南京 210096
  • 收稿日期:2004-01-06 修回日期:2004-05-18 出版日期:2005-05-31 发布日期:2005-05-31
  • 作者简介:韩京宇(1976-),男,吉林白山人,博士生,E-mail:hjy3789759@163.com;董逸生(1940-),男,江苏启东人,教授,博导,E-mail:ysdong@seu.edu.cn
  • 基金资助:
    江苏省十五高科技项目(BG2001013)

Optimization of ETL Execution by the Horizontal Partitioning Method

HAN Jing-yu, XU Li-zhen, DONG Yi-sheng   

  1. Department of Computer Science and Engineering, Southeast University, Nanjing 210096, China
  • Received:2004-01-06 Revised:2004-05-18 Online:2005-05-31 Published:2005-05-31

PDF

89

被引次数

8

摘要： 提出了一个ETL优化框架,并指出"单视图单衍生"、"多视图单衍生"、"单视图多衍生"和"多视图多衍生"4种模式在加载和增量维护时都可以采用数据水平分割的方法来加快ETL过程的响应时间,理论分析和实验表明其具有良好的效果.

关键词: ETL, 增量维护, 水平分割

Abstract: ETL is a tool suite for data loading and maintaining of data warehouse.How to efficiently shorten the ETL process execution time is a big challenge because the volume of data to be processed is very large. Four types of view horizontal patition approaches such as " single fact derived by one view", " single fact derived by many views", "many facts derived by one view" and "many facts derived by many views" are proposed to shorten the execution time.The theory and experiment result prove it to be efficient.

Key words: ETL, horizontal partition, incremental maintenance

中图分类号: