We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Data Warehouse Appliances: Lessons from the Trenches

Originally published July 22, 2009

There are many factors to consider when choosing to implement a data warehouse appliance. Steve Dine and Jerry Locke share lessons learned from a recent data warehouse appliance implementation for both the data warehouse and data mart layers of the client architecture.

You must be a member to view this content. Membership is free and gives you full access to all content across the Network. Login or sign up today.

Sorry there was a problem with your login or password. Please try again.
Member Login

Not a member? Signup now!
Forgot your password? Get it now.



Want to post a comment? Login or become a member today!

Posted July 22, 2009 by Phil Bailey phil.bailey@btconnect.com

Nice clear overview and some good points. I know you'd like the article to be generic, but out of interest, which appliance was implemented in this particular case?

I implemented an appliance in a Telco back in 2003 and came across all of your points. 5) was interesting as it taught me that SPs are simply not required in MPP systems... pretty much every procedural operation can be done by breaking the logic into chunks of standard sql and applying them incrementally, but incredibly quickly due to the performance of the system - so SPs are a hang-over from traditional OLTP systems just like indexes in my view.

Is this comment inappropriate? Click here to flag this comment.