{"id":"https://openalex.org/W2107791525","doi":"https://doi.org/10.1145/2513190.2513202","title":"Using REO on ETL conceptual modelling","display_name":"Using REO on ETL conceptual modelling","publication_year":2013,"publication_date":"2013-10-28","ids":{"openalex":"https://openalex.org/W2107791525","doi":"https://doi.org/10.1145/2513190.2513202","mag":"2107791525"},"language":"en","primary_location":{"id":"doi:10.1145/2513190.2513202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513190.2513202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the sixteenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"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/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":true,"raw_author_name":"Bruno Oliveira","raw_affiliation_strings":["ALGORITMI R&D Centre, University of Minho, Braga, Portugal"],"affiliations":[{"raw_affiliation_string":"ALGORITMI R&D Centre, University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"ALGORITMI R&D Centre, University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5089487986"],"corresponding_institution_ids":["https://openalex.org/I99682543"],"apc_list":null,"apc_paid":null,"fwci":4.8537,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.95209411,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"55","last_page":"60"},"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.9993000030517578,"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.9993000030517578,"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/T10703","display_name":"Business Process Modeling and Analysis","score":0.9987000226974487,"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.9983000159263611,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8162232041358948},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6459711790084839},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.565634548664093},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.5205515623092651},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.5051813721656799},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5031251311302185},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4849007725715637},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4768144488334656},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.45434802770614624},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4371874928474426},{"id":"https://openalex.org/keywords/conceptual-model","display_name":"Conceptual model","score":0.4342457354068756},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.2577304244041443},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18634536862373352}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8162232041358948},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6459711790084839},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.565634548664093},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.5205515623092651},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5051813721656799},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5031251311302185},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4849007725715637},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4768144488334656},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.45434802770614624},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4371874928474426},{"id":"https://openalex.org/C13606891","wikidata":"https://www.wikidata.org/wiki/Q2623243","display_name":"Conceptual model","level":2,"score":0.4342457354068756},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.2577304244041443},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18634536862373352},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2513190.2513202","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2513190.2513202","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the sixteenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5799999833106995,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1893018","https://openalex.org/W57116089","https://openalex.org/W126115071","https://openalex.org/W1482268585","https://openalex.org/W1510328895","https://openalex.org/W1522766828","https://openalex.org/W1534626598","https://openalex.org/W1583568507","https://openalex.org/W1602045554","https://openalex.org/W1692521721","https://openalex.org/W1906169869","https://openalex.org/W1988680012","https://openalex.org/W1993582687","https://openalex.org/W2075518254","https://openalex.org/W2098856526","https://openalex.org/W2101457992","https://openalex.org/W2105658676","https://openalex.org/W2139842876","https://openalex.org/W2146244985","https://openalex.org/W2273461479","https://openalex.org/W2561675875","https://openalex.org/W2621542389","https://openalex.org/W6681344290","https://openalex.org/W6694515237"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"The":[0],"formalization":[1],"of":[2,25,59,69,73,81,114,116,120,150],"software":[3,12],"patterns":[4],"has":[5],"proven":[6],"to":[7,77,90,131,141,158],"be":[8,63],"very":[9,38],"useful":[10],"in":[11,163],"developing,":[13],"improving":[14],"systems":[15],"communication,":[16],"data":[17,28,32,60,86],"interchange":[18],"across":[19],"platforms,":[20],"and":[21,27,52,88,104,145,178,188],"simplifying":[22],"the":[23,112,136,148],"integration":[24],"processes":[26,89],"flows.":[29],"Populating":[30],"a":[31,37,101,128,184,189],"warehouse":[33],"(ETL)":[34],"is":[35],"often":[36],"complex":[39],"task":[40],"demanding":[41],"significant":[42,79],"computational":[43],"resources.":[44],"It":[45],"faces":[46],"many":[47],"drawbacks":[48],"during":[49],"its":[50,143],"design":[51],"implementation,":[53],"involving":[54],"not":[55],"only":[56],"large":[57],"volumes":[58],"that":[61,98],"must":[62],"processed":[64],"but":[65],"also":[66],"undesirable":[67],"change":[68],"business":[70],"requirements.":[71,94],"All":[72],"this":[74,117,124],"leads":[75],"frequently":[76],"reuse":[78],"parts":[80],"other":[82],"ETL":[83,108,121,132,151,166],"implementations,":[84],"adapting":[85],"structures":[87],"comply":[91],"with":[92],"new":[93,129],"Additionally,":[95],"we":[96,126,176],"believe":[97],"it's":[99],"necessary":[100],"more":[102],"simply":[103],"reliable":[105],"approach":[106,130,155],"for":[107],"conceptual":[109,133],"modelling":[110,134],"covering":[111],"\"lack":[113],"mature\"":[115],"important":[118],"part":[119],"development.":[122],"In":[123],"paper":[125],"explored":[127],"using":[135],"Reo":[137,171],"coordination":[138,149],"language,":[139],"trying":[140],"evaluate":[142],"adequacy":[144],"expressiveness":[146],"on":[147],"tasks.":[152],"A":[153],"pattern-based":[154],"was":[156],"designed":[157],"map":[159],"typical":[160],"operations":[161],"used":[162],"real":[164],"world":[165],"scenarios":[167],"from":[168],"an":[169],"initial":[170],"specification.":[172],"For":[173],"demonstration":[174],"purposes,":[175],"present":[177],"discuss":[179],"as":[180],"two":[181],"case":[182],"studies,":[183],"slowly":[185],"changing":[186],"dimension":[187],"surrogated":[190],"key":[191],"pipelining":[192],"processes.":[193]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}