Posts

MATCH_RECOGNIZE and predicates - everything you need to know

Image
MATCH_RECOGNIZE and predicates At a recent user conference I had a question about when and how  predicates are applied when using MATCH_RECOGNIZE so that’s the purpose of this blog post. Will this post cover everything you will ever need to know for this topic? Probably!
Where to start….the first thing to remember is that the table listed in the FROM clause of your SELECT statement acts as the input into the MATCH_RECOGNIZE pattern matching process and this raises the question about how and where are predicates actually applied. I briefly touched on this topic in part 1 of my deep dive series on MATCH_RECOGNIZE: SQL Pattern Matching Deep Dive - Part 1.
In that first post I looked at the position of predicates within the explain plan and their impact on sorting. In this post I am going to use the built in measures (MATCH_NUMBER and CLASSIFIER) to show the impact of applying predicates to the results that are returned.
First, if you need a quick refresher course in how to use the MATCH…

PDF version - Big Data Warehousing Must See Guide for Oracle OpenWorld 2017

Image
….and now it’s here in PDF format as well!
The free big data warehousing Must-See guide for OpenWorld 2017 is now available for download in PDF format - click here, and yes it’s completely free. This comprehensive guide covers everything you need to know about this year’s Oracle OpenWorld conference so that when you arrive at Moscone Conference Center you are ready to get the most out of this amazing conference. The guide contains the following information:
Page 8 -
On-Demand VideosPage 17 - Justify
Your tripPage 19 - Key
PresentersPage 41 - Must See
SessionsPage 90 -
Useful MapsChapter 1 - Introduction to the must-see guide.
Chapter 2 - A guide to the key the highlights from last year’s conference so you can relive the experience or see what you missed. Catch the most important highlights from last year's OpenWorld conference with our on demand video service which covers all the major keynote sessions. Sit back and enjoy the highlights. The second section explains why you need t…

Big Data Warehousing Must See Guide for Oracle OpenWorld 2017

Image
It’s here - at last! I have just pushed my usual must-see guide to the Apple iBooks Store.
The free big data warehousing Must-See guide for OpenWorld 2017 is now available for download from the Apple iBooks Store - click here, and yes it’s completely free. This comprehensive guide covers everything you need to know about this year’s Oracle OpenWorld conference so that when you arrive at Moscone Conference Center you are ready to get the most out of this amazing conference. The guide contains the following information:

Page 8 -
On-Demand VideosPage 17 - Justify
Your tripPage 19 - Key
PresentersPage 41 - Must See
SessionsPage 90 -
Useful MapsChapter 1 - Introduction to the must-see guide. Chapter 2 - A guide to the key the highlights from last year’s conference so you can relive the experience or see what you missed. Catch the most important highlights from last year's OpenWorld conference with our on demand video service which covers all the major keynote sessions. Sit back and en…

Connecting Apache Zeppelin to your Oracle Data Warehouse

Image
In my last posts I provided an overview of the Apache Zeppelin open source project which is a new style of application called a “notebook”. These notebook applications typically runs within your browser so as an end user there is no desktop software to download and install.

Interestingly, I had a very quick response to this article asking about how to setup a connection within Zeppelin to an Oracle Database. Therefore, in this post I am going to look at how you can install the Zeppelin server and create a connection to your Oracle data warehouse.

This aim of this post is to walk you through the following topics:
Installing ZeppelinConfiguring ZeppelinWhat is an interpreterFinding and installing the Oracle JDBC driversSetting up a connection to an Oracle PDB Firstly a quick warning! There are a couple of different versions of Zeppelin available for download. At the moment I am primarily using version 0.6.2 which works really well. Currently, for some reason I am seeing performance probl…

Using Apache Zeppelin Notebooks with your Oracle Data Warehouse

Image
Over the past couple of weeks I have been looking at one of the Apache open source projects called Zeppelin. It’s a new style of application called a “notebook” which typically runs within your browser. The idea behind notebook-style applications like Zeppelin is to deliver an adhoc data-discovery tool - at least that is how I see it being used. Like most notebook-style applications, Zeppelin provides a number of useful data-discovery features such as:
a simple way to ingest dataaccess to languages that help with data discovery and data analyticssome basic data visualization toolsa set of collaboration services for sharing notebooks (collections of reports) Zeppelin is essentially a scripting environment for running ordinary SQL statements along with a lot of other languages such as Spark, Python, Hive, R etc. These are controlled by a feature called “interpreters” and there is a list of the latest interpreters available here.

A good example of a notebook-type of application is R Stud…