PivotalR: A Fast, Easy-to-use Tool for Manipulating Tables in Databases and A Wrapper of MADlib

R interface of Pivotal Data Fabrics running on PostgreSQL or Pivotal (Greenplum and HAWQ) database with parallel and distributed computation ability for big data analytics. PivotalR is a package that enables users of R to interact with the Pivotal (Greenplum) Database as well as Pivotal HD/HAWQ for Big Data analytics. It does so by providing an interface to the operations on tables/views in the database. These operations are almost the same as those of data.frame. Thus the users of R do not need to learn SQL when they operate on the objects in the database. It also provides a wrapper for MADlib, which is an open-source library for parallel and scalable in-database analytics.

Depends: R (≥ 2.14.0), methods, Matrix
Enhances: DBI, RPostgreSQL, shiny, testthat, tools, rpart
Published: 2015-01-03
Author: Predictive Analytics Team at Pivotal Inc., with contributions from Data Scientist Team at Pivotal Inc.
Maintainer: Caleb Welton <cwelton at pivotal.io>
Contact: Predictive Analytics Team at Pivotal Inc. <user@madlib.net>
BugReports: NA
License: GPL-2 | GPL-3 [expanded from: GPL (≥ 2)]
NeedsCompilation: yes
Materials: README NEWS
CRAN checks: PivotalR results


Reference manual: PivotalR.pdf
Vignettes: An Introduction to PivotalR
Package source: PivotalR_0.1.17.45.tar.gz
Windows binaries: r-devel: PivotalR_0.1.17.45.zip, r-release: PivotalR_0.1.17.45.zip, r-oldrel: PivotalR_0.1.17.45.zip
OS X Mavericks binaries: r-release: PivotalR_0.1.17.45.tgz, r-oldrel: PivotalR_0.1.17.45.tgz
Old sources: PivotalR archive