We performed a comparison between Microsoft Parallel Data Warehouse, 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."The solution's integration is good."
"It is a stable solution...It is a scalable solution."
"The most valuable feature of this solution is performance."
"One of the most important features is the ease of using MS SQL."
"I am very satisfied with the customer service/technical support."
"It handles high volumes of data very well."
"We have complete control over our data."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"Complete management occurs from one single address instead of different servers."
"Exadata with the In-Memory option is several levels about SAP HANA."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"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."
"The offloading of data to the SIM is a valuable feature."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"The most valuable feature is Vertica's performance and the ease of using the database."
"I have found the solution to be scalable."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The most valuable feature of Vertica is the unmatchable database performance."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"It could be made more user-friendly for business users which would increase the user base."
"It could offer more development across the solution."
"This solution would be improved with an option for in-memory data analysis."
"I think that the error messages need to be made more specific."
"They need to incorporate a machine learning engine."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"The product does not have all of the features that the native products have."
"The query is slow if we don't optimize it."
"The solution could always be more stable and more reliable."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"The cost of the solution is high and can be improved."
"The handling of temp space has room for improvement."
"The performance could be improved."
"There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions."
"We faced some challenges when trying to use the temporary tables feature."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"It should provide a GUI interface for data management and tuning."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"When it is about to reach the maximum storage capacity, it becomes slow."
"I have found that coding support could be simplified."
"The geospatial functionality could be designed better."
"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."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →