HyperTrac:hypergraph Decompositions and Tractability
HyperTrac:hypergraph Decompositions and Tractability
Disciplines
Computer Sciences (100%)
Keywords
-
Conjunctive Queries,
Hypergraph Decompositions,
Constraint Satisfaction Problems,
Tractability
Conjunctive Queries (CQs, also known as Select-From-Where queries in the database query language SQL) are the most fundamental form of database queries. Likewise, Constraint Satisfaction Problems (CSPs) are a fundamental task in the Artificial Intelligence domain. Both problems are known to have high complexity. Therefore, the search for classes of CQs and CSPs with lower complexity has been an active research area for many years. An important tool for identifying such classes of CQs and CSPs with lower complexity are so-called hypergraph decompositions. These techniques have been successfully applied to CSP solving and have meanwhile also been integrated into commercial database systems. There are several types of hypergraph decompositions in the literature, namely hypertree decompositions (HDs), their generalization to generalized hypertree decompositions (GHDs) and the yet more general fractional hypertree decompo- sitions (FHDs). However, the computation of an appropriate HD, GHD, or FHD is itself a demanding problem. Algorithms for this task exist, but they typically only work well for small Conjunctive Queries or small Constraint Satisfaction Problems. In this project, we will tackle the problem of computing various forms of hypergraph decompositions (namely HDs, GHDs, and FHDs) both from a theoretical and practical point of view. On the one hand, we aim at the development of new algorithms that outperform existing ones. On the other hand, we want to identify meaningful restrictions of the CQs or CSPs under consideration to allow for yet more efficient decomposition algorithms.
Answering queries posed by the user to a database or finding solutions that satisfy certain constraints specified by the user are fundamental problems in computer science. However, these are non-trivial problems and even modern computers may struggle to solve them in an acceptable time. Consequently, various methods have been proposed in the literature for decomposing a given problem and to use the resulting decompositions to find solutions faster. Intuitively, such decompositions split a complex computation task into smaller, manageable subtasks. However, also the problem of finding a good decomposition may be challenging. In this project, we therefore pursued two main directions: First, we significantly improved upon previous methods for computing decompositions. We applied several methods to achieve this goal: on the one hand, we designed parallel algorithms that can run on a cluster of computers. On the other hand, we analysed problem instances typically occurring in practice and identified structural properties of these problem instances. We have then exploited these properties to design more efficient algorithms. As a byproduct of this work, we created a benchmark of problem instances that can be (and already has been) used for experimental evaluations also by other groups designing algorithms in this area. Second, we worked on fast solution methods - many of them using decompositions - for various problems in the areas of Databases and Artificial Intelligence. In case of the Database area, we have thus proposed novel techniques for query evaluation and optimization of various query languages. In the Artificial Intelligence area, we have targeted various problems from areas as diverse as Computational Social Choice and Reasoning. However, in particular, in the area of query evaluation and optimization, the use of decomposition-based methods has not yet entered industrial-strength programmes. This is at least partly due to the fact that the computation of decompositions has been considered as a difficult and hence time-consuming task. With the progress made in this project with the development of new algorithms (and publicly available software tools implementing these algorithms) for computing decompositions, this should no longer be an obstacle. Hence, the natural next step will be to integrate decomposition-based techniques into state-of-the-art database systems.
- Technische Universität Wien - 100%
- Gianluigi Greco, Universita della Calabria - Italy
- Francesco Scarcello, Università di Calabria - Italy
- Nicola Leone, Università di Calabria - Italy
- Christopher Re, Stanford University - USA
- Dan Olteanu, University of Oxford
- Stanislav Zivny, University of Oxford
Research Output
- 196 Citations
- 71 Publications
- 3 Methods & Materials
- 2 Scientific Awards
- 1 Fundings
-
2024
Title Fast Parallel Hypertree Decompositions in Logarithmic Recursion Depth DOI 10.1145/3638758 Type Journal Article Author Gottlob G Journal ACM Transactions on Database Systems -
2018
Title On the Enumeration Complexity of Unions of Conjunctive Queries DOI 10.48550/arxiv.1812.03831 Type Preprint Author Carmeli N -
2018
Title HyperBench: A Benchmark and Tool for Hypergraphs and Empirical Findings DOI 10.48550/arxiv.1811.08181 Type Preprint Author Fischl W -
2018
Title General and Fractional Hypertree Decompositions DOI 10.1145/3196959.3196962 Type Conference Proceeding Abstract Author Fischl W Pages 17-32 -
2022
Title Convergence of Datalog over (Pre-) Semirings Type Conference Proceeding Abstract Author Hung Q. Ngo Conference PODS '22: International Conference on Management of Data Pages 105-117 -
2022
Title Datalog in Wonderland Type Journal Article Author Hung Q Ngo Journal SIGMOD Record Pages 6-17 -
2022
Title Optimizing Recursive Queries with Progam Synthesis Type Conference Proceeding Abstract Author Mahmoud Abo Khamis Conference SIGMOD '22: International Conference on Management of Data Pages 79-93 -
2022
Title Fast Parallel Hypertree Decompositions in Logarithmic Recursion Depth Type Conference Proceeding Abstract Author Georg Gottlob Conference PODS '22: International Conference on Management of Data Pages 325-336 -
2022
Title Family Link Detection in Uncertain Settings with MV-Datalog Type Conference Proceeding Abstract Author Marta Bernardini Conference EDBT/ICDT Workshops 2022 -
2022
Title New Perspectives for Fuzzy Datalog (Extended Abstract) Type Conference Proceeding Abstract Author Matthias Lanzinger Conference 4th International Workshop on the Resurgence of Datalog in Academia and Industry (Datalog-2.0 2022) co-located with the 16th International Conference on Logic Programming and Nonmonotonic Reasoning (LPNMR} 2022) Pages 42-47 -
2021
Title HyperBench DOI 10.1145/3440015 Type Journal Article Author Fischl W Journal Journal of Experimental Algorithmics (JEA) Pages 1-40 -
2021
Title On the Enumeration Complexity of Unions of Conjunctive Queries DOI 10.1145/3450263 Type Journal Article Author Carmeli N Journal ACM Transactions on Database Systems (TODS) Pages 1-41 Link Publication -
2021
Title Complexity Analysis of Generalized and Fractional Hypertree Decompositions DOI 10.1145/3457374 Type Journal Article Author Gottlob G Journal Journal of the ACM (JACM) Pages 1-50 Link Publication -
2021
Title Fast Parallel Hypertree Decompositions in Logarithmic Recursion Depth DOI 10.48550/arxiv.2104.13793 Type Preprint Author Gottlob G -
2021
Title Tractability Beyond {\beta}-Acyclicity for Conjunctive Queries with Negation Type Conference Proceeding Abstract Author Matthias Lanzinger Conference PODS'21: Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems Pages 355-369 -
2020
Title Fractional Covers of Hypergraphs with Bounded Multi-Intersection Type Conference Proceeding Abstract Author Georg Gottlob Conference MFCS 2020 - 45th International Symposium on Mathematical Foundations of Computer Science -
2020
Title The HyperTrac Project: Recent Progress and Future Research Directions on Hypergraph Decompositions DOI 10.1007/978-3-030-58942-4_1 Type Book Chapter Author Gottlob G Publisher Springer Nature Pages 3-21 -
2020
Title HyperBench: A Benchmark and Tool for Hypergraphs and Empirical Findings DOI 10.48550/arxiv.2009.01769 Type Preprint Author Fischl W -
2020
Title Characterizing Tractability of Simple Well-Designed Pattern Trees with Projection DOI 10.1007/s00224-020-10002-z Type Journal Article Author Mengel S Journal Theory of Computing Systems Pages 3-41 Link Publication -
2019
Title A complexity theory for hard enumeration problems DOI 10.1016/j.dam.2019.02.025 Type Journal Article Author Creignou N Journal Discrete Applied Mathematics Pages 191-209 Link Publication -
2018
Title Efficient Evaluation and Static Analysis for Well-Designed Pattern Trees with Projection DOI 10.1145/3233983 Type Journal Article Author Barceló P Journal ACM Transactions on Database Systems (TODS) Pages 1-44 -
2020
Title Semantic Width and the Fixed-Parameter Tractability of Constraint Satisfaction Problems DOI 10.24963/ijcai.2020/239 Type Conference Proceeding Abstract Author Chen H Pages 1726-1733 Link Publication -
2020
Title Fractional Covers of Hypergraphs with Bounded Multi-Intersection DOI 10.48550/arxiv.2007.01830 Type Preprint Author Gottlob G -
2020
Title Fast and Parallel Decomposition of Constraint Satisfaction Problems DOI 10.24963/ijcai.2020/161 Type Conference Proceeding Abstract Author Gottlob G Pages 1155-1162 Link Publication -
2020
Title Proportional Belief Merging DOI 10.1609/aaai.v34i03.5671 Type Journal Article Author Haret A Journal Proceedings of the AAAI Conference on Artificial Intelligence Pages 2822-2829 Link Publication -
2020
Title Tractability Beyond $\beta$-Acyclicity for Conjunctive Queries with Negation DOI 10.48550/arxiv.2007.08876 Type Preprint Author Lanzinger M -
2020
Title Semantic Width and the Fixed-Parameter Tractability of Constraint Satisfaction Problems DOI 10.48550/arxiv.2007.14169 Type Preprint Author Chen H -
2020
Title The HyperTrac Project: Recent Progress and Future Research Directions on Hypergraph Decompositions DOI 10.48550/arxiv.2012.14762 Type Preprint Author Gottlob G -
2020
Title Lower Bounds for QBFs of Bounded Treewidth DOI 10.1145/3373718.3394756 Type Conference Proceeding Abstract Author Fichte J Pages 410-424 Link Publication -
2019
Title On the Enumeration Complexity of Unions of Conjunctive Queries Type Conference Proceeding Abstract Author Markus Kröll Conference PODS 2019 - 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems Pages 134-148 -
2019
Title Complexity Bounds for Relational Algebra over Document Spanners Type Conference Proceeding Abstract Author Dominik Freydenberger Conference PODS 2019 - 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems Pages 320-334 -
2019
Title Characterizing Tractability of Simple Well-Designed Pattern Trees with Projection Type Conference Proceeding Abstract Author Sebastian Skritek Conference ICDT 2019 - 22nd International Conference on Database Theory -
2019
Title HyperBench: A Benchmark and Tool for Hypergraphs and Empirical Findings Type Conference Proceeding Abstract Author Georg Gottlob Conference AMW 2019 - 13th Alberto Mendelzon International Workshop on Foundations of Data Management -
2019
Title Towards Reconciling Certain Answers and SPARQL: Bag Semantics to the Rescue? Type Conference Proceeding Abstract Author Skritek S. Conference 13th Alberto Mendelzon International Workshop on Foundations of Data Management, AMW 2019 -
2019
Title Semantic Width Revisited (Extended Abstract) Type Conference Proceeding Abstract Author Gottlob G. Conference 13th Alberto Mendelzon International Workshop on Foundations of Data Management, AMW 2019 -
2019
Title Parallel Computation of Generalized Hypertree Decompositions Type Conference Proceeding Abstract Author C. Okulmus Conference Proceedings of the 13th Alberto Mendelzon International Workshop on Foundations of Data Management, AMW 2019 -
2019
Title HyperBench: A Benchmark and Tool for Hypergraphs and Empirical Findings Type Conference Proceeding Abstract Author D. Longo Conference PODS 2019 - 38th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems Pages 464-480 -
2019
Title Datalog: Bag Semantics via Set Semantics Type Conference Proceeding Abstract Author Bertossi L. -
2023
Title Fractional covers of hypergraphs with bounded multi-intersection DOI 10.1016/j.tcs.2023.114204 Type Journal Article Author Gottlob G Journal Theoretical Computer Science -
2023
Title Tractability beyond -acyclicity for conjunctive queries with negation and SAT DOI 10.1016/j.tcs.2022.12.002 Type Journal Article Author Lanzinger M Journal Theoretical Computer Science -
2019
Title HyperBench DOI 10.1145/3294052.3319683 Type Conference Proceeding Abstract Author Fischl W Pages 464-480 -
2019
Title Complexity Bounds for Relational Algebra over Document Spanners DOI 10.1145/3294052.3319699 Type Conference Proceeding Abstract Author Peterfreund L Pages 320-334 Link Publication -
2022
Title Tractability Beyond ?-Acyclicity for Conjunctive Queries with Negation and Sat DOI 10.2139/ssrn.4132993 Type Preprint Author Lanzinger M Link Publication -
2022
Title Fast Parallel Hypertree Decompositions in Logarithmic Recursion Depth DOI 10.1145/3517804.3524153 Type Conference Proceeding Abstract Author Gottlob G Pages 325-336 Link Publication -
2022
Title Optimizing Recursive Queries with Progam Synthesis DOI 10.1145/3514221.3517827 Type Conference Proceeding Abstract Author Wang Y Pages 79-93 Link Publication -
2022
Title Fast and parallel decomposition of constraint satisfaction problems DOI 10.1007/s10601-022-09332-1 Type Journal Article Author Gottlob G Journal Constraints Pages 284-326 Link Publication -
2022
Title Convergence of Datalog over (Pre-) Semirings DOI 10.1145/3517804.3524140 Type Conference Proceeding Abstract Author Khamis M Pages 105-117 Link Publication -
2023
Title Diversity of Answers to Conjunctive Queries DOI 10.48550/arxiv.2301.08848 Type Other Author Merkl T Link Publication -
2021
Title Tractability Beyond ß-Acyclicity for Conjunctive Queries with Negation DOI 10.1145/3452021.3458308 Type Conference Proceeding Abstract Author Lanzinger M Pages 355-369 Link Publication -
2021
Title Efficiently enumerating minimal triangulations DOI 10.1016/j.dam.2020.05.034 Type Journal Article Author Carmeli N Journal Discrete Applied Mathematics Pages 216-236 Link Publication -
2022
Title Incremental Updates of Generalized Hypertree Decompositions DOI 10.1145/3578266 Type Journal Article Author Gottlob G Journal ACM Journal of Experimental Algorithmics Pages 1-28 Link Publication -
2023
Title Grounding Planning Tasks Using Tree Decompositions and Iterated Solving DOI 10.1609/icaps.v33i1.27184 Type Journal Article Author Corrêa A Journal Proceedings of the International Conference on Automated Planning and Scheduling -
2023
Title Incremental Updates of Generalized Hypertree Decompositions Type Journal Article Author Georg Gottlob Journal ACM Journal of Experimental Algorithms Pages 1-16 -
2018
Title General and Fractional Hypertree Decompositions: Hard and Easy Cases Type Conference Proceeding Abstract Author Reinhard Pichler Conference PODS 2018 - 37th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems Pages 17-32 -
2018
Title General and Fractional Hypertree Decompositions: Hard and Easy Cases (extended abstract) Type Conference Proceeding Abstract Author Georg Gottlob Conference 12th Alberto Mendelzon International Workshop on Foundations of Data Management Pages 1-4 -
2018
Title Datalog: Bag Semantics via Set Semantics DOI 10.48550/arxiv.1803.06445 Type Preprint Author Bertossi L Link Publication -
2018
Title Proceedings of the 37th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, PODS '18 DOI 10.1145/3196959 Type Journal Article -
2018
Title Computing the Schulze Method for Large-Scale Preference Data Sets DOI 10.24963/ijcai.2018/25 Type Conference Proceeding Abstract Author Csar T Pages 180-187 Link Publication -
2022
Title Integration of Skyline Queries into Spark SQL DOI 10.48550/arxiv.2210.03718 Type Preprint Author Grasmann L -
2022
Title Incremental Updates of Generalized Hypertree Decompositions DOI 10.48550/arxiv.2209.10375 Type Preprint Author Gottlob G -
2022
Title MV-Datalog+-: Effective Rule-based Reasoning with Uncertain Observations DOI 10.1017/s1471068422000199 Type Journal Article Author Lanzinger M Journal Theory and Practice of Logic Programming Pages 678-692 Link Publication -
2022
Title Optimizing Recursive Queries with Program Synthesis DOI 10.48550/arxiv.2202.10390 Type Preprint Author Wang Y -
2022
Title MV-Datalog+-: Effective Rule-based Reasoning with Uncertain Observations DOI 10.48550/arxiv.2202.01718 Type Preprint Author Lanzinger M -
0
DOI 10.1145/3294052 Type Other -
0
DOI 10.1145/3517804 Type Other -
0
DOI 10.1145/3514221 Type Other -
2020
Title Fractional Covers of Hypergraphs with Bounded Multi-Intersection DOI 10.4230/lipics.mfcs.2020.41 Type Conference Proceeding Abstract Author Gottlob G Conference LIPIcs, Volume 170, MFCS 2020 Pages 41:1 - 41:14 Link Publication -
2020
Title Complexity Analysis of Generalized and Fractional Hypertree Decompositions DOI 10.48550/arxiv.2002.05239 Type Preprint Author Gottlob G -
2020
Title selp: A Single-Shot Epistemic Logic Program Solver DOI 10.1017/s1471068420000022 Type Journal Article Author Bichler M Journal Theory and Practice of Logic Programming Pages 435-455 Link Publication -
2020
Title selp: A Single-Shot Epistemic Logic Program Solver DOI 10.48550/arxiv.2001.01089 Type Preprint Author Bichler M -
2020
Title The Impact of Treewidth on Grounding and Solving of Answer Set Programs DOI 10.1613/jair.1.11515 Type Journal Article Author Bliem B Journal Journal of Artificial Intelligence Research Pages 35-80 Link Publication
-
2022
Title Keynote at Datalog 2.0 Workshop Type Personally asked as a key note speaker to a conference Level of Recognition Continental/International -
2020
Title Keynote at CPAIOR 2020 Type Personally asked as a key note speaker to a conference Level of Recognition Continental/International
-
2023
Title ICT2021 Type Research grant (including intramural programme) Start of Funding 2023 Funder Vienna Science and Technology Fund