Database 12c MATCH_RECOGNIZE: Beating the Best Pre-12c Solutions

22 Jan 2018
14:00 - 14:45

Database 12c MATCH_RECOGNIZE: Beating the Best Pre-12c Solutions

Starting from common problems facing SQL developers, this session will show how the MATCH_RECOGNIZE clause provides more straightforward and efficient solutions than pre-12c methods such as analytics or the MODEL clause. Some of the problem areas covered are:

  • grouping sequences;
  • grouping based on intervals or running totals;
  • and bin fitting problems.

These real-life examples will illustrate both basic and advanced syntax, with a focus on regular expressions.

Attendees will learn how to think of common problems in terms of pattern matching; how to discern problem types that the MATCH_RECOGNIZE clause can help solve; and how to work around some limitations, including the major pitfall of regular expressions: catastrophic backtracking.