This content has been marked as final. Show 5 replies
Ruslan,1 person found this helpful
So as I understood, the calculations (step 4) will be done on the server. And client’s R should receive the fully calculated data frames from ORE. Is that correct?</font>Correct. ORE has something called embedded R execution. In this mode R is running on the DB server and thus will have have access to a bigger system then the client machine. This functionality is available as SQL table function or we also have R client wrappers. Besides data frames you can also get graphics as base64 encoded png.
Is it possible to use current R packages or do I need to rewrite R scripts which currently works on client’s R (in case of using ORE)?</font>You can use any package with this approach. You will need to have then installed in R that is running on the DB server. If you are planning to pass package specific objects between client and server you will need to have the package available on both sides.
How to work with graphics? Currently R creates graphics on local machine. Will it be possible with ORE?</font>Yes, you can get graphics as well. The details will depend on the interface used (SQL or R)
What are the options of buying ORE: only as part of Oracle Advanced Analytics or it’s possible to buy just Oracle R Enterprise?</font>Currently ORE is only available as part of OAA option for 11.2. However, it is being distributed via [url http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/ore-downloads-1502823.html]OTN
Another feature of ORE that you might find useful is transparency layer. It allows you to do data manipulation in R against tables in the database just like you would do with data frames. ORE will then convert your expressions to SQL and execute then on the database. Everything is done transparently.
Denis, thanks for your answers!
But I have more questions.
1. About server operationg system.
My Company prefer Windows servers, but as I see at the downloading page, the latest version of ORE is only for Linux server. Is Windows fully supported server operating system? Can I have any problems in future using Windows server OS?
2. About hardware requirement.
Is there any special hardware requirements for install and use ORE?
3. About license.
I have server with 2x Xeon processors (8 cores). So I need to buy 2x23,000$ license?
Do I need licenses for clients machines?
Ruslan,1 person found this helpful
My Company prefer Windows servers, but as I see at the downloading page, the latest version of ORE is only for Linux server. Is Windows fully supported server operating system? Can I have any problems in future using Windows server OS?Windows is fully supported but there could be a small lag before we publish all the ports for a new release. Linux usually comes out first followed by Windows. We have just recently released ORE 1.3 on Linux and other ports will be coming out soon.
Is there any special hardware requirements for install and use ORE?Not really. You should go by the database needs as ORE is a database option. From ORE perspective the hardware will determine the size of the problems you can solve in R. There are lots of moving parts so it is hard to say in advance. The best approach is to have a POC to try things out first.
I have server with 2x Xeon processors (8 cores). So I need to buy 2x23,000$ license? Do I need licenses for clients machines?Licensing is not that easy. It is best if you get in touch with the sales folks. If you need help drop me an email. I am denis.x.mukhin at oracle.com.
Denis, thanks a lot!