Tables with Nulls and Functional Dependencies: Explanation and Quality of Query Answers - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2024

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

Résumé

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
Origine : Fichiers produits par l'(les) auteur(s)

Dates et versions

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

Identifiants

  • HAL Id : hal-04383086 , version 1

Citer

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⟩
3 Consultations
14 Téléchargements

Partager

Gmail Facebook X LinkedIn More