

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
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.
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.
In some cases, they support me on a 24/7 basis, round the clock.
Oracle's technical support is not very effective.
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.
The database regularly releases new versions with better performance and security features.
RAC is the feature where I can distribute the load among multiple nodes, and it has helped our enterprise applications.
OpenText Analytics Database (Vertica) is very stable.
Oracle Database is very robust, and I rate its stability nine out of ten.
It is a stable product.
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 Database needs improvement in data analytics capabilities, AI involvement, machine learning, and deep learning.
One existing feature that distinguishes Oracle Database from others is its ability to log errors in the database itself.
It would be more feasible if Oracle allowed licensing on a socket-based model instead of cores.
The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.
For medium businesses, Oracle and IBM DB2 pricing are quite similar.
Oracle Database is costly.
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.
Its data management capabilities include data quality, data integration, data architecture, modeling, and data security, which are very important for data-driven companies.
Regarding what I value about Oracle Database, as far as execution is concerned, I think it is one of the best databases I have come across.
The most valuable features in WebLogic Suite are its stability and security.
| Product | Mindshare (%) |
|---|---|
| OpenText Analytics Database (Vertica) | 5.0% |
| Snowflake | 10.2% |
| Teradata | 9.0% |
| Other | 75.8% |
| Product | Mindshare (%) |
|---|---|
| Oracle Database | 11.5% |
| SQL Server | 11.9% |
| SAP HANA | 6.9% |
| Other | 69.7% |

| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 42 |
| Company Size | Count |
|---|---|
| Small Business | 87 |
| Midsize Enterprise | 65 |
| Large Enterprise | 179 |
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.
Oracle Database is a top-ranking multi-model database management system by Oracle Corporation. Through Oracle database services and products, clients receive cost-optimized and high-performing versions of Oracle Database, as well as in-memory, NoSQL, and MySQL databases. The solution is available by several service providers on premises, in the cloud, or as a hybrid installation. It can be run on vendor servers as well as on Oracle hardware, including Exadata on-premise, Oracle Cloud, or Cloud at Customer.
Users can select from various types of Oracle Database solutions, depending on what they aim to do with this product. Based on their specific needs, they can choose among options that include:
Part of this product is a fully automated database service called Oracle Autonomous Database, which facilitates the development and deployment of application workloads for organizations. It is built on Oracle Database as well as on Oracle Exadata. This service supports various data types and simplifies application development and deployment from modeling and coding to extract, transform, load process (ETL), data analysis, and database optimization. The service achieves high results in:
Oracle Database Features
Oracle Database has various features which users can utilize in their work with the solution. Among these features are the following:
Oracle Database Benefits
Oracle Database offers its users various benefits. Some of these include:
Reviews from Real Users
Paul S., president at Advance Consulting Enterprise, likes Oracle Database because it gets the job done, doesn't fail, and suitable for massively scalable applications.
An Oracle DBA at a computer software company describes Oracle Database as reliable with good performance and very good stability.
We monitor all Data Warehouse 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.