HP Big Data Schnellstart Anleitung PDF herunterladen (Seite 19)

Creating tables

You can create two types of tables in HP Vertica, columnar and flexible.

• Columnar— Columnar tables store data the way it is typically queried for performance, based

on a pre-defined data model. Column storage is ideal for read-intensive workloads because

it can reduce disk I/O.

• Flexible — Flexible tables store data in a way that is designed especially for loading and

querying unstructured and semi-structured data, such as social media files (as JSON) and

ArcSight log files.

Additionally, you can create either type of table as either persistent or temporary. You can also

create views to capture a specific set of table columns that you query frequently.

For details, see Working with Tables in the HP Vertica Administrator’s Guide and the HP Vertica

Flex Tables Guide.

Loading data into the database

If you followed the tutorial in the HP Vertica Getting Started Guide, you already loaded data into

the VMart example database. After you create a working database, you can load data in several

ways, depending on the frequency of new data and other requirements. To learn more, see the

following topics in the HP Vertica Administrator’s Guide:

• Bulk Loading Data

• Trickle Loading Data

Monitoring the database

HP Vertica provides tools that let you monitor many operational aspects of your database, and its

overall health and performance. For details about how and what to monitor, see the following

topics the HP Vertica Administrator’s Guide:

• Monitoring HP Vertica

• Using System Tables

Using HP Vertica Management Console

The Management Console (MC) interface lets you monitor and manage one or more database

clusters. You can create a new database cluster or import an existing cluster, optimize a database

design, and perform other administrative tasks on the cluster.

To learn more about Management Console, see “HP Vertica Management Console tasks” (page 19):

Table 5 HP Vertica Management Console tasks

Read:If you want to:

Management Console in the HP Vertica Concepts GuideUnderstand Management Console components and its

underlying architecture and security.

Administration Tools and Management Console in the HP

Vertica Administrator’s Guide

Understand the difference between the browser-based

Management Console versus the CLI-based Administration

Tools functionality.

Using Management Console in the HP Vertica

Administrator’s Guide

Connect to MC, manage client connections and database

clusters, manage MC settings, or change MC application

and agent ports.

Monitoring HP Vertica Using MC in the HP Vertica

Administrator’s Guide

Use MC to monitor your database cluster, query, session,

and node activity, or view MC-managed database

messages and MC user activity.

Performing common database administrator tasks 19

1 2 ... 14 15 16 17 18 19 20 21 22 23 24

Kommentare zu diesen Handbüchern

Keine Kommentare

HP Big Data Schnellstart Anleitung Seite 19

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Datenbanksoftware HP Big Data