-
1. Re: Porting a relational db data to semantic db
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
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
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
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.