Re: Do Data Models Need to built on a Mathematical Concept?

From: Neo <neo55592_at_hotmail.com>
Date: 3 May 2003 10:05:06 -0700
Message-ID: <4b45d3ad.0305030905.2e8c66f5_at_posting.google.com>


> >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 - 19:05:06 CEST

Original text of this message