ida.data.frame objects provide many methods that will behave exactly like or very similar to methods defined on a regular data.frame. The following is a list of currently supported methods: as.data.frame, sd, max, mean, min, length, print, names, colnames, summary, NROW, NCOL, dim, var, head, hist, cor, cov. Furthermore, the $ and [ operators allow you to select columns and rows and the $<- operator will allow you to add columns. For details see the documentation of ida.data.frame.
In-database analytics functions operate directly on data in a database, rather than requiring that the data first be extracted to working memory. This lets you analyze large amounts of data that would be impractical or impossible to extract. It also avoids security issues associated with extracting data, and ensures that the data being analyzed is as current as possible. Some functions additionally use lazy loading to load only those parts of the data that are actually required, to further increase efficiency.
ida.list
(Package: ibmdbR) :
Store and retrieve R objects in the database
A user can elect to store R objects in a database table rather than storing them in a workstation file system. This makes it easier for users to share objects, and simplifies backup tasks.