Equivalence of aggregate queries is investigated for the class of conjunctive queries with
comparisons and the aggregate operators count, count-distinct, min, max, and sum …

Database-as-a-service offerings enable users to quickly create and deploy complex data
processing pipelines. In practice, these pipelines often exhibit significant overlap of …

How-To queries answer fundamental data analysis questions of the form:" How should the
input change in order to achieve the desired output". As a Reverse Data Management …

How can we tell when accounts are fake or real in a social network? And how can we tell
which accounts belong to liberal, conservative or centrist users? Often, we can answer such …

The problem of rewriting aggregate queries using views is studied for conjunctive queries
with arbitrary aggregation functions and built-in predicates. Two types of queries over views …

The rapid increase in data volumes and complexity of applied analytical tasks poses a big
challenge for visualization solutions. It is important to keep the experience highly interactive …

Without proper simplification techniques, database integrity checking can be prohibitively
time consuming. Several methods have been developed for producing simplified …

The query equivalence problem has been studied extensively for set-semantics and, more
recently, for bag and bag-set semantics. However, SQL queries often combine set, bag and …

The query equivalence problem has been studied extensively for set-semantics and, more
recently, for bag-set semantics. However, SQL queries often combine set and bag-set …

Integrity constraint checking, understood as the verification of data correctness and
wellformedness conditions that must be satisfied in any state of a database, is not fully …