Handling Null Values in SQL Queries on Relational Databases

Simple item page
dc.contributor.authorMéndez, Manuel
dc.contributor.authorMerayo, Mercedes G.
dc.contributor.authorChittayasothorn, Suphamit
dc.date.accessioned2026-08-06T10:44:24Z
dc.date.available2026-08-06T10:44:24Z
dc.date.issued2024-01-01
dc.description.abstractThe lack of information within relational databases expressed as NULL values presents a problem in ensuring the quality of data and the information retrieved by SQL queries. This is so because there are different interpretations of NULL values. Actually, in many cases, queries either do not consider that NULL values can appear as a result of their evaluation or do not reflect in the code the correct interpretation of these values. NULL values have been present in databases since almost the earliest implementations of relational database management systems, but the implementation of the SQL standard raises multiple problems. When querying on a database that handles NULL values, the results may not be as expected, either by omission of results (false negatives) or by incorrect results (false positives). In this work we propose a methodology that analyses different SQL queries and allows the user to detect possible errors in those queries that have NULL values.
dc.identifier.citation2024 10th International Conference on Engineering Applied Sciences and Technology Iceast 2024, 65-68, 2024
dc.identifier.doi10.1109/ICEAST61342.2024.10553913
dc.identifier.other2-s2.0-85197239471
dc.identifier.urihttps://dspace.kmitl.ac.th/handle/123456789/15185
dc.source2024 10th International Conference on Engineering Applied Sciences and Technology Iceast 2024
dc.subjectNull Values
dc.subjectRelational Databases
dc.subjectSQL Queries
dc.titleHandling Null Values in SQL Queries on Relational Databases
dc.typeConference Paper

Files

Collections

Research