HP Vertica

HP Vertica
Name	HP Vertica
Developer	Hewlett Packard Enterprise
Initial release	2005
Latest release	2020s
Written in	C++
Operating system	Linux
Genre	Columnar analytics database
License	Proprietary

HP Vertica HP Vertica is a commercial, column-oriented, massively parallel processing (MPP) analytical database designed for large-scale analytics and real-time data warehousing. Originating from an academic project, the platform targets use cases in online advertising, finance, telecommunications, and cloud services, emphasizing high-throughput ingest and low-latency analytical queries. Vendors and enterprises often deploy it alongside products from Amazon Web Services, Google Cloud Platform, Microsoft Azure, and infrastructure from Hewlett Packard Enterprise partners.

History

Vertica emerged from academic research at Massachusetts Institute of Technology and was founded by alumni associated with projects that involved Michael Stonebraker-style columnar innovations and work influenced by PostgreSQL research. The company behind Vertica attracted investment from firms like Sequoia Capital and partnerships with technology organizations including Intel Corporation and Cisco Systems. In 2011, Vertica was acquired by Hewlett-Packard and later became integrated into Hewlett Packard Enterprise following corporate restructuring. Over time it evolved to interoperate with cloud providers such as Amazon Web Services, Google Cloud Platform, and Microsoft Azure and to complement ecosystems involving Hadoop, Apache Spark, and Kubernetes deployments.

Architecture and components

Vertica adopts a distributed, shared-nothing architecture inspired by research from institutions like Massachusetts Institute of Technology and companies such as Teradata and Netezza. Core components include the Management Console, the Analytic Database engine, and the K-safety replication model influenced by concepts used in systems from Oracle Corporation and IBM. The system uses a cluster of nodes running on commodity servers from vendors like Dell Technologies or Hewlett Packard Enterprise, coordinated with services comparable to Zookeeper or orchestration platforms such as Kubernetes when deployed in cloud-native configurations. Integration adapters and connectors exist for tools including Tableau, Looker, Qlik, MicroStrategy, and ETL platforms like Informatica and Talend.

Data storage and query processing

Vertica stores data in a columnar format similar to designs by C-Store researchers and contemporaries such as MonetDB and ClickHouse. It uses projections—physical layouts that combine sorted columns and encoding schemes—paralleling indexing strategies from systems like Teradata and SAP HANA. Compression techniques draw on algorithms and libraries developed by organizations like Google and Facebook to reduce I/O. Query processing relies on an MPP engine that parallels query planners found in PostgreSQL, with execution strategies comparable to those in Apache Impala and Presto. The optimizer uses statistics and cost models akin to approaches from Microsoft SQL Server and Oracle Database to select execution plans across distributed nodes.

Performance and scalability

Vertica emphasizes linear scale-out for analytic workloads, a goal shared with Amazon Redshift, Snowflake, and Greenplum. Techniques such as predicate pushdown, vectorized execution similar to approaches by HyPer and MonetDB, and data locality strategies echo practices used by Cloudera and MapR. K-safety and replication models provide resilience comparable to solutions from Cassandra and HBase. Performance benchmarking often references industry-standard tools and workloads from organizations like TPC and comparisons with platforms including IBM Db2 and Teradata for mixed and pure analytic workloads.

Security and administration

Security and administrative features mirror enterprise expectations found in Oracle Corporation and Microsoft. Vertica supports authentication integrations with LDAP and Active Directory and encryption at rest and in transit influenced by standards from NIST and implementations used by OpenSSL. Role-based access control and auditing capabilities are comparable to governance tools from Splunk and IBM Security. Administrative tooling, including backup, restore, and resource management, integrates with orchestration platforms and monitoring solutions such as Prometheus and Grafana and enterprise schedulers like Apache Airflow.

Use cases and deployments

Enterprises deploy Vertica for real-time analytics in industries including advertising platforms like The Trade Desk, finance firms akin to Goldman Sachs, telecommunications operators similar to AT&T, and IoT analytics initiatives reminiscent of Bosch. Common applications include clickstream analysis, fraud detection (as practiced by Visa and Mastercard), customer 360 analytics comparable to implementations at Salesforce, and log analytics paralleling use cases at Splunk. Deployments span on-premises clusters built on servers from Dell Technologies or Hewlett Packard Enterprise, private clouds using OpenStack, and public clouds such as Amazon Web Services, Microsoft Azure, and Google Cloud Platform.

Commercial editions and licensing

Vertica is offered under commercial licensing models maintained by Hewlett Packard Enterprise, with editions that vary in features, support levels, and cloud integration options similar to the tiered offerings from Red Hat and Cloudera. Licensing typically covers software entitlements, enterprise support, and professional services, with alternatives including subscription-based cloud consumption models comparable to Amazon Web Services Marketplace listings and managed services offered by system integrators like Accenture and Deloitte.

Category:Column-oriented databases