Amazon’s Redshift{1}


Cloud-based hosted data warehousing services are gaining in popularity. The primary drivers for this movement are that older enterprise warehouse data systems are expensive and difficult to maintain. Amazon looks to fill those void’s with its new hosted data warehouse service Redshift. What makes it unique is that it’s about a tenth of the cost of regular data warehouses and it automates deployment and maintenance. It is also compatible with many popular business intelligence tools, so people will not have to spend resources to learn new tools. Since Redshift runs off of Amazon’s AWS service, it gets the added benefits of massive failover and redundancy clusters. Customers will not have to worry about data management as it’s already taken care of by Amazon.

Chapter 9 talks about some of the common infrastructures used in data warehousing. It can sometimes get complicated and I think with a hosted solution, it takes some of those complications away. Hosted data warehousing services are getting cheaper so it makes sense to use them as there are no on premise hardware costs involved. According to the article, one terabyte of data would cost approximately $1,000 per year, compared to the $19,000 to $25,000 it would’ve cost traditionally.

What I like most about Amazon’s Redshift is that it is compatible with most popular business intelligence tools. That would greatly benefit companies that have become accustomed to their normal set of tools and would like to avoid the costs and time of learning how to use new tools. Sometimes it’s hard to teach an old dog new tricks.

Jackson, J., (November 28, 2012) Amazon Introduces New Data Warehouse Service. Retrieved November 28, 2012 from http://www.computerworld.com/s/article/9234090/Amazon_introduces_data_warehouse_service