Database Querying under Missing Values Governed by Missingness Mechanisms
Organizations: Carleton University, Ottawa, Canada & IMFD, Chile. · LIMOS, CNRS, UCA, France.
Abstract
We address the problems of giving a semantics to- and doing query answering (QA) on a relational database (RDB) that has missing values (MVs). The causes for the latter are governed by a Missingness Mechanism that is modelled as a Bayesian Network, which represents a Missingness Graph (MG) and involves the DB attributes. Our approach considerable departs from the treatment of RDBs with NULL (values). The MG together with the observed DB allow to build a block-independent probabilistic DB, on which basis we propose two QA techniques that jointly capture probabilistic uncertainty and statistical plausibility of the implicit imputation of MVs. We obtain complexity results that characterize the computational feasibility of those approaches.
Figures & tables
Appendix figures & tables2 assets
Supplementary material from the paper’s appendix.
Appendix
Relational Databases
Relational databases store structured data in tables linked by keys, enabling reliable querying, updates, and analysis with SQL.
See all 80 papers