Publicação
ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes
| Resumo: | The implementation of data warehouse populating processes (ETL) is considered a complex task, not only in terms of the amount of data processed but also in the complexity of the tasks involved. The implementation and maintenance of such processes faces various design drawbacks, such as the change of business requirements, which consequently leads to adapting existing data structures and reusing existing parts of ETL system. We consider that a more abstract view of the ETL processes and its data structures is need as well as a more effective mapping to real execution primitives, providing its validation before conducting an ETL solution to its final implementation. With this work we propose the use of standard solutions, which already has proven very useful in software developing, for the implementation of standard ETL processes. In this paper we approach ETL modelling in a new perspective, using YAWL, a Workflow language, as the mean to get ETL models platform-independent. |
|---|---|
| Autores principais: | Oliveira, Bruno |
| Outros Autores: | Belo, O. |
| Assunto: | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| Ano: | 2014 |
| País: | Portugal |
| Tipo de documento: | comunicação em conferência |
| Tipo de acesso: | acesso restrito |
| Instituição associada: | Universidade do Minho |
| Idioma: | inglês |
| Origem: | RepositóriUM - Universidade do Minho |
| _version_ | 1866877302729605120 |
|---|---|
| author | Oliveira, Bruno |
| author2 | Belo, O. |
| author2_role | author |
| author_facet | Oliveira, Bruno Belo, O. |
| author_role | author |
| contributor_name_str_mv | Universidade do Minho |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Oliveira, Bruno\"},{\"Person.name\":\"Belo, O.\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Universidade do Minho |
| datacite.creators.creator.creatorName.fl_str_mv | Oliveira, Bruno Belo, O. |
| datacite.date.Accepted.fl_str_mv | 2014-01-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2015-09-30T15:14:22Z |
| datacite.date.embargoed.fl_str_mv | 2015-09-30T15:14:22Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_16ec |
| datacite.subjects.subject.fl_str_mv | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| datacite.titles.title.fl_str_mv | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| dc.contributor.none.fl_str_mv | Universidade do Minho |
| dc.creator.none.fl_str_mv | Oliveira, Bruno Belo, O. |
| dc.date.Accepted.fl_str_mv | 2014-01-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2015-09-30T15:14:22Z |
| dc.date.embargoed.fl_str_mv | 2015-09-30T15:14:22Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | https://hdl.handle.net/1822/37413 |
| dc.language.none.fl_str_mv | eng |
| dc.publisher.none.fl_str_mv | SCITEPRESS |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_16ec |
| dc.subject.none.fl_str_mv | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| dc.title.fl_str_mv | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_5794 |
| description | The implementation of data warehouse populating processes (ETL) is considered a complex task, not only in terms of the amount of data processed but also in the complexity of the tasks involved. The implementation and maintenance of such processes faces various design drawbacks, such as the change of business requirements, which consequently leads to adapting existing data structures and reusing existing parts of ETL system. We consider that a more abstract view of the ETL processes and its data structures is need as well as a more effective mapping to real execution primitives, providing its validation before conducting an ETL solution to its final implementation. With this work we propose the use of standard solutions, which already has proven very useful in software developing, for the implementation of standard ETL processes. In this paper we approach ETL modelling in a new perspective, using YAWL, a Workflow language, as the mean to get ETL models platform-independent. |
| dirty | 0 |
| eu_rights_str_mv | restrictedAccess |
| format | conferencePaper |
| fulltext.url.fl_str_mv | https://prod-dspace.uminho.pt/bitstreams/8ccb7d0a-792e-4054-8dd7-65b88b406e74/download |
| id | rum_699aa09c1f91ec00e422d1f9febe3588 |
| identifier.url.fl_str_mv | https://hdl.handle.net/1822/37413 |
| instacron_str | repositorium |
| institution | Universidade do Minho |
| instname_str | Universidade do Minho |
| language | eng |
| network_acronym_str | rum |
| network_name_str | RepositóriUM - Universidade do Minho |
| oai_identifier_str | oai:repositorium.uminho.pt:1822/37413 |
| organization_str_mv | urn:organizationAcronym:repositorium |
| person_str_mv | Oliveira, Bruno Belo, O. |
| publishDate | 2014 |
| publisher.none.fl_str_mv | SCITEPRESS |
| reponame_str | RepositóriUM - Universidade do Minho |
| repository_id_str | urn:repositoryAcronym:rum |
| service_str_mv | urn:repositoryAcronym:rum |
| spelling | engSCITEPRESSporThe implementation of data warehouse populating processes (ETL) is considered a complex task, not only in terms of the amount of data processed but also in the complexity of the tasks involved. The implementation and maintenance of such processes faces various design drawbacks, such as the change of business requirements, which consequently leads to adapting existing data structures and reusing existing parts of ETL system. We consider that a more abstract view of the ETL processes and its data structures is need as well as a more effective mapping to real execution primitives, providing its validation before conducting an ETL solution to its final implementation. With this work we propose the use of standard solutions, which already has proven very useful in software developing, for the implementation of standard ETL processes. In this paper we approach ETL modelling in a new perspective, using YAWL, a Workflow language, as the mean to get ETL models platform-independent.application/pdfporETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processesOliveira, BrunoBelo, O.HostingInstitutionOrganizationalUniversidade do Minhoe-mailmailto:repositorium@usdb.uminho.ptrepositorium@usdb.uminho.ptISBNIsPartOf97898975802772015-09-30T15:14:22Z20142014-01-01T00:00:00ZHandlehttps://hdl.handle.net/1822/37413http://purl.org/coar/access_right/c_16ecrestricted accessData Warehousing SystemsETL ModellingETL Validation and TestingETL PatternsYAWLAnd YAWLData warehousing521283 bytesother research producthttp://purl.org/coar/resource_type/c_5794conference paperhttp://purl.org/coar/access_right/c_16ecapplication/pdffulltexthttps://prod-dspace.uminho.pt/bitstreams/8ccb7d0a-792e-4054-8dd7-65b88b406e74/download |
| spellingShingle | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes Oliveira, Bruno Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| status | SINGLETON |
| subject.fl_str_mv | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| title | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| title_full | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| title_fullStr | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| title_full_unstemmed | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| title_short | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| title_sort | ETL patterns on YAWL: towards to the specification of platform-independent data warehousing populating processes |
| topic | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| topic_facet | Data Warehousing Systems ETL Modelling ETL Validation and Testing ETL Patterns YAWL And YAWL Data warehousing |
| url | https://hdl.handle.net/1822/37413 |
| visible | 1 |