Access and Feeds

Cloud-based Data Warehousing: Snowflake, Microsoft Azure and Amazon Redshift

By Dick Weisinger

Data warehousing traditionally required a company to extract and download huge volumes of data from various business software systems into a central repository for analysis.  The process to prep the data was slow which meant that the analysis was always run against data that was already partially stale.

But recently we’re seeing a new generation of data warehousing, one based on cloud computing.  This week saw the announcement of general availability of Snowflake.  Snowflake is a cloud-based data warehouse running on Amazon AWS.  The company is led by Microsoft veteran Bob Muglia.  Snowflake received $26 million in funding in October 2014 and has received another round of $45 million this past week.

The Snowflake data warehouse is in direct competition with Microsoft’s Azure SQL Data Warehouse and Amazon’s Redshift cloud data warehouse.

What’s unique about Snowflake among the crowd of other recent data-focused startups is that it isn’t based on Hadoop and it was built from scratch with the cloud in mind.

Features of Snowflake include:

  • Native support for structured, machine-generated and semi-structured data
  • Scalability of data, workloads and users for multi-dimensional elasticity
  • Self tuning of data distribution and storage, and query execution
  • Security. Uses authentication, granular access control and data encryption
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Leave a Reply

Your email address will not be published. Required fields are marked *