I currently have scheduled the following public appearances:
|2013-05-17||Hissarya (BG)||I will present two papers entitled “How the Query Optimizer Learns from ITs Mistakes” and “SQL New Features in the Latest Generation of Database Technology” at the Spring Conference of the BGOUG. The abstract is available below.|
- How the Query Optimizer Learns from ITs Mistakes: The aim of the query optimizer is not only to deliver the SQL engine execution plans that describe how to process data but also, and more importantly, to deliver efficient execution plans. Even though this central component of Oracle Database is enhanced with every new release, there are always cases where it makes mistakes. It is therefore critical that the query optimizer learns from these mistakes automatically. This is exactly what was introduced, starting with 11g, with feedback-based optimization. The aim of this presentation is to review and demonstrate the available features in this area.
- SQL New Features in the Latest Generation of Database Technology: As with any new Oracle Database release many new or enhanced functionalities are available. In this presentation we will focus on the key additions in SQL. Some are long awaited improvements, other are new concepts that open up completely new possibilities. The following features will be covered:
- Extended Data Types
- Better Default Values
- Session-Level Sequences
- Native Support for Top-N Queries
- Pattern Matching
- Define PL/SQL in the WITH clause
A list of past public appearances can be seen here.