4 Replies Latest reply on Jan 14, 2013 5:02 AM by 981516

    install RODM

      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-Oracle
          <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
            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-Oracle
              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.

              1 person found this helpful
              • 4. Re: install RODM
                I execute library(ORE) in R after them and my problem was solved.