INCOMPLETE RELATIONAL DATABASE MODELS BASED ON INTERVALS

Authors
Citation
A. Ola et G. Ozsoyoglu, INCOMPLETE RELATIONAL DATABASE MODELS BASED ON INTERVALS, IEEE transactions on knowledge and data engineering, 5(2), 1993, pp. 293-308
Citations number
24
Categorie Soggetti
Information Science & Library Science","Computer Sciences, Special Topics","Computer Applications & Cybernetics
ISSN journal
10414347
Volume
5
Issue
2
Year of publication
1993
Pages
293 - 308
Database
ISI
SICI code
1041-4347(1993)5:2<293:IRDMBO>2.0.ZU;2-4
Abstract
In this paper, we utilize intervals for unknown values in incomplete r elational databases. We use tables to represent unknown relations. Fir st, we define three partial tuple types in a table to specify incomple teness relationships among tuples of the same table. For tuples of dif ferent tables, we distinguish between the cases where incompleteness i s introduced at the relation level, tuple level, or attribute value le vel. Also, based on these relationships among tuples in different tabl es, we present a family of incomplete relational database models. For each of the models, we show that query evaluation is sound (i.e., no i ncorrect results are derivable) in the Imielinski-Lipski sense. None o f the models is complete (i.e., all valid conclusions are derivable) i n the Imielinski-Lipski sense. We briefly compare two of the models in the family with other approaches. Considering each table tuple as a s et of d-dimensional cubes, each model in the family of models presente d in this paper can be considered and implemented as a geometric datab ase model. We briefly summarize the geometric operations and the primi tive update semantics that need to be utilized in such an implementati on.