Accessing the R datasets in ORE and SQL

When you install R you also get a set of pre-compiled datasets. These are great for trying out many of the features that are available with R and all the new packages that are being produced on an almost daily basis.

The exact list of data sets available will depend on the version of R that you are using.

To get the list of available data sets in R you can run the following.


> (more...)

Experiments with Elastic’s Graph Tool

Elastic announced their Graph tool at ElastiCON 2016 (see presentation here). It’s part of the forthcoming X-Pack which bundles Graph along with other helper tools such as Shield and Marvel. Graph itself is two things; an extension of Elasticsearch’s capabilities, enabling the user to explore how items indexed in Elasticsearch are related, and a plugin for Kibana that acts as an optional front-end for this new functionality.

You can find a good (more...)

DAMA Ireland: Data Protection Event 5th May

We have our next DAMA Ireland event/meeting coming up on the 5th May, and will be in our usual venue of Bank of Ireland, 1 Grand Canal Dock.

Our meeting will cover two topics. The main topic for the evening will be on Data Protection. We have Daragh O'Brien (MD of Castlebridge Associate) presenting on this. Daragh is also the Global Data Privacy Officer for DAMA International. He has also been invoked in contributing to (more...)

Are you worried about what to do now that Discoverer is almost out of support

Hello everyone
Like me, if you are a big user of Discoverer, you would have been alarmed at the news a few years ago that Oracle was dropping the tool.

Well, once I got over my alarm I started to think about how my clients could maximize their use of the at times millions of dollars of investment.

Oracle Corporation’s statement of direction implies that they will not force you off of Discoverer and (more...)

Are you having trouble starting Weblogic from a Windows service

Are you having trouble starting Weblogic on Windows and thus unable to start the WLS_DISCO service? If so, you can start Wenlogic from the command line.

To start Weblogic from the command line, follow these steps:
  1. Open a CMD window
  2. Navigate to the bin folder for Weblogic. Mine is located at C:oracleMiddlewareuser_projectsdomainsClassicDomainbin
  3. Run startweblogic.cmd
  4. Provide a username - in my case weblogic
  5. Provide the password
  6. When started, leave the CMD window open

Next, I (more...)

Oracle Advanced Analytics in the Oracle Cloud

You have heard about the cloud? Right? Even the Oracle Cloud?

If you haven't, then maybe we need to look at how you can learn more about the Oracle Cloud.

Over the past while, and in the past few weeks in particular, Oracle has been advertising about how you can get a trail Oracle cloud service setup for FREE. Well it is free for one month when you set it up on the Oracle website (more...)

More Animals in Big Data Zoo – Big Data Landscape for 2016

| Mar 25, 2016

Hi All

While surfing net stumbled upon Big Data Landscape for 2016 image and it was very impressive to see many more new Animals in Big Data Zoo.

 

New Animals

Hope This Helps

Sunil S Ranka


Configuring RStudio Server for Oracle R Enterprise

In this blog post I will show you the configurations that are necessary for RStudio Server to work with Oracle R Enterprise on your Oracle Database server. In theory if you have just installed ORE and then RStudio Server, everything should work, but if you encounter any issues then check out the following.

Before I get started make sure to check out my previous blog posts on installing R Studio Server. The first blog post (more...)

Installing RStudio Server on an (Oracle) Linux server

In a previous blog post I showed how you can install and get started with using RStudio on a server by using RStudio Server. My previous post showed how you could do that on the Oracle BigDataLite VM. On this VM everything was nicely scripted and set up for you. But when it comes to installing it on a different server, well things can be a bit different.

The purpose of this blog post is (more...)

Installing RStudio Server on Oracle BigDataLite VM

A very popular tool for data scientists is RStudio. This tool allows you to interactively work with your R code, view the R console, the graphs and charts you create, manage the various objects and data frames you create, as well shaving easy access to the R help documentation. Basically it is a core everyday tool.

The typical approach is to have RStudio installed on your desktop or laptop. What this really means is that (more...)

Issue in using EJB Actions in OBIEE 11.1.1.9

This blog is less about a solution and more about an information.

If you have written an EJB that uses a obiee report saved in the catalog as an arguement and you are trying to invoke this EJB using Actions in OBIEE 11.1.1.9 then you might get the following error.


Assertion failure: false at line 1320 of project/webhttp/httpstream.cpp[[ 
File:parametervalueresolvers.cpp 
Line:480 
Location: 
saw.httpserver.processrequest 
saw.rpc.server.responder 
saw.rpc. (more...)

OUG Ireland 2016: a roaring success

Last week we had out OUG Ireland annual conference. Traditionally it has been a 1 day conference and in the past few years we have had an extra day where we had the likes of Tom Kyte (we miss you), Maria Colgan, etc give a full day seminar.

But over the past few years a few of the committee have been constantly asked about when we would have a second day of presentations (just like (more...)

Migrating application roles in OBIEE 11g

My last article talked about a maintenance and hassle free mechanism to implement security. The article moved the security architecture to roles created in EM. The next logical step is to move the roles from one environment to another because lets face it, manually creating roles is a lot of effort.


Oracle has a process to migrate the policy store from one environment to another and is described @ http://docs.oracle.com/cd/E14571_01/core.1111/e10043/addlsecfea.htm#JISEC3593

This (more...)

Recoding variable values using ore.recode

Oracle R Enterprise comes with a vast array of features that not really documented anywhere. One of these features that I've recently found useful is the ore.recode() function.

The following code illustrates how you can records the values in an existing attributes or (more specifically in this example) how you can create a new attribute based on the values in another attribute.

The data set that I'm using is the White Wine data set (more...)

Big Data – Tez, MR, Spark Execution Engine : Performance Comparison

| Feb 25, 2016

There is no question that massive data is being generated in greater volumes than ever before. Along with the traditional data set, new data sources as sensors, application logs, IOT devices, and social networks are adding to data growth. Unlike traditional ETL platforms like Informatica, ODI, DataStage that are largely proprietary commercial products, the majority of Big ETL platforms are powered by open source.

With many execution engines, customers are always curious about their usage (more...)

BI & Analytics – Agile BI and / or Enterprise Reporting?

As I wrote in my last blogpost, Gartner’s latest version of the Magic Quadrant for Business Intelligence and Analytics Platforms (#BIAMQ) caused a lot of noise in the Analytics Market. Gartner and Oracle have different views of this market. Gartner sees a difference; “between a modern BI and Analytics Platform and a traditional, IT-centric Reporting and…Read more BI & Analytics – Agile BI and / or Enterprise Reporting?

So Oracle did not make it to the Magic Quadrant for Business Intelligence and Analytics Platforms?

Earlier this month Gartner released a new version of the Magic Quadrant for Business Intelligence and Analytics Platforms. This release has caused a lot of noise in the Analytics Market. Vendors have changed quadrants or even disappeared completely (eg. Oracle). Traditionally, the Analytics Market is characterized by IT-led buying. Over the last years there is a…Read more So Oracle did not make it to the Magic Quadrant for Business Intelligence and Analytics Platforms?

OUG Ireland 2016: APPs Track highlights

Today I was joined by Debra Lilly who is the APPs track lead and conference chair for OUG Ireland. Debra lets us know what we can look forward to on the APPs track at this years conference.

Check out Debra's video.

Click on the image below to get more details of the agenda and to register for this 2 day conference.

NewImage

Follow the conference and OUG Ireland on twitter using #oug_ire

OUG Ireland 2016: DBA and Developer track highlights

This morning I records a short video (1:18m) view with Simon Holt giving a quick overview and some highlights of the DBA and Developer tracks for the upcoming OUG Ireland 2016 conference.

Click on the image below to get more details of the agenda and to register for this 2 day conference.

NewImage

Follow the conference and OUG Ireland on twitter using #oug_ire

Maintenance free security implementation in OBIEE 11g

This blog talks about a hassle free mechanism of OBIEE security implementation with almost zero overhead.
We will first look at the data level security implementation and then extend it to object level security.


Data Level Security:
Data level security is usually implemented using database tables. These tables store the users and the filter (more...)