• Product
    • Product Overview
    • On-Premises
    • In the Clouds
    • Machine Learning
    • On Hadoop
    • Data Security
    • Voltage SecureData for Vertica
    • Services for Success
  • Solutions
    • Vertica Solutions
    • Communication and Network Analytics
    • Customer Behavior Analytics
    • Data Warehouse Modernization
    • Embedded Analytics
    • Fraud Monitoring and Risk Management
    • Internet of Things (IoT) Analytics
    • Time Series Analytics
  • Partners
    • Partners Overview
    • OEMs
    • System Integrators / Resellers
    • Technology Partners
  • Resources
    • Resource Library
    • Customer Case Studies
    • Webcasts
    • Blog
    • Demos
    • Documentation
      • Product Documentation
      • Knowledge Base
      • Technology Partner Integrations
      • Troubleshooting Checklists
      • Quickstarts
  • About
    • About Vertica
    • Careers
    • Events
    • Newsletters
    • News
  • Support
    • Downloads
      • Community Edition
      • Client Drivers
      • Customer Downloads
      • Vertica By the Hour on AWS
    • Documentation
      • Product Documentation
      • Knowledge Base
      • Technology Partner Integrations
      • Troubleshooting Checklists
      • Quickstarts
    • Vertica Academy
    • User Forum
    • Patches
    • Support Requests
    • Support Chat
  • Try Vertica

  • View My Dashboard
  • Contact Us
  • Blog
  • User Forum
  • Vertica Academy
Vertica
  • View My Dashboard
  • Contact Us
  • Blog
  • User Forum
  • Vertica Academy
Vertica
  • Product
    • Product Overview

      Vertica delivers the fastest, most scalable unified analytics warehouse.

      Learn More

    • Product
      • On-Premises
      • In the Clouds
      • Machine Learning
      • On Hadoop
      • Open Source Innovation
      • Data Security
      • Services for Success
    • Product Resource

      Vertica 10 is Now Available

      Delivering unified predictive analytics at massive scale.

      Read the Data Sheet
  • Solutions
    • Solutions Overview

      Addressing the broadest range of analytical use cases across industries.

      Learn More

    • All Solutions
      • Communication and Network Analytics
      • Customer Behavior Analytics
      • Data Warehouse Modernization
      • Embedded Analytics
      • Fraud Monitoring and Risk Management
      • Internet of Things (IoT) Analytics
      • Time Series Analytics
    • Solutions Resource

      Vertica Returns $4.07 for Every Dollar Spent

      Nucleus Research proves Vertica delivers best value for highest performance.

      Try the Benefits Calculator
  • Partners
    • Partners Overview

      Tight integration with and support from leading technology and solution providers.

      Learn More

    • Partners
      • OEMs
      • System Integrators / Resellers
      • Technology Partners
    • Partners Resource

      Vertica Inside – Embedded Analytics at Scale

      Seize the huge growth opportunity for OEM software developers.

      Read the White Paper
  • Resources
    • Resources
      • Resource Library
      • Customer Case Studies
      • Webcasts
      • Blog
      • Demos
      • Videos
    • Documentation
      • Product Documentation
      • Knowledge Base
      • Technology Partner Integration
      • Troubleshooting Checklists
      • Quickstarts
    • Webcast Series
      • Data Disruptors Webcast Series
      • Under the Hood Webcast Series
    • Resources Menu Resource

      Vertica Earns Top Leader Position in GigaOm Data Warehouse Report

      Vertica placed in top tier for excellent concurrent loading and query performance.

      Read the Report
  • About
    • About Vertica

      Built for Fast. Built for Freedom.

      Learn More

    • About Vertica
      • Careers
      • Events
      • Newsletters
      • In the News
    • About Resource

      Vertica Big Data Conference 2020

      Hear sessions from The Trade Desk, Philips, and our engineers.

      View All the Recorded Sessions
  • Support
    • Downloads
      • Community Edition
      • Client Drivers
      • Customer Downloads
      • Vertica By the Hour on AWS
    • Documentation
      • Product Documentation
      • Knowledge Base
      • Technology Partner Integration
      • Troubleshooting Checklists
      • Quickstarts
    • Support Links
      • Vertica Academy
      • User Forum
      • Patches
      • Support Requests
      • Support Chat
    • Support Resource

      Access Subscription-Based Pricing

      New customers eligible for a 50% discount.

      Act Now
  • Try Vertica

The Secrets behind Vertica

Columnar Storage

Vertica differs from standard RDBMS in the way that it stores data.  By grouping data together on disk by column rather than by row, Vertica reads just the columns referenced by the query, instead of scanning the whole table as row-oriented databases must do. This speeds up query processing dramatically by reducing disk I/O.

Think all Column Store Databases are the same? Read this Whitepaper to learn about twelve critical capabilities that give a native column-store database superior performance and massive scale over legacy technologies.

Compression

By grouping data together on disk by column, Vertica creates the perfect scenario for data compression—lots of similar or repetitive values can be compressed very aggressively. Vertica features a library of many compression algorithms, which it applies automatically based on data type. Typically, the data in Vertica occupies up to 90% less disk space than the data loaded into it. This not only lowers storage costs, but also speeds up querying by further reducing disk I/O.

MPP Architecture

Vertica’s architecture is a “shared-nothing,” distributed database designed to work on almost any platform, including clusters of inexpensive, off-the-shelf servers, Amazon and Azure Cloud servers, and Hadoop. Its performance can not only be tuned with features like resource pools and projections, but it can be scaled simply by adding new servers to the cluster. Clustering speeds up performance by parallelizing querying and loading across the nodes in the cluster for higher throughput.

These architectural differences—column storage, compression, MPP Scale-Out architecture and the ability to distribute a query are what fundamentally enable analytic applications based on Vertica to scale seamlessly and offer many more users access to much more data.

Every company’s data is different.  We asked our customers how much Vertica boosted query performance over their former database and here are the results.

Read the Aberdeen Report: The Columnar Advantage: Speed, Firepower, and User Empowerment for SQL Analytics

  • Have a question?
  • Contact us
  • Privacy / Cookies
  • Twitter
  • LinkedIn
  • Returning Customer?
  • Vertica Russia
  • Vertica Japan
  • Vertica China

  • Product
    • On-Premises
    • Vertica in the Clouds
    • Machine Learning
    • On Hadoop
    • Open Source Innovation
    • Services for Success
  • Downloads
    • Client Drivers
    • Community Edition
    • Customer Downloads
    • Quickstarts
    • Vertica By the Hour on AWS
  • Documentation
    • Knowledge Base
    • Technology Partner Integrations
    • Troubleshooting Checklists
  • Solutions
    • Communication and Network Analytics
    • Customer Behavior Analytics
    • Data Warehouse Modernization
    • Embedded Analytics
    • Fraud Monitoring and Risk Management
    • Internet of Things (IoT) Analytics
    • Time Series Analytics
  • Partners
  • Resources
    • Customer Case Studies
    • Demos
    • Webcasts
    • Knowledge Base
    • News
    • Newsletters
    • Quickstarts
  • About
    • Careers
    • Events
    • Newsletters

© 2021 Micro Focus

Your choice of cookies on this site

We use cookies to give you the best possible online experiences. You can change your consent choices at any time by updating your cookie settings.

Cookie Privacy Manager

Some essential features on Vertica.com won't work without certain cookies. Other cookies help improve your experience by giving us insights into how you use our site and providing you with relevant content. For more information, please check out our cookie policy here.

Strictly Necessary

ON

These cookies provide a secure login experience and allow you to use essential features of the site

Analytics / Performance

Analytics cookies allow us to improve our website by giving us insights into how you interact with our pages, what content you're interested in, and identifying when things aren't working properly. The information collected is anonymous.

Targeting

We use targeting cookies to test new design ideas for pages and features on the site so we can improve your experience. We also collect information about your browsing habits so we can serve up content more relevant to your interests. Disabling these cookies would mean the content you see on the site might not be as relevant to you.