Presentation Title: Meet Your Match: Advanced Row Pattern Matching
Speaker: Mr Stew Ashton UKOUG Speaker Award Winner
Company: Independent
Presentation abstract: By taking full advantage of the new Row Pattern Matching functionality in Oracle Database 12c, you can quickly solve new problems - and old problems in much more efficient and scalable ways.

This session will present general-purpose techniques for bin fitting problems, hierarchical summaries, temporal validity queries and joining or summarizing data by ranges. By decreasing CPU use, these techniques run 50 to 500 times faster than existing solutions, with or without Exadata or the In-Memory option.

The pattern matching features of the most recent version will be presented.

This session is geared primarily to SQL practitioners who are willing to unleash the full power of SQL in the Oracle database. They will learn how to apply row pattern matching concepts to different categories of problems, and will observe these concepts applied to typical situations using repeatable techniques.

Presentation begins: 04/12/2016 16:10
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Product User
Speaker biography:  Stew is one of the top SQL developers in the Oracle community, to which he has contributed for a decade through the AskTom site, the OTN forum dedicated to SQL and PL/SQL, and his blog. He was “Best New Overseas Speaker” at Tech 14 and OTN “Devvy Award” finalist in 2015. Stew has been a developer and application architect for 35 years, working in mainframe, client-server and web architectures. For the last ten years at BNP Paribas, he has focused on proper use of the Oracle database in OLTP applications and batch processing,improving application performance up to 300-fold. His blog features in-depth series on such topics as comparing and synchronizing tables, handling date ranges and the MATCH_RECOGNIZE clause.
Related topics: APEX & Database Development: Performance , APEX & Database Development: SQL , APEX & Database Development: Upgrades/New Feature
Hall: Executive Room 8

Advanced_Row_Pattern_Matching.pptx3.0 MB10/12/2016 23:11:57