{"id":"https://openalex.org/W3184508954","doi":"https://doi.org/10.5220/0010575702670274","title":"Using BPMN for ETL Conceptual Modelling: A Case Study","display_name":"Using BPMN for ETL Conceptual Modelling: A Case Study","publication_year":2021,"publication_date":"2021-01-01","ids":{"openalex":"https://openalex.org/W3184508954","doi":"https://doi.org/10.5220/0010575702670274","mag":"3184508954"},"language":"en","primary_location":{"id":"doi:10.5220/0010575702670274","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0010575702670274","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 10th International Conference on Data Science, Technology and Applications","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.5220/0010575702670274","any_repository_has_fulltext":null},"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":false,"raw_author_name":"Bruno Oliveira","raw_affiliation_strings":["CIICESI, School of Management and Technology, Porto Polytechnic, Rua do Curral, Felgueiras, Portugal, --- Select a Country ---"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Rua do Curral, Felgueiras, 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, Rua do Curral, Felgueiras, Portugal, --- Select a Country ---"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"CIICESI, School of Management and Technology, Porto Polytechnic, Rua do Curral, Felgueiras, 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, Braga, Portugal, --- Select a Country ---"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ALGORITMI R&D Centre, University of Minho, Braga, Portugal, --- Select a Country ---","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2799,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.6357051,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"267","last_page":"274"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.8501999974250793,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.8501999974250793,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T10703","display_name":"Business Process Modeling and Analysis","score":0.8206999897956848,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.7394000291824341,"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/business-process-model-and-notation","display_name":"Business Process Model and Notation","score":0.7065981030464172},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6652054190635681},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.44963547587394714},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35758307576179504},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3402456045150757},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.23676568269729614},{"id":"https://openalex.org/keywords/business-process-modeling","display_name":"Business process modeling","score":0.20730167627334595},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.09045451879501343},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.08039182424545288},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.054156094789505005}],"concepts":[{"id":"https://openalex.org/C179299601","wikidata":"https://www.wikidata.org/wiki/Q1017605","display_name":"Business Process Model and Notation","level":5,"score":0.7065981030464172},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6652054190635681},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.44963547587394714},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35758307576179504},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3402456045150757},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.23676568269729614},{"id":"https://openalex.org/C207505557","wikidata":"https://www.wikidata.org/wiki/Q4374012","display_name":"Business process modeling","level":4,"score":0.20730167627334595},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.09045451879501343},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.08039182424545288},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.054156094789505005}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5220/0010575702670274","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0010575702670274","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 10th International Conference on Data Science, Technology and Applications","raw_type":"proceedings-article"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/90741","is_oa":false,"landing_page_url":"https://hdl.handle.net/1822/90741","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"}],"best_oa_location":{"id":"doi:10.5220/0010575702670274","is_oa":true,"landing_page_url":"https://doi.org/10.5220/0010575702670274","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 10th International Conference on Data Science, Technology and Applications","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2030287586","https://openalex.org/W2784577564","https://openalex.org/W4256122958","https://openalex.org/W3203818570","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W3148255942","https://openalex.org/W2127171476"],"abstract_inverted_index":{"One":[0],"of":[1,6,35,46,64,90,147,160],"the":[2,12,33,47,62,65,70,84,88,105,137,145],"most":[3,45],"important":[4],"parts":[5],"a":[7,52,57,101,158,167],"Data":[8,53,92],"Warehousing":[9,54],"System":[10],"is":[11,17,41,74],"Extract-Transform-Load":[13],"(ETL)":[14],"component.":[15],"It":[16],"responsible":[18,42],"for":[19,26,43,50,135,149,162],"extracting,":[20],"transforming,":[21],"conciliating,":[22],"and":[23,93,113,119,156],"loading":[24],"data":[25],"supporting":[27],"decision-making":[28],"requirements.":[29,139],"Usually,":[30],"due":[31],"to":[32,121],"complexity":[34],"managing":[36],"heterogeneous":[37],"data,":[38],"this":[39,141,164],"component":[40,59],"consuming":[44],"resources":[48],"required":[49],"implementing":[51],"System,":[55],"representing":[56,136],"critical":[58],"that":[60],"compromises":[61],"adequacy":[63],"system.":[66],"Despite":[67],"their":[68],"importance,":[69],"ETL":[71,97,123,150],"development":[72],"method":[73],"essentially":[75],"ad-hoc,":[76],"which":[77],"does":[78],"not":[79],"always":[80],"follow":[81],"or":[82],"embodies":[83],"best":[85],"practices.":[86],"With":[87],"emergence":[89],"Big":[91],"associated":[94],"tools,":[95],"script-based":[96],"became,":[98],"even":[99],"more,":[100],"common":[102],"approach.":[103],"In":[104,140],"last":[106],"years,":[107],"BPMN":[108,148],"-":[109,115],"Business":[110],"Process":[111],"Model":[112],"Notation":[114],"have":[116],"been":[117],"proposed":[118],"used":[120],"support":[122],"conceptual":[124,151],"models.":[125],"Still,":[126],"as":[127],"an":[128],"expressive":[129],"language,":[130],"it":[131],"provides":[132],"different":[133],"approaches":[134],"same":[138],"paper,":[142],"we":[143],"explore":[144],"use":[146],"modelling,":[152],"analyzing":[153],"existing":[154],"approaches,":[155],"proposing":[157],"set":[159],"guidelines":[161],"using":[163],"notation":[165],"in":[166],"more":[168],"consistent":[169],"way.":[170]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}