1.0 Overview

Vertica is an analytics database platform that is specifically built for Big Data analytics. Vertica is built for organizations that generate large volumes of data frequently. Compared to traditional relational database systems (RDBMS), Vertica provides faster query performance and scalability while analyzing these large volumes of data. The most important features of Vertica include:

  • Being a columnar database, it stores information in columns and only reads the columns required to answer a query.

  • Highly scalable as Vertica runs on a cluster of commodity hardware. As and when the volume of data generated increases, you can add more nodes to the Vertica cluster to increase processing speeds.

  • Compresses data size to a significant extent, which improves analytic performance while processing historical or trending data.

  • Queries and loads data on a real-time basis up to 10X faster than traditional RDBMS.

  • Efficiently handles multiple operations with multiple concurrent users.

Some other features include:

  • Supports standard programming interfaces that include ODBC, JDBC, ADO.NET, and OLEDB.

  • Uses database designer and administration that allows you to control Vertica with minimal administration effort.

  • Analyzes semi-structured data along with structured data.

For more information on the Vertica database, see the documentation available at www.vertica.com.