Vertica Blog

Vertica Blog

Vertica Blog

The Unstructured Leprechaun

Walt_Maguire
June 9, 2014

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

Walt_Maguire
June 2, 2014

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?

Po Hong
May 22, 2014

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.
Modern Database Analytics

Inside the Secret World of the Workload Analyzer

Curtis_1
May 6, 2014

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

ramakrishna
April 29, 2014

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

Po Hong
April 18, 2014

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?

Can Vertica Climb a Tree?

Po Hong
March 24, 2014

The answer is YES if it is the right kind of tree. Here ?tree? refers to a common data structure that consists of parent-child hierarchical relationship such as an org chart. Traditionally this kind of hierarchical data structure can be modeled and stored in tables but is usually not simple to navigate and use in...

Enter the Flex Zone – Under the Hood

Ben Vandiver
February 14, 2014

With Vertica's latest release (Vertica 7 Crane"), we introduced Vertica Flex Zone, based on the patent-pending flex tables technology, which dynamically adapt to whatever schema is present in the data. Flex tables offer dramatic usability improvements over regular tables. In this post, we take a look under the hood and show how flex tables are...
Database Server Room

Enter the FlexZone – Let’s talk ETL

Steve Sarsfield, Vertica Senior Product Marketing Manager – Partner Ecosystem
January 30, 2014

In December, HP released version 7 of the Vertica analytics platform which includes, among others, a great new feature called Vertica Flex Zone (Flex Zone). Flex Zone enables you to quickly and easily load, explore and analyze some forms of semi-structured data. It eliminates the need for coding-intensive schemas to be defined or applied before...

Enter the Flex Zone – Exploring Delimited Data

Ben Vandiver
January 22, 2014

Here at Vertica, we had to solve a technical challenge that many of you might be facing: data analysis from legacy products.

Welcome to the Flex Zone – Dynamic Schemas

Ben Vandiver
January 15, 2014

Much of the data analytics we perform occurs with data whose schema changes over time. Many organizations have developers who define the record types that are collected and analysts who comb through these records looking for important patterns. In today's fast-changing business landscape, agility is the key to success: developers need to continually define new...

Enter the Flex Zone –– An Exploration in Processing Twitter Data

Ben Vandiver
January 13, 2014

With our