Hypertree decompositions and tractable queries
@inproceedings{Gottlob1998HypertreeDA, title={Hypertree decompositions and tractable queries}, author={Georg Gottlob and Nicola Leone and Francesco Scarcello}, booktitle={ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems}, year={1998} }
1 A preliminary version of this paper appeared in the ‘‘Proceedings of the Eighteenth ACM Symposium on Principles of Database Systems (PODS’99),’’ pp. 21–32, Philadelphia, May 1999. Research supported by FWF (Austrian Science Funds) under the Project Z29-INF. Part of the work of Francesco Scarcello has been carried out while visiting the Technische Universitat Wien. Part of the work of Nicola Leone has been carried out while he was with the Technische Universitat Wien. Georg Gottlob
437 Citations
Hypertree Decompositions for Query Optimization
- Computer Science2007 IEEE 23rd International Conference on Data Engineering
- 2007
This paper defines an extension of the notion of hypertree decomposition, which is currently the most powerful structural method, and implements a hybrid optimizer, which can be used on top of available DBMSs to compute query plans.
Hypertree Decompositions: Questions and Answers
- Computer SciencePODS
- 2016
The present paper reviews' in form of questions and answers' the main relevant concepts and algorithms and surveys selected related work including applications and test results.
Query answering exploiting structural properties
- Computer Science, MathematicsSGMD
- 2005
We review the notion of hypertree width, a measure of the degree of cyclicity of hypergraphs that is useful for identifying and solving efficiently easy instances of hard problems, by exploiting…
A CSP Hypergraph Library
- Computer Science
- 2006
A collection of hypergraphs used to evaluate the authors' evaluation of hypertree decomposition algorithms, which were introduced by Gottlob et al. (6) as new structural decomposition method in constraint satisfaction.
Computing Optimal Hypertree Decompositions
- Computer ScienceALENEX
- 2020
This work proposes a new algorithmic method for computing the hypertree width of hypergraphs using a novel ordering based characterization ofhypertree width which lends to an efficient encoding to SAT modulo Theory (SMT).
Structural Decomposition Methods: Key Notions and Database Applications
- Computer ScienceA Comprehensive Guide Through the Italian Database Research
- 2018
This chapter describes structural decomposition methods that guarantee tractability for all problem instances whose associated hypergraphs have a small degree of cyclicity, called width, and focuses on the notion of hypertree width.
Hypertree Decompositions: A Survey
- Computer ScienceMFCS
- 2001
This paper surveys recent results related to the concept of hypertree decomposition and the associated notion ofhypertree width and reviews a number of complexity results on problems whose structure is described by acyclic or nearly acyClic hypergraphs.
ComputingOptimal Hypertree Decompositions
- Computer Science
- 2020
This work proposes a new algorithmic method for computing the hypertree width of hypergraphs using a novel ordering based characterization ofhypertree width which lends to an efficient encoding to SAT modulo Theory (SMT).
Optimal Join Algorithms Meet Top-k
- Computer ScienceSIGMOD Conference
- 2020
It is argued that the two areas of optimal join algorithms and ranked enumeration can and should be studied from a unified point of view in order to achieve optimality in the common model of computation for a very general class of top-k-style join queries.
Complexity of Conjunctive Query Answering under Access Limitations (Preliminary Report)
- Computer ScienceSEBD
- 2014
The problem of Boolean conjunctive query answering under access limitations is illustrated; the problem’s two main cases are defined and motivated; some preliminary results on its computational complexity are provided and some research directions are suggested.
References
SHOWING 1-10 OF 85 REFERENCES
On the complexity of database queries (extended abstract)
- Computer SciencePODS '97
- 1997
It is shown that, if the query size (or the number of variables in the query) is considered as a parameter, then the relational calculus and its fragments are classified at appropriate levels of the so-called W hierarchy of Downey and Fellows.
On the Complexity of Database Queries
- Computer ScienceJ. Comput. Syst. Sci.
- 1999
It is shown that, if the query size (or the number of variables in the query) is considered as a parameter, then the relational calculus and its fragments are classified at appropriate levels of the so-called W hierarchy of Downey and Fellows.
Decomposing Constraint Satisfaction Problems Using Database Techniques
- Computer ScienceArtif. Intell.
- 1994
The complexity of acyclic conjunctive queries
- Computer ScienceProceedings 39th Annual Symposium on Foundations of Computer Science (Cat. No.98CB36280)
- 1998
We show that the problem of evaluating acylic Boolean database-queries is LOGCFL-complete and thus highly parallelizable. We present a parallel database algorithm solving this problem with a…
Power of Natural Semijoins
- Computer ScienceSIAM J. Comput.
- 1981
This paper characterizes the queries for which full reducer exist and presents an efficient algorithm for constructing full reducers where they do exist and considers “natural” semijoin operator, which is used in the SDD-1 distributed database system.
Algorithms for Acyclic Database Schemes
- Computer ScienceVLDB
- 1981
The purpose in this paper is to describe efficient algorithms in this setting for various problems, such as computing projections, minimizing joins, inferring dependencies, and testing for dependency satisfaction.
On the Desirability of Acyclic Database Schemes
- Computer ScienceJACM
- 1983
It is shown that this class of database schemes, called acychc, has a number of desirable properties that have been studied by other researchers and are shown to be eqmvalent to acydicity.
On Tractable Queries and Constraints
- Computer ScienceDEXA
- 1999
This paper surveys recent results by the authors on tractable classes of conjunctive queries and constraint satisfaction problems and presents a new decomposition algorithm for such problems.
Optimal implementation of conjunctive queries in relational data bases
- Computer ScienceSTOC '77
- 1977
It is shown that while answering conjunctive queries is NP complete (general queries are PSPACE complete), one can find an implementation that is within a constant of optimal.