research-article

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

Author:

C. J. DateAuthors Info & Claims

ACM SIGMOD Record, Volume 37, Issue 3

Pages 20 - 22

https://doi.org/10.1145/1462571.1462574

Published: 30 September 2008 Publication History

Get Access

References

[1]

C. J. Date: Database in Depth: Relational Theory for Practitioners. Sebastopol, Calif.: O'Reilly Media, Inc. (2005).

Digital Library

Google Scholar

[2]

C. J. Date: "The Closed World Assumption," in Logic and Databases: The Roots of Relational Theory. Victoria, BC: Trafford Publishing (2007). See www.trafford.com/07-0690.

Digital Library

Google Scholar

[3]

Claude Rubinson: "Nulls, Three-Valued Logic, and Ambiguity in SQL: Critiquing Date's Critique," ACMSIGMOD Record 36, No. 4, December 2007.

Digital Library

Google Scholar

Cited By

View all

Taipalus TAivaloglou EFletcher GMiedema D(2023)SQL: A Trojan Horse Hiding a Decathlon of ComplexitiesProceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research10.1145/3596673.3603142(9-13)Online publication date: 23-Jun-2023
https://dl.acm.org/doi/10.1145/3596673.3603142
Libkin LPeterfreund LGeerts FNgo HSintos S(2023)SQL Nulls and Two-Valued LogicProceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems10.1145/3584372.3588661(11-20)Online publication date: 18-Jun-2023
https://dl.acm.org/doi/10.1145/3584372.3588661
Zhang ALi JGao H(2019)Interval Estimation for Aggregate Queries on Incomplete DataJournal of Computer Science and Technology10.1007/s11390-019-1970-434:6(1203-1216)Online publication date: 22-Nov-2019
https://dl.acm.org/doi/10.1007/s11390-019-1970-4
Show More Cited By

Index Terms

A critique of Claude Rubinson's paper nulls, three - valued logic, and ambiguity in SQL: critiquing Date's critique
1. Information systems
  1. Data management systems
    1. Database design and models
    2. Query languages
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)

Recommendations

Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique

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 ...
SQL’s Three-Valued Logic and Certain Answers
Invited Paper from ICDT 2015, SIGMOD 2014, EDBT 2014 and Regular Papers

The goal of the article is to bridge the difference between theoretical and practical approaches to answering queries over databases with nulls. Theoretical research has long ago identified the notion of correctness of query answering over incomplete ...
Can naturalism explain consciousness? A critique

The problem of consciousness is one of the most important problems both in cognitive science and in philosophy. There are different philosophers and different scientists who define consciousness and explain it differently. In philosophy, `consciousness' ...

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 37, Issue 3

September 2008

44 pages

ISSN:0163-5808

DOI:10.1145/1462571

Issue’s Table of Contents

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 30 September 2008

Published in SIGMOD Volume 37, Issue 3

Check for updates

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

8
Total Citations
View Citations
316
Total Downloads

Downloads (Last 12 months)2
Downloads (Last 6 weeks)0

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Taipalus TAivaloglou EFletcher GMiedema D(2023)SQL: A Trojan Horse Hiding a Decathlon of ComplexitiesProceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research10.1145/3596673.3603142(9-13)Online publication date: 23-Jun-2023
https://dl.acm.org/doi/10.1145/3596673.3603142
Libkin LPeterfreund LGeerts FNgo HSintos S(2023)SQL Nulls and Two-Valued LogicProceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems10.1145/3584372.3588661(11-20)Online publication date: 18-Jun-2023
https://dl.acm.org/doi/10.1145/3584372.3588661
Zhang ALi JGao H(2019)Interval Estimation for Aggregate Queries on Incomplete DataJournal of Computer Science and Technology10.1007/s11390-019-1970-434:6(1203-1216)Online publication date: 22-Nov-2019
https://dl.acm.org/doi/10.1007/s11390-019-1970-4
Neumann T(2018)Reasoning in the Presence of NULLs2018 IEEE 34th International Conference on Data Engineering (ICDE)10.1109/ICDE.2018.00214(1682-1683)Online publication date: Apr-2018
https://doi.org/10.1109/ICDE.2018.00214
(2016)Certain answers as objects and knowledgeArtificial Intelligence10.1016/j.artint.2015.11.004232:C(1-19)Online publication date: 1-Mar-2016
https://dl.acm.org/doi/10.1016/j.artint.2015.11.004
Rubinson C(2014)Ontological Considerations When Modeling Missing Data With Relational DatabasesSocial Science Computer Review10.1177/089443931452198832:6(769-780)Online publication date: 3-Jul-2014
https://doi.org/10.1177/0894439314521988
Libkin LHull RGrohe M(2014)Incomplete dataProceedings of the 33rd ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems10.1145/2594538.2594561(1-13)Online publication date: 18-Jun-2014
https://dl.acm.org/doi/10.1145/2594538.2594561
Krajca PVychodil V(2013)Foundations of relational similarity-based query language RESIQL2013 IEEE Symposium on Foundations of Computational Intelligence (FOCI)10.1109/FOCI.2013.6602450(15-23)Online publication date: Apr-2013
https://doi.org/10.1109/FOCI.2013.6602450

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique

SQL’s Three-Valued Logic and Certain Answers

Can naturalism explain consciousness? A critique

Comments

Published In

Publisher

Publication History

Check for updates

Qualifiers

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

References

Cited By

Index Terms

Recommendations

Nulls, three-valued logic, and ambiguity in SQL: critiquing date's critique

SQL’s Three-Valued Logic and Certain Answers

Can naturalism explain consciousness? A critique

Comments

Information

Published In

Publisher

Publication History

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations