Tables with Nulls and Functional Dependencies: Explanation and Quality of Query Answers

Dominique Laurent (1, 2) , Nicolas Spyratos (3)

1 CY - CY Cergy Paris Université
2 ETIS - UMR 8051 - Equipes Traitement de l'Information et Systèmes
3 LISN - Laboratoire Interdisciplinaire des Sciences du Numérique

Several applications today deal with tables that are the result of merging other tables coming from different sources (as when recording the results of collaborative work or when merging tables during data staging in data warehouses). Such tables usually have missing values (also called nulls) and/or contain data that do not respect given constraints(such as key constraints). In this paper we study the influence of nulls and/or inconsistent data on the answers to queries to such tables by (a) providing to the user explanations regarding the expected presence (or absence) of certain tuples in the answer and (b) by defining measures for assessing the quality of query answers.

Keywords: Inconsistent data Query answering Explanations Data quality; Inconsistent data; Query answering; Explanations; Data quality

Domains: Databases [cs.DB]

Dominique Laurent, Nicolas Spyratos. Tables with Nulls and Functional Dependencies: Explanation and Quality of Query Answers. MEDES 2023 - The 15th Conference on Management of Digital Ecosystems, May 2023, Heraklion, Greece. ⟨hal-04383086⟩