HP VERTICA

What is HP VERTICA

Vertica is an analytical database based on MPP architecture (massive parallel architecture). It’s a columnar database, where each column is a separate storage. It features high performance compared to traditional relational databases. It has a standard SQL interface with built-in analytical capabilities.

Advantages

High availability

Vertica ensures the database’s ability to continue running even if a node fails. Vertica automatically restores missing data by requesting other nodes.

Mass parallel processing

Vertica allows users to continuously upload real-time data to any node. The request will be evenly distributed and managed by designating one of the nodes as the initiator of the request, and the others as executors.

Automatic database design

For efficient automated database design, HP Vertica uses a database designer. When data is loaded into Vertica from a row storage data source, Vertica converts the data into column-based projections.

"Zero" administration

Vertica does not require administration or complex configuration during use.

Significant savings

You don’t need to spend significant money on adding DBA resources, replacing current DBMS and purchasing additional licences for them, and purchasing proprietary software and hardware systems.

User-friendly interface

Vertica has a standard SQL interface that is compatible with all analytical applications and supports ODBC, JDBC, ADO.NET connectors.

High compression ratio

Vertica doesn’t just store its data in columns, it does it rationally, with a high compression ratio to reduce storage costs and save disk space.