RIOTDB: transparently bringing scalability and I/O-efficiency to statistical computing with R http://www.cs.duke.edu/dbgroup/Main/RIOT NOTE: This is only a prototype implementation for demonstrating research ideas. -------------------------- To install RIOTDB on a Unix-like system, follow these instructions: 1) Extract the downloaded package and cd to the top level directory of the package (where this file resides). Paths in the following are relative to this directory. 2) Setting up a databse. Currently RIOTDB uses MySQL as its backend. Please make sure you have access to a MySQL server. You can modify the server address, username, and password in the RIOTDB/src/clib/config.h file to match your settings. The default username RIOTDB assumes is 'mysql' and the default password is empty. 3) Make sure your mysql user has the following privileges: CREATE, CREATE VIEW, DELETE, DROP, FILE, INDEX, SELECT, SUPER, TRIGGER, UPDATE. A simpler way to do this is: $ mysql -u root # log in as root # replace 'mysql' and 'localhost' with the real server host and user name $ grant all privileges on *.* to 'mysql'@'localhost' $ grant super on *.* to 'mysql'@'localhost' 4) Next use the script RIOTDB/src/scripts/init_riotdb.sql to initialize and populate the database: $ mysql -u mysql $ \. <path_to_the_script> If any error should occur, go back to Step 3 and make sure the user has enough privileges. 5) Check the RIOTDB/src/Makefile file to make sure the directories for MySQL include and library files match with your settings. 6) Compile the package with $ R CMD INSTALL ROITDB The RIOTDB package will be installed. If you want to have it installed in a customized directory, make a file $HOME$/.Renviron with the following contents before installing the package: R_LIBS=<path> 7) (Optional) Patch R. If you want to use an optimized version of RIOTDB (see the discussion at http://www.cs.duke.edu/dbgroup/Main/RIOT-interface), use the file R-RIOTDB.patch to patch the official R source and rebuild R. Any reasonably modern R release should work. $ cd <top level of R's source tree> $ patch -p1 < <path to the R-RIOTDB.patch file> $ ./configure # build R as usual $ make && make install 8) Use RIOTDB. Start R and use the following statement to load RIOTDB: > library(RIOTDB)