Modelling ETL processes of data warehouses with UML activity diagrams
Extraction-transformation-loading (ETL) processes play an important role in a data warehouse (DW) architecture because they are responsible of integrating data from heterogeneous data sources into the DW repository. Importantly, most of the budget of a DW project is spent on designing these processe...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | , , |
| Format: | article |
| Language: | English |
| Published: |
2018
|
| Subjects: | |
| Online Access: | http://ridda2.utp.ac.pa/handle/123456789/4916 |
| Tags: |
No Tags, Be the first to tag this record!
|
| _version_ | 1869652473670533120 |
|---|---|
| author | Muñoz, Lilia |
| author2 | Mazón, Jose Norberto Pardillo, Jesús Trujillo, Juan |
| author2_role | author author author |
| author_browse | Mazón, Jose Norberto Muñoz, Lilia Pardillo, Jesús Trujillo, Juan |
| author_facet | Muñoz, Lilia Mazón, Jose Norberto Pardillo, Jesús Trujillo, Juan |
| author_role | author |
| collection | Repositorio Institucional de documento digitales de acceso abierto de la UTP |
| dc.creator.none.fl_str_mv | Muñoz, Lilia Mazón, Jose Norberto Pardillo, Jesús Trujillo, Juan |
| dc.date.none.fl_str_mv | 11/09/2008 11/09/2008 2018-06-13T20:17:41Z 2018-06-13T20:17:41Z 2018-06-13T20:17:41Z 2018-06-13T20:17:41Z |
| dc.format.none.fl_str_mv | application/pdf application/pdf |
| dc.identifier.none.fl_str_mv | http://ridda2.utp.ac.pa/handle/123456789/4916 http://ridda2.utp.ac.pa/handle/123456789/4916 |
| dc.language.none.fl_str_mv | eng eng |
| dc.rights.none.fl_str_mv | https://creativecommons.org/licenses/by-nc-sa/4.0/ info:eu-repo/semantics/openAccess |
| dc.source.none.fl_str_mv | reponame:Repositorio Institucional de documento digitales de acceso abierto de la UTP instname:Universidad Tecnológica de Panamá instacron:U Tecnológica de Panamá |
| dc.subject.none.fl_str_mv | ETL UML activity diagrams modelling processes ETL UML activity diagrams modelling processes |
| dc.title.none.fl_str_mv | Modelling ETL processes of data warehouses with UML activity diagrams |
| dc.type.none.fl_str_mv | info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
| description | Extraction-transformation-loading (ETL) processes play an important role in a data warehouse (DW) architecture because they are responsible of integrating data from heterogeneous data sources into the DW repository. Importantly, most of the budget of a DW project is spent on designing these processes since they are not taken into account in the early phases of the project but once the repository is deployed. In order to overcome this situation, we propose using the unified modelling language (UML) to conceptually model the sequence of activities involved in ETL processes from the beginning of the project by using activity diagrams (ADs). Our approach provides designers with easy-to-use modelling elements to capture the dynamic aspects of ETL processes. |
| eu_rights_str_mv | openAccess |
| format | article |
| id | lrtest_b4900524bc9753ef3cdb32b0ded979d0 |
| instacron_str | U Tecnológica de Panamá |
| institution | U Tecnológica de Panamá |
| instname_str | Universidad Tecnológica de Panamá |
| language | eng |
| network_acronym_str | lrtest |
| network_name_str | lr |
| oai_identifier_str | oai:ridda2.utp.ac.pa:123456789/4916 |
| publishDate | 2018 |
| publishDateSort | 2018 |
| reponame_str | Repositorio Institucional de documento digitales de acceso abierto de la UTP |
| repository.mail.fl_str_mv | |
| repository.name.fl_str_mv | |
| repository_id_str | |
| rights_invalid_str_mv | https://creativecommons.org/licenses/by-nc-sa/4.0/ |
| spelling | Modelling ETL processes of data warehouses with UML activity diagramsMuñoz, LiliaMazón, Jose NorbertoPardillo, JesúsTrujillo, JuanETLUMLactivity diagramsmodelling processesETLUMLactivity diagramsmodelling processesExtraction-transformation-loading (ETL) processes play an important role in a data warehouse (DW) architecture because they are responsible of integrating data from heterogeneous data sources into the DW repository. Importantly, most of the budget of a DW project is spent on designing these processes since they are not taken into account in the early phases of the project but once the repository is deployed. In order to overcome this situation, we propose using the unified modelling language (UML) to conceptually model the sequence of activities involved in ETL processes from the beginning of the project by using activity diagrams (ADs). Our approach provides designers with easy-to-use modelling elements to capture the dynamic aspects of ETL processes.Extraction-transformation-loading (ETL) processes play an important role in a data warehouse (DW) architecture because they are responsible of integrating data from heterogeneous data sources into the DW repository. Importantly, most of the budget of a DW project is spent on designing these processes since they are not taken into account in the early phases of the project but once the repository is deployed. In order to overcome this situation, we propose using the unified modelling language (UML) to conceptually model the sequence of activities involved in ETL processes from the beginning of the project by using activity diagrams (ADs). Our approach provides designers with easy-to-use modelling elements to capture the dynamic aspects of ETL processes.2018-06-13T20:17:41Z2018-06-13T20:17:41Z2018-06-13T20:17:41Z2018-06-13T20:17:41Z11/09/200811/09/2008info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfapplication/pdfhttp://ridda2.utp.ac.pa/handle/123456789/4916http://ridda2.utp.ac.pa/handle/123456789/4916engenghttps://creativecommons.org/licenses/by-nc-sa/4.0/info:eu-repo/semantics/openAccessreponame:Repositorio Institucional de documento digitales de acceso abierto de la UTPinstname:Universidad Tecnológica de Panamáinstacron:U Tecnológica de Panamáoai:ridda2.utp.ac.pa:123456789/49162021-07-06T15:35:09Z |
| spellingShingle | Modelling ETL processes of data warehouses with UML activity diagrams Muñoz, Lilia ETL UML activity diagrams modelling processes ETL UML activity diagrams modelling processes |
| status_str | publishedVersion |
| title | Modelling ETL processes of data warehouses with UML activity diagrams |
| title_full | Modelling ETL processes of data warehouses with UML activity diagrams |
| title_fullStr | Modelling ETL processes of data warehouses with UML activity diagrams |
| title_full_unstemmed | Modelling ETL processes of data warehouses with UML activity diagrams |
| title_short | Modelling ETL processes of data warehouses with UML activity diagrams |
| title_sort | Modelling ETL processes of data warehouses with UML activity diagrams |
| topic | ETL UML activity diagrams modelling processes ETL UML activity diagrams modelling processes |
| url | http://ridda2.utp.ac.pa/handle/123456789/4916 |