- grant execute on rqsys.rqGroupEvalImpl for each user.
- Create all the synonyms listed in rquser.sql for each user.
Start
Connection
From a client
# Load ORE packages and dependencies
# DBI, ROracle, OREbase, MASS, OREstats,
# OREgraphics, OREeda, ORExml, ORE
library(ORE)
# Change the following connection settings:
user <- "scott"
password <- "tiger"
sid <- "mysid"
host <- "myhost"
port <- 1521
all <- TRUE
cat("Connecting to ORE\n")
cat(" User:", user, "\n")
cat(" SID: ", sid, "\n")
cat(" Host:", host, "\n")
ore.connect(user, sid, host, password, port, all)
that you can add in a startup scriptORE Database function
Oracle R Enterprise includes the following R functions that enable transparent access to Oracle Database tables and views:- ore.attach(USER, SID, host, password) establishes a database connection using the schema or user name, the database SID, machine hostname, and password, and creates an environment that maps database table names to R objects (ore.frame) from the schema referenced in the database connection. At this time, views are not mapped. If you use the all parameter of ore.connect when you attach to a database, ore.attach is executed automatically.
- ore.sync() synchronizes with your schema (account) in the Oracle Database. ore.connect can perform this command. If you use the all parameter of ore.connect when you attach to a database, ore.sync is executed automatically.
- ore.detach(“SCHEMA_NAME”) detaches from the schema.
- ore.ls() lists all objects in the schema you are currently connected to.
ORE Objects
Objects created by Oracle R Enterprise are identified with the ore prefix. Pick any object returned by ore.ls() and type either class(OBJECTNAME) or class(OBJECTNAMECOLUMN_NAME).For example,
R> class(NARROW)
[1] "ore.frame"
attr(,"package")
[1] "OREbase"
The prefix ore is applied to the class names. This indicates that the object is an Oracle R Enterprise created object that holds metadata (instead of contents) of the corresponding object in Oracle Database.Sample
Scripts have been added as demos to the ORE package.To access a complete listing of them type
demo(package = "ORE")
To run one of these scripts, specify the name of the demo in a demo function call. For example, to run aggregate.R, type
demo("aggregate", package = "ORE")
table_apply.R Execute R code on all rows of a table passed in at once
aggregate.R Demonstrates aggregations. See also summary.R
analysis.R Demonstrates basic analysis and data processing operations
basic.R Demonstrates basic connectivity to database
binning.R Demonstrates binning in R
columnfns.R Demonstrates use of column functions
corr.R Correlation matrix (Pearson's, Spearman/Kendalls)
crosstab.R Frequency cross-tabulations. Also see freq.R
derived.R Handling derived columns
distributions.R Distribution, Density, and Quantile Functions
doEval.R Demonstrates support for database-enabled parallel simulations
freqanalysis.R Frequency cross-tabulations. Also see crosstab.R
graphics.R Demonstrates visual analysis (boxplot, histogram)
group_apply.R Execute R code for different sets of rows, one set per group
hypothesis.R Hypothesis Testing Functions(binomial, chi square, T test, etc.)
matrix.R Matrix operations
nulls.R Demonstrates handling of nulls in SQL vs. NAs in R
push_pull.R Demonstrates collaborative processing between database and client
rank.R Ranking of observations (ranking, handling ties, etc.)
reg.R Multivariate Regression
row_apply.R Execute R code on each row
sql_like.R Demonstrates how R commands map to SQL operations
stepwise.R Stepwise Multivariate Regression
summary.R Demonstrates summary functionality
Documentation / Reference