Learn R Programming
⚠️There's a newer version (1.51.0) of this package.Take me there.

Getting Started

The ibmdbR package works with IBM DB2(C) for Linux and Windows Version 10.5, and with IBM dashDB(C). Before you start, you must install DB2 or provision an instance of dashDB on the cloud (see link below).

If you use dashDB on the web, everything is pre-configured and ready to be used from your web browser. If you connect to a DB2 server or use dashDB remotely, you must first install the appropriate client driver packages. For DB2, the driver packages come with the product; for dashDB, you can download them from the dashDB 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".

Useful Links

Copy Link

Version

Install

install.packages('ibmdbR')

Monthly Downloads

214

Version

1.47.1

License

GPL-3

Maintainer

Michael Wurst

Last Published

December 10th, 2015

Functions in ibmdbR (1.47.1)

ida.data.frame, is.ida.data.frame

Create a IDA data frame
ida.list

Store and retrieve R objects in the database
idaArule

Association Rule Mining
ida.data.frame methods

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

Convert an R object to a IDA data frame
idaListModels and idaModelExists

List all predictive models in the database
idaDropModel

Drop a predictive model from the database
idaNaiveBayes

Naive Bayes Classifier
idaSample

Taking a random sample from a IDA data frame
idaKMeans

k-means clustering
ida.list methods

Available methods for ida.list
idaQuery, idaScalarQuery

Run an SQL query on the database
idaDeleteTable, idaExistTable, idaGetValidTableName

Miscellaneous tools
idaInit

Initialize the In-Database Analytics functions
idaRetrieveModel

Retrieve a predictive model from the database
idaMerge

Merge IDA data frames
ida.col.def methods

Available methods for ida.col.def
ibmdbR-package

IBM In-Database Analytics
idaTable

In-Database Cross Tabulation and Table Creation
idaConnect, idaClose

Open or closes a IDA database connection
idadf,idaSave,idaUpdate

Query, store and update data in the database.
idaCreateView, idaDropView

Create or drop a view
idaShowTables

Return a list of tables
idaLm

Linear regression
idaTree

Decision and Regression tree
idaGetModelName

Get the name of a model