Vertica Analytic Database Review - why 4.1 stars?

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

Frequently Asked Questions (FAQs)

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.