{"id":"https://openalex.org/W2066684585","doi":"https://doi.org/10.1145/1806907.1806913","title":"Views and queries","display_name":"Views and queries","publication_year":2010,"publication_date":"2010-07-01","ids":{"openalex":"https://openalex.org/W2066684585","doi":"https://doi.org/10.1145/1806907.1806913","mag":"2066684585"},"language":"en","primary_location":{"id":"doi:10.1145/1806907.1806913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1806907.1806913","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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 Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://inria.hal.science/hal-03664876","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005196571","display_name":"Alan Nash","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alan Nash","raw_affiliation_strings":["Aleph One LLC","Aleph One LLC (La Jolla, Californie - United States)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aleph One LLC","institution_ids":[]},{"raw_affiliation_string":"Aleph One LLC (La Jolla, Californie - United States)","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042411667","display_name":"Luc Segoufin","orcid":"https://orcid.org/0000-0002-9564-7581"},"institutions":[{"id":"https://openalex.org/I11559806","display_name":"\u00c9cole Normale Sup\u00e9rieure Paris-Saclay","ror":"https://ror.org/00hx6zz33","country_code":"FR","type":"education","lineage":["https://openalex.org/I11559806","https://openalex.org/I277688954"]},{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en sciences et technologies du num\u00e9rique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"government","lineage":["https://openalex.org/I1326498283"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Luc Segoufin","raw_affiliation_strings":["INRIA, ENS-Cachan, CACHAN Cedex, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INRIA, ENS-Cachan, CACHAN Cedex, France","institution_ids":["https://openalex.org/I11559806","https://openalex.org/I1326498283"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049457012","display_name":"Victor Vianu","orcid":"https://orcid.org/0000-0002-0671-4456"},"institutions":[{"id":"https://openalex.org/I36258959","display_name":"University of California San Diego","ror":"https://ror.org/0168r3w48","country_code":"US","type":"education","lineage":["https://openalex.org/I36258959"]},{"id":"https://openalex.org/I4210118524","display_name":"Universit\u00e9 Bourgogne Franche-Comt\u00e9","ror":"https://ror.org/02dn7x778","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210118524"]}],"countries":["FR","US"],"is_corresponding":false,"raw_author_name":"Victor Vianu","raw_affiliation_strings":["University of California San Diego, La Jolla, CA","CSE - UC San Diego - Department of Computer Science and Engineering [Univ California San Diego] (University of California, San Diego, Jacobs School of Engineering, 9500 Gilman Drive, La Jolla, CA 92093-0404 - United States)","UC San Diego - University of California [San Diego] (UCSD, 9500 Gilman Dr., La Jolla, CA 92093 USA - United States)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California San Diego, La Jolla, CA","institution_ids":["https://openalex.org/I36258959"]},{"raw_affiliation_string":"CSE - UC San Diego - Department of Computer Science and Engineering [Univ California San Diego] (University of California, San Diego, Jacobs School of Engineering, 9500 Gilman Drive, La Jolla, CA 92093-0404 - United States)","institution_ids":["https://openalex.org/I36258959","https://openalex.org/I4210118524"]},{"raw_affiliation_string":"UC San Diego - University of California [San Diego] (UCSD, 9500 Gilman Dr., La Jolla, CA 92093 USA - United States)","institution_ids":["https://openalex.org/I36258959"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":9.5253,"has_fulltext":false,"cited_by_count":111,"citation_normalized_percentile":{"value":0.97795465,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":"35","issue":"3","first_page":"1","last_page":"41"},"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.9983000159263611,"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.9983000159263611,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9969000220298767,"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/T12002","display_name":"Computability, Logic, AI Algorithms","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/rewriting","display_name":"Rewriting","score":0.8891499638557434},{"id":"https://openalex.org/keywords/determinacy","display_name":"Determinacy","score":0.8133610486984253},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7613034248352051},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.7303687334060669},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6261846423149109},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5175056457519531},{"id":"https://openalex.org/keywords/connection","display_name":"Connection (principal bundle)","score":0.4974513351917267},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4754990041255951},{"id":"https://openalex.org/keywords/completeness","display_name":"Completeness (order theory)","score":0.44167208671569824},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4348939061164856},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3112486004829407},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2111186981201172},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.16520550847053528}],"concepts":[{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.8891499638557434},{"id":"https://openalex.org/C58468513","wikidata":"https://www.wikidata.org/wiki/Q1201165","display_name":"Determinacy","level":2,"score":0.8133610486984253},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7613034248352051},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.7303687334060669},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6261846423149109},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5175056457519531},{"id":"https://openalex.org/C13355873","wikidata":"https://www.wikidata.org/wiki/Q2920850","display_name":"Connection (principal bundle)","level":2,"score":0.4974513351917267},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4754990041255951},{"id":"https://openalex.org/C17231256","wikidata":"https://www.wikidata.org/wiki/Q5156540","display_name":"Completeness (order theory)","level":2,"score":0.44167208671569824},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4348939061164856},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3112486004829407},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2111186981201172},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.16520550847053528},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"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/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1806907.1806913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1806907.1806913","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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 Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:HAL:hal-03664876v1","is_oa":true,"landing_page_url":"https://inria.hal.science/hal-03664876","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":"ACM Transactions on Database Systems, 2010, 35 (3), pp.1-41. ⟨10.1145/1806907.1806913⟩","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:HAL:hal-03664876v1","is_oa":true,"landing_page_url":"https://inria.hal.science/hal-03664876","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":"ACM Transactions on Database Systems, 2010, 35 (3), pp.1-41. ⟨10.1145/1806907.1806913⟩","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[{"score":0.8299999833106995,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G1121455012","display_name":null,"funder_award_id":"IIS-0705589","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W30540373","https://openalex.org/W51516856","https://openalex.org/W187851124","https://openalex.org/W1482193060","https://openalex.org/W1483892218","https://openalex.org/W1485145428","https://openalex.org/W1488575196","https://openalex.org/W1549008998","https://openalex.org/W1558832481","https://openalex.org/W1563590781","https://openalex.org/W1573537871","https://openalex.org/W1585278433","https://openalex.org/W1587829740","https://openalex.org/W1591670035","https://openalex.org/W1975733288","https://openalex.org/W1976580206","https://openalex.org/W1994840586","https://openalex.org/W1995332844","https://openalex.org/W1998141358","https://openalex.org/W2004405116","https://openalex.org/W2012078943","https://openalex.org/W2042570369","https://openalex.org/W2063770561","https://openalex.org/W2074669964","https://openalex.org/W2094394144","https://openalex.org/W2096375618","https://openalex.org/W2102635071","https://openalex.org/W2113582770","https://openalex.org/W2114633883","https://openalex.org/W2122816893","https://openalex.org/W2126004201","https://openalex.org/W2134483537","https://openalex.org/W2160983447","https://openalex.org/W2251809152","https://openalex.org/W2317970288","https://openalex.org/W2628596753","https://openalex.org/W2646887492","https://openalex.org/W3152223825","https://openalex.org/W4252933876","https://openalex.org/W6601223888","https://openalex.org/W6629417139"],"related_works":["https://openalex.org/W642373709","https://openalex.org/W1497581330","https://openalex.org/W1504820687","https://openalex.org/W4210495575","https://openalex.org/W1585460393","https://openalex.org/W16617677","https://openalex.org/W4252242530","https://openalex.org/W2155880381","https://openalex.org/W2102635071","https://openalex.org/W2097765725"],"abstract_inverted_index":{"We":[0,18,182],"investigate":[1,149],"the":[2,21,40,49,124,127,133,151,175],"question":[3,134],"of":[4,16,51,56,96,130,135,137,153,164,178],"whether":[5],"a":[6,13,59,63,75,101,138],"query":[7,68,102,112,170],"Q":[8,31,43,53,70,84,88,90,109],"can":[9,91],"be":[10,92],"answered":[11],"using":[12,58,100,114],"set":[14],"V":[15,29,33,57,66,82,97,99,107],"views.":[17],"first":[19],"define":[20],"problem":[22,50],"in":[23,54,94,103],"information-theoretic":[24,128],"terms:":[25],"we":[26,46,72,148],"say":[27,73],"that":[28,74],"determines":[30,108],"if":[32,86],"provides":[34],"enough":[35],"information":[36],"to":[37,42,126,158,188],"uniquely":[38],"determine":[39],"answer":[41],".":[44,110],"Next,":[45],"look":[47],"at":[48],"rewriting":[52,76,113,139,180],"terms":[55,95],"specific":[60,122],"language.":[61],"Given":[62],"view":[64,168],"language":[65,69,77,140],"and":[67,132,155,169],",":[71,105],"R":[78,104],"is":[79],"complete":[80,179],"for":[81,120,166],"-to-":[83],"rewritings":[85],"every":[87],"\u2208":[89,98],"rewritten":[93],"whenever":[106],"While":[111],"views":[115],"has":[116],"been":[117],"extensively":[118],"investigated":[119],"some":[121],"languages,":[123,171],"connection":[125,157],"notion":[129,152],"determinacy,":[131],"completeness":[136],"have":[141],"received":[142],"little":[143],"attention.":[144],"In":[145],"this":[146],"article":[147],"systematically":[150],"determinacy":[154,165],"its":[156],"rewriting.":[159],"The":[160],"results":[161],"concern":[162],"decidability":[163],"various":[167],"as":[172,174],"well":[173],"power":[176],"required":[177],"languages.":[181],"consider":[183],"languages":[184],"ranging":[185],"from":[186],"first-order":[187],"conjunctive":[189],"queries.":[190]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":11},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":14},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":10},{"year":2012,"cited_by_count":7}],"updated_date":"2026-08-26T07:47:46.906454","created_date":"2016-06-24T00:00:00"}