Consistency, Acyclicity, and Positive Semirings

09/20/2020
by   Albert Atserias, et al.
0

In several different settings, one comes across situations in which the objects of study are locally consistent but globally inconsistent. Earlier work about probability distributions by Vorob'ev (1962) and about database relations by Beeri, Fagin, Maier, Yannakakis (1983) produced characterizations of when local consistency always implies global consistency. Towards a common generalization of these results, we consider K-relations, that is, relations over a set of attributes such that each tuple in the relation is associated with an element from an arbitrary, but fixed, positive semiring K. We introduce the notions of projection of a K-relation, consistency of two K-relations, and global consistency of a collection of K-relations; these notions are natural extensions of the corresponding notions about probability distributions and database relations. We then show that a collection of sets of attributes has the property that every pairwise consistent collection of K-relations over those attributes is globally consistent if and only if the sets of attributes form an acyclic hypergraph. This generalizes the aforementioned results by Vorob'ev and by Beeri et al., and demonstrates that K-relations over positive semirings constitute a natural framework for the study of the interplay between local and global consistency. In the course of the proof, we introduce a notion of join of two K-relations and argue that it is the "right" generalization of the join of two database relations. Furthermore, to show that non-acyclic hypergraphs yield pairwise consistent K-relations that are globally inconsistent, we generalize a construction by Tseitin (1968) in his study of hard-to-prove tautologies in propositional logic.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
12/22/2020

Structure and Complexity of Bag Consistency

Since the early days of relational databases, it was realized that acycl...
research
08/20/2022

Safe Subjoins in Acyclic Joins

It is expensive to compute joins, often due to large intermediate relati...
research
08/27/2022

Paraconsistent logic and query answering in inconsistent databases

This paper concerns the paraconsistent logic LPQ^⊃,𝖥 and an application ...
research
05/22/2017

Compatible extensions and consistent closures: a fuzzy approach

In this paper ∗--compatible extensions of fuzzy relations are studied, g...
research
10/26/2022

Quantifying the Loss of Acyclic Join Dependencies

Acyclic schemas possess known benefits for database design, speeding up ...
research
03/12/2020

Querying and Repairing Inconsistent Prioritized Knowledge Bases: Complexity Analysis and Links with Abstract Argumentation

In this paper, we explore the issue of inconsistency handling over prior...
research
08/01/2023

Metrics to Quantify Global Consistency in Synthetic Medical Images

Image synthesis is increasingly being adopted in medical image processin...

Please sign up or login with your details

Forgot password? Click here to reset