Data import from RDB to TDB

[lewis john mcgibbney <le...@gmail.com>]

Hi list,

I've been working on an XML authoring project and we currently store our XML
models in MySQL. So far we only provide formal structure in the models, but
I'm interested in the semantic annotation aspect therefore a traditional
XSLT looks like the option to get this stuff into RDF/XML which will then
provide the basis for creating a richer information resource. I'm looking to
get conformation on whether using the Jena API to import data directly into
TDB or even Fuseki as well as applying an XSLT is possible or would this be
covered by the API import process removing the requirement for an XSLT. My
intention is to have a development MySQL datastore which would be interim
synced to the triple store. This in turn would then be available for
production use. I'm pretty sure that this is a common use case so apologies
for the newbie type question however I would like to verify the exact
process.

Thanks in advance


-- 
*Lewis*

Re: Data import from RDB to TDB

[lewis john mcgibbney <le...@gmail.com>]

Hi Dave,

If I remove my confusing comments regarding API import process, you have
fully answered my question. Thanks very much for your time.

Regards
Lewis

On Thu, Oct 13, 2011 at 8:58 AM, Dave Reynolds <da...@gmail.com>wrote:

> On Wed, 2011-10-12 at 22:22 +0100, lewis john mcgibbney wrote:
> > Hi list,
> >
> > I've been working on an XML authoring project and we currently store our
> XML
> > models in MySQL. So far we only provide formal structure in the models,
> but
> > I'm interested in the semantic annotation aspect therefore a traditional
> > XSLT looks like the option to get this stuff into RDF/XML which will then
> > provide the basis for creating a richer information resource. I'm looking
> to
> > get conformation on whether using the Jena API to import data directly
> into
> > TDB or even Fuseki as well as applying an XSLT is possible or would this
> be
> > covered by the API import process removing the requirement for an XSLT.
>
> Don't know what you mean by "API import process".
>
> It is certainly possible to write java code which will take an XML
> document, apply an XSLT to convert it to RDF/XML, then read that RDF/XML
> stream into a model (including a TDB model).
>
> Whether it's better to do that or use an offline process to convert to
> RDF/XML files first would, I guess, depend on how much data you are
> dealing split across how many models. Doing it as a simple external
> script would be the easiest way to get started - set up an export and
> transform script to generate the RDF/XML files then use tdbloader to
> load up your TDB and point Fuseki at it.
>
> Dave
>
>
>


-- 
*Lewis*

Re: Data import from RDB to TDB

[Dave Reynolds <da...@gmail.com>]

On Wed, 2011-10-12 at 22:22 +0100, lewis john mcgibbney wrote: 
> Hi list,
> 
> I've been working on an XML authoring project and we currently store our XML
> models in MySQL. So far we only provide formal structure in the models, but
> I'm interested in the semantic annotation aspect therefore a traditional
> XSLT looks like the option to get this stuff into RDF/XML which will then
> provide the basis for creating a richer information resource. I'm looking to
> get conformation on whether using the Jena API to import data directly into
> TDB or even Fuseki as well as applying an XSLT is possible or would this be
> covered by the API import process removing the requirement for an XSLT.

Don't know what you mean by "API import process".

It is certainly possible to write java code which will take an XML
document, apply an XSLT to convert it to RDF/XML, then read that RDF/XML
stream into a model (including a TDB model).

Whether it's better to do that or use an offline process to convert to
RDF/XML files first would, I guess, depend on how much data you are
dealing split across how many models. Doing it as a simple external
script would be the easiest way to get started - set up an export and
transform script to generate the RDF/XML files then use tdbloader to
load up your TDB and point Fuseki at it.

Dave