{"id":"https://openalex.org/W2947084576","doi":"https://doi.org/10.5220/0007727502160222","title":"ETL Development using Patterns: A Service-Oriented Approach","display_name":"ETL Development using Patterns: A Service-Oriented Approach","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2947084576","doi":"https://doi.org/10.5220/0007727502160222","mag":"2947084576"},"language":"en","primary_location":{"id":"doi:10.5220/0007727502160222","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0007727502160222","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.5220/0007727502160222","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5089487986","display_name":"Bruno Oliveira","orcid":"https://orcid.org/0000-0001-9138-9143"},"institutions":[{"id":"https://openalex.org/I83863532","display_name":"Polytechnic Institute of Porto","ror":"https://ror.org/04988re48","country_code":"PT","type":"education","lineage":["https://openalex.org/I83863532"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Bruno Oliveira","raw_affiliation_strings":["CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---","institution_ids":["https://openalex.org/I83863532"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045689248","display_name":"\u00d3scar Oliveira","orcid":"https://orcid.org/0000-0003-3807-7292"},"institutions":[{"id":"https://openalex.org/I83863532","display_name":"Polytechnic Institute of Porto","ror":"https://ror.org/04988re48","country_code":"PT","type":"education","lineage":["https://openalex.org/I83863532"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"\u00d3scar Oliveira","raw_affiliation_strings":["CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---","institution_ids":["https://openalex.org/I83863532"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030308784","display_name":"Vasco Santos","orcid":"https://orcid.org/0000-0002-3344-0753"},"institutions":[{"id":"https://openalex.org/I83863532","display_name":"Polytechnic Institute of Porto","ror":"https://ror.org/04988re48","country_code":"PT","type":"education","lineage":["https://openalex.org/I83863532"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Vasco Santos","raw_affiliation_strings":["CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras and Portugal, --- Select a Country ---","institution_ids":["https://openalex.org/I83863532"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061961536","display_name":"Orlando Belo","orcid":"https://orcid.org/0000-0003-2157-8891"},"institutions":[{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Orlando Belo","raw_affiliation_strings":["ALGORITMI R&D Centre, University of Minho, Campus de Gualtar, Braga and Portugal, --- Select a Country ---"],"affiliations":[{"raw_affiliation_string":"ALGORITMI R&D Centre, University of Minho, Campus de Gualtar, Braga and Portugal, --- Select a Country ---","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5089487986"],"corresponding_institution_ids":["https://openalex.org/I83863532"],"apc_list":null,"apc_paid":null,"fwci":0.3714,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.63528129,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"216","last_page":"222"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microservices","display_name":"Microservices","score":0.8942137956619263},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7642651796340942},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.7072868347167969},{"id":"https://openalex.org/keywords/architectural-style","display_name":"Architectural style","score":0.6204264760017395},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.49660974740982056},{"id":"https://openalex.org/keywords/software-design-pattern","display_name":"Software design pattern","score":0.4765810966491699},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4748038351535797},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4301917552947998},{"id":"https://openalex.org/keywords/architectural-pattern","display_name":"Architectural pattern","score":0.41065818071365356},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.26031914353370667},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.21507596969604492},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20169711112976074},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.14804142713546753},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.1368812918663025},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.09542673826217651}],"concepts":[{"id":"https://openalex.org/C2778505942","wikidata":"https://www.wikidata.org/wiki/Q18344624","display_name":"Microservices","level":3,"score":0.8942137956619263},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7642651796340942},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.7072868347167969},{"id":"https://openalex.org/C2777364373","wikidata":"https://www.wikidata.org/wiki/Q32880","display_name":"Architectural style","level":3,"score":0.6204264760017395},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.49660974740982056},{"id":"https://openalex.org/C146054899","wikidata":"https://www.wikidata.org/wiki/Q181156","display_name":"Software design pattern","level":3,"score":0.4765810966491699},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4748038351535797},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4301917552947998},{"id":"https://openalex.org/C72280835","wikidata":"https://www.wikidata.org/wiki/Q635346","display_name":"Architectural pattern","level":5,"score":0.41065818071365356},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.26031914353370667},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.21507596969604492},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20169711112976074},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.14804142713546753},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1368812918663025},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.09542673826217651},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C52913732","wikidata":"https://www.wikidata.org/wiki/Q857102","display_name":"Software design","level":4,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.5220/0007727502160222","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0007727502160222","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/71909","is_oa":true,"landing_page_url":"http://hdl.handle.net/1822/71909","pdf_url":null,"source":{"id":"https://openalex.org/S4306400354","display_name":"Reposit\u00f3riUM (Universidade do Minho)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I99682543","host_organization_name":"University of Minho","host_organization_lineage":["https://openalex.org/I99682543"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"},{"id":"pmh:oai:repositorium.uminho.pt:1822/71909","is_oa":false,"landing_page_url":"https://hdl.handle.net/1822/71909","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference paper"}],"best_oa_location":{"id":"doi:10.5220/0007727502160222","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0007727502160222","pdf_url":null,"source":null,"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 21st International Conference on Enterprise Information Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.4000000059604645}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W3137265620","https://openalex.org/W4382248441","https://openalex.org/W3088227461","https://openalex.org/W2806940133","https://openalex.org/W4378501550","https://openalex.org/W2786131231","https://openalex.org/W3000073308","https://openalex.org/W3114078890","https://openalex.org/W4293242936","https://openalex.org/W2932873945"],"abstract_inverted_index":{"Extract-Transform-Load":[0],"(ETL)":[1],"workflows":[2],"are":[3,44,97],"commonly":[4],"developed":[5],"using":[6,115],"frameworks":[7],"and":[8,37,82],"tools":[9],"that":[10,48],"provide":[11],"a":[12,33],"set":[13],"of":[14,80,109],"useful":[15],"pre-configured":[16],"components":[17,84],"to":[18,35,71],"develop":[19],"complete":[20],"ETL":[21,27,40,55,67,95,112],"packages.":[22],"The":[23,57,78],"pattern":[24,58],"concept":[25],"for":[26,106,111],"development":[28,41,114],"is":[29],"being":[30],"studied":[31],"as":[32],"way":[34,94],"simplify":[36],"improve":[38,92],"the":[39,54,72,87,93,107],"lifecycle.":[42],"Patterns":[43],"independent":[45],"composite":[46],"tasks":[47],"can":[49,91],"be":[50],"changed":[51],"without":[52],"affecting":[53],"structure.":[56],"implementation":[59],"reveals":[60],"several":[61],"challenges":[62],"when":[63],"used":[64],"with":[65],"existing":[66],"tools,":[68],"mainly":[69],"due":[70],"monolith":[73],"architectural":[74,89],"style":[75,90],"usually":[76],"followed.":[77],"use":[79,108],"small":[81],"loosely-coupled":[83],"provided":[85],"by":[86],"microservices":[88,110],"patterns":[96],"used.":[98],"In":[99],"this":[100],"paper,":[101],"we":[102],"present":[103],"an":[104],"analysis":[105],"application":[113],"patterns.":[116]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}