Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Are you ready for Data Warehouses? Expand / Collapse
Author
Message
Posted Monday, March 12, 2007 10:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:03 PM
Points: 2,839, Visits: 3,146
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2914.asp
Post #350798
Posted Tuesday, March 20, 2007 9:25 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 15, 2014 12:38 PM
Points: 216, Visits: 425
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
Post #352859
Posted Wednesday, March 21, 2007 1:11 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 11:09 AM
Points: 989, Visits: 1,329
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
Post #353052
Posted Wednesday, March 21, 2007 4:18 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, December 8, 2014 9:53 AM
Points: 408, Visits: 230

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




Post #353098
Posted Wednesday, March 21, 2007 11:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 11:46 PM
Points: 1, Visits: 31

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.

 

Post #353144
Posted Thursday, March 22, 2007 5:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:03 AM
Points: 847, Visits: 478
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
Post #353188
Posted Monday, April 2, 2007 11:39 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 11:09 AM
Points: 989, Visits: 1,329
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
Post #355421
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse