- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (3) from $41.76
-
New (3) from $41.76
Want a NOOK? Explore Now
With the rise of Massively Parallel Processing (MPP) or NewSQL databases, many users are confused about which MPP technology to opt for. Today, HP Vertica is gaining lot of traction as a major MPP technology. Vertica's distributed architecture allows fast query processing, and is a highly fault-tolerant architecture, thus making it one of the most sought-after MPP databases today.
This book will help you to learn the day-to-day administration activities in a step-by-step format. You will start with learning how to install Vertica, followed by its management, and monitoring. You will learn the different backup and restore techniques, including the concept of projections in Vertica. Finally, you will explore the 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.
For decades HP has been doing seminal work in computing. It is nice to see them at the top of their game with this offering in Massively Parallel Processing [MPP]. As the text explains, the rise of Big Data requires the ability to distribute the workload across many machines. Vertica's key differentiating feature, at least to me, is its use of column storage, instead of row storage as in most databases.
The accessing of entire rows in traditional database processing can be extremely inefficient if the SQL query only needs to operate on a few columns. The unused column data that is retrieved is a total waste. Vertica uses the concept of projections. So a query that explicitly accesses only a few fields [columns], which is typical of many queries, leads to far more efficient and faster processing.
The book also has explanations of ancillary Vertica management operations. Like doing full and incremental backups. Or uploading a massive amount of data. As you might expect, HP has done a competent job in fleshing out these features.
Using this book does require some background in the theory of relational databases. One side benefit about learning Vertica is that you can now look at traditional databases like MySql, Oracle 11g and SQL Server in a deeper level of understanding.
Overview
With the rise of Massively Parallel Processing (MPP) or NewSQL databases, many users are confused about which MPP technology to opt for. Today, HP Vertica is gaining lot of traction as a major MPP technology. Vertica's distributed architecture allows fast query processing, and is a highly fault-tolerant architecture, thus making it one of the most sought-after MPP databases today.
This book will help you to learn the day-to-day administration activities in a step-by-step format....