Conjunctive queries with negation and aggregation: A linear time characterization

H Zhao, AZ Fan, X Ouyang, P Koutris - … of the ACM on Management of …, 2024 - dl.acm.org
In this paper, we study the complexity of evaluating Conjunctive Queries with negation
(\cqneg). First, we present an algorithm with linear preprocessing time and constant delay …

Avoiding Materialisation for Guarded Aggregate Queries

M Lanzinger, R Pichler, A Selzer - arXiv preprint arXiv:2406.17076, 2024 - arxiv.org
Database systems are often confronted with queries that join many tables but ultimately only
output comparatively small aggregate information. Despite all advances in query …

[HTML][HTML] Temporal graph processing in modern memory hierarchies

A Baumstark, MA Jibril, KU Sattler - Information Systems, 2025 - Elsevier
Updates in graph DBMS lead to structural changes in the graph over time with different
intermediate states. Capturing these changes and their time is one of the main purposes of …

To rewrite or not to rewrite: Decision making in query optimization of SQL queries

D Böhm - 2024 - repositum.tuwien.at
A common challenge for database management systems (DBMSs) is efficiently evaluating
queries. The most basic queries are conjunctive queries (CQs), which are SELECT-FROM …

[图书][B] Finding Consistent Answers From Inconsistent Data: Systems, Algorithms, and Complexity

X Ouyang - 2023 - search.proquest.com
Most data analytical pipelines often encounter the problem of querying inconsistent data that
could violate pre-determined integrity constraints. Data cleaning is an extensively studied …

Relational Algorithms for Top-k Query Evaluation

Q Wang, Q Luo, Y Wang - Proceedings of the ACM on Management of …, 2024 - dl.acm.org
The evaluation of top-k conjunctive queries, a staple in business analysis, often requires
evaluating the conjunctive query prior to filtering the top-k results, leading to a significant …