Free PDF HP Vertica Essentials, by Rishabh Agrawal
Your impression of this book HP Vertica Essentials, By Rishabh Agrawal will lead you to acquire what you specifically need. As one of the impressive publications, this publication will certainly offer the presence of this leaded HP Vertica Essentials, By Rishabh Agrawal to accumulate. Also it is juts soft data; it can be your cumulative data in gizmo and other tool. The crucial is that use this soft data book HP Vertica Essentials, By Rishabh Agrawal to review and also take the benefits. It is exactly what we imply as book HP Vertica Essentials, By Rishabh Agrawal will certainly improve your thoughts as well as mind. Then, checking out book will certainly additionally boost your life high quality much better by taking excellent action in balanced.
HP Vertica Essentials, by Rishabh Agrawal
Free PDF HP Vertica Essentials, by Rishabh Agrawal
Learn the strategy of doing something from lots of resources. Among them is this publication entitle HP Vertica Essentials, By Rishabh Agrawal It is an extremely well understood publication HP Vertica Essentials, By Rishabh Agrawal that can be suggestion to review currently. This suggested publication is one of the all wonderful HP Vertica Essentials, By Rishabh Agrawal collections that remain in this website. You will additionally discover other title and also styles from different authors to search right here.
When some individuals taking a look at you while checking out HP Vertica Essentials, By Rishabh Agrawal, you might feel so pleased. But, as opposed to other individuals feels you need to instil in on your own that you are reading HP Vertica Essentials, By Rishabh Agrawal not due to that reasons. Reading this HP Vertica Essentials, By Rishabh Agrawal will provide you greater than people appreciate. It will guide to understand more than individuals staring at you. Even now, there are numerous sources to understanding, reviewing a book HP Vertica Essentials, By Rishabh Agrawal still ends up being the front runner as a fantastic method.
Why should be reading HP Vertica Essentials, By Rishabh Agrawal Again, it will rely on how you really feel and think about it. It is definitely that a person of the benefit to take when reading this HP Vertica Essentials, By Rishabh Agrawal; you could take more lessons straight. Even you have actually not undergone it in your life; you can gain the experience by checking out HP Vertica Essentials, By Rishabh Agrawal And also currently, we will certainly present you with the on-line publication HP Vertica Essentials, By Rishabh Agrawal in this site.
What sort of book HP Vertica Essentials, By Rishabh Agrawal you will like to? Currently, you will not take the published publication. It is your time to get soft file publication HP Vertica Essentials, By Rishabh Agrawal instead the printed records. You could enjoy this soft documents HP Vertica Essentials, By Rishabh Agrawal in at any time you expect. Even it is in expected location as the various other do, you could read guide HP Vertica Essentials, By Rishabh Agrawal in your gadget. Or if you really want more, you can read on your computer system or laptop computer to obtain full display leading. Juts find it right here by downloading the soft data HP Vertica Essentials, By Rishabh Agrawal in web link page.
Learn how to deploy, administer, and manage HP Vertica, one of the most robust MPP solutions aroundAbout This Book
- 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
If you are a Vertica user or DBA who wants to perform basic administration and fine tuning, then this book is for you. Prior knowledge of Vertica will help you to understand the concepts better, but is not mandatory. Some intermediate knowledge of RDBMS, SQL, Linux, and scripting languages such as Perl or Python will be helpful.
What You Will Learn- 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.
- Sales Rank: #1957517 in Books
- Published on: 2014-05-15
- Released on: 2014-05-15
- Original language: English
- Number of items: 1
- Dimensions: 9.25" h x .24" w x 7.50" l, .43 pounds
- Binding: Paperback
- 106 pages
About the Author
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 cuttingedge 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 dancin g. You can connect with him on LinkedIn at in.linkedin.com/pub/rishabhagrawal/15/ab4/186.
Most helpful customer reviews
5 of 5 people found the following review helpful.
Falls short of the essentials needed to understand the platform
By N. Krupa
First Impression
I was quite surprised how light the book is in terms of content. Out of 106 pages, 30 are for opening/closing details (cover, copyright, credits, reviewers, table of contents, index). This leaves some 76 pages to cover the following topics:
- Chapter 1 – Installing Vertica
- Chapter 2 – Cluster Management
- Chapter 3 – Monitoring Vertica
- Chapter 4 – Backup and Restore
- Chapter 5 – Performance Improvement
- Chapter 6 – Bulk Loading
The target audience for this book are “Vertica users and DBAs who want to perform basic administration and fine tuning.” Although, prior knowledge of Vertica is not mandatory (in my opinion, a user will most likely be lost in this book).
Chapter 1 – Installing Vertica
The author begins outlining the differences of Vertica from other MPP databases and mentions that data is stored in a columnar fashion, but misses encoding on top of compression, as well as other critical features of Vertica such as its high availability. I feel the author should have also included the features that come with each version (Community vs. Enterprise) of Vertica when mentioning the Management Console. It would have been helpful to mention that the logical design that’s typically performed at the database level can be taken to the schema level.
The pre-installation requirements attempt to be covered in 4 short paragraphs. There are many other critical steps to pre-installation such as OS level configuration and hardware planning that should have been touched on. The author suggests to keep 20-30 percent of disk space free on each node, however, the official recommendation is 40%. There is also no mention that Vertica can be run on AWS or that it can be run locally using a VM image from the Marketplace.
The rest of the chapter steps through the software installation process, and mentions it aims at covering a two-node cluster installation. I can’t really come up with any good reason to demonstrate a two node installation, as the most common installation has three nodes. The output from the installation script seems completely unnecessary.
Chapter 2 – Cluster Management
Most of the material in this chapter seems to imply that projections are strictly segmented, where they can obviously also be replicated (especially in the case of smaller dimension tables in a star schema). This isn’t hinted until Chapter 5. However, the author does a descent job of explaining how skew plays a factor in segmentation.
There appears to be confusion between adding hosts to a cluster and adding nodes to a database. The distinction should be more explicit and each process individually called out as it is with removing the node from the database and removing the host from the cluster.
There is also no mention that a K-safety higher than 2 isn’t really recommended or that a minimum K-safety of 1 is required for production clusters.
The rest of the chapter does a fairly descent job describing node/host management. However, the section on spread isn’t really applicable after version 6.1 since spread is integrated into the OS.
Chapter 3 – Monitoring Vertica
This chapter fell short on a critical part of the workload management of Vertica. At the very least, there should have been a mention of resource pools, query requests, background processes, monitoring for potential problems, and on the data collector and its role in aggregating system data.
Chapter 4 – Backup and Restore
The author provides a good basic overview of the backup and restore process. Mentioning the miscellaneous settings, or parameters for vbr.py seems unnecessary and a reference to the documentation would have sufficed. When mentioning the copycluster, the author could have added more detail about how a dormant node can be used in a production environment for failover. I feel that this chapter could have highlighted more of Vertica’s high availability strategy, as some customers don’t even use backup.
Chapter 5 – Performance Improvement
The author does a poor job of comparing Vertica’s columnar architecture to traditional a row-store. While it is true that Vertica can only use columns involved with the query, this is also true in a traditional row-store under certain conditions with proper indexes. I feel a better approach would be showing an example of how the physical data is stored in each architecture.
The first section also incorrectly states that a superprojection gets created when the table is created (occurs at first data load). The remainder of the section does a reasonable job of introducing the concept. With regards to high availability and recovery, I feel it’s important to mention how Vertica uses checkpoints epochs with projections to recover data.
The material on the Database Designer seemed to completely miss the performance design priority (Balanced/Query/Load).
The remainder of the chapter briefly discusses the concept of ROS/WOS and Tuple Mover operations.
Chapter 6 – Bulk Loading
The COPY command is covered in extreme brevity. There should have been some details about monitoring loads.
Closing Thoughts
I feel that the book falls short on the discussed topics. Critical concepts such as the architecture, resource management, and monitoring/troubleshooting are not adequately covered. I couldn’t find anything that isn’t more thoroughly covered in the official documentation. There is too much space used on script outputs and screenshots.
It also seemed that the book tried to be version agnostic, however, there are many features such as the installation script, database designer and management console that have been dramatically improved and overhauled. The author should have explicitly mentioned this book focuses on version 6.1. The book comes late into the game as Version 7.0 was released late last year.
The amount of material in understanding the essentials of the platform would probably require at least three books (with 500+ pages). A proper anthology on the platform would probably look like:
- Fundamentals
- Administration
- Querying
- Development
- Internals
- Performance Tuning
I rate the book 2 out of 5 stars.
4 of 4 people found the following review helpful.
An easy "pass"
By Dimitri Shvorob
"Look on my works, ye mighty, and despair". Starting tinkering with databases in 2010 and mastering 20 databases by 2014 - while finding time for poetry, dancing and badminton - is an impressive accomplishment in anyone's book. Apart from Vertica (last touched in 2012; I remember the atrocious projections crafted by DBAs using Vertica's designer tool, and the database choking on "select ... where x in (select ...)" queries), SSAS and QlikView might be the only new technologies which I myself picked up over these years - and in each case, there was a good Packt-published book to help me along the way.
Sadly, those books were exceptions, and the typical Packt book is a low-quality quickie that looks like a digest of a better book, written by a first-time author hailing from the Indian subcontinent. "HP Vertica Essentials" is just one more example of this quantity-over-quality approach. (And so is one of the other reviews). The book is transparently inadequate, and unnecessary, given that Vertica documentation - helpfully split into thematic volumes - is only a Google search away. ("Concepts Guide" is the best place to start if you are a beginner).
2 of 2 people found the following review helpful.
Too short. Doesn't cover some important topics.
By Santosh Mathew
The book is way too short for a database book. It is not possible to explain a database in so few pages.
The installation chapter doesn't mention about using deadline for I/O scheduler which is important for read performance. There are other pre-requisites that should be mentioned if not explained in detail.
It would have been useful to explain vsql and frequently used commands to get started.
Resource pool which is a very important part of the Vertica architecture was not covered.
Security was not covered.
In my opinion, the purpose of writing a book on database should be to ensure better understanding of concepts and sharing insights got from experience and testing. Most of the book feels like reading the official documentation.
HP Vertica Essentials, by Rishabh Agrawal PDF
HP Vertica Essentials, by Rishabh Agrawal EPub
HP Vertica Essentials, by Rishabh Agrawal Doc
HP Vertica Essentials, by Rishabh Agrawal iBooks
HP Vertica Essentials, by Rishabh Agrawal rtf
HP Vertica Essentials, by Rishabh Agrawal Mobipocket
HP Vertica Essentials, by Rishabh Agrawal Kindle
Tidak ada komentar:
Posting Komentar