Date: 2008-04-30 11:33 Subject: Supporting Scalable Online Statistical Processing Security: Public

Interesting Google tech talk: Supporting Scalable Online Statistical Processing.

Goes for an hour and has a slowish start but around the 10 minute mark the beef starts... basically, rather than doing complete aggregates, he uses statistical sampling to provide a reasonable estimate (unbiased guess) of the result.

This makes sense, statistically!
It might be possible to transplant his system into a MySQL storage engine, but it would need to be able to do in-engine joins, something that MySQL doesn't yet support.

(Thanks Ian for the link)

Post A Comment | Add to Memories | Tell a Friend | Link

Date: 2008-04-30 14:14 Subject: MySQL Developer and DBA training days in Melbourne Security: Public

I'm travelling to Melbourne in a few weeks, to teach another edition of some Open Query course days. Three days this time:

• Optimisation by Design
• Storage Engine Optimisation
• Replication Workshop

There are still some seats available; you can sign up for individual days, and there's very special pricing available for students! The Melbourne dates are 12-14 May (Monday-Wednesday). I'm doing on-site consulting later in the week.

Post A Comment | Add to Memories | Tell a Friend | Link