Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

R language access database management system

Shulou Source: shulou.com Published: 2022-06-02 06:33:07 11月17日 Update

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

Tags: Data database management system system language management content learning driving practical deeper effective advantage interest function function name multiple character string Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker MySQL NVidia macOS Xiaomi