26.Feb.2010 at 11:41 by Ivo Jansch
At times confusing because of the level of the talk, but great in depth modern SQL lesson.
RDBMS in the social networks age
Lorenzo Alberton (26.Feb.2010 at 10:30)
Talk at PHP UK Conference 2010 (English - UK)
Despite the NoSQL movement trying to flag traditional databases as a dying breed, the RDBMS keeps evolving and adding new powerful weapons to its arsenal. In this talk we'll explore Common Table Expressions (SQL-99) and how SQL handles recursion, breaking the bi-dimensional barriers and paving the way to more complex data structures like trees and graphs, and how we can replicate features from social networks and recommendation systems. We'll also have a look at window functions (SQL:2003) and the advanced reporting features they finally make possible.
Quicklink: https://joind.in/1451
Track(s): Sidetrack 1
Slides: RDBMS in the social networks age
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
26.Feb.2010 at 12:03 by Dave Ingram
Some interesting technologies described in the talk, and lots of food for thought. Also important that he mentioned and illustrated that they aren't always the best choice - sometimes simpler methods are more appropriate
26.Feb.2010 at 12:13 by Peter Bowyer
Please number your slides in future! This would help us to reference your slides in our notes (useful with the amount of info in your slides)
Having mentioned the NoSQL movement, some coverage of that would be useful - how they compare (can they compare?).
Some coverage of performance and would have been useful. Not extensive, but to say whether these examples are usable in the real world or academic examples.
26.Feb.2010 at 12:39 by Lorna Mitchell
Nice talk with very approachable coverage of some very heavyweight theory. I saw slide numbers but I think room layout meant someone missed them. I definitely learned some new things, thanks Lorenzo :)
26.Feb.2010 at 12:43 by Jasper Tandy
Awesome talk. Shame that my current db of choice doesn't appear to support a lot of this stuff. Time to check out postgresql, I think! Thanks for this talk, learned a lot of really useful stuff.
26.Feb.2010 at 16:51 by Barney Hanlon
Very in-depth, bordering on head-exploding, but essential for the advanced developer.
27.Feb.2010 at 14:29 by Richard Harrison
Loved it. Lorenzo's talk was a great mental workout.
I thought the presentation and slides were sympathetically crafted: highlighting the sections of SQL and keeping the formatting/layout consistent was a big help.
01.Mar.2010 at 17:14 by Franck Cassedanne
Next time, I will bring my shades as this talk was so brilliant. I even got a tan out of it ;-) Cheers! Really enjoyed it... not sure about how well the title suited this tho. Also, some may have been gutted that the examples didn't cover MySQL as such.
02.Mar.2010 at 00:17 by James Dempster
Subject matter was very interesting. Very in depth details given. Good presentation and good slides but felt rather rushed.
Saw lots of examples of things that where possible with some great ideas and methods.
Pretty disappointed to find that most I'd learnt wasn't available on MySQL :(
Would like to have seen more MySQL database stuff.
26.Feb.2010 at 11:40 by Rob Allen
Interesting topic that was well presented. I learned new things to apply to my work.