

Find out what your peers are saying about PostgreSQL, Oracle, ClickHouse and others in Open Source Databases.
I have seen a return on investment with MySQL, as it allows us to manage with fewer employees, focusing on business logic rather than database management.
I saved a lot of money because the storage was on a cheaper alternative and was not directly on OpenText Analytics Database (Vertica), but on S3.
The time we used to take with our earlier databases has reduced to one-tenth of what was there earlier, which is a positive outcome that can be converted to financial metrics in terms of return on investment.
I would rate the documentation and online support a 10 out of 10.
We have no issues and usually receive timely responses.
Throughout this process, customer support was outstanding, and we had a person actively supporting us from the OpenText Analytics Database (Vertica) team for our use case.
Overall, our experience with OpenText Analytics Database (Vertica) customer support has been good and reliable.
Meeting scalability requirements through cloud computing is an expensive affair.
MySQL's scalability is currently adequate, as we have increased operations from ten thousand to twelve thousand devices, and it is working fine for us.
We have experienced easy horizontal scaling, consistent query performance as data grew, and the ability to handle large analytic workloads.
OpenText Analytics Database (Vertica) has very good scalability.
OpenText Analytics Database (Vertica) can scale to a great extent.
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar.
From my experience, MySQL was pretty stable.
OpenText Analytics Database (Vertica) is very stable.
It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.
Oracle could improve on scalability.
The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation.
Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management.
Projections could be made more dynamic, and if they could find a faster way to update, insert, and delete data, that would also be helpful.
OpenText Analytics Database (Vertica) does not have a cloud-based UI that Snowflake has, which features a very good comprehensive GUI for querying and analyzing data.
Oracle has different components, so if you need security, you have to procure a different license, but here everything is inbuilt and it's not costly.
The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment.
The main feature we utilize in MySQL is the view, and I can say that it is the most valuable feature for our needs.
It allows programming, writing stored procedures, creating views, constraints, and triggers easily.
I can use it in Eon Mode in which I can store the data in cheaper storage such as Amazon S3 and have different compute nodes.
Projection and columnar storage are the most valuable features because they dramatically improve query performance and reduce the need for index management.
The best features that OpenText Analytics Database (Vertica) offers are mainly the parallel processing, ETL capabilities, and the multi-cloud features which are very handy to use.
| Product | Mindshare (%) |
|---|---|
| MySQL | 10.3% |
| PostgreSQL | 13.5% |
| Firebird SQL | 11.0% |
| Other | 65.2% |
| Product | Mindshare (%) |
|---|---|
| OpenText Analytics Database (Vertica) | 5.1% |
| Snowflake | 9.5% |
| Teradata | 8.8% |
| Other | 76.6% |

| Company Size | Count |
|---|---|
| Small Business | 75 |
| Midsize Enterprise | 33 |
| Large Enterprise | 61 |
| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 43 |
MySQL is an open-source database known for its ease of use and high performance. It offers features like replication and clustering, making it ideal for diverse applications. Its cost-effectiveness and LAMP integration are key advantages for businesses.
MySQL supports a variety of languages and platforms, providing reliable, scalable data management. Its graphical interface and LAMP architecture integration enhance its usability, while community support further strengthens its appeal. Challenges include scalability issues with large databases, lack of advanced clustering, and limited high-availability features. Complex queries may affect performance, and integration can pose difficulties. The outdated interface and insufficient documentation are also concerns, along with replication and backup reliability issues.
What are MySQL's key features?MySQL is widely implemented in industries such as web development, e-commerce, and finance. It's used for managing dynamic websites, powering e-commerce platforms, and supporting financial applications. Its compatibility with PHP and cost-effectiveness make it suitable for CMS platforms like WordPress. With cloud services integration, MySQL is a backend choice for scalable applications in various sectors.
OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.
OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.
What features define OpenText Analytics Database Vertica?OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.
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.