Verifying the Oracle Machine Learning for R Installation

To verify that the basic functionality of OML4R is working, establish a connection to an OML4R server and execute several basic functions.

Note:

To start and use OML4R, your database user must have the privileges required for OML4R installation. See User Requirements for details.

Example A-2 Connecting to an OML4R Server

To connect the an OML4R client to an OML4R server:

  1. Select R x64 3.3.0 from the Windows Start menu.

    The R Console is displayed.

  2. Type this command to start OML4R:

    $ ORE
    R> library(ORE)
    
  3. Type this command to connect to the OML4R server. The following example connects user OML_USER to the database orcl on the server host serv1 using port 1521:

    >  ore.connect(user="OML_USER", sid="orcl", host="serv1", password="OML_USERpsw",
                   port=1521, all=TRUE)
    Loading required package: ROracle
    Loading required package: DBI
    
  4. Execute ore.is.connected to validate the connection. If the connection is successful, the function returns TRUE:

    > ore.is.connected()
    [1] TRUE

Example A-3 Listing the Database Tables Accessible in a Schema

The ore.ls function lists the ore.frame proxy objects that correspond to database tables in the environment for a schema. In the following example, TABLE1 and TABLE2 exist in the current schema:

> ore.ls()
[1] "TABLE1" "TABLE2"

Example A-4 Pushing an R Data Frame to the Database

The ore.push function pushes a local R object into an OML4R object of the appropriate data type in the database. The following example creates an R data.frame and pushes it an ore.frame object in the database.

df <- data.frame(a="abc",
                 b=1.456,
                 c=TRUE,
                 d=as.integer(1))
of <- ore.push(df)

Example A-5 Executing an Embedded R Function

The ore.doEval function executes the specified function in an R engine on the database server and returns the results. This example declares a function in the ore.doEval invocation.

> ore.doEval(function() { 123 })
[1] 123