Vertica Blog

Vertica Blog

performance

Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for data analysis. How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with...

Constellation Research Report Finds Vertica 10 a Leading Choice

A few pages into a new, detailed overview of Vertica 10, produced by Constellation Research, principle analyst Doug Henschen summarizes the top new capabilities of Vertica 10 like this: In short, the Vertica team has steadily evolved the product to keep pace with the demands of organizations that seek to do the following: Unify diverse...
Return on Investment ROI

What’s the Deal with Vertica TCO?

Recently, a colleague of mine was trying to express why Vertica had such a low total cost of ownership (TCO). It’s not obvious. Our customers rave about the fast return on investment. We have a half dozen excellent case studies from third-parties showing Vertica’s ROI. But why? Open source options are free. Vertica isn’t free....

Vertica outperforms Redshift and Snowflake in third-party benchmark study

Vertica proven to be faster, more affordable, and more scalable in terms of concurrency in third-party benchmark over Amazon Redshift and Snowflake Choosing a cloud-based big data analytics platform for your organization’s analytical needs is seldom an easy task, and it can’t be the first step on your big data journey. Earlier steps should include...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...
Global Partitions

Optimizing Vertica Data With Partitions

How do partitions affect overall Vertica operations? Let’s look at a snapshot of the Flight Data Tracker dataset and compare performance ...
Larry Bird Monument - Photo by Eric Kilby WC

Practice Makes Perfect at BDC 2020

Larry Bird, Boston Celtics legend and NBA Hall of Famer, shot 500 free throws every morning before his first class in high school. But, he didn’t stop there. Larry was known to shoot 100 free throws after every NBA game. The result? The sharp-shooting forward from French Lick, Indiana led the NBA in free throw...
Brandeis University sign

Hands-on Class Makes Parallel Data Management Theories Concrete

Parallel data management in databases is a tough thing to learn when you’re a student. It can feel like another one of those esoteric theories, and it never quite sticks. Now, there’s a cool class at Brandeis University that brings those lofty theories down to earth, and gives students a real chance to see how...
Calculating ROI

Learn How Much Money Vertica Can Save Your Business

The ROI for software systems is notoriously tough to pin down. The effort to integrate new software with systems already in place often adds time and labor costs to the upfront investment. What’s more, if there is any cultural resistance to change, then the ROI can be impossible to measure for months or years, or...
3D render of a binary data stream flowing into a network server surrounded by clouds

Is Your Future Cloudy? This Buyer’s Guide Offers Clarity

When I started at Vertica about seven years ago, I was met by anxious sales people warning me that Hadoop (HDFS, specifically) was going to completely replace the enterprise data warehouse (EDW), as we knew it. And we should be very concerned. That was 2012, a year that I first encountered the lovable elephant and...

Are Your Columns too Wide?

This tip expands on the earlier post on encoding and compression at Checking and Improving Column Compression and Encoding When you have millions to billions of rows, data type becomes a bit more important: even an extra 10 bytes per row across a huge data set will impact storage or performance (or both!). When I...
Create Read Update Delete in red 3D letters surrounded by 3D ones and zeroes

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads (for example, through INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...