We performed a comparison between MySQL, SAP IQ, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."The connectivity with PHP is quite good."
"The feature I found most valuable is activity performance."
"The initial setup is easy."
"MySQL gives us a very user-friendly workspace in which to query the database."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"MySQL is a popular database platform for businesses because it is extremely easy to use."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Unbeatable speed and compression with a colummn-structured relational database."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"Its projections and encoding are excellent tools for tuning large volumes."
"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."
"It has improved my organization's functionality and performance."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The most valuable feature is Vertica's performance and the ease of using the database."
"The most valuable feature of Vertica is the unmatchable database performance."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"Scalability could be improved."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"I would like to have the ability to cancel a query in SQL Developer."
"Could use some additional JSON query support in the solution."
"Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."
"The licensing cost of the solution is expensive, which MySQL needs to consider improving."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"I think the universe should be part of the Sybase IQ tool set."
"Concurrency and functional error messaging."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"The integration of this solution with ODI could be improved."
"Limitations in group by projections is where I would like to see an improvement."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."