Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

I currently have an application which runs on Oracle RDBMS and an area of new functionality which would be better supported by a NoSQL store. I am wondering if Oracle NoSQL Database may be a good place to store this information and more concretely, can a single query span Oracle NoSQL and Oracle RDBMS.

share|improve this question
2  
Without further information about your workload, production environment, requirements, etc, it is impossible to tell if Oracle NoSQL (or anything else for that matter) will work well. – Max Vernon Dec 20 '12 at 21:33
I added the essential question I was asking as the environment, requirements etc all are extraneous to this one key question. – Thronk Dec 20 '12 at 22:07
1  
Oracle's NoSQL solution is a completely self-contained solution. I very much doubt there is any bridge to run queries across both systems. – a_horse_with_no_name Dec 20 '12 at 22:25
2  
docs.oracle.com/cd/NOSQL/html/javadoc/oracle/kv/exttab/… "This package contains the public API and Utilities for accessing Oracle NoSQL Database data through Oracle Database External Tables." - That's the only thing I can find as far as integration between the two, and doesn't look very "sexy" (EE only too). But I'm not familiar with the product. – Mat Dec 21 '12 at 6:44
That is valuable to know though - Thank you Mat – Thronk Dec 21 '12 at 14:43

2 Answers

up vote 0 down vote

http://docs.oracle.com/cd/NOSQL/html/GettingStartedGuide/introduction.html

"To make use of Oracle NoSQL Database, code must be written (using Java or C) that runs on the application server....The requests are made using the Oracle NoSQL Database Driver, which is linked into your application as a Java library"

So, I believe the answer is no with the exception of possibly the way Mat pointed out in the comments section

share|improve this answer
up vote 2 down vote

Oracle NoSQL Database integrates well with the Oracle database. You can run an SQL query in Oracle Database that can reference data in the Oracle database as well as NoSQL Database.

Please see the Oracle NoSQL Database documentation for more details on external tables support.

You can also get an overview of the latest release here: http://www.youtube.com/watch?v=VT2n1QhIprQ

I'd suggest that you also post your questions relating to Oracle NoSQL Database to the OTN forum: https://forums.oracle.com/forums/forum.jspa?forumID=1388. We monitor the forums regularly...

Happy Holidays.

Ashok Joshi Senior Director, Oracle NoSQL Database development

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.