{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,4]],"date-time":"2024-09-04T23:51:33Z","timestamp":1725493893645},"publisher-location":"Berlin, Heidelberg","reference-count":45,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783540009573"},{"type":"electronic","value":"9783540365969"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2003]]},"DOI":"10.1007\/3-540-36596-6_7","type":"book-chapter","created":{"date-parts":[[2007,10,24]],"date-time":"2007-10-24T21:23:52Z","timestamp":1193261032000},"page":"119-138","source":"Crossref","is-referenced-by-count":2,"title":["Null Values in Relational Databases and Sure Information Answers"],"prefix":"10.1007","author":[{"given":"Klein","family":"Hans-Joachim","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2003,4,1]]},"reference":[{"key":"7_CR1","volume-title":"Foundations of Databases","author":"S. Abiteboul","year":"1995","unstructured":"S. Abiteboul, R. Hull, and V. Vianu: Foundations of Databases. Addison-Wesley, Reading, 1995"},{"key":"7_CR2","doi-asserted-by":"publisher","first-page":"159","DOI":"10.1016\/0304-3975(51)90007-2","volume":"78","author":"S. Abiteboul","year":"1991","unstructured":"S. Abiteboul, P. Kanellakis, and G. Grahne: On the representation and querying of sets of possible worlds. Theor. Comp. Science 78, pp. 159\u2013187, 1991","journal-title":"Theor. Comp. Science"},{"issue":"4","key":"7_CR3","doi-asserted-by":"publisher","first-page":"608","DOI":"10.1145\/319996.320014","volume":"8","author":"J. Biskup","year":"1983","unstructured":"J. Biskup: A foundation of Codd\u2019s relational maybe-operations. ACM Trans. on Database Systems 8 (4), pp. 608\u2013636, 1983","journal-title":"ACM Trans. on Database Systems"},{"key":"7_CR4","unstructured":"E.F. Codd: Further normalization of the database relational model. In: Data Base Systems. Current Computer Science Symposium 6 (R. Rustin, ed.), Prentice Hall, Englewood Cliffs, pp. 33\u201364, 1972"},{"key":"7_CR5","unstructured":"E.F. Codd: Relational completeness of data base sublanguages. In: Data Base Systems. Current Computer Science Symposium 6 (R. Rustin, ed.), Prentice Hall, Englewood Cliffs, pp. 65\u201398, 1972"},{"issue":"4","key":"7_CR6","doi-asserted-by":"publisher","first-page":"397","DOI":"10.1145\/320107.320109","volume":"4","author":"E.F. Codd","year":"1979","unstructured":"E.F. Codd: Extending the database relational model to capture more meaning. ACM Trans. on Database Systems 4 (4), pp. 397\u2013434, 1979","journal-title":"ACM Trans. on Database Systems"},{"issue":"4","key":"7_CR7","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1145\/16301.16303","volume":"15","author":"E.F. Codd","year":"1986","unstructured":"E.F. Codd: Missing information (applicable and inapplicable) in relational databases. ACM SIGMOD RECORD15 (4), pp. 53\u201377, 1986","journal-title":"ACM SIGMOD RECORD"},{"key":"7_CR8","volume-title":"Relational Database: Selected Writings","author":"C.J. Date","year":"1986","unstructured":"C.J. Date: Null values in database management. In: Relational Database: Selected Writings, Addison-Wesley, Reading, 1986"},{"key":"7_CR9","volume-title":"Relational Database Writings 1985-1989","author":"C.J. Date","year":"1990","unstructured":"C.J. Date: Relational Database Writings 1985-1989. Addison-Wesley, Reading, 1990"},{"key":"7_CR10","volume-title":"Foundation for Object\/Relational Databases","author":"C.J. Date","year":"1998","unstructured":"C.J. Date and H. Darwen: Foundation for Object\/Relational Databases. Addison Wesley, Reading, 1998"},{"issue":"1","key":"7_CR11","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1145\/382274.382401","volume":"19","author":"G.H. Gessert","year":"1990","unstructured":"G.H. Gessert: Four valued logic for relational database systems. ACM SIGMOD Record 19 (1), pp. 29\u201335, 1990","journal-title":"ACM SIGMOD Record"},{"key":"7_CR12","doi-asserted-by":"crossref","unstructured":"O.N. Garcia and M. Moussavi: A six-valued logic for representing incomplete knowledge. Proc. IEEE 20th Int. Symp. on Multiple-valued Logic (G. Epstein, ed.), Charlotte, pp. 110\u2013114, 1990","DOI":"10.1109\/ISMVL.1990.122605"},{"key":"7_CR13","series-title":"Lect Notes Comput Sci","doi-asserted-by":"crossref","DOI":"10.1007\/3-540-54919-6","volume-title":"The Problem of Incomplete Information in Relational Databases","author":"G. Grahne","year":"1991","unstructured":"G. Grahne: The Problem of Incomplete Information in Relational Databases. LNCS 554, Springer-Verlag, Berlin, 1991"},{"key":"7_CR14","doi-asserted-by":"crossref","unstructured":"J. Grant: Null values in relational data base. Inform. Proc. Letters 6 (5), pp. 156\u2013157, 1977","DOI":"10.1016\/0020-0190(77)90013-8"},{"key":"7_CR15","unstructured":"G. Gottlob and R. Zicari: Closed world databases opened through null values. Proc. 14th VLDB Conf., Los Angeles, pp. 50\u201361, 1988"},{"key":"7_CR16","doi-asserted-by":"crossref","unstructured":"T. Imielinski and W. Lipski: A systematic approach to relational database theory. Proc. ACM SIGMOD Conf., Orlando, pp. 8\u201314, 1982","DOI":"10.1145\/582353.582356"},{"issue":"4","key":"7_CR17","doi-asserted-by":"publisher","first-page":"761","DOI":"10.1145\/1634.1886","volume":"31","author":"T. Imielinski","year":"1984","unstructured":"T. Imielinski and W. Lipski: Incomplete information in relational databases. Journal of the ACM 31 (4), pp. 761\u2013791, 1984","journal-title":"Journal of the ACM"},{"key":"7_CR18","doi-asserted-by":"crossref","first-page":"261","DOI":"10.1016\/0020-0190(86)90104-3","volume":"22","author":"A.M. Keller","year":"1986","unstructured":"A.M. Keller: Set-theoretic problems of null completion in relational databases. Inf. Proc. Letters 22, pp. 261\u2013265, 1986","journal-title":"Inf. Proc. Letters"},{"key":"7_CR19","doi-asserted-by":"publisher","first-page":"150","DOI":"10.2307\/2267778","volume":"3","author":"S.C. Kleene","year":"1938","unstructured":"S.C. Kleene: On a notation of ordinal numbers. The Journal of Symbolic Logic 3, pp. 150\u2013155, 1938","journal-title":"The Journal of Symbolic Logic"},{"issue":"3","key":"7_CR20","doi-asserted-by":"publisher","first-page":"14","DOI":"10.1145\/187436.187445","volume":"23","author":"H.-J. Klein","year":"1994","unstructured":"H.-J. Klein: How to modify SQL queries in order to guarantee sure answers. ACM SIGMOD Record 23 (3), pp. 14\u201320, 1994","journal-title":"ACM SIGMOD Record"},{"key":"7_CR21","unstructured":"H.-J. Klein: Sure and possible answers to queries for relational databases with partial relations. Technical Report 9802, Inst. f. Informatik u. Prakt. Mathem., Univ. Kiel, 194 pages, 1997 (in German)"},{"key":"7_CR22","unstructured":"H.-J. Klein: Model theoretic and proof theoretic view of relational databases with null values: a comparison, in: M.H. Scholl et al. (Eds.), 10. GI-Workshop \u201cGrundlagen von Datenbanken\u201d, Konstanzer Schriften in Mathematik u. Informatik, Nr. 63, Univ. Konstanz, pp. 57\u201361, 1998"},{"key":"7_CR23","first-page":"82","volume-title":"Fundamentals of Informations Systems","author":"H.-J. Klein","year":"1999","unstructured":"H.-J. Klein: On the use of marked nulls for the evaluation of queries against incomplete relational databases. In: Fundamentals of Informations Systems (T. Polle, T. Ripke, and K.-D. Schewe, eds), Kluwer Academic Publ., Boston, pp. 82\u201399, 1999"},{"key":"7_CR24","unstructured":"H.-J. Klein: Efficient algorithms for approximating answers to queries against incomplete relational databases. In: Proc. KRDB\u201999 (E. Franconi and M. Kifer, eds.), Link\u00f6ping, pp. 26\u201330, 1999"},{"issue":"7","key":"7_CR25","doi-asserted-by":"publisher","first-page":"620","DOI":"10.1109\/TSE.1985.232506","volume":"SE-11","author":"A.M. Keller","year":"1985","unstructured":"A.M Keller and M.W. Winslett Wilkins: On the use of an extended relational model to handle changing information and nulls. IEEE Trans. on Soft. Eng., SE-11 (7), pp. 620\u2013633, 1985","journal-title":"IEEE Trans. on Soft. Eng."},{"key":"7_CR26","series-title":"Lect Notes Comput Sci","doi-asserted-by":"crossref","first-page":"204","DOI":"10.1007\/3-540-52048-1_45","volume-title":"Query evaluation with null values: how complex is completeness?","author":"V.S. Lakshmanan","year":"1989","unstructured":"V.S. Lakshmanan: Query evaluation with null values: how complex is completeness?. Proc. 9th Conf. on Found. of Software Technologies and Theor. Comp. Science, Bangalore, LNCS 405, Springer-Verlag, Berlin, pp. 204\u2013222, 1989"},{"key":"7_CR27","doi-asserted-by":"publisher","first-page":"67","DOI":"10.1016\/0304-3975(86)90022-8","volume":"46","author":"N. Lerat","year":"1986","unstructured":"N. Lerat and W. Lipski: Nonapplicable nulls. Theoretical Computer Science 46, pp. 67\u201382, 1986","journal-title":"Theoretical Computer Science"},{"key":"7_CR28","doi-asserted-by":"crossref","DOI":"10.1007\/978-0-85729-349-7","volume-title":"A Guided Tour of Relational Databases and Beyond","author":"M. Levene","year":"1999","unstructured":"M. Levene and G. Loizou: A Guided Tour of Relational Databases and Beyond. Springer-Verlag, London, 1999"},{"key":"7_CR29","series-title":"Lect Notes Comput Sci","doi-asserted-by":"publisher","first-page":"170","DOI":"10.1007\/BFb0035009","volume-title":"Semantics in Databases","author":"L. Libkin","year":"1998","unstructured":"L. Libkin: A semantics based approach to design of query languages for partial information. In: Semantics in Databases (B. Thalheim, L. Libkin, eds.), LNCS 1358, pp. 170\u2013208, 1998"},{"issue":"3","key":"7_CR30","doi-asserted-by":"publisher","first-page":"262","DOI":"10.1145\/320083.320088","volume":"4","author":"W. Lipski","year":"1979","unstructured":"W. Lipski: On semantic issues connected with incomplete information databases. ACM Trans. on Database Systems 4 (3), pp. 262\u2013296, 1979","journal-title":"ACM Trans. on Database Systems"},{"issue":"1","key":"7_CR31","doi-asserted-by":"publisher","first-page":"41","DOI":"10.1145\/322234.322239","volume":"18","author":"W. Lipski","year":"1981","unstructured":"W. Lipski: On databases with incomplete information. J. of the ACM 18 (1), pp. 41\u201370, 1981","journal-title":"J. of the ACM"},{"issue":"1","key":"7_CR32","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/77643.77644","volume":"15","author":"K.C. Liu","year":"1990","unstructured":"K.C. Liu and R. Sunderraman: Indefinite and maybe information in relational databases. ACM Trans. on Database Systems 15 (1), pp. 1\u201339, 1990","journal-title":"ACM Trans. on Database Systems"},{"key":"7_CR33","unstructured":"D. Maier: The Theory of Relational Databases. Computer Science Press, Rockville, 1983"},{"volume-title":"Uncertainty Management in Information Systems","year":"1997","key":"7_CR34","unstructured":"A. Motro and P. Smets (eds.): Uncertainty Management in Information Systems. Kluwer Academic Publ., Boston, 1997"},{"issue":"2","key":"7_CR35","doi-asserted-by":"publisher","first-page":"283","DOI":"10.1145\/329.318580","volume":"9","author":"D. Maier","year":"1984","unstructured":"D. Maier, J.D. Ullman, and M.Y. Vardi: On the foundations of the universal relational model. ACM Trans. on Database Systems 9 (2), pp. 283\u2013308, 1984","journal-title":"ACM Trans. on Database Systems"},{"issue":"2","key":"7_CR36","doi-asserted-by":"publisher","first-page":"294","DOI":"10.1109\/69.219737","volume":"5","author":"A. Ola","year":"1993","unstructured":"A. Ola and G. Ozsoyoglu: Incomplete relational database models based on intervals. IEEE Trans. on Knowledge and Data Eng. 5 (2), pp. 294\u2013308, 1993","journal-title":"IEEE Trans. on Knowledge and Data Eng."},{"key":"7_CR37","first-page":"55","volume-title":"Logic and Databases","author":"R. Reiter","year":"1978","unstructured":"R. Reiter: On closed world databases. In: Logic and Databases (H. Gallaire and J. Minker, eds.), Plenum Press, New York, pp. 55\u201376, 1978"},{"issue":"2","key":"7_CR38","doi-asserted-by":"publisher","first-page":"349","DOI":"10.1145\/5383.5388","volume":"33","author":"R. Reiter","year":"1986","unstructured":"R. Reiter: A sound and sometimes complete query evaluation algorithm for relational databases with null values. J. of the ACM 33 (2), pp. 349\u2013370, 1986","journal-title":"J. of the ACM"},{"key":"7_CR39","doi-asserted-by":"publisher","first-page":"615","DOI":"10.1007\/BF00288974","volume":"26","author":"M.A. Roth","year":"1989","unstructured":"M.A. Roth, H.F. Korth, and A. Silberschatz: Null values in nested relational databases. Acta Informatica 26, pp 615\u2013642, 1989","journal-title":"Acta Informatica"},{"key":"7_CR40","doi-asserted-by":"crossref","unstructured":"E. Sciore: Improving semantic specification in a relational database. Proc. ACM SIGMOD Conf., Boston, pp. 170\u2013178, 1979","DOI":"10.1145\/582095.582124"},{"key":"7_CR41","doi-asserted-by":"publisher","first-page":"142","DOI":"10.1016\/0022-0000(86)90016-4","volume":"33","author":"M.Y. Vardi","year":"1986","unstructured":"M.Y. Vardi: Querying logical databases. Journal of Comp. and System Sciences 33, pp. 142\u2013160, 1986","journal-title":"Journal of Comp. and System Sciences"},{"key":"7_CR42","doi-asserted-by":"crossref","unstructured":"Y. Vassiliou: Null values in data base management: a denotational approach. Proc. ACM SIGMOD Conf., Boston, pp. 162\u2013169, 1979","DOI":"10.1145\/582095.582123"},{"issue":"3","key":"7_CR43","doi-asserted-by":"publisher","first-page":"43","DOI":"10.1145\/126482.126487","volume":"20","author":"K. Yue","year":"1991","unstructured":"K. Yue: A more general model for handling missing information in relational databases using 3-value logic. ACM SIGMOD RECORD 20 (3), pp. 43\u201349, 1991","journal-title":"ACM SIGMOD RECORD"},{"key":"7_CR44","doi-asserted-by":"publisher","first-page":"142","DOI":"10.1016\/0022-0000(84)90080-1","volume":"28","author":"C. Zaniolo","year":"1984","unstructured":"C. Zaniolo: Database relations with null values. J. of Comp. and System Sciences 28, pp. 142\u2013166, 1984","journal-title":"J. of Comp. and System Sciences"},{"key":"7_CR45","unstructured":"E. Zim\u00e1nyi and A. Pirotte: Imperfect information in relational databases. In: [MS97], pp. 35\u201387, 1997"}],"container-title":["Lecture Notes in Computer Science","Semantics in Databases"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/3-540-36596-6_7","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,4]],"date-time":"2019-05-04T00:03:02Z","timestamp":1556928182000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/3-540-36596-6_7"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003]]},"ISBN":["9783540009573","9783540365969"],"references-count":45,"URL":"https:\/\/doi.org\/10.1007\/3-540-36596-6_7","relation":{},"ISSN":["0302-9743"],"issn-type":[{"type":"print","value":"0302-9743"}],"subject":[],"published":{"date-parts":[[2003]]}}}