Posts

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:

OpenWorld 2017: Must-See Sessions for Day 2 - Monday

Image
Day 2, Monday, is here and this is my definitive list of Must-See sessions for today. The list is packed full of sessions and labs that follow on from yesterday's (Sunday) big announcements around Oracle Autonomous Database and Oracle Autonomous Data Warehouse Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn about the latest technology from the real technical experts.MONDAY'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 …

OpenWorld 2017 - Must-See Sessions for Day 1 - Sunday

Image
It all starts today -  OpenWorld 2017. Each day I will provide you with a list of must-see sessions and hands-on labs. This is going to be one of the most exciting OpenWorlds ever!

Today is Day 1 so here here is my definitive list of Must-See sessions for the opening day. The list is packed full of really excellent speakers such as Franck PachotAmi AharonovichGalo Balda and Rich Niemiec. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts.

Of course you need to end your first day in Moscone North Hall D for Larry Ellison's welcome keynote - it's going to be a  great one!
SUNDAY'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.H…

#oow17 BDW Smartphone App Now Live

Image
It’s only 4 days and counting until OpenWorld 2017 starts.

If you are coming to this year’s conference then you will definitely want to use our completely free #oow17 online BDW app for smartphones and tablets which is now livehttps://keithlaker.github.io/Storyboard.html#LandingPad.

The app includes a day-by-day calendar of all the most important sessions covered in the comprehensive Big Data Warehousing Must-See Guide, see here: https://oracle-big-data.blogspot.co.uk/2017/08/updated-big-data-warehousing-must-see.html.

The day-by-day coverage breaks sessions down into 5 categories:
Data Warehousing and CloudAnalytics and Machine LearningUnstructured and developmentBig DataHands-on labs each session is color coded to the above topics making it easier to focus on the areas that are most important to you. Please send my any feedback. Hope the app is useful and enjoy OpenWorld 2017: Your Data Warehouse Transformation Starts Here.


Landing page which includes video for #oow17Main page app w…