my recent reads..

Cloud Computing - Why IT Matters

I caught Simon Wardley's presentation from OSCON on the IT Conversations Network; you can see in video below. He's an engaging speaker, and I think his characterisation of Cloud Computing as nothing less than a cultural transformation akin to the Industrial Revolution is spot on.



Soundtrack for this post? Mr Blue Sky
read more and comment..

Joshua Bell and Kristin Chenoweth performing "My Funny Valentine"

Happenchanced upon this fantastic performance on Channel V the other day. Joshua Bell and Kristin Chenoweth. I'm way impressed by Kristin's vocals, especially the way she manages the transitions. So deliciously smooth when most other singers would break. Perfectly matched by Joshua's playing.


read more and comment..

Casuarina Curry

Google Street View is pretty amazing. Here's my favourite prata place. Local and also one of the best in Singapore;-)

View It's a Prata Map in a larger map

Soundtrack for this post? Eat 'Em and Smile - David Lee Roth
read more and comment..

ActiveWarehouse/ETL and Reflections on BI for Rails

I've recently been considering the opportunity to apply Ruby and Rails goodness to mainstream Business Intelligence applications.

During my research into prior art I discovered Anthony Eden's ActiveWarehouse and ActiveWarehouse-ETL projects, and gave them a test drive using a fictitious "Cupcakes Inc" site.

I presented this at the Jan 2010 Singapore Ruby Brigade meetup held at hackerspace.sg. My "point-of-view" slides are embedded below, and you can find the sample project and doco on github.

Conclusions?

  • ActiveWarehouse is a textbook implementation of classic data warehousing techniques. That was clearly Anthony's intention, but it also means it does not really attempt to explore how data warehousing might be approached quite differently with Ruby and Rails

  • ActiveWarehouse/ETL are not for the faint-hearted. When you get them working, they works well, but the lack of documentation basically means it's inevitable you'll end up reading the sources to figure it all out

  • I have concerns about scalability. Having worked on terabyte warehouses using "classic" technology, I know just how far you push databases in order to scale. This bears more investigation and testing before it would be sensible to commit to ActiveWarehouse for a large-scale DWH implementation

Nevertheless, ActiveWarehouse and ActiveWarehouse-ETL are interesting projects, and the underlying implementations make for some educational code reading. Hopefully my slides and the Cupcakes sample project will add a bit to the available documentation, and give a bit of a leg up to anyone intersted in checking out these projects;-)


Soundtrack for this post: Information Overload- Living Color
read more and comment..