Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
top down vs bottom up
- Thread starter mrcamo
- Start date
In my experience Top Down is where you start with Reports that need to be filled. These in turn dictate the design of your cube, data mart and underlying relational schema. Bottom up is starting with a list of capabilities that are needed which you then can build your Relational schema off of then cube and reports.
In my experience top down is faster initially because you can quickly meet the needs of the orginization, but typically forces a design that may not be as flexible making expanding the capabilities of the solution more difficult.
It is an easy trap to get caught up in. My experience leads me to believe you get forced in a top down method when people do not understand the technology or methodology and are unwilling or unable to learn.
I find myself quickly going from a bottom up to Top down environment yet again.
In my experience top down is faster initially because you can quickly meet the needs of the orginization, but typically forces a design that may not be as flexible making expanding the capabilities of the solution more difficult.
It is an easy trap to get caught up in. My experience leads me to believe you get forced in a top down method when people do not understand the technology or methodology and are unwilling or unable to learn.
I find myself quickly going from a bottom up to Top down environment yet again.
- Thread starter
- #3
not so much a methodology as what you include. If you build from the report aspect you are likely to only fit the needs of those reports. If you start with here is the the business need we are trying to build for you will probably end up with a more robust design, that includes the immediate needs but also some people have not yet considered.
- Thread starter
- #5
- Thread starter
- #7
is it not possible to apply top down and bottom up methods to the design of cubes ? and at the same time apply top down and bottom up methods to the design of star schemas.
My point is that I am trying to write a document which describes the difference between top down and bottom up techniques, and am unsure weather to label cubes as top down and stars as bottom up..
My point is that I am trying to write a document which describes the difference between top down and bottom up techniques, and am unsure weather to label cubes as top down and stars as bottom up..
- Status
Similar threads
