SQL for Data Warehousing and Analytics

Here it is….. THE ultimate, comprehensive review for big data warehousing for #OOW18. This review is for everyone who either missed this year’s conference or just wants to relive the amazing experience all over again ( but focusing on just the best bits obviously! ). So here you go, my complete view nicely packaged and available free of charge in a number of different formats…           Following on from this year’s OpenWorld I have now put together the ultimate, comprehensive review for big data warehousing content from #OOW18. This free review contains the following information: Key video highlights from the main executive keynotes Overview of the announcements for Autonomous Database - contains the links you need to learn even more about how the Autonomous Database can simplify and speed up your big data warehousing projects! Full list of Oracle Product Management and Development presenters, links to all their social media sites are included alon...

  Here’s your absolutely Must-See agenda for Wednesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 3 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is two additional chances to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 12:45pm - 1:45pm and then again at 3:45pm - 4:45pm, both at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   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 com...

  Here’s your absolutely Must-See agenda for Tuesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 2 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is the chance to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 3:45 PM - 4:45 PM at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   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 Thursd...

Here’s your absolutely Must-See agenda for Monday at OpenWorld 2018... It all starts today -   OpenWorld 2018.  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 biggest and 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 from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn 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 ...

It’s  not long until the doors open at the Moscone Center in San Francisco for the biggest and most exciting tech conference in the calendar. Looking at the online content catalog it’s hard to know where to start because there are so many sessions and just not enough time! Which is here my Must-See Guide comes to the rescue. It lists all the most important data warehouse, big data, analytics, machine learning sessions and labs at #oow18 is now available as a comprehensive Day-by-Day version: My Day-by-Day guide for OpenWorld 2018 is available in both old-fashioned PDF format as a free download from here  and the more useful Apple Book format as a free download   from here   ( open this link in a browser and then click on the blue “View in iBooks” button below the cover-picture ). As usual, all feedback is welcome and if I have missed a session or a hands-on lab that you think should be included in this guide then send me a quick email with the details: keith.lak...

There are so many sessions at this year’s OpenWorld it’s hard to know where to start when trying to pick which sessions to attend! To help you get your personal calendar organized and totally focused on THE most important sessions here is my pick of the very best sessions and labs that you definitely won’t want to miss! Simply cut & paste the links below into your calendar app and then sit back and relax because all you need to do next is turn up at Moscone and enjoy the best tech conference ever :-) ...so if you have a calendar app on your computer then just use the iCal links to subscribe to my calendars. Your calendar app should allow you to color-code each calendar to make life easier and more colourful!   For data warehousing and cloud-focused sessions+labs use these links: iCal format: https://calendar.google.com/calendar/ical/31pd442io213d7n1o44rstlqno%40group.calendar.google.com/private-5fc5e75a3b08e9ab2f2f0a3a16b839ef/basic.ics Web page:  https:...

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

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 - an Apple iBook. I have added a lot of new content based discussions I have had at user conferences, questions posted on the developer ...

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 live :  https://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 Cloud Analytics and Machine Learning Unstructured and development Big Data Hands-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 wh...

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

  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 Videos Page 17 - Justify Your trip Page 19 - Key Presenters Page 41 - Must See Sessions Page 90 - Useful Maps Chapter 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 ...