Vertica Blog

Vertica Blog

Vertica Blog

Time Series Analytics: The Hunt for “Missing Link” in Data

Sarah Lemaire, Manager, Vertica Documentation
May 12, 2015

Time series analytics is a little-known, but very powerful Vertica tool. In Vertica, the TIMESERIES clause and time series aggregate functions normalize data into time slices. Then they interpolate missing values that fill in the gaps.Using time series analytics is useful when you want to analyze discrete data collected over time, such as stock market...
Three 3D arrows, different colors pointing in different directions

Always Have a Backup Plan

Sarah Lemaire, Manager, Vertica Documentation
May 6, 2015

Why should you always have a backup plan? Because something, inevitably, goes wrong. Whether you experience something as simple as a deleted record, or as serious as a full system deletion, you need a backup.
Modern Database Analytics

Configuring Vertica for a Multi-Tenant Solution

Curtis_1
April 27, 2015

One of the more interesting and popular Vertica solutions that I've come across is the so-called multi-tenant implementation. A multi-tenant database is simply a database designed to support multiple unique customers. Often, these customers interact with the database through some sort of web interface which uses an Vertica database in the backend.

For Your Eyes Only: Using Vertica Access Policies

Sarah Lemaire, Manager, Vertica Documentation
April 8, 2015

Everyone knows there?s virtually no limit to the amount of data you can store, manage, and query in Vertica. But you may not be aware of how easy it is to control who sees what in your database. In this blog, Alexey Kireyev, the lead security developer for Vertica, explains how you can use the...
Database Server Room

Vertica Best Practices: Identifying Queries for DBD

Sarah Lemaire, Manager, Vertica Documentation
March 26, 2015

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

Sarah Lemaire, Manager, Vertica Documentation
January 27, 2015

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?

ChuckB
January 20, 2015

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

Sarah Lemaire, Manager, Vertica Documentation
December 10, 2014

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

New Configuration Parameter Storage and Setting Options

Sarah Lemaire, Manager, Vertica Documentation
December 3, 2014

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

NorbertK
October 22, 2014

In an earlier post,
How to Backup Vertica Database

Backing Up and Restoring Your Vertica Database

Sarah Lemaire, Manager, Vertica Documentation
September 24, 2014

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

Is Big Data Giving You Grief? Part 5: Acceptance

Walt_Maguire
August 18, 2014

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