
Oracle R Enterprise: Harnessing the Power of R in Oracle Database
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

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
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.