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 database instances (of different types) and query their records using the R language
During the process of achieving the preceding goals, you will also be exposed to a variety of methods and techniques that will help you...