Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sync between RDF store and relational table

HansCMar 7 2014 — edited Mar 13 2014

I start up this question in a new thread as it goes into a different problem domain,

One of the option to model the object attributes is to store attributes in a separate relational table and use a SQL to join the graph query results. Now here is a situation, if we want to join, we need to keep some reference key in the RDF datastore, so that they can join together. But it comes out a issue, how we sync the data? Suppose we keep a user node in RDF with property user ID and we keep all other user info in relational table. When we do join, we can join by user ID. But if we delete that user record in relational table, most likely RDF will not delete that user node in graph datastore. Am I correct on this point or Oracle has some sort of way to maintain the data sync?

Thanks.

This post has been answered by alwu-Oracle on Mar 13 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 10 2014
Added on Mar 7 2014
1 comment
1,198 views