{"id":"https://openalex.org/W2158060543","doi":"https://doi.org/10.1145/1462571.1462574","title":"A critique of Claude Rubinson's paper nulls, three - valued logic, and ambiguity in SQL","display_name":"A critique of Claude Rubinson's paper nulls, three - valued logic, and ambiguity in SQL","publication_year":2008,"publication_date":"2008-09-30","ids":{"openalex":"https://openalex.org/W2158060543","doi":"https://doi.org/10.1145/1462571.1462574","mag":"2158060543"},"language":"en","primary_location":{"id":"doi:10.1145/1462571.1462574","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1462571.1462574","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,"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"},"type":"article","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/A5109676609","display_name":"C. J. Date","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"C. J. Date","raw_affiliation_strings":["Consultant, Healdsburg, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Consultant, Healdsburg, CA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5109676609"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.18271858,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"37","issue":"3","first_page":"20","last_page":"22"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9794999957084656,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9794999957084656,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9049999713897705,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/citation","display_name":"Citation","score":0.8139533400535583},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7916573882102966},{"id":"https://openalex.org/keywords/ambiguity","display_name":"Ambiguity","score":0.7568017244338989},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6157755851745605},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.4255830943584442},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.42308881878852844},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3708431124687195},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3423464894294739},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2524353265762329}],"concepts":[{"id":"https://openalex.org/C2778805511","wikidata":"https://www.wikidata.org/wiki/Q1713","display_name":"Citation","level":2,"score":0.8139533400535583},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7916573882102966},{"id":"https://openalex.org/C2780522230","wikidata":"https://www.wikidata.org/wiki/Q1140419","display_name":"Ambiguity","level":2,"score":0.7568017244338989},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6157755851745605},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.4255830943584442},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.42308881878852844},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3708431124687195},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3423464894294739},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2524353265762329}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1462571.1462574","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1462571.1462574","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,"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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W1608181711","https://openalex.org/W2094841990"],"related_works":["https://openalex.org/W2353179089","https://openalex.org/W2923538289","https://openalex.org/W2353125546","https://openalex.org/W2470643824","https://openalex.org/W2349635380","https://openalex.org/W4353089801","https://openalex.org/W2353819554","https://openalex.org/W2359488321","https://openalex.org/W2389866386","https://openalex.org/W2131379912"],"abstract_inverted_index":{"research-article":[0],"A":[1],"critique":[2,18],"of":[3],"Claude":[4],"Rubinson's":[5],"paper":[6],"nulls,":[7],"three":[8],"-":[9],"valued":[10],"logic,":[11],"and":[12,65],"ambiguity":[13],"in":[14,97],"SQL:":[15],"critiquing":[16],"Date's":[17],"Share":[19],"on":[20,88],"Author:":[21],"C.":[22],"J.":[23],"Date":[24],"Consultant,":[25,28],"Healdsburg,":[26,29],"CA":[27],"CAView":[30],"Profile":[31],"Authors":[32],"Info":[33],"&":[34],"Claims":[35],"ACM":[36],"SIGMOD":[37],"RecordVolume":[38],"37Issue":[39],"3September":[40],"2008":[41],"pp":[42],"20\u201322https://doi.org/10.1145/1462571.1462574Online:30":[43],"September":[44],"2008Publication":[45],"History":[46],"6citation303DownloadsMetricsTotal":[47],"Citations6Total":[48],"Downloads303Last":[49],"12":[50],"Months3Last":[51],"6":[52],"weeks0":[53],"Get":[54],"Citation":[55,57,94],"AlertsNew":[56,93],"Alert":[58],"added!This":[59],"alert":[60,85],"has":[61,80],"been":[62,81],"successfully":[63],"added":[64],"will":[66,70],"be":[67,71],"sent":[68],"to:You":[69],"notified":[72],"whenever":[73],"a":[74,106],"record":[75],"that":[76],"you":[77],"have":[78],"chosen":[79],"cited.To":[82],"manage":[83],"your":[84,99],"preferences,":[86],"click":[87],"the":[89],"button":[90],"below.Manage":[91],"my":[92],"Alert!Please":[95],"log":[96],"to":[98,102,104],"account":[100],"Save":[101],"BinderSave":[103],"BinderCreate":[105],"New":[107],"BinderNameCancelCreateExport":[108],"CitationPublisher":[109],"SiteGet":[110],"Access":[111]},"counts_by_year":[{"year":2023,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}