We performed a comparison between Amazon Redshift and IBM Db2 Warehouse on Cloud based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The product is relatively easy to use because there is no indexing and no partitions."
"It allows for the storage of huge amounts of data."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"The solution is scalable. It handles different loads very well."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast."
"The most valuable feature is the scalability, as it grows according to our needs."
"It will be MPP, so performance should improve."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."
"The performance is okay as long as the volume of queries is not too high."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"The solution could improve in handling more data formats and more native support for RDF."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"Planting is the primary key enforcement that should be improved."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"This solution lacks integration with non-AWS sources."
"In our experiments, the handling of unstructured data was not very smooth."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse. Amazon Redshift is rated 7.8, while IBM Db2 Warehouse on Cloud is rated 7.6. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and AWS Lake Formation, whereas IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, IBM Netezza Performance Server and Snowflake. See our Amazon Redshift vs. IBM Db2 Warehouse on Cloud report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.