Feb 26, 2010, 11:41 by ijansch
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 (Feb 26, 2010 at 09: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: http://joind.in/1451
Track(s): Sidetrack 1
Slides: RDBMS in the social networks age
Comments
Feb 26, 2010, 12:03 by dmi
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
Feb 26, 2010, 12:13 by pbowyer
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.
Feb 26, 2010, 12:39 by lornajane
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 :)
Feb 26, 2010, 12:43 by jaspertandy
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.
Feb 26, 2010, 16:51 by Shrikeh
Very in-depth, bordering on head-exploding, but essential for the advanced developer.
Feb 27, 2010, 14:29 by rjharrison
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.
Feb 28, 2010, 18:09 by Anonymous
I really got a lot out of the talk - the best hour I think I've ever spent at a conference session.
Mar 1, 2010, 17:14 by kifranky
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.
Mar 2, 2010, 00:17 by Letssurf
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.
Mar 2, 2010, 14:56 by Anonymous
Interesting talk, some of the SQL in the slides was daunting at first. Had to pay close attention otherwise it'd be too easy to slip behind. Would have been better if more time was allocated to relax the pace slightly and have a longer Q&A session. Thanks for the slides.
Was disappointed to see these features haven't made it in MySQL.
Mar 18, 2010, 20:27 by Anonymous
Very interesting talk which only made me feel sad we are a MySQL shop! And many thanks for answering my question on performance and how expensive this sort of work is.
Feb 26, 2010, 11:40 by akrabat
Interesting topic that was well presented. I learned new things to apply to my work.