This Article 
 Bibliographic References 
 Add to: 
Incomplete Relational Database Models Based on Intervals
April 1993 (vol. 5 no. 2)
pp. 293-308

Tables are used to represent unknown relations. The three partial tuple types are defined in a table to specify incompleteness relationships among tuples of the same table. For tuples of different tables, the cases where incompleteness is introduced at the relation level, tuple level, or attribute value level are discussed. For each of the models, it is shown that query evaluation is sound in the Imielinski-Lipski sense. None of the models is complete in the Imielinski-Lipski sense. Two of the models in the family are compared with other approaches.

[1] S. Abiteboul, P. Kanellakis, and G. Grahne, "On the representation and querying of sets of possible worlds," inProc. ACM-SIGMOD Conf., 1987, pp. 34-48.
[2] J. Biskup, "A formal approach to null values in database relations,"Advances in Database Theory, vol. 1, pp. 299-341, 1981.
[3] J. Biskup, "A foundation of Codd's relational maybe operations,"ACM Trans. Database Syst., vol. 8, pp. 608-636, Dec. 1983.
[4] E. F. Codd, "Extending the relational database model to capture more meaning,"ACM Trans. Database Syst., vol. 4, no. 4, pp. 397-434, Dec. 1979.
[5] H. Edelsbrunner and H. A. Maurer, "On the intersection of orthogonal objects,"Inf. Proc. Letters, vol. 13, pp 177-181, 1981.
[6] H. Edelsbrunner, "A new approach to rectangle intersections,"Int. J. Computer Math., vol. 13, pp. 209-219, 1983.
[7] J. Grant, "Partial values in tabular database model",Inf. Proc. letters, vol. 9, no. 3, pp. 97-99, 1979.
[8] J. Grant, "Incomplete information in a relational database,"Fundamental Informat., vol. 3, pp. 363-378, 1980.
[9] R. Guy, "Research problems,"'Amer. Math. Monthly, vol. 84, no. 4, pp. 284-285, 1977.
[10] T. Imielinski, "Incomplete information in logical databases,"Bull. IEEE Tech. Committee on Data Eng., vol. 12, pp. 29-40, 1989.
[11] T. Imielinski and W. Lipski, "Incomplete Information in Relational Databases,"J. ACM, Vol. 31, No. 4, Oct. 1984, pp. 761-791.
[12] A. M. Keller, "Set-theoretic problems of null completion of relational databases,"Inf. Proc. Lett., vol. 22, pp. 261-265, 1986.
[13] J. Leeuwen and D. Wood, "The measure problem for rectangular ranges in d-space,"J. Algorithms, vol. 2, pp. 282-300, 1981.
[14] E. Lien, "Multivalued dependencies with null values in relational databases," inProc. 5th Int. Conf. Very Large Data Bases, 1979, pp. 61-66.
[15] W. Lipski, "On semantic issues connected with incomplete information databases,"ACM Trans. Database Syst., vol. 4, no. 3, pp. 262-296, Sept. 1979.
[16] K.C. Liu and R. Sunderraman, "Indefinite and maybe information in relational databases,"ACM Trans. Database Syst., vol. 15, pp 1-39, Mar. 1990.
[17] D. Maier,The Theory of Relational Databases. Rockville, MD: Computer Science, 1983.
[18] A. Ola and G. Ozsoyoglu, "Geometric modeling of incomplete relational databases," Tech. Rep., CWRU, May 1988.
[19] A. Ola and G. Ozsoyoglu," A family of incomplete relational database models," inProc. Int. Conference on Very Large Databases, 1989, pp 23-31.
[20] R. Reiter, "On closed world databases," inLogic and DatabasesNew York: Plenum, 1978, pp.55-76.
[21] J. Shen, "A main-memory incomplete information DBMS and its performance," M.S. thesis, CWRU, 1988.
[22] H. W. Six and D. Wood, "Counting and reporting intersections of d-Ranges",IEEE Trans. Comput., vol C-31, pp 181-187, 1982.
[23] Y. Vassiliou, "Null values in database management: A denotational semantics approach,"ACM SIGMOD Conf., Boston, MA, 1979, pp. 162-169.
[24] C. Zaniolo, "Database systems with null values",J. Comput. Syst. Sci., vol. 28, pp. 142-166, 1984.

Index Terms:
relational database models; unknown relations; partial tuple types; incompleteness relationships; relation level; attribute value level; query evaluation; Imielinski-Lipski sense; data structures; database theory; relational databases
A. Ola, G. Ozsoyoglu, "Incomplete Relational Database Models Based on Intervals," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 2, pp. 293-308, April 1993, doi:10.1109/69.219737
Usage of this product signifies your acceptance of the Terms of Use.