A taxonomy of ETL activities

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2009, Pages 25-32

  Vassiliadis, Panos ^a   Simitsis, Alkis ^b   Baikousi, Eftychia ^a  

^a UNIVERSITY OF IOANNINA   (Greece)

^b HEWLETT PACKARD LABORATORIES   (United States)

Author keywords

Data warehouses; ETL; Optimization; Taxonomy

Indexed keywords

BLACK BOX APPROACH; BLACK BOXES; BUILDING BLOCKES; ETL; EXTRACT TRANSFORM LOADS; GENERIC PROPERTIES; NORMAL FORM; OPERATIONAL DATA; SOFTWARE MODULES; UNIFIED APPROACH; WHOLE PROCESS; WORK-FLOWS;

KNOWLEDGE MANAGEMENT; MANAGEMENT; OPTIMIZATION; TAXONOMIES;

DATA WAREHOUSES;

EID: 74549132841     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1651291.1651297     Document Type: Conference Paper

References (23)

1. Y. Cui, J. Widom. Lineage tracing for general data warehouse transformations. In VLDB J. 12(1): 41-58, 2003.
2. U. Dayal, M. Castellanos, A. Simitsis, K. Wilkinson. Data integration flows for business intelligence. In EDBT, pp. 1-11, 2009.
3. A. Dobre, F. Hakimpour, K.R. Dittrich. Operators and Classification for Data Mapping in Semantic Integration. In ER, pp. 534-547, 2003.
4. L. M. Haas, M. A. Hernández, H. Ho, L. Popa, M. Roth. Clio Grows Up: From Research Prototype to Industrial Tool. In SIGMOD, pp. 805-810, 2005.
5. IBM, "IBM Data Warehouse Manager", in the Web, available at: http://www-306.ibm.com/software/data/integration/datastage/,2009.
6. Informatica. How to Achieve Flexible, Cost-effective, Scalability and Performance through Pushdown Processing. White paper, 2007.
7. Informatica, "PowerCenter", in the Web, available at: http://www.informatica.com/products/powercenter/, 2009.
8. A. Karagiannis, P. Vassiliadis, A. Simitsis. Macro-level Scheduling of ETL Workflows. Submitted for publication, 2009.
9. S. Luján-Mora, P. Vassiliadis, J. Trujillo. Data Mapping Diagrams for Data Warehouse Design with UML. In ER, pp.191-204, 2004.
10. Microsoft. SQL Server 2005 Integration Services (SSIS), in the Web, available at: http://technet.microsoft.com/enus/sqlserver/bb331782.aspx, 2009
11. Oracle, "Oracle Warehouse Builder 10g", in the Web, available at http://www.oracle.com/technology/products/warehouse/, 2009.
12. N. Polyzotis, S. Skiadopoulos, P. Vassiliadis, A. Simitsis, N.-E. Frantzell. Supporting Streaming Updates in an Active Data Warehouse. In ICDE, pp. 476-485, 2007.
13. E. Rahm, P. A. Bernstein. A Survey of Approaches to Automatic Schema Matching. In VLDB Journal, 10(4): 334-350, 2001.
14. A. Simitsis, P. Vassiliadis, U. Dayal, A. Karagiannis, V. Tziovara. Benchmarking ETL Workflows. In TPC-TC, 2009.
15. A. Simitsis, P. Vassiliadis, T. K. Sellis. Optimizing ETL Processes in Data Warehouses. In ICDE, pp. 564-575, 2005.
16. A. Simitsis, K. Wilkinson, M. Castellanos, U. Dayal. QoX-driven ETL design: reducing the cost of ETL consulting engagements. In SIGMOD Conference, pp. 953-96, 2009.
17. D. Skoutas, A. Simitsis. Designing ETL processes using semantic web technologies. In DOLAP, pp. 67-74, 2006.
18. M. Thiele, U. Fischer, W. Lehner: Partition-based workload scheduling in living data warehouse environments. In DOLAP, pp. 57-64, 2007.
19. C. Thomsen, T.B. Pedersen, W. Lehner. RiTE: Providing On-Demand Data for Right-Time Data Warehousing. In ICDE, pp. 456-465, 2008.
20. J. Trujillo, S. Luján-Mora: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In ER, pp. 307-320, 2003.
21. V. Tziovara, P. Vassiliadis, A. Simitsis. Deciding the physical implementation of ETL workflows. In DOLAP, pp. 49-56, 2007.
22. P. Vassiliadis, A. Simitsis, P. Georgantas, M. Terrovitis. A Framework for the Design of ETL Scenarios. In CAiSE, pp. 520-535, 2003.
23. P. Vassiliadis, A. Simitsis, S. Skiadopoulos: Conceptual modeling for ETL processes. In DOLAP, pp. 14-21, 2002.