Sets and Uncertainty in Relational Databases

A number of approaches that have been taken to using sets to represent compound values and uncertain information in relational databases. We review three such approaches (collective sets, disjunctive sets and generalized sets), and propose a new approach (restricted cardinality sets), in which every set is accompanied by a range of possible cardinalities of the actual value represented. We show that this approach generalizes the other approaches, leading to a simpler, more flexible representation. We also consider defining algebraic operations on the sets.

[1]  Stan J. Thomas A non-first-normal-form relational database model , 1983 .

[2]  David Maier,et al.  The Theory of Relational Databases , 1983 .

[3]  Hans-Jörg Schek,et al.  Remarks on the algebra of non first normal form relations , 1982, PODS.

[4]  Claude Delobel,et al.  Normalization and hierarchical dependencies in the relational data model , 1978, TODS.

[5]  Takao Miura,et al.  Operations and the Properties on Non-First-Normal-Form Relational Databases , 1983, VLDB.

[6]  Ian A. Macleod,et al.  A Model for Integrated Information Systems , 1983, VLDB.

[7]  Akifumi Makinouchi,et al.  A Consideration on Normal Form of Not-Necessarily-Normalized Relation in the Relational Data Model , 1977, VLDB.

[8]  Hans-Jörg Schek,et al.  The relational model with relation-valued attributes , 1986, Inf. Syst..

[9]  Hans-Jörg Schek,et al.  Data Structures for an Integrated Data Base Management and Information Retrieval System , 1982, VLDB.

[10]  Witold Lipski,et al.  On semantic issues connected with incomplete information databases , 1979, ACM Trans. Database Syst..

[11]  Sylvia L. Osborn,et al.  The design of a relational database system with abstract data types for domains , 1986, TODS.

[12]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[13]  Witold Lipski,et al.  On Databases with Incomplete Information , 1981, JACM.

[14]  John Grant,et al.  Answering Queries in Indefinite Databases and the Null Value Problem , 1986, Adv. Comput. Res..

[15]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[16]  Jeffrey D. Ullman,et al.  Principles of Database Systems , 1980 .