W3C home > Mailing lists > Public > public-rdb2rdf-comments@w3.org > October 2011

Re: A way to generate PK-strings or new blank nodes

From: David McNeil <dmcneil@revelytix.com>
Date: Thu, 20 Oct 2011 13:52:06 -0500
Message-ID: <CA+8VvdxmN_hd4oOo3SN8wPAt-5qNUMOz3XThkLR2JKS3UzftXg@mail.gmail.com>
To: Fabian Pijcke <fabian.pijcke@gmail.com>
Cc: public-rdb2rdf-comments@w3.org
On Thu, Oct 20, 2011 at 11:36 AM, Fabian Pijcke <fabian.pijcke@gmail.com>wrote:

> because I don't know the fields into my tables,
> I cannot create a template that will make only unique
> values, and I cannot do it for blank node labels anymore.
>

<snip>


> Or perhaps does anybody know a way to generate the
> PK-string using an R2RML mapping ? Please let me know ...


Fabian - I may not properly understand what you are asking, but perhaps this
would work: write a SQL query to query the underlying data and include a row
identifier column. Use that query as a logical table in an R2RML mapping and
define the subject URI in terms of the row identifier.

-David
Received on Thursday, 20 October 2011 18:52:34 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Thursday, 20 October 2011 18:52:34 GMT