SANE 2006 abstract

Tutorial W1PM

Time: Wednesday 17 May 2006 14:00 - 17:30 Location: Commissiekamer 3 / IAR

New Features of MySQL 5.0 and 5.1 In-depth

(Partitioning, Updateable Views, Triggers, Stored Procedures)

Abstract

Updateable Views, SQL standard stored procedures, and triggers have long been considered a basic requirement of an enterprise-ready DBMS. Now, MySQL 5.0 introduces support for these flagship features, as well as for a standard SQL-compliant INFORMATION_SCHEMA data dictionary, bringing the popular open-source DBMS several steps closer to matching all the capabilities of the competition.

MySQL 5.1 also introduces support for table partitioning.

In this tutorial, each of these features are discussed in-depth for syntax and functionality, with examples. Interesting for all users at intermediate and advanced levels, but particularly useful for existing MySQL users who may not be familiar with these features from other databases.

Topics not covered:

Other 5.0/5.1 features in depth, there is simply not enough time.

Who should attend:

Existing MySQL users who want to use the new MySQL 5.0/5.1 features.
Users of other RDBMS who are evaluating MySQL 5.0/5.1 for new projects.

Arjen Lentz
MySQL AB

Arjen Lentz (36) is originally from Amsterdam, The Netherlands. Together with his wife, baby daughter and black cat he resides in Kenmore (Brisbane), Australia.

Arjen initially started with programming, but has since branched out to blends initial geekness with more human interaction - like writing and training. He still dabbles with PHP and C in his abundant spare time. He has been working for MySQL AB since 2001, primarily as technical writer (docs) and trainer.

Arjen is currently MySQL AB's Community Relations Manager, a job which involves cool stuff like jet-lag, hanging out with MySQL users everywhere and drinking assorted beverages on company time. He is also the program chair for the MySQL Users Conference.

Last modified: Mon, 23 Jan 2006 22:36:51 +0100