A technical deep dive into pattern matching using MATCH_RECOGNIZE
Track
Business Intelligence & Analytics
Datum i vrijeme
srijeda, 19. listopad 2016., 11:00
Dvorana
Dvorana C
Trajanje
45'
This session will explore the new Database 12c SQL Pattern Matching feature. This is a very powerful feature, which can used to solve a wide variety of business and technical problems. Using a live demo we will look at how to solve typical pattern matching business problems that can be solved very efficiently using MATCH_RECOGNIZE. To help you understand the basic mechanics of the MATCH_RECOGNIZE clause the demo will look at the new MATCH_RECOGNIZE related keywords in the explain plan such as DETERMINISTIC, FINITE and AUTO. We will explore the key concepts of deterministic vs. non-deterministic state machines, greedy vs. reluctant quantifiers and how to use the built-in debugging measures. Finally, we will review typical issues such as back-tracking.
Detalji o predavanju
O predavaču
Keith Laker, autor
Data Warehouse 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.
Najbolji pokrovitelj
Bolji pokrovitelj
Dobar pokrovitelj
Edukacijski pokrovitelj
Medijski pokrovitelj
HrOUG.hr
Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.