A technical deep dive into pattern matching using MATCH_RECOGNIZE
Track
Business Intelligence & Analytics
Date and time
Wednesday, 19. October 2016., 11:00
Room
Hall C
Duration
45'
This session will explore the new Database 12c SQL Pattern Matching feature. This is a very powerful feature, which can used to solve a wide variety of business and technical problems. Using a live demo we will look at how to solve typical pattern matching business problems that can be solved very efficiently using MATCH_RECOGNIZE. To help you understand the basic mechanics of the MATCH_RECOGNIZE clause the demo will look at the new MATCH_RECOGNIZE related keywords in the explain plan such as DETERMINISTIC, FINITE and AUTO. We will explore the key concepts of deterministic vs. non-deterministic state machines, greedy vs. reluctant quantifiers and how to use the built-in debugging measures. Finally, we will review typical issues such as back-tracking.
Lecture details
About speaker
Keith Laker, author
Data Warehouse Product Manager for Analytic SQL with extensive experience of data warehouse and business intelligence market having worked in a variety of roles, including: post sales consultancy, customer support and product management. Worked in a number of locations across Europe and also in California at Oracle's HQ in Redwood Shores.
Best Sponsor
Better Sponsor
Good Sposor
University sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.