JOURNAL BROWSE
Search
Advanced SearchSearch Tips
Access to Databases through the R-Language
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
Access to Databases through the R-Language
Sim, Song-Yong; Kang, Hee-Mo; Lee, Yoon-Hwan;
  PDF(new window)
 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;
 Language
Korean
 Cited by
1.
임베디드 SQL 기반 정보시스템의 개발 및 관리 방법에 대한 연구,송용욱;

한국정보시스템학회지:정보시스템연구, 2010. vol.19. 4, pp.25-49 crossref(new window)
1.
A Study on the Development and Maintenance of Embedded SQL based Information Systems, The Journal of Information Systems, 2010, 19, 4, 25  crossref(new windwow)
 References
1.
심송용 (2005). <통계그래픽스>, 교우사, 서울

2.
Dalgaard, P. (2002). Introductory Statistics with R, Springer, New York

3.
Everitt, B. S. and Hothorn, T. (2006). A Handbook of Statistical Analysis Using R, Chapman & Hall/CRC, New York

4.
PostgreSQL Global Development Group (2007), http://www.postgresql.org/

5.
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

6.
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

7.
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

8.
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

9.
http://dev.mysql.com/

10.
http://kodiak.cs.cornell.edu/kddcup/

11.
http://www.mysql.com/why-mysql/

12.
http://www.postgresql.org/ftp/odbc/versions/msi/

13.
http://www.postgresql.org/ftp/win32/

14.
http://www.oracle.com

15.
http://www.oracle.com/technology/software/tech/windows/odbc/index.html

16.
http://www.oracle.com/technology/software/products/database/xe/htd ocs/102xewinsoft.html