I am a big fan of Vincent McBurney. Today I was reading this post.

I agree completely with his view on Denormalization. (Scroll to the bottom of the article).

At times, I have had difficulties in recalling if normalization is splitting or joining. And it does make a lot more sense to just call them ’split’ and ‘merge’ instead of ‘normalize’ and ‘denormalize’.

Just another instance where plain common sense could have been helped everyone.

In the last few days I have been particularly keen on knowing (just knowing.. not exploring in detail) the capabilities of SAP BW to develop an Enterprise Data Warehouse (EDW).

And this link was pretty useful.

As of now, I really don’t have a clear understanding of SAP BW. But I understand that it is

1. proprietary.
2. not that great with non-SAP environments.
3. expensive.
4. not flexible enough.

If you know more about the capabilities of SAP BW to develop an EDW, please do let me know.