HP Vertica Essentials

More Information
  • Successfully install Vertica
  • Manage clusters in Vertica
  • Create backups and restore databases
  • Master different techniques to improve performance
  • Understand the concept of projections in Vertica
  • Make effective projections in Vertica
  • Monitor performance in Vertica
  • Get to grips with the concept of bulk loading in Vertica

With the rise of Massively Parallel Processing (MPP) and NewSQL databases, many users are confused about which MPP technology to opt for. Today, HP Vertica is gaining a lot of traction as a major MPP technology. Vertica's distributed architecture allows fast query processing, and it is a highly fault-tolerant architecture, thus making it one of the most sought-after MPP databases today.

HP Vertica Essentials will help you to learn day-to-day administration activities in a step-by-step format. You will start by learning how to install Vertica, followed by its management and monitoring. You will learn about the different backup and restore techniques, including the concept of projections in Vertica. Finally, you will explore the various techniques to improve performance and bulk loading in Vertica. By the end of this book, you will be able to install, manage, and monitor Vertica efficiently.

  • Learn cluster management and techniques to improve performance in Vertica
  • Deploy local segmentation and get to grips with the concept of projections
  • A simple, step-by-step guide covering the common administration-related activities in HP Vertica
Page Count 106
Course Length 3 hours 10 minutes
ISBN 9781782171560
Date Of Publication 14 May 2014


Rishabh Agrawal

Rishabh Agrawal is currently working as a senior database research engineer and consultant at Impetus India. He has been tinkering with databases since 2010 and has gained expertise in a variety of NoSQL, massively parallel processing (MPP), and relational databases in the Big Data domain in a short span of time. A MongoDB Certified DBA, he has working knowledge of more than 20 databases, namely Cassandra, Oracle NoSQL, FoundationDB, Riak, Gemfire, Gemfire XD, HBase, Hive, Shark, HP Vertica, Greenplum, SQL Server 2008 R2, and so on. His primary focus areas are research and evaluation of new and cutting-edge database technologies and consulting with clients on the strategic use of diverse database technologies.

When not at work, he revels in photographing vivid subjects, playing badminton, writing poems, and dancing. You can connect with him on LinkedIn at in.linkedin.com/pub/rishabh-agrawal/15/ab4/186.