Vertica Analytic Database Review - why 4.1 stars?

Vertica Analytic Database Review
ITQlick Score: 86/100
ITQlick Rating:
Pricing: 4.4/10 - average cost
Category: Business Intelligence -> Vertica Analytic Database review
Ranking:Ranked 33 out of 532 Business Intelligence systems
Company: HP VERTICA
Typical customers: Small, medium and large size businesses
Platforms: Desktop
Links: Vertica Analytic Database pricing, Vertica Analytic Database alternatives
Shlomi LaviShlomi Lavi / updated: Aug 18, 2022

We publish unbiased reviews. Our opinions are our own and are not influenced by payments from advertisers. This content is reader-supported, which means if you leave your details with us we may earn a commission. Learn why ITQlick is free .

What is Vertica Analytic Database?

Vertica Analytic Database is a cloud-based database management solution. With the hybrid in-memory architecture, the software offers real-time loading and querying. The software also provides proactive analysis of workload, query stream, schema, as well as any other statistics. Cluster management is another feature within the software that assists in data analytics by grouping data into clusters and managing those clusters.

Some other core features of Vertica Analytic Database include execution engine, graph traversal, live aggregation projections, querying, conclusive analytics, and many more. Vertica Analytic Database is a product launched by Vertica, a company based in the United States with over 10 years of experience within the big data analytics domain.

Who is it best for?

Customers of the software include businesses of all sizes and a wide range of types. Major industries where it can be used include technology and software development, automation and manufacturing, financial services, education, retail and wholesale, and others. Some notable clients of the software include Capital IQ, Thinking Phone Networks, Conclusive Analytics, and others.

Main features and functionalities

The software offers real-time loading and querying with its hybrid in-memory architecture. Compared to the traditional row-stores, Vertica facilitates as much as 10x faster data transfer speeds. The software offers various advanced analytical capabilities of native gap filling, interpolation, event window functions, graph traversal, and sessionization.

The database designer of Vertica offers proactive analysis of schema, query stream, workload, as well as other statistics. It also automates the physical design optimization process. Other important capabilities include cluster management, columnar storage and execution, aggressive data compression, automatic high availability, workload management, execution engine, third party integration, and others.

What is the actual cost?

ITQlick pricing score is 4.4 out of 10 (10 is most expensive). Access ITQlick pricing guide for Vertica Analytic Database. You can also find here pricing information from Vertica Analytic Database's website.

Pros

  • The columnar storage on Vertica helps load data faster, no matter the size
  • The software is easy to use and set up
  • Vertica offers advanced analytics with geospatial and time series
  • Easy to integrate with other software products.

Cons

  • Some functions on Vertica become slow when data volume increases
  • Cluster-to-cluster data transfers are sometimes difficult to carry out

How it stacks up?

Access a head to head analysis of Vertica Analytic Database vs alternative software solutions.
ITQlick rating
Score
Pricing
License pricing
Functionality
Review
Compare
Vertica ...
ITQlick rating
4.1/5
Score
86/100
Pricing
4.4/10
License pricing
Pricing not available
Functionality
5
Compare
Qlik Sen...
ITQlick rating
4.3/5
Score
95/100
Pricing
3/10
License pricing
$30 per user/month
Functionality
15
SuiteAna...
ITQlick rating
4.1/5
Score
94/100
Pricing
3/10
License pricing
$499 per month + $99 per user
Functionality
10
Sisense
ITQlick rating
4.6/5
Score
94/100
Pricing
4/10
License pricing
$83 per employee/month
Functionality
35
Infor Bi...
ITQlick rating
4/5
Score
92/100
Pricing
5.6/10
License pricing
$30,000 per 20 users/year
Functionality
43

Frequently Asked Questions (FAQs)

Is it the best Business Intelligence system?

Vertica Analytic Database is ranked 33 out of 532 software in their category (Business Intelligence systems).

How they are rated on ITQlick?

The rating of Vertica Analytic Database is 4.1 stars out of 5 and the total score is 86 out of 100. The rating score is based on our unbiased data-based algo. Learn more - rating methodology page.

Is it an easy to use Software?

Yes, Vertica Analytic Database makes it fairly easy to use. This product is user friendly and intuitive.

Is it cloud-based?

No, the software in not cloud based so you would need to install it locally and connect it directly to a server.

Can it be used on mobile?

No, currently Vertica Analytic Database can't be accessed on mobile, you would need to access it from your computer.

Differences between Vertica Analytic Database and alternatives?

The most popular alternatives to Vertica Analytic Database in 2023: Qlik Sense, SuiteAnalytics, Sisense, Infor Birst, Balanced Scorecard. Access the complete competitors analysis here - Vertica Analytic Database VS Business Intelligence Software alternatives.

Is Vertica Analytic Database right for you or your business?

Vertica Analytics Database is a business intelligence and database software for companies and enterprises across several industries, including AdTech, financial services, gaming, healthcare, Telecoms, etc. The software is highly scalable and can support large-scale data warehouse analytics. Some customers that use Vertica include Cerner, Taboola, and Vodafone.

List of categories

Data analysis
Data mining

List of features

Data Import/Export
Basic Reports
Online Customer Support

Auditor - Shlomi Lavi

Website Linkedin profile Facebook Twitter

Shlomi Lavi is an entrepreneur and founder of ITQlick.com. He holds a Bachelor of Science (B.Sc.) in Information Systems Engineering from Ben Gurion University in Israel. Shlomi brings 17 years of global IT and IS management experience as a consultant and implementation expert for small, medium and large-sized (global) companies. Shlomi’s goal is to share the best knowledge and news about information systems so you can make smarter buying decisions for your business.