Ebook HP Vertica Essentials, by Rishabh Agrawal
You could save the soft data of this book HP Vertica Essentials, By Rishabh Agrawal It will rely on your downtime and also tasks to open as well as review this e-book HP Vertica Essentials, By Rishabh Agrawal soft file. So, you may not hesitate to bring this e-book HP Vertica Essentials, By Rishabh Agrawal almost everywhere you go. Merely include this sot documents to your gadget or computer system disk to allow you review whenever as well as everywhere you have time.
HP Vertica Essentials, by Rishabh Agrawal
Ebook HP Vertica Essentials, by Rishabh Agrawal
Just how if there is a site that enables you to look for referred book HP Vertica Essentials, By Rishabh Agrawal from all over the globe author? Instantly, the site will certainly be incredible completed. A lot of book collections can be located. All will be so simple without difficult point to move from website to website to obtain guide HP Vertica Essentials, By Rishabh Agrawal desired. This is the site that will give you those assumptions. By following this site you can obtain lots varieties of book HP Vertica Essentials, By Rishabh Agrawal compilations from variants types of author and also author popular in this globe. Guide such as HP Vertica Essentials, By Rishabh Agrawal and also others can be obtained by clicking great on web link download.
This letter might not influence you to be smarter, yet the book HP Vertica Essentials, By Rishabh Agrawal that we offer will evoke you to be smarter. Yeah, at least you'll understand greater than others which do not. This is exactly what called as the quality life improvisation. Why should this HP Vertica Essentials, By Rishabh Agrawal It's considering that this is your favourite style to review. If you similar to this HP Vertica Essentials, By Rishabh Agrawal motif about, why don't you check out guide HP Vertica Essentials, By Rishabh Agrawal to enhance your discussion?
The presented book HP Vertica Essentials, By Rishabh Agrawal we provide here is not sort of normal book. You recognize, checking out currently doesn't imply to manage the printed book HP Vertica Essentials, By Rishabh Agrawal in your hand. You could obtain the soft documents of HP Vertica Essentials, By Rishabh Agrawal in your device. Well, we suggest that the book that we extend is the soft documents of guide HP Vertica Essentials, By Rishabh Agrawal The content and all points are same. The difference is just the types of guide HP Vertica Essentials, By Rishabh Agrawal, whereas, this condition will exactly pay.
We share you likewise the way to obtain this book HP Vertica Essentials, By Rishabh Agrawal without going to guide store. You can continuously see the link that we give and also prepared to download and install HP Vertica Essentials, By Rishabh Agrawal When lots of people are active to seek fro in the book establishment, you are quite simple to download and install the HP Vertica Essentials, By Rishabh Agrawal right here. So, just what else you will choose? Take the motivation here! It is not just offering the best book HP Vertica Essentials, By Rishabh Agrawal yet also the best book collections. Right here we constantly offer you the very best and easiest method.
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