New pattern matching tutorial on LiveSQL

By -

LiveSQL home page on livesql.oracle.com

If you always wanted to try our new SQL pattern matching feature, MATCH_RECOGNIZE, but never had access to a Database 12c instance then you really need to checkout the our great new LiveSQL playground environment. LiveSQL is a great place to learn about all the new features of Database 12c along with all the existing features from earlier releases.

The new tutorial is called “Log file sessionization analysis with MATCH_RECOGNIZE” and you can view by clicking here. This tutorial is designed to help show how you can run sessionization analysis on application logs, web logs, etc. Using a simplified table of click data you create a sessionization data set which tracks each session, the duration of the session and the number of clicks/events. It’s all fully annotated and there are links to supporting topics where you can get more information. The objective is to introduce you to some of the important keywords and concepts that are part of the MATCH_RECOGNIZE clause.

I have put together a quick video that shows how to access my new pattern matching tutorial so simply click on the image below to access the video:

 

LiveSQL video showing using new pattern matching tutorial

 

There are lots of code samples and tutorials for analytical SQL already loaded and available for you to run. Ever wanted to do a mortgage calculation using the SQL Model clause? Well Carsten Czarski, Oracle Database Developer guru, has created a great script that you can run to see how it works, just follow this link - https://livesql.oracle.com/apex/livesql/file/content_CA67VTHEVZZPYG94E5HWG6RWC.html

The AskTom team (Connor and Chris) have uploaded scripts that they have created in response to questions posted on the AskTom forum. For example, here is the AskTom answer for finding the min/max rows within price change groups: https://livesql.oracle.com/apex/livesql/file/content_CK3GKD93H9AE0MJ3QSAQUP97N.html.

I hope this is useful and don’t forget to share your own scripts and tutorials as this site is community driven, the more you upload the more we all learn.

Looking for more Information

Use the tag search to see more information about pattern matching or SQL Analytics or Database 12c.

Technorati Tags: , , , ,

Comments

Post a Comment

Popular posts from this blog

My query just got faster - brief introduction to 12.2 in-memory cursor duration temp tables

By -
Image
Image courtesy of wikipedia This post covers one of the new SQL performance enhancements that we incorporated into Database 12c Release 2 . All of these enhancements are completely automatic, i.e. transparent to the calling app/developer code/query. These features are enabled by default because who doesn’t want their queries running faster with zero code changes? So in this post I am going to focus on the new In-Memory “cursor duration” temporary table  feature. Let’s start by looking at cursor duration temp tables… Above image courtesy of wikimedia.org What is a cursor duration temp table? This is a feature that has been around for quite a long time. Cursor duration temporary tables (CDTs) are used to materialize intermediate results of a query to improve performance or to support complex multi step query execution. The following types of queries commonly use cursor duration temp tables: WITH Clause and parallel recursive WITH Grouping Sets Star Trans
Keep reading

Oracle OpenWorld - Highlights from Day 2

By -
Image
Data Warehouse and Big Data - Highlights from Oracle OpenWorld Day 2 Welcome to this online review of day two of Oracle OpenWorld 2012. Our aim is to keep you up to date on all the press reports, blog posts, analyst reports and related activities from this year's conference. Oracle: Big Business Has Big Data Woes (New York Times Interview) Business, the way you’re working will kill you. Storage costs, social media awareness, software application migration — they are all big problems. And, not surprisingly, Oracle is trying to address them. Last week I sat down with Mark V. Hurd, Oracle’s co-president, for a talk about Oracle’s strategy. Most of his conversation had to do with the problems facing big companies as they adapt to a world of mobile devices, cloud computing and
Keep reading

SQL Pattern Matching Deep Dive - Part 1

By -
Image
There has been quite a lot of interest in the new 12c MATCH_RECOGNIZE feature for SQL pattern matching. Therefore, I thought now would be the perfect time to start a series of quick deep dive posts that explain how SQL pattern matching works. Over the coming weeks I will cover the following topics in a series of posts. This is the start of a series of posts based on a presentation that I put together for the recent annual  BIWA conferenc e at Oracle HQ. The Oracle BI, DW and Analytics user community always puts on a great conference and this year was the best yet. You can download any or all of the presentations from this year’s conference by following this link . My pattern matching deep dive presentation started life about a year ago as a post covering some of the new keywords in the explain plan that are linked to pattern matching, see here . It has now expanded to cover a much wider range of topics. Firstly, a huge vote of thanks to my development team (Lei Sheng and Chun-Chie
Keep reading