Cassandra vs OpenText Analytics Database (Vertica) comparison

Cassandra vs. OpenText Analytics Database (Vertica)

Download the complete report

Helped 858,435 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

Cassandra

Average Rating

8.0

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

NoSQL Databases (6th), Vector Databases (14th)

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

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

Q&A Highlights

it_user1272297

Special Adviser Strategy at a university with 501-1,000 employees

Apr 19, 2020

Which is the best RDMBS solution for big data?

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

Well-equipped to handle a massive influx of data and billions of requests

Featured Reviews

Himanshu Amodwala

Senior cloud solution architect at Microsoft

The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time updates is paramount. For instance, when a customer leaves comments or feedback on an image, they anticipate an immediate reflection of these changes on the portal. Similarly, sellers altering product attributes or updating images expect instant visibility of these modifications. Handling large data volumes with Cassandra has been an excellent experience. Despite challenges related to the influx, these were not attributed to Cassandra itself but rather to middle-layer issues. Generally, it demonstrated scalability with workloads, thanks to its horizontal scaling capabilities. We could easily add new nodes to the system as needed, ensuring the platform coped well with increasing loads. The tool's most beneficial feature for scalability is its entire architecture. The absence of a single point of failure or a leader within the ecosystem contributes to its robust scalability. This key aspect influenced our decision to opt for the Cassandra ecosystem. In terms of performance, it demonstrated the ability to handle approximately 1.6 billion requests per day. This was achieved on AWS using EC2 instances, and it was during a period about four to five years ago.

Read full review

T Venkatesh

Deputy Manager at ICICIBANK Ltd

Processes query faster through multiple systems simultaneously, but it could support different data types

We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

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

"The most valuable feature of Cassandra is its fast retrieval. Additionally, the solution can handle large amounts of data. It is the quickest application we use."

"Some of the valued features of this solution are it has good performance and failover."

"We can add almost one million columns to the solution."

"Can achieve continuous data without a single downtime because of node to node ring architecture."

"Its retrieval is similar to an RDBMS, so our team finds it easy to adapt."

"The solution's database capabilities are very good."

"The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time updates is paramount."

"The most valuable features are the counter features and the NoSQL schema. It also has good scalability. You can scale Cassandra to any finite level."

More Cassandra pros

"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."

"Allows us to take volumes and process them at a very high speed."

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

"The performance is very good and the aggregate records are fast."

"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."

"The solution is quick, has good compression data, and is not expensive."

"Speed and resiliency are probably the best parts of this product."

"I enjoy the cybersecurity and backup features."

More OpenText Analytics Database (Vertica) pros

Cons

"The solution doesn't have joins between tables so you need other tools for that."

"The disc space is lacking. You need to free it up as you are working."

"The secondary index in Cassandra was a bit problematic and could be improved."

"I want Cassandra to update its open-source version more quickly. It's already feature-rich, but I'd appreciate better integration with other NoSQL databases like MariaDB or MongoDB. If I ever need to work with customers or vendors using different NoSQL databases, having native integration in Cassandra would make managing and interacting with their databases much easier."

"Maybe they can improve their performance in data fetching from a high volume of data sets."

"The initial setup of Cassandra can be difficult in the configuration. There might be a need to have assistance. The implementation process can six months for connecting to certain databases."

"It can be difficult to analyze what's going on inside of the database relative to other databases. It can also be difficult to troubleshoot sometimes."

"Cassandra can improve by adding more built-in tools. For example, if you want to do some maintenance activities in the cluster, we have to depend on third-party tools. Having these tools build-in would be e benefit."

More Cassandra cons

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

"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."

"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."

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

"Vertica can improve automation and documentation. Additionally, the solution can be simplified."

"The integration with AI has room for improvement."

"Vertica's native cloud support could be improved, and its installation could be made easier."

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

More OpenText Analytics Database (Vertica) cons

Pricing and Cost Advice

"There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."

"I use the tool's open-source version."

"Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."

"We are using the open-source version of Cassandra, the solution is free."

"We pay for a license."

"I don't have the specific numbers on pricing, but it was fairly priced."

"The solution is relatively cost-effective."

"The pricing and licensing depend on the size of your environment and the zone where you want to implement."

"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."

"The pricing for this solution is very reasonable compared to other vendors."

"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."

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

"From a cost perspective, the software is less than most of its competitors."

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

More OpenText Analytics Database (Vertica) pricing and cost advice

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

858,435 professionals have used our research since 2012.

Answers from the Community

it_user1272297

Special Adviser Strategy at a university with 501-1,000 employees

Apr 19, 2020

Which is the best RDMBS solution for big data?

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

2 out of 4 answers

Russell Rothstein

CEO at a tech company with 51-200 employees

Jan 27, 2020

Morten, the most popular comparisons of SQream can be found here: https://www.itcentralstation.com/products/sqream-db-alternatives-and-competitors The top ones include Cassandra, MemSQL, MongoDB, and Vertica.

Read full answer

reviewer1219965

Data Architect at a tech services company with 201-500 employees

Jan 27, 2020

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

Read full answer

See all 4 answers

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

15%

Comms Service Provider

Retailer

Financial Services Firm

19%

Computer Software Company

18%

Manufacturing Company

University

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Cassandra?

What is your experience regarding pricing and costs for Cassandra?

We are using Cassandra locally and as open-source.

What needs improvement with Cassandra?

While Cassandra can handle NoSQL, I think there should be more flexibility for whole schema design when data is stored in wide columns. Additionally, I believe that eventual consistency should be e...

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?

The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.

What needs improvement with Vertica?

The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.

More Cassandra Competitors

Comparisons

Couchbase vs Cassandra

Compared 14% of the time

MongoDB vs Cassandra

Compared 14% of the time

ClickHouse vs Cassandra

Compared 11% of the time

ScyllaDB vs Cassandra

Compared 8% of the time

InfluxDB vs Cassandra

Compared 6% of the time

SQL Server vs OpenText Analytics Database (Vertica)

Compared 14% of the time

Teradata vs OpenText Analytics Database (Vertica)

Compared 12% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 9% of the time

BigQuery vs OpenText Analytics Database (Vertica)

Compared 9% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 8% of the time

More OpenText Analytics Database (Vertica) Competitors

Product Reports

Cassandra

Download Cassandra product report

OpenText Analytics Database (Vertica)

Download OpenText Analytics Database (Vertica) product report

OpenText Analytics Database (Vertica) report

Also Known As

No data available

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

Overview

Cassandra is a distributed and scalable database management system used for real-time data processing.

It is highly valued for its ability to handle large amounts of data, scalability, high availability, fault tolerance, and flexible data model.

It is commonly used in finance, e-commerce, and social media industries.

Apache

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

Sample Customers

1. Apple 2. Netflix 3. Facebook 4. Instagram 5. Twitter 6. eBay 7. Spotify 8. Uber 9. Airbnb 10. Adobe 11. Cisco 12. IBM 13. Microsoft 14. Yahoo 15. Reddit 16. Pinterest 17. Salesforce 18. LinkedIn 19. Hulu 20. Airbnb 21. Walmart 22. Target 23. Sony 24. Intel 25. Cisco 26. HP 27. Oracle 28. SAP 29. GE 30. Siemens 31. Volkswagen 32. Toyota

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

Cassandra vs. OpenText Analytics Database (Vertica)