{"id":"https://openalex.org/W2081417442","doi":"https://doi.org/10.1145/2206869.2206874","title":"A survey of view selection methods","display_name":"A survey of view selection methods","publication_year":2012,"publication_date":"2012-04-25","ids":{"openalex":"https://openalex.org/W2081417442","doi":"https://doi.org/10.1145/2206869.2206874","mag":"2081417442"},"language":"en","primary_location":{"id":"doi:10.1145/2206869.2206874","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2206869.2206874","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-00720157","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090376314","display_name":"Imene Mami","orcid":null},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]},{"id":"https://openalex.org/I19894307","display_name":"Universit\u00e9 de Montpellier","ror":"https://ror.org/051escj72","country_code":"FR","type":"education","lineage":["https://openalex.org/I19894307"]},{"id":"https://openalex.org/I4210101743","display_name":"Laboratoire d'Informatique, de Robotique et de Micro\u00e9lectronique de Montpellier","ror":"https://ror.org/013yean28","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I1326498283","https://openalex.org/I151295451","https://openalex.org/I19894307","https://openalex.org/I4210101743","https://openalex.org/I4210159245","https://openalex.org/I4412460525"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"Imene Mami","raw_affiliation_strings":["Universit\u00e9 Montpellier 2 - INRIA, LIRMM, Montpellier, France"],"affiliations":[{"raw_affiliation_string":"Universit\u00e9 Montpellier 2 - INRIA, LIRMM, Montpellier, France","institution_ids":["https://openalex.org/I1326498283","https://openalex.org/I4210101743","https://openalex.org/I19894307"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109240366","display_name":"Zohra Bellahs\u00e8ne","orcid":null},"institutions":[{"id":"https://openalex.org/I19894307","display_name":"Universit\u00e9 de Montpellier","ror":"https://ror.org/051escj72","country_code":"FR","type":"education","lineage":["https://openalex.org/I19894307"]},{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en informatique et en automatique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"funder","lineage":["https://openalex.org/I1326498283"]},{"id":"https://openalex.org/I4210101743","display_name":"Laboratoire d'Informatique, de Robotique et de Micro\u00e9lectronique de Montpellier","ror":"https://ror.org/013yean28","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I1326498283","https://openalex.org/I151295451","https://openalex.org/I19894307","https://openalex.org/I4210101743","https://openalex.org/I4210159245","https://openalex.org/I4412460525"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Zohra Bellahsene","raw_affiliation_strings":["Universit\u00e9 Montpellier 2 - INRIA, LIRMM, Montpellier, France"],"affiliations":[{"raw_affiliation_string":"Universit\u00e9 Montpellier 2 - INRIA, LIRMM, Montpellier, France","institution_ids":["https://openalex.org/I1326498283","https://openalex.org/I4210101743","https://openalex.org/I19894307"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5090376314"],"corresponding_institution_ids":["https://openalex.org/I1326498283","https://openalex.org/I19894307","https://openalex.org/I4210101743"],"apc_list":null,"apc_paid":null,"fwci":11.28,"has_fulltext":false,"cited_by_count":112,"citation_normalized_percentile":{"value":0.98686254,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"41","issue":"1","first_page":"20","last_page":"29"},"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.9998999834060669,"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.9998999834060669,"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.9998999834060669,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9990000128746033,"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.8790522813796997},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.8205491304397583},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8018262982368469},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.549130916595459},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5271120667457581},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5195951461791992},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4162772297859192},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21551662683486938},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.13875669240951538},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09764543175697327}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8790522813796997},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.8205491304397583},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8018262982368469},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.549130916595459},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5271120667457581},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5195951461791992},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4162772297859192},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21551662683486938},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.13875669240951538},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09764543175697327},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2206869.2206874","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2206869.2206874","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},{"id":"pmh:oai:HAL:lirmm-00720157v1","is_oa":true,"landing_page_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-00720157","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SIGMOD record, 2012, 41 (1), pp.20-29. ⟨10.1145/2206869.2206874⟩","raw_type":"Journal articles"}],"best_oa_location":{"id":"pmh:oai:HAL:lirmm-00720157v1","is_oa":true,"landing_page_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-00720157","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SIGMOD record, 2012, 41 (1), pp.20-29. ⟨10.1145/2206869.2206874⟩","raw_type":"Journal articles"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":69,"referenced_works":["https://openalex.org/W192938905","https://openalex.org/W253264081","https://openalex.org/W1039137372","https://openalex.org/W1481595995","https://openalex.org/W1482520531","https://openalex.org/W1519205554","https://openalex.org/W1520432709","https://openalex.org/W1549717312","https://openalex.org/W1558617513","https://openalex.org/W1560005039","https://openalex.org/W1581805425","https://openalex.org/W1595062593","https://openalex.org/W1597198211","https://openalex.org/W1597931764","https://openalex.org/W1602422951","https://openalex.org/W1639032689","https://openalex.org/W1738857073","https://openalex.org/W1793365533","https://openalex.org/W1943411325","https://openalex.org/W1952523953","https://openalex.org/W1977786400","https://openalex.org/W1989893188","https://openalex.org/W1995999642","https://openalex.org/W2002131042","https://openalex.org/W2011580419","https://openalex.org/W2012670464","https://openalex.org/W2022286645","https://openalex.org/W2030148067","https://openalex.org/W2038176938","https://openalex.org/W2044279394","https://openalex.org/W2047809518","https://openalex.org/W2054170837","https://openalex.org/W2056229702","https://openalex.org/W2072916859","https://openalex.org/W2082941608","https://openalex.org/W2087869882","https://openalex.org/W2098416578","https://openalex.org/W2100109822","https://openalex.org/W2100251446","https://openalex.org/W2104704499","https://openalex.org/W2111845378","https://openalex.org/W2112101330","https://openalex.org/W2114712170","https://openalex.org/W2117654209","https://openalex.org/W2122816893","https://openalex.org/W2122902664","https://openalex.org/W2124751909","https://openalex.org/W2131165411","https://openalex.org/W2132582487","https://openalex.org/W2132729409","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2145559627","https://openalex.org/W2152191782","https://openalex.org/W2156554027","https://openalex.org/W2160645305","https://openalex.org/W2160825121","https://openalex.org/W2164049396","https://openalex.org/W2167443373","https://openalex.org/W2170515491","https://openalex.org/W2171776966","https://openalex.org/W2506514621","https://openalex.org/W2757905766","https://openalex.org/W2951321531","https://openalex.org/W3023540311","https://openalex.org/W4241602967","https://openalex.org/W4255826646","https://openalex.org/W6634765471","https://openalex.org/W6679865122"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W1908544460","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2087983779","https://openalex.org/W1635132392"],"abstract_inverted_index":{"Materialized":[0],"view":[1,37,42,62,72,88,101],"selection":[2,38,43,63,73,89,102],"is":[3],"a":[4,59,67],"critical":[5],"problem":[6,26,74],"in":[7,48,84],"many":[8],"applications":[9],"such":[10],"as":[11,35],"query":[12],"processing,":[13],"data":[14],"warehousing,":[15],"distributed":[16],"and":[17,108],"semantic":[18],"web":[19],"databases,":[20],"etc.":[21],"We":[22],"refer":[23],"to":[24,51],"the":[25,36,49,71,77,82,85,100],"of":[27,32,61,87,99],"selecting":[28],"an":[29],"appropriate":[30],"set":[31],"materialized":[33],"views":[34],"problem.":[39],"Many":[40],"different":[41],"methods":[44,103],"have":[45],"been":[46],"proposed":[47],"literature":[50],"address":[52],"this":[53,93,95],"issue.":[54],"The":[55],"present":[56],"paper":[57],"provides":[58],"survey":[60],"methods.":[64,90],"It":[65],"defines":[66],"framework":[68],"for":[69],"highlighting":[70],"by":[75,104],"identifying":[76,105],"main":[78],"dimensions":[79],"that":[80],"are":[81],"basis":[83],"classification":[86],"Based":[91],"on":[92],"classification,":[94],"study":[96],"reviews":[97],"most":[98],"respective":[106],"potentials":[107],"limits.":[109]},"counts_by_year":[{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":13},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":11},{"year":2018,"cited_by_count":10},{"year":2017,"cited_by_count":9},{"year":2016,"cited_by_count":10},{"year":2015,"cited_by_count":12},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":5}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}