Communications for Statistical Applications and Methods

The Korean Statistical Society (한국통계학회)
권호 표지
DOI QR코드

DOI QR Code

Access to Databases through the R-Language

R 언어를 통한 데이터베이스 접근

  • 심송용 (한림대학교 정보통계학과) ;
  • 강희모 (한림대학교 정보통계학과) ;
  • 이윤환 (한림대학교 정보통계학과)
  • Published : 2008.01.31
Download PDF
⟨ Previous Next ⟩

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.

일반적으로 R 언어는 작은 크기의 자료분석에 적당하다. 이 연구에서 데이터베이스에 저장된 대용량의 자료를 R 언어를 통해서 접근하는 방법에 대해서 알아보았다. 실제 자료를 사용하여 MySQL, Oracle 또는 PostgreSQL 데이터베이스 서버에 저장된 자료에 접근하는 예를 제공하였다.

Keywords

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

Cited by

  1. A Study on the Development and Maintenance of Embedded SQL based Information Systems vol.19, pp.4, 2010, https://doi.org/10.5859/KAIS.2010.19.4.025