A UML based approach for modeling ETL processes in data warehouses

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

Volumn 2813, Issue , 2003, Pages 307-320

  Trujillo, Juan ^a   Luján Mora, Sergio ^a  

^a UNIVERSITY OF ALICANTE   (Spain)

Author keywords

Conceptual modeling; Data warehouses; ETL processes; UML

Indexed keywords

DATA MINING; DATA WAREHOUSES; DECISION MAKING; EXTRACTION; METADATA; MODELING LANGUAGES;

COMPLEX COMPUTER SYSTEMS; CONCEPTUAL MODEL; DECISION MAKING PROCESS; ETL PROCESS; EXTRACTION TRANSFORMATION LOADINGS; SEAMLESS INTEGRATION; UML; UML-BASED APPROACH;

UNIFIED MODELING LANGUAGE;

EID: 0142218996     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-39648-2_25     Document Type: Article

References (22)

1. Inmon, W.H.: Building the Data Warehouse. QED Press/John Wiley (1992) (Last edition: 3rd edition, John Wiley & Sons, 2002).
2. SQL Power Group: How do I ensure the success of my DW? Internet: http://www.sqlpower.ca/page/dw_best_practices (2002)
3. Strange, K.: ETL Was the Key to this Data Warehouse's Success. Technical Report CS-15-3143, Gartner (2002)
4. Rahm, E., Do, H.: Data Cleaning: Problems and Current Approaches. IEEE Bulletin of the Technical Committee on Data Engineering 23 (2000) 3-13
5. Friedman, T.: ETL Magic Quadrant Update: Market Pressure Increases. Technical Report M-19-1108, Gartner (2003)
6. L. Greenfield: Data Extraction, Transforming, Loading (ETL) Tools. The Data Warehousing Information Center. Internet: http://www.dwinfocenter.org/clean.html (2003)
7. Agosta, L.: Market Overview Update: ETL. Technical Report RPA-032002-00021, Giga Information Group (2002)
8. Kimball, R.: The Data Warehouse Toolkit. John Wiley & Sons (1996) (Last edition; 2nd edition, John Wiley & Sons, 2002).
9. Object Management Group (OMG): Unified Modeling Language Specification 1.4. Internet: http://www.omg.org/cgi-bin/doc?formal/01-09-67 (2001)
10. Trujillo, J., Palomar, M., Gómez, J., Song, I.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses 34 (2001) 66-75
11. Luján-Mora, S., Trujillo, J., Song, I.: Extending UML for Multidimensional Modeling. In: Proc. of the 5th International Conference on the Unified Modeling Language (UML 2002). Volume 2460 of LNCS., Dresden, Germany, Springer-Verlag (2002) 290-304
12. Luján-Mora, S., Trujillo, J., Song, I.: Multidimensional Modeling with UML Package Diagrams. In: Proc. of the 21st International Conference on Conceptual Modeling (ER 2002). Volume 2503 of LNCS., Tampere, Finland, Springer-Verlag (2002) 199-213
13. Eckerson, W.: Data Quality and the Bottom Line. Technical report, The Data Warehousing Institute (2002)
14. Naiburg, E., Maksimchuk, R.: UML for Database Design. Addison-Wesley (2001)
15. Golfarelli, M., Rizzi, S.: A methodological Framework for Data Warehouse Design. In: Proc. of the ACM 1st Intl. Workshop on Data warehousing and OLAP (DOLAP'98), Washington D.C., USA (1998) 3-9
16. Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. In: Proc. of the 1st Intl. Workshop on Data Warehouse and Data Mining (DWDM'98). Volume 1552 of LNCS., Springer-Verlag (1998) 105-116
17. Tryfona, N., Busborg, F., Christiansen, J.: starER: A Conceptual Model for Data Warehouse Design. In: Proc. of the ACM 2nd Intl. Workshop on Data warehousing and OLAP (DOLAP'99), Kansas City, Missouri, USA (1999)
18. Husemann, B., Lechtenborger, J., Vossen, G.: Conceptual Data Warehouse Design. In: Proc. of the 2nd. Intl. Workshop on Design and Management of Data Warehouses (DMDW'2000), Stockholm, Sweden (2000) 3-9
19. Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An Extension of UML. In: International Database Engineering & Applications Symposium (IDEAS 2002), Edmonton, Canada (2002) 172-181
20. National Technical University of Athens (Greece): Knowledge and Database Systems Laboratory. Internet: http://www.dblab.ntua.gr/ (2003)
21. Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual Modeling for ETL Processes. In: 5th ACM International Workshop on Data Warehousing and OLAP (DOLAP 2002), McLean, USA (2002) 14-21
22. Vassiliadis, P., Vagena, Z., Skiadopoulos, S., Karayannidis, N., Sellis, T.: ARKTOS: towards the modeling, design, control and execution of ETL processes. Information Systems (2001) 537-561