plsql and Oracle NoSQL - NoSQL Database

Hi,
Our main data source is in Oracle 11g database on top we build app that queries data with PLSQL.
We would like to port certain data to Oracle NoSQL and use it in our app.
What would be best approach to use PLSQL to manipulate data in Oracle NoSQL. I can see that there is no direct way - what would be best "non-direct"? Calling java from PLSQL? Any other?
Thanks! 

user11202580 wrote:
Hi,
Our main data source is in Oracle 11g database on top we build app that queries data with PLSQL.
We would like to port certain data to Oracle NoSQL and use it in our app.
What would be best approach to use PLSQL to manipulate data in Oracle NoSQL. I can see that there is no direct way - what would be best "non-direct"? Calling java from PLSQL? Any other?Ummm, using PLSQL to manipulate NoSQL will be difficult to do. Presently, the way you manipulate Oracle NoSQL data is using the Oracle NoSQL Java API.
Charles Lamb

Related

Is ORDS Oracle NoSQL's support for REST, or is there something built in?

Is ORDS Oracle NoSQL's support for REST, or is there something built in? I am trying to understand this statement in the data sheet: Oracle RESTful ServicesThe Oracle NoSQL Database includes support for exposing the Oracle NoSQL Database tables as REST API endpoints. The data stored in the tables can be created, queries, updated, and deleted using REST with JSON filters. This allows customers to build a REST based application that can access data in either the Oracle Database or the Oracle NoSQL Database.
What this means is there's a support for Oracle NoSQL Database in Oracle REST Data Services(ORDS) - please refer to the doc for details https://docs.oracle.com/cd/E56351_01/doc.30/e87809/NoSQL-and-REST.htm#AELIG90000  Hope it helps ? Anand

Processing oracle relational data with hadoop

hello every body:
i would like if it possible to process oracle relational data with hadoop in order to get better performance
native parallel processing in oracle VS hadoop processing? who is the better?
how can we do it?
thank you at advance 
Hello,
This is the Oracle NoSQL Database forum. You asked about Oracle Database so you may want to try that forum instead of this one. I suggest that you ask about "In-Database Map/Reduce".
Charles

MAP/REDUCE and Oracle NoSQL

Hi all,
I would like to know if there are some examples on how to run run map/reduce with Oracle NoSQL.
Is there any source code any where? Can you send me one example?
Where can we download all the necessary tools?
In Oracle Big Data Appliance is map/reduce used with Oracle NoSQL or with Hadoop?
Thanks 
user962305 wrote:
I would like to know if there are some examples on how to run run map/reduce with Oracle NoSQL.
Is there any source code any where? Can you send me one example?Take a look in the oracle.kv.hadoop.KVInputFormat javadoc. It discusses how to use Oracle NoSQL Database with Hadoop as well as referring to an example which is included in the distribution.
Where can we download all the necessary tools?
In Oracle Big Data Appliance is map/reduce used with Oracle NoSQL or with Hadoop?It would be used with both, whether or not you were on the BDA. You use the KVInputFormat to read data from Oracle NoSQL Database into Hadoop during map/reduce processing.
I hope this is useful.
Charles Lamb 
Hi Charles,
Can you please, explain where and what to download and install for this case?
Should we also install hadoop on the same replication nodes as Oracle NoSQL?
Is it possible to have an example with pre-loaded keys on Oracle NoSQL to perform the test?
Is there a version of Oracle NoSQL which comes with some key/value pairs?
I understand the following. Data in Oracle NoSQL will be loaded in hadoop first and then map/reduce is performed in haddop. Is it right?
I would like to know: Does that mean Oracle NoSQL can not run parallel operations? What is the aim in loading data to hadoop first if Oracle is able do perform parallel operations? Loading data from Oracle NoSQL to hadoop may take enormous time I suppose.
Thanks 
user962305 wrote:
Can you please, explain where and what to download and install for this case?Download [Oracle NoSQL Database from OTN|http://www.oracle.com/technetwork/database/nosqldb/downloads/index.html] .
Should we also install hadoop on the same replication nodes as Oracle NoSQL?It depends on your access patterns. In general, probably not, but there may be cases where you achieve better performance with Hadoop and the Rep Nodes co-located.
Is it possible to have an example with pre-loaded keys on Oracle NoSQL to perform the test?
Is there a version of Oracle NoSQL which comes with some key/value pairs?Look at the quickstart guide that comes with the above Oracle NoSQL Database package. There is a small HelloWorld example which you can use as the basis for creating a data set.
I understand the following. Data in Oracle NoSQL will be loaded in hadoop first and then map/reduce is performed in haddop. Is it right?Hadoop is a framework, which among other things happens to run Map/Reduce jobs. Your Map/Reduce job would use the KVInputFormat to read data from Oracle NoSQL Database and process it however it sees fit. It might write the output of the M/R to (say) HDFS. Or it might write it to (say) Oracle RDBMS. Or it might write it back to (say) Oracle NoSQL Database.
>
I would like to know: Does that mean Oracle NoSQL can not run parallel operations? What is the aim in loading data to hadoop first if Oracle is able do perform parallel operations? Loading data from Oracle NoSQL to hadoop may take enormous time I suppose.I am not sure I understand your question. Hadoop, by its nature will break a job into many subtasks. Those subtasks run in parallel, generally across many Hadoop nodes. Those subtasks may access Oracle NoSQL Database data. Hence, Oracle NoSQL Database is able to perform operations in parallel either on the same or different Rep Nodes.
Charles Lamb 
Thanks Charles.
For hadoop, where and which version should we used for Oracle NoSQL ? 
I think 0.2.20 is the current, no?
Charles Lamb

GoldenGate and JavaDB (Derby db)

Hello,
I would like to know if GoldenGate supports replication from Oracle dbs to Javadbs (old named was Derby). In particular is the version of Javadb 10 10.6.2.1 provided with Glassfish 3.1.1 supported and with which version of Golden gate?
Extra question: is it possible to set the replication one way instead of both way? I would need data to get replicated only one way from central Oracle database to a multiitude of javaDB databases.
Any documentation on this?
Other alternative than Godengate?
Thanks 
user553981 wrote:
Hello, I would like to know if GoldenGate supports replication from Oracle dbs to Javadbs (old named was Derby). Java DB is not supported as a source nor a target for GoldenGate. It's possible that ODI (Oracle Data Integrator) might be able to do what you're looking for.
Extra question: is it possible to set the replication one way instead of both way? I would need data
to get replicated only one way from central Oracle database to a multiitude of javaDB databases.GoldenGate by default is one-way replication; two-way replication is just a matter of setting up the same configuration in the other direction. You can set up data-capture from Oracle DB, and possibly (not trivially) use the Java API to take these change-events and apply them via your own JDBC implementation to Java DB. (Again, that's a bit of a project. This is not out-of-the-box functionality.)
Any documentation on this?The OGG Java API (aka the Java user-exit) is =>
* http://docs.oracle.com/cd/E18101_01/index.htm
* http://www.oracle.com/technetwork/middleware/goldengate/documentation/index.html
More likely you'll want to look at ODI =>
* http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html
* Data Integrator
I believe you can also use GG via ODI to capture changes from Oracle, and then use ODI to deliver the change events via JDBC to Java DB... but I'm not positive about that. (You might want to check in the ODI forum.)
Cheers,
-Mike

Create Oracle NoSQL data source using Oracle Weblogic 11g

Hi, I am working on a PoC whereby I want to plug Oracle NoSQL database with Oracle Weblogic11g as a new data source accompanying Oracle Database 11g.So my question is that does Oracle Weblogic 11g support Oracle NoSQL database as a data source OR can I plug Oracle NoSQL database as a data source with Oracle Weblogic11g? Thanks...
Hi, By "data source" I assume you mean a JDBC data source. Is that right? If so, please be aware that NoSQL DB does not currently support SQL or JDBC, although these features may be added in the future. Currently, to access data in the NoSQL database from your application you should use the Java API in the client driver that is included in the package. Please see the Getting Started Guide for more information. Does that answer your question? --mark
Thanks Mark.I was looking for JDBC data source information.I will look through the documentation for steps on how to access NoSQL DB through Java APIs.

Categories

Resources