The Nested Universal Relation Database Model (lecture Notes In Computer Science)

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.--publisher's Website. M. Levene. Revision Of The Author's Thesis (ph. D.)--birkbeck College, 1990. Includes Bibliographical References (p. ) And Index. Introduction....Pages 1-9 The underlying database models....Pages 11-33 The null extended nested relational model....Pages 35-75 Null extended data dependencies and the extended chase....Pages 77-107 A universal relation model for a nested database....Pages 109-135 A universal relation model for a single nested relation....Pages 137-157 Concluding remarks and ongoing research....Pages 159-161