Posts

UPDATED: Big Data Warehousing Must See Guide for Oracle OpenWorld 2017

Image
** NEW ** Chapter 5


*** UPDATED *** Must-See Guide now available as PDF and via Apple iBooks Store This updated version now contains details of all the most important hands-on labs AND a day-by-day calendar. This means that our comprehensive guide now covers absolutely everything you need to know about this year’s Oracle OpenWorld conference. Now, when you arrive at Moscone Conference Center you are ready to get the absolute most out of this amazing conference.

The updated, and still completely free, big data warehousing Must-See guide for OpenWorld 2017 is now available for download from the Apple iBooks Store - click hereand in PDF format - click here.

Just so you know…this guide contains the following information:

Page 8 -
On-Demand VideosPage 11 - Justify
Your tripPage 18 - Key
PresentersPage 39 - Must See
SessionsPage 83 - Must See
Day-by-DayPage 150 -
Useful MapsChapter 1 - Introduction to the must-see guide. Chapter 2 - A guide to the key the highlights from last year’s confe…

Sneak preview of BDW OpenWorld smartphone app...

DW and Big Data - OpenWorld 2017a YOUR DATA WAREHOUSE TRANSFORMATION STARTS TODAY 456 October 1–5, 2017 San Francisco, CA #OOW17 Continue... 114 240

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 to atte…

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 enjoy th…

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…