Results 81 to 90 of about 290,436 (133)

An investigation of fentanyl and methamphetamine use among first-time arrestees from 25 county jails across the U.S. in 2023. [PDF]

open access: yesAddict Sci Clin Pract
Schumacher JE   +6 more
europepmc   +1 more source

Applying prospective tree-temporal scan statistics to genomic surveillance data to detect emerging SARS-CoV-2 variants and salmonellosis clusters in New York City. [PDF]

open access: yesInt J Epidemiol
Greene SK   +12 more
europepmc   +1 more source

Null values in SQL

open access: closedACM SIGMOD Record, 2008
In various writings over the past 20 years, such as [3], Date has pointed out that SQL produces incorrect answers to some queries where a null value is included in a table. In a recent article in the ACM SIGMOD Record, [8], Rubinson states that "Date misinterprets the meaning of his example query" and "SQL returns the correct answer to the query posed".
John Grant
semanticscholar   +4 more sources

NULL-Werte und dreiwertige Logik in SQL

open access: closedInformatik zwischen Wissenschaft und Gesellschaft, 1992
In relationalen Datenbanken ist es ublich, das gewisse Felder „NULL“ sein konnen (vgl. [Date86]). Wir sagen hier bewust nicht „den Wert NULL haben“. NULL kann u.a. bedeuten, das der aktuelle Wert eines Attributs unbekannt ist. Andere Arten von Nullen, wie z.B. „nicht anwendbar“ oder „gibt es nicht“ werden hier nicht behandelt, (vgl.
Günter Matthiessen
semanticscholar   +4 more sources

Handling Null Values in SQL Queries on Relational Databases

open access: closed2024 10th International Conference on Engineering, Applied Sciences, and Technology (ICEAST)
The 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,
Manuel Me’Ndez   +2 more
semanticscholar   +3 more sources

Nulls, three-valued logic, and ambiguity in SQL

open access: closedACM SIGMOD Record, 2007
Date's popular critique of SQL's three-valued logic [4, 3] purports to demonstrate that SQL queries can produce erroneous results when nulls are present in the database. I argue that this critique is flawed in that Date misinterprets the meaning of his example query.
Claude Rubinson
openaire   +3 more sources

A critique of Claude Rubinson's paper nulls, three - valued logic, and ambiguity in SQL

open access: closedACM SIGMOD Record, 2008
I’d like to thank Claude Rubinson for his thoughtful critique [3] of my remarks in reference [1] on nulls and three-valued logic (3VL). Clearly we’re in agreement on the major issues; as Rubinson says, “I agree with Date that three-valued logic is incompatible with database management systems.” We also agree that null isn’t a value; as Rubinson says ...
C. J. Date
openaire   +3 more sources

TenSQL: An SQL Database Built on GraphBLAS

IEEE Conference on High Performance Extreme Computing, 2023
Relational Database Management Systems (RDBMS) have been the most prominent form of database in the world for several decades. While relational databases are often applied within high-frequency/low-volume transactional applications such as website ...
Jon Roose   +3 more
semanticscholar   +1 more source

Home - About - Disclaimer - Privacy