Re: The stupidest design I ever saw
Date: 5 Apr 2006 19:06:00 -0700
Message-ID: <1144289160.169699.139420_at_i39g2000cwa.googlegroups.com>
Neo wrote:
> > The folks who wrote this apparently have no idea that graph is defined by the set of nodes and edges between them. They wrap their naive understanding what the graph is into XML cludgy syntax and claim it to be a superior solution.
> .
> What is the better solution? Could you show it (possibly using the
> vehicle classes above)?
To what kind of problem? Do you really insist on vehicle classification
in the first place? You may want spend some time on Bruce Jacobs site
where he advocates that classification system for data management
problems is a poor solution in general.
Note, that I'm not saying that graph related problems don't exist. I
merely challenge their applicability in this case.
Now, storing a graph in the database is no brainer.
table Nodes (
id number,
table Edges (
tail number,
... -- content
)
head number,
I have two chapters about trees and graphs in my book. http://www.rampant-books.com/book_2006_1_sql_coding_styles.htm Received on Thu Apr 06 2006 - 04:06:00 CEST