Modelling ETL processes of data warehouses with UML activity diagrams

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 5333, Issue , 2008, Pages 44-53

  Muñoz, Lilia ^a   Mazón, Jose Norberto ^b   Pardillo, Jesús ^b   Trujillo, Juan ^b  

^a UNIVERSIDAD TECNOLÓGICA DE PANAMÁ   (Panama)

^b UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Activity diagrams; ETL; Modelling; Processes; UML

Indexed keywords

BUDGET CONTROL; DATA WAREHOUSES; MODELING LANGUAGES; MODELS; PROCESSING;

ACTIVITY DIAGRAM; DYNAMIC ASPECTS; ETL PROCESS; EXTRACTION TRANSFORMATION LOADINGS; HETEROGENEOUS DATA SOURCES; MODELLING ELEMENTS; MODELLING ETL PROCESS; UML ACTIVITY DIAGRAMS;

METADATA;

EID: 84964432684     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-88875-8_21     Document Type: Conference Paper

References (23)

1. Inmon, W.: Building the Data Warehouse. Wiley, Chichester (1992)
2. Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit. Wiley, Chichester (2004)
3. Oracle: Oracle Warehouse Builder 10g, http://www.oracle.com
4. Microsoft: SQL Server 2005 Integration Services (SSIS), http://technet.microsoft.com/enus/sqlserver/bb331782.aspx
5. IBM: WebSphere DataStage, http://www.ibm.com
6. Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of DataWarehouses. Springer, Heidelberg (2000)
7. Shilakes, C., Tylman, J.: Enterprise Information Portals. Enterprise Software Team, http://sagemaker.com/company/downloads/eip/indepth.pdf
8. Demarest, M.: The politics of data warehousing, http://www.hevanet.com/demarest/marc/dwpol.html
9. OMG: Unified Modelling Language. Version 2.0 (2005), http://www.omg.org
10. Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual modeling for ETL processes. In: DOLAP (2002)
11. Simitsis, A., Vassiliadis, P.: A Methodology for the Conceptual Modeling of ETL Processes. In: CAiSE Workshops (2003)
12. Trujillo, J., Luján, S.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In: ER, pp. 307–320 (2003)
13. Luján, S., Vassiliadis, P., Trujillo, J.: Data Mapping Diagrams for Data Warehouse Design with UML. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 191–204. Springer, Heidelberg (2004)
14. Skoutas, D., Simitsis, A.: Designing ETL processes using semantic web technologies. In: DOLAP, pp. 67–74 (2006)
15. Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: On the Logical Modeling of ETL Processes. In: CAiSE, pp. 782–786 (2002)
16. Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Modeling ETL activities as graphs. In: DMDW, pp. 52–61 (2002)
17. Vassiliadis, P., Vagena, Z., Skiadopulos, S., Karayannidis, N., Sellis, T.: ARKTOS: towards the modeling, design, control and excution of ETL processes. Information Systems, 24 (2001)
18. Simitsis, A., Vassiliadis, P., Terrovitis, M., Skiadopoulos, S.: Graph-Based Modeling of ETL Activities with Multi-level Transformations and Updates. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 43–52. Springer, Heidelberg (2005)
19. Simitsis, A., Vassiliadis, P., Skiadopoulos, S., Sellis, T.: Data Warehouse Refreshment. In: Data Warehouses and OLAP: Concepts, Architectures and Solutions, IRM Press (2006)
20. Tziovara, V., Vassiliadis, P., Simitsis, A.: Deciding the physical implementation of ETL workflows. In: DOLAP, pp. 49–56 (2007)
21. Simitsis, A., Vassiliadis, P., Sellis, T.: State-Space Optimization of ETL Workflows. IEEE Trans. Knowl. Data Eng. 17(10), 1404–1419 (2005)
22. Bock, C.: UML 2 Activity and Action Models, Part 2: Actions. Journal of Object Technology 2(5), 41–56 (2003)
23. Mazón, J.-N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the development of data warehouses. In: DOLAP, pp. 57–66 (2005)