We performed a comparison between Microsoft Parallel Data Warehouse, Oracle Exadata, and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."Data collection and reporting are valuable features of the solution."
"The solution's integration is good."
"I am very satisfied with the customer service/technical support."
"We can store the data in a data lake for a very low cost."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"The business intelligence is very good."
"It is a scalable solution."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"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."
"It is a highly relevant option with extreme performance."
"The performance of the data is the most important part."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"The most valuable feature is storage offloading."
"It's one of the fastest databases in the market. It's easy to use. From a maintenance perspective it's a good product. The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments. The query performance of the product, for complex queries, is very good. It has good integration with Hadoop."
"The loading speed is very good."
"With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."
"A very good, open-source platform."
"We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database."
"Very fast for query processing."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"Scalable (Massive) Parallel Processing (MPP) – The ability to bring to bear large amounts of compute against large data sets with Greenplum and the EMC DCA has proven itself to be very effective."
"I think that the error messages need to be made more specific."
"I would like to see better visualization features."
"The reporting for certain types of data needs to be improved."
"We find the cost of the solution to be a little high."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"This solution would be improved with an option for in-memory data analysis."
"They need to incorporate a machine learning engine."
"More tools to help designers should be included."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"Sometimes it takes too long time to get help with technical issues."
"The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"The solution's pricing is very high."
"It's too expensive per terabyte. It's complex."
"The initial setup process is very difficult and extremely complex."
"Implementation takes a long time."
"Tanzu Greenplum's compression for GPText could be made more efficient."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"Maintenance is time-consuming."
"they need to interact more with customers. They need to explain the features, especially when there are new releases of Greenplum. I know just from information I've found that it has other features, it can be used to for analytics, for integration with Big Data, Hadoop. They need to focus on this part with the customer."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →