Oracle R Enterprise: Harnessing the Power of R in Oracle Database
1st Edition
Published on 4. November 2016
288 pages
978-1-259-58564-7 (ISBN)
Available for download
Description
Master the Big Data Capabilities of Oracle R EnterpriseEffectively manage your enterprise s big data and keep complex processes running smoothly using the hands-on information contained in this Oracle Press guide. Oracle R Enterprise: Harnessing the Power of R in Oracle Database shows, step-by-step, how to create and execute large-scale predictive analytics and maintain superior performance. Discover how to explore and prepare your data, accurately model business processes, generate sophisticated graphics, and write and deploy powerful scripts. You will also find out how to effectively incorporate Oracle R Enterprise features in APEX applications, OBIEE dashboards, and Apache Hadoop systems.Learn to: Install, configure, and administer Oracle R Enterprise Establish connections and move data to the database Create Oracle R Enterprise packages and functions Use the R language to work with data in Oracle Database Build models using ODM, ORE, and other algorithms Develop and deploy R scripts and use the R script repository Execute embedded R scripts and employ ORE SQL API functions Map and manipulate data using Oracle R Advanced Analytics for Hadoop Use ORE in Oracle Data Miner, OBIEE, and other applications
More details
Other editions
Additional editions
Book
10/2016
McGraw-Hill Education
€89.32
Article not available at the moment
Content
- Cover
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- 1 Introduction to Oracle R Enterprise
- Aim of This Book
- Oracle Advanced Analytics Option
- Oracle R Enterprise
- Deploying R Is Easy with Oracle R Enterprise
- The Advantages of Using Oracle R Enterprise
- R Technologies from Oracle
- How Customers Are Using Oracle R Enterprise and Oracle Advanced Analytics
- Summary
- 2 Installing Oracle R Enterprise
- Installation Prerequisites
- Setting Up Your Oracle Database
- Installing Oracle R Enterprise
- Oracle R Enterprise Packages
- Pre-installation Requirements
- Oracle Database Server Installation
- Client Installation
- Verifying the Installation of ORE
- Installing RStudio
- Using Oracle Pre-built Appliances
- Oracle Database Developer Pre-built Appliance
- Oracle OBIEE Sample App Pre-built Appliance
- Oracle Big Data Lite Pre-built Appliance
- Summary
- 3 Getting Started with Oracle R Enterprise
- Creating and Managing ORE Connections to the Database
- Creating an ORE Connection Using ore.connect
- Syncing Data Using ore.sync
- Adding Objects to the Search Space Using ore.attach
- Running a SQL Command
- Working with Data in the Oracle Database
- Storing Data in the Database
- Using ore.create to Create Tables
- Using ore.drop to Remove a Table
- Example Combining ore.create and ore.drop
- Storing ORE Objects in the In-database R Datastore
- Disconnecting from the Database
- Summary
- 4 The Transparency Layer
- Overview of the Transparency Layer
- Looking Behind the Scenes of the ORE Transparency Layer
- Summary
- 5 The Oracle R Enterprise Packages
- The Oracle R Enterprise Package
- Exploring the ORE Package Functions and Package Version
- ORE Settings and Options
- Getting Help for ORE
- ORE Demo Script
- Summary
- 6 Exploring Your Data
- Exploratory Data Analysis (EDA)
- Data Sampling
- Data Aggregation
- Data Transformations
- Derived Attributes
- Binning Attributes
- Combining Data
- Sorting Your Data
- Summary
- 7 Building Models Using ODM Algorithms
- Oracle Data Mining
- The ODM Algorithms Available in ORE
- Automatic Data Preparation in Oracle Using the OREdm Package
- Building Models and Scoring Data Using the OREdm Package
- Attribute Importance
- Association Rule Analysis
- Decision Tree
- Support Vector Machine
- Naïve Bayes
- Generalized Linear Model
- Clustering
- Saving Your Data Mining Models
- Summary
- 8 Building Models Using ORE and Other Algorithms
- What Algorithms Are Available?
- Preparing Your Data to Build a Model
- Sample Data Sets for This Chapter
- Building Models Using ORE Algorithms
- Generalized Linear Model
- Linear and Stepwise Regression Models
- Neural Networks
- Random Forests
- Building Models Using R Packages and Algorithms
- Using ore.predict for Optimizing In-database Scoring
- Summary
- 9 Creating R Scripts in the User-defined R Script Repository
- Using the R Script Repository
- Creating and Dropping R Scripts
- Granting and Revoking Privileges to User-defined R Scripts
- Managing the R Script Repository
- Creating Scripts Using the SQL API
- Creating an R Script
- Dropping a Script
- Granting and Revoking Access
- Data Dictionary Views for User-defined R Scripts
- Summary
- 10 Embedded R Execution
- Embedded R Execution Using the R Interface
- How to Use the ore.doEval Function
- How to Use the ore.tableApply Function
- How to Use the ore.groupApply Function
- How to Use the ore.rowApply Function
- How to Use the ore.indexApply Function
- Parallel Execution of Embedded R Functions
- Embedded R Execution Using the SQL Interface
- How to Use the rqEval SQL Function
- How to Use the rqTableEval SQL Function
- How to Use the "rqGroupEval" SQL Function
- How to Use the rqRowEval SQL Function
- Summary
- 11 Oracle R Advanced Analytics for Hadoop
- Connecting to Apache Hive and Processing Data
- Managing Map-Reduce Jobs Using ORCH
- Using Spark with ORAAH
- Summary
- 12 Using ORE with Oracle Data Mining
- Oracle Data Mining
- Oracle Data Miner
- Including R Scripts Using the SQL Node
- Using the R Node
- Summary
- 13 Using ORE in APEX and OBIEE
- Oracle APEX
- Including an ORE Script in Your APEX Application
- Adding an R Graph to Your APEX Application
- Oracle Business Intelligence
- Setting Up OBIEE to Use ORE
- Using an R Script in the OBIEE RPD
- Presenting Results from an R Script on Your Dashboard
- Summary
- 14 ORE for the Oracle DBA
- Creating a New ORE Schema in the Database
- Privilege Required to Run Embedded R
- Installing a New R Package into Oracle R Enterprise
- Installing a New R Package on the Database Server
- Installing a New Package on the Client Machine
- ORE Global Variables and Options
- Using the ore.parallel Feature
- Uninstalling Oracle R Enterprise
- Uninstalling Oracle R Enterprise from the Oracle Database Server
- Uninstalling Oracle R Enterprise from the Client
- Summary
- Index
