{"id":"https://openalex.org/W4386201031","doi":"https://doi.org/10.1111/exsy.13442","title":"Overcoming traditional ETL systems architectural problems using a service\u2010oriented approach","display_name":"Overcoming traditional ETL systems architectural problems using a service\u2010oriented approach","publication_year":2023,"publication_date":"2023-08-27","ids":{"openalex":"https://openalex.org/W4386201031","doi":"https://doi.org/10.1111/exsy.13442"},"language":"en","primary_location":{"id":"doi:10.1111/exsy.13442","doi":"https://doi.org/10.1111/exsy.13442","is_oa":false,"landing_page_url":"https://doi.org/10.1111/exsy.13442","pdf_url":null,"source":{"id":"https://openalex.org/S72232612","display_name":"Expert Systems","issn_l":"0266-4720","issn":["0266-4720","1468-0394"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-c","fnege-4","jufo-1","norway-1","poland-70","russia-white-list-1"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Expert Systems","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://repositorium.uminho.pt/items/1b1d66c8-26e9-46e9-a530-5f2aac27b985/request-a-copy?bitstream=67d0065f-c3d8-4136-bd76-5468d10375e3","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","observed_orcids":["https://orcid.org/0000-0001-9138-9143"]},"institutions":[{"id":"https://openalex.org/I4405256117","display_name":"Centro de Inova\u00e7\u00e3o e Investiga\u00e7\u00e3o em Ci\u00eancias Empresariais e Sistemas de Informa\u00e7\u00e3o","ror":"https://ror.org/03sg03b15","country_code":"PT","type":"facility","lineage":["https://openalex.org/I4405256117","https://openalex.org/I4405262866","https://openalex.org/I83863532"]},{"id":"https://openalex.org/I83863532","display_name":"Universidade T\u00e9cnica do 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, Portugal"],"raw_orcid":"https://orcid.org/0000-0001-9138-9143","affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras, Portugal","institution_ids":["https://openalex.org/I4405256117","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","observed_orcids":["https://orcid.org/0000-0003-3807-7292"]},"institutions":[{"id":"https://openalex.org/I4405256117","display_name":"Centro de Inova\u00e7\u00e3o e Investiga\u00e7\u00e3o em Ci\u00eancias Empresariais e Sistemas de Informa\u00e7\u00e3o","ror":"https://ror.org/03sg03b15","country_code":"PT","type":"facility","lineage":["https://openalex.org/I4405256117","https://openalex.org/I4405262866","https://openalex.org/I83863532"]},{"id":"https://openalex.org/I83863532","display_name":"Universidade T\u00e9cnica do 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, Portugal"],"raw_orcid":"https://orcid.org/0000-0003-3807-7292","affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Felgueiras, Portugal","institution_ids":["https://openalex.org/I4405256117","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","observed_orcids":["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/LASI University of Minho, Campus de Gualtar Braga Portugal"],"raw_orcid":"https://orcid.org/0000-0003-2157-8891","affiliations":[{"raw_affiliation_string":"ALGORITMI R&D Centre/LASI University of Minho, Campus de Gualtar Braga Portugal","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5089487986"],"corresponding_institution_ids":["https://openalex.org/I4405256117","https://openalex.org/I83863532"],"apc_list":{"value":3860,"currency":"USD","value_usd":3860},"apc_paid":null,"fwci":0.5455,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.68557665,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":"40","issue":"10","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.8496000170707703,"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"}},"topics":[{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.8496000170707703,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.12409999966621399,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.002899999963119626,"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/service-oriented-architecture","display_name":"service-oriented architecture","score":0.8790000081062317},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.7179999947547913},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.7120000123977661},{"id":"https://openalex.org/keywords/data-loading","display_name":"data loading","score":0.4020000100135803},{"id":"https://openalex.org/keywords/analytical-systems","display_name":"analytical systems","score":0.6029999852180481},{"id":"https://openalex.org/keywords/data-quality","display_name":"data quality","score":0.4779999852180481},{"id":"https://openalex.org/keywords/data-heterogeneity","display_name":"data heterogeneity","score":0.4359999895095825}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.841688871383667},{"id":"https://openalex.org/C2775945657","wikidata":"https://www.wikidata.org/wiki/Q381442","display_name":"Structuring","level":2,"score":0.6052078604698181},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.5357526540756226},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.47524285316467285},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4310015141963959},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.42698973417282104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40972813963890076},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3705750107765198},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"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/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1111/exsy.13442","doi":"https://doi.org/10.1111/exsy.13442","is_oa":false,"landing_page_url":"https://doi.org/10.1111/exsy.13442","pdf_url":null,"source":{"id":"https://openalex.org/S72232612","display_name":"Expert Systems","issn_l":"0266-4720","issn":["0266-4720","1468-0394"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","ccf-c","cwts-core","dongbi-c","fnege-4","jufo-1","norway-1","poland-70","russia-white-list-1"],"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Expert Systems","raw_type":"journal-article"},{"id":"doi:10.22541/au.167303798.86222074/v1","doi":"https://doi.org/10.22541/au.167303798.86222074/v1","is_oa":false,"landing_page_url":"https://doi.org/10.22541/au.167303798.86222074/v1","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"posted-content"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/90747","doi":null,"is_oa":false,"landing_page_url":"https://hdl.handle.net/1822/90747","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,"listed_in":[],"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":"","raw_type":"journal article"},{"id":"pmh:oai:repositorium.uminho.pt:1822/90747","doi":null,"is_oa":true,"landing_page_url":"https://repositorium.uminho.pt/items/1b1d66c8-26e9-46e9-a530-5f2aac27b985/request-a-copy?bitstream=67d0065f-c3d8-4136-bd76-5468d10375e3","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,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":null,"raw_type":"journal article"}],"best_oa_location":{"id":"pmh:oai:repositorium.uminho.pt:1822/90747","doi":null,"is_oa":true,"landing_page_url":"https://repositorium.uminho.pt/items/1b1d66c8-26e9-46e9-a530-5f2aac27b985/request-a-copy?bitstream=67d0065f-c3d8-4136-bd76-5468d10375e3","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,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":null,"raw_type":"journal article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W87292567","https://openalex.org/W1517818194","https://openalex.org/W1534626598","https://openalex.org/W1918839972","https://openalex.org/W2022521972","https://openalex.org/W2033828303","https://openalex.org/W2044102377","https://openalex.org/W2045926295","https://openalex.org/W2075518254","https://openalex.org/W2101185366","https://openalex.org/W2112789607","https://openalex.org/W2296255490","https://openalex.org/W2335968944","https://openalex.org/W2460071091","https://openalex.org/W2513592835","https://openalex.org/W2518430286","https://openalex.org/W2609547559","https://openalex.org/W2750514106","https://openalex.org/W2752054654","https://openalex.org/W2792777652","https://openalex.org/W2794512073","https://openalex.org/W2811104093","https://openalex.org/W2884882006","https://openalex.org/W2893989659","https://openalex.org/W2914605960","https://openalex.org/W2962328801","https://openalex.org/W2974106837","https://openalex.org/W2988443674","https://openalex.org/W3033783962","https://openalex.org/W3093531719","https://openalex.org/W3113577161","https://openalex.org/W3146147323","https://openalex.org/W3178832859","https://openalex.org/W4236251675"],"related_works":["https://openalex.org/W4297811501","https://openalex.org/W7200559756","https://openalex.org/W4415160475","https://openalex.org/W2022521972","https://openalex.org/W2947084576","https://openalex.org/W6930529981","https://openalex.org/W7126622557","https://openalex.org/W167271714","https://openalex.org/W7084214459","https://openalex.org/W2045926295"],"abstract_inverted_index":{"Abstract":[0],"Developing":[1],"analytical":[2,43,60,71],"systems":[3,80,162],"imposes":[4],"several":[5],"challenges":[6,76],"related":[7],"not":[8],"only":[9],"to":[10,21,25,29,147,160],"the":[11,16,22,40,138,149],"amount":[12],"and":[13,27,44,51,57,69,82,87,94,96,106,112,130,134,151],"heterogeneity":[14],"of":[15,42,100,137,156],"involved":[17],"data":[18,89],"but":[19],"also":[20],"constant":[23],"need":[24],"readapt":[26],"evolve":[28],"overcome":[30],"new":[31],"business":[32],"challenges.":[33],"Data":[34],"are":[35,64],"a":[36,124,144],"determinant":[37],"factor":[38],"in":[39,143],"success":[41],"decision\u2010making":[45],"applications,":[46,72],"being":[47],"its":[48],"nature,":[49],"availability,":[50],"quality,":[52],"crucial":[53],"aspects":[54],"for":[55,84,127],"planning":[56],"structuring":[58],"populating":[59,90],"systems.":[61],"Today's":[62],"users":[63],"more":[65],"demanding,":[66],"requiring":[67],"adaptable":[68],"flexible":[70,86],"which":[73],"impose":[74],"serious":[75],"on":[77],"extract\u2010transform\u2010load":[78],"(ETL)":[79],"design":[81,105,129],"development":[83],"ensuring":[85],"robust":[88],"services,":[91],"operating":[92],"24/7,":[93],"managing":[95],"processing":[97],"large":[98],"volumes":[99],"data.":[101],"Thus,":[102],"we":[103,122],"should":[104],"implement":[107],"ETL":[108,128,141,161],"processes":[109,142],"using":[110],"innovative":[111],"up\u2010to\u2010date":[113],"approaches,":[114],"having":[115],"real":[116],"application":[117,150],"evidence.":[118],"In":[119],"this":[120,154],"paper,":[121],"present":[123],"service\u2010oriented":[125,145],"implementation":[126],"development.":[131,164],"We":[132],"mapped":[133],"implemented":[135],"some":[136],"most":[139],"conventional":[140],"architecture,":[146],"demonstrate":[148],"benefits":[152],"that":[153],"kind":[155],"approach":[157],"will":[158],"provide":[159],"project":[163]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2023-08-28T00:00:00"}