Troubles with nulls, views from the users - Inria - Institut national de recherche en sciences et technologies du numérique
Article Dans Une Revue Proceedings of the VLDB Endowment (PVLDB) Année : 2022

Troubles with nulls, views from the users

Résumé

Incomplete data, in the form of null values, has been extensively studied since the inception of the relational model in the 1970s. Anecdotally, one hears that the way in which SQL, the standard language for relational databases, handles nulls creates a myriad of problems in everyday applications of database systems. To the best of our knowledge, however, the actual shortcomings of SQL in this respect, as perceived by database practitioners, have not been systematically documented, and it is not known if existing research results can readily be used to address the practical challenges. Our goal is to collect and analyze the shortcomings of nulls and their treatment by SQL, and to re-evaluate existing research in this light. To this end, we designed and conducted a survey on the everyday usage of null values among database users. From the analysis of the results we reached two main conclusions. First, null values are ubiquitous and relevant in real-life scenarios, but SQL's features designed to deal with them cause multiple problems. The severity of these problems varies depending on the SQL features used, and they cannot be reduced to a single issue. Second, foundational research on nulls is misdirected and has been addressing problems of limited practical relevance. We urge the community to view the results of this survey as a way to broaden the spectrum of their researches and further bridge the theory-practice gap on null values.
Fichier principal
Vignette du fichier
main.pdf (2.52 Mo) Télécharger le fichier
Origine Fichiers produits par l'(les) auteur(s)

Dates et versions

hal-03934346 , version 1 (05-12-2023)

Identifiants

Citer

Etienne Toussaint, Paolo Guagliardo, Leonid Libkin, Juan Sequeda. Troubles with nulls, views from the users. Proceedings of the VLDB Endowment (PVLDB), 2022, 15 (11), pp.2613-2625. ⟨10.14778/3551793.3551818⟩. ⟨hal-03934346⟩
67 Consultations
30 Téléchargements

Altmetric

Partager

More