Mathematicians crack efficiency limits for database query operations
Researchers have defined when database systems can efficiently handle complex queries using a restricted set of logical operations. The finding resolves a decades-old question about computational limits, offering database engineers clearer design rules for building faster systems that can handle larger datasets without exponential slowdowns.
Originaltitel: The power of primitive positive definitions with polynomially many variables
<p>Two well-studied closure operators for relations are based on existentially quantified conjunctive formulas, primitive positive (p.p.) definitions, and primitive positive formulas without existential quantification, quantifier-free primitive positive definitions (q.f.p.p.) definitions. Sets of relations closed under p.p. definitions are known as co-clones and sets of relations closed under q.f.p.p. definitions as weak partial co-clones. The latter do however have limited expressivity, and the corresponding lattice of strong partial clones is of uncountably infinite cardinality even for the Boolean domain. Hence, it is reasonable to consider the expressiveness of p.p. definitions where only a small number of existentially quantified variables are allowed. In this article, we consider p.p. definitions allowing only polynomially many existentially quantified variables, and say that a co-clone closed under such definitions is polynomially closed, and otherwise superpolynomially closed. We investigate properties of polynomially closed co-clones and prove that if the corresponding clone contains a k-ary near-unanimity operation for k amp;gt;= 3, then the co-clone is polynomially closed, and if the clone does not contain a k-edge operation for any k amp;gt;= 2, then the co-clone is superpolynomially closed. For the Boolean domain we strengthen these results and prove a complete dichotomy theorem separating polynomially closed co-clones from superpolynomially closed co-clones. Using these results, we then proceed to investigate properties of strong partial clones corresponding to superpolynomially closed co-clones. We prove that if Gamma is a finite set of relations over an arbitrary finite domain such that the clone corresponding to Gamma is essentially unary, then the strong partial clone corresponding to Gamma is of infinite order and cannot be generated by a finite set of partial functions.</p>