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