4 Replies Latest reply on Sep 3, 2014 4:28 PM by joguerra

Porting a relational db data to semantic db

joguerra Aug 13, 2014 12:31 PM

Hi,

I have running on Oracle 11g a relational table with around 170M rows and I'd like to port the table to semantic db on Oracle. Does anybody has a hint to start off?. I have an ontology already that fits the rows but I'd like to know which is the best way to migrate this information using Java Jena|Sesame APIs.

Cheers

1. Re: Porting a relational db data to semantic db

alwu-Oracle Aug 27, 2014 12:30 AM (in response to joguerra)

Hi,

With 11g, you probably have to use a relational to RDF mapping tool like D2R. It is quite straightforward to materialize triples into an N-TRIPLE file, once you have a proper mapping. After that, you can bulk load the N-TRIPLE file into Oracle Database.

If you upgrade to 12c, then you can leverage the native RDB2RDF (Direct Mapping & R2RML) support in Oracle.

Thanks,

Zhe Wu
Like Show 0 Likes(0)

Actions
2. Re: Porting a relational db data to semantic db

joguerra Aug 29, 2014 10:21 PM (in response to alwu-Oracle)

Hi,

We are considering to upgrade to 12c, so its likely that we are going to deal with a 12c database at the end. Decision has to be made soon so I'll come back with more clues for it. I presume that the easiest way is to use the tool RDB2RDF, doesn't it?. I'd try to avoid to dump the entire database in a file to load it up straight away in RDF.

thank you for your reply.
Like Show 0 Likes(0)

Actions
3. Re: Porting a relational db data to semantic db

alwu-Oracle Sep 2, 2014 9:06 PM (in response to joguerra)

That is correct. BTW, you may want to take a step-by-step approach. Start with a couple of tables and turn them into RDF. Once you get more comfortable with how things work, you can scale up to a whole schema or multiple schemas.

Hope it helps,

Zhe Wu
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Porting a relational db data to semantic db

joguerra Sep 3, 2014 4:28 PM (in response to alwu-Oracle)

Thank you
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.