, , , , , , ,

“Big data” is hot, hot, hot (Gartner hype cycle) and now supported by Amazon Web Services. Although pitched as “Big data” it will be very interesting to see the tools offering. I provide services to small to medium-sized enterprises and I am interested in how AWS can support the data warehousing requirements of these organisations. At the moment the natural choice is Microsoft SQL Server but AWS may change this.

Amazon Redshift (Limited Preview)

Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Amazon Redshift offers you fast query performance when analyzing virtually any size data set using the same SQL-based tools and business intelligence applications you use today. With a few clicks in the AWS Management Console, you can launch a Redshift cluster, starting with a few hundred gigabytes of data and scaling to a petabyte or more, for under $1,000 per terabyte per year.

Amazon Redshift manages all the work needed to set up, operate, and scale a data warehouse cluster, from provisioning capacity to monitoring and backing up the cluster, to applying patches and upgrades. Scaling a cluster to improve performance or increase capacity is simple and incurs no downtime. The service continuously monitors the health of the cluster and automatically replaces any component, if needed. By automating these labor-intensive tasks, Amazon Redshift enables you to spend your time focusing on your data and business insights.

Amazon Redshift is designed for developers or businesses that require the full features and capabilities of a relational data warehouse. It is certified by Jaspersoft and MicroStrategy, with additional business intelligence tools coming soon.