Concurrency Control in Relational Databases

Arjen Lentz, Community Relations Manager, MySQL AB

Track: Databases
Date: Thursday, July 27
Time: 5:20pm - 6:05pm
Location: Portland 252

In this session, we will delve into how modern relational database systems handle concurrency. A guided tour of the important features in different RDBMS is provided first, after which we should have sufficient ammunition to discuss the inevitable trade-offs that come with nearly every design aspect.

As the word "trade-off" already indicates, there is no single perfect way to do concurrency control -- so this won't be a "mine is better than yours" event. Naturally, MySQL will be covered, but also most other well known free/open source and proprietary relational database systems.

This session is aimed at people who are interested in learning (more) about how relational database systems do their magic. It may not be suitable for newbies, but you really don't have to be a hard-core hacker to dig this stuff. In fact, when using RDBMS it is a great asset to have sufficient understanding of this topic.

The objective is to gain a balanced perspective and the information required to pick the best tool for individual jobs.