Skip to Main content Skip to Navigation
Preprints, Working Papers, ...

Handling Inconsistencies in Tables with Nulls and Functional Dependencies

Abstract : In this paper we address the problem of handling inconsistencies in tables with missing values (or nulls) and functional dependencies. Although the traditional view is that table instances must respect all functional dependencies imposed on them, it is nevertheless relevant to develop theories about how to handle instances that violate some dependencies. The usual approach to alleviate the impact of inconsistent data on the answers to a query is to introduce the notion of repair: a repair is a minimally different consistent instance and an answer is consistent if it is present in every repair. Our approach is fundamentally different: we use set theoretic semantics for tuples and functional dependencies that allow us to associate each tuple with a truth value among the following: true, false, inconsistent or unknown. The users of the table can then query the set of true tuples as usual. Regarding missing values, we make no assumptions on their existence: a missing value exists only if it is inferred from the functional dependencies of the table. The main contributions of the paper are the following: (a) we introduce a new approach to handle inconsistencies in a table with nulls and functional dependencies, (b) we give algorithms for computing all true, inconsistent and false tuples, (c) we discuss how our approach relates to Belnap's four valued logic, (d) we describe how our approach can be applied to the consolidation of two or more tables and (e) we discuss the relationship between our approach and that of table repairs.
Document type :
Preprints, Working Papers, ...
Complete list of metadata
Contributor : Dominique Laurent Connect in order to contact the contributor
Submitted on : Thursday, August 5, 2021 - 11:49:08 AM
Last modification on : Saturday, August 7, 2021 - 3:48:22 AM


Files produced by the author(s)


  • HAL Id : hal-03314808, version 1


Dominique Laurent, Nicolas Spyratos. Handling Inconsistencies in Tables with Nulls and Functional Dependencies. 2021. ⟨hal-03314808⟩



Record views


Files downloads