Skip to Main Content

Berkeley DB Family

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!

Moving and accessing DBs on fiber channel...

user567642Apr 24 2014 — edited May 8 2014

Hello,

    I want to be able to copy and access db files on fiber channel-based volumes. This access will be a single read-only process.

However, this paragraph in the documentation:

"Also, DB's databases and data structures are designed for concurrent access — they are thread-safe, and they share well across multiple processes. That said, in order to allow multiple processes to share databases and the cache, DB makes use of mechanisms that do not work well on network-shared drives (NFS or Windows networks shares, for example). For this reason, you cannot place your DB databases and environments on network-mounted drives."


is kinda scary. If I'm not using concurrent access, will I be ok?


Thanks.

Comments

Sdas-Oracle
You can do this from a SQL query using SEM_MATCH table function which allows you to specify a SPARQL graph pattern.
SEM_MATCH retrieves relevant data from the RDF store which can then be joined with one or more relational tables.

For more details on use of SEM_MATCH, please refer to documentation at:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sdo_rdf_concepts.htm#CHDJACII
880207
Hi,

I am using Jena & SparQL. I am not sure if i can call SEM_MATCH query directly from Jena. As per my understanding Sparql gets converted to SEM_MATCH query.
As i am calling Sparql query using Jena, I want to use RDBMS table data also with sparql query in a single query.

If possible , kindly share an example , it would be of great help

Thanks and Regards,
Manish H
880207
Any view on above comment
Sdas-Oracle
Use of SPARQL from Jena does not currently allow access to relational tables. A workaround you may consider trying would be to first generate RDF triples from the relational tables and then try querying using SPARQL the original RDF data plus the RDF data generated from relational tables.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 5 2014
Added on Apr 24 2014
1 comment
1,008 views