We performed a comparison between Oracle MySQL Cloud Service and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."It's easy to use."
"The most valuable aspect of the product is data migration."
"The solution's performance is good."
"The initial setup was straightforward."
"The most valuable feature is the data aggregation function."
"The product is good for tuning."
"The access to a suite of management and administration tools that simplify tasks such as database provisioning, configuration, and monitoring."
"The most valuable features of the solution stem from the fact that it is flexible and is an open-source product."
"Its projections and encoding are excellent tools for tuning large volumes."
"Allows us to take volumes and process them at a very high speed."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"The performance is very good and the aggregate records are fast."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"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."
"The most valuable feature of Vertica is the unmatchable database performance."
"Oracle MySQL Cloud Service's scalability is an area of concern that can be better."
"The technical support is in need of improvement."
"Improvement could be made in the workflow, particularly when it comes to making changes or implementing certain functions."
"The product has many bugs."
"Sometimes, we face syntax issues with the solution."
"There could be more courses where the people could learn more easily how to use the tool."
"The solution should offer memory management."
"The tool’s stability must be improved."
"Support is an area where it could get better."
"It should provide a GUI interface for data management and tuning."
"The integration with AI has room for improvement."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"We faced some challenges when trying to use the temporary tables feature."
Oracle MySQL Cloud Service is ranked 7th in Open Source Databases with 15 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle MySQL Cloud Service is rated 8.2, while Vertica is rated 8.4. The top reviewer of Oracle MySQL Cloud Service writes "A stable solution that can be used to perform on-premises to cloud migrations". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle MySQL Cloud Service is most compared with Amazon Aurora, MySQL, Firebird SQL, Percona Server and PostgreSQL, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.