Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / September 2004

Tip: Looking for answers? Try searching our database.

Question about Top-down and Bottom-up approac

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hari - 09 Sep 2004 07:23 GMT
Hi all

As we all know that there are two approaches of implementing a data
warehouse project. One is the top-down approach where in we create the
central data warehouse first, and then we go about creating different data
marts. Another approach is Bottom-up where in we create individual data marts
and then integrate them to create the data warehouse.
I have referred many materials, I came to know that many suggest going for
top-down approach. But they have not justified their decision, or you can say
that I was not satisfied with their explanation. I just wanted to know from
Infosys data warehouse experts about their opinion. If  someone can give any
scenarios wherein one would go for a particular approach , then it would be
more helpful.
Hari - 09 Sep 2004 07:47 GMT
Hi all,
sorry i have posted this question some where else also. So i just copy
pasted the message. Please ignore the second last statement.

> Hi all
>
[quoted text clipped - 9 lines]
> scenarios wherein one would go for a particular approach , then it would be
> more helpful.
Bryan - 10 Sep 2004 02:33 GMT
One word - "Time"
Bottom up is fast. Top down could take up to a year or more to design and
implements and usually cost a lot of money with noting to show over that
time. Despite our old beliefs in "Design twice and implement once" as we
stubbornly march down the top down path, the truth is that in most cases the
bottom up can be just as flexible, faster and productive even in phases.
Most business units do not want to wait to see results and would much rather
see an immediate ROI before plunking down the dollars for a full model.
Another reason is, say your company has 10 sales regions, but there may be
up to 20 more in the next five years. At this point it is easier to add the
data mart / region into the larger warehouse. But wait! there was just a
merger and now there are 7 new divisions to add leading to a whole other set
of data marts that would have not been designed in the original model of a
top down approach.
In the end, it all depends on the information, resources and support you
have. Like anything in database design, there is no "one size fits all"
answer.
Hope this helps.

Signature

Bryan Bitzer MCP
Senior Database Administrator
Marshall & Swift / Boeckh
www.msbinfo.com

> Hi all,
> sorry i have posted this question some where else also. So i just copy
[quoted text clipped - 13 lines]
> > scenarios wherein one would go for a particular approach , then it would be
> > more helpful.
J?j? - 14 Sep 2004 13:29 GMT
The top-bottom is great when you have a lot of indicators (or KPIs) to
create.
Because your datawarehouse will contain "all" the required information to
make them, so constructing your KPIs take far less work then a bottom up.

The bottom-top approach is good if you have questions and your data is
already accessible, so can quickly answer the question. the ROI is better,
but responding to other questions can result in this : destroy all and
recreate all!

So focus on the more complex questions you have from your users to identify
how to solve it.

> Hi all
>
[quoted text clipped - 9 lines]
> scenarios wherein one would go for a particular approach , then it would be
> more helpful.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.