Introduction to solving SQL problems with MATCH_RECOGNIZE

Oracle Database 12c provides a completely new native SQL syntax that allows you to implement a core set of rules to define patterns in sequences (streams of rows).

This presentation will provide a detailed review of the new keywords that make up the new MATCH_RECOGNIZE clause. It will layout a simple four step approach to writing pattern matching queries based around the main key words. A live demonstration will show how easy it is to write and amend MATCH_RECOGNIZE statements.

At the end of this session you should be able to:

- Understand how to use the MATCH_RECOGNIZE clause
- Have a good understanding of the main keywords
- Understand how SQL pattern matching can solve common business and technical problems
- Compare and contrast existing pre-12c SQL code with MATCH_RECOGNIZE statements

Dienstag, 30.05.2017
16:15 - 17:00
Amsterdam 3
Einsteiger
English
Datenbank Betrieb
Demo
Laker
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. Almost 20 years with Oracle, Keith is now part of Data Warehouse Product Management team where he works on the analytic SQL features such as: window functions, SQL pattern matching, SQL Model clause and the new approximate query processing. He is the author of the data warehouse and analytical SQL blog, his Twitter handle is @BigRedDW and he presents at many Oracle conferences.

Weitere Vorträge, die Sie interessieren könnten