Saturday, August 29, 2015

How to judge a good solution?

Its a very easy question...

Q. How good is the solution?

The answer is simpler

A. How big is the problem?

An elegant solution to an insignificant problem means wasted effort. If something needs to claim as a worthy solution it has to compare itself to the problem being solved. So we need to look very closely to the problem we are trying to solve.

Now lets understand what makes a problem big. A problem is big if it affects large groups of people adversely. Such a problem becomes even more complex if the lack of a solution serves some people quite well, or if there is a perception that the solution to the problem will create winners and losers.

Solution of these problems requires that we understand who all gets affected by a problem in what way, and how do we slowly affect change and mitigate concerns. Also, how we ensure that people who feel they will get affected adversely by this change, slowly start changing perceptions and behaviours that leads to changed behaviour...



 

Saturday, February 21, 2015

Naming conventions in Dimensional Warehousing models

I am looking at a good and robust set of naming conventions to adopt for a Dimensional Data Warehousing Model that I am developing. As I looked around, there were different conventions with opposing perspectives. I still do not know which makes more sense, but I will first enumerate the list of questions I have.

1. Should the table name suggest whether the table is a fact or a dimension?
2. Should Entity name prefixed in each table attribute?
3. Should the attribute name follow some convention?
4. Should the fact table reveal something about the grain?
5. Should a fact measure provide some clue of the units the measure is recorded in?

I will update the post, as I get closer to my answer, but already I have seen some links/ blogs from Kimball group and another set of standards from Oracle BI Applications. Here are the links to these resources as I will revisit this post.

1. Oracle naming conventions


2. Kimball Group Blog on naming convention


I will explore this further and keep updating my preferences as we go along...