> >Draw a hundred dots on a piece of paper and arbitrarily connect lines
> >between them until it looks like a hair ball. Give each dot a name.
> >Now fit that data in rectangular tables called "relations" and let me
> >know if it looks very well suited for this type of application.
>
> How about:
> create table edges
> (start_x int, start_y int,
> end_x int, end_y int,
> primary key(
> start_x int, start_y int,
> end_x int, end_y int)
> );
Yes, the data can be represented by generic modelling meaning
everything in one table. But consider that each dot may represent
different kinds/types of things (persons, airplanes, colors, jobs,
chairs, etc). IMO, the rdb data model is not well suited for this type
of problem.
Received on Sat May 03 2003 - 12:05:06 CDT
