Re: And again: 1NF may not be dead

From: Neo <neo55592_at_hotmail.com>
Date: 28 Oct 2004 12:36:34 -0700
Message-ID: <4b45d3ad.0410281136.68a3b3e6_at_posting.google.com>


> John Doe (123) 555-1234 jdoe_at_msn.com
> (232) 555-2837 john_doe_at_aol.com
> jd_at_johndoe.org

With XDb2:

CREATE2 *person.cls = thing;
CREATE2 *phone.cls = thing;
CREATE2 *email.cls = thing;

CREATE2 *john doe.cls = person;

CREATE2 john doe.phone = +'(123)555-1234';
CREATE2 john doe.phone = +'(232)555-2837';
CREATE2 john doe.email = +'jdoe_at_msn.com';
CREATE2 john doe.email = +'john_doe_at_aol.com';
CREATE2 john doe.email = +'jd_at_johndoe.org';

One view of above things in the tree is shown below:

thing
  inst: person
    inst: john doe

      phone: (123)555-1234 
      phone: (232)555-2837
      email: jdoe_at_msn.com
      email: john_doe_at_aol.com
      email: jd_at_johndoe.org


One view of above things in the grid is shown below:

person name     phone    phone    email      email          email
id     john doe 555-1234 555-2837 jdoe_at_msn.. john_doe_at_aol.. jd_at_johndoe..

Note: cls/inst are abbreviations for class/instance. Received on Thu Oct 28 2004 - 21:36:34 CEST

Original text of this message