Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

The pros and cons of data warehousing

SQL Server expert Eric Brown explains the pros and cons of data warehousing.

Could you outline some of the pros and cons of data warehousing?
There are a number of good books on DW. You can read anything by Ralph Kimball ( kimballuniversity.com), a DW guru.

Maybe it would help you to categorize the issues, rather then pro/cons as each potential "pro" can be "con" depending...

on your point of view. The factors affecting the DW discussion are a combination of business and technology issues. Business people will want reports with a certain level of quality and timeliness. The infrastructure folks will want security and scalability and the other "abilities". The question for me is really, AS cube or no cube- relational reporting as it is called. Many times depending on the reporting need, a DW will be good enough. The case for a cube in my opinion is tied to aggregation and time analysis.

In the end the decision to use DW comes back to what are the reporting requirements.

Read questions and answers from all of our SQL Server experts here.

This was last published in April 2006

Dig Deeper on SQL Server Data Warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close