Meet Your Match: Advanced Row Pattern Matching

23 Jan 2018
10:15 - 11:00

Meet Your Match: Advanced Row Pattern Matching

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 300 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.