R language access database management system
This article mainly explains "R language access database management system", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "R language access database management system" it!
There are a variety of interfaces for relational database management systems (DBMS) in R, including Microsoft SQL Sever, Microsoft Access, MySQL, Oracle, PostgreSQL, DB2, Sybase, Teradata and SQLite. Some of these packages provide access through the original database driver, while others provide access through ODBC or JDBC. Using R to access data in external data is an effective means of analyzing large data sets (see Appendix G) and can take advantage of SQL and R respectively.
It is a popular way to access some databases through RODBC package in R language. Allow R to connect to any database that has an ODBC driver.
The first step is to install the RODBC package
> install.packages ("RODBC")
Try to open URL' https://cran.rstudio.com/bin/macosx/el-capitan/contrib/3.4/RODBC_1.3-15.tgz'
Content type 'application/x-gzip' length 813136 bytes (KB)
=
Downloaded 794 KB
The downloaded binary packages are in
/ var/folders/50/tybzdqks35lfztwq28v39_r40000gn/T//RtmptjWK4W/downloaded_packages
The functions in the RODBC package:
Library (RODBC)
Myconn