20.May.2010 at 21:07 by Michael Loss
Great talk. Very, very informative. The book looks like a must have.
Models for Hierarchical Data with SQL and PHP
Bill Karwin (20.May.2010 at 15:45)
Talk at TEK·X (English - US)
Tree-like data relationships are common, but working with trees in SQL usually requires awkward recursive queries. This talk describes alternative solutions in SQL, including:
* Adjacency List
* Path Enumeration
* Nested Sets
* Closure Table
Code examples will show using these designs in PHP, and offer guidelines for choosing one design over another.
Quicklink: https://joind.in/1575
Who are you?
By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.
If the claim is approved you will be able to edit the information for this talk.
Are you sure?
Comments
22.May.2010 at 01:05 by Andrew C. Vernon
I went into the talk not knowing exactly what to expect. Somewhere during this talk, I realized, "Hey, this guy is addressing some of those really nasty SQL problems I was working on a couple of months ago, and that's probably a way better solution!" I'm really looking forward to re-reading the slides and putting them to good use.
A good presentation covering some really tough (and let's face it, *DRY*) technical content, but the high value and importance in this discussion kept me interested.
24.May.2010 at 00:16 by Goran Halusa
Bill's talk could have easily been dubbed, "Breadcrumbs Demystified"... but in reality, it was so much more. Bill has a gift in explaining things in a simple, down-to-earth way. A true leader in SQL... I highly recommend folks to catch him in action at a conference near (or not so near) you.
24.May.2010 at 17:49 by Matt Schraede
There's nothing like being presented a seemingly mind boggling tree and being shown almost simplistic and easily understood solutions to handling them in a relational database. I feel a little bit more time could have been spent breaking down some of the more ridiculous queries before visualizing what the query was actually doing, but that didn't affect the ability to understand what was going on.
I would love to see a longer tutorial version of this talk covering even more types of data structures rather than just trees.
20.May.2010 at 20:35 by James Bush
Complex and very enlightening.