Re: Nested Relational Model or NF2

In article <44eqlr$dps@gingko.cc.swarthmore.edu> stauffer@swarthmore.edu "R Glenn Stauffer" writes: > nraden@ix.netcom.com (Neil Raden) writes: > > > > > > I would like to find out a little bit more about the Nested > > >Relational Model or NF2. > > > > > > Does anyone have any documentation that can help me? For example any > > >recent paper titles or book names or even a ftp site? > > > > > > > I've lost track of this thread over the years, but I hear through the > > grapevine that Pick claims to have actually implemented this. > > > > Unidata, a PICK-A-LIKE vendor claims to deliver this. They have a www site > where you can find some information: www.unidata.com > > Another place to find info is comp.databases.pick > > Glenn Stauffer Oracle does NF2 much better than Pick, IMHO. The Oracle name for nested tables is CLUSTER. The Pick data model requires the programmer to be aware of nesting structure and ordering detail. Pick requires substantial program changes should the nesting structure change. With Oracle it's just a DBA issue: Cluster uncluster recluster. -- Paul Beardsell SAM Business Systems Ltd ~~~~~~~~~~~~~~ 21 Finn House, Bevenden St, pbeardsell@cix.compulink.co.uk London, N1-6BN, UK. psb@sambusys.demon.co.uk (+44 or 0)171 608-2391