OpenText Analytics Database (Vertica) vs Oracle NoSQL comparison

OpenText Analytics Database (Vertica) vs. Oracle NoSQL

Download the complete report

Helped 893,244 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Warehouse (5th), Cloud Data Warehouse (11th)

Oracle NoSQL

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

NoSQL Databases (13th)

Featured Reviews

Jitendrak Naik

consultant at tcs

Data warehousing has transformed reporting performance and now delivers near real-time insights

OpenText Analytics Database (Vertica) is a very powerful analytic database, but like any platform, there are areas where it can improve to make daily work even smoother. Better cloud-native experience is one area for improvement. OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud. Improvement opportunities include more seamless cloud-native features such as auto-scaling, serverless options, and easier cluster management. Competitors such as Snowflake and BigQuery provide more fully managed experiences. Easier UI is another area for improvement. Most administration is currently done by SQL and command line tools. An improvement opportunity would be a more modern web UI for monitoring, workload management, and troubleshooting. Faster ecosystem and community growth is needed. In short, OpenText Analytics Database (Vertica) could improve in areas such as cloud-native capability, modern UI for administration, stronger real-time streaming integration, and growing its ecosystem and community. These enhancements would make it easier to manage and adopt compared to newer cloud-first analytic platforms. From a day-to-day operational perspective, there are a few areas where OpenText Analytics Database (Vertica) could improve to make our work smoother. Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management. Right now, monitoring queries often requires system tables and manual analysis. Troubleshooting slow queries takes time. A modern real-time dashboard showing query bottlenecks and resource users would enable quick detection. The impact could be faster issue resolution and less time spent debugging performance. Storage native interaction with modern data tools is also important. In short, from a day-to-day perspective, improvements in automatic projection optimization, better workload monitoring dashboard, easier schema evolution, and stronger modern tool integration would significantly reduce manual tuning effort and improve developer productivity. While OpenText Analytics Database (Vertica) is very powerful, these enhancements would make it more efficient for the analytics team.

Read full review

Susantha Kumar

Support on banking at Aithent

Handles large data volumes effectively but connection issues require attention

The Oracle NoSQL solution is used primarily for storing data for our web applications. We work alongside the DBA team for this purpose, given that specific departments manage aspects of its use. We choose it specifically to handle large scales of data, such as in one of our bank customer's scenarios using more than nine hundred gigabytes of data.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Replication and Node recovery in 8.0."

"Before Vertica, we used a combination of sharded RDBMSs and Hive: the typical runtime for a query was in the hours; it's now in the seconds, with way more data than then (we're talking hundreds of terabytes)."

"The implementation itself is excellent with fantastic features, speed and scalability."

"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."

"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"

"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."

"It is tremendously scalability, with excellent performance."

"Do you want to stand up a data warehouse in a reasonable amount of time using the in-house skills accustomed to dealing with an RDBMS? If that is the case, nothing beats Vertica, hands down."

More OpenText Analytics Database (Vertica) pros

"NoSQL has high availability; I think it's perfect from a technical perspective, and it's quick to run and go."

"The product meets expectations when it comes to stability."

"So far, we find stability to be very reasonable, it is dependable and we do not have any big issues."

"With Oracle NoSQL, our clients have a highly scalable, simple to set up database that performs very well when data is organized correctly from the beginning."

"Try it! You’ll be impressed."

"The tool is easy to learn."

"Oracle NoSQL is pretty scalable."

"NoSQL has high availability. I think it's perfect from a technical perspective. It's quick to run and go."

More Oracle NoSQL pros

Cons

"Vertica’s resource demands for RAM and I/O during load and storage were challenging for our platform."

"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."

"Whatever's out, the core is not always as great as the engine, especially their first version."

"We had confronted couple of issues during Vertica upgrades for which we do align with your support group."

"I'm concerned that HP Enterprise has sold their software business, and worry about future investment to enhance predictive/machine-learning capabilities."

"Very bad support, I would rate it two out of 10."

"We faced some challenges when trying to use the temporary tables feature."

"Over the last few months with the new release of Vertica, there have been stability problems. The performance should improve."

More OpenText Analytics Database (Vertica) cons

"You will get high performance when you organize your data correctly at the beginning. Otherwise, there are instability issues."

"Handling big data in a user-friendly way is currently a bit of an issue. The dashboard for this needs some work."

"Personally, I’d like to see some improvements in the monitoring UI for it."

"The installation is difficult."

"I would rate Oracle NoSQL six or 6.5 out of ten based on my experience."

"The main areas that need improvement with NoSQL are in the area of big data and user-friendly presentation."

"Oracle could improve how NoSQL works in containers. I don't think NoSQL needs any new features, but I want to see new features in the Oracle Cloud Infrastructure. I would like to see some improvements in OCI's building options."

"Focusing on making the administration easier compared to other solutions like MongoDB could be beneficial. Simplifying the administrative tasks could enhance the user experience."

More Oracle NoSQL cons

Pricing and Cost Advice

"The solution is free and we pay for the storage."

"The pricing could improve, it is a little expensive."

"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."

"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."

"I am aware that we have licensed it, but I have no knowledge of its cost."

"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."

"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."

"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."

More OpenText Analytics Database (Vertica) pricing and cost advice

"The product is expensive and Oracle could work to lower the licensing cost."

See which vendors are best for you

Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.

See recommendations

893,244 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Computer Software Company

12%

Manufacturing Company

Comms Service Provider

Financial Services Firm

15%

Outsourcing Company

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	29
Midsize Enterprise	23
Large Enterprise	43

By reviewers
Company Size	Count
Midsize Enterprise	3
Large Enterprise	5

Questions from the Community

What do you like most about Vertica?

Vertica is easy to use and provides really high performance, stability, and scalability.

What is your experience regarding pricing and costs for Vertica?

My experience with pricing, setup cost, and licensing is limited because the organization handled the licensing and pricing as well as the cost setup.

What needs improvement with Vertica?

OpenText Analytics Database (Vertica) is already doing great. There could be a community which could have been much more advanced and more people can be engaged so that any kind of questions, queri...

What is your experience regarding pricing and costs for Oracle NoSQL?

We use the enterprise edition of Oracle NoSQL.

What needs improvement with Oracle NoSQL?

Sometimes we face problems with the connection between our applications and the database. It may be due to network issues or performance issues on Oracle's side. Our DBA team requests validations f...

What is your primary use case for Oracle NoSQL?

We use Oracle NoSQL ( /products/oracle-nosql-reviews ) to store data for our web applications. It is being used for customer projects, and we handle one of our bank customers using more than nine h...

Teradata vs OpenText Analytics Database (Vertica)

Comparisons

Compared 7% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 5% of the time

SAP IQ vs OpenText Analytics Database (Vertica)

Compared 4% of the time

SQL Server vs OpenText Analytics Database (Vertica)

Compared 4% of the time

More OpenText Analytics Database (Vertica) Competitors

MongoDB Enterprise Advanced vs Oracle NoSQL

Compared 17% of the time

Cassandra vs Oracle NoSQL

Compared 14% of the time

Cloudera Distribution for Hadoop vs Oracle NoSQL

Compared 10% of the time

Amazon QLDB vs Oracle NoSQL

Compared 10% of the time

CouchDB vs Oracle NoSQL

Compared 3% of the time

More Oracle NoSQL Competitors

Product Reports

OpenText Analytics Database (Vertica)

Download OpenText Analytics Database (Vertica) product report

OpenText Analytics Database (Vertica) report

NoSQL Databases

Download Oracle NoSQL product report

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

No data available

Overview

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?

Fast Data Loading: Quickly ingests large data volumes.
Columnar Storage: Optimizes storage efficiency and speed.
OLAP Support: Provides robust analytics capabilities.
Advanced Compression: Enhances storage efficiency and performance.
Parallel Data Ingestion: Enables faster data processing.
Fault Tolerance: Ensures high availability and reliability.

What benefits should users expect?

Cost Efficiency: Low cost per TB is advantageous.
Scalability: Accommodates growing data needs seamlessly.
Integration Flexibility: Works well with BI tools like Tableau.
Real-Time Reporting: Delivers immediate insights for decision-making.

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.

OpenText

Oracle NoSQL is known for its distributed architecture, which ensures scalability and high availability, making it ideal for handling substantial data across diverse applications.

Oracle NoSQL leverages its distributed nature to offer automatic load balancing and powerful schema evolution tools. With features such as a Java table API and seamless integration with Oracle Database, it efficiently manages unstructured data and supports high read/write operations. Departments dealing with large-scale data benefit from fast data retrieval and effective data replication, with support agreements facilitating easy management.

What are Oracle NoSQL's key features?

Distributed Architecture: Ensures data availability and scalability.
Automatic Load Balancing: Distributes workloads evenly across servers.
Table API for Java: Facilitates integration with Java applications.
Powerful Schema Evolution: Allows changes without downtime.
Efficient Data Replication: Supports high availability and disaster recovery.

What benefits should users expect?

High Performance: Fast data retrieval for large datasets.
Seamless Integration: Compatibility with Oracle Database enhances usability.
Easy Data Management: Simplifies handling of unstructured data.
Scalability: Supports future data growth effortlessly.

In telecom solutions, Oracle NoSQL helps store structured data and logs, supporting relational databases. It plays a crucial role in banking by managing over 900 gigabytes of data, facilitating data fetching and updates efficiently. Its implementation across infrastructure and web applications highlights its robustness in varied use cases.

Oracle

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

Airbus, Globacom, WebAction

OpenText Analytics Database (Vertica) vs. Oracle NoSQL