SQL for Data Warehousing and Analytics

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

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

In case you missed Wednesday's Oracle Database 12c launch webcast then the good news is that it is now available for on-demand replay. The live session was amazingly well attended and the questions posted by the participants were great. There were quite a few data warehousing questions posted and I think I managed to answer nearly all of them. If I missed your particular question then let me know and I will make sure you get an answer.   During the webcast Tom Kyte offered his "Top 12 features of Oracle Database 12c" and there were quite a few data warehousing features that made it on to his list: SQL analytics row_limiting/Top-n Pattern matching Partitioning enhancements Adaptive execution plans  You can watch the webcast right now by clicking on the image below, which will take you to the landing pad for the on-demand replay.  alternatively you can click here  to watch the webcast. FYI - there is a registration process but it is quite painless. Once you watc...

The OTN team has just posted a great video interview with Oracle ACE Director Gwen Shapira on YouTube. Gwen talks about integrating Hadoop with Oracle Database using Oracle's Loader for Hadoop and she gives her views on when to use Hadoop vs. when to use Oracle Database. If the embedded video above does not work for any reason then follow this link to the YouTube site: http://www.youtube.com/watch?v=tBpHAyTH6MU . One of the interesting points that Gwen makes during the interview is the superior performance (5X faster) offered by our Hadoop loader compared to the other open source data loading tools. The Oracle Loader for Hadoop is part Oracle's Big Data Connectors suite of software and this suite of tools supports a wide range of Oracle targets. These connectors are designed and optimized to integrate Apache Hadoop with specific Oracle products including Oracle Database, Oracle Endeca Information Discovery and Oracle Data Integrator. The suite of connectors includes the foll...

We have just published five new exciting videos about Big Data that will help you understand why big data is so important and why your organization needs big data. The last three videos in the series cover the key stages in a typical big data workflow: how to acquire, organize and analyze big data. You can view them all on YouTube using the following links: Overview for the Boss : http://youtu.be/ikJyrmKdJWc Hadoop : http://youtu.be/acWtid-OOWM Acquiring Big Data : http://youtu.be/TfuhuA_uaho Organizing Big Data : http://youtu.be/IC6jVRO2Hq4 Analyzing Big Data : http://youtu.be/2yf_jrBhz5w These videos are a great place to start learning about big data, the value it can bring to your organisation and how Oracle can help you start working with big data today. Big Data Episode 1: Overview for the Boss - The boss needs to present a big data strategy to the CEO. But what's it all about? And above all, what's the value to the business? Two team members give him… En...

Join us on 12th June in EMEA for our latest virtual Developer Day on Database 11g Application Development. This virtual event offers:  Hands-on ( for some tracks but not the data mining or big data tracks - sorry ) experience developing database-backed applications with innovative and performance-enhancing methods.  Chance to learn from Oracle database application development experts.  Get post-event benefits such as advanced lab content downloads.  Full details, including registration details, are here: https://oracle.6connex.com/portal/database2012/login/?langR=en_US&mcc=EMEAint There is a packed 4-track agenda and the event will cover the key tools, frameworks, techniques, and best practices for building database-backed applications, information on how to get the best from Oracle's Advanced Analytics option and an overview of Oracle's Big Data technologies. Included as part of the database track is a session on Oracle Data Mining starting at 11:30am BST.  There ...

An important date for your 2012 calendar : January 12 2012, at 12:00PM ET Join David Segleau , Director of Product Management at Oracle , and an expert on NoSQL. David will discuss the spectrum of big data solutions, and then focus on two common technologies for capturing and storing big data: Hadoop Distributed File System and Oracle NoSQL Database. He will discuss the approach and strengths of each application, and provide use cases for when to use each one. The presentation concludes by summarizing how to transform and filter data as needed, loading it into an Oracle data warehouse for the deep analytics needed to generate new insight. In this webcast you will learn about: - Oracle's big data solutions Different big data use cases with technology recommendations The strengths of both Oracle NoSQL Database and Hadoop Distributed file system To register for the webcast go here: http://www.information-management.com/web_seminars/-10021607-1.html