6.1.2 APIs for Embedded R Execution
Oracle Machine Learning for R provides R and SQL application programming interfaces for embedded R execution.
The following table lists the R functions and the equivalent SQL functions and procedures for embedded R execution and OML4R script repository management. The function f refers to a named R function or an R function defined in a script in the OML4R script repository.
Table 6-1 R and SQL APIs for Embedded R Execution
R API | SQL API | Description |
---|---|---|
|
|
Executes f with no automatic transfer of data. |
|
|
Executes f by passing all rows of the provided input |
|
This function must be explicitly defined by the user. |
Executes f by partitioning data according to the values of a grouping column. Provides each data partition as a |
|
|
Executes f by passing a specified number of rows (a chunk) of the provided input |
|
No equivalent. |
Executes f with no automatic transfer of data but provides the index of the invocation, 1 through n, where n is the number of times to invoke the function. Supports parallel execution of each f invocation in the pool of R engines running on the database server. |
ore.grant |
rqGrant |
Grants read privilege access to a datastore or script. |
ore.revoke |
rqRevoke |
Revokes read privilege access to a datastore or script. |
|
|
Adds the provided R function into the OML4R script repository with the provided name. |
|
|
Removes the named R function from the OML4R script repository. |
ore.scriptList |
ALL_RQ_SCRIPTS
|
Lists information about scripts. |
ore.scriptLoad |
No equivalent. | Loads the R function of a script into the R environment. |
Parent topic: About Oracle Machine Learning for R Embedded R Execution