Vertica Blog

Vertica Blog

Vertica Blog

Workload Management Metrics ? A Golden Triangle

Modern databases are often required to process many different kinds of workloads, ranging from short/tactical queries, to medium complexity ad-hoc queries, to long-running batch ETL jobs to extremely complex data mining jobs (See my previous blog on workload classification for more information.) DBAs must ensure that all concurrent workload, along with their respective Service Level...

Is Big Data Giving You Grief? Part 1: Denial

My father passed away recently, and so I?ve found myself in the midst of a cycle of grief. And, in thinking about good blog topics, I realized that many of the organizations I?ve worked with over the years have gone through something very much like grief as they?ve come to confront big data challenges?and the...

The Automagic Pixie

In previous installments of this series, I de-bunked some of the more common myths around big data analytics. In this final installment, I?ll address one of the most pervasive and costly myths: that there exists an easy button that organizations can press to automagically solve their big data problems. I?ll provide some insights as to...

Live Aggregate Projections with Vertica

The Dragline release of Vertica offers an exciting new feature that is unique in the world of big data analytics platforms. We now offer Live Aggregate projections as part of the platform. The impact is that you can really fly through certain types of big data analytics that typically grind down any analytics system.

Building Bridges with Gumdrops and Toothpicks

In June 2014, the Vertica summer interns headed to the East End House in East Cambridge, MA to work with students through a community service project. Sarah Perkins, a business planner on the Project Management team, organized the project. Since 1875, the East End House has offered innovative programs to the community and continues to...

The Single-Solution Elf

In this part of the de-mythification series, I’ll address another common misconception in the big data marketplace: that there exists a single piece of technology that will solve all big data problems. Whereas the first two entries in this series focused on market needs, this will focus more on the vendor side of things in terms of...

A Method for Vertica Workload Classification

Modern analytic databases such as Vertica often need to process a myriad of workloads ranging from the simplest primary-key lookup to complex analytical queries that include dozens of large tables and joins between them. Different types of load jobs (such as batch type ETL jobs and near real-time trickle loads) keep the data up-to-date in...

Tech Support Series: Optimizing for Deletes

This blog is just the first in a series that addresses frequently asked tech support questions. For now, we?ll talk about optimizing your database for deletion.

The Unstructured Leprechaun

In this, the second of the multi-part ?de-mythification? series, I?ll address another common misconception in the Big Data marketplace today ? that there are only two types of data an enterprise must deal with for Big Data analytics ? structured and unstructured, and that unstructured data is somehow structure-free.
Three 3D arrows, different colors pointing in different directions

The Real-Time Unicorn

In the first of this multi-part series, I?ll address one of the most common myths my colleagues and I have to confront in the Big Data marketplace today: the notion of ?real-time? data visibility. Whether it?s real-time analytics or real-time data, the same misconception always seems to come up. So I figured I?d address this,...

How to make ROLLUP fly in Vertica?

ROLLUP is a very common Online Analytic Processing (OLAP) function and is part of ANSI SQL. Many customers use ROLLUP to write reports that automatically perform sub-total aggregations across multiple dimensions at different levels in one SQL query.

Inside the Secret World of the Workload Analyzer

When I?m on a flight sitting next to someone, and we?re making polite conversations, often the question comes up ?what do you do?? In these situations, I have to assess whether the person works in the IT industry or is otherwise familiar with the lingo. If not, my stock response is ?I fix databases?. This...