{"id":"https://openalex.org/W2094841990","doi":"https://doi.org/10.1145/1361348.1361350","title":"Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique","display_name":"Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique","alternate_titles":[],"publication_year":2007,"publication_date":"2007-12-01","ids":{"openalex":"https://openalex.org/W2094841990","doi":"https://doi.org/10.1145/1361348.1361350","mag":"2094841990"},"language":"en","primary_location":{"id":"doi:10.1145/1361348.1361350","doi":"https://doi.org/10.1145/1361348.1361350","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1361348.1361350","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2094841990"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5045936131","display_name":"Claude Rubinson","orcid":"https://orcid.org/0000-0003-4349-1965","observed_orcids":["https://orcid.org/0000-0003-4349-1965"]},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Claude Rubinson","raw_affiliation_strings":["University of Arizona"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Arizona","institution_ids":["https://openalex.org/I138006243"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5045936131"],"corresponding_institution_ids":["https://openalex.org/I138006243"],"apc_list":null,"apc_paid":null,"fwci":1.8544,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.88271821,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":96},"biblio":{"volume":"36","issue":"4","first_page":"13","last_page":"17"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9735999703407288,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9735999703407288,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.009600000455975533,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.006899999920278788,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6859999895095825},{"id":"https://openalex.org/keywords/nulls","display_name":"nulls","score":0.734000027179718},{"id":"https://openalex.org/keywords/three-valued-logic","display_name":"ternary logic","score":0.9990000128746033},{"id":"https://openalex.org/keywords/ambiguity","display_name":"ambiguity","score":0.550000011920929},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"relational algebra","score":0.3790000081062317},{"id":"https://openalex.org/keywords/query-semantics","display_name":"query semantics","score":0.44600000977516174}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8063481450080872},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7707640528678894},{"id":"https://openalex.org/C2780522230","wikidata":"https://www.wikidata.org/wiki/Q1140419","display_name":"Ambiguity","level":2,"score":0.6517543196678162},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5403140187263489},{"id":"https://openalex.org/C2780876879","wikidata":"https://www.wikidata.org/wiki/Q3054749","display_name":"Meaning (existential)","level":2,"score":0.5352146625518799},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.44441336393356323},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23350417613983154},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.11964517831802368},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.09881749749183655},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07838046550750732},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1361348.1361350","doi":"https://doi.org/10.1145/1361348.1361350","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1361348.1361350","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.423.2021","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.423.2021","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.sigmod.org/publications/sigmod-record/0712/p13.article-rubinson.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1608181711","https://openalex.org/W1979755162","https://openalex.org/W2030315716","https://openalex.org/W2037207320","https://openalex.org/W2138709157","https://openalex.org/W4210304433","https://openalex.org/W4285042649"],"related_works":["https://openalex.org/W2158060543","https://openalex.org/W4379113086","https://openalex.org/W3116876164","https://openalex.org/W2297697128","https://openalex.org/W2155838697","https://openalex.org/W2765523787","https://openalex.org/W2614913282","https://openalex.org/W2405394339"],"abstract_inverted_index":{"Date's":[0,72],"popular":[1],"critique":[2,30,66],"of":[3,39,77,86],"SQL's":[4,75],"three-valued":[5,80],"logic":[6,81],"[4,":[7],"3]":[8],"purports":[9],"to":[10,50],"demonstrate":[11],"that":[12,28,34,57],"SQL":[13,45],"queries":[14],"can":[15],"produce":[16],"erroneous":[17],"results":[18],"when":[19],"nulls":[20,78],"are":[21],"present":[22],"in":[23,33],"the":[24,37,47,51],"database.":[25],"I":[26,69],"argue":[27],"this":[29],"is":[31,59,67],"flawed":[32],"Date":[35],"misinterprets":[36],"meaning":[38],"his":[40,65],"example":[41],"query.":[42],"In":[43],"fact,":[44],"returns":[46],"correct":[48],"answer":[49],"query":[52],"posed;":[53],"Date,":[54],"however,":[55],"believes":[56],"he":[58],"asking":[60],"a":[61,83],"different":[62],"question.":[63],"Although":[64],"flawed,":[68],"agree":[70],"with":[71],"general":[73],"conclusion:":[74],"use":[76],"and":[79],"introduces":[82],"startling":[84],"amount":[85],"complexity":[87],"into":[88],"seemingly":[89],"straightforward":[90],"queries.":[91]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2094841990","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
