Deciding the physical implementation of ETL workflows

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2007, Pages 49-56

  Tziovara, Vasiliki ^a   Vassiliadis, Panos ^a   Simitsis, Alkis ^b  

^a UNIVERSITY OF IOANNINA   (Greece)

^b IBM ALMADEN RESEARCH CENTER   (United States)

Author keywords

data warehousing; ETL; optimization; physical design

Indexed keywords

COST MODELS; ETL; LOGICAL LEVELS; LOW-COSTS; OPTIMISATIONS; PHYSICAL DESIGN; SPACE PROBLEM; STATE-SPACE; SUITABLE SOLUTIONS; WORK-FLOWS;

DATA WAREHOUSES;

EID: 70849122649     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1317331.1317341     Document Type: Conference Paper

References (9)

1. J. M. Hellerstein. Optimization Techniques for Queries with Expensive Methods. ACM Trans. Database Syst., 23(2):113-157, 1998.
2. T. Neumann and G. Moerkotte. An Efficient Framework for Order Optimization. In ICDE, pages 461-472, 2004.
3. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price. Access Path Selection in a Relational Database Management System. In SIGMOD, pages 23-34, 1979.
4. A. Simitsis, P. Vassiliadis, and T. K. Sellis. Optimizing ETL Processes in Data Warehouses. In ICDE, pages 564-575, 2005.
5. A. Simitsis, P. Vassiliadis, and T. K. Sellis. State-Space Optimization of ETL Workflows. IEEE Trans. Knowl. Data Eng., 17(10):1404-1419, 2005.
6. D. E. Simmen, E. J. Shekita, and T. Malkemus. Fundamental Techniques for Order Optimization. In SIGMOD, pages 57-67, 1996.
7. V. Tziovara. Order-Aware ETL Workflows. Master's thesis, University of Ioannina. Available as a TR at http://www.cs.uoi.gr, 2006.
8. P. Vassiliadis, A. Karagiannis, V. Tziovara, and A. Simitsis. Towards a Benchmark for ETL workflows. In QDB'07 (in conj. with VLDB'07), 2007.
9. X. Wang and M. Cherniack. Avoiding Ordering and Grouping In Query Processing. In VLDB, pages 826-837, 2003.