{"id":"https://openalex.org/W2127912974","doi":"https://doi.org/10.4018/jdwm.2013070103","title":"A BPMN-Based Design and Maintenance Framework for ETL Processes","display_name":"A BPMN-Based Design and Maintenance Framework for ETL Processes","publication_year":2013,"publication_date":"2013-07-01","ids":{"openalex":"https://openalex.org/W2127912974","doi":"https://doi.org/10.4018/jdwm.2013070103","mag":"2127912974"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2013070103","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdwm.2013070103","pdf_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=78375&isxn=9781466634558","source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=78375&isxn=9781466634558","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068421459","display_name":"Zineb El Akkaoui","orcid":"https://orcid.org/0009-0001-9116-8081"},"institutions":[{"id":"https://openalex.org/I132053463","display_name":"Universit\u00e9 Libre de Bruxelles","ror":"https://ror.org/01r9htc13","country_code":"BE","type":"education","lineage":["https://openalex.org/I132053463"]}],"countries":["BE"],"is_corresponding":true,"raw_author_name":"Zineb El Akkaoui","raw_affiliation_strings":["Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"],"affiliations":[{"raw_affiliation_string":"Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium","institution_ids":["https://openalex.org/I132053463"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050401502","display_name":"Esteban Zim\u00e1nyi","orcid":"https://orcid.org/0000-0003-1843-5099"},"institutions":[{"id":"https://openalex.org/I132053463","display_name":"Universit\u00e9 Libre de Bruxelles","ror":"https://ror.org/01r9htc13","country_code":"BE","type":"education","lineage":["https://openalex.org/I132053463"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Esteban Zim\u00e1nyi","raw_affiliation_strings":["Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"],"affiliations":[{"raw_affiliation_string":"Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium","institution_ids":["https://openalex.org/I132053463"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015502433","display_name":"Jos\u00e9-Norberto Maz\u00f3n","orcid":"https://orcid.org/0000-0001-7924-0880"},"institutions":[{"id":"https://openalex.org/I130194489","display_name":"University of Alicante","ror":"https://ror.org/05t8bcz72","country_code":"ES","type":"education","lineage":["https://openalex.org/I130194489"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Jose-Norberto Maz\u00f3n","raw_affiliation_strings":["Department of Software and Computing Systems, University of Alicante, Alicante, Spain"],"affiliations":[{"raw_affiliation_string":"Department of Software and Computing Systems, University of Alicante, Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087667090","display_name":"Juan Trujillo","orcid":"https://orcid.org/0000-0003-0139-6724"},"institutions":[{"id":"https://openalex.org/I130194489","display_name":"University of Alicante","ror":"https://ror.org/05t8bcz72","country_code":"ES","type":"education","lineage":["https://openalex.org/I130194489"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Juan Trujillo","raw_affiliation_strings":["Department of Software and Computing Systems, University of Alicante, Alicante, Spain"],"affiliations":[{"raw_affiliation_string":"Department of Software and Computing Systems, University of Alicante, Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5068421459"],"corresponding_institution_ids":["https://openalex.org/I132053463"],"apc_list":null,"apc_paid":null,"fwci":11.5781,"has_fulltext":true,"cited_by_count":46,"citation_normalized_percentile":{"value":0.98630916,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"9","issue":"3","first_page":"46","last_page":"72"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9994000196456909,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9975000023841858,"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/computer-science","display_name":"Computer science","score":0.8693819046020508},{"id":"https://openalex.org/keywords/executable","display_name":"Executable","score":0.7160030007362366},{"id":"https://openalex.org/keywords/code-generation","display_name":"Code generation","score":0.5733410716056824},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.5476308465003967},{"id":"https://openalex.org/keywords/business-process-model-and-notation","display_name":"Business Process Model and Notation","score":0.5202159285545349},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.43472820520401},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.4316197633743286},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42961210012435913},{"id":"https://openalex.org/keywords/modeling-language","display_name":"Modeling language","score":0.4210333228111267},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.3928389549255371},{"id":"https://openalex.org/keywords/business-process","display_name":"Business process","score":0.32329249382019043},{"id":"https://openalex.org/keywords/business-process-modeling","display_name":"Business process modeling","score":0.2598164677619934},{"id":"https://openalex.org/keywords/work-in-process","display_name":"Work in process","score":0.1750253438949585},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1397346556186676},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.11602810025215149}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8693819046020508},{"id":"https://openalex.org/C160145156","wikidata":"https://www.wikidata.org/wiki/Q778586","display_name":"Executable","level":2,"score":0.7160030007362366},{"id":"https://openalex.org/C133162039","wikidata":"https://www.wikidata.org/wiki/Q1061077","display_name":"Code generation","level":3,"score":0.5733410716056824},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5476308465003967},{"id":"https://openalex.org/C179299601","wikidata":"https://www.wikidata.org/wiki/Q1017605","display_name":"Business Process Model and Notation","level":5,"score":0.5202159285545349},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.43472820520401},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4316197633743286},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42961210012435913},{"id":"https://openalex.org/C179603123","wikidata":"https://www.wikidata.org/wiki/Q1941921","display_name":"Modeling language","level":3,"score":0.4210333228111267},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.3928389549255371},{"id":"https://openalex.org/C85345410","wikidata":"https://www.wikidata.org/wiki/Q851587","display_name":"Business process","level":3,"score":0.32329249382019043},{"id":"https://openalex.org/C207505557","wikidata":"https://www.wikidata.org/wiki/Q4374012","display_name":"Business process modeling","level":4,"score":0.2598164677619934},{"id":"https://openalex.org/C174998907","wikidata":"https://www.wikidata.org/wiki/Q357662","display_name":"Work in process","level":2,"score":0.1750253438949585},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1397346556186676},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.11602810025215149},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.4018/jdwm.2013070103","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdwm.2013070103","pdf_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=78375&isxn=9781466634558","source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:9:y:2013:i:3:p:46-72","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2013070103","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"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":"article"},{"id":"pmh:oai:dipot.ulb.ac.be:2013/163739","is_oa":false,"landing_page_url":"http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/163739","pdf_url":null,"source":{"id":"https://openalex.org/S4306401063","display_name":"D\u00e9p\u00f4t institutionnel de l'Universit\u00e9 libre de Bruxelles (Universit\u00e9 Libre de Bruxelles)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I132053463","host_organization_name":"Universit\u00e9 Libre de Bruxelles","host_organization_lineage":["https://openalex.org/I132053463"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"International journal of data warehousing and mining, 9 (3","raw_type":"info:ulb-repo/semantics/openurl/article"},{"id":"pmh:oai:rua.ua.es:10045/40213","is_oa":false,"landing_page_url":"http://hdl.handle.net/10045/40213","pdf_url":null,"source":{"id":"https://openalex.org/S4306400416","display_name":"Repositorio Institucional de la Universidad de Alicante (Universidad de Alicante)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I130194489","host_organization_name":"University of Alicante","host_organization_lineage":["https://openalex.org/I130194489"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.4018/jdwm.2013070103","is_oa":true,"landing_page_url":"https://doi.org/10.4018/jdwm.2013070103","pdf_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=78375&isxn=9781466634558","source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6399999856948853}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2127912974.pdf","grobid_xml":"https://content.openalex.org/works/W2127912974.grobid-xml"},"referenced_works_count":29,"referenced_works":["https://openalex.org/W41964281","https://openalex.org/W84515857","https://openalex.org/W154674883","https://openalex.org/W332208005","https://openalex.org/W1482268585","https://openalex.org/W1534626598","https://openalex.org/W1541535863","https://openalex.org/W1558140929","https://openalex.org/W1564115980","https://openalex.org/W1906169869","https://openalex.org/W1993582687","https://openalex.org/W1996651333","https://openalex.org/W2004281168","https://openalex.org/W2014763157","https://openalex.org/W2016257365","https://openalex.org/W2016432893","https://openalex.org/W2020829916","https://openalex.org/W2039780220","https://openalex.org/W2075518254","https://openalex.org/W2078783226","https://openalex.org/W2097047803","https://openalex.org/W2099223743","https://openalex.org/W2108971776","https://openalex.org/W2120865520","https://openalex.org/W2126395594","https://openalex.org/W2166006219","https://openalex.org/W2404768723","https://openalex.org/W4252729912","https://openalex.org/W6601663426"],"related_works":["https://openalex.org/W2141750083","https://openalex.org/W2911847762","https://openalex.org/W3121251068","https://openalex.org/W2403967028","https://openalex.org/W1778671501","https://openalex.org/W1557587181","https://openalex.org/W2904052985","https://openalex.org/W2036913131","https://openalex.org/W2115097704","https://openalex.org/W2009962318"],"abstract_inverted_index":{"Business":[0],"Intelligence":[1],"(BI)":[2],"applications":[3],"require":[4],"the":[5,45,54,72,80,89,101,104,112,156,160,164,167,189],"design,":[6],"implementation,":[7],"and":[8,15,38,96,124,195],"maintenance":[9,126,165,196],"of":[10,23,82,128,136,162,166],"processes":[11,25,91],"that":[12,34,118,153,188],"extract,":[13],"transform,":[14],"load":[16],"suitable":[17],"data":[18,106,172],"for":[19,52,143],"analysis.":[20],"The":[21],"development":[22,81],"these":[24],"(known":[26],"as":[27,148,150,182],"ETL)":[28],"is":[29,35,180],"an":[30,93,178,183],"inherently":[31],"complex":[32],"problem":[33],"typically":[36],"costly":[37],"time":[39],"consuming.":[40],"In":[41,109],"a":[42,49,115,134],"previous":[43],"work,":[44],"authors":[46,113],"have":[47],"proposed":[48],"vendor-independent":[50],"language":[51],"reducing":[53],"design":[55,65],"complexity":[56],"due":[57],"to":[58,63,87,99,140,171,186],"disparate":[59],"ETL":[60,83,130,145,157],"languages":[61],"tailored":[62],"specific":[64],"tools":[66,147],"with":[67,159],"steep":[68],"learning":[69],"curves.":[70],"Nevertheless,":[71],"designer":[73],"still":[74],"faces":[75],"two":[76],"major":[77],"issues":[78],"during":[79],"processes:":[84],"(i)":[85],"how":[86,98],"implement":[88],"designed":[90],"in":[92,200],"executable":[94],"language,":[95],"(ii)":[97],"maintain":[100],"implementation":[102],"when":[103],"organization":[105],"infrastructure":[107],"evolves.":[108],"this":[110],"paper,":[111],"propose":[114],"model-driven":[116],"framework":[117,190],"provides":[119],"automatic":[120],"code":[121,142,169,193],"generation":[122,194],"capability":[123],"ameliorate":[125],"support":[127],"our":[129],"language.":[131],"They":[132],"present":[133],"set":[135],"model-to-text":[137],"transformations":[138,152],"able":[139],"produce":[141],"different":[144],"commercial":[146],"well":[149],"model-to-model":[151],"automatically":[154],"update":[155],"models":[158],"aim":[161],"supporting":[163],"generated":[168],"according":[170],"source":[173],"evolution.":[174],"A":[175],"demonstration":[176],"using":[177],"example":[179],"conducted":[181],"initial":[184],"validation":[185],"show":[187],"covering":[191],"modeling,":[192],"could":[197],"be":[198],"used":[199],"practice.":[201]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}