W3C home > Mailing lists > Public > public-rdb2rdf-wg@w3.org > August 2011

Re: PROPOSAL for Direct Mapping predicate IRI design for foreign-key

From: Marcelo Arenas <marcelo.arenas1@gmail.com>
Date: Tue, 9 Aug 2011 12:10:45 -0400
Message-ID: <CA+7aXj4dCEPpj+SPv0xDZNvADkPe8_e49QByKi52dy2B+JLQNw@mail.gmail.com>
To: Souripriya Das <souripriya.das@oracle.com>
Cc: RDB2RDF WG <public-rdb2rdf-wg@w3.org>
On Tue, Aug 9, 2011 at 11:55 AM, Souripriya Das
<souripriya.das@oracle.com> wrote:
> The same sequence of columns in a child table may be used for multiple
> foreign keys:
> For example:
>     create table t12 (x int, y int, val number
>          , foreign key(x,y) references t1(a,b)
>          , foreign key(x,y) references t2(c,d));
>
> Current syntax is based solely on the sequence of columns in the child
> table:
> Example: <People#deptName,deptCity>
>
> This IRI syntax for the predicate is therefore not sufficient. It needs to
> also include the target table and corr. column sequence in the target table.
>
> PROPOSAL: Enhance syntax to include the parent table name and corresponding
> column sequence in the parent table
> Example: <People,Department#deptName,name;deptCity,city>
>
> Thanks,
> - Souri.
>


+1

Cheers,

Marcelo
Received on Tuesday, 9 August 2011 16:11:20 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 6 January 2015 21:00:26 UTC