The Nested Universal Relation Database Model: 595 (Lecture Notes in Computer Science, 595) - Softcover

Levene, Mark

Softcover

ISBN 10: 3540554939 ISBN 13: 9783540554936

Publisher: Springer Berlin Heidelberg, 2008

Synopsis

This monograph describes a method of data modelling whose basic aim is to make databases easier to use by providing them with logical data independence. To achieve this, the nested UR (universal relation) model is defined by extending the classical UR model to nested relations. Nested relations generalize flat relations and allow hierarchically structured objects to be modelled directly, whereas the classical UR model allows the user to view the database as if it were composed of a single flat relation. The author presents a comprehensive formalisation of the nested relational model, which incorporated null values into the model. Functional data dependencies and the classical notion of lossless decomposition are extended to nested relations and an extended chase procedure is defined to test the satisfaction of the data dependencies. The nested UR model is defined, and the classical UR model is shown to be a special case of the nested model.This implies that an UR interface canbe implemented by using the nested UR model, thus gaining the full advantages of nested relations over flat relations.

Edition details

• Publisher: Springer Berlin Heidelberg
• Publication date: 2008
• Language: English
• ISBN 10: 3540554939
• ISBN 13: 9783540554936
• Binding: Paperback
• Number of pages: 192