Approximate Lifted Inference with Probabilistic Databases

12/02/2014
by   Wolfgang Gatterbauer, et al.
0

This paper proposes a new approach for approximate evaluation of #P-hard queries with probabilistic databases. In our approach, every query is evaluated entirely in the database engine by evaluating a fixed number of query plans, each providing an upper bound on the true probability, then taking their minimum. We provide an algorithm that takes into account important schema information to enumerate only the minimal necessary plans among all possible plans. Importantly, this algorithm is a strict generalization of all known results of PTIME self-join-free conjunctive queries: A query is safe if and only if our algorithm returns one single plan. We also apply three relational query optimization techniques to evaluate all minimal safe plans very fast. We give a detailed experimental evaluation of our approach and, in the process, provide a new way of thinking about the value of probabilistic methods over non-probabilistic methods for ranking query answers.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
03/27/2023

Learned Query Superoptimization

Traditional query optimizers are designed to be fast and stateless: each...
research
12/23/2019

Towards Deterministic Decomposable Circuits for Safe Queries

There exist two approaches for exact probabilistic inference of UCQs on ...
research
01/27/2022

Probabilistic Query Evaluation with Bag Semantics

We initiate the study of probabilistic query evaluation under bag semant...
research
07/29/2019

Precomputing Datalog evaluation plans in large-scale scenarios

With the more and more growing demand for semantic Web services over lar...
research
11/10/2017

Size bounds and query plans for relational joins

Relational joins are at the core of relational algebra, which in turn is...
research
09/28/2022

Lazy Probabilistic Roadmaps Revisited

This paper describes a revision of the classic Lazy Probabilistic Roadma...
research
06/21/2018

Novel Selectivity Estimation Strategy for Modern DBMS

Selectivity estimation is important in query optimization, however accur...

Please sign up or login with your details

Forgot password? Click here to reset