Learn R Programming

Getting Started

The ibmdbR package works with the following IBM database products and services:

  • Products:
    • IBM® Db2® Warehouse (formerly IBM dashDB® Local)
    • IBM Db2 for z/OS® in conjunction with IBM Db2 Analytics Accelerator for z/OS
  • Managed services:
    • IBM Db2 Warehouse on Cloud (formerly IBM dashDB for Analytics)

Before you start, you must install one of these products or provision an instance of one of these managed services. For more information, see:

If you use a Db2 managed service directly, everything is pre-configured and ready to be used from your web browser. If you connect to a Db2 server or use a Db2 managed service remotely, you must first install the appropriate client driver packages. You can download the packages from the service’s web console. After you install the driver packages, you must configure an ODBC source. Refer to the documentation of your operating system for information on how to do this.

For an introduction to the package and first steps, see the package vignette "Use IBM In-Database Analytics with R".

Copy Link

Version

Install

install.packages('ibmdbR')

Monthly Downloads

241

Version

1.51.0

License

GPL-3

Maintainer

Toni Bollinger

Last Published

November 24th, 2023

Functions in ibmdbR (1.51.0)

idaLm

Linear regression
idaGetModelName

Get the name of a model
idaListAccelerators, idaSetAccelerator, idaGetAccelerator, idaGetAcceleratorDetails

Show and set accelerator settings
idaDropModel

Drop a predictive model from the database
idaGlm

Generalized Linear Models (GLM)
idaMerge

Merge IDA data frames
idaListModels and idaModelExists

List all predictive models in the database
idaKMeans

k-means clustering
idaNaiveBayes

Naive Bayes Classifier
idaQuery, idaScalarQuery

Run an SQL query on the database
idaRetrieveModel

Retrieve a predictive model from the database
idaTApply

Apply R-function to subsets of IDA data frame
idaSample

Taking a random sample from a IDA data frame
idaTwoStep

two step clustering
idaTree

Decision and Regression tree
idadf,idaSave,idaUpdate

Query, store and update data in the database.
idaDeleteTable, idaExistTable, idaGetValidTableName, idaIsView

Miscellaneous tools
ibmdbR-package

IBM In-Database Analytics
idaShowTables

Return a list of tables
idaInit

Initialize the In-Database Analytics functions
idaTable

In-Database Cross Tabulation and Table Creation
ida.col.def methods

Available methods for ida.col.def
ida.list

Store and retrieve R objects in the database
ida.list methods

Available methods for ida.list
as.ida.data.frame

Convert an R object to an IDA data frame
idaArule

Association Rule Mining
idaDivCluster

Hierarchical (divisive) clustering
ida.data.frame methods

Available methods for ida.data.frame
idaConnect, idaClose

Open or closes a IDA database connection
idaCreateView, idaDropView

Create or drop a view
ida.data.frame, is.ida.data.frame

Create an IDA data frame