arXiv · 2608.16570
Approximate Functional Dependencies---Implication Problem Revisited
Abstract
Functional dependencies are an important and well-studied class of database constraints that correspond to a notion expressed by dependence atoms in team logic. In practice, data often contain errors, so in some cases it might be useful to allow the database to have a small number of tuples that violate the desired dependency. V\"a\"an\"anen (2017) studied the axiomatisation of a notion of approximate dependence that specifies for each dependence atom how much of the database can be disregarded. We demonstrate that the interaction of approximate dependence atoms is more complicated than previously thought in the sense that there is a semantic consequence that is not captured by the inference rules introduced before. We show that V\"a\"an\"anen's axiomatisation is still complete in the restricted case of unary dependencies. We also consider the complexity of model checking for approximate dependence: it is NP-complete for disjunctions of two atoms and LOGSPACE-hard for individual atoms.
Explore related subjects
Keep this discovery
Nicolas Fröhlich, Matilda Häggblom, Åsa Hirvonen, Minna Hirvonen. 2026-08-17. Approximate Functional Dependencies---Implication Problem Revisited. https://arxiv.org/abs/2608.16570
Cite the original work for its findings. Save a collection to share your selection of sources.