Automatic generation of ETL processes from conceptual models
Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (co...
Gorde:
| Egile nagusia: | |
|---|---|
| Beste egile batzuk: | , |
| Formatua: | article |
| Hizkuntza: | ingelesa |
| Argitaratua: |
2018
|
| Gaiak: | |
| Sarrera elektronikoa: | https://dl.acm.org/citation.cfm?id=1651298 http://ridda2.utp.ac.pa/handle/123456789/4915 |
| Etiketak: |
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
|
| _version_ | 1869652475586281472 |
|---|---|
| author | Muñoz, Lilia |
| author2 | Trujillo, Juan Mazón, Jose Norberto |
| author2_role | author author |
| author_browse | Mazón, Jose Norberto Muñoz, Lilia Trujillo, Juan |
| author_facet | Muñoz, Lilia Trujillo, Juan Mazón, Jose Norberto |
| author_role | author |
| collection | Repositorio Institucional de documento digitales de acceso abierto de la UTP |
| dc.creator.none.fl_str_mv | Muñoz, Lilia Trujillo, Juan Mazón, Jose Norberto |
| dc.date.none.fl_str_mv | 11/06/2009 11/06/2009 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z 2018-06-13T20:09:20Z |
| dc.format.none.fl_str_mv | application/pdf text/html |
| dc.identifier.none.fl_str_mv | https://dl.acm.org/citation.cfm?id=1651298 http://ridda2.utp.ac.pa/handle/123456789/4915 http://ridda2.utp.ac.pa/handle/123456789/4915 |
| dc.language.none.fl_str_mv | 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 | Automatic ETL processes conceptual models Automatic ETL processes conceptual models |
| dc.title.none.fl_str_mv | Automatic generation of ETL processes from conceptual models |
| dc.type.none.fl_str_mv | info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
| description | Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations. |
| eu_rights_str_mv | embargoedAccess |
| format | article |
| id | lrtest_d2961cabe7550865602cc85dc38bfddf |
| 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/4915 |
| 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 | Automatic generation of ETL processes from conceptual modelsMuñoz, LiliaTrujillo, JuanMazón, Jose NorbertoAutomaticETL processesconceptual modelsAutomaticETL processesconceptual modelsData warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations.Data warehouses (DW) integrate different data sources in order to give a multidimensional view of them to the decision-maker. To this aim, the ETL (Extraction, Transformation and Load) processes are responsible for extracting data from heterogeneous operational data sources, their transformation (conversion, cleaning, standardization, etc.), and its load in the DW. In recent years, several conceptual modeling approaches have been proposed for designing ETL processes. Although these approaches are very useful for documenting ETL processes and supporting the designer tasks, these proposals fail to give mechanisms to carry out an automatic code generation stage. Such a stage should be required to both avoid fails and save development time in the implementation of complex ETL process. Therefore, in this paper we define an approach for the automatic code generation of ETL processes. To this aim, we align the modeling of ETL processes in DW with MDA (Model Driven Architecture) by formally defining a set of QVT (Query, View, Transformation) transformations.2018-06-13T20:09:20Z2018-06-13T20:09:20Z2018-06-13T20:09:20Z2018-06-13T20:09:20Z11/06/200911/06/2009info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdftext/htmlhttps://dl.acm.org/citation.cfm?id=1651298http://ridda2.utp.ac.pa/handle/123456789/4915http://ridda2.utp.ac.pa/handle/123456789/4915enginfo: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/49152021-07-06T15:35:08Z |
| spellingShingle | Automatic generation of ETL processes from conceptual models Muñoz, Lilia Automatic ETL processes conceptual models Automatic ETL processes conceptual models |
| status_str | publishedVersion |
| title | Automatic generation of ETL processes from conceptual models |
| title_full | Automatic generation of ETL processes from conceptual models |
| title_fullStr | Automatic generation of ETL processes from conceptual models |
| title_full_unstemmed | Automatic generation of ETL processes from conceptual models |
| title_short | Automatic generation of ETL processes from conceptual models |
| title_sort | Automatic generation of ETL processes from conceptual models |
| topic | Automatic ETL processes conceptual models Automatic ETL processes conceptual models |
| url | https://dl.acm.org/citation.cfm?id=1651298 http://ridda2.utp.ac.pa/handle/123456789/4915 |