ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study
BACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropri...
Furkejuvvon:
| Váldodahkki: | |
|---|---|
| Eará dahkkit: | , |
| Materiálatiipa: | article |
| Giella: | eaŋgalasgiella |
| Almmustuhtton: |
2018
|
| Fáttát: | |
| Liŋkkat: | https://ieeexplore.ieee.org/abstract/document/5893784/ http://ridda2.utp.ac.pa/handle/123456789/4918 |
| Fáddágilkorat: |
Eai fáddágilkorat, Lasit vuosttaš fáddágilkora!
|
| _version_ | 1869652461572063232 |
|---|---|
| author | Muñoz, Lilia |
| author2 | Mazón, Jose Norberto Juan, Trujillo |
| author2_role | author author |
| author_browse | Juan, Trujillo Mazón, Jose Norberto Muñoz, Lilia |
| author_facet | Muñoz, Lilia Mazón, Jose Norberto Juan, Trujillo |
| 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 Juan, Trujillo |
| dc.date.none.fl_str_mv | 06/16/2011 06/16/2011 2018-06-14T13:37:43Z 2018-06-14T13:37:43Z 2018-06-14T13:37:43Z 2018-06-14T13:37:43Z |
| dc.format.none.fl_str_mv | application/pdf text/html |
| dc.identifier.none.fl_str_mv | https://ieeexplore.ieee.org/abstract/document/5893784/ 1548-0992 http://ridda2.utp.ac.pa/handle/123456789/4918 http://ridda2.utp.ac.pa/handle/123456789/4918 |
| dc.language.none.fl_str_mv | eng eng |
| dc.rights.none.fl_str_mv | info:eu-repo/semantics/embargoedAccess |
| 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 | Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining |
| dc.title.none.fl_str_mv | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| dc.type.none.fl_str_mv | info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
| description | BACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropriate design of the ETL processes are key factors in the success of DW projects. OBJECTIVE: We assess existing research proposals about ETL process modeling for data warehouse in order to identify their main characteristics, notation, and activities. We also study if these modeling approaches are supported by some kind of prototype or tool. METHOD: We have undertaken a systematic mapping study of the research literature about modeling ETL processes. A mapping study provides a systematic and objective procedure for identifying the nature and extent of the available research by means of research questions. RESULTS: The study is based on a comprehensive set of papers obtained after using a multi-stage selection criteria and are published in international workshops, conferences and journals between 2000 and 2009. CONCLUSIONS: This systematic mapping study states that there is a clear classification of ETL process modeling approaches, but that they are not enough covered by researchers. Therefore, more effort is required to bridge the research gap in modeling ETL processes. |
| eu_rights_str_mv | embargoedAccess |
| format | article |
| id | lrtest_4475ffdebbb7825af9fbe8e21b42856a |
| identifier_str_mv | 1548-0992 |
| 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/4918 |
| 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 | |
| spelling | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping StudyMuñoz, LiliaMazón, Jose NorbertoJuan, TrujilloUnified modeling languageData modelsData warehousesLoad modelingSystematicsLibrariesData miningUnified modeling languageData modelsData warehousesLoad modelingSystematicsLibrariesData miningBACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropriate design of the ETL processes are key factors in the success of DW projects. OBJECTIVE: We assess existing research proposals about ETL process modeling for data warehouse in order to identify their main characteristics, notation, and activities. We also study if these modeling approaches are supported by some kind of prototype or tool. METHOD: We have undertaken a systematic mapping study of the research literature about modeling ETL processes. A mapping study provides a systematic and objective procedure for identifying the nature and extent of the available research by means of research questions. RESULTS: The study is based on a comprehensive set of papers obtained after using a multi-stage selection criteria and are published in international workshops, conferences and journals between 2000 and 2009. CONCLUSIONS: This systematic mapping study states that there is a clear classification of ETL process modeling approaches, but that they are not enough covered by researchers. Therefore, more effort is required to bridge the research gap in modeling ETL processes.BACKGROUND: A data warehouse (DW) is an integrated collection of subject-oriented data in the support of decision making. Importantly, the integration of data sources is achieved through the use of ETL (Extract, Transform, and Load) processes. It is therefore extensively recognized that the appropriate design of the ETL processes are key factors in the success of DW projects. OBJECTIVE: We assess existing research proposals about ETL process modeling for data warehouse in order to identify their main characteristics, notation, and activities. We also study if these modeling approaches are supported by some kind of prototype or tool. METHOD: We have undertaken a systematic mapping study of the research literature about modeling ETL processes. A mapping study provides a systematic and objective procedure for identifying the nature and extent of the available research by means of research questions. RESULTS: The study is based on a comprehensive set of papers obtained after using a multi-stage selection criteria and are published in international workshops, conferences and journals between 2000 and 2009. CONCLUSIONS: This systematic mapping study states that there is a clear classification of ETL process modeling approaches, but that they are not enough covered by researchers. Therefore, more effort is required to bridge the research gap in modeling ETL processes.2018-06-14T13:37:43Z2018-06-14T13:37:43Z2018-06-14T13:37:43Z2018-06-14T13:37:43Z06/16/201106/16/2011info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdftext/htmlhttps://ieeexplore.ieee.org/abstract/document/5893784/1548-0992http://ridda2.utp.ac.pa/handle/123456789/4918http://ridda2.utp.ac.pa/handle/123456789/4918engenginfo:eu-repo/semantics/embargoedAccessreponame: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/49182021-07-06T15:35:09Z |
| spellingShingle | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study Muñoz, Lilia Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining |
| status_str | publishedVersion |
| title | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| title_full | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| title_fullStr | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| title_full_unstemmed | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| title_short | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| title_sort | ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study |
| topic | Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining Unified modeling language Data models Data warehouses Load modeling Systematics Libraries Data mining |
| url | https://ieeexplore.ieee.org/abstract/document/5893784/ http://ridda2.utp.ac.pa/handle/123456789/4918 |