Aggregate Queries on Sparse Databases

12/27/2019
by   Szymon Toruńczyk, et al.
0

We propose an algebraic framework for studying efficient algorithms for query evaluation, aggregation, enumeration, and maintenance under updates, on sparse databases. Our framework allows to treat those problems in a unified way, by considering various semirings, depending on the considered problem. As a concrete application, we propose a powerful query language extending first-order logic by aggregation in multiple semirings. We obtain an optimal algorithm for computing the answers of such queries on sparse databases. More precisely, given a database from a fixed class with bounded expansion, the algorithm computes in linear time a data structure which allows to enumerate the set of answers to the query, with constant delay between two outputs.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
10/16/2020

Enumerating Answers to First-Order Queries over Databases of Low Degree

A class of relational databases has low degree if for all δ>0, all but f...
research
01/11/2019

Dependency Weighted Aggregation on Factorized Databases

We study a new class of aggregation problems, called dependency weighted...
research
07/22/2019

Social Choice Methods for Database Aggregation

Knowledge can be represented compactly in multiple ways, from a set of p...
research
01/15/2021

Towards Approximate Query Enumeration with Sublinear Preprocessing Time

This paper aims at providing extremely efficient algorithms for approxim...
research
02/23/2018

Database Aggregation

Knowledge can be represented compactly in a multitude ways, from a set o...
research
07/29/2020

Aggregate Analytic Window Query over Spatial Data

Analytic window query is a commonly used query in the relational databas...
research
10/27/2022

Querying Incomplete Numerical Data: Between Certain and Possible Answers

Queries with aggregation and arithmetic operations, as well as incomplet...

Please sign up or login with your details

Forgot password? Click here to reset