Re: [R] Implementing R through Oracle

2007-11-08 Thread jah
Thanks for all your advice and I have spent considerable time looking at all the options. I have good new and bad news. Bad news I won't be implmenting R on our server. Good news I can keep all the business logic in the database where it belongs. What I will be doing is taking the data set and

Re: [R] Implementing R through Oracle

2007-11-08 Thread Don MacQueen
If it were me, I think I would try to use Rscript. R will still have to pull data using ROracle, and write back to Oracle, but the operation will be under the control of the pl/sql script. A standard R installation now includes Rscript. Rscript is intended to be used, as I recall, in a manner

Re: [R] Implementing R through Oracle

2007-11-05 Thread jah
I have looked through all the ROracle documentation, R-help, R-dev, Googled the world and still cannot figure out this issue. Everything I read it is about connecting to an Oracle database and pulling data, processing it, and then pushing it back to Oracle. I am running in pl/sql code so I

Re: [R] Implementing R through Oracle

2007-11-05 Thread Duncan Temple Lang
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You might want to take a look at PL/R or REmbeddedPostgres (the former being a reimplementation of the latter). AFAIK, nobody has done this for Oracle, but we did do it as an experiment for MySQL and Postgres and so the ideas are there but there will

Re: [R] Implementing R through Oracle

2007-11-05 Thread Jeffrey Horner
jah wrote on 11/05/2007 02:41 PM: I have looked through all the ROracle documentation, R-help, R-dev, Googled the world and still cannot figure out this issue. Everything I read it is about connecting to an Oracle database and pulling data, processing it, and then pushing it back to Oracle. I

Re: [R] Implementing R through Oracle

2007-11-05 Thread elw
I have looked through all the ROracle documentation, R-help, R-dev, Googled the world and still cannot figure out this issue. Everything I read it is about connecting to an Oracle database and pulling data, processing it, and then pushing it back to Oracle. I am running in pl/sql code

[R] Implementing R through Oracle

2007-10-30 Thread jah
I have been looking for a statistical package that I can implement in our application and I came across R. We run an n-Tier environment with an Oracle 10g backend. Our design is to keep all business logic in the backend. What I would like to do is call R from pl/sql. I noticed that ROracle is