Tables with Nulls and Functional Dependencies: Explanation and Quality of Query Answers - Laboratoire Interdisciplinaire des Sciences du Numérique Access content directly
Conference Papers Year : 2024

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

Abstract

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.
Fichier principal
Vignette du fichier
MEDES-post-proc.pdf (489.75 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-04383086 , version 1 (09-01-2024)

Identifiers

  • HAL Id : hal-04383086 , version 1

Cite

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⟩
8 View
26 Download

Share

Gmail Facebook X LinkedIn More