We performed a comparison between Amazon Redshift, Oracle Exadata, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."Easy to build out our snowflake design and load data."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"It allows for the storage of huge amounts of data."
"The processing of data is very fast."
"We have found Machine Learning use cases are very nice."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"Complete management occurs from one single address instead of different servers."
"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."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The performance of the data is the most important part."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"The tool's performance is good."
"The most valuable feature of Oracle Exadata is the storage available."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"In our experiments, the handling of unstructured data was not very smooth."
"The customer support could be more responsive."
"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."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"The initial deployment was complex."
"Improvement could be made in the area of streaming data."
"Tech support sometimes takes some time to identify and rectify issues."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"The solution lacks a visualized console."
"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."
"I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"The setup is a little bit complex. We would like to see the installation part get easier."
"The integration with third-party applications regarding access management security could be better."
"Sometimes it takes too long time to get help with technical issues."
"They could improve on customer service."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"It would be great if this were a managed service in AWS."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The biggest problem is the cost of cloud deployment."