Index

A

access control
- for datastores 2.2.5.4, 6.3.3
- for scripts 6.2.2, 6.3.2
accessor functions 3.1.9
aggregate function 1.4.1, 3.1.5
aggregating data 3.1.5, 3.3.4
aggregation functions 3.1.9, 3.3.4
algorithms
- Apriori 4.2.2
- association rules 4.2.2
- attribute importance 4.2.3
- Decision Tree 4.2.4
- Expectation Maximization 4.2.5
- Explicit Semantic Analysis 4.2.6
- Extensible R 4.2.7
- Generalized Linear Model 4.2.8
- k-Means 4.2.9
- Minimum Description Length 4.2.3
- Naive Bayes 4.2.10
- Non-Negative Matrix Factorization 4.2.11
- Orthogonal Partitioning Cluster 4.2.12
- Singular Value Decomposition 4.2.13
- Support Vector Machine 4.2.14
ALL_RQ_DATASTORES view B.1
ALL_RQ_SCRIPTS view B.2
Apriori algorithm 4.2.2
arima function 3.1.9
arrange_ function
- description 3.3.1
arrange function
- description 3.3.1
- example 3.3.1.3, 3.3.1.5
as.Date function 3.1.9
as.difftime function 3.1.9
as.integer function 3.1.9
as.ore.character function 1.4.2.4, 3.1.9
as.ore.date function 3.1.9
as.ore class 3.1.9
as.ore function 1.4.2.4
association models 4.2.2
attaching a schema 2.2.1.4
attribute importance models 4.2.3

C

C50 package 6.1.5, 6.2.5.1, 6.2.6, A.4, A.6
class inheritance 1.4.1
coercing class types 1.4.2.4
columns
- deriving 3.1.6
- partitioning on 6.2.5.2
combining data 3.1.4
Comprehensive R Archive Network
- See: CRAN packages
connecting an R session 2.1
connections, specifying 2.1.1.1
connection types 2.1.1.1
control arguments for embedded R execution 6.2.1.2
count function
- description 3.3.4
- example 3.3.4
CRAN packages 1.2, 3.1.1, 3.4, 6.1.4, 6.1.5
creating a table 2.2.4
creating proxy objects 2.2.1.1
cross-validating models 4.3
ctx.settings argument 4.2.1.3, 4.2.16
cume_dist function
- description 3.3.6
- examples 3.3.6

D

data
- aggregating 3.3.4
- distribution analysis of 3.2.10
- exploring 3.2
- grouping 3.3.3
- indexing 3.1.3
- joining 3.1.4, 3.3.2
- partitioning 3.1.8
- preparing 1.2, 3.1.1
- ranking 3.2.7, 3.3.6
- sampling 3.1.7, 3.3.5
- scoring 1.2
- selecting 3.1.2, 3.3.1
- sorting 3.2.8
- summarizing 3.1.5, 3.3.4
- transforming 3.1.6
- transmuting 3.3.1
datastores
- about 2.2.5.2
- access control 2.2.5.4
- deleting 2.2.5.7
- getting information about 2.2.5.5
- in embedded R execution 2.2.5.8, 6.2.6, A.4, A.6, A.7
- managing in SQL 6.3.3
- restoring objects from 2.2.5.6
- saving objects in 2.2.5, 2.2.5.3
data types
- coercing to another type 3.1.9
date and time objects 3.1.9
DCLI 6.1.5
Decision Tree algorithm 4.2.4
Decision Tree models 4.2.4
dense_rank function
- description 3.3.6
- examples 3.3.6
density estimation algorithm 4.2.5
desc function
- description 3.3.1
- example 3.3.1.5
detaching a schema 2.2.1.4
diff function 3.1.9
distinct_ function
- description 3.3.1
distinct function
- description 3.3.1
- example 3.3.1.3
do.call function 3.1.7
dplyr package 3.3
dropping a table 2.2.4

E

e1071 package 6.2.4
easy connect string, specifying 2.1.2
embedded R execution 1.2
- about 6.1
- APIs for 6.1.2
- control arguments 6.2.1.2
- parallel execution 6.1.4, 6.2.1.5
- R interface for 6.2
- security 6.1.3
- SQL interface for 6.3
executing SQL statements 2.2.2.3
Expectation Maximization model 4.2.5
Explicit Semantic Analysis model 4.2.6
exploratory data analysis
- data set for examples 3.2.2
exponential smoothing models 3.2.6
Extensible R model 4.2.7

F

feature extraction algorithm 4.2.6, 4.2.13
filter_ function
- description 3.3.1
filter function
- description 3.3.1
- example 3.3.1.4
- examples 3.3.1.6
filtering data 2.2.3
forecast package 3.2.6
formatting data 3.1.6
full_join function
- description 3.3.2
- example of 3.3.2

G

Generalized Linear Model 4.1.4, 4.2.8
glm function 4.1.4
global options 1.6, 2.2.2.2
- ore.envAsEmptyenv 1.6
- ore.na.extract 1.6
- ore.parallel 1.6
- ore.sep 1.6
- ore.trace 1.6
- ore.warn.order 1.6
group_by function
- description 3.3.3
- examples 3.3.3
group_size function
- description 3.3.3
- examples 3.3.3
groups function
- description 3.3.3
- examples 3.3.3

H

Hadoop cluster 2.1.1.1
HIVE connection type 2.1.1.1

I

indexing data 3.1.3
inner_join function
- description 3.3.2
- example of 3.3.2
install.packages function 3.4
IRLS algorithm 4.1.4
is.null function 2.2.2.1

K

kernlab package 2.2.2.3, 3.4
keys
- ordering with 2.2.2.3
k-Means models 4.2.9
kyphosis data set 4.1.4

L

lapply function 3.1.7
least squares regression 4.1.3
left_join function
- description 3.3.2
- example of 3.3.2
library function 3.4
linear regression model 4.1.3
longley data set 4.1.2

M

machine learning models 4.2
map/reduce operations 4.1.4
max function 3.1.9
min_rank function
- description 3.3.6
- examples 3.3.6
min function 3.1.9
Minimum Description Length algorithm 4.2.3
models
- association 4.2.2
- attribute importance 4.2.3
- cross-validating 4.3
- Decision Tree 4.2.4
- Expectation Maximization 4.2.5
- Explicit Semantic Analysis 4.2.6
- Extensible R 4.2.7
- Generalized Linear Model 4.1.4, 4.2.8
- k-Means 4.2.9
- linear regression 4.1.3
- Naive Bayes 4.2.10
- Neural Network 4.1.5
- Non-Negative Matrix Factorization 4.2.11
- OML4SQL 4.2
- Orthogonal Partitioning Cluster 4.2.12
- parametric 4.2.8
- partitioned 4.2.15
- predictive 5.1
- Random Forest 4.1.6
- Singular Value Decomposition 4.2.13
- Support Vector Machine 4.2.14
mutate_ function
- description 3.3.1
mutate function
- description 3.3.1
- examples 3.3.1.7, 3.3.6

N

n_groups function
- description 3.3.3
- examples 3.3.3
Naive Bayes models 4.2.10
naming conventions 1.4.2.3
NARROW data set 3.2.2
neural network models 4
Neural Network models 4.1.5
NMF models 4.2.11
ntile function
- description 3.3.6
- examples 3.3.6

O

O-Cluster models 4.2.12
odm.settings argument 4.2.1.3, 4.2.15, 4.2.16
OML4R script repository 6.2.2, 6.3.2
OML4SQL models 4, 4.2
- partitioned 4.2.15
- settings 4.2.1.3
open source R packages 3.4, 6.1.4
ORACLE connection type 2.1.1.1
Oracle Data Mining rebranded
Oracle Machine Learning for Spark 2.1.1.1
Oracle R Advanced Analytics for Hadoop rebranded
Oracle R Enterprise rebranded
Oracle Wallet 2.1.1.1, 2.1.2
ordering ore.frame objects 1.4.2.2, 2.2.2
ore.attach function 2.2.1.1, 2.2.1.4
ore.character objects 3.1.9
ore.connect control argument for embedded R execution 6.2.1.2
ore.connect function 2.1.1.1
ore.corr function 3.2.1, 3.2.3
ore.create function 2.2.4
ore.crosstab function 3.2.1, 3.2.4
ore.CV function 4.3
ore.datastore function 2.2.5.1, 2.2.5.5
ore.datastoreSummary function 2.2.5.1, 2.2.5.5
ore.date objects 3.1.9
ore.datetime objects 3.1.9
ore.delete function 2.2.5.7
- ore.grant function 2.2.5.1
ore.detach function 2.2.1.4
ore.disconnect function 2.1.1.1, 2.1.1.2
ore.doEval function 6.2.3
ore.drop control argument for embedded R execution 6.2.1.2
ore.drop function 2.2.4
ore.envAsEmptyenv control argument for embedded R execution 6.2.1.2
ore.envAsEmptyenv global option 1.6
ore.esm function 3.2.1, 3.2.6
ore.exec function 2.2.2.3, 3.1.2.2
ore.exists function 2.2.1.1
ore.frame objects
- about 1.4.2.2
- as proxy for a table 2.2.1.1
- column naming conventions 1.4.2.3
- ordering 1.4.2.2
- subclass of data.frame 1.4.1
ore.freq function 3.2.1, 3.2.5
ore.get function 2.2.1.3
ore.glm function 4.1.1, 4.1.4
ore.grant 2.2.5.4
ore.grant function 6.2.2
ore.graphics control argument for embedded R execution 6.2.1.2
ore.groupApply function 3.1.8, 6.2.5
ore.hour function 3.1.9
ore.indexApply function 6.2.7
ore.integer objects 3.1.9
ore.is.connected function 2.1.1.1
ore.lazyLoad function 2.2.5.1
ore.list class 2.2.3
ore.lm function 4.1.1, 4.1.3
ore.load function 2.2.5.1, 2.2.5.6
ore.logical class 3.1.9
ore.ls function 2.2.1.1
ore.mday function 3.1.9
ore.minute function 3.1.9
ore.month function 3.1.9
ore.na.extract global option 1.6
ore.na.omit control argument for embedded R execution 6.2.1.2
ore.neural function 4.1.1, 4.1.5
ore.odmAI function 4.2.3
ore.odmAssocRules function 4.2.2
ore.odmDT function 4.2.4
ore.odmEM function 4.2.5
ore.odmESA function 4.2.6
ore.odmGLM function 4.2.8
ore.odmKM function 4.2.9
ore.odmNB function 4.2.10
ore.odmNMF function 4.2.11
ore.odmOC function 4.2.12
ore.odmRAlg function 4.2.7
ore.odmSVD function 4.2.13
ore.odmSVM function 4.2.14
ore.parallel global option 1.6
ore.png control arguments for embedded R execution 6.2.1.2
ore.pull function 1.4.2.4, 2.2.3, 3.1.9
ore.push function 1.4.2.4, 2.2.3, 4.1.3
ore.randomForest function 4.1.1, 4.1.6
ore.rank function 3.2.1, 3.2.7
ore.revoke 2.2.5.1, 2.2.5.4
ore.revoke function 6.2.2
ore.rm function 2.2.1.1
ore.rollmean function 3.1.9
ore.rollsd function 3.1.9
ore.rowApply function 6.2.6
ore.save function 2.2.5.1, 2.2.5.2, 2.2.5.3
- examples 2.2.5.3, 6.2.6, A.4, A.6
ore.scriptCreate function 6.2.2
ore.scriptDrop function 6.2.2
ore.scriptList function 6.2.2
ore.scriptLoad function 6.2.2
ore.second function 3.1.9
ore.sep global option 1.6, 2.2.2.2
ore.sort function 3.2.1, 3.2.8
ore.stepwise function 4.1.1, 4.1.3
ore.summary function 3.2.1
ore.sync function 2.2.1.1, 2.2.1.2, 2.2.1.4, 2.2.2.3, 3.1.2.2
ore.tableApply function 6.2.4
ore.trace global option 1.6
ore.univariate function 3.2.1, 3.2.10
ore.warn.order global option 1.6, 2.2.2.2
ore.year function 3.1.9
OREbase package 1.4.1
OREdm package 2.2.5.1, 4.2
OREdplyr package 3.3
OREeda package 3.2.1
OREgraphics package 1.4.1
OREmodels package 4.1
OREpredict package 5.1
OREstats package 1.4.1

P

packages
- C50 6.1.5, 6.2.5.1, 6.2.6, A.4, A.6
- dplyr 3.3
- e1071 6.2.4
- forecast 3.2.6
- kernlab 2.2.2.3, 3.4
- OML4R 1.3
- OREbase 1.4.1
- OREdm 2.2.5.1, 4.2
- OREdplyr 3.3
- OREeda 3.2.1
- OREgraphics 1.4.1
- OREmodels 4.1
- OREpredict 5.1
- OREstats 1.4.1
- rpart 4.1.4
- third-party 3.4, 6.1.5
- TTR 3.2.6
parallel execution 6.1.4, 6.2.1.5
parametric models 4.2.8
partitioning
- OML4SQL models 4.2.15
partitions function 4.2.15
percent_rank function
- description 3.3.6
- examples 3.3.6
persisting proxy objects 2.2.5.1
PL/SQL procedures
- rqDropDataStore A.1
- rqGrant A.3
- rqRevoke A.5
- sys.rqScriptCreate A.8
- sys.rqScriptDrop A.9
prcomp function 3.2.11
preparing data 1.2
- time series 3.1.9
primary keys
- ordering with 2.2.2.3
principal component analysis 3.2.11
princomp function 3.2.11
proxy objects
- for database tables 2.2.1.1

Q

quantile function 3.1.9

R

Random Forest model 4.1.6
range function 3.1.9
rbind function 3.1.7
rebranding
- Oracle Data Mining
- Oracle R Advanced Analytics for Hadoop
- Oracle R Enterprise
regression models 4
removing proxy objects 2.2.1.1
rename_ function
- description 3.3.1
rename function
- description 3.3.1
- example 3.3.1.1
repository, OML4R script 6.2.2
right_join function
- description 3.3.2
- example of 3.3.2
row names
- ordering with 2.2.2.4
rpart package 4.1.4
RQADMIN role 6.1.3
rqDropDataStore procedure A.1
rqEval function 6.3.1, A.2
rqGrant procedure A.3
rqGroupEval function 6.3.1, A.4
rqRevoke procedure A.5
rqRowEval function 6.3.1, A.6
rqTableEval function 6.3.1, A.7
RQUSER_DATASTORECONTENTS view B.3
RQUSER_DATASTORELIST view B.4

S

sample function 3.1.7, 3.1.8
sampling
- cluster 3.1.7
- in-database data 3.1.7
- stratified 3.1.7
sanple_frac function
- description 3.3.5
- example 3.3.5
sanple_n function
- description 3.3.5
- example 3.3.5
saving objects 2.2.5
schema
- attaching 2.2.1.4
- default 2.2.1.4
- detaching 2.2.1.4
scoring data 1.2
script repository 6.2.2
scripts
- dropping A.9
- embedded R execution of 6.1
- executing in database 1.2
- managing in SQL 6.3.2
search path
- adding an environment to 2.2.1.4
- removing a schema from 2.2.1.4
security for embedded R execution scripts 6.1.3
select_ function
- description 3.3.1
- example 3.3.1.2
select function
- description 3.3.1
- example 3.3.1.1
seq function 3.1.7, 3.1.9
settings
- OML4SQL model parameter 4.2.1.3
settings function 4.2.1.3, 4.2.16
singular value decomposition 3.2.12
Singular Value Decomposition model 4.2.13
slice_ function
- description 3.3.1
slice function
- description 3.3.1
- example 3.3.1.4
sort function 3.1.9
SQL functions for embedded R execution 6.3.1
SQL statements, executing 2.2.2.3
SQL table functions 6.3.1
stepwise least squares regression 4.1.3
summarize function
- description 3.3.4
- example 3.3.4
summary function 4.1.4
supported R operators and functions C
svd function 3.2.12
SVM models 4.2.14
synchronizing database tables 2.2.1.1
sys.rqScriptCreate procedure A.8
sys.rqScriptDrop procedure A.9

T

table functions 6.3.1
tables
- creating a database 2.2.4
- dropping a database 2.2.4
- making visible in R 2.2.1.4
- proxy objects for 2.2.1.1
tally function
- description 3.3.4
- example 3.3.4
text processing 4.2.1.3, 4.2.16
third-party packages 3.4, 6.1.4, 6.1.5
transform function
- examples of 3.1.6
transmute_ function
- description 3.3.1
transmute function
- description 3.3.1
- example of 3.3.1.7
transparency layer 1.2, 1.4, 2.2
ts function 3.1.9
TTR package 3.2.6

U

ungroup function
- description 3.3.3
- examples 3.3.3
unique function 3.1.9
use.keys argument to ore.sync 2.2.2.1
USER_RQ_DATASTORE_PRIVS view B.5
USER_RQ_DATASTORES view B.6
USER_RQ_SCRIPT_PRIVS view B.7
USER_RQ_SCRIPTS view B.8

V

views B
- ALL_RQ_DATASTORES B.1
- ALL_RQ_SCRIPTS B.2
- making visible in R 2.2.1.4
- RQUSER_DATASTORECONTENTS B.3
- RQUSER_DATASTORELIST B.4
- USER_RQ_DATASTORE_PRIVS B.5
- USER_RQ_DATASTORES B.6
- USER_RQ_SCRIPT_PRIVS B.7
- USER_RQ_SCRIPTS B.8

W

wallets, Oracle 2.1.1.1, 2.1.2
window functions 3.1.9