{"id":"https://openalex.org/W2422033479","doi":"https://doi.org/10.1145/2902251.2902294","title":"Bounded Query Rewriting Using Views","display_name":"Bounded Query Rewriting Using Views","publication_year":2016,"publication_date":"2016-06-15","ids":{"openalex":"https://openalex.org/W2422033479","doi":"https://doi.org/10.1145/2902251.2902294","mag":"2422033479"},"language":"en","primary_location":{"id":"doi:10.1145/2902251.2902294","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2902251.2902294","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.research.ed.ac.uk/en/publications/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101426208","display_name":"Yang Cao","orcid":"https://orcid.org/0000-0001-7984-3219"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Yang Cao","raw_affiliation_strings":["University of Edinburgh & Beihang University, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh & Beihang University, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070565287","display_name":"Wenfei Fan","orcid":"https://orcid.org/0000-0001-5149-2656"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Wenfei Fan","raw_affiliation_strings":["University of Edinburgh & Beihang University, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh & Beihang University, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087587379","display_name":"Floris Geerts","orcid":"https://orcid.org/0000-0002-8967-2473"},"institutions":[{"id":"https://openalex.org/I149213910","display_name":"University of Antwerp","ror":"https://ror.org/008x57b05","country_code":"BE","type":"education","lineage":["https://openalex.org/I149213910"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Floris Geerts","raw_affiliation_strings":["University of Antwerp, Antwerpen, Belgium"],"affiliations":[{"raw_affiliation_string":"University of Antwerp, Antwerpen, Belgium","institution_ids":["https://openalex.org/I149213910"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5013499387","display_name":"Ping L\u00fc","orcid":null},"institutions":[{"id":"https://openalex.org/I82880672","display_name":"Beihang University","ror":"https://ror.org/00wk2mp56","country_code":"CN","type":"education","lineage":["https://openalex.org/I82880672"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ping Lu","raw_affiliation_strings":["Beihang University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Beihang University, Beijing, China","institution_ids":["https://openalex.org/I82880672"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5101426208"],"corresponding_institution_ids":["https://openalex.org/I98677209"],"apc_list":null,"apc_paid":null,"fwci":2.3163,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.89330355,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"107","last_page":"119"},"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.9993000030517578,"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.9993000030517578,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9988999962806702,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9987999796867371,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.8198788166046143},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.8102552890777588},{"id":"https://openalex.org/keywords/bounded-function","display_name":"Bounded function","score":0.7515434622764587},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.6666795015335083},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6341274380683899},{"id":"https://openalex.org/keywords/fraction","display_name":"Fraction (chemistry)","score":0.5151294469833374},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.45573481917381287},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4478158950805664},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4167516827583313},{"id":"https://openalex.org/keywords/existential-quantification","display_name":"Existential quantification","score":0.4110344648361206},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.33942681550979614},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3138197064399719},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23064804077148438},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.22119557857513428},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.16215679049491882}],"concepts":[{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.8198788166046143},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.8102552890777588},{"id":"https://openalex.org/C34388435","wikidata":"https://www.wikidata.org/wiki/Q2267362","display_name":"Bounded function","level":2,"score":0.7515434622764587},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6666795015335083},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6341274380683899},{"id":"https://openalex.org/C149629883","wikidata":"https://www.wikidata.org/wiki/Q660926","display_name":"Fraction (chemistry)","level":2,"score":0.5151294469833374},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.45573481917381287},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4478158950805664},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4167516827583313},{"id":"https://openalex.org/C136979486","wikidata":"https://www.wikidata.org/wiki/Q773483","display_name":"Existential quantification","level":2,"score":0.4110344648361206},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.33942681550979614},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3138197064399719},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23064804077148438},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.22119557857513428},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.16215679049491882},{"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/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/2902251.2902294","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2902251.2902294","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"Cao, Y, Fan, W, Geerts, F & Lu, P 2016, Bounded Query Rewriting Using Views. in PODS '16 Proceedings of the 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. pp. 107-119, 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, San Francisco, California, United States, 26/06/16. https://doi.org/10.1145/2902251.2902294","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:pure.ed.ac.uk:publications/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","is_oa":false,"landing_page_url":"http://hdl.handle.net/20.500.11820/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""},{"id":"pmh:oai:pure.ed.ac.uk:publications/b9c346d9-ed2f-4d82-8af4-3c968a9aead3","is_oa":false,"landing_page_url":"http://hdl.handle.net/20.500.11820/b9c346d9-ed2f-4d82-8af4-3c968a9aead3","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""}],"best_oa_location":{"id":"pmh:oai:pure.ed.ac.uk:openaire/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/164ed9d7-1cef-46d4-8ef2-fccd05892ff9","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"Cao, Y, Fan, W, Geerts, F & Lu, P 2016, Bounded Query Rewriting Using Views. in PODS '16 Proceedings of the 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. pp. 107-119, 35th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, San Francisco, California, United States, 26/06/16. https://doi.org/10.1145/2902251.2902294","raw_type":"contributionToPeriodical"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10","score":0.550000011920929}],"awards":[{"id":"https://openalex.org/G3649347000","display_name":null,"funder_award_id":"EP/J015377/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G8400180575","display_name":null,"funder_award_id":"EP/M025268/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":50,"referenced_works":["https://openalex.org/W187851124","https://openalex.org/W193724012","https://openalex.org/W1495576170","https://openalex.org/W1524265383","https://openalex.org/W1525887080","https://openalex.org/W1541672808","https://openalex.org/W1542009890","https://openalex.org/W1549109831","https://openalex.org/W1558832481","https://openalex.org/W1802083805","https://openalex.org/W1853762380","https://openalex.org/W1920341779","https://openalex.org/W1952447191","https://openalex.org/W1975733288","https://openalex.org/W1992673035","https://openalex.org/W1994353670","https://openalex.org/W1999377429","https://openalex.org/W2008552727","https://openalex.org/W2010308380","https://openalex.org/W2011039300","https://openalex.org/W2013112375","https://openalex.org/W2023472553","https://openalex.org/W2027388991","https://openalex.org/W2031641275","https://openalex.org/W2033325972","https://openalex.org/W2042441172","https://openalex.org/W2042570369","https://openalex.org/W2049599857","https://openalex.org/W2050882124","https://openalex.org/W2057546223","https://openalex.org/W2058844036","https://openalex.org/W2065251436","https://openalex.org/W2065603413","https://openalex.org/W2066684585","https://openalex.org/W2079590017","https://openalex.org/W2088044688","https://openalex.org/W2099683594","https://openalex.org/W2104525376","https://openalex.org/W2152191782","https://openalex.org/W2166549982","https://openalex.org/W2254540169","https://openalex.org/W2264746323","https://openalex.org/W2440674561","https://openalex.org/W2476096155","https://openalex.org/W2489748212","https://openalex.org/W2545449716","https://openalex.org/W2753710282","https://openalex.org/W2963511602","https://openalex.org/W3150580898","https://openalex.org/W4298235694"],"related_works":["https://openalex.org/W2556786504","https://openalex.org/W2152149667","https://openalex.org/W4244527061","https://openalex.org/W2469357693","https://openalex.org/W3125756434","https://openalex.org/W1977383094","https://openalex.org/W2572349046","https://openalex.org/W42879793","https://openalex.org/W1779612025","https://openalex.org/W2413368787"],"abstract_inverted_index":{"A":[0],"query":[1,16],"Q":[2],"has":[3],"a":[4,8,15,28,43,55,60],"bounded":[5],"rewriting":[6],"using":[7],"set":[9,56],"of":[10,47,57,62,73,83],"views":[11,41],"if":[12],"there":[13],"exists":[14],"Q'":[17,36],"expressed":[18],"in":[19],"the":[20,70,76],"same":[21],"language":[22],"as":[23],"Q,":[24],"such":[25,68],"that":[26,37,53,69],"given":[27],"dataset":[29],"D,":[30],"Q(D)":[31],"can":[32],"be":[33],"computed":[34],"by":[35],"accesses":[38],"only":[39],"cached":[40],"and":[42,65,75],"small":[44],"fraction":[45],"DQ":[46,74,80],"D.":[48],"We":[49],"consider":[50],"datasets":[51],"D":[52,89],"satisfy":[54],"access":[58],"constraints,":[59],"combination":[61],"cardinality":[63],"constraints":[64],"associated":[66],"indices,":[67],"size":[71],"|DQ|":[72],"time":[77],"to":[78],"identify":[79],"are":[81],"independent":[82],"|D|,":[84],"no":[85],"matter":[86],"how":[87],"big":[88],"is.":[90]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}