Sessions at Open Source Bridge 2011 about SQL and Databases

Tuesday 21st June 2011

• A Dozen Databases in 45 Minutes

  by Eric Redmond

  Choosing a data storage engine is an important decision, but it doesn’t have to be painful if you know the landscape. The decision should be made by research, not buzzwords. Authoring the book “Seven Databases in Seven Weeks” has opened up a whole world of open source database alternatives that I never before seriously considered - and we’ve sifted through them so you don’t have to. At the very least we can settle the Mongo v. Couch debate (hint: they’re both awesome).

  This talk will include:

  • A 30,000 foot view of the current database ecosystem.
  • How to choose the correct database for a project (the CAP theorem).
  • Thoughts by database project leaders.

  Among the DBMSs we’ll look into are: MySQL, PostgreSQL, Redis, Memcached, Riak, Cassandra, HBase, MongoDB, CouchDB, Neo4J, OrientDB, DB4o.

  • Databases
  • dbms
  • NoSQL
  • RDBMS
  • SQL

  At 2:30pm to 3:15pm, Tuesday 21st June

  Coverage note

Thursday 23rd June 2011

• King of the Data Jungle

  by Melissa Hollingsworth

  An experienced DBA who also happens to be a talking lion explains what normalization is, why it's a good idea, and how to do it. When his pupil complains about performance slowdowns, he goes on to explain about when, why, and how we should denormalize. There are slides as well as puppets.

  • Data
  • Databases
  • denormalization
  • Normalization
  • SQL

  At 3:45pm to 4:30pm, Thursday 23rd June

  Coverage note