Are you ready for Data Warehouses?

Question

Are you ready for Data Warehouses?

Loner

SSC-Insane

Points: 21279
More actions
March 12, 2007 at 10:45 am

#175515

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2914.asp

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Rick Todd Hall of Fame Points: 3302 More actions · Answer 1

Hey, thanks for the pick me up! I'm getting ready to work on a big DW project, and have mostly been thinking how overwhelming it is while reading The Data Warhouse Toolkit. Now I can at least think that I'm much better off than I would have been 12 years ago! There are certainly a lot more resources (like this site and that great book by Inmon!) than there were when you did it.

I have to say it's an exciting time in DW/BI, as there's enough info to make it realistic, but not so much as to make it too easy for your work to be appreaciated.

Cheers,

Rick

Rick Todd

Kurt W. Zimmerman SSCrazy Eights Points: 8676 More actions · Answer 2

I remember when I introduced the concept to a corporate finance company I was working at in 2000. It was the first time the company was able to make strategic decisions looking at the company business. It was the company's most profitable year.

Thanks for the report

Kurt Zimmerman

DBA

RegionalHelpWanted.COM

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman

SuzSQL SSC Eights! Points: 927 More actions · Answer 3

I am a DBA who recently finished working on a SQL 2005 DW project. The 1st 6 months almost killed me between working with beta software and trying desperately to get my head around the whole BI world. I believe that BI could be the most exciting area for a DBA to be in. I still stuggle with what the true role of a DBA is in the MS DW model. I did the AS development (cubeville) but in general is there a seperate DBA role or does the DBA assume a new role? Do we administer AS? Do we administer RS? Do we develop the ETL in SSIS? Do we develop in those areas or do DBAs work with the relational store and the data sources and leave the rest to developers? Not sure what the answer is and I imagine it will be quite different for different companies. Thoughts?

Susan Shafer

EDS - Data Engineering

Troy, Michigan

Raghavendra Basarkar SSC Rookie Points: 25 More actions · Answer 4

Hi Sir/Madam,

My name is Raghavendra,presently iam working on .Net2.0 with SqlServer2005 as backend.

iam very much interested in "Dataware housing".

But iam begineer in database side.

what i should know before i start this DatawareHousing in Sqlserver.

thanks in advance,

Regards,

B.Raghavendra.

Bryant McClellan SSCarpal Tunnel Points: 4337 More actions · Answer 5

I still find myself wondering, occasionally, what the hoopla around data warehousing is. Virtually anybody who works for a company that has been in business long enough to define the word 'mainframe' already HAS a data warehouse. By that I mean data stored away in different formats among different systems that are typically incompatible. Typically, the real problem with these 'warehouses' is not the storage but the picking of data.

The trend seems to be to create yet another warehouse, where data is regularly collected from one warehouse and stored in another (albeit in a fashion more optimized for analytics). This is a financial boon for those who run the warehouse business, but is the value really gained simply by moving the data? Why not a software platform that is vendor agnostic, capable of stitching together data from the various existing systems, using meta data to arrive at consistencies in definitions, and making that data available for reporting without requiring that it be physically moved?

------------
Buy the ticket, take the ride. -- Hunter S. Thompson

Kurt W. Zimmerman SSCrazy Eights Points: 8676 More actions · Answer 6

G Bryant McClellan;

In a sense you are 100% correct on your assessment with a DW. None the less there are many organizations that don't have something like a very large data repository that allows them to efficiently report on "what-if" scenarios. The framework of a DW with the proper project management design methodology behind it will result in a high performance reliable platform providing good statistics for the "decision makers".

It doesn't take long, after sitting in on a long-winded high-level meeting to find out there is information that is needed to steer a corporation and yet has no way of being tapped.

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman