Posts

Autonomous Data Warehouse is LIVE!

Image
That’s right: Autonomous Data Warehouse Cloud is LIVE and available in the Oracle Cloud.
ADWC Launch Event at Oracle Conference Center We had a major launch event on Thursday last week at the Oracle Conference center in Redwood Shores which got a huge amount of press coverage. Larry Ellison delivered the main keynote covering how our next-generation cloud service is built on the self-driving Oracle Autonomous Database technology which leverages machine learning to deliver unprecedented performance, reliability and ease of deployment for data warehouses.

As an autonomous cloud service, it eliminates error-prone manual management tasks and, most importantly for a lot readers of this blog, frees up DBA resources, which can now be applied to implementing more strategic business projects.

The key highlights of our Oracle Autonomous Data Warehouse Cloud include:

Ease of Use: Unlike traditional cloud services with complex, manual configurations that require a database expert to specify data d…

Demoing ADWC+OAC Querying Massive Data Volumes

Image
If you missed all the major announcements from OpenWorld 2017 about Oracle Autonomous Data Warehouse Cloud then take some time to review this blog post Review of Big Data Warehousing at OpenWorld 2017 - Now Available. Take a look a Chapter 2 - YOUR ORACLE DATA WAREHOUSE IN THE AUTONOMOUS CLOUD.Once you have fully digested the powerpoint presentations and videos included in Chapter 2 you will then be ready to watch this exciting new video:Below is an excerpt of Thomas Kurian’s Keynote session at Oracle Cloud World in Feb 2018. In this video, George Lumpkin, VP of Product Management, shows how easy it is to create an new data warehouse inside the Oracle Autonomous Data Warehouse Cloud, how fast and elastic it is and how quick and easy it is to integrate with other parts of Oracle's Cloud portfolio - in this case Oracle Analytics Cloud.This demo will take you from zero-to-dashboard in around 10 minutes! For the full-length video of Thomas Kurian's keynote at Oracle CloudWorld, Ne…

SQL Pattern Matching Deep Dive - the PDF Version

Image
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. The title of each blog post started with SQL Pattern Matching Deep Dive...and covered a set of 6 posts:

Part 1 - Overview
Part 2 - Using MATCH_NUMBER() and CLASSIFIER()
Part 3 - Greedy vs. reluctant quantifiers
Part 4 - Empty matches and unmatched rows?
Part 5 - SKIP TO where exactly?
Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. 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 and 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…

SQL Pattern Matching Deep Dive - the book

Image
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. The title of each blog post started with SQL Pattern Matching Deep Dive... and covered a set of 6 posts:


Part 1 - OverviewPart 2 - Using MATCH_NUMBER() and CLASSIFIER()Part 3 - Greedy vs. reluctant quantifiersPart 4 - Empty matches and unmatched rows?Part 5 - SKIP TO where exactly?Part 6 - State machines

There are a lot of related posts derived from that core set of 6 posts along with other presentations and code samples. 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 deve…

Review of Big Data Warehousing at OpenWorld 2017 - Now Available

Image
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. This review contains the following information:

Welcome - an overview of the contents.

Let’s Go Autonomous - containing all you need to know about Oracle’s new, fully-managed Autonomous Data Warehouse Cloud. This was the biggest announcement at OpenWorld so this chapter contains videos, presentations and podcasts to get you up to speed on this completely new data warehouse cloud service.

Keynotes - Relive OpenWorld 2017 by watching the most important highlights from this year’s OpenWor…

OpenWorld 2017: Must-See Sessions for Day 4 - Wednesday

Image
Day 4 is here which makes today #Autonomous Wednesday. Included my definitive list of Must-See sessions for today are two of THE most important sessions at this years conference. You will not want to miss these two sessions:



The rest of list is, of course, packed full of sessions and labs covering our Big Data Warehouse technologies and features. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts.
WEDNESDAY'S MUST-SEE GUIDE

Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday.

The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well.
Have a great conference.

If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this year.

Don't forget…

OpenWorld 2017: Must-See Sessions for Day 3 - Tuesday

Image
Day 3, Tuesday, is here and this is my definitive list of Must-See sessions for today.

Today we are focused on the new features in Oracle Database 18c - multitenant, in-memory, Oracle Text, machine learning, Big Data SQL etc etc. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts.
TUESDAY'S MUST-SEE GUIDE

Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursday.

The review will include links to download the presentations for each of my Must-See sessions and links to any hands-on lab content as well.
Have a great conference.

If you are here in San Francisco then enjoy the conference - it's going to be an awesome conference this year.

Don't forget to make use of our Big DW #oow17 smartphone app which you can access by pointing your phone at this QR code: