TY - GEN
T1 - Deciding equivalences among aggregate queries
AU - Nutt, Werner
AU - Sagiv, Yehoshua
AU - Shurin, Sara
PY - 1998
Y1 - 1998
N2 - Equivalence of aggregate queries in investigated for the class of conjunctive queries with comparisons and the aggregate operators min, max, count, count-distinct, and sum. Essentially, this class contains all unnested SQL queries with the above aggregate operators, with a WHERE clause consisting of a conjunction of comparisons, and without a HAVING clause. The comparisons can be interpreted over either a dense order (over the rationals) or a discrete order (over the integers).
AB - Equivalence of aggregate queries in investigated for the class of conjunctive queries with comparisons and the aggregate operators min, max, count, count-distinct, and sum. Essentially, this class contains all unnested SQL queries with the above aggregate operators, with a WHERE clause consisting of a conjunction of comparisons, and without a HAVING clause. The comparisons can be interpreted over either a dense order (over the rationals) or a discrete order (over the integers).
UR - https://www.scopus.com/pages/publications/0031632472
U2 - 10.1145/275487.275512
DO - 10.1145/275487.275512
M3 - ???researchoutput.researchoutputtypes.contributiontobookanthology.conference???
AN - SCOPUS:0031632472
T3 - Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems
SP - 214
EP - 223
BT - Proceedings of the 17th ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, PODS 1998
PB - ACM
T2 - 17th ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, PODS 1998
Y2 - 1 June 1998 through 4 June 1998
ER -