I responded before this was moved to "... graph doubt 2". See my answer
there.
Adriano Crestani wrote:
> Another doubt:
>
> I have the following tables on my database:
>
> create table B (
> ID INTEGER NOT NULL PRIMARY KEY
> );
>
> create table A (
> ID INTEGER NOT NULL PRIMARY KEY,
> B_ID INTEGER,
> FOREIGN KEY (B_ID) REFERENCES B(ID)
> );
>
> OK, then I was analyzing the generated sdo graph when I execute the query
> "select * from A, B;", I got something like this:
>
> Graph1:
> http://cwiki.apache.org/confluence/download/attachments/45093/das_graph.JPG
>
>
> I understand the column B_ID would be considered only an integer
> column when
> of table A when there is no B table returned on the query. However, the B
> table is also returned on the query and as the B_ID column is a FK to the
> table B, shouldn't the graph be like this?:
>
> Graph2:
> http://cwiki.apache.org/confluence/download/attachments/45093/das+
> graph+as+I+suppose+it+shoud+be.JPG
> <http://cwiki.apache.org/confluence/download/attachments/45093/das+graph+as+I+suppose+it+shoud+be.JPG>
>
>
> This way I think the data returned by the query would be better
> represented
> on the graph. Maybe there is a reason for the graph to be generated as
> Graph1 instead of Graph2.
> What do you say guys?
>
> Adriano Crestani
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org
|