4 ms·
What's the difference between this and Amazon's RDS or S3? Is it just data storage with an easy way to query the for-mentioned data? Seems like an "odd" produc
by UnoriginalGuy 14y ago
What's the difference between this and Amazon's RDS or S3? Is it just data storage with an easy way to query the for-mentioned data?
Seems like an "odd" product that kind of compete's with Amazon's existing offerings in many ways...
- jrnkntl 14y agoThis seamlessly integrates with existing Data Warehouse software solutions and Redshift handles everything you'd normally had to configure, import, read, query yourself using RDS; plus it uses S3 to store its backups and let the client restore their datasets from it. So it doesn't compete with it, my understanding is that it might as well utilize both but in a ready made package that integrates with existing data warehousing solutions.
- SpikeGronim 14y agoThis is optimized for bulk analysis. RDS is more optimized for low latency queries. This is because Redshift is column oriented: http://en.wikipedia.org/wiki/Column-oriented_DBMS http://en.wikipedia.org/wiki/Column-oriented_DBMS .
- kevindication 14y agoYep. Redshift is based off of ParAccel. We used that DB for some really awesome large scale analytics on a previous project. http://www.zdnet.com/amazon-redshift-paraccel-in-costly-appliances-out-7000008111/ http://www.zdnet.com/amazon-redshift-paraccel-in-costly-appl...
- dirtyaura 14y agoBoth RedShift and Google's BigQuery are very useful for enterprise applications that involve aggregating data in many ways.
- mallipeddi 14y agoAmazon RDS is for OLTP workloads. Redshift is a distributed, column-oriented store that's designed for OLAP workloads. For more info: http://aws.amazon.com/redshift/faqs/#0110 http://aws.amazon.com/redshift/faqs/#0110