Pages

Saturday, December 26, 2009

Presenting at Vancouver PASS in January


I've weaseled my way to bore the pants off another session of the Vancouver PASS chapter's monthly meetings.  Sooner or later, the chapter leader Richard Baumet (Blog|Twitter) will catch on to the fact that nobody wants to hear me wax lyrical on Business Intelligence junk, and he'll politely decline next time I ask. 
All kidding aside, I'll try and make it worth your time!  The January topic is data warehousing - but with a "regular DBA" angle.  I hope to start a discussion about what makes a Data Warehouse database different from a "regular" OLTP database.  I'm going to put forward some reasons why it's OK to violate just about everything you've had hammered into you about normalization and other relational design best practices.  If you happened to make it to my talk at Vancouver TechFest, I did start to lay out some of the differences about halfway in to the presentation (recorded here) - but I skimmed the surface.
If you want to know why normalization isn't a good practice with a data warehouse database, why it's absolutely acceptable to have a dimension table with wide character columns and redundant data, and why we're really only interested in optimizing for read performance, you'll want to drop by.  I also hope to let you know what SQL Server Analysis Services brings to the party, and a little on how you can monitor your relational and SSAS databases to detect and optimize queries.  If we have time, I'll talk a little about the column-oriented database technology that Donald Farmer touched on at last month's meeting, and Dr. Dewitt talked about at the PASS Summit.
Hope to see you there on January 21st at the Sierra Systems building, 25th floor at 5:30pm!

No comments:

Post a Comment