-
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
-
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.
-
3. Re: Porting a relational db data to semantic db
alwu-Oracle Sep 2, 2014 9:06 PM (in response to joguerra)1 person found this helpfulThat 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 -
4. Re: Porting a relational db data to semantic db
joguerra Sep 3, 2014 4:28 PM (in response to alwu-Oracle)Thank you