Browse > Article
http://dx.doi.org/10.5351/CKSS.2008.15.1.051

Access to Databases through the R-Language  

Sim, Song-Yong (Department of Statistics, Hallym University)
Kang, Hee-Mo (Hallym University)
Lee, Yoon-Hwan (Hallym University)
Publication Information
Communications for Statistical Applications and Methods / v.15, no.1, 2008 , pp. 51-64 More about this Journal
Abstract
In general, R is useful for small size data. We study how to access a large data set in a database by R-language. We provide real examples to access data sets stored in database servers MySQL, Oracle or PostgreSQL.
Keywords
DBMS; MySQL; ODBC; SQL; Oracle; PostgreSQL;
Citations & Related Records
연도 인용수 순위
  • Reference
1 http://www.mysql.com/why-mysql/
2 http://www.postgresql.org/ftp/odbc/versions/msi/
3 http://www.postgresql.org/ftp/win32/
4 http://www.oracle.com
5 http://www.oracle.com/technology/software/tech/windows/odbc/index.html
6 http://www.oracle.com/technology/software/products/database/xe/htd ocs/102xewinsoft.html
7 R Development Core Team (2007b). R: A Language and Environment for Sta-tistical Computing. ISBN 3-900051-07-0, Vienna, Austria, http://cran.r-proect.org/doc/packages/DBI.pdf
8 Dalgaard, P. (2002). Introductory Statistics with R, Springer, New York
9 R Development Core Team (2007c). R: A Language and Environment for Statistical Computing. ISBN 3-900051-07-0, Vienna, Austria, http://cran.r-project.org/doc/packages/RODBC.pdf
10 R Development Core Team (2007d). R: A Language and Environment for Statistical Computing. ISBN 3-900051-07-0, Vienna, Austria, http://cran.r-project.org/src /contrib/Descriptions/RODBC.html
11 http://dev.mysql.com/
12 http://kodiak.cs.cornell.edu/kddcup/
13 Everitt, B. S. and Hothorn, T. (2006). A Handbook of Statistical Analysis Using R, Chapman & Hall/CRC, New York
14 PostgreSQL Global Development Group (2007), http://www.postgresql.org/
15 R Development Core Team (2007a). R: A Language and Environment for Statistical Computing. ISBN 3-900051-07-0, Vienna, Austria, http://www.R-pro ject.org
16 심송용 (2005). <통계그래픽스>, 교우사, 서울