What are Vertica Engineers Reading?
Sarah Lemaire, Manager, Vertica Documentation
January 6, 2016
Ever wonder what Vertica engineers do when they aren?t busy building and perfecting an awesome product?
Restoring Objects from a Full Backup
Sarah Lemaire, Manager, Vertica Documentation
November 24, 2015
Before Vertica version 7.2, you had two options: perform full backups and restore full backups (remove everything from the storage unit) or perform object-level backups and restore those individually (maintain separate storage units). But as of Vertica 7.2, you can have the best of both worlds. You can perform full backups and restore individual objects...
Understanding ROS and WOS: A Hybrid Data Storage Model
Sarah Lemaire, Manager, Vertica Documentation
October 7, 2015
Vertica is unique in many ways, one of which can be seen in its data storage model. In this blog, we?ll go over each storage component and show you how to take advantage of Vertica?s storage options to optimize your database for writing and reading.
Sarah Lemaire, Manager, Vertica Documentation
September 9, 2015
During the summer of 2015, I participated in an internship program with Vertica. Most interns assisted in software development, but my primary goal was to use Vertica, Vertica Place, and HP Distributed R to address an ecological problem
Kerberos Authentication for Hadoop Integration: Keeping your data safe
Sarah Lemaire, Manager, Vertica Documentation
August 27, 2015
Like all Vertica releases, 7.1.2 includes a bunch of new features. One specific feature can help make your HDFS data safer: Kerberos integration for Hadoop. This blog will give you an overview of using Kerberos authentication with Vertica for SQL on Hadoop.
Vertica and Qlik Team Up to Hack for a Cause
Sarah Lemaire, Manager, Vertica Documentation
August 17, 2015
On November 17 2014, Vertica took part in the annual Qlik Hackathon in Orlando, Florida. The hackathon, which took place the day before the Qlik World Conference, brought together engineers, developers, and Qlik experts from all over the world. The challenge was simple: leverage features from Qlik and its partners to create an application to...
Best Practices for Refreshing Large Projections
Sarah Lemaire, Manager, Vertica Documentation
May 27, 2015
More than once I have worked with customers who need to update a superprojection or create a new projection for a large fact table. It seems like a simple and easy process: just create a projection and perform a refresh. However, refreshing projections for large fact tables can produce unwanted complications. In this blog, we?ll...
Sarah Lemaire, Manager, Vertica Documentation
May 19, 2015
We talk a lot about database security and how you can protect your sensitive data from outside threats. But what about internal, unintentional data corruption? What if the data you are trying to analyze or manipulate is simultaneously being manipulated by another transaction? A scenario such as this could lead to data loss and inconsistency....
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...
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.
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...
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.