Export to

• Google Calendar
• iCalendar file
• hCalendar markup
  <div class="vevent h-event"> <h1 class="summary p-name">Portland Perl Mongers: Relational DB vs Key-Value Store and Beyond</h1> <div class='date'><time class="dtstart dt-start" title="2010-08-11T18:53:00" datetime="2010-08-11T18:53:00">Wednesday, August 11, 2010 from 6:53</time>–<time class="dtend dt-end" title="2010-08-11T21:00:00" datetime="2010-08-11T21:00:00">9pm</time></div> <div class="location vcard p-location h-card"> <a class="url" href='http://calagator.org/venues/202389965'><span class='fn org p-name'>Free Geek</span></a> <div class="adr p-adr h-adr"> <div class="street-address p-street-address">1731 SE 10th Avenue</div> <span class="locality p-locality">Portland</span> , <span class="region p-region">OR</span> <span class="postal-code p-postal-code">97214</span> <div class="country-name p-country-name">US</div> (<a href='https://maps.google.com/maps?q=1731%20SE%2010th%20Avenue,%20Portland%20OR%2097214%20US'>map</a>) </div> </div> <div class="description p-description"> <p>Panel: Selena Deckelmann, Igal Koshevoy, Jeff Lavallee, David Wheeler</p> <p>This will be a panel discussion about the ups, downs, ins, and outs of relational, row, key-value, and hierarchical data stores (simplistic buzzwordiness: SQL vs NOSQL aka ACID CRUD.)</p> <p>The panel will discuss parallelism, scale, data integrity, normalization, business logic, ORMs, and performance. Some of the following might be addressed:</p> <ul> <li>why do you want a relational DB?</li> <li>why do you not want a relational DB?</li> <li>Membase, MongoDB, Redis, Cassandra</li> <li>Tokyo Tyrant, CouchDB, old school K/V (zodb, bdb)</li> <li>distinctions between "relational" and "row store"</li> <li>how filesystem settings affect the database</li> <li>how important is your data?</li> <li>common errors in SQL schemas or usage</li> <li>is count(*) supposed to be fast?</li> <li>efficiency vs speed vs parallel cleverness</li> <li>sharding</li> <li>what is "scale" and do you need it?</li> <li>massively denormalized, or massively normalized?</li> <li>ORMs, materialized views, indexes, and the query planner</li> <li>typical performance with small/large, simple/complex data sets</li> </ul> <p>As always, the meeting will be followed by social hour at the Lucky Lab.</p> </div> <h3>Links</h3> <ul> <li><a class="url u-url" href="http://pdx.pm.org/">Website</a></li> </ul> </div>