Jump to content

Universal relation assumption

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Mdd (talk | contribs) at 13:42, 19 March 2015 (Some rearrangement(s)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The universal relation assumption in relational databases states, that one can place all data attributes into a (possibly very wide) table, which may then be decomposed into smaller tables as needed.[1]

However, the assumption that a single large table can capture real database designs is often plagued with a number of difficulties.[2] The "nested universal relation" model has attempted to address some of the problems and offer improvements.[3]

References

  1. ^ I. T. Hawryszkiewycz, Database analysis and design, 1984. ISBN 0-574-21485-2, pages 59-62.
  2. ^ Carlo Zaniolo, Advances in database technology--EDBT 2000, 2000. ISBN 3-540-67227-3, page 276
  3. ^ Mark Levene, The nested universal relation database model, 2000. ISBN 3-540-55493-9, pages 1-5.