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

Provides an R interface for the Pivotal Data stack running on 'PostgreSQL', 'Greenplum' or 'Apache HAWQ (incubating)' databases with parallel and distributed computation ability for big data processing. 'PivotalR' provides an R interface to various database operations on tables or views. These operations are almost the same as the corresponding native R operations. Thus users of R do not need to learn 'SQL' when they operate on objects in the database. It also provides a wrapper for 'Apache MADlib (incubating)', which is an open- source library for parallel and scalable in-database analytics.

AuthorPredictive Analytics Team at Pivotal Inc. <user@madlb.incubator.apache.org>, with contributions from Data Science Team at Pivotal Inc.
Date of publication2016-10-22 12:17:19
MaintainerRahul Iyer <riyer@pivotal.io>
LicenseGPL (>= 2)
Version0.1.18.2

View on CRAN

Man pages

abalone: Abalone data set

aggregate-methods: Functions to perform a calculation on multiple values and...

aic: AIC methods for Madlib regression objects

arith-methods: Arithmetic Operators for 'db.obj' objects

arraydb.to.arrayr: Convert strings extracted from database into arrays

array.len: Get the length of the array in an array column

as.db.data.frame-methods: Convert other objects into a 'db.data.frame' object

as.environment: Evaluate expressions within the context of a database table...

as.factor-methods: Convert one column of a 'db.obj' object into a categorical...

by-methods: Apply a Function to a 'db.data.frame' Split by column(s)

cbind2: Combine two 'db.obj' Objects by Columns

clean.madlib.temp: Delete all the result tables created during calculations of...

coef: Extract model coefficients for Madlib regression objects

compare-methods: Comparison Operators for 'db.obj' objects

connection-info: Utilities for extracting related information about a database...

conn.eql: Check whether two connections are the same

conn.id: Find out the connection ID of a 'db.obj' object

content: Print the content of a 'db.obj' object

crossprod: Compute the matrix product of 'X^T' and 'Y'.

db.connect: Create a connection to a database

db.data.frame: Create a 'db.data.frame' object pointing to a table/view in...

db.data.frame-class: Class '"db.data.frame"'

db.disconnect: Disconnect a connection to a database

db.existsObject: Test whether an object exists in the database

db.list: List all the currently active connections with their...

db.obj-class: Abstract Class '"db.obj"'

db.objects: List all the existing tables/views in a database with their...

db.q: Execute a SQL query

db.Rcrossprod-class: Class '"db.Rcrossprod"'

db.Rquery-class: Class '"db.Rquery"' and its sub-class 'db.Rview-class'

db.search.path: Display or set the search path (i.e. default schemas) for a...

db.table-class: Class '"db.table"'

db.view-class: Class '"db.view"'

delete-methods: Safely delete a 'db.obj' object or a table/view in the...

dim-methods: Dimension of a table

eql-methods: Test if two objects point to the same table

extract-replace-methods: Extract or replace a part of 'db.obj' objects

func-methods: Mathematical functions that take 'db.obj' objects as the...

generic.bagging: This function runs boostrap aggregating for a given training...

generic.cv: Generic cross-validation for supervised learning algorithms

getTree.rf.madlib: MADlib wrapper function for Random Forest

groups: Summary information for Logistic Regression output

ifelse: Conditional Element Selection

is.db.data.frame: Check if an object is of type 'db.data.frame'

is.factor-methods: Detect whether a 'db.obj' object is a categorical object

is.na-methods: Query if the entries in a table are NULL

key: Get or set the primary key for a table

logical-methods: Logical operations for 'db.obj' objects

madlib.arima: Wrapper for MADlib's ARIMA model fitting function

madlib.elnet: MADlib's elastic net regularization for generalized linear...

madlib.glm: Generalized Linear Regression by MADlib in databases

madlib.kmeans: Wrapper for MADlib's Kmeans clustering function

madlib.lda: Wrapper for MADlib's Latent Dirichilet Allocation

madlib.lm: Linear regression with grouping support, heteroskedasticity

madlib.randomForest: MADlib wrapper function for Random Forest

madlib.rpart: MADlib wrapper function for Decision Tree

madlib.summary: Data summary function

madlib.svm: Support Vector Machine with regression and novelty detection

margins: Compute the marginal effects of regression models

merge-methods: Computing a join on two tables

na.action: Functions for filtering 'NA' values in data

names-methods: The Names of an object

null.data: A Data Set with lots of 'NA' values

perplexity.lda.madlib: Perplexity of LDA predictions

pivotalr: Graphical interface for PivotalR based upon shiny

pkg-package: An R font-end to PostgreSQL and Greenplum database, and...

plot.dt.madlib: Plot the result of madlib.rpart

predict: Generate the 'db.Rquery' object that can calculate the...

predict.arima.madlib: Forecast from MADlib's ARIMA fits

predict.bagging.model: Make predictions using the result of 'generic.bagging'

predict.dt.madlib: Compute the predictions of the model produced by madlib.rpart

predict.elnet.madlib: Predict using the regression result of elastic net...

predict.lda.madlib: Prediction function for MADlib's LDA models

predict.rf.madlib: Compute the predictions of the model produced by...

preview: Read the actual data stored in a table of database.

print.arima.madlib: Display results of ARIMA fitting of 'madlib.arima'

print.dt.madlib: Print the result of madlib.rpart

print.elnet.madlib: Display the results from madlib.elnet function in a pretty...

print.lm.madlib: Display results of linear regression

print.logregr.madlib: Display results of logistic regression

print-methods: Display the connection information associated with a 'db'...

print.none.obj: Function used in GUI to print absolutely nothing

print.rf.madlib: Print the result of madlib.randomForest

print.summary.madlib: Display the results from summary function in a pretty format

residuals: Residuals methods for Madlib regression objects

row_actions: Compute the sum or mean of all columns in one row of a table

sample-methods: Methods for sampling rows of data from a table/view randomly

scale-methods: Scaling and centering of tables

sort-methods: Sort a table or view by a set of columns

subset-methods: Extract a subset of a table or view

summary.arima.madlib: Summary information for MADlib's ARIMA model

summary.elnet.madlib: Summary information for Elastic net regularization output

summary.lm.madlib: Summary information for Linear Regression output

summary.logregr.madlib: Summary information for Logistic Regression output

text.dt.madlib: Add labels onto the figure generated by plot.dt.madlib

type-cast: Cast columns of 'db.obj' objects to other types

unique-methods: The Unique of an object

vcov: vcov methods for Madlib regression objects

Files in this package

PivotalR
PivotalR/inst
PivotalR/inst/sql
PivotalR/inst/sql/find_majority_double.sql_in
PivotalR/inst/sql/find_majority_boolean.sql_in
PivotalR/inst/sql/crossprod_double2.sql_in
PivotalR/inst/sql/crossprod_sym_double.sql_in
PivotalR/inst/sql/find_majority_integer.sql_in
PivotalR/inst/sql/crossprod_double.sql_in
PivotalR/inst/sql/find_majority_text.sql_in
PivotalR/inst/dbi
PivotalR/inst/dbi/DBI.tar.gz
PivotalR/inst/gui
PivotalR/inst/gui/ui.R
PivotalR/inst/gui/server.R
PivotalR/inst/doc
PivotalR/inst/doc/pivotalr.Rnw
PivotalR/inst/doc/pivotalr.pdf
PivotalR/tests
PivotalR/tests/README
PivotalR/tests/testthat
PivotalR/tests/testthat/test-madlib_lda.r
PivotalR/tests/testthat/test-examples.r
PivotalR/tests/testthat/test-madlib_randomForest.r
PivotalR/tests/testthat/test-madlib_glm.r
PivotalR/tests/testthat/test-madlib_svm.r
PivotalR/tests/testthat/test-madlib_kmeans.r
PivotalR/tests/testthat/testthat.R
PivotalR/src
PivotalR/src/Makevars
PivotalR/src/elcd.cpp
PivotalR/src/adp
PivotalR/src/adp/rmix_list.cpp
PivotalR/src/adp/Makefile
PivotalR/src/adp/rlist.h
PivotalR/src/adp/README
PivotalR/src/adp/rmatrix.h
PivotalR/src/adp/rvector.h
PivotalR/src/adp/rmix_list.h
PivotalR/NAMESPACE
PivotalR/NEWS
PivotalR/data
PivotalR/data/null.data.RData
PivotalR/data/abalone.RData
PivotalR/R
PivotalR/R/madlib-svm.R PivotalR/R/method-db.data.frame_.R PivotalR/R/method-aggregates_.R PivotalR/R/method-merge_.R PivotalR/R/method-na.action_.R PivotalR/R/method-preview_.R PivotalR/R/generic.cv.R PivotalR/R/method-unique_.R PivotalR/R/onAttach.R PivotalR/R/madlib-kmeans.R PivotalR/R/madlib-glm.R PivotalR/R/method-replacement_.R PivotalR/R/method-delete_.R PivotalR/R/vcov.R PivotalR/R/PivotalR.R PivotalR/R/method-as.db.data.frame_.R PivotalR/R/predict.R PivotalR/R/method-display_.R PivotalR/R/elnet-cd.R PivotalR/R/madlib-elnet.R PivotalR/R/utilities.R PivotalR/R/method-sample_.R PivotalR/R/onUnload.R PivotalR/R/method-by_.R PivotalR/R/utility-madlib.R PivotalR/R/utility-formating.R PivotalR/R/method-cast_.R PivotalR/R/coef.R PivotalR/R/madlib-rpart.R PivotalR/R/method-db.data.frame_props_.R PivotalR/R/aic_lm.R PivotalR/R/madlib-lda.R PivotalR/R/method-cbind_.R PivotalR/R/madlib-lm.R PivotalR/R/db_conn-rpostgresql.R PivotalR/R/madlib-arima.R PivotalR/R/method-crossprod_.R PivotalR/R/as.data.frame.R PivotalR/R/db_conn-generic.R PivotalR/R/utility-array.R PivotalR/R/method-extraction_.R PivotalR/R/ifelse.R PivotalR/R/method-as.factor_.R PivotalR/R/method-as.list_.R PivotalR/R/method-sort_.R PivotalR/R/as.environment.R PivotalR/R/testing.R PivotalR/R/db.q.R PivotalR/R/methods-scale_.R PivotalR/R/margins.R PivotalR/R/defs-pkg.R PivotalR/R/aic_logregr.R PivotalR/R/generic.bagging.R PivotalR/R/utility-generic.R PivotalR/R/method-math_.R PivotalR/R/method-key_.R PivotalR/R/method-ops.R PivotalR/R/madlib-summary.R PivotalR/R/madlib-randomForest.R PivotalR/R/residuals.R PivotalR/R/utility-conn_attr.R
PivotalR/vignettes
PivotalR/vignettes/pivotalr.Rnw
PivotalR/vignettes/sample_plot.png
PivotalR/vignettes/RJournal.sty
PivotalR/vignettes/gui_linregr.png
PivotalR/vignettes/qian.tex
PivotalR/vignettes/gui_table.png
PivotalR/vignettes/qian.bib
PivotalR/vignettes/class-hierarchy.png
PivotalR/vignettes/PivotalR_structure.png
PivotalR/README.md
PivotalR/MD5
PivotalR/build
PivotalR/build/vignette.rds
PivotalR/DESCRIPTION
PivotalR/man
PivotalR/man/as.environment.Rd PivotalR/man/key.Rd PivotalR/man/madlib.rpart.Rd PivotalR/man/db.Rquery-class.Rd PivotalR/man/content.Rd PivotalR/man/ifelse.Rd PivotalR/man/eql-methods.Rd PivotalR/man/db.data.frame.Rd PivotalR/man/generic.cv.Rd PivotalR/man/print.logregr.madlib.Rd PivotalR/man/print.rf.madlib.Rd PivotalR/man/text.dt.madlib.Rd PivotalR/man/madlib.lda.Rd PivotalR/man/logical-methods.Rd PivotalR/man/compare-methods.Rd PivotalR/man/unique-methods.Rd PivotalR/man/residuals.Rd PivotalR/man/dim-methods.Rd PivotalR/man/db.objects.Rd PivotalR/man/print.elnet.madlib.Rd PivotalR/man/as.db.data.frame-methods.Rd PivotalR/man/predict.elnet.madlib.Rd PivotalR/man/pivotalr.Rd PivotalR/man/madlib.glm.Rd PivotalR/man/madlib.elnet.Rd PivotalR/man/madlib.arima.Rd PivotalR/man/db.existsObject.Rd PivotalR/man/sample-methods.Rd PivotalR/man/func-methods.Rd PivotalR/man/print.summary.madlib.Rd PivotalR/man/is.na-methods.Rd PivotalR/man/conn.eql.Rd PivotalR/man/is.db.data.frame.Rd PivotalR/man/names-methods.Rd PivotalR/man/predict.arima.madlib.Rd PivotalR/man/db.search.path.Rd PivotalR/man/aic.Rd PivotalR/man/clean.madlib.temp.Rd PivotalR/man/na.action.Rd PivotalR/man/subset-methods.Rd PivotalR/man/sort-methods.Rd PivotalR/man/as.factor-methods.Rd PivotalR/man/summary.elnet.madlib.Rd PivotalR/man/predict.Rd PivotalR/man/db.q.Rd PivotalR/man/perplexity.lda.madlib.Rd PivotalR/man/print.none.obj.Rd PivotalR/man/db.data.frame-class.Rd PivotalR/man/print.lm.madlib.Rd PivotalR/man/pkg-package.Rd PivotalR/man/summary.arima.madlib.Rd PivotalR/man/null.data.Rd PivotalR/man/predict.bagging.model.Rd PivotalR/man/print.arima.madlib.Rd PivotalR/man/madlib.summary.Rd PivotalR/man/predict.lda.madlib.Rd PivotalR/man/groups.Rd PivotalR/man/db.disconnect.Rd PivotalR/man/madlib.lm.Rd PivotalR/man/print-methods.Rd PivotalR/man/madlib.kmeans.Rd PivotalR/man/db.connect.Rd PivotalR/man/cbind2.Rd PivotalR/man/summary.logregr.madlib.Rd PivotalR/man/generic.bagging.Rd PivotalR/man/predict.dt.madlib.Rd PivotalR/man/predict.rf.madlib.Rd PivotalR/man/row_actions.Rd PivotalR/man/db.Rcrossprod-class.Rd PivotalR/man/type-cast.Rd PivotalR/man/conn.id.Rd PivotalR/man/getTree.rf.madlib.Rd PivotalR/man/array.len.Rd PivotalR/man/vcov.Rd PivotalR/man/extract-replace-methods.Rd PivotalR/man/merge-methods.Rd PivotalR/man/plot.dt.madlib.Rd PivotalR/man/summary.lm.madlib.Rd PivotalR/man/db.table-class.Rd PivotalR/man/delete-methods.Rd PivotalR/man/db.list.Rd PivotalR/man/by-methods.Rd PivotalR/man/scale-methods.Rd PivotalR/man/arith-methods.Rd PivotalR/man/preview.Rd PivotalR/man/db.obj-class.Rd PivotalR/man/connection-info.Rd PivotalR/man/arraydb.to.arrayr.Rd PivotalR/man/margins.Rd PivotalR/man/print.dt.madlib.Rd PivotalR/man/abalone.Rd PivotalR/man/crossprod.Rd PivotalR/man/aggregate-methods.Rd PivotalR/man/madlib.svm.Rd PivotalR/man/db.view-class.Rd PivotalR/man/madlib.randomForest.Rd PivotalR/man/is.factor-methods.Rd PivotalR/man/coef.Rd
PivotalR/cleanup

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.