Welcome to the IBM Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
Log in
Search Options
Search Options
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Data Management
Topic groups
Data Management Global
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Early Access Program (EAP) Forum
Db2 for z/OS
Db2 Tools for z/OS
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Gamification Program
Post to Forum
Share a Resource
Blogging on the Community
Connect with Data Management Users
All IBM Community Users
Resources
Community Front Porch
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Technology Zone
IBM Training
Marketplace
Marketplace
IBM Data Management Community
Connect with Db2, Informix, Netezza, open source, and other data experts to gain value
from your data, share insights, and solve problems
Join / Log in
Skip main navigation (Press Enter).
Toggle navigation
Search Options
User Groups
User Group Tag Test
Netezza Performance Server
View Only
Group Home
Discussion
164
Library
33
Blogs
20
Events
0
Members
364
Back to Blog List
R and NPS
By
Nikita Nirbhavane
posted
Mon February 01, 2021 03:02 AM
0
Like
R and NPS
Why should you choose R
with NPS?
In-database analytics with R. Using R on NPS for Analytics, offers a solution that allows users to get the best of both worlds, the flexibility and richness of the R language and the scalability and enterprise strength integration of IBM NPS for Analytics. Figure 1 shows the basic architecture of this integration.
Figure 1: Basic architecture of R and NPS for analytics
One instance of R is running on each of potentially many clients connecting to the data warehouse.
There are several instances of R running in the database. R is running on the SPU allowing to access and process data in parallel in each partition.
Additionally, there is an R instance running on the host. Both the R instances on the server, and the instance on the client are extended by packages that provide the seamless integration between both. Users mostly interact with the client instance of R, just as if working locally.
Overview of the R NPS Analytics Functionality
There are several ways for the R client to interact with the database server.
Figure 2: Functionality Overview
For more details on local data structures to use in R along with NPS refer
NPS Package for R User's Guide
Also, simple operations on the database can be invoked through R wrappers, allowing R users who are not familiar with SQL to perform these operations.
This functionality is described in NPS R Library. Instead of loading the data to the client, the R user can invoke own R functions or transformation on the server, where they are executed either on the host, or in parallel on the data slices.
This is achieved by transferring the user R code to the server, where it is interpreted by the server-side R instances.
For more details regarding compilation, registration and execution of your custom R code in database refer the R user's guide mentioned earlier.
The NPS Client Packages for R
For more details on client packages and API provided by them refer
NPS Package for R User's Guide
Note
: Downloading, installing, and working with Open Source R and all other required packages is subject to the terms and conditions that are mentioned in the appropriate license files of those packages.
Reference URLs:
R repository
:
https://cran.r-project.org/
Git repository:
https://github.com/IBM/NPS-utils/tree/master/R/NPS_R
R Studio (for R client)
:
https://rstudio.com/products/rstudio/download/
IBM knowledge center:
https://www.ibm.com/support/knowledgecenter/SS5FPD_1.0.0/com.ibm.ips.doc/postgresql/ext/opensourcer.html
0 comments
28 views
Permalink
Data Management
Topic groups
Data Management Global
Db2 (On Premises and Cloud)
Db2 Analytics Accelerator for z/OS
Db2 Early Access Program (EAP) Forum
Db2 for z/OS
Db2 Tools for z/OS
IBM Data Virtualization Manager for z/OS
IBM Query Management Facility (QMF)
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
Upcoming Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Gamification Program
Post to Forum
Share a Resource
Blogging on the Community
Connect with Data Management Users
All IBM Community Users
Resources
Community Front Porch
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Technology Zone
IBM Training
Marketplace
Marketplace
Copyright © 2020 IBM Data Science Community. All rights reserved.
Powered by Higher Logic