Vertica Wins the Gold in Bloor Market Update

Know Your Options for Analytical Databases and Data Warehouses For CDOs and CIOs, there have never been more options to choose from when deciding where to run their analytical workloads. Analytical databases and data warehouses are two popular options – with the data warehouse market experiencing 10% annual growth and many new entrants* – particularly...

Vertica for Time Series Analytics and IoT

When you want to make a prediction – stocking levels for items in your store, predicting energy usage so supply is ready, or being proactive about equipment failures – those predictions often rely on time-series data, a series of data points measuring the same signal or process through time. By analyzing that data, companies can...

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...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

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.

Explore Popular Topics

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...
Programmer

Optimizing Big Data Storage in Vertica

With the explosion of data volumes all enterprises are capturing, new technological solutions, such as Vertica, offer a solution to non-expert users who need to analyze and monetize their Big Data. If you are a non-expert user, the Database Designer (DBD) module in Vertica can help you choose a physical database design that minimizes storage...

Facebook and Vertica: A Case for MPP Databases

I have just come back from a business trip to China where I visited several large Chinese telecom customers to talk about the recent big Vertica win at Facebook. Two questions these customers had constantly asked me were: What?s the future of MPP databases? Will Hadoop become one database that rules the whole analytic space?