Universal relation assumption

From Wikipedia, the free encyclopedia

In relational databases, the universal relation assumption 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. Database analysis and design by I. T. Hawryszkiewycz, 1984 ISBN 0-574-21485-2 pages 59-62
  2. Advances in database technology--EDBT 2000 by Carlo Zaniolo 2000 ISBN 3-540-67227-3 page 276
  3. The nested universal relation database model by Mark Levene 1992 ISBN 3-540-55493-9 pages 1-5

External links


This article is issued from Wikipedia. The text is available under the Creative Commons Attribution/Share Alike; additional terms may apply for the media files.