Chapter 5. R with Relational Database Management Systems (RDBMSs)
We have already done quite a lot of Big Data analytics using the R language in the preceding chapters, but this book would not be complete if we didn't touch on the subject of databases. To be precise, in this chapter we will explore connectivity between R and very popular Relational Database Management Systems (RDBMSs), more commonly known as SQL databases. After reading the contents of this chapter, you will know how:
- To set up a number of local and/or remote SQL databases, for example SQLite, PostgreSQL, and MariaDB/MySQL
- To query and manage SQL databases directly from R (both locally and remotely) using a selection of R packages
- To launch fully-managed, highly-scalable Amazon RDS ...
Get Big Data Analytics with R now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
