{"id":"https://openalex.org/W2056907916","doi":"https://doi.org/10.1145/1219092.1219093","title":"Deciding equivalences among conjunctive aggregate queries","display_name":"Deciding equivalences among conjunctive aggregate queries","publication_year":2007,"publication_date":"2007-04-01","ids":{"openalex":"https://openalex.org/W2056907916","doi":"https://doi.org/10.1145/1219092.1219093","mag":"2056907916"},"language":"en","primary_location":{"id":"doi:10.1145/1219092.1219093","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1219092.1219093","pdf_url":null,"source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"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":"Journal of the ACM","raw_type":"journal-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/A5006348713","display_name":"Sara Cohen","orcid":"https://orcid.org/0000-0002-8482-9435"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Sara Cohen","raw_affiliation_strings":["Technion---Israel Institute of Technology, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion---Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038176802","display_name":"Werner Nutt","orcid":"https://orcid.org/0000-0002-9347-1885"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Werner Nutt","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bozen, Italy","[Free University of Bozen-Bolzano, Bozen, Italy]"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bozen, Italy","institution_ids":["https://openalex.org/I171543936"]},{"raw_affiliation_string":"[Free University of Bozen-Bolzano, Bozen, Italy]","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014143171","display_name":"Yehoshua Sagiv","orcid":null},"institutions":[{"id":"https://openalex.org/I197251160","display_name":"Hebrew University of Jerusalem","ror":"https://ror.org/03qxff017","country_code":"IL","type":"education","lineage":["https://openalex.org/I197251160"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Yehoshua Sagiv","raw_affiliation_strings":["Hebrew University, Jerusalem, Israel","Hebrew University , Jerusalem, Israel"],"affiliations":[{"raw_affiliation_string":"Hebrew University, Jerusalem, Israel","institution_ids":["https://openalex.org/I197251160"]},{"raw_affiliation_string":"Hebrew University , Jerusalem, Israel","institution_ids":["https://openalex.org/I197251160"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5006348713"],"corresponding_institution_ids":["https://openalex.org/I174306211"],"apc_list":null,"apc_paid":null,"fwci":4.2152,"has_fulltext":false,"cited_by_count":127,"citation_normalized_percentile":{"value":0.94803277,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":"54","issue":"2","first_page":"5","last_page":"5"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9965000152587891,"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.7410452961921692},{"id":"https://openalex.org/keywords/equivalence","display_name":"Equivalence (formal languages)","score":0.6416565775871277},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.6143693923950195},{"id":"https://openalex.org/keywords/logical-equivalence","display_name":"Logical equivalence","score":0.5363366007804871},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.49061885476112366},{"id":"https://openalex.org/keywords/characterization","display_name":"Characterization (materials science)","score":0.47478148341178894},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.47036999464035034},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.36802762746810913},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.27524369955062866},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.1664867103099823},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.15146422386169434}],"concepts":[{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.7410452961921692},{"id":"https://openalex.org/C2780069185","wikidata":"https://www.wikidata.org/wiki/Q7977945","display_name":"Equivalence (formal languages)","level":2,"score":0.6416565775871277},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.6143693923950195},{"id":"https://openalex.org/C70846408","wikidata":"https://www.wikidata.org/wiki/Q220433","display_name":"Logical equivalence","level":3,"score":0.5363366007804871},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.49061885476112366},{"id":"https://openalex.org/C2780841128","wikidata":"https://www.wikidata.org/wiki/Q5073781","display_name":"Characterization (materials science)","level":2,"score":0.47478148341178894},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.47036999464035034},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.36802762746810913},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.27524369955062866},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1664867103099823},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.15146422386169434},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"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":3,"locations":[{"id":"doi:10.1145/1219092.1219093","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1219092.1219093","pdf_url":null,"source":{"id":"https://openalex.org/S118992489","display_name":"Journal of the ACM","issn_l":"0004-5411","issn":["0004-5411","1557-735X"],"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":"Journal of the ACM","raw_type":"journal-article"},{"id":"pmh:oai:alma.39UBZ_INST:11291748200001241","is_oa":false,"landing_page_url":"http://dl.acm.org/citation.cfm?id=1219093","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:unibz.it:11291748200001241","is_oa":false,"landing_page_url":"https://bia.unibz.it/esploro/outputs/journalArticle/Deciding-equivalences-among-conjunctive-aggregate-queries/991006483097101241","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W150943429","https://openalex.org/W1488870204","https://openalex.org/W1505156281","https://openalex.org/W1512639828","https://openalex.org/W1519039476","https://openalex.org/W1527356121","https://openalex.org/W1527733826","https://openalex.org/W1561908196","https://openalex.org/W1562880585","https://openalex.org/W1592609929","https://openalex.org/W1967992696","https://openalex.org/W1969991082","https://openalex.org/W1979514837","https://openalex.org/W1986832527","https://openalex.org/W1992681763","https://openalex.org/W2004405116","https://openalex.org/W2007093013","https://openalex.org/W2013136702","https://openalex.org/W2028864278","https://openalex.org/W2029970296","https://openalex.org/W2043778692","https://openalex.org/W2048531653","https://openalex.org/W2055586952","https://openalex.org/W2056660085","https://openalex.org/W2071875892","https://openalex.org/W2072764742","https://openalex.org/W2075035440","https://openalex.org/W2077261730","https://openalex.org/W2079590017","https://openalex.org/W2083735344","https://openalex.org/W2086316704","https://openalex.org/W2090337980","https://openalex.org/W2094806969","https://openalex.org/W2095263945","https://openalex.org/W2105787964","https://openalex.org/W2114883263","https://openalex.org/W2119422073","https://openalex.org/W2122179278","https://openalex.org/W2134483537","https://openalex.org/W2144771279","https://openalex.org/W2148706674","https://openalex.org/W2153803014","https://openalex.org/W2154698489","https://openalex.org/W2160712524","https://openalex.org/W2160770337","https://openalex.org/W2163491591","https://openalex.org/W2913666752","https://openalex.org/W4236543541","https://openalex.org/W4246675303"],"related_works":["https://openalex.org/W4245655469","https://openalex.org/W2362240646","https://openalex.org/W2347992748","https://openalex.org/W2362689974","https://openalex.org/W1552914076","https://openalex.org/W4381893637","https://openalex.org/W2382586048","https://openalex.org/W4248117800","https://openalex.org/W2391201265","https://openalex.org/W2383356281"],"abstract_inverted_index":{"Equivalence":[0],"of":[1,9,41,44,75,94,104,122,124,159,207,210],"aggregate":[2,16,34],"queries":[3,11,30,83,108,126,145,169,180,187,211],"is":[4,90,118,135,140,155,216],"investigated":[5],"for":[6,78,116,168],"the":[7,15,32,64,72,79,110,165,171,182,186,197,205,208,213,220,224],"class":[8,26],"conjunctive":[10,125,144],"with":[12,31,36,59,67,84,109,146,170,181,212],"comparisons":[13,52,147,202],"and":[14,22,46,203],"operators":[17],"count,":[18],"count-distinct,":[19],"min,":[20,88],"max,":[21],"sum.":[23],"Essentially,":[24],"this":[25,138,175],"contains":[27],"unnested":[28],"SQL":[29],"above":[33],"operators,":[35],"a":[37,42,48,57,60,68,102,113],"where":[38],"clause":[39],"consisting":[40],"conjunction":[43],"comparisons,":[45,192],"without":[47,149],"having":[49],"clause.":[50],"The":[51],"are":[53,226],"either":[54,85,189],"interpreted":[55],"over":[56],"domain":[58],"dense":[61],"order":[62,70],"(like":[63,71],"rationals)":[65],"or":[66,87,191],"discrete":[69],"integers).":[73],"Characterizations":[74],"equivalence":[76,89,117,123,151,209],"differ":[77],"two":[80],"cases.":[81],"For":[82,107,130,143],"max":[86],"characterized":[91,156],"in":[92,120,157,223,228],"terms":[93,121,158],"dominance":[95],"mappings,":[96],"which":[97],"can":[98],"be":[99],"viewed":[100],"as":[101],"generalization":[103],"containment":[105],"mappings.":[106],"count-distinct":[111],"operator,":[112],"sufficient":[114],"condition":[115,139],"given":[119,222],"under":[127,152],"set":[128],"semantics.":[129],"some":[131],"special":[132],"cases,":[133],"it":[134],"shown":[136],"that":[137],"also":[141,167,177],"necessary.":[142],"but":[148,193],"aggregation,":[150],"bag-set":[153],"semantics":[154],"isomorphism.":[160],"This":[161],"characterization":[162,176,206],"essentially":[163],"remains":[164],"same":[166],"count":[172],"operator.":[173],"Moreover,":[174],"applies":[178],"to":[179],"sum":[183,214],"operator":[184,215],"if":[185],"have":[188],"constants":[190],"not":[194],"both.":[195],"In":[196],"general":[198],"case":[199],"(i.e.,":[200],"both":[201],"constants),":[204],"more":[217],"elaborate.":[218],"All":[219],"characterizations":[221],"paper":[225],"decidable":[227],"polynomial":[229],"space.":[230]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":7},{"year":2024,"cited_by_count":14},{"year":2023,"cited_by_count":17},{"year":2022,"cited_by_count":14},{"year":2021,"cited_by_count":8},{"year":2020,"cited_by_count":10},{"year":2019,"cited_by_count":11},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":9},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}