We performed a comparison between Amazon Redshift, IBM Db2 Warehouse on Cloud, and Oracle Exadata based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"This service can merge and integrate well with all databases."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"It is quite simple to use and there are no issues with creating the tables."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"The product offers good support for the data lake."
"The product is relatively easy to use because there is no indexing and no partitions."
"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 is a highly relevant option with extreme performance."
"Oracle has reliable solutions and this one is no different."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"Complete management occurs from one single address instead of different servers."
"They just have a lot of products, and they work well together."
"The business intelligence is very good."
"Oracle Exadata is stable."
"Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The customer support could be more responsive."
"It lacks a few features which can be very useful, such as stored procedures"
"Should be made available across zones, like other Multi-AZ solutions."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"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."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The technical support is in need of improvement."
"Exadata would be improved with single dashboard visibility."
"Since the product is an appliance, it is very costly."
"The initial setup process is very difficult and extremely complex."
"We used the support from Oracle Exadata to complete the implementation."