Hotsos Symposium Speaker – Toon Koppelaars
Mr. Koppelaars is a prior Hotsos Symposium presenter.
Biography
Toon Koppelaars is a long-time Oracle technology user, having used the Oracle database and tools software since 1987 (Oracle version 4). During this time, he has been involved in both application development (terminal/host in the early days, GUI client/server later on, and J2EE nowadays), as well as database administration (including Parallel Server administration, the predecessor of Oracle-RAC).
Toon's special interest areas include: the Oracle optimizer (SQL tuning), technical application architectures (from a performance and maintainability perspective), and the specification and implementation of data integrity rules (aka business rules).
Together with Lex de Haan, he has co-authored "Applied Mathematics for Database Professionals" (Apress, June 2007).
In 2007, Mr. Koppelaars decided to go independent and founded his own company RuleGen B.V. (www.rulegen.com).
Presentation Title
Semantic Query Optimization
Abstract
In the past decade, we have seen Oracle's optimizer evolve from a rule-based to a cost-based optimizer. Cost based optimization is all about applying lots of useful statistics about the data that is being queried. Nowadays, the optimizer has various little known semantic query optimization features, too. Semantic query optimization is all about applying the knowledge of data integrity constraints about the data that is being queried. Constraints can be considered absolute statistics: statistics that are always true, versus only true when just gathered. With the advent of Oracle11G, the optimizer is further breaking ground in the area of semantic query optimization. In this presentation, we will explain the concept of semantic query optimization and show how the optimizer performs this type of optimization in 10G and 11G.
Presentation Materials
Presentation materials are available to attendees only. Attendees may find Mr. Koppelaar's presentation on the Hotsos portal. Attendees must use their portal ids rather than their email addresses to log in.
Schedule
The speaker schedule can be found at the following links:
