August2010Meeting

August2010Meeting

Wed. August 11th, 6:53pm at FreeGeek -- 1731 SE 10th Ave.

Relational DB vs Key-Value Store and Beyond

Speaker Panel: SelenaDeckelmann, IgalKoshevoy, JeffLavallee, DavidWheeler

This will be a panel discussion about the ups, downs, ins, and outs of relational, row, key-value, hierarchical, and distributed data stores (simplistic buzzwordiness: SQL vs NOSQL aka ACID CRUD.)

The panel will discuss parallelism, scale, data integrity, normalization, business logic, ORMs, and maybe flat files. They might take questions from the audience. Some of the following might be asked or answered:

• why do you want a relational DB?
• why do you not want a relational DB?
• Membase, MongoDB, Redis, Cassandra
• Tokyo Tyrant, CouchDB, old school K/V (zodb, bdb)
• distinctions between "relational" and "row store"
• how filesystem settings affect the database
• how important is your data?
• common errors in SQL schemas or usage
• is count(*) supposed to be fast?
• efficiency vs speed vs parallel cleverness
• sharding
• what is "scale" and do you need it?
• massively denormalized, or massively normalized?
• ORMs, materialized views, indexes, and the query planner
• typical performance with small/large, simple/complex data sets

As always, the meeting will be followed by social hour at the Lucky Lab.