Posts

Showing posts from May, 2016

New pattern matching tutorial on LiveSQL

Image
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 t