{"id":"https://openalex.org/W2020997873","doi":"https://doi.org/10.1145/1353343.1353383","title":"Exact and inexact methods for selecting views and indexes for OLAP performance improvement","display_name":"Exact and inexact methods for selecting views and indexes for OLAP performance improvement","publication_year":2008,"publication_date":"2008-03-25","ids":{"openalex":"https://openalex.org/W2020997873","doi":"https://doi.org/10.1145/1353343.1353383","mag":"2020997873"},"language":"en","primary_location":{"id":"doi:10.1145/1353343.1353383","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353383","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353383","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353383","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5072014226","display_name":"Zohreh Asgharzadeh Talebi","orcid":null},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]},{"id":"https://openalex.org/I2801313472","display_name":"North Central State College","ror":"https://ror.org/04b6b6f76","country_code":"US","type":"education","lineage":["https://openalex.org/I2801313472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zohreh Asgharzadeh Talebi","raw_affiliation_strings":["NC State University, Raleigh, NC"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NC State University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535","https://openalex.org/I2801313472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078910758","display_name":"Rada Chirkova","orcid":"https://orcid.org/0000-0003-4249-9690"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]},{"id":"https://openalex.org/I2801313472","display_name":"North Central State College","ror":"https://ror.org/04b6b6f76","country_code":"US","type":"education","lineage":["https://openalex.org/I2801313472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rada Chirkova","raw_affiliation_strings":["NC State Univ University, Raleigh, NC"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NC State Univ University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535","https://openalex.org/I2801313472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044801429","display_name":"Yahya Fathi","orcid":"https://orcid.org/0000-0003-4592-6459"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]},{"id":"https://openalex.org/I2801313472","display_name":"North Central State College","ror":"https://ror.org/04b6b6f76","country_code":"US","type":"education","lineage":["https://openalex.org/I2801313472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yahya Fathi","raw_affiliation_strings":["NC State University, Raleigh, NC"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NC State University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535","https://openalex.org/I2801313472"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068222606","display_name":"Matthias F. Stallmann","orcid":"https://orcid.org/0000-0003-1199-156X"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]},{"id":"https://openalex.org/I2801313472","display_name":"North Central State College","ror":"https://ror.org/04b6b6f76","country_code":"US","type":"education","lineage":["https://openalex.org/I2801313472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Matthias Stallmann","raw_affiliation_strings":["NC State Univ University, Raleigh, NC"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NC State Univ University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535","https://openalex.org/I2801313472"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.8187,"has_fulltext":true,"cited_by_count":34,"citation_normalized_percentile":{"value":0.94650595,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"311","last_page":"322"},"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.9998000264167786,"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.9998000264167786,"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/T11106","display_name":"Data Management and Algorithms","score":0.9991000294685364,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9922999739646912,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.95421302318573},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7937805652618408},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.7027420401573181},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.6390625238418579},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6011825203895569},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.52025306224823},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5117137432098389},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4921979010105133},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.48066794872283936},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.4774611294269562},{"id":"https://openalex.org/keywords/limit","display_name":"Limit (mathematics)","score":0.4637959599494934},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.4633254408836365},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.4631044268608093},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4293302893638611},{"id":"https://openalex.org/keywords/approximation-algorithm","display_name":"Approximation algorithm","score":0.4204041659832001},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35334083437919617},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3224026560783386},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.25249671936035156},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1390123963356018},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.12387335300445557},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.08142152428627014}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.95421302318573},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7937805652618408},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.7027420401573181},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6390625238418579},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6011825203895569},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.52025306224823},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5117137432098389},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4921979010105133},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.48066794872283936},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.4774611294269562},{"id":"https://openalex.org/C151201525","wikidata":"https://www.wikidata.org/wiki/Q177239","display_name":"Limit (mathematics)","level":2,"score":0.4637959599494934},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.4633254408836365},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.4631044268608093},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4293302893638611},{"id":"https://openalex.org/C148764684","wikidata":"https://www.wikidata.org/wiki/Q621751","display_name":"Approximation algorithm","level":2,"score":0.4204041659832001},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35334083437919617},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3224026560783386},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.25249671936035156},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1390123963356018},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.12387335300445557},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.08142152428627014},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","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},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1353343.1353383","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353383","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353383","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.lib.ncsu.edu:1840.16/6202","is_oa":false,"landing_page_url":"http://www.lib.ncsu.edu/resolver/1840.16/6202","pdf_url":null,"source":{"id":"https://openalex.org/S4306402468","display_name":"NCSU Libraries Repository (North Carolina State University Libraries)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I137902535","host_organization_name":"North Carolina State University","host_organization_lineage":["https://openalex.org/I137902535"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"pmh:oai:repository.lib.ncsu.edu:1840.4/1390","is_oa":false,"landing_page_url":"http://www.lib.ncsu.edu/resolver/1840.4/1390","pdf_url":null,"source":{"id":"https://openalex.org/S4306402468","display_name":"NCSU Libraries Repository (North Carolina State University Libraries)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I137902535","host_organization_name":"North Carolina State University","host_organization_lineage":["https://openalex.org/I137902535"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Technical report"}],"best_oa_location":{"id":"doi:10.1145/1353343.1353383","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353383","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353383","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1198119564","display_name":null,"funder_award_id":"DMI-032163503070720447742","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1970981602","display_name":"Efficient View-Design Algorithms to Achieve Near-Optimal Performance of Sets of Relational Queries","funder_award_id":"0307072","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G824287111","display_name":"STTR Phase II:   Automation of the Crosscut Operation in a Wood Processing Mill","funder_award_id":"0321635","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8313349998","display_name":"CAREER: Adaptive Automated Design of Stored Derived Data","funder_award_id":"0447742","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2020997873.pdf","grobid_xml":"https://content.openalex.org/works/W2020997873.grobid-xml"},"referenced_works_count":22,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W119664787","https://openalex.org/W1482520531","https://openalex.org/W1538267625","https://openalex.org/W1562988957","https://openalex.org/W1851390469","https://openalex.org/W2017782374","https://openalex.org/W2020997873","https://openalex.org/W2033052876","https://openalex.org/W2072764742","https://openalex.org/W2087869882","https://openalex.org/W2106325388","https://openalex.org/W2111845378","https://openalex.org/W2113888164","https://openalex.org/W2122816893","https://openalex.org/W2143401113","https://openalex.org/W2148299570","https://openalex.org/W2150101660","https://openalex.org/W2165481122","https://openalex.org/W2416687338","https://openalex.org/W2521498284","https://openalex.org/W6992659470"],"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":{"In":[0,130],"on-line":[1],"analytical":[2],"processing":[3,118],"(OLAP),":[4],"precomputing":[5],"(materializing":[6],"as":[7,36,124,126,132],"views)":[8],"and":[9,32,55,59,68,85,136],"indexing":[10],"auxiliary":[11],"data":[12],"aggregations":[13],"is":[14,63,104,127,144],"a":[15,48,56,64,110],"common":[16],"way":[17],"of":[18,50,53,66,74,120,140],"reducing":[19],"query-evaluation":[20],"time":[21],"costs":[22,73,119],"for":[23,89,149],"important":[24],"data-analysis":[25,51],"queries.":[26],"We":[27],"consider":[28],"an":[29,37],"OLAP":[30,122,150],"view-":[31],"index-selection":[33],"problem":[34],"stated":[35],"optimization":[38],"problem,":[39],"where":[40],"(i)":[41],"the":[42,45,61,72,75,80,101,117,138],"inputs":[43],"include":[44],"data-warehouse":[46],"schema,":[47],"set":[49,65],"queries":[52,123],"interest,":[54],"storage-limit":[57],"constraint,":[58],"(ii)":[60],"output":[62],"views":[67,91],"indexes":[69,93],"that":[70,115],"minimizes":[71],"input":[76],"queries,":[77],"subject":[78],"to":[79,96,107,137],"storage":[81],"limit.":[82],"While":[83],"greedy":[84],"other":[86],"heuristic":[87],"strategies":[88],"choosing":[90],"or":[92,152],"might":[94],"help":[95],"some":[97],"extent":[98],"in":[99,134],"improving":[100],"costs,":[102],"it":[103],"highly":[105],"nontrivial":[106,156],"arrive":[108],"at":[109],"globally":[111],"optimum":[112],"solution,":[113],"one":[114],"reduces":[116],"typical":[121],"much":[125],"theoretically":[128],"possible.":[129],"fact,":[131],"observed":[133],"[17]":[135],"best":[139],"our":[141],"knowledge,":[142],"there":[143],"no":[145],"known":[146],"approximation":[147],"algorithm":[148],"view":[151],"index":[153],"selection":[154],"with":[155],"performance":[157],"guarantees.":[158]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2012,"cited_by_count":5}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}