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."
"We can store the data in a data lake for a very low cost."
"One of the most important features is the ease of using MS SQL."
"The most valuable feature is the business intelligence (BI) part of it."
"It is a very stable database."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"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 new Exadata x9m has an even higher speed of 100GBps connectivity."
"The product is flexible."
"The most valuable feature of Oracle Exadata is the storage available."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"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."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Speed and resiliency are probably the best parts of this product."
"Allows us to take volumes and process them at a very high speed."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The performance is very good and the aggregate records are fast."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"They need to incorporate a machine learning engine."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"We'd like to see it be a bit more compatible with other solutions."
"This solution would be improved with an option for in-memory data analysis."
"We find the cost of the solution to be a little high."
"I would like to see better visualization features."
"I would like the tool to support different operating systems."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"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 customization can sometimes be difficult to achieve."
"We used the support from Oracle Exadata to complete the implementation."
"Sometimes it takes too long time to get help with technical issues."
"The handling of temp space has room for improvement."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"Exadata would be improved with single dashboard visibility."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The integration with AI has room for improvement."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"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."
"I believe the installation process could be streamlined."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →