On Mon, 2006-11-06 at 15:57 -0300, Eduardo Henrique Altieri wrote: > Since the databases that I handle with are very large, I need answers > to some questions: > > 1) Can I work with R data frames like databases in SAS, that is, > storing data frames in files instead of in memory? > > 2) Can I use SQL codes to work with R data frames? Note that I ask for > the direct use, with no need to use a “channel” or to export data > frames to a DBMS.
Interesting questions... I see that nobody has replied and I was interested to read other thoughts about it. I'm curious to know under what scenario you require these features. To answer your question, personally I don't think it's possible to do that with R. If I had a very large database, I'd probably focus on interfacing R with other database system (e.g. MySQL) to which I'd connect through a channel. Regards, -- Jerome Asselin, M.Sc., Agent de recherche, RHCE CHUM -- Centre de recherche 3875 rue St-Urbain, 3e etage // Montreal QC H2W 1V1 Tel.: 514-890-8000 Poste 15914; Fax: 514-412-7106 ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
