When Oracle Data Miner (ODMr) 4.0 (which is part of SQL Developer) came out back in late 2013 there was a number of new features added to the tool. One of these was a Graph node that allows us to create various graphs and charts that include Line, Scatter, Bar, Histogram and Box plot.
I've been using this node recently to produce graphs and particularly scatter plots. I've been using the scatter plots to (more...)
Virginia maintains the summary of Deer kills way back from 1947
The stack bar gives a total view of the killings and how it has grown over the years
By comparing the killings on a line chart we see that the female Deer killings has an uptick from 2008 onwards
iCasualties.org maintains documented list of all fatalities for Iraq and Afghanistan wars.
Analysing the USA dataset, we summarize the results by the year
USA war fatalities by year
We are approaching the levels of 2002 and hope for the best that we don’t have to suffer another wars.
Here is another view by year and month
The dataset contains the age of each (more...)
In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query.
See the bottom of this post for the background and some of the reasons for this post.
Before we had the 12c Database if we only wanted to see a subset or the initial set of records from the results of a query we (more...)
GitHub maintains a list of all DMCA takedown notices along with counteractions and retractions if any.
Analysing all the notices from 2011, it seems that the takedown notices are on the rise.
Year View : Notice the sharp increase in 2014
Quarterly view : Now looking at the quarterly breakup, seems like the takedowns are cooling off in the later quarters.
So who is issuing these DMCA takedowns?
Here is the complete list (more...)
Let us move on from Grass Eating Sauropods and talk about who’s who in the analytic space.
For every dime there are dozen analytic companies. Everybody who provides a freaking dashboard is an analytic company. Anybody that merely mentions Google, Facebook, Hadoop etc in the same sentence is somehow into BigData. Haven’t you stumbled across company pages where they claim to be expert in analytics and big data but they want you to schedule a (more...)
Microsoft recently released it first preview version of their next desktop operating system, Windows 10. In our business, we have seen many large companies just migrate to Windows 7 and the general consensus seems to be that Windows 8 is a 'consumer' operating system. In other words, it will be a while before you have to think about Windows 10, but it is our
business to be thinking about this now. We have the Windows (more...)
Kscope15 abstract submission will close in just a few days and the ODTUG content teams want you
I am sure there are many of you who have never done a presentation at a conference and may not feel comfortable speaking in public. Well, I have a secret for you, despite the fact that I won the Best Speaker Award at Kscope14, I share your discomfort with speaking. What works for me, however, is that I (more...)
The following steps are what I did for installing 188.8.131.52 on Windows.
1. Download the Oracle installation ZIP files from the Oracle Downloads page.
2. Unzip the two 12c downloads files into the same directory.
3. Go to the newly created directory (it is probably called 'database') and you will find a file called setup.exe. Double click on this file.
After a couple of seconds you will see the Oracle Database (more...)
Leaving some time between the trip home from OOW14 and finishing up the blog post on the 4 official days of the event has had an interesting effect: excellent write-ups of the news and announcements have already popped up, so it's a pleasure to simply link to Mark Rittman's "News and Updates" post
for all your needs in that regard.
Session or rather content-wise over these four days there are a couple of things to (more...)
w00t! One compound word? Mind-boggling!
As a first time OOW participant, when I arrived at Moscone this morning, the sheer size, grandeur and general over-the-top-ness hit me like a brick. Seeing it in pics and on youtube is one thing but experiencing first hand...wow. KScope back in June was a family party in comparison! Which isn't a bad thing by the way
For me, Sunday was all about getting my bearings and participating - (more...)
Saturday was a rather quiet day. After having spent 2 hours on Friday night, trying to get the connectivity working in my hotel room, Friday started out with another almost 2 hours which culminated on a recabling of the room and replacement modem to finally get things working. After that I was able to put the finishing touches to my presentation.
Lunch was...american. Very american. Think 50s-type diner. Think chili-chedder-hot-dog. Think fries. LOVE IT! (more...)
Oracle Open World is coming up in a few days time. This is a huge event that also incorporates Jave One and various other smaller conferences that are for specific product areas and for partners.
I will be presenting at Oracle Open World this year and I'll also be taking part in a number of other sessions/events including the Oracle ACE Directors briefing. Check out my blog post that list these sessions/events.
In addition to (more...)
I had an previous blog post listing the various Oracle Advanced Analytics sessions/presentation at Oracle Open World 2014.
After trawling through the list of Hands-on-Labs it was disappointing to see that there was no Oracle Data Mining or Oracle R Enterprise hands-on-labs this year.
But there is a hands on lab that looks are how to use the new SQL for Big Data feature (announced over the summer).
Here is the abstract for the session.
With Oracle Open World just a few days away now, I was going through the list of presentations that are focused on using the Oracle Advanced Analytics Option. These will cover Oracle Data Miner and Oracle R Enterprise.
So I've decided to share this list with you :-) and hopefully I will get to see you are some or all of these sessions.
I am doing a repeat of my Kscope15 'Best Speaker' award-winning presentation as part of the ODTUG webcast series. Here is the official announcement from ODTUG:
Wednesday, October 8, 2014 12:00 PM - 1:00 PM EDT
Next Generation Essbase Outline Extractor Tips and Tricks
Tim Tow, Applied OLAP
The Next Generation Outline Extractor is the follow-up to the classic OlapUnderground Essbase Outline Extractor used by thousands of Essbase customers. This session, which was the highest-rated (more...)
We have all been in the position of trying to find the name of a command in a language, particularly if you are not totally sure of the full command name.
I've been working with R a lot recently and in particular Oracle R Enterprise. I was always trying to remember what the full command name was. Then I found the apropos
function. The apropos function allows you to search R for commands based on (more...)
Oracle has released an update to their Oracle R Enterprise software. We now have ORE 1.4.1 and this seems to have been released on the past day or so.
Here are the links to the important stuff:
ORE 1.4.1 Release Note
ORE 1.4.1 User Guide
ORE 1.4.1 Installation Guide
ORE 1.4.1 Download page
One of the main features of this new release is that it (more...)