| Acknowledgments |
|
xi | |
| Introduction |
|
xii | |
|
1 Introduction to Oracle R Enterprise |
|
|
1 | (16) |
|
|
|
4 | (1) |
|
Oracle Advanced Analytics Option |
|
|
5 | (2) |
|
|
|
7 | (2) |
|
Deploying R Is Easy with Oracle R Enterprise |
|
|
9 | (4) |
|
The Advantages of Using Oracle R Enterprise |
|
|
10 | (3) |
|
R Technologies from Oracle |
|
|
13 | (1) |
|
How Customers Are Using Oracle R Enterprise and Oracle Advanced Analytics |
|
|
14 | (2) |
|
|
|
16 | (1) |
|
2 Installing Oracle R Enterprise |
|
|
17 | (22) |
|
Installation Prerequisites |
|
|
18 | (1) |
|
Setting Up Your Oracle Database |
|
|
19 | (1) |
|
Installing Oracle R Enterprise |
|
|
20 | (12) |
|
Oracle R Enterprise Packages |
|
|
21 | (1) |
|
Pre-installation Requirements |
|
|
21 | (2) |
|
Oracle Database Server Installation |
|
|
23 | (5) |
|
|
|
28 | (4) |
|
Verifying the Installation of ORE |
|
|
32 | (1) |
|
|
|
33 | (1) |
|
Using Oracle Pre-built Appliances |
|
|
34 | (3) |
|
Oracle Database Developer Pre-built Appliance |
|
|
35 | (1) |
|
Oracle OBIEE Sample App Pre-built Appliance |
|
|
35 | (2) |
|
Oracle Big Data Lite Pre-built Appliance |
|
|
37 | (1) |
|
|
|
37 | (2) |
|
3 Getting Started with Oracle R Enterprise |
|
|
39 | (20) |
|
Creating and Managing ORE Connections to the Database |
|
|
40 | (5) |
|
Creating an ORE Connection Using ore. connect |
|
|
40 | (2) |
|
Syncing Data Using ore. sync |
|
|
42 | (2) |
|
Adding Objects to the Search Space Using ore. attach |
|
|
44 | (1) |
|
|
|
45 | (1) |
|
Working with Data in the Oracle Database |
|
|
46 | (4) |
|
Storing Data in the Database |
|
|
50 | (2) |
|
Using ore. create to Create Tables |
|
|
50 | (1) |
|
Using ore. drop to Remove a Table |
|
|
51 | (1) |
|
Example Combining ore. create and ore. drop |
|
|
51 | (1) |
|
Storing ORE Objects in the In-database R Datastore |
|
|
52 | (6) |
|
Disconnecting from the Database |
|
|
58 | (1) |
|
|
|
58 | (1) |
|
|
|
59 | (10) |
|
Overview of the Transparency Layer |
|
|
60 | (3) |
|
Looking Behind the Scenes of the ORE Transparency Layer |
|
|
63 | (4) |
|
|
|
67 | (2) |
|
5 The Oracle R Enterprise Packages |
|
|
69 | (16) |
|
The Oracle R Enterprise Package |
|
|
70 | (2) |
|
Exploring the ORE Package Functions and Package Version |
|
|
72 | (2) |
|
|
|
74 | (4) |
|
|
|
78 | (1) |
|
|
|
79 | (4) |
|
|
|
83 | (2) |
|
|
|
85 | (20) |
|
Exploratory Data Analysis (EDA) |
|
|
86 | (6) |
|
|
|
92 | (6) |
|
|
|
98 | (2) |
|
|
|
100 | (3) |
|
|
|
101 | (1) |
|
|
|
102 | (1) |
|
|
|
103 | (1) |
|
|
|
103 | (1) |
|
|
|
104 | (1) |
|
7 Building Models Using ODM Algorithms |
|
|
105 | (24) |
|
|
|
106 | (3) |
|
The ODM Algorithms Available in ORE |
|
|
107 | (1) |
|
Automatic Data Preparation in Oracle Using the OREdm Package |
|
|
107 | (2) |
|
Building Models and Scoring Data Using the OREdm Package |
|
|
109 | (17) |
|
|
|
110 | (1) |
|
Association Rule Analysis |
|
|
111 | (3) |
|
|
|
114 | (3) |
|
|
|
117 | (4) |
|
|
|
121 | (1) |
|
|
|
122 | (2) |
|
|
|
124 | (2) |
|
Saving Your Data Mining Models |
|
|
126 | (1) |
|
|
|
127 | (2) |
|
8 Building Models Using ORE and Other Algorithms |
|
|
129 | (18) |
|
What Algorithms Are Available? |
|
|
130 | (1) |
|
Preparing Your Data to Build a Model |
|
|
131 | (2) |
|
Sample Data Sets for This Chapter |
|
|
131 | (2) |
|
Building Models Using ORE Algorithms |
|
|
133 | (7) |
|
|
|
133 | (2) |
|
Linear and Stepwise Regression Models |
|
|
135 | (2) |
|
|
|
137 | (1) |
|
|
|
138 | (2) |
|
Building Models Using R Packages and Algorithms |
|
|
140 | (2) |
|
Using ore. predict for Optimizing In-database Scoring |
|
|
142 | (3) |
|
|
|
145 | (2) |
|
9 Creating R Scripts in the User-defined R Script Repository |
|
|
147 | (12) |
|
Using the R Script Repository |
|
|
148 | (1) |
|
Creating and Dropping R Scripts |
|
|
149 | (2) |
|
Granting and Revoking Privileges to User-defined R Scripts |
|
|
151 | (1) |
|
Managing the R Script Repository |
|
|
152 | (1) |
|
Creating Scripts Using the SQL API |
|
|
153 | (5) |
|
|
|
154 | (2) |
|
|
|
156 | (1) |
|
Granting and Revoking Access |
|
|
156 | (1) |
|
Data Dictionary Views for User-defined R Scripts |
|
|
157 | (1) |
|
|
|
158 | (1) |
|
|
|
159 | (26) |
|
Embedded R Execution Using the R Interface |
|
|
160 | (10) |
|
How to Use the ore.doEval Function |
|
|
161 | (2) |
|
How to Use the ore.tableApply Function |
|
|
163 | (2) |
|
How to Use the ore.groupApply Function |
|
|
165 | (1) |
|
How to Use the ore.rowApply Function |
|
|
166 | (2) |
|
How to Use the ore.indexApply Function |
|
|
168 | (1) |
|
Parallel Execution of Embedded R Functions |
|
|
169 | (1) |
|
Embedded R Execution Using the SQL Interface |
|
|
170 | (12) |
|
How to Use the rqEval SQL Function |
|
|
170 | (3) |
|
How to Use the rqTableEval SQL Function |
|
|
173 | (5) |
|
How to Use the "rqGroupEval" SQL Function |
|
|
178 | (3) |
|
How to Use the rqRowEval SQL Function |
|
|
181 | (1) |
|
|
|
182 | (3) |
|
11 Oracle R Advanced Analytics for Hadoop |
|
|
185 | (14) |
|
Connecting to Apache Hive and Processing Data |
|
|
188 | (5) |
|
Managing Map-Reduce Jobs Using ORCH |
|
|
193 | (3) |
|
|
|
196 | (1) |
|
|
|
197 | (2) |
|
12 Using ORE with Oracle Data Mining |
|
|
199 | (14) |
|
|
|
200 | (6) |
|
|
|
206 | (1) |
|
Including R Scripts Using the SQL Node |
|
|
207 | (2) |
|
|
|
209 | (3) |
|
|
|
212 | (1) |
|
13 Using ORE in APEX and OBIEE |
|
|
213 | (16) |
|
|
|
214 | (7) |
|
Including an ORE Script in Your APEX Application |
|
|
216 | (2) |
|
Adding an R Graph to Your APEX Application |
|
|
218 | (3) |
|
Oracle Business Intelligence |
|
|
221 | (7) |
|
Setting Up OBIEE to Use ORE |
|
|
223 | (2) |
|
Using an R Script in the OBIEE RPD |
|
|
225 | (1) |
|
Presenting Results from an R Script on Your Dashboard |
|
|
226 | (2) |
|
|
|
228 | (1) |
|
14 ORE for the Oracle DBA |
|
|
229 | (14) |
|
Creating a New ORE Schema in the Database |
|
|
230 | (1) |
|
Privilege Required to Run Embedded R |
|
|
231 | (1) |
|
Installing a New R Package into Oracle R Enterprise |
|
|
231 | (4) |
|
Installing a New R Package on the Database Server |
|
|
232 | (2) |
|
Installing a New Package on the Client Machine |
|
|
234 | (1) |
|
ORE Global Variables and Options |
|
|
235 | (2) |
|
Using the ore. parallel Feature |
|
|
237 | (1) |
|
Uninstalling Oracle R Enterprise |
|
|
238 | (3) |
|
Uninstalling Oracle R Enterprise from the Oracle Database Server |
|
|
239 | (1) |
|
Uninstalling Oracle R Enterprise from the Client |
|
|
240 | (1) |
|
|
|
241 | (2) |
| Index |
|
243 | |