Subject Re: [firebird-support] DDL for graph edges
Author Michael Ludwig
Doug Chamberlin schrieb am 02.05.2010 um 18:36:09 (-0400):
> On 5/2/2010 2:21 PM, Michael Ludwig wrote:
> > I'm building a model for holding a graph such as for a social
> > network. There is a table to hold the users (nodes), and another to
> > hold the acquaintances (edges). I'm wondering how best to define the
> > edge table.
> >
> Aren't social networks comprised of connections between peers? If so,
> wouldn't the more accurate and easier data model to have just one
> table listing each person

Which is the table for users (nodes), named "USR" in my example.

> with a second table that reflects the many-to-many relationships
> between two people in the first table?

Which is the table for acquaintances (edges), named "FS" in my example.

Maybe I misled you by writing *acquaintances*, when I should rather have
written *relationships*, which is what I meant.

So, s/acquaintance/relationship/g. Sorry and thanks for answering.

Michael Ludwig