{"id":"https://openalex.org/W2045141511","doi":"https://doi.org/10.1145/1142473.1142479","title":"Query evaluation using overlapping views","display_name":"Query evaluation using overlapping views","publication_year":2006,"publication_date":"2006-06-27","ids":{"openalex":"https://openalex.org/W2045141511","doi":"https://doi.org/10.1145/1142473.1142479","mag":"2045141511"},"language":"en","primary_location":{"id":"doi:10.1145/1142473.1142479","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142479","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-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/A5002102428","display_name":"Gang Gou","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"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Gang Gou","raw_affiliation_strings":["North Carolina State University, Raleigh, NC","North Carolina State University, Raleigh, NC;"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"North Carolina State University, Raleigh, NC;","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023902352","display_name":"Maxim Kormilitsin","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Maxim Kormilitsin","raw_affiliation_strings":["North Carolina State University, Raleigh, NC","North Carolina State University, Raleigh, NC;"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"North Carolina State University, Raleigh, NC;","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"last","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rada Chirkova","raw_affiliation_strings":["North Carolina State University, Raleigh, NC","North Carolina State University, Raleigh, NC;"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"North Carolina State University, Raleigh, NC;","institution_ids":["https://openalex.org/I137902535"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5002102428"],"corresponding_institution_ids":["https://openalex.org/I137902535"],"apc_list":null,"apc_paid":null,"fwci":3.3196,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":{"value":0.92656701,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"37","last_page":"48"},"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.9994000196456909,"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.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"}}],"keywords":[{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.7747215628623962},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7426122426986694},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6737279295921326},{"id":"https://openalex.org/keywords/soundness","display_name":"Soundness","score":0.6550654172897339},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.619867742061615},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5516515970230103},{"id":"https://openalex.org/keywords/mathematical-proof","display_name":"Mathematical proof","score":0.5216867923736572},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.5082168579101562},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.5053537487983704},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4764416813850403},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.46980080008506775},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4559623897075653},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4535360336303711},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.44965600967407227},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.4482444226741791},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4450252056121826},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4007638096809387},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.281232088804245},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.24188491702079773},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.23815235495567322},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1836625039577484},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.15374526381492615},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.10814696550369263}],"concepts":[{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.7747215628623962},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7426122426986694},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6737279295921326},{"id":"https://openalex.org/C39920170","wikidata":"https://www.wikidata.org/wiki/Q693083","display_name":"Soundness","level":2,"score":0.6550654172897339},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.619867742061615},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5516515970230103},{"id":"https://openalex.org/C108710211","wikidata":"https://www.wikidata.org/wiki/Q11538","display_name":"Mathematical proof","level":2,"score":0.5216867923736572},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5082168579101562},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.5053537487983704},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4764416813850403},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.46980080008506775},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4559623897075653},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4535360336303711},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.44965600967407227},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.4482444226741791},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4450252056121826},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4007638096809387},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.281232088804245},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24188491702079773},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.23815235495567322},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1836625039577484},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.15374526381492615},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.10814696550369263},{"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/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","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/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1142473.1142479","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142479","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W99733817","https://openalex.org/W187851124","https://openalex.org/W1485145428","https://openalex.org/W1488870204","https://openalex.org/W1527733826","https://openalex.org/W1562988957","https://openalex.org/W1569403765","https://openalex.org/W1581805425","https://openalex.org/W1975733288","https://openalex.org/W1979514837","https://openalex.org/W2027763082","https://openalex.org/W2048531653","https://openalex.org/W2068901259","https://openalex.org/W2072764742","https://openalex.org/W2079590017","https://openalex.org/W2090438868","https://openalex.org/W2097989803","https://openalex.org/W2104233490","https://openalex.org/W2113888164","https://openalex.org/W2132582487","https://openalex.org/W2152191782","https://openalex.org/W2153329411","https://openalex.org/W2160099956","https://openalex.org/W2160770337","https://openalex.org/W2171492933","https://openalex.org/W3005907268","https://openalex.org/W4244600136","https://openalex.org/W6631453627","https://openalex.org/W6633961643","https://openalex.org/W6634765471"],"related_works":["https://openalex.org/W1967430536","https://openalex.org/W3107700780","https://openalex.org/W1505212787","https://openalex.org/W3092785261","https://openalex.org/W2949144621","https://openalex.org/W2340557151","https://openalex.org/W3047081115","https://openalex.org/W3170346938","https://openalex.org/W4282550487","https://openalex.org/W2114334214"],"abstract_inverted_index":{"We":[0,140,331],"study":[1,334],"the":[2,21,35,38,74,104,128,194,202,244,261,300,336,340,348,355],"problem":[3],"of":[4,10,32,40,50,71,87,161,178,228,246,294,304,335,350,357],"finding":[5],"efficient":[6,186,221,266,286,309],"equivalent":[7,267],"view-based":[8,268],"rewritings":[9,160,232],"relational":[11],"queries,":[12,119],"focusing":[13],"on":[14,142,159,175,273],"query":[15,46,83,254,269,358],"optimization":[16,359],"using":[17,43,360],"materialized":[18,295],"views":[19,44,236],"under":[20,77],"assumption":[22],"that":[23,112,148,167,182,233,284,346],"base":[24],"relations":[25],"cannot":[26],"contain":[27],"duplicate":[28],"tuples.":[29],"A":[30],"lot":[31],"work":[33,144],"in":[34,131,198,204,292,316,339],"literature":[36],"addresses":[37,73],"problems":[39,75,106,203],"answering":[41],"queries":[42,61,66,110,136,163,230,291,328],"and":[45,85,117,126,171,191,200,215,223,282,323,342,353],"optimization.":[47],"However,":[48],"most":[49,70],"it":[51,72,88],"proposes":[52,89],"solutions":[53],"for":[54,59,64,82,94,213,226,289,325],"special":[55],"cases,":[56,318],"such":[57],"as":[58,187,189],"conjunctive":[60,116],"(CQs)":[62],"or":[63,79,96],"aggregate":[65,118],"only.":[67],"In":[68,98],"addition,":[69],"separately":[76],"set":[78,216],"bag-set":[80,214],"semantics":[81],"evaluation,":[84],"some":[86,317],"heuristics":[90],"without":[91],"formal":[92],"proofs":[93],"completeness":[95],"soundness.":[97],"this":[99,150,205],"paper":[100],"we":[101,196,208,219,276,329],"look":[102],"at":[103],"two":[105,210,278],"by":[107],"considering":[108],"CQ/A":[109,162,229,290,327],"-":[111],"is,":[113],"both":[114],"pure":[115],"with":[120,241],"aggregation":[121],"functions":[122],"SUM,":[123],"COUNT,":[124],"MIN,":[125],"MAX;":[127],"DISTINCT":[129],"keyword":[130],"(SQL":[132],"versions":[133],"of)":[134],"our":[135,183,351],"is":[137,154,181,263,313,321],"also":[138,314],"allowed.":[139],"build":[141],"past":[143],"to":[145,231,243,253,257,264],"provide":[146,343],"algorithms":[147,173,184,238,298],"handle":[149],"general":[151,206],"setting.":[152],"This":[153],"possible":[155],"because":[156],"recent":[157],"results":[158,249,275,345],"[1,":[164],"8]":[165],"show":[166,347],"there":[168],"are":[169,185,239],"sound":[170,190,222,279,310,322],"complete":[172,224,240,315,324],"based":[174,272],"containment":[176],"tests":[177,225],"CQs.Our":[179],"focus":[180],"well":[188],"complete.":[192],"Besides":[193],"contribution":[195],"make":[197,209],"putting":[199],"addressing":[201],"setting,":[207],"additional":[211],"contributions":[212],"semantics.":[217],"First,":[218],"propose":[220,277],"equivalence":[227],"use":[234],"overlapping":[235,361],"(the":[237],"respect":[242],"language":[245],"rewritings).":[247],"These":[248],"apply":[250],"not":[251],"only":[252],"optimization,":[255],"but":[256],"all":[258,326],"areas":[259],"where":[260],"goal":[262],"obtain":[265],"rewritings.":[270],"Second,":[271],"these":[274],"algorithms,":[280,341],"BDPV":[281,312],"CDPV,":[283],"find":[285],"execution":[287],"plans":[288],"terms":[293],"views.":[296,362],"Both":[297],"extend":[299],"cost-based":[301],"query-optimization":[302],"approach":[303,352],"System":[305],"R":[306],"[19].":[307],"The":[308],"algorithm":[311],"whereas":[319],"CDPV":[320],"consider.":[330],"present":[332],"a":[333],"completeness-efficiency":[337],"tradeoff":[338],"experimental":[344],"viability":[349],"test":[354],"limits":[356]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}