This guide introduces the basic concepts to get you started in effectively designing, building, operating, and maintaining a Vertica database. This document assumes that you are familiar with the basic concepts and terminology of relational database management systems and SQL.
The Vertica Approach
The Vertica Analytic Database consists of the following key features:
Columnar Storage and Execution - column stores offer significant gains in performance, I/O, storage footprint, and efficiency when it comes to analytic workloads. With columnar storage the query only reads the columns needed to answer the query.
Real-time loading and querying - with high query concurrency and the ability to simultaneously load new data into the system, Vertica can load data up to 10X faster than traditional row-store databases.
Advanced Database Analytics - a set of Advanced In-Database Analytics allows you to conduct the analytics computations closer to the data. This provides immediate results from a single place without having to extract data from a separate environment.
Database Designer and Administration Tools - these features allow you to tune and control Vertica with minimal administration effort. For more information see About Database Designer and Using the Administration Tools.
Advanced Compression - aggressive encoding and compression allows Vertica to dramatically improve analytic performance by reducing CPU, memory, and disk I/O at processing time. Vertica can reduce the original data size to up to 1/10th its original size.
Massively Parallel Processing - a robust and scalable parallel processing solution provides active redundancy, automatic replication, failover, and recovery.
A mobile gaming company used to rely on a patchwork of technologies for data warehousing and business intelligence reporting.It took two to four hours to run a query on each game server. The search for a solution led the company to evaluate different companies for expanding its analytic capabilities. The Vertica implementation accomplished the following for the company:
- Queries were reduced from two to four hours to minutes or seconds
- Solution successfully met cloud deployment requirement
- Expanded data capacity from a few months to whole lifetime of data
This has led to better customer support by shortening response time to customer issues, as well as providing the ability to answer many more questions than before the Vertica implementation.