Parallel Execution of R Scripts in Oracle DB

With Oracle R Enterprise it is possible to run R scripts inside an Oracle database. The idea is to use the performance of a database server to make running R code fast. We can also use it on an Oracle exadata database machine. We have than two ways on query data in parallel: On the one hand we can query data in parallel in the database (SQL parallel query) on the other hand  we can run more than one external R processes.  The blog below shows to run R processes parallel as external processes on DB server.  It depends on the R code, if it is possible to run more than one R process. E.g for scoring it should be possible. Continue reading