Hotsos Symposium Speaker – Tom Kyte

Tom Kyte is a returning Hotsos Symposium presenter.

Biography

Tom KyteTom Kyte is a Senior Technical Architect in Oracle's Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

Presentation Titles

Session #1: All About Metadata; Why Telling the Database About Your Schema Matters
and
Session #2: Efficient PL/SQL - Why and How to Use PL/SQL to Its Greatest Effect

Abstracts

Session #1, All About Metadata; Why Telling the Database About Your Schema Matters: It is interesting to note how important metadata — data about data — is in the database. Database constraints make up one important part of metadata. The database uses constraints for query optimization as well as data integrity. Most people understand that constraints are a "data integrity feature", but are not as aware of the fact that the optimizer relies heavily on metadata to operate at its best. We'll explore the various types of metadata we as developers and DBA's can assert into the database and the positive impact this metadata will have on us.

Session #2, Efficient PL/SQL — Why and How to Use PL/SQL to Its Greatest Effect: PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. It was first introduced way back in version 6 of the database, giving us the ability to code "anonymous blocks" in our client applications and submit them for processing on the database. In Oracle6, there were no stored procedures, no packages, and no triggers. The ability to store PL/SQL in the database came with version 7 in 1992.

Today, PL/SQL is competent, mature, and full-featured, offering everything you expect to find in a 3GL programming language. In this session, we'll look at why you should be using PL/SQL in your applications and cover the most important programming techniques that provide efficient, high-performance PL/SQL code.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: