Data Warehouse Appliances: Lessons from the Trenches
By Jerry Locke & Steve Dine
Over the past few years data warehouse (DW) appliances have become a viable option for business intelligence (BI) programs looking to load and process large data volumes as well as reducing query execution times. However, like most architectural decisions, there are many factors to consider when choosing to implement a DW appliance that aren’t usually highlighted during the sales presentation. This article will present some observations and lessons learned from a recent project in which we implemented a DW appliance for both the data warehouse and the data mart layers of the client architecture.