From bates@stat.wisc.edu  Sat Nov 18 21:01:02 2000
From: bates@stat.wisc.edu (Douglas Bates)
Date: 18 Nov 2000 15:01:02 -0600
Subject: [Rd] PostgreSQL book
Message-ID: <6rem09q9kh.fsf@franz.stat.wisc.edu>

Bruce Momjian has just published a book on PostgreSQL that should be
available from bookstores in the next month or so.  It can be
downloaded as a PDF file now from
              http://www.postgresql.org/docs/awbook.html

I found the book to be well written and informative.  I recommend it.

Especially if you have to deal with large data sets, the combination
of relational databases and R is very useful.  Currently I am working
on a project where we have information on 3.5 million subjects
amounting to a total of 10.5 million records.  Processing these in
MySQL and PostgreSQL is much, much more efficient than what my
colleagues were doing with SAS and SPSS.  We took a sample of 180,000
subjects (550,000 records) and fit multilevel (linear mixed-effects)
models using lme in R after accessing the data from the relational
database.

-- 
Douglas Bates                            bates@stat.wisc.edu
Statistics Department                    608/262-2598
University of Wisconsin - Madison        http://www.stat.wisc.edu/~bates/
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-devel-request@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._


[Rd] PostgreSQL book
Douglas Bates