Vertica
A unified analytics platform for high-speed, real-time data analysis at massive scale.
Architecture
Shared-Nothing MPP
Data Storage
Column-Oriented
Deployment
Cloud, On-Premises, Hybrid
Acquired By
Hewlett-Packard (2011), now part of Micro Focus
About Vertica
Vertica provides a high-performance, scalable analytics platform with a columnar storage architecture that significantly speeds up query execution. Its MPP architecture distributes processing across a cluster of servers, enabling it to handle massive data volumes and high-concurrency workloads. Key features include in-database machine learning, advanced analytical functions, and Vertica in-Place Analytics (formerly known as SQL on Hadoop), which allows querying data directly on HDFS. It is designed for use cases such as customer analytics, financial services risk analysis, IoT data processing, and network monitoring, offering deployment flexibility across on-premises, cloud, and hybrid environments.
Core Features
Massive Parallel Processing (Mpp)
Distributes data and query workload across a cluster of nodes for high-speed performance.
Columnar Storage
Optimizes analytical query performance and improves data compression ratios.
Vertica In-Place Analytics
Query data directly in-place on other systems like HDFS and S3 without data loading.
In-Database Machine Learning
Build, train, and deploy machine learning models directly within the database.
Advanced Analytics
Includes built-in functions for time series, pattern matching, geospatial, and statistical analysis.
Connectivity & Integration
Client Libraries
Provides ODBC, JDBC, and ADO.NET drivers for connecting various applications.
Ecosystem Integrations
Integrates with BI tools (Tableau, Power BI), ETL tools (Informatica, Talend), and big data systems (Spark, Kafka).
Primary Interface
SQL (vSQL client)