RE: [R] storage of lm objects in a database

About this list Date view Thread view Subject view Author view Attachment view

From: Arne.Muller@aventis.com
Date: Fri 14 May 2004 - 02:13:59 EST


Message-id: <C80ECAFA2ACC1B45BE45D133ED660ADECDD189@crbsmxsusr04.pharma.aventis.com>

Thanks for your reply. I think I'll go for Prof Ripley's suggestion to use "serialize", since I don't need to query attributes of the objects via SQL. So a crude BLOB will do ...

        thanks,

        Arne

--
Arne Muller, Ph.D.
Toxicogenomics, Aventis Pharma
arne dot muller domain=aventis com

> -----Original Message----- > From: Sean Davis [mailto:sdavis2@mail.nih.gov] > Sent: 13 May 2004 17:22 > To: Muller, Arne PH/FR; r-help > Subject: Re: [R] storage of lm objects in a database > > > Arne, > > There are several database access packages for R. I use > RMySQL, but there > are several others (ODBC, etc.). However, as far as I know > (and I may be > wrong), there is not a persistence API for R objects (in a > relational DB > sense), but you could certainly deconstruct the objects and > store their > parts for later reconstruction of the objects. I guess > another option would > be a scheme of saved results (files) indexed in some way so > that you could > get the results, but I can't think of a way to make this fast. > > Sean > > On 5/13/04 11:11 AM, "Arne.Muller@aventis.com" > <Arne.Muller@aventis.com> > wrote: > > > Hello, > > > > I'd like to use DBI to store lm objects in a database. I've > to analyze many of > > linear models and I cannot store them in a single R-session > (not enough > > memory). Also it'd be nice to have them persistent. > > > > Maybe it's possible to create a compact binary > representation of the object > > (the kind of format created created by "save"), so that one > doesn't need to > > write a conversion routine for these objects (or maybe > there's already a > > conversion available for lm?). I assume that the data do > not need to be > > analyzed with a any other software than R. > > > > I'm happy for any suggestions and links to get some more > info on this. > > > > kid regards, > > > > Arne > > > > -- > > Arne Muller, Ph.D. > > Toxicogenomics, Aventis Pharma > > arne dot muller domain=aventis com > > > > ______________________________________________ > > R-help@stat.math.ethz.ch mailing list > > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html >

______________________________________________ R-help@stat.math.ethz.ch mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Mon 31 May 2004 - 23:05:09 EST