Vertica Blog

Vertica Blog

Vertica Blog

Vertica Best Practices: Identifying Queries for DBD

The Vertica Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The result is an optimized database with optimal query performance and data compression.

Vertica Storage Location for HDFS

Do you find yourself running low on disk space on your Vertica database? You could delete older data, but that sacrifices your ability to perform historical queries. You could add new nodes to your cluster or add storage to your existing nodes. However, these options require additional expense.The Vertica Storage Locations for HDFS feature introduced...

What Is a Range Join and Why Is It So Fast?

Last week, I was at the 2015 Conference on Innovative Data Systems Research (CIDR), held at the beautiful Asilomar Conference Grounds. The picture above shows one of the many gorgeous views you won't see when you watch other people do PowerPoint presentations. One Vertica user at the conference said he saw a ?range join? in...

Tech Support Series: Optimizing Projections

Welcome to another installment of our Top Tech Support Questions Answered blog series. In our first

New Configuration Parameter Storage and Setting Options

Vertica 7.1.x introduces a new way to store and set configuration parameters.Previously, configuration parameter values were stored in individual vertica.conf files on each node. As of Vertica 7.1.0, these values are stored in the database catalog, allowing the values to stay consistent over all nodes.

Optimizing for Merge Join

In an earlier post,
Three 3D arrows, different colors pointing in different directions

Backing Up and Restoring Your Vertica Database

Backing up and restoring your database is an important part of basic database maintenance. Vertica lets you create both comprehensive and object-level backups. This article highlights the Vertica 7.x features that enhance the backup and restore process.

Is Big Data Giving You Grief? Part 5: Acceptance

Over the last month or so, this series has discussed how organizations often deal with a missed big data opportunity in ways that closely resemble the grieving process, and how that process maps to the commonly understood five stages of grief: denial, anger, bargaining, depression, and acceptance. This is the last entry in the series;...
Programmer

Is Big Data Giving You Grief? Part 4: Depression

Continuing the five part series which explores how organizations coping with big data often go through a process that closely resembles grief, this segment addresses the point at which the organization finally grasps the reality of big data and realizes the magnitude of the opportunity and challenge?and gets depressed about the reality of it.

Is Big Data Giving You Grief? Part 3: Bargaining

Continuing the five part series about the stages of big-data grief that organizations experience, this segment focuses on the first time organizations explore the reality of the challenges and opportunities presented by big data and start to work their way forward?with bargaining.

Is Big Data Giving You Grief? Part 2: Anger

Continuing this five part series focused on how organizations frequently go through the five stages of grief when confronting big data challenges, this post will focus on the second stage: anger.

Physical Design Automation in the Vertica Analytic Database

Automatic physical database design is a challenging task. Different customers have different requirements and expectations, bounded by their resource constraints. To deal with these challenges in Vertica, we adopt a customizable approach by allowing users to tailor their designs for specific scenarios and applications. To meet different customer requirements, any physical database design tool should...