| 基于数据水平分割的ETL执行优化 |
| |
| 引用本文： | 韩京宇,徐立臻,董逸生. 基于数据水平分割的ETL执行优化[J]. 应用科学学报, 2005, 23(3): 300-304 |
| |
| 作者姓名： | 韩京宇 徐立臻 董逸生 |
| |
| 作者单位： | 东南大学计算机科学与工程系, 江苏南京 210096 |
| |
| 基金项目： | 江苏省十五高科技项目(BG2001013) |
| |
| 摘 要： | 提出了一个ETL优化框架,并指出"单视图单衍生"、"多视图单衍生"、"单视图多衍生"和"多视图多衍生"4种模式在加载和增量维护时都可以采用数据水平分割的方法来加快ETL过程的响应时间,理论分析和实验表明其具有良好的效果.
|
| 关 键 词： | ETL 增量维护 水平分割 |
| 文章编号： | 0255-8297(2005)03-0300-05 |
| 收稿时间： | 2004-01-06 |
| 修稿时间： | 2004-05-18 |
Optimization of ETL Execution by the Horizontal Partitioning Method |
| |
| HAN Jing-yu,XU Li-zhen,DONG Yi-Sheng. Optimization of ETL Execution by the Horizontal Partitioning Method[J]. Journal of Applied Sciences, 2005, 23(3): 300-304 |
| |
| Authors: | HAN Jing-yu XU Li-zhen DONG Yi-Sheng |
| |
| Affiliation: | Department of Computer Science and Engineering, Southeast University, Nanjing 210096, China |
| |
| 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. |
| |
| Keywords: | ETL horizontal partition incremental maintenance |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《应用科学学报》浏览原始摘要信息 |
|
点击此处可从《应用科学学报》下载全文 |
