A couple of weeks ago during the madness of Oracle Open World there was some new product releases and lots of updates to existing products.
One such product was SQL Developer. They released an Early Adopter version (EA1). This is where you can try out the new version of the product, but you need to be careful as it is not the GA/Production version. So it may have some "features".
One component of SQL Developer (more...)
Over the past 12 months there has been an increase in the number of Machine Learning notebooks becoming available.
What is a Machine Learning notebook?
As the name implies it can be used to perform machine learning using one or more languages and allows you to organise your code, scripts and other details in one application.
The ML notebooks provide an interactive environment (sometimes browser based) that allows you to write, run, view results, share/collaborate (more...)
I was at Oracle Open World last week and have some notes to share on the upcoming EssCS (Essbase Cloud Service) product and on Essbase in general.
EssCS will be Infrastructure as a Service (IaaS) product and will be priced on the number of cores and memory. I believe there will be a metered and an unmetered pricing as well (metered meaning pay per cycle or some other usage measure). According to presentations at Open (more...)
This is the fourth blog post of a series on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. Make sure to check out the previous blog posts
as each one builds upon each other.
In this blog post, I will have an initial look at how you can use Oracle Text to perform document classification. In my next blog post, in the series, I will look at how you can use Oracle Data (more...)
Today 12th September (2016) is the official release date of my 3rd book.
The title of the books is 'Oracle R Enterprise'. Make sure to check it out on Amazon.
It has been a busy 17 months, as you may have noticed that I had another book released a few weeks ago. Check it out here.
Yes, I was working on two books at the same time.
Yes, that was a lot of work, and (more...)
In a previous blog post
I showed you how create and display a ggplot2 R graphic using SQL. Make sure to check it out before reading the rest of this blog post.
In my previous blog post
, I showed and mentioned that the PNG graphic returned by the embedded R execution SQL statement was not the same as what was produced if you created the graphic in an R session.
Here is the same (more...)
Do you want to display an image on a report in APEX ?
Is the image stored as a BLOB data type in your schema or the blob is returned by some functions?
If so, then displaying the BLOB is not a simple or straight forward task.
Actually it is a simple and straight forward task, as long as you know "the trick" you need to create/defined in your APEX report.
The following steps outlines what (more...)
This blog post will bring you through the steps of how to get Oracle R Enterprise (ORE) to work with APEX.
The reason for this blog posts is that since ORE 1.4+ the security model has changed for how you access and run in-database user defined R scripts using the ORE SQL API functions.
I have a series of blog posts going out on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. (more...)
It has been a busy 12 month. In addition to the day jobs, I've also been busy writing. (More news on this in a couple of weeks!)
Today is a major milestone as my second book is officially released and available in print and ebook formats.
The tile of the book is 'Real Word SQL and PL/SQL: Advice from the Experts'. Check it out on Amazon.
Now that sounds like a very fancy title, (more...)
I have always liked MDX as it exposes very powerful operations for creating member sets. It has this amazing ability to take a set of members, union it with another set of members, intersect it with yet another set of members, and then exclude members from yet another set. This is very
Recently, I was talking with a customer about some creative uses for MDX and they told me about some cool things they (more...)
This is the third blog post of a series on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. Check out the first and second blog posts of the series, as the data used in this blog post was extracted, processed and stored in a databases table.
This blog post is divided into 3 parts. The first part will build on what was covered in in the previous blog post and will expand (more...)
Recently we have been getting lots of traction on BICS , existing OBIEE customers been asking for BICS . In nutshell :
BI Cloud Service enables organisations of all sizes to quickly and cost effectively deploy business intelligence with the simplicity of the cloud..
Silent features of BICS :
- No need of software installation
- No need of software maintenance
- No upfront costs, low monthly subscription
- Customers can get started in hours
- 100% cloud based
- Robust reporting (more...)
This is the second blog post of a series on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. Check out the first blog post of the series, as the data used in this blog post was extracted, processed and stored in a databases table.
In this blog post I will show you how you use Oracle R Enterprise and the embedded R execution features of ORE to use the text from the (more...)
We know that we can perform outer joins in OBIEE in the Logical Layer. The problem with this mechanism is that it is not possible for one logical table sources (LTS) to join to a fact by an inner join and the other to join to the fact by an outer join. Let us (more...)
As many of you know, I have spent many years helping the Hyperion community in many ways. I have wrote this blog for quite some time, have taken on the OlapUnderground Utilities and provided free support through my company, In other words, I have worked hard to give back to the community and, in return, have had many kind words from people we have helped.
As a result of this spirit of giving back, I (more...)
Over the past few weeks or months (maybe even years) I've had several conversations with various people about why Data Science (or whatever you want to call it) projects fail or never really get started.
Before we go any further perhaps we need to define what 'fail' means in these conversations. Typically fail means that the project doesn't deliver what was hoped for, it got bogged down is some technical or political issues, it did (more...)
When working with SQL or PL/SQL we all know there are some words we cannot use in our code or to label various parts of it. These languages have a number of reserved words that form the language.
Somethings it can be a challenge to know what is or isn't a reserved word. Yes we can check the Oracle documentation for the SQL reserved words
and the PL/SQL reserved words
. There are other references and (more...)
With my recent role as CTO/Advisor with www.analytos.com, during most of my conversation with Analytics leaders within the company, all are concern over security. At a recent conversation with another entrepreneur friend, one of his solution was stalled due to SQL injection issue on the cloud ( a valid concern , but is it valid ?) .
During my recent startup sting, cloud Allergy word was coined, and it did make sense, because allergies do exist and (more...)
After 18 months of hard work, Applied OLAP is proud to announce the general availability of the Dodeca Spreadsheet Management System, version 7, and the all-new Dodeca Excel Add-In for Essbase.
The Dodeca Spreadsheet Management System provides customers the ability to automate spreadsheet functionality, reducing the risk of spreadsheet errors while increasing productivity. It combines unprecedented ease-of-use for business users using spreadsheets for planning, budgeting, forecasting, reporting and analysis tasks. It also provides a robust, (more...)