Tuesday, January 20, 2015

Star(schema) Commander, Iteration 0

Because I am constantly writing queries against dimensionally modeled star-schemas, I decided to write a small app to make the process easier.  I thought I would approach it in an agile manner - incorporating small releases and focussing on delivered value.

I also thought it might be interesting to post my experiences mainly to help keep myself on task.  My goal is to have a very usable UI - but I have tried that before and I think it will end up like a messy iOS app with code scattered all over user interface components.  It would also take a long time for me to be able to do anything meaningful - and an application opening a window is not value.  E.G., It might take months to make the UI work, but probably only a few weeks to have a command-line tool I can use to generate queries.  That would be a win by itself.

So, anyway, here I go.

This is the bitbucket project (currently blank):  https://bitbucket.org/bradleysmithllc/star-schema-commander

This is where I will actually document it (also currently blank): https://etlunit.atlassian.net/wiki/display/STAR/StarSchemaCommander

No comments:

Post a Comment