I have java/JSF web app. I have to make possible creation of custom R script in app, and it's execution on remote Oracle DB with Oracle R Enterprise. I don't even understand the concept. Can a R script be sent to remote DB for execution? If anyone dealt with Oracle R Enterprise could he/she give me some pointers or basic understanding and some links would be appreciated?
5
-
1this might be worth a read stat.berkeley.edu/~nolan/stat133/Fall05/lectures/SQL-R.pdfRachel Gallen– Rachel Gallen2013-05-03 13:27:31 +00:00Commented May 3, 2013 at 13:27
-
1or this science.nature.nps.gov/im/datamgmt/statistics/r/fundamentals/…Rachel Gallen– Rachel Gallen2013-05-03 13:29:57 +00:00Commented May 3, 2013 at 13:29
-
1stackoverflow.com/questions/11037195/how-to-connect-r-to-oracleRachel Gallen– Rachel Gallen2013-05-03 13:32:53 +00:00Commented May 3, 2013 at 13:32
-
1wikihow.com/Use-R-Language-to-Connect-with-an-ORACLE-DatabaseRachel Gallen– Rachel Gallen2013-05-03 13:34:15 +00:00Commented May 3, 2013 at 13:34
-
2@RachelGallen - the OP is talking about running a script on Oracle's embedded R technology: oracle.com/technetwork/database/options/advanced-analytics/…APC– APC2013-05-03 13:36:02 +00:00Commented May 3, 2013 at 13:36
Add a comment
|
1 Answer
Here are short instructions:
On server(if DB is on another computer):
Install R language,
Install Oracle R Enterprise
On client(if not working on computer with DB installed on it):
Install r language
Install oracle instantClient and set PATH(Win) to folder
Install support-client libraries
Install client libraries,
see: http://docs.oracle.com/cd/E36939_01/doc/doc.13/e36763/client.htm
for specifics.
Then connect to DB(with ORE installed) through your app/R/R-Studio/SQLDeveloper and use R-interface or SQL-interface(depending on your medium for connecting to DB)
I recommend going through these 8 flash lectures from oracle:
www.oracle.com/webfolder/technetwork/tutorials/tutorial/db/ore1.1/ore_part1/player.html
www.oracle.com/webfolder/technetwork/tutorials/tutorial/db/ore1.1/ore_part2/player.html
www.oracle.com/webfolder/technetwork/tutorials/tutorial/db/ore1.1/ore_part3/player.html
...
www.oracle.com/webfolder/technetwork/tutorials/tutorial/db/ore1.1/ore_part8/player.html