Mailing-List: contact tuscany-dev-help@ws.apache.org; run by ezmlm
Precedence: bulk
Reply-To: tuscany-dev@ws.apache.org
Received-SPF: pass (herse.apache.org: local policy)
Message-ID: <461A5D92.5000408@qwest.net>
Date: Mon, 09 Apr 2007 09:36:50 -0600
From: Kevin Williams <kevincbw@qwest.net>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: tuscany-dev@ws.apache.org
Subject: Re: [DAS Java] created SDO graph doubt
References: <55e2bf7e0704032315jf557341w98a75578b3b27601@mail.gmail.com>
	 <4613F150.8070401@qwest.net>
	 <55e2bf7e0704042351k7b38865emcc1c08e2df93e219@mail.gmail.com>
 <55e2bf7e0704070021x4273ca71h39143cfeab6a3564@mail.gmail.com>
In-Reply-To: <55e2bf7e0704070021x4273ca71h39143cfeab6a3564@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello Adriano,
To return a graph of related elements, the RDB DAS depends on the user 
providing a Query that expresses the relationship between the elements.  
This is most often done by providing a query that includes a join.  See 
the "relationship" examples in the DAS test suite.
Thanks,
--Kevin


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 
>
>
> 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
>
> On 4/5/07, Adriano Crestani <adrianocrestani@gmail.com> wrote:
>
>>
>> Thanks kelvin ; )
>>
>> Adriano Crestani
>>
>> On 4/4/07, Kevin Williams <kevincbw@qwest.net> wrote:
>> >
>> > The RDB DAS will only populate a graph with data returned from the 
>> used
>> > query.  If you want a graph that contains data from related tables 
>> then
>> > the query provided must return that data (typically a join).  The
>> > relationship tests in the test suite demonstrate this.
>> > --Kevin
>> >
>> > Adriano Crestani wrote:
>> >
>> > > Let me try to explain my doubt:
>> > >
>> > > Lets suppose I create a select command and execute it. The returned
>> > > ResultSet has an attribute that belongs to the table X and is a 
>> FK to
>> > the
>> > > table Y, but no Y attribute is contained in the ResultSet. The
>> > > question is:
>> > > does the das create, and also populate, the SDO graph only with the
>> > > metadata
>> > > and data contained in the ResultSet or the das also adds to the SDO
>> > graph
>> > > the referenced Y table and its attributes and keep doing it till 
>> there
>> > > is no
>> > > more referenced table?
>> > >
>> > > I expect to be clear enough ; )
>> > >
>> > >
>> > > Adriano Crestani
>> > >
>> >
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
>> > For additional commands, e-mail: tuscany-dev-help@ws.apache.org
>> >
>> >
>>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-dev-help@ws.apache.org