Sessions at Open Source Bridge 2011 about SQL

Your current filters are…

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.

    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.

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

    Coverage note