×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

top down vs bottom up

top down vs bottom up

top down vs bottom up

(OP)
Could someone explain to me the difference between top down and bottom up data warehousing approaches?

are star schemas bottom up where as data cubes are top down?

any help would be appriciated

RE: top down vs bottom up

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.
 

RE: top down vs bottom up

(OP)
so it is incorrect to refer to data cubes as top down and data marts (star schemas) as bottom up?

by this do you mean that regardless to the architecture (data cube/ start schema) each have related top down and bottom up methodologies?
 

RE: top down vs bottom up

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.

RE: top down vs bottom up

(OP)
just to confirm , is it incorrect to say that data cubes are a top down approach and star schemas are a bottom up approach?

RE: top down vs bottom up

For me I would say it is more correct to say that.  Cubes are A top level entity the star schema supports the cube so I see the star schema as the bottom.

RE: top down vs bottom up

(OP)
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..

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close