MySQL Con: Data Warehousing With MySQL

Email.Email weblog link
Blog this.Blog this

Derek J. Balling
Apr. 18, 2005 10:12 PM

Atom feed for this author. RSS 1.0 feed for this author. RSS 2.0 feed for this author.


This afternoon, I attended John Paul Ashenfelter's Data Warehousing With MySQL talk at the MySQL Users Conference.

I was trying to come up with some way of saying how completely and totally useful it was to me. After all, I realized after sitting there for the afternoon why I'd been struggling with my own implementation of a data warehouse at my workplace. I saw what he was defining as "classic mistakes" as being synonymous with "things I had just implemented".

I struggled for a while until I read John Adams' post about the talk (as given at a previous conference), and realized that John had said nearly everything I wanted to say, but done so much more eloquently than I could have.

While the talk was centered on MySQL, in reality it had much more to do with data warehousing in general (and I firmly beleive that an Oracle or SQL Server DBA in attendance would have gotten as much out of the session as all of us MySQL users did). It was, by and large, agnostic to the database being used, and more about the design and mindset behind the data warehouse itself.

I feel like I want to rush home now, tell my marketing guy to stop using the existing warehouse implementation while I completely gut it and start from scratch with something that he'll be a lot happier with.

Derek J. Balling has been a Perl programmer and UNIX/Linux system administrator since 1996 and is currently employed as the Data Center Manager for