Spark is an open source Apache project that provides a framework for multi stage in-memory analytics. Spark is based on the Hadoop platform and can interface with Cassandra OpenStack Swift, Amazon S3, Kudu and HDFS. Spark comes with a suite of analytic and machine learning algorithm allowing you to perform a wide variety of analytics on you distribute Hadoop platform. This allows you to generate data insights, data enrichment and data aggregations for storage on (more...)
The following is the fifth and final set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
The following examples illustrate how you can use the Oracle R Enterprise capabilities within SQL and PL/SQL. The following illustrate building a GLM (more...)
The following notes and documents are for the BIWA Summit 2016 attendees who are taking the HOL on using ODM using SQL and PL/SQL.
Getting connected to the Cloud
The following document outlines the steps you need to perform to get connected to the Cloud Database we are using.
If you have attended the HOL (yesterday) then you can reuse the same connection details (and number).
If you didn't attend the HOL yesterday then you (more...)
The annual BIWA Summit 2016 will be next week from the 26-28 January, and it is back in Oracle HQ at Redwood Shores. If you are into the Oracle Database, Business Intelligence, Big Data, Advanced Analytics, etc then this is the conference for you.
Over the 3 days there is an action packed agenda of 5 parallel tracks, plus a full 3 days of Hands-on Labs. The agenda is filled with the whos-who of the (more...)
The following is the fourth set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
The following code example illustrate how you can build a Data Mining model using the in-database data mining algorithms. In this example a Decision Tree (more...)
The following is the third set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
The following code is illustrates some simple examples of using Oracle R Enterprise. In these example you will see how to connect to the Oracle (more...)
In the last week or so, we placed an updated version of the Next Generation Outline Extractor on our website. This version provides support for some updated Essbase versions, including 188.8.131.52.002, 184.108.40.206.003, and 220.127.116.11.005. More importantly, it addresses a bug where alias names were improperly associated with parent members when using the MaxL extraction source.. This bug was reported to us by a (more...)
The following is the second set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
The following code gives a very quick demonstration of using the RORACLE R package to access the data in your Oracle schema. ROracle has a (more...)
In a previous blog post I posted a video on using R with the Oracle Database and using Oracle R Enterprise. This is a part 1 extension of that blog post that gives the first set of demo code.
This first set of demonstration code is for using RJDBC to connect to the Oracle Database. Using RJDBC relies on using the JDBC jar file for Oracle. It is easily found in various installations of Oracle (more...)
The Oracle Santa had a busy time just before Christmas with the release of several new version of products. One of these was Oracle R Enterprise version 1.5.
Oracle R Enterprise (1.5) is part of the Oracle Advanced Analytics option for the enterprise edition of the Oracle Database.
As with every new release of a product there are a range of bug fixes. But with ORE 1.5 there are also some important (more...)
Earlier this year I was asked by the Business Analysics & Big Data SIG (of the UKOUG) to give a presentation on Oracle R Enterprise. Unfortunately I had already committed to giving the same presentation at the OUG Norway conference on the same day.
But then they asked me if I could record a video of the presentation and they would show it at the SIG. The following video is what I recorded.
At the (more...)
This Business Intelligence article discusses one very important question “Have we lost the true meaning and purpose of Business Intelligence?”
In summary, it says that the bottom line for any Business Intelligence is to increase profit and performance and if done wrong it is absolute waste of time and money.
So if your management is hooked on the Big-Data wagon and fantasizing about the hidden gold behind the untapped data sources such as social (more...)
Ever wondered, how may startups or companies did Google acquire so far and how much did it pay for them?
But the main question is, what happened to the acquired companies? Was it all waste of money?
With the recent re-structuring, Google became a subsidiary of Alphabet Inc., which now owns most of the parts.
In this analysis, we will visualize the relation between the Age at Presidency, State of Birth and birth sign.
This example will use a simple table structure in SQL Server though the concepts are the same when using Oracle, DB2, and most other relational databases. The example will use a simple Dodeca (more...)
Part 1 of 3
"I'm smart; you're dumb. I'm big; you're small. I'm right; you're wrong. And there's nothing you can do about it."
Thus spake Harry Wormwood in the movie "Matilda". This well could be the message that robots will have for us in the not too distant future. The dramatic improvements in the speed, the (more...)
The hourly rate in any consulting business or practice increases by the years of experience in the field.
Bigfoot and UFO remain elusive but know their ways to make news from time to time.
Olive Garden is one of the favorite destination for Italian food and today we got hold of the entire Olive Garden menu along with their nutrition data.
A typical meal at Olive Garden starts with a drink, appetizers [free bread sticks], main dish and finally the desert.
So going in the same sequence let see what the data menu for Wine and Beer has to offer.
Amount of Carbs per serving in your favorite Wine (more...)