Relational Databases and R

Novice and advanced R users from all professional groups.

• CHF 600.- für Angehörige der UZH/ETH und assoziierter Institute
• CHF 800.- für Alumni der UZH/ETH, Angehörige anderer Universtitäten, Einrichtungen der öffentlichen Hand und non-profit Organisationen
• CHF 1200.- für Firmen

Much of the world’s information is held in relational database management systems. Their size and complexity make it impractical to transfer their entire contents or even tables for analysis in R. Recent developments in the R package ecosystem and R itself allow for using data stored in SQL databases directly and with surgical precision for complex analysis, model fitting and plotting.

This course will consist of two parts, the first part will introduce the standard database query language SQL to enable users to surgically retrieve and reshape data coming from a database. The second part of the course will introduce the R integration with databases, starting with DBI, the dbplyr package for query construction and the dbplot package to directly plot from databases. We will also discuss data management systems embedded into R directly such as RSQLite or MonetDBLite and User-defined functions in data management systems with R.

Dr. Hannes Mühleisen is senior researcher at the Database Architectures group at CWI, the national research institute for mathematics and computer science in the Netherlands. Hannes is also Assistant Professor at Vrije Universiteit Amsterdam. Hannes’ research revolves around data management for statistical processing, he is the author of several related R packages, for example the MonetDBLite package. Hannes has also published several scientific papers on the topic of integrating databases with R efficiently.

17.-18. Juni 2019

Anmeldung