Re: Storing data and code in a Db with LISP-like interface

Neo wrote:
> Below is an updated view of things in the tree. In the prior one, the
> email addresses could not be read, so I have added a space before the @
> symbol in this post. Also I added a view of types Names and Verbs and
> their relevant instances. The script does not make these a direct item
> under the main directory (Dir) as they are relatively minor types. I
> will now take a closer look at your web link.
>
> Dir
> |-item-
> |-Building
> | |-instance-
> | |-CourtHouse1
> | |-has-
> | |-Floor1+
> | |-Floor2+
> | |-Courtney+
> |
> |-Floor
> | |-instance-
> | |-Floor1
> | | |-has-
> | | |-Room1+
> | | |-Ashley+
> | |
> | |-Floor2
> | |-has-
> | |-Room1+
> | |-Room2+
> |
> |-Room
> | |-instance-
> | |-Room1 (of Floor1)
> | | |-has-
> | | |-Clark+
> | |
> | |-Room1 (of Floor2)
> | |
> | |-Room2 (of Floor2)
> | |-has-
> | |-Judy+
> |
> |-Person
> | |-instance-
> | |-Judy
> | | |-phone#-
> | | | |-333-5555
> | | | |-JDG-JUDY
> | | |
> | | |-email-
> | | | |-J @aol.com
> | | | |-Judy @law.com
> | | |
> | | |-staffMember-
> | | |-Clark+
> | | |-Ashley+
> | | |-Colby+
> | | |-Brandy+
> | | |-Courtney+
> | |
> | |-Clark
> | | |-phone#-
> | | | |-737-5588
> | | |
> | | |-assistant-
> | | |-Ashley+
> | |
> | |-Ashley
> | | |-phone#-
> | | |-737-5588
> | |
> | |-Colby
> | | |-email-
> | | |-Colby @msn.com
> | |
> | |-Brandy
> | | |-phone#-
> | | |-919-9945
> | |
> | |-Courtney
> | |-phone#-
> | | |-203-9898
> | |
> | |-email-
> | |-C @gov.org
> |
> |-Judge
> | |-instance-
> | |-Judy+
> |
> |-StaffMember
> | |-instance-
> | |-Clark+
> | |-Ashley+
> | |-Colby+
> | |-Brandy+
> | |-Courtney+
> |
> |-Clerk
> | |-instance-
> | |-Clark+
> | |-Ashley+
> |
> |-Assistant
> | |-instance-
> | |-Ashley+
> |
> |-Coordinator
> | |-instance-
> | |-Colby+
> |
> |-Bailiff
> | |-instance-
> | |-Brandy+
> |
> |-CourtReporter
> | |-instance-
> | |-Courtney+
> |
> |-Phone#
> | |-instance-
> | |-333-5555
> | |-JDG-JUDY
> | |-737-5588
> | |-919-9945
> | |-203-9898
> |
> |-Email
> | |-instance-
> | |-J @aol.com
> | |-Judy @law.com
> | |-Colby @msn.com
> | |-C @gov.org
> |
> |-Type
> |-instance-
> |-Name
> | |-instance-
> | |-Building
> | |-Floor
> | |-Room
> | |-Person
> | |-Judge
> | |-StaffMember
> | |-Clerk
> | |-Assistant
> | |-Coordinator
> | |-Bailiff
> | |-CourtReporter
> | |-Phone#
> | |-Email
> | |-Has
> | |-Judy
> | |-333-5555
> | |-JDG-JUDY
> | |-J @aol.com
> | |-Judy @law.com
> | |-Clark
> | |-737-5588
> | |-Ashley
> | |-Colby
> | |-Colby @msn.com
> | |-Brandy
> | |-919-9945
> | |-Courtney
> | |-203-9898
> | |-C @gov.org
> | |-CourtHouse1
> | |-Floor1
> | |-Room1
> | |-Floor2
> | |-Room2
> |
> |-Verb
> | |-instance-
> | |-Has
> |
> |-Etc...

This is a typical structure of a "navigational" or "hierarchical" database. They are fine for particular specific uses, but over time people found they grew into messes and are hard to query for unforseen questiones. Dr. Codd was working with stuff like this when he fealt there should be a better way.

I cannot give specific scenarios to demonstrate where it falls apart right now. I'll have to get back to you on that.

-T- Received on Tue Apr 18 2006 - 23:54:11 CDT