This discussion is archived
4 Replies Latest reply: Jan 13, 2013 9:02 PM by 981516 RSS

install RODM

981516 Newbie
Currently Being Moderated
1- I need to use oracle data mining via R but I don't know what I need.
is this true?
I must install oracle 11g in server and R2.13 in both server and client.
is RODM is tools or service? I must add or install it or it exists in Oracle.

2- for using R, I only can use Oracle data mining algorithms or I can use R function like social network in Oracle data base?
  • 1. Re: install RODM
    Denis Mukhin Journeyer
    Currently Being Moderated
    <tt>RODM</tt> is an open source package. It is available on CRAN. It uses <tt>RODBC</tt> for connecting to the database. You only need it on you client machine (both R and <tt>RODM</tt>). The server only needs to have ODM (what is now called Oracle Advanced Analytics) option enabled (which is true by default I think).

    Another option is to use Oracle R Enterprise (ORE) which is also part of OAA option. Version 1.3 has an <tt>OREdm</tt> package with a more transparent interface. For OAA customers <tt>OREdm</tt> is a supported package while <tt>RODM</tt> is not. ORE is available for download on OTN.
  • 2. Re: install RODM
    981516 Newbie
    Currently Being Moderated
    tanks for your attention and answer but I need to know sequence of installs
    on client on windows
    1-install R2.13.2
    2-add packages(DBI, ROracle, png)

    on server
    1-install oracle 11g
    2-install R
    3-add R's packages

    IS THIS TRUE?
    tanks again for your attention
  • 3. Re: install RODM
    Denis Mukhin Journeyer
    Currently Being Moderated
    I assume you are asking about installing ORE now. The steps you listed are mostly correct. You missed installation of ORE packages for both client and server that should be done right after installing R. Also, please, note that for ORE 1.1 we recommend R 2.13.2 while for ORE 1.3 we recommend R 2.15.1. For more details about installation, please, consult ORE documentation that is available from the ORE download page (the link is available in the previous post).

    If you were asking about installing RODM then on the client you need to install R first and then RODM package. On the server you need to install the database with ODM option enabled.

    Hope this helps. Let me know if you need more help.

    Denis
  • 4. Re: install RODM
    981516 Newbie
    Currently Being Moderated
    I execute library(ORE) in R after them and my problem was solved.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points