Integrating formal databases (MariaDB and OracleDB) with R

Setting up Databases (MariaDB and OracleDB)

Prior to integrating the databases with R, MariaDB and Oracle 10g were successfully installed.

MariaDB and R

In order to integrate MariaDB with R, the following packages were installed and loaded to R:

"rJava", "DBI" and "RJDBC". Using JDBC() function that is provided by RJDBC package, relevant DBMS driver was designated. Moreover, four variables, (driver, url, id, password) were applied in dbConnect() function and thus got connected to database.

*There are mainly two methods, ODBC and JDBC, to connect R with databases. Out of the two methods, JDBC was chosen.

The following screenshot of RStudio highlights the connecting process.

Data Base (SQL & NoSQL)