{"id":"https://openalex.org/W2477765947","doi":"https://doi.org/10.4018/ijirr.2016070104","title":"Efficient Materialized View Selection for Multi-Dimensional Data Cube Models","display_name":"Efficient Materialized View Selection for Multi-Dimensional Data Cube Models","publication_year":2016,"publication_date":"2016-07-01","ids":{"openalex":"https://openalex.org/W2477765947","doi":"https://doi.org/10.4018/ijirr.2016070104","mag":"2477765947"},"language":"en","primary_location":{"id":"doi:10.4018/ijirr.2016070104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijirr.2016070104","pdf_url":null,"source":{"id":"https://openalex.org/S4210223861","display_name":"International Journal of Information Retrieval Research","issn_l":"2155-6377","issn":["2155-6377","2155-6385"],"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 Information Retrieval Research","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/A5008779469","display_name":"Naveen Dahiya","orcid":"https://orcid.org/0000-0002-3038-766X"},"institutions":[{"id":"https://openalex.org/I2799452066","display_name":"Maharaja Engineering College","ror":"https://ror.org/034pbde03","country_code":"IN","type":"education","lineage":["https://openalex.org/I2799452066","https://openalex.org/I33585257"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Naveen Dahiya","raw_affiliation_strings":["Maharaja Surajmal Institute of Technology, New Delhi, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Maharaja Surajmal Institute of Technology, New Delhi, India","institution_ids":["https://openalex.org/I2799452066"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075349449","display_name":"Vishal Bhatnagar","orcid":"https://orcid.org/0000-0002-2681-0103"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Vishal Bhatnagar","raw_affiliation_strings":["Department of Computer Science and Engineering, Ambedkar Institute of Advanced Communication Technologies and Research, New Delhi, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Ambedkar Institute of Advanced Communication Technologies and Research, New Delhi, India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101816461","display_name":"Manjeet Singh","orcid":"https://orcid.org/0000-0002-5117-0830"},"institutions":[{"id":"https://openalex.org/I55124831","display_name":"J.C. Bose University of Science & Technology, YMCA","ror":"https://ror.org/014jqnm52","country_code":"IN","type":"education","lineage":["https://openalex.org/I55124831"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Manjeet Singh","raw_affiliation_strings":["Y.M.C.A. University of Science and Technology, Faridabad, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Y.M.C.A. University of Science and Technology, Faridabad, India","institution_ids":["https://openalex.org/I55124831"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2501,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.51576468,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"6","issue":"3","first_page":"52","last_page":"74"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.98580002784729,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/materialized-view","display_name":"Materialized view","score":0.9567104578018188},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7555089592933655},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.7330233454704285},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6420908570289612},{"id":"https://openalex.org/keywords/knapsack-problem","display_name":"Knapsack problem","score":0.6155824661254883},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5421134233474731},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4847142696380615},{"id":"https://openalex.org/keywords/greedy-randomized-adaptive-search-procedure","display_name":"Greedy randomized adaptive search procedure","score":0.46455997228622437},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.4500090777873993},{"id":"https://openalex.org/keywords/space","display_name":"Space (punctuation)","score":0.42464056611061096},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.3509851396083832},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34223872423171997},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.23122629523277283},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.19396072626113892},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.16814380884170532},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13478529453277588},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09237873554229736}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9567104578018188},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7555089592933655},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.7330233454704285},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6420908570289612},{"id":"https://openalex.org/C113138325","wikidata":"https://www.wikidata.org/wiki/Q864457","display_name":"Knapsack problem","level":2,"score":0.6155824661254883},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5421134233474731},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4847142696380615},{"id":"https://openalex.org/C126221529","wikidata":"https://www.wikidata.org/wiki/Q3116070","display_name":"Greedy randomized adaptive search procedure","level":3,"score":0.46455997228622437},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.4500090777873993},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.42464056611061096},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3509851396083832},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34223872423171997},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.23122629523277283},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.19396072626113892},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.16814380884170532},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13478529453277588},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09237873554229736},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijirr.2016070104","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijirr.2016070104","pdf_url":null,"source":{"id":"https://openalex.org/S4210223861","display_name":"International Journal of Information Retrieval Research","issn_l":"2155-6377","issn":["2155-6377","2155-6385"],"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 Information Retrieval Research","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jirr00:v:6:y:2016:i:3:p:52-74","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJIRR.2016070104","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"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.7599999904632568}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W2776818","https://openalex.org/W76102122","https://openalex.org/W79561920","https://openalex.org/W192938905","https://openalex.org/W1482980260","https://openalex.org/W1507039213","https://openalex.org/W1544010218","https://openalex.org/W1596194537","https://openalex.org/W1602422951","https://openalex.org/W1943411325","https://openalex.org/W1952523953","https://openalex.org/W1981726942","https://openalex.org/W2006057663","https://openalex.org/W2022286645","https://openalex.org/W2044279394","https://openalex.org/W2073889401","https://openalex.org/W2081417442","https://openalex.org/W2100799582","https://openalex.org/W2113888164","https://openalex.org/W2122816893","https://openalex.org/W2126002471","https://openalex.org/W2143401113","https://openalex.org/W2152191782","https://openalex.org/W2170515491","https://openalex.org/W2436693592"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2351136238","https://openalex.org/W2167807475","https://openalex.org/W2169800510"],"abstract_inverted_index":{"Decision":[0],"Support":[1],"Systems":[2],"help":[3],"managers":[4],"to":[5,19,77,95,156],"make":[6],"intelligent":[7],"decisions":[8],"by":[9,41,143,152],"throwing":[10],"complex":[11],"queries":[12,20],"on":[13,86,138],"large":[14],"databases.":[15],"The":[16,34,63,83,101,126,146],"response":[17,35],"time":[18,36],"is":[21,92,120,131,149],"a":[22,69,111],"very":[23],"crucial":[24],"factor":[25],"in":[26,65,115],"governing":[27],"the":[28,55,107,123,144,157],"quality":[29],"of":[30,54,89,99,103,117,133,140,159],"decision":[31],"support":[32],"systems.":[33],"can":[37],"be":[38],"greatly":[39],"improved":[40],"using":[42,74,106,165],"query":[43,48],"optimization":[44,49],"techniques.":[45],"A":[46],"powerful":[47],"technique":[50],"selects":[51],"only":[52],"some":[53],"views":[56,60,105],"and":[57,136,161],"not":[58],"all":[59],"for":[61],"materialization.":[62],"authors":[64],"this":[66],"paper":[67],"present":[68],"refined":[70,127,162],"greedy":[71,128,160,163],"selection":[72,129,148],"approach":[73,84,109,130,164],"forward":[75],"references":[76],"give":[78],"better":[79,112],"materialized":[80,104],"view":[81,147],"selection.":[82],"works":[85],"lattice":[87],"framework":[88],"data":[90],"that":[91],"capable":[93],"enough":[94],"show":[96],"inter":[97],"dependencies":[98],"data.":[100],"choice":[102],"proposed":[108],"gives":[110],"trade":[113],"off":[114],"terms":[116],"space/benefits,":[118],"which":[119],"proved":[121],"from":[122],"experimental":[124],"results.":[125],"independent":[132],"space":[134,154],"constraint":[135],"depends":[137],"number":[139],"passes":[141],"entered":[142],"user.":[145],"further":[150],"enhanced":[151],"including":[153],"constraints":[155],"results":[158],"knapsack":[166],"implementation.":[167]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2017,"cited_by_count":1}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}