Sneak preview of demo for Oracle Code events

By -
I will be presenting at a number of the Oracle Code events over the coming months on the subject of…..(drum roll please) SQL pattern matching. Oracle Code is a great series of conferences dedicated to developers who want to get the absolute maximum benefit from using today's cutting edge technologies. If you want to register for any of the dates listed below then follow this link to the registration page.

North and Latin America

San Francisco
, 
March 1, 2017

Austin
, 
March 8, 2017

New York City
, 
March 21, 2017

Washington DC
, 
March 27, 2017

Toronto
, 
April 18, 2017

Atlanta
June 22, 2017

Sao Paulo
,
June 27, 2017

Mexico City
, 
June 29, 2017
Europe and Middle East

London
,
April 20, 2017

Berlin
,
April 24, 2017

Prague
,
April 28, 2017

Moscow
,
May 22, 2017

Brussels
,
June 6, 2017

Tel Aviv
,
July 11, 2017
Asia

New Delhi
,
May 10, 2017

Tokyo
,
May 18, 2017

Beijing
,
July 14, 2017

Sydney
,
July 18, 2017

Seoul
,
August 30, 2017

Bangalore
,
August 4, 2017

Back to my session...the actual topic of my session is: Simplified and fast fraud detection. The overall aim of this session is to demonstrate the key benefits of using SQL row pattern matching techniques compared to using other programming languages. As part of the presentation I will be using live demos to review a specific use related to fraud detection where I will walk through the MATCH_RECOGNIZE clause and explain the concepts and keywords. The demo will use a simple five step framework to construct pattern matching queries.

I will aim to show how easy it is to write and amend SQL-based pattern matching queries as requirements change and the slide deck includes a link to the video from OpenWorld 2015 where we showed a sophisticated fraud detection application that used pattern matching and spatial to create an analytical mash-up that processed a data stream in real-time.
If you would like a sneak preview of the presentation and the demo then follow these links:
If you are planning to attend any of the above events then please let me know as it would be great to meet up and talk about your experiences with analytic SQL and, especially, pattern matching. Email is the usual address keith.laker@oracle.com, or you can ping me on Twitter - @ASQLBarista.

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