<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.0.1">
</HEAD>
<BODY>
Hi
<BR>
<BR>
ODBC is one more software layer between R and the database. In generic terms I think it's better to use the proper client and "talk" directly to the database server.
<BR>
<BR>
Anyway I don't know exactly how ODBC for oracle works and I never made any comparisons between the to packages (I use linux) so I can not give you a fundamented answer.
<BR>
<BR>
Regards
<BR>
<BR>
EJ
<BR>
<BR>
On Thu, 2002-01-17 at 21:03, Fan wrote:
<BLOCKQUOTE>
<PRE><FONT COLOR="#737373"><FONT SIZE="3"><I>AFAK, ROracle works only for R unix. </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>RODBC works very well for R Windows, I'd like to know </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>if there's any interests of ROracle for Windows users </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>(ex. large data sets, faster, etc.) ?</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Thanks for advice</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>--</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Xiao Gang FAN</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Ernesto Jardim a écrit :</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Hi</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> I'm using some large datasets and I found the ROracle package to be of</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> great help.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> If you have the chance to create a database in Oracle or MySQL with one</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> single table for your dataset, you can then use the ROracle package to</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> access the dataset. I found several advantages on that.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> I don't import the data into my environment. I use a small function (see</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> below) to access the dataset and because the result is a data.frame you</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> can use it as usually.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Your environment will not be to large and you'll have the ram memory</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> less full.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> It's easier to select subsets with SQL than S/R language.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Hope it helps</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Regards</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> EJ</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> --//--</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ora.fun <- function(){</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> library(ROracle)</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> m <- dbManager("Oracle")</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> con <- dbConnect(m,user="user",password="password")</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> dat <- quickSQL(con,"select ...")</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> close(con)</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> unload(m)</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> dat</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> }</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> --//--</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> On Tue, 2002-01-15 at 19:43, Prof Brian Ripley wrote:</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > On Tue, 15 Jan 2002, wei, xiaoyan wrote:</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > As a part of our regular data analysis, I have to read in large data sets</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > with six columns and about a million rows. In Splus, this usually take a</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > couple of minutes. I just tried R, it seems take forever to use read.table()</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > to read in the data frame! It did not help much even though I specified</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > colClasses and nrows in read.table().</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > How is R's ability to analyze large data sets? I used R on solaris 2.6 and I</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > used all default compilation flags when building the R package. Will it help</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > > if I use some compilation flags with higher optimization level?</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > It will help to use R-patched, since I guess you are using 1.4.0.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > Also, look in the list archives, as I answered this more fully earlier</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > today.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > In either S-PLUS or R, scan would be a better choice for such a dataset.</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > --</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > Brian D. Ripley, ripley@stats.ox.ac.uk</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > University of Oxford, Tel: +44 1865 272861 (self)</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > 1 South Parks Road, +44 1865 272860 (secr)</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > Oxford OX1 3TG, UK Fax: +44 1865 272595</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> ></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > Send "info", "help", or "[un]subscribe"</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > (in the "body", not the subject !) To: r-help-request@stat.math.ethz.ch</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> </FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> Send "info", "help", or "[un]subscribe"</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> (in the "body", not the subject !) To: r-help-request@stat.math.ethz.ch</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I></FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>Send "info", "help", or "[un]subscribe"</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>(in the "body", not the subject !) To: r-help-request@stat.math.ethz.ch</FONT></FONT></I>
<FONT COLOR="#737373"><FONT SIZE="3"><I>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._</FONT></FONT></I>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>