Incomplete Information in Relational Databases

Journal of the ACM (JACM)

Volumn 31, Issue 4, 1984, Pages 761-791

  Imieliński, Tomasz ^a,b   Lipski, Witold ^a,c  

^a POLISH ACADEMY OF SCIENCES   (Poland)

^b Hill Center for the Mathematical Sciences   (United States)

^c UFR 919 Laboratoire d'Informatique Pour la Mécanique et les Sciences de l'Ingénieur   (France)

Author keywords

[No Author keywords available]

Indexed keywords

INCOMPLETE INFORMATION; QUERY PROCESSING; RELATIONAL DATBASES;

DATABASE SYSTEMS;

EID: 0021513522     PISSN: 00045411     EISSN: 1557735X     Source Type: Journal    
DOI: 10.1145/1634.1886     Document Type: Article

References (34)

1. Aho, A. V., Sagiv, Y., and Ullman, J. D. Equivalences among relational expressions. SIAM J Comput 8, 2 (May 1979), 218-246.
2. Bgeri. C, and Vardi, M. V. Formal systems for tuple and equality generating dependencies. SIAM. Compul 13, 1 (Feb. 1984), 76-98.
3. Biskup, J. A formal approach to null values in database relations. In Advances in Database Theory, H. Gallaire, J. Minker, and J.M. Nicolas, Eds. Plenum Press, New York, 1981, pp. 299-341.
4. Chandra, A. K., and Merlin, P. M. Optimal implementation of conjunctive queries in relational data bases. In Proceedings of the 9th Annual ACM Symposium on Theory of Computing (Boulder, Col., May 2-4). ACM, New York, 1977, pp. 77-90.
5. Codd, E.F. A relational model for large shared data banks. Commun ACM 13, 6 (June 1970), 377-387.
6. Codd, E. F. Relational completeness of data base sublanguages. In Data Base Systems, R. Rustin, Ed. Prentice-Hall, Englewood Cliffs, N.J., 1972, pp. 65-98.
7. CODD, E. F. Understanding relations (Installment #7). FDT Bull, of ACM-SIGMOD 7,3-4 (Dec. 1975), 23-28.
8. Codd E.F. Extending the database relational model to capture more meaning. ACM Trans Database Syst 4,4 (Dec. 1979), 397-434.
9. Garey, M. R., and Johnson, D. S. Computers and Intractability: A Guide to the Theory of NP-completeness. Freeman, San Francisco, Calif., 1979.
10. Grant, J. Null values in a relational data base. Inf Process. Leu. 6, 5 (Oct. 1977), 156-157.
11. Horowitz, E., and Sahni, S. Fundamentals of Computer Algorithms Computer Science Press, Potomac, Md., 1979.
12. Imielinski, T. Problems of representing information in relational databases (in Polish). Ph.D. Thesis, Institute of Computer Science, Polish Academy of Sciences, 1981.
13. Imielinski, T., and Ljpski, W. On representing incomplete information in a relational data base. In Proceedings of the 7th International Conference on Very Large Data Bases (Cannes, France, Sept. 9-11) ACM, New York, 1981, pp. 388-397.
14. Imielinski, T., and Lipski, W. The relational model of data and cylindric algebras. J. Comput. System Sci. 28,1 (Feb. 1984), 80-102.
15. Imielinski, T., and Lipski, W. A technique for translating states between database schemata. In Proceedings of the ACM SJGMOD International Conference on Management of Data (Orlando, Fla., June 2-4). ACM, New York, 1982, pp. 61-68.
16. Imielinski, T., and Lipski, W. Incomplete information and dependencies in relational databases. In Proceedings of the ACM SIGMOD International Conference on Management of Data (San Jose, Calif., May 23-26). ACM, New York, 1983, pp. 178-184.
17. Imielinski, T., and Lipski, W. Inverting relational expressions-a uniform and natural technique for various database problems. In Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems (Atlanta, Ga., March 21-23). ACM, New York, 1983, pp. 305-311.
18. Lacroix, M., and Pirotte, A. Generalized joins. ACM-SIGMOD Record 8, 3 (Sept. 1976), 14-15.
19. Lipski, W. Informational systems with incomplete information. In Proceedings of the 3rd International Colloquium on Automata, Languages and Programming (Edinburgh, Scotland, July 2023). Edinburgh University Press, Edinburgh, Scotland, 1976, pp. 120-130.
20. Lipski, W. On semantic issues connected with incomplete information databases. ACM Trans Database Syst 4, 3 (Sept. 1979), 262-296.
21. Lipski, W, On databases with incomplete information. J. ACM 28, 1 (Jan. 1981), 41-70.
22. Lipski, W. Logical problems related to incomplete information in databases. Tech. Rep. 138, Laboratoire de Recherche en Informatique, University de Paris-Sud, Centre d'Orsay, Sept. 1983.
23. Lipski, W. On relational algebra with marked nulls. In Proceedings of the 3rd ACM SIGACT-SIGMOD Symposium on Principles of Database Systems (Waterloo, Ont., Canada, April 2-4). ACM, New York, 1984, pp. 201-203.
24. Maier, D., Ullman, J. D., and Vardi, M. Y. On the foundations of the universal relation model. ACM Trans. Database Syst. 9, 2 (June 1984), 283-308.
25. Reingold, E. M., Nievergelt, J., and Deo, N. Combinational Algorithms: Theory and Practice. Prentice Hall, Englewood Cliffs, N.J., 1977.
26. Reiter, R, On closed world databases. In Logic and Data Bases, H. Gallaire and J. Minker, Eds. Plenum Press, New York, 1978, pp. 55-76.
27. Reiter, R. Towards a logical reconstruction of relational database theory. In Conceptual Modelling, Perspectives from Artificial Intelligence, Databases and Programming Languages, M.L. Brodie, J. Mylopoulos, and J. Schmidt, Eds. Springer-Verlag, New York, 1984, pp. 191-233.
28. Siklossy, L. Efficient query evaluation in relational databases with missing values. Inf. Process. Lett 13, 4 / 5 (End 1985), 160-163.
29. Ullman, J.D. Principles of Database Systems. 2nd ed. Computer Science Press, Potomac, Md., 1982.
30. Vassiliou, Y. Null values in data base management: A denotationai semantics approach. In Proceedings of the ACM-SIGMOD International Symposium on Management of Data (Boston, Mass., May 30-June 1). ACM, New York, 1979, pp. 162-169.
31. Vassiliou, Y. Functional dependencies and incomplete information. In Proceedings of the 6th International Conference on Very Large Data Bases (Montreal, Ont., Canada, Oct. 1-3). ACM, New York, 1980, pp. 260-269.
32. Yannakakis, M., and Papadimitriou, C.H. Algebraic dependencies. J. Comput Syst. Set. 25, I (Aug. 1982), 2-41.
33. Zaniolo, C. Relational views ia a data base system support for queries. la Proceedmgs of the IEEE Computer Software and Applications Conference (Chicago, 111., Nov. 8-11). IEEE, New York, 1977, pp. 267-275.
34. Zaniolo, C. Database relations with null values. In Proceedings of the ACM SlGACT-SIGMOD Symposium on Principles of Database Systems (Los Angeles, Calif., March 29-31). ACM, New York, 1982, pp. 27-33.