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, MariaDB and others in Open Source Databases."The deployment process is pretty fast."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"While MySQL offers strong basic functionality."
"It's a mature solution that's been around for decades."
"The most valuable features are that it's free and the documentation is good."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"It is a scalable solution."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Unbeatable speed and compression with a colummn-structured relational database."
"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."
"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."
"Its projections and encoding are excellent tools for tuning large volumes."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"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."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"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."
"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."
"Some problems with big table operations, and a struggle to keep the servers responding in peak situations."
"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"The integration with other systems can be improved as can the integration between other databases."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"When I run into issues, I really have to research how to fix them."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"Concurrency and functional error messaging."
"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."
"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."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The geospatial functionality could be designed better."
"The integration of this solution with ODI could be improved."
"Very bad support, I would rate it two out of 10."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Documentation has become much better, but can always use some improvement."
"It would be great if this were a managed service in AWS."
"They could improve on customer service."
"It should provide a GUI interface for data management and tuning."