Introduction | Prerequisites | Getting Started | Working with ida.data.frame | Preprocess and Analyze Data | Store and Share R Objects | Frequently asked questions | Further Reading
Package: ibmdbR 1.51.0
Shaikh Quader
ibmdbR: IBM in-Database Analytics for R
Functionality required to efficiently use R with IBM(R) Db2(R) Warehouse offerings (formerly IBM dashDB(R)) and IBM Db2 for z/OS(R) in conjunction with IBM Db2 Analytics Accelerator for z/OS. Many basic and complex R operations are pushed down into the database, which removes the main memory boundary of R and allows to make full use of parallel processing in the underlying database. For executing R-functions in a multi-node environment in parallel the idaTApply() function requires the 'SparkR' package (<https://spark.apache.org/docs/latest/sparkr.html>). The optional 'ggplot2' package is needed for the plot.idaLm() function only.
Authors:
ibmdbR_1.51.0.tar.gz
ibmdbR_1.51.0.zip(r-4.7-any)ibmdbR_1.51.0.zip(r-4.6-any)
ibmdbR_1.51.0.tar.gz(r-4.7-any)ibmdbR_1.51.0.tar.gz(r-4.6-any)
ibmdbR_1.51.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
ibmdbR/json (API)
| # Install 'ibmdbR' in R: |
| install.packages('ibmdbR', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
This package does not link to any Github/Gitlab/R-forge repository. No issue tracker or development information is available.
Last updated from:9f0b5822b6. Checks:6 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 204 | ||
| source / vignettes | OK | 289 | ||
| linux-release | OK | 155 | ||
| windows-devel | OK | 99 | ||
| windows-release | OK | 109 | ||
| wasm-release | OK | 121 |
Exports:as.data.frameas.ida.data.framecolnamescorcovdb.is.nullheadhistida.data.frameida.listidaAppendidaApplyRulesidaAruleidaCloseidaConnectidaCreateViewidaDeleteTableidadfidaDivClusteridaDropModelidaDropViewidaExistTableidaGetAcceleratoridaGetAcceleratorDetailsidaGetModelnameidaGetValidTableNameidaGlmidaInitidaIsViewidaKMeansidaListAcceleratorsidaListModelsidaLmidaMergeidaModelExistsidaNaiveBayesidaQueryidaRetrieveModelidaSampleidaSaveidaScalarQueryidaSetAcceleratoridaShowTablesidaTableidaTApplyidaTreeidaTwoStepidaUpdateifelseis.ida.data.frameis.ida.listNCOLNROWplot.idaLmplot.idaTreepredict.idaDivClusterpredict.idaGlmpredict.idaKMeanspredict.idaLmpredict.idaNaiveBayespredict.idaTreepredict.idaTwoStepprint.idaDivClusterprint.idaGlmprint.idaKMeansprint.idaLmprint.idaNaiveBayesprint.idaTwoStepsdsummaryvar
Dependencies:arulesgenericslatticeMASSMatrixRODBCrpartrpart.plot
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| IBM In-Database Analytics | ibmdbR-package ibmdbR |
| Convert an R object to an IDA data frame | as.ida.data.frame |
| Available methods for ida.col.def | !,ida.col.def-method as.character,ida.col.def-method as.integer,ida.col.def-method as.numeric,ida.col.def-method as.vector,ida.col.def,ANY-method as.vector,ida.col.def-method db.is.null format.ida.col.def ifelse,ida.col.def-method print,ida.col.def-method |
| Available methods for ida.data.frame | $,ida.data.frame-method $<-,ida.data.frame-method as.data.frame,ida.data.frame-method colnames,ida.data.frame-method cor,ida.data.frame-method cov,ANY,ANY-method cov,ANY,ida.data.frame-method cov,ida.data.frame,ANY-method cov,ida.data.frame,ida.data.frame-method dim,ida.data.frame-method head,ida.data.frame-method hist,ida.data.frame-method length,ida.data.frame-method max,ida.data.frame-method mean,ida.data.frame-method min,ida.data.frame-method names,ida.data.frame-method NCOL,ida.data.frame-method NROW,ida.data.frame-method print,ida.data.frame-method sd,ida.data.frame-method summary,ida.data.frame-method var,ida.data.frame-method [,ida.data.frame,ANY,ANY,ANY-method [,ida.data.frame-method |
| Create an IDA data frame | ida.data.frame is.ida.data.frame |
| Store and retrieve R objects in the database | ida.list is.ida.list |
| Available methods for ida.list | !,ida.list-method $,ida.list-method $<-,ida.list-method length,ida.list-method names,ida.list-method print,ida.list-method [,ida.list,ANY,ANY,ANY-method [,ida.list-method [<-,ida.list,ANY,ANY,ANY-method [<-,ida.list-method |
| Association Rule Mining | idaApplyRules idaArule |
| Open or closes a IDA database connection | idaClose idaConnect |
| Create or drop a view | idaCreateView idaDropView |
| Miscellaneous tools | idaAppend idaDeleteTable idaExistTable idaGetValidTableName idaIsView |
| Query, store and update data in the database. | idadf idaSave idaUpdate |
| Hierarchical (divisive) clustering | idaDivCluster predict.idaDivCluster print.idaDivCluster |
| Drop a predictive model from the database | idaDropModel |
| Get the name of a model | idaGetModelname |
| Generalized Linear Models (GLM) | idaGlm predict.idaGlm print.idaGlm |
| Initialize the In-Database Analytics functions | idaInit |
| k-means clustering | idaKMeans predict.idaKMeans print.idaKMeans |
| Show and set accelerator settings | idaGetAccelerator idaGetAcceleratorDetails idaListAccelerators idaSetAccelerator |
| List all predictive models in the database | idaListModels idaModelExists |
| Linear regression | idaLm plot.idaLm predict.idaLm print.idaLm |
| Merge IDA data frames | idaMerge |
| Naive Bayes Classifier | idaNaiveBayes predict.idaNaiveBayes print.idaNaiveBayes |
| Run an SQL query on the database | idaQuery idaScalarQuery |
| Retrieve a predictive model from the database | idaRetrieveModel |
| Taking a random sample from a IDA data frame | idaSample |
| Return a list of tables | idaShowTables |
| In-Database Cross Tabulation and Table Creation | idaTable |
| Apply R-function to subsets of IDA data frame | idaTApply |
| Decision and Regression tree | idaTree plot.idaTree predict.idaTree |
| two step clustering | idaTwoStep predict.idaTwoStep print.idaTwoStep |