Can These Oracle and Microsoft Veterans Reinvent the Data Warehouse?
Can these Oracle and Microsoft veterans reinvent the data warehouse?This article is about a reinvention of the data warehouse, from the ground up in a new SQL relational database technology called Snowflake. This idea isnt meant to be taken lightly, because its designed by a team of well-trained experts in the field from companies like Oracle and Microsoft. Snowflake was built from scratch and seems to address concerns from current data warehouse users predominately from a cost perspective. Snowflake can reduce costs in the neighborhood similar to a close competitor, RedShift, by as much as 90% because its all cloud based. That means no buying extensive expensive equipment only to analyze a small portion of data. Snowflake will charge based on usage of processing time and storage, so putting your data on the cloud is required. This also means that response time can be much better as well, “instead of spending an hour waiting for a response, we get it in five minutes with Snowflake.”Coming from someone who has limited database knowledge (I work with a data warehouse via pivot tables – hence why Im taking this class!), the idea of “big data” and analyzing information is always overwhelming and intimidating. This makes it seem like Snowflake is the “Netflix” of data analytics, and that makes me a little more comfortable. If it comes true, I think I would more apt to try out Snowflake.
This article is about a reinvention of the data warehouse, from the ground up in a new SQL relational database technology called Snowflake. This idea isnt meant to be taken lightly, because its designed by a team of well-trained experts in the field from companies like Oracle and Microsoft. Snowflake was built from scratch and seems to address concerns from current data warehouse users predominately from a cost perspective. Snowflake can reduce costs in the neighborhood similar to a close competitor, RedShift, by as much as 90% because its all cloud based. That means no buying extensive expensive equipment only to analyze a small portion of data. Snowflake will charge based on usage of processing time and storage, so putting your data on the cloud is required. This also means that response time can be much better as well, “instead of spending an hour waiting for a response, we get it in five minutes with Snowflake.”Coming from someone who has limited database knowledge (I work with a data warehouse via pivot tables – hence why Im taking this class!), the idea of “big data” and analyzing information is always overwhelming and intimidating. This makes it seem like Snowflake is the “Netflix” of data analytics, and that makes me a little more comfortable. If it comes true, I think I would more apt to try out Snowflake.