Post is pinned.Post has attachment
It's #Autonomous Wednesday @ Oracle OpenWorld 2017

Step-by-Step Guide to Oracle Autonomous Data Warehouse Cloud
Wednesday, Oct 04, 12:00 p.m. - 12:45 p.m. | Moscone West - Room 3010

If you are attending #OOW17 then here's your chance to Join Yasin Baskan, Senior Principal Product Manager at Oracle, run a full live step-by-step demo of Oracle's new Autonomous Data Warehouse Cloud.

This is a great opportunity to learn more and ask question. Reserve your seat right now by adding this session to your OpenWorld calendar

Post has attachment
SQL Pattern Matching Deep Dive - the book

Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a deep dive presentation that I prepared for the BIWA User Group Conference.

One of the challenges, even when searching via Google, was tracking down all the relevant content.

Therefore, I have spent the last 6-9 months converting all my deep dive content into a book - an Apple iBook. I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer SQL forum, discussions with my development team and some new presentations developed for the OracleCode series events.

More information is available here:

Post has attachment
Review of Big Data Warehousing at OpenWorld 2017 - Now Available

Did you miss OpenWorld 2017? Then my latest book is definitely something you will want to download! If you went to OpenWorld this book is also for you because it covers all the most important big data warehousing messages and sessions during the five days of OpenWorld.

Following on from OpenWorld 2017 I have put together a comprehensive review of all the big data warehousing content from OpenWorld 2017. This includes all the key sessions and announcements from this year's Oracle OpenWorld conference. Follow this link for more information about how to download this review:


Post has attachment
* 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.

Post has attachment
MATCH_RECOGNIZE and predicates - everything you need to know

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...

Post has attachment
Big Data Warehousing Must See Guide for Oracle OpenWorld 2017

The free big data warehousing Must-See guide for OpenWorld 2017 is now available for download from the Apple iBooks Store - 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. More information and links here:

Post has attachment
Connecting Apache Zeppelin to your Oracle Data Warehouse

Part two in my series of posts about using Apache Zeppelin - in this post I look at the process of installing, configuring and testing database connections. There are lots of screenshots to help explain the various key steps.

Post has attachment
Using Apache Zeppelin Notebooks with your Oracle Data Warehouse

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 data
- access to languages that help with data discovery and data analytics
- some basic data visualization tools
- a set of collaboration services for sharing notebooks (collections of reports)

Post has attachment
My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2. All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes?

So in this post I am going to focus on the new In-Memory “cursor duration” temporary table feature. Let’s start by looking at cursor duration temp tables…

Post has attachment
The latest in Oracle Partitioning - Part 1: Read Only Partitions

Now that Oracle Database 12c Release 2 is available on-premise for Linux x86-64, Solaris Sparc64, and Solaris x86-64 and on the Oracle Cloud for everybody else - the product we had the pleasure to develop and to play with for quite some time now - it's also time to introduce some of the new functionality in more detail to the broader audience.

This blog post will be the first of hopefully many over the course of the next months (time permits) to specifically highlight individual features of Oracle Partitioning and why we actually implemented it. A big thanks at this point to the user community out there...
Wait while more posts are being loaded