MonetDB Analytical Database with R virtual image is designed to give you a platform to speedup data discovery. It combines MonetDB with the R statistical software, in a single pre-configured package. The virtual images ship with our R integration module, which allows R code to be run embedded in SQL statements. For the R users, the VM has our MonetDB.R connector set-up, for a transparent connection from the R software suite to the database.

The package contains the following:

  • MonetDB (Oct2014-SP1)
    • ​SQL​ module
    • R integration module for inline statical analysis 
    • GEOM module for GeoSpatial support
  • R (3.1.2)
    • MonetDB.R - the connector for R​ to MonetDB
    • dplyr - a data manipulation package for R​

Instructions

You can easily start the VM on your desktop and use it as a sandbox.

  1. Download the package from here.
  2. Unzip it and import it in VirtualBox. If you don't have VirtualBox installed, you can get it from here
    • Double click on the extracted .ovf file
    • Or from VirtualBox, by selecting File->Import Appliance and browsing to the extracted .ovf file
  3. Follow the on-screen instructions to import the image. In most cases you don't have to change anything.
  4. Start the appliance and log in. Default username/password: root/monetdb
    • Using the on-screen console
    • Or from your host computer with SSH/PuTTY on port 2222 at localhost. The appliance is configured in NAT mode and it will forward port 22 on the guest machine to port 2222 on your localhost (e.g. ssh -p 2222 root@localhost).

Usage

You can run user-setup.sh (located in the root user directory) to set-up the 'monetdb' and 'rstart' users for password only access to the machine. After the quick setup you can log in (using the su command)as either:

  • 'su monetdb' to access directly the mclient shell
  • 'su rstats' to access directly R shell 

Alternatively you can create a tunnel over SSH to access the database using the MonetDB MAPI protocol.

The appliance is configured to give you best performance, albeit running in a virtual machine. You can also modify the configuration once imported to increase the number of CPU cores assigned to the appliance, the amount of RAM allocated or modify the network interface.

Next steps

Head over to the MonetDB tutorial page to get more familiar with the database and try it out in your VM. Running the 'load-vod-data.sh' script will download and load the VOC (Dutch East India Company) data for you.

Cloud

Work is already underway on Amazon Web Service AMIs with the MonetDB Analytics Database with R. The AWS images will be available soon on the AWS Marketplace, ready for single-click deployment on the cloud.

Need help?

If you need help with deploying MonetDB in the cloud or building a custom image, please contact us.

File: