Page tree

Skip to end of metadata
Go to start of metadata


The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.

Discover with BMC Discovery
download

This product can be discovered by Enterprise version of BMC Discovery, but you can still Download our free Community Edition to discover [other products] !

What is this?
This is a product information page, containing details of the information that BMC Discovery gathers about a product and how it is obtained.
Product Name
Vertica
Publisher Page
HP
Category
Nonrelational Database Management Systems
Release
TKU 2019-04-1
Change History
HP Vertica - Change History
Reports & Attributes
HP Vertica - Reports & Attributes
Publisher Link
HP

Product Description

The cluster-based, column-oriented Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.

Architecture

Known Versions

  • 3.0
  • 3.5
  • 4.1
  • 5.0
  • 5.1
  • 6.0
  • 6.1
  • 7.0
  • 7.1
  • 7.2

Software Pattern Summary

Product Component

OS Type

Versioning

Pattern Depth

VerticaDBNodeUnixActive, PackageInstance based
Vertica_ClusterRelated SISecond-order SI

 

Platforms Supported by the Pattern

The patterns discover HP Vertica deployed on UNIX platforms only.

Identification

Software Instance Triggers

Pattern

Trigger Node

Attribute

Condition

Argument

VerticaDBNodeDiscovered Processcmdmatchesvertica
Vertica_ClusterSoftware Instancetype=HP Vertica Database Node
and
cluster_hostsexists 

 

Simple Identification Mappings

The trigger process is given a simple identification mapping:

Name

Command

Arguments

'HP Vertica Agent'

unix_cmd 'bash'

regex "vertica/agent"

'HP Vertica Management Console'

unix_cmd 'java'

regex "vconsole/lib"

Name

Command

'HP Vertica Database'

unix_cmd 'vertica'

'HP Vertica Database Spread'

unix_cmd 'spread'

Obtaining install root

The VerticaDBNode pattern obtains install root from process using regex:

  • "(?i)(/\S+)/bin/vertica"

Obtaining the version information

Active Versioning

The VerticaDBNode pattern executes the following command :

  • "process.cmd --version"

From the output full version is extracted using regex :

  • '(?i)vertica\(v(\d+(?:\.\d+)*)'

Package Versioning

The VerticaDBNode pattern looks for packages installed that would match regex "(?i)^vertica"

Obtaining database details

The VerticaDBNode pattern obtains db details from process arguments using the following regexes:

  • "-C\s+(\S+)" - for db node type
  • "-D\s+(\S+)" - for db home
  • "-n\s+(\S+)" - for db node id

Application Model Produced by Software Pattern

Architecture

BMC Atrium Discovery uses the following approach for modeling HP Vertica components.

Software Pattern Model

Pattern Trigger

The VerticaDBNode pattern triggers on a discovered process with command line that matches specific regular expression.

The Vertica_Cluster pattern triggers on a created and confirmed HP Vertica Database Node SI that would have cluster_hosts attribute.

SI Depth

TheVerticaDBNode pattern creates an instance-based Software Instance with the key based on the SI type, and the host key.

The Vertica_Cluster pattern creates a second-order Software Instance with the key based on the cluster_hosts attribute and the SI type.

Software Context view

The image below is an example of software context view of the HP Vertica and related software:

 

Relationship creation

The pattern creates the following relationships:

model.setContainment :

  • Containment relationships where HP Vertica Database contains the trigger HP Vertica Database Node SIs that belongs to the same cluster hosts group.

Subject Matter Expertise

Subject Matter Expert input will be welcome on any other potential approaches not discussed to improving product versioning coverage and depth of
HP Vertica model.

Information Sources

Open Issues

There are no known open issues with this pattern.

The full text of this page is only available to our customers.

Please login or sign up. You may also need to provide your support ID if you have not already done so.