SQL for Data Warehousing and Analytics

Our BI team has added SQL pattern matching to their demo VM environment which is used by the sales teams and Oracle partners to demonstrate the capabilities of our BI system. There is a short demo on YouTube:  http://www.youtube.com/watch?v=rgwAgckaiTU  - "SampleApp V309 What's New Overview" which shows a SQL pattern matching dashboard in OBI EE. If you jump to point 1:50 this is where the pattern matching content starts and it runs for about 15-20seconds - obviously there is a lot of great content so do please watch the complete video . The data set in the demo is the publicly available flight information data which is commonly used with the R language demos. Technorati Tags: Big Data , Data Warehousing , Database 12c , Oracle , Oracle Database 12c , Pattern Matching , SQL Analytics

There's so much to learn at Oracle OpenWorld because it provides more educational and networking opportunities than any other conference dedicated to Oracle business and technology users. What to expect at OOW 2013 - We will be announcing a wide range of continuous innovations from query optimization and partitioning to advanced analytics, Oracle Exadata and more. All these features make Oracle Database the world's most popular database for data warehousing. Join Oracle experts as we dive deep into the latest generation of database innovations for analyzing enterprise data and diverse big data streams to derive real business value from your data warehouse. You will also learn data warehouse best practices and hear from customers consolidating business analysis onto a common scalable platform. Hands-on labs for both beginners and experts give you the chance to try some of these innovative data warehouse technologies first-hand. To help you get the most from this year's ev...

Each year I put together a guide to OpenWorld which lists all the data warehouse sessions, biographies for the product managers who are presenting, links to a "Data Warehousing @ OOW" calendar and links to all the related product pages on Oracle.com and OTN. This year's guide will be bigger and more informative than ever! It will only be available in Apple iBook format and it will provide a multi-media guide to this year's conference. While I am waiting for this year's schedule to be finalised I thought it would be useful to share with you my hand-picked list of the must-see sessions and hands-on labs for data warehousing. This is basically an extract (a  very small extract ) from the forthcoming iBook guide to data warehousing at OOW 2013. This brief session guide contains the following information: List of must-see data warehouse sessions List of hands-on labs Comprehensive presenter biographies     To make life easier for you I have prepared this infor...

We have just released a series of five short video interviews with George Lumpkin, Vice President of Product Management, on the new 12c features that related to big data and data warehousing. I am pleased to see the new SQL pattern matching capabilities get in mention in chapter 2 - a quick recap if you missed my recent blog posts SQL Pattern Matching introduces a new SQL syntax, along with optimized performance, for detecting patterns in a sequence of events stored in a database table. For example, one might want to look for trends in a stock price, or for suspicious behavior stored in activity log. With Oracle 12c, these queries can be expressed in a simple syntax, without requiring recursive joins or other complex SQL constructs. For more information on SQL pattern matching visit the home page on OTN (click here ). In the section on easier management, chapter 3, George discusses the new partitioning features that we have added to make general maintenance and information lifecycl...

I have put together an Apple iBook for our new SQL pattern matching feature. The book brings together the content from the recently published whitepaper, which is available via OTN , the recent series of three podcasts and a number of presentations covering pattern matching and the new MATCH_RECOGNIZE syntax. All the content you need to learn about this great new feature, bundled up in an Apple iBook that you can read anytime, anywhere on your iPad and iPad Mini. The best part is that you can watch the three recently published online podcasts on pattern matching ( Part 1 , Part 2 and Part 3 ) without the need for an internet connection because they bundled inside the iBook! The book has 5 chapters: Overview Introduction to pattern matching SQL pattern matching with MATCH_RECOGNIZE Customer use cases Conclusion You can download this new iBook by clicking here . This is a very large file (200MB) so, depending on your network connection, it may take some time to d...

Following on from last week's post " Oracle Database 12c Pattern Matching Podcasts - Part 2 " here is the last part of this three part series on the new SQL pattern matching feature. In this final podcast we review a series of uses cases and provide conceptual simplified SQL to solve these business requirements using the new SQL pattern matching functionality. These examples are taken from real-life requirements from customers in the financial services, retail, life sciences and telecommunications industries, although the scenarios are also applicable across many other industries. Click on the above image to launch the movie, if this for some reason this link does not work then copy & paste this url:  http://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:7828,2 Note - the format is .MOV which is compatible with Apple iTunes/QuickTime. You may need to install QuickTime and/or use Apple Safari browser to access the file. There is a ...

Following on from last week's post " Oracle Database 12c Pattern Matching Podcasts - Part 1 " here is the second part of this three part series on the new SQL pattern matching feature. There are four basic steps for building a MATCH_RECONGIZE clause: Define the partitions/buckets and ordering needed to identify the ‘stream of events’ you are analyzing Define the pattern of events and pattern variables identifying the individual events within the pattern Define measures: source data points, pattern data points and aggregates related to a pattern Determine how the output will be generated The following podcast provides an overview of the most important keywords within the MATCH_RECOGNIZE clause in the context of these four simple steps.  The podcast can be accessed by clicking on the image below: (click on the above image to launch the movie, if this for some reason this link does not work then copy & paste this url:  http://apex.oracle.com/pls/apex/f?p=4...