Answering Aggregate Queries with Ordered Direct Access

Idan Eldar, Nofar Carmeli, Benny Kimelfeld

Research output: Contribution to journalConference articlepeer-review


The paper presents recent findings on the fine-grained complexity of conjunctive queries with aggregation. For common aggregate functions (e.g., min, max, sum), such a query can be phrased as an ordinary conjunctive query over a database annotated with a suitable commutative semiring. We investigate the ability to evaluate queries by constructing in log-linear time a data structure that provides logarithmic-time direct access to the answers, ordered by a lexicographic order of choice. Importantly, these complexity guarantees hold even if the result of the query is asymptotically larger than log-linear in the size of the input.

Original languageEnglish
JournalCEUR Workshop Proceedings
StatePublished - 2023
Event15th Alberto Mendelzon International Workshop on Foundations of Data Management, AMW 2023 - Santiago de Chile, Chile
Duration: 22 May 202326 May 2023

ASJC Scopus subject areas

  • General Computer Science


Dive into the research topics of 'Answering Aggregate Queries with Ordered Direct Access'. Together they form a unique fingerprint.

Cite this