{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,12,21]],"date-time":"2023-12-21T19:39:02Z","timestamp":1703187542798},"reference-count":14,"publisher":"Association for Computing Machinery (ACM)","issue":"3","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[1994,9]]},"abstract":"Some problems connected with the handling of null values in SQL are discussed. A definition of sure answers to SQL queries is proposed which takes care of the \u201cno information\u201d meaning of null values in SQL. An algorithm is presented for modifying SQL queries such that answers are not changed for databases without null values but sure answers are obtained for arbitrary databases with standard SQL semantics.<\/jats:p>","DOI":"10.1145\/187436.187445","type":"journal-article","created":{"date-parts":[[2005,11,9]],"date-time":"2005-11-09T20:35:31Z","timestamp":1131568531000},"page":"14-20","update-policy":"http:\/\/dx.doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":7,"title":["How to modify SQL queries in order to guarantee sure answers"],"prefix":"10.1145","volume":"23","author":[{"given":"H.-J.","family":"Klein","sequence":"first","affiliation":[{"name":"Department of Computer Science, University of Kiel, 24118 Kiel, Germany"}]}],"member":"320","published-online":{"date-parts":[[1994,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1016\/0304-3975(51)90007-2"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/319996.320014"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/320107.320109"},{"key":"e_1_2_1_4_1","volume-title":"J","author":"C.","year":"1985","unstructured":"[Da] C. J . Date : Relational Database Writings 1985 - 1989. Addison-Wesley , 1990. [Da] C. J. Date: Relational Database Writings 1985- 1989. Addison-Wesley, 1990."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1016\/0020-0190(77)90013-8"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/1634.1886"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/320083.320088"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/111197.111212"},{"key":"e_1_2_1_10_1","first-page":"55","volume-title":"Logic and Databases","author":"R.","year":"1978","unstructured":"[Re] R. Reiter: On closed world databases . In Logic and Databases (H. Gallaire and J. Minker, eds.), pp. 55 - 76 , 1978 . [Re] R. Reiter: On closed world databases. In Logic and Databases (H. Gallaire and J. Minker, eds.), pp. 55-76, 1978."},{"key":"e_1_2_1_11_1","volume-title":"[SQL89] International Standard ISO\/IEC 9075","year":"1989","unstructured":"[SQL89] International Standard ISO\/IEC 9075 , second edition. Gen\u00e8ve , 1989 . [SQL89] International Standard ISO\/IEC 9075, second edition. Gen\u00e8ve, 1989."},{"key":"e_1_2_1_12_1","volume-title":"[SQL92] International Standard ISO\/IEC 9075","year":"1992","unstructured":"[SQL92] International Standard ISO\/IEC 9075 , third edition. Gen\u00e8ve , 1992 . [SQL92] International Standard ISO\/IEC 9075, third edition. Gen\u00e8ve, 1992."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-0000(86)90016-4"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/582095.582123"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-0000(84)90080-1"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/187436.187445","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,29]],"date-time":"2022-12-29T20:24:56Z","timestamp":1672345496000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/187436.187445"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1994,9]]},"references-count":14,"journal-issue":{"issue":"3","published-print":{"date-parts":[[1994,9]]}},"alternative-id":["10.1145\/187436.187445"],"URL":"https:\/\/doi.org\/10.1145\/187436.187445","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[1994,9]]},"assertion":[{"value":"1994-09-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}