{"id":"https://openalex.org/W2131556061","doi":"https://doi.org/10.1142/s0218194011005402","title":"AN APPROACH FOR DESIGNING, MODELING AND REALIZING ETL PROCESSES BASED ON UNIFIED VIEWS MODEL","display_name":"AN APPROACH FOR DESIGNING, MODELING AND REALIZING ETL PROCESSES BASED ON UNIFIED VIEWS MODEL","publication_year":2011,"publication_date":"2011-06-01","ids":{"openalex":"https://openalex.org/W2131556061","doi":"https://doi.org/10.1142/s0218194011005402","mag":"2131556061"},"language":"en","primary_location":{"id":"doi:10.1142/s0218194011005402","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218194011005402","pdf_url":null,"source":{"id":"https://openalex.org/S131442419","display_name":"International Journal of Software Engineering and Knowledge Engineering","issn_l":"0218-1940","issn":["0218-1940","1793-6403"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Engineering and Knowledge Engineering","raw_type":"journal-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/A5101883986","display_name":"Xudong Song","orcid":"https://orcid.org/0000-0002-4989-9091"},"institutions":[{"id":"https://openalex.org/I27357992","display_name":"Dalian University of Technology","ror":"https://ror.org/023hj5876","country_code":"CN","type":"education","lineage":["https://openalex.org/I27357992"]},{"id":"https://openalex.org/I7350606","display_name":"Dalian Jiaotong University","ror":"https://ror.org/05gp45n31","country_code":"CN","type":"education","lineage":["https://openalex.org/I7350606"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"XUDONG SONG","raw_affiliation_strings":["Computer Science Department, Dalian Jiaotong University, Dalian, Liaoning 116028, China","Computer Science Department, Dalian University of Technology, Dalian, Liaoning 116024, China"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Dalian Jiaotong University, Dalian, Liaoning 116028, China","institution_ids":["https://openalex.org/I7350606"]},{"raw_affiliation_string":"Computer Science Department, Dalian University of Technology, Dalian, Liaoning 116024, China","institution_ids":["https://openalex.org/I27357992"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100731169","display_name":"Xiaobing Liu","orcid":"https://orcid.org/0000-0003-0458-1298"},"institutions":[{"id":"https://openalex.org/I27357992","display_name":"Dalian University of Technology","ror":"https://ror.org/023hj5876","country_code":"CN","type":"education","lineage":["https://openalex.org/I27357992"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"XIAOBING LIU","raw_affiliation_strings":["Computer Integrated Manufacturing Systems Center, Dalian University of Technology, Dalian, Liaoning 116028, China"],"affiliations":[{"raw_affiliation_string":"Computer Integrated Manufacturing Systems Center, Dalian University of Technology, Dalian, Liaoning 116028, China","institution_ids":["https://openalex.org/I27357992"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5101883986"],"corresponding_institution_ids":["https://openalex.org/I27357992","https://openalex.org/I7350606"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.19067439,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"21","issue":"04","first_page":"543","last_page":"570"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.998199999332428,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9970999956130981,"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.8121388554573059},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.5912257432937622},{"id":"https://openalex.org/keywords/maintainability","display_name":"Maintainability","score":0.5328728556632996},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.532283365726471},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.49630314111709595},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.43991348147392273},{"id":"https://openalex.org/keywords/modeling-language","display_name":"Modeling language","score":0.42785072326660156},{"id":"https://openalex.org/keywords/model-driven-architecture","display_name":"Model-driven architecture","score":0.42195582389831543},{"id":"https://openalex.org/keywords/personalization","display_name":"Personalization","score":0.41494515538215637},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3849390149116516},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.3066669702529907},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2828797698020935},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.14712494611740112},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.13450667262077332}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8121388554573059},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.5912257432937622},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.5328728556632996},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.532283365726471},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.49630314111709595},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.43991348147392273},{"id":"https://openalex.org/C179603123","wikidata":"https://www.wikidata.org/wiki/Q1941921","display_name":"Modeling language","level":3,"score":0.42785072326660156},{"id":"https://openalex.org/C509989072","wikidata":"https://www.wikidata.org/wiki/Q15188241","display_name":"Model-driven architecture","level":4,"score":0.42195582389831543},{"id":"https://openalex.org/C183003079","wikidata":"https://www.wikidata.org/wiki/Q1000371","display_name":"Personalization","level":2,"score":0.41494515538215637},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3849390149116516},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.3066669702529907},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2828797698020935},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.14712494611740112},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.13450667262077332}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1142/s0218194011005402","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218194011005402","pdf_url":null,"source":{"id":"https://openalex.org/S131442419","display_name":"International Journal of Software Engineering and Knowledge Engineering","issn_l":"0218-1940","issn":["0218-1940","1793-6403"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Engineering and Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W332208005","https://openalex.org/W1482268585","https://openalex.org/W1495859460","https://openalex.org/W1971518725","https://openalex.org/W1997529428","https://openalex.org/W2014763157","https://openalex.org/W2106895292","https://openalex.org/W2107159615","https://openalex.org/W2108971776","https://openalex.org/W2128731098","https://openalex.org/W2151763080","https://openalex.org/W2393614826","https://openalex.org/W4251605462"],"related_works":["https://openalex.org/W79426661","https://openalex.org/W2170113317","https://openalex.org/W2363773515","https://openalex.org/W2349592260","https://openalex.org/W2536645041","https://openalex.org/W1966557326","https://openalex.org/W2025588638","https://openalex.org/W2394049954","https://openalex.org/W2119875166","https://openalex.org/W2158621500"],"abstract_inverted_index":{"Extraction-Transformation-Loading":[0],"(ETL)":[1],"tools":[2],"are":[3,29,135],"pieces":[4],"of":[5,11,98,105,120,161,191,210,217,229],"software":[6],"responsible":[7],"for":[8,49,67,181],"the":[9,30,90,94,99,103,106,115,126,130,159,178,192,208,212,227],"extraction":[10],"data":[12,79,101,107,143],"from":[13],"several":[14],"sources,":[15],"their":[16],"cleaning,":[17],"customization":[18],"and":[19,27,52,81,96,109,113,118,129,141,151,164,215,220],"insertion":[20],"into":[21],"Data":[22],"Warehouses":[23],"(DWs).":[24],"Complexity,":[25],"usability":[26],"maintainability":[28],"primary":[31],"problems":[32],"concerning":[33],"ETL":[34,54,68,165,182,201,218],"processes.":[35,55],"To":[36],"deal":[37],"with":[38,207],"these":[39],"problems,":[40],"in":[41,70],"this":[42,157],"paper":[43],"we":[44,173,198],"provide":[45],"a":[46,58,222],"dynamic":[47],"approach":[48],"designing,":[50],"modeling":[51,180,214],"realizing":[53],"We":[56],"propose":[57],"new":[59],"architecture":[60],"based":[61,184,203],"on":[62,156,185,204],"Unified":[63,72,138,152,193],"Views":[64],"Model":[65],"(UVM)":[66],"processes,":[69,219],"which":[71],"view":[73,139,153],"layer":[74],"is":[75,170],"added":[76],"between":[77,137,148],"source":[78,100,142],"level":[80,140,144,150],"DWs":[82,149],"level.":[83,154],"The":[84],"unified":[85],"views":[86],"model":[87],"serves":[88],"as":[89,145,147],"means":[91],"to":[92,102,124,176,225],"conform":[93],"structure":[95],"semantics":[97],"ones":[104],"warehouses,":[108],"help":[110],"designers":[111],"understand":[112],"analyze":[114],"meaning,":[116],"relationships":[117],"lineage":[119],"information.":[121],"In":[122],"order":[123],"guarantee":[125],"transparency":[127],"access":[128],"usability,":[131],"two":[132],"mapping":[133],"methods":[134],"adopted":[136],"well":[146],"Based":[155],"architecture,":[158],"method":[160],"constructing":[162],"UVM":[163,186,205],"operations":[166],"among":[167],"three":[168],"levels":[169],"given.":[171],"Then,":[172],"describe":[174],"how":[175],"build":[177],"conceptual":[179],"processes":[183],"by":[187],"using":[188],"an":[189,200],"extension":[190],"Modeling":[194],"Language":[195],"(UML).":[196],"Finally,":[197],"present":[199],"tool":[202],"(UVETL)":[206],"goal":[209],"facilitating":[211],"design,":[213],"realization":[216],"give":[221],"case":[223],"study":[224],"exemplify":[226],"benefits":[228],"our":[230],"proposal.":[231]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}