| Summary: |
Throughout my career, I’ve seen more issues (functional, architectural, performance-related) with recursions than with any other development-related techniques. Keeping architecture out of the scope for now, the goal of this presentation is to create a comprehensive introduction to things that can be done recursively in the context of Oracle RDBMS.
The first half of the presentation is dedicated to recursive PL/SQL with the focus on exception handling (from my experience of working with developers, that’s the least understood area here) and variable management (another area where developers are not very clear about what is going on at every level).
The second half is covering SQL techniques – Oracle-specific CONNECT BY clause and Common Table Expressions (CTE). In addition to syntax intro the audience will see how CBO internally transforms recursive queries (that will help to understand query results) and how things like joins or complex conditions impact execution plans /corresponding efficiency (that will make developers be performance-conscious from the very beginning).
Recursions are not magical – they just have to be explained well enough to understand what is going on. This way developers wouldn’t be scared of this functionality and make good code faster and with less stress. |
| Biographical Sketch: |
Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of "PL/SQL for Dummies" (Wiley Press, 2006), "PL/SQL Performance Tuning Tips & Techniques" (Oracle Press, 2014), contributing author of "Expert PL/SQL Practices" (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc.), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award.
|
