Index

A  C  D  E  F  G  H  I  K  L  M  N  O  P  Q  R  S  T  U  V  W 

---

A

accessor functions, 3.1.9

aggregate function, 1.4.1, 1.4.1, 3.1.5

aggregating data, 3.1.5

aggregation functions, 3.1.9

apriori algorithm, 4.2.2

arima function, 3.1.9

arules package, Preface

as.Date function, 3.1.9

as.difftime function, 3.1.9, 3.1.9

as.integer function, 3.1.9

as.ore class, 3.1.9

as.ore function, 1.4.2.4

as.ore.character function, 1.4.2.4, 3.1.9

as.ore.date function, 3.1.9

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, 6.3.3, 6.3.3

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

connection types, 2.1.1.1

connections, specifying, 2.1.1.1

control arguments for embedded R execution, 6.2.1.2

CRAN packages, Preface, 1.2, 3.1.1, 3.3, 6.1.4, 6.1.5

creating a table, 2.2.4

creating proxy objects, 2.2.1.1

creating scripts

with the SQL API, 6.3.2

cross-validating models, 4.3

---

D

data

distribution analysis of, 3.2.10

exploring, 3.2

indexing, 3.1.3

joining, 3.1.4

partitioning, 3.1.8

preparing, 1.2, 3.1.1

ranking, 3.2.7

sampling, 3.1.7

scoring, 1.2

selecting, 3.1.2

sorting, 3.2.8

summarizing, 3.1.5, 3.2.9

transforming, 3.1.6

data types

coercing to another type, 3.1.9

datastores

about, 2.2.5.2

deleting, 2.2.5.6

getting information about, 2.2.5.4

in embedded R execution, 2.2.5.7, 6.2.6, 6.3.3, 6.3.3, 6.3.3

managing in SQL, 6.3.3

restoring objects from, 2.2.5.5

saving objects in, 2.2.5, 2.2.5.3

date and time objects, 3.1.9

DCLI, 6.1.5

Decision Tree algorithm, 4.2.4

decision tree models, 4.2.4

demo function, 1.7.2

demos, 1.7

detaching a schema, 2.2.1.4

diff function, 3.1.9, 3.1.9

do.call function, 3.1.7, 3.1.7

dropping a table, 2.2.4

dropping scripts

with the SQL API, 6.3.2

---

E

e1071 package, 6.2.4

easy connect string, specifying, 2.1.2, 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

example scripts, 1.7

executing SQL statements, 2.2.2.3

exploratory data analysis

data set for examples, 3.2.2

exponential smoothing models, 3.2.6

---

F

filtering data, 2.2.3

forecast package, 3.2.6

formatting data, 3.1.6

---

G

generalized linear models, 4.1.4, 4.2.5

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

---

H

Hadoop cluster, 2.1.1.1

HIVE connection type, 2.1.1.1

---

I

indexing data, 3.1.3

install.packages function, 3.3

IRLS algorithm, 4.1.4

is.null function, 2.2.2.1

---

K

kernlab package, 2.2.2.3, 3.3

keys

ordering with, 2.2.2.3

k-Means models, 4.2.6

kyphosis data set, 4.1.4

---

L

lapply function, 3.1.7

least squares regression, 4.1.3

library function, 3.3

linear regression model, 4.1.3

load function, 2.2.5.1

local host, specifying, 2.1.2

longley data set, 4.1.2

---

M

map/reduce operations, 4.1.4

max function, 3.1.9

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

generalized linear, 4.1.4, 4.2.5

k-Means, 4.2.6

linear regression, 4.1.3

Naive Bayes, 4.2.7

neural network, 4.1.5

Non-Negative Matrix Factorization, 4.2.8

Oracle Data Mining, 4.2

Orthogonal Partitioning Cluster, 4.2.9

parametric, 4.2.5

predictive, 5.1

Support Vector Machine, 4.2.10

---

N

Naive Bayes models, 4.2.7

naming conventions, 1.4.2.3

NARROW data set, 3.2.2

neural network models, 4, 4.1.5

NMF models, 4.2.8

---

O

O-Cluster models, 4.2.9

open source R packages, 3.3, 6.1.4

Oracle Advanced Analytics, 1.1

ORACLE connection type, 2.1.1.1

Oracle Data Mining models, 4, 4.2

Oracle R Advanced Analytics for Hadoop, 2.1.1.1

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

OREbase package, 1.3, 1.4.1

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, 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.4

ore.datastoreSummary function, 2.2.5.1, 2.2.5.4

ore.date objects, 3.1.9

ore.datetime objects, 3.1.9

ore.delete function, 2.2.5.1, 2.2.5.6

ore.detach function, 2.2.1.4

ore.disconnect function, 2.1.1.1, 2.1.1.2

OREdm package, 2.2.5.1, 4.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

OREeda package, 3.2.1, 3.2.1

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.graphics control argument for embedded R execution, 6.2.1.2

OREgraphics package, 1.4.1

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.5

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

OREmodels package, 4.1

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.odmGLM function, 4.2.5

ore.odmKM function, 4.2.6

ore.odmNB function, 4.2.7

ore.odmNMF function, 4.2.8

ore.odmOC function, 4.2.9

ore.odmSVM function, 4.2.10

ore.parallel global option, 1.6

ore.png control arguments for embedded R execution, 6.2.1.2

OREpredict package, 5.1

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.rank function, 3.2.1, 3.2.7

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.1, 2.2.5.2, 2.2.5.3

ore.scriptCreate function, 6.2.2

ore.scriptDrop function, 6.2.2

ore.second function, 3.1.9

ore.sep global option, 1.6, 2.2.2.2

OREShowDoc function, 1.3

ore.sort function, 3.2.1, 3.2.8

OREstats package, 1.4.1

ore.stepwise function, 4.1.1, 4.1.3

ore.summary function, 3.2.1, 3.2.9

ore.sync function, 2.2.1.1, 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

---

P

packages

arules, Preface

C50, 6.1.5, 6.2.5.1, 6.2.6, 6.3.3, 6.3.3

e1071, 6.2.4

forecast, 3.2.6

kernlab, 2.2.2.3, 3.3

Oracle R Enterprise, 1.3

ORE, 1.7.2

OREbase, 1.4.1

OREdm, 2.2.5.1, 4.2

OREeda, 3.2.1

OREgraphics, 1.4.1

OREmodels, 4.1

OREpredict, 5.1

OREstats, 1.4.1

rpart, 4.1.4

statmod, Preface

third-party, 3.3, 6.1.5

TTR, 3.2.6

parallel execution, 6.1.4, 6.2.1.5

parametric models, 4.2.5

persisting objects, 2.2.5.1

preparing data, 1.2

time series, 3.1.9

primary keys

ordering with, 2.2.2.3

proxy objects

for database tables, 2.2.1.1, 2.2.1.1

---

Q

quantile function, 3.1.9

---

R

R script repository, 6.3.2

range function, 3.1.9

rbind function, 3.1.7, 3.1.7

regression models, 4

removing proxy objects, 2.2.1.1

row names

ordering with, 2.2.2.4

rpart package, 4.1.4

RQADMIN role, 6.1.3

rqDataStoreContents function, 6.3.3

rqDataStoreList view, 6.3.3

rqDropDataStore function, 6.3.3

rqEval function, 6.3.1, 6.3.3

rqGroupEval function, 6.3.1, 6.3.3

rqRowEval function, 6.3.1, 6.3.3

rqTableEval function, 6.3.1, 6.3.3, 6.3.3

---

S

sample function, 3.1.7, 3.1.7, 3.1.7, 3.1.8

sample programs, 1.7

sampling

cluster, 3.1.7

in-database data, 3.1.7

quota, 3.1.7

stratified, 3.1.7

save function, 2.2.5.1

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

scripts

embedded R execution of, 6.1

example, 1.7

executing in database, 1.2

viewing available, 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

seq function, 3.1.7, 3.1.9

service name, specifying, 2.1.2

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

statmod package, Preface

stepwise least squares regression, 4.1.3

summary function, 4.1.4

supported R operators and functions, A

SVM models, 4.2.10

synchronizing database tables, 2.2.1.1

sys.rq_scripts view, 6.3.2

sys.rqScriptCreate function, 6.3.2

sys.rqScriptDrop function, 6.3.2

---

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

third-party packages, 3.3, 6.1.4, 6.1.5

transform function

examples of, 3.1.6

transparency layer, 1.2, 1.4, 2.2

ts function, 3.1.9

TTR package, 3.2.6

---

U

unique function, 3.1.9

use.keys argument to ore.sync, 2.2.2.1

---

V

views

making visible in R, 2.2.1.4

---

W

wallets, Oracle, 2.1.1.1, 2.1.2

window functions, 3.1.9