Presentation Title: Introduction to Solving SQL Problems With MATCH_RECOGNIZE
Speaker: Mr Keith Laker
Company: Oracle
Co-presenter: 
Presentation abstract: 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

Presentation begins: 04/12/2017 11:35
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Beginner/Exploratory
Audience function: Oracle, Partner, Product Expert, Product User
Speaker biography: 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 @ASQLBarista and he presents at many Oracle conferences. Website: http://www.oracle.com/technetwork/database/database-technologies/sql-analytics/overview/index.html Blog: http://oracle-big-data.blogspot.co.uk Facebook: https://www.facebook.com/BigRedDW/ Twitter: https://twitter.com/ASQLBarista LinkedIn: https://www.linkedin.com/in/klaker
Related topics: Database: 12c Database
Hall: Hall 9


FileSizeUploaded
Introduction_to_solving_SQL_problems_with_MATCH_RECOGNIZE.pdf7.2 MB07/12/2017 18:10:06


Top