Redshift
- Columnar database optimized for Datawarehousing
- Offered in Amazon Cloud by Amazon Web Services - http://aws.amazon.com/redshift
- Modified version of PostgreSQL database.
Fast Query Performance
- Uses columnar data storage to improve I/O
- Data is compressed and stored in disk
- Massively parallel processing(MPP) -Distributes data and query across multiple nodes.
Data Load
- Data Load speed scales linearly with cluster size.
- Redshift is integrated with other Amazon services like S3, Dynamo DB and EMR
- Any data transfers between amazon services are not charged.
Fault Tolerant/Backup
- All data written to a node is replicated to other nodes within the cluster.
- All data is backedup in S3.Automated backups of new data and can retain snapshots
Comments