April 2008 - Posts

Multiple Hierarchies from SQLCAT

I'm still late with blog reading and sometimes I discover interesting things one or two months later than the original posting. I just read the SQLCAT analysis of the several solutions available to handle multiple parent-child hierarchies within a single dimension. The multiple hierarchies pattern described in my many-to-many paper has been used (with some variations) and now I have the "SQLCAT certification" that this model is faster than others!

I think there is space for improvement in this area and the many-to-many space is still a relatively unexplored space. If you have experience adopting those models, please share your knowledge - and if you are shy, write me directly and I'll post the interesting data.



Cross-posted from SQLBlog! - http://www.sqlblog.com

posted Monday, April 21, 2008 7:52 PM by marcorusso with 0 Comments

Many-to-Many Session at European PASS Conference 2008

I'll be a speaker at the European PASS Conference 2008 next week in Dusseldorf. I will talk about advanced dimensional modeling using many-to-many relationship. The content is based on "The many-to-many revolution" paper I wrote two years ago. If you will attend that conference and you already used some of the models I described in the paper, I will be happy to get direct feedback from you.

My session is scheduled on Wednesday at 14:30. Unfortunately, I will not have much time after the session because I will have to go to the airport - for this reason, contact me in advance if you want, I'll be at the conference starting from Monday.



Cross-posted from SQLBlog! - http://www.sqlblog.com

posted Friday, April 11, 2008 11:50 AM by marcorusso with 0 Comments