{"id":"https://openalex.org/W2044966822","doi":"https://doi.org/10.1145/2390045.2390050","title":"Improving the maintainability of data warehouse designs","display_name":"Improving the maintainability of data warehouse designs","publication_year":2012,"publication_date":"2012-11-02","ids":{"openalex":"https://openalex.org/W2044966822","doi":"https://doi.org/10.1145/2390045.2390050","mag":"2044966822"},"language":"en","primary_location":{"id":"doi:10.1145/2390045.2390050","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2390045.2390050","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the fifteenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},"type":"conference-paper","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/A5091436252","display_name":"Alejandro Mat\u00e9","orcid":"https://orcid.org/0000-0001-7770-3693"},"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":"Alejandro Mat\u00e9","raw_affiliation_strings":["University of Alicante, Alicante, Spain","University of Alicante, Alicante,#R# Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Alicante, Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]},{"raw_affiliation_string":"University of Alicante, Alicante,#R# Spain","institution_ids":["https://openalex.org/I130194489"]}]},{"author_position":"middle","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":["University of Alicante, Alicante, Spain","University of Alicante, Alicante,#R# Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Alicante, Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]},{"raw_affiliation_string":"University of Alicante, Alicante,#R# Spain","institution_ids":["https://openalex.org/I130194489"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018322115","display_name":"Elisa de Gregorio","orcid":null},"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":"Elisa de Gregorio","raw_affiliation_strings":["University of Alicante, Alicante, Spain","University of Alicante, Alicante,#R# Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Alicante, Alicante, Spain","institution_ids":["https://openalex.org/I130194489"]},{"raw_affiliation_string":"University of Alicante, Alicante,#R# Spain","institution_ids":["https://openalex.org/I130194489"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067437365","display_name":"Il\u2010Yeol Song","orcid":"https://orcid.org/0000-0001-7706-959X"},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Il-Yeol Song","raw_affiliation_strings":["Drexel University, Philadelphia, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Drexel University, Philadelphia, USA","institution_ids":["https://openalex.org/I72816309"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"25","last_page":"32"},"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.9987999796867371,"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.9987999796867371,"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.9986000061035156,"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/T11719","display_name":"Data Quality and Management","score":0.9966999888420105,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7673699259757996},{"id":"https://openalex.org/keywords/maintainability","display_name":"Maintainability","score":0.7186751961708069},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7106180787086487},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5431280732154846},{"id":"https://openalex.org/keywords/matching","display_name":"Matching (statistics)","score":0.5360852479934692},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5049105286598206},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47673001885414124},{"id":"https://openalex.org/keywords/data-transformation","display_name":"Data transformation","score":0.47365960478782654},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.4392507076263428},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4053429961204529},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3611533045768738},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.33751800656318665},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20504972338676453}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7673699259757996},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.7186751961708069},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7106180787086487},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5431280732154846},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.5360852479934692},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5049105286598206},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47673001885414124},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.47365960478782654},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.4392507076263428},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4053429961204529},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3611533045768738},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33751800656318665},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20504972338676453},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2390045.2390050","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2390045.2390050","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the fifteenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W77920379","https://openalex.org/W1495859460","https://openalex.org/W1524500851","https://openalex.org/W1526993786","https://openalex.org/W1552694902","https://openalex.org/W1565862462","https://openalex.org/W1904112038","https://openalex.org/W1971323001","https://openalex.org/W1976507515","https://openalex.org/W2029594935","https://openalex.org/W2032999854","https://openalex.org/W2039201949","https://openalex.org/W2057982817","https://openalex.org/W2072764742","https://openalex.org/W2075036374","https://openalex.org/W2075518254","https://openalex.org/W2108971776","https://openalex.org/W2114887408","https://openalex.org/W2163857507","https://openalex.org/W2498905566","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2348093825","https://openalex.org/W2390710026","https://openalex.org/W2364425891","https://openalex.org/W2347601812","https://openalex.org/W3022239989","https://openalex.org/W3015205082","https://openalex.org/W1505247071","https://openalex.org/W2364409751","https://openalex.org/W4211040133","https://openalex.org/W2181836431"],"abstract_inverted_index":{"In":[0,109,132,189],"data":[1,16,80,130,175],"warehouse":[2],"(DW)":[3],"development,":[4],"a":[5,73,114,152,200],"series":[6],"of":[7,116,195,209,212],"mappings":[8,33,118],"must":[9,25],"be":[10,38],"specified":[11,123],"between":[12],"user":[13,121],"concepts":[14,122],"and":[15,148],"source":[17],"elements,":[18],"in":[19,75,78,96,100],"order":[20,190],"to":[21,37,46,92,103,126,137,162,184,191],"identify":[22,139],"which":[23],"sources":[24,81,176],"undergo":[26],"an":[27],"integration":[28],"process.":[29],"Until":[30],"now,":[31],"these":[32],"are":[34],"either":[35],"assumed":[36],"implied":[39],"by":[40,124],"name":[41],"matching":[42],"or":[43,77,174],"identified":[44],"according":[45],"the":[47,51,65,79,83,105,145,178,186,193,206,210],"designer's":[48],"experience.":[49],"Then,":[50],"result":[52],"is":[53],"implemented":[54],"as":[55,166,168],"Extraction/Transformation/Loading":[56],"(ETL)":[57],"processes.":[58,150],"Since":[59],"ETL":[60,149],"processes":[61],"relate":[62,120],"elements":[63],"at":[64,172],"logical":[66],"level,":[67],"designers":[68],"cannot":[69],"adequately":[70],"analyze":[71],"how":[72,140],"change":[74,143,170],"requirements":[76,125,173],"affects":[82,144],"analysis":[84,107],"capabilities.":[85],"Furthermore,":[86],"this":[87,110,134],"approach":[88,158],"makes":[89],"it":[90],"difficult":[91],"perform":[93,104],"incremental":[94],"changes":[95],"DW":[97,153,179],"design,":[98],"requiring":[99],"some":[101],"cases":[102],"whole":[106,187],"again.":[108],"paper":[111],"we":[112,198],"present":[113],"set":[115],"semantic":[117],"that":[119],"those":[127],"obtained":[128],"from":[129],"sources.":[131],"turn,":[133],"allows":[135,160],"us":[136,161],"accurately":[138],"any":[141,169],"potential":[142],"different":[146],"structures":[147],"As":[151],"evolves":[154],"over":[155],"time,":[156],"our":[157,196],"easily":[159],"incorporate":[163],"new":[164],"concepts,":[165],"well":[167],"introduced":[171],"into":[177],"repository":[180],"with":[181],"no":[182],"need":[183],"redesign":[185],"DW.":[188],"show":[192,199],"application":[194],"proposal,":[197],"real":[201],"case":[202],"study":[203],"focusing":[204],"on":[205],"Digital":[207],"library":[208],"University":[211],"Alicante.":[213]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}