Community
Search Options
Search Options
Log in
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Data Management
Topic areas
Data Management Global
Db2
Db2 for z/OS and its ecosystem
Db2 Tools for z/OS
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Data Management Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Data Management Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
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.
Ask a question
Join us for IBM TechXchange Day: AI and Automation
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Data Management User Groups
Netezza Performance Server
View Only
Group Home
Discussion
278
Library
51
Blogs
39
Events
1
Members
513
Share
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
#NetezzaPerformanceServer
0 comments
33 views
Permalink
IBM Community Home
Browse
Discussions
Resources
Groups
Events
IBM TechXchange Conference 2023
IBM Community Webinars
All IBM Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Blogging on the Community
All IBM Community Users
Resources
Community Front Porch
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Technology Zone
IBM Training
Marketplace
Marketplace
Data Management
Topic areas
Data Management Global
Db2
Db2 for z/OS and its ecosystem
Db2 Tools for z/OS
Informix
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
User groups
Events
TechXchange Day
IBM TechXchange Conference
Upcoming Data Management Events
IBM TechXchange Webinars
All IBM TechXchange Community Events
Participate
Gamification Program
Community Manager's Welcome
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Data Management Users
All IBM TechXchange Community Users
Resources
IBM TechXchange Group
Data and AI Learning
IBM Champions
IBM Cloud Support
IBM Documentation
IBM Support
IBM Support 101
IBM Technology Zone
IBM Training
TechXchange Day
Marketplace
Marketplace
Powered by Higher Logic