{"id":"https://openalex.org/W2296150852","doi":"https://doi.org/10.1109/tkde.2015.2499199","title":"Virtual Denormalization via Array Index Reference for Main Memory OLAP","display_name":"Virtual Denormalization via Array Index Reference for Main Memory OLAP","publication_year":2015,"publication_date":"2015-11-12","ids":{"openalex":"https://openalex.org/W2296150852","doi":"https://doi.org/10.1109/tkde.2015.2499199","mag":"2296150852"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2015.2499199","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2015.2499199","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data 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/A5100644855","display_name":"Yansong Zhang","orcid":"https://orcid.org/0000-0003-2198-0987"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]},{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["CN","NL"],"is_corresponding":true,"raw_author_name":"Yansong Zhang","raw_affiliation_strings":["Centrum Wiskunde & Informatica, Amsterdam, Netherlands","DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde & Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]},{"raw_affiliation_string":"DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101789720","display_name":"Xuan Zhou","orcid":"https://orcid.org/0000-0003-2044-1818"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuan Zhou","raw_affiliation_strings":["DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100386104","display_name":"Ying Zhang","orcid":"https://orcid.org/0000-0002-2674-1638"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]},{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["CN","NL"],"is_corresponding":false,"raw_author_name":"Ying Zhang","raw_affiliation_strings":["Centrum Wiskunde & Informatica, Amsterdam, Netherlands","DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde & Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]},{"raw_affiliation_string":"DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042056922","display_name":"\u88d5\u6df5 \u5f35","orcid":"https://orcid.org/0000-0001-8372-3412"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]},{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["CN","NL"],"is_corresponding":false,"raw_author_name":"Yu Zhang","raw_affiliation_strings":["Centrum Wiskunde & Informatica, Amsterdam, Netherlands","DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Centrum Wiskunde & Informatica, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I1341640284"]},{"raw_affiliation_string":"DEKE Lab and the National Survey Research Centre, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023475976","display_name":"Mingchuan Su","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mingchuan Su","raw_affiliation_strings":["DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5073869833","display_name":"Shan Wang","orcid":"https://orcid.org/0000-0002-6990-8071"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shan Wang","raw_affiliation_strings":["DEKE Lab, Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"DEKE Lab, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5100644855"],"corresponding_institution_ids":["https://openalex.org/I1341640284","https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":1.6641,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.86767675,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"28","issue":"4","first_page":"1061","last_page":"1074"},"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9965000152587891,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9944000244140625,"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.8573443293571472},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7505407929420471},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4924560487270355},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48923516273498535},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.42867547273635864},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.39262402057647705},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.30802416801452637},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.2068345844745636},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1192471981048584}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8573443293571472},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7505407929420471},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4924560487270355},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48923516273498535},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.42867547273635864},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.39262402057647705},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.30802416801452637},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2068345844745636},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1192471981048584}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2015.2499199","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2015.2499199","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G248599","display_name":null,"funder_award_id":"HIRP OPEN 20140510","funder_id":"https://openalex.org/F4320322183","funder_display_name":"Huawei Technologies"},{"id":"https://openalex.org/G4569306369","display_name":null,"funder_award_id":"2015AA015307","funder_id":"https://openalex.org/F4320335773","funder_display_name":"National High-tech Research and Development Program"},{"id":"https://openalex.org/G5078798923","display_name":null,"funder_award_id":"61272138","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320322183","display_name":"Huawei Technologies","ror":"https://ror.org/00cmhce21"},{"id":"https://openalex.org/F4320322499","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92"},{"id":"https://openalex.org/F4320335773","display_name":"National High-tech Research and Development Program","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W146226588","https://openalex.org/W1507516418","https://openalex.org/W1513239963","https://openalex.org/W1874295121","https://openalex.org/W1878777455","https://openalex.org/W1912964554","https://openalex.org/W1967601791","https://openalex.org/W1975837734","https://openalex.org/W1987238352","https://openalex.org/W2005112390","https://openalex.org/W2014977566","https://openalex.org/W2054046497","https://openalex.org/W2072541977","https://openalex.org/W2097880677","https://openalex.org/W2102639991","https://openalex.org/W2102729946","https://openalex.org/W2102987499","https://openalex.org/W2104242181","https://openalex.org/W2113831242","https://openalex.org/W2124851765","https://openalex.org/W2135003477","https://openalex.org/W2136390693","https://openalex.org/W2143125604","https://openalex.org/W2146461854","https://openalex.org/W2167357284","https://openalex.org/W2295596515","https://openalex.org/W2406955896","https://openalex.org/W4213163687","https://openalex.org/W6639069962","https://openalex.org/W6639498660","https://openalex.org/W6639914037","https://openalex.org/W6675553691","https://openalex.org/W6677064796","https://openalex.org/W6678708722","https://openalex.org/W7051270736"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","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/W2381646725"],"abstract_inverted_index":{"Denormalization":[0],"is":[1,14,35,66],"a":[2,31,86,130,141],"common":[3],"tactic":[4,34],"for":[5,92,135],"enhancing":[6],"performance":[7],"of":[8,96,121,143],"data":[9],"warehouses,":[10],"though":[11],"its":[12],"side-effect":[13],"quite":[15],"obvious.":[16],"Besides":[17],"being":[18],"confronted":[19],"with":[20],"update":[21],"abnormality,":[22],"denormalization":[23,105,122],"has":[24],"to":[25,68,103,117,153],"consume":[26],"additional":[27,125],"storage":[28,44],"space.":[29,127],"As":[30],"result,":[32],"this":[33,81],"rarely":[36],"used":[37],"in":[38,169],"main":[39,56,87],"memory":[40,57,88],"databases,":[41],"which":[42],"regards":[43],"space,":[45],"i.e.,":[46],"RAM,":[47],"as":[48,64,110,148],"scarce":[49],"resource.":[50],"Nevertheless,":[51],"our":[52],"research":[53],"reveals":[54],"that":[55,160],"database":[58],"can":[59],"benefit":[60,120],"enormously":[61],"from":[62],"denormalization,":[63,100],"it":[65],"able":[67],"remarkably":[69],"simplify":[70],"the":[71,77,119,163],"query":[72,132,173],"processing":[73,133],"plans":[74],"and":[75,151],"reduce":[76],"computation":[78],"cost.":[79],"In":[80],"paper,":[82],"we":[83],"present":[84],"A-Store,":[85],"OLAP":[89],"engine":[90],"customized":[91],"star/snowflake":[93,170],"schemas.":[94],"Instead":[95],"generating":[97],"fully":[98],"materialized":[99],"A-Store":[101,128,161],"resorts":[102],"virtual":[104],"by":[106],"treating":[107],"array":[108],"indexes":[109],"primary":[111],"keys.":[112],"This":[113],"design":[114],"allows":[115],"us":[116],"harvest":[118],"without":[123],"sacrificing":[124],"RAM":[126],"uses":[129],"generic":[131],"model":[134],"all":[136],"SPJGA":[137],"queries.":[138],"It":[139],"applies":[140],"number":[142],"state-of-the-art":[144],"optimization":[145],"methods,":[146],"such":[147],"vectorized":[149],"scan":[150],"aggregation,":[152],"achieve":[154],"superior":[155],"performance.":[156],"Our":[157],"experiments":[158],"show":[159],"outperforms":[162],"most":[164],"prestigious":[165],"MMDB":[166],"systems":[167],"significantly":[168],"schema":[171],"based":[172],"processing.":[174]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}