R/S-Database Interface

The R/S Database interface, RS-DBI, is set of S4 classes and methods for interfacing R, S, and S-Plus to relational database systems (RDBMS). For details see A Common Interface to Relational Databases from R and S

Like Java's JDBC, Perl's DBI, Python's DB-API, and Microsoft's ODBC, RS-DBI defines a common interface for data access to most RDBMS and allows portability both across RDBMS'es and S implementations. Our first draft emphasizes querying databases, and not so much a full low-level interface for database development (like JDBC or ODBC). Also, unlike the JDBC and Perl API's, we want to approach the interface from the "whole-object" perspective so natural to R and S (e.g., by fetching all fields and records simultaneously) yet allowing finer control for users that need it. Currently we envision providing drivers for Oracle, Informix, MySQL, and Postgres. It's quite possible that we may want to create an interface to UNIX (gzipped) flat file databases.

Please send us your suggestions and comments on the RS-DBI to either the The R Databases Special Interest Group or The Omega Project for Statistical Computing

Three Implementations

We have R and S-Plus implementations of the R/S interface to the open-source RDBMS MySQL and an S-Plus implementation to Oracle. You may download the code from http://www.omegahat.org/download/contrib/RS-DBI .

Other Database Connections from R

The following R packages provide connectivity to databases. Each package defines its own set of classes and methods to implement the interface between R and the corresponding database(s).
David A James (for the Omega Project)
Bell Labs, Lucent Technologies
600 Mountain Ave
Room 2C-253
Murray Hill, NJ 07974-0636
(908) 582-3082 (voice)
(908) 582-3340 (fax)