SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Are you ready for Data Warehouses?


Are you ready for Data Warehouses?

Author
Message
Loner
Loner
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3648 Visits: 3351
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2914.asp
Rick Todd
Rick Todd
SSC Veteran
SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)

Group: General Forum Members
Points: 298 Visits: 441
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
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1422 Visits: 1398
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
SuzSQL
SSC-Addicted
SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)

Group: General Forum Members
Points: 452 Visits: 299

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
Raghavendra Basarkar
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 32

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
Bryant McClellan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1081 Visits: 542
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
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1422 Visits: 1398
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search