Table of Contents
Fetching ...

Towards Parameterized Hardness on Maintaining Conjunctive Queries

Qichen Wang

Abstract

We investigate the fine-grained complexity of dynamically maintaining the result of fixed self-join free conjunctive queries under single-tuple updates. Prior work shows that free-connex queries can be maintained in update time $O(|D|^δ)$ for some $δ\in [0.5, 1]$, where $|D|$ is the size of the current database. However, a gap remains between the best known upper bound of $O(|D|)$ and lower bounds of $Ω(|D|^{0.5-ε})$ for any $ε\ge 0$. We narrow this gap by introducing two structural parameters to quantify the dynamic complexity of a conjunctive query: the height $k$ and the dimension $d$. We establish new fine-grained lower bounds showing that any algorithm maintaining a query with these parameters must incur update time $Ω(|D|^{1-1/\max(k,d)-ε})$, unless widely believed conjectures fail. These yield the first super-$\sqrt{|D|}$ lower bounds for maintaining free-connex queries, and suggest the tightness of current algorithms when considering arbitrarily large $k$ and~$d$. Complementing our lower bounds, we identify a data-dependent parameter, the generalized $H$-index $h(D)$, which is upper bounded by $|D|^{1/d}$, and design an efficient algorithm for maintaining star queries, a common class of height 2 free-connex queries. The algorithm achieves an instance-specific update time $O(h(D)^{d-1})$ with linear space $O(|D|)$. This matches our parameterized lower bound and provides instance-specific performance in favorable cases.

Towards Parameterized Hardness on Maintaining Conjunctive Queries

Abstract

We investigate the fine-grained complexity of dynamically maintaining the result of fixed self-join free conjunctive queries under single-tuple updates. Prior work shows that free-connex queries can be maintained in update time for some , where is the size of the current database. However, a gap remains between the best known upper bound of and lower bounds of for any . We narrow this gap by introducing two structural parameters to quantify the dynamic complexity of a conjunctive query: the height and the dimension . We establish new fine-grained lower bounds showing that any algorithm maintaining a query with these parameters must incur update time , unless widely believed conjectures fail. These yield the first super- lower bounds for maintaining free-connex queries, and suggest the tightness of current algorithms when considering arbitrarily large and~. Complementing our lower bounds, we identify a data-dependent parameter, the generalized -index , which is upper bounded by , and design an efficient algorithm for maintaining star queries, a common class of height 2 free-connex queries. The algorithm achieves an instance-specific update time with linear space . This matches our parameterized lower bound and provides instance-specific performance in favorable cases.
Paper Structure (44 sections, 25 theorems, 15 equations, 5 figures, 1 algorithm)

This paper contains 44 sections, 25 theorems, 15 equations, 5 figures, 1 algorithm.

Key Result

theorem 1

Let $Q$ be a height $k$ query with $k\ge2$. Assuming combinatorial $k$-clique conjecture, no dynamic combinatorial algorithm can maintain $Q$ with amortized update time $O(|D|^{(k-1)/k-\epsilon})$ and support constant delay enumeration for any constant $\epsilon>0$.

Figures (5)

  • Figure 1: Query Hierarchy with $\omega(Q)=1$.
  • Figure 2: Relational Hypergraph
  • Figure 3: Generalized Join Tree
  • Figure 4: $\mathcal{N}$ and $\mathcal{V}_k(\mathcal{N})$ for $\{x_5\}$
  • Figure 6: Hypergraph for $Q$, where solid dots represent the output attributes.

Theorems & Definitions (48)

  • theorem 1: height-based lower bound
  • theorem 2: Dimension-based lower bound
  • proposition 1
  • theorem 3: Algorithm for Star Queries
  • definition 1: Relational Hypergraph
  • theorem 4: bagan2007acyclic
  • theorem 5: bagan2007acyclic
  • theorem 6: wang2023changeidris17:_dynampods25
  • theorem 7: berkholz17:_answer,Theorem 1.1
  • definition 2: Ears
  • ...and 38 more