Hyperstage for PostgreSQL Reference Guide

Feedback

Copyright © 2015 Information Builders

This document describes how to set up and use WebFOCUS Hyperstage directly, beyond the scope of a typical WebFOCUS installation.

How This Manual Is Organized

This manual includes the following chapters:

Chapter/Appendix

Contents

1

About WebFOCUS Hyperstage

Introduces WebFOCUS Hyperstage, a column-oriented, high performance analytic engine designed for analytic applications.

2

Installing and Configuring the Hyperstage Database

Describes the Hyperstage technical requirements, and explains the installation and configuration steps.

3

Using the Hyperstage Database Beyond WebFOCUS

Describes how to work with Hyperstage, check its version, and use Hyperstage to improve ETL performance.

4

Managing Hyperstage Tables

Describes the Hyperstage tables.

5

Data Manipulation Statements

Describes the statements supported by Hyperstage.

6

Character Set Support

Describes how character sets are supported by the Hyperstage analytic engine.

7

Importing and Exporting Data in Hyperstage

Describes how to import and export data using the Hyperstage analytic engine.

8

Running Queries in Hyperstage

Describes how to run queries in Hyperstage.

9

Hyperstage Backup and Recovery

Describes how to backup and restore the Hyperstage databases.

A

Functions and Operators

Describes the functions and operators supported by Hyperstage.

B

Hyperstage Data Tools

Describes the data tools used by Hyperstage.

Documentation Conventions

The following table describes the documentation conventions that are used in this manual.

Convention

Description

THIS TYPEFACE

or

this typeface

Denotes syntax that you must enter exactly as shown.

                  this typeface                

Represents a placeholder (or variable) in syntax for a value that you or the system must supply.

                  underscore                

Indicates a default setting.

this typeface

Represents a placeholder (or variable), a cross-reference, or an important term. It may also indicate a button, menu item, or dialog box option that you can click or select.

Key + Key

Indicates keys that you must press simultaneously.

{  }

Indicates two or three choices. Type one of them, not the braces.

[  ]

Indicates a group of optional parameters. None are required, but you may select one of them. Type only the parameter in the brackets, not the brackets.

|

Separates mutually exclusive choices in syntax. Type one of them, not the symbol.

...

Indicates that you can enter a parameter multiple times. Type only the parameter, not the ellipsis (...).

.

.

.

Indicates that there are (or could be) intervening or additional commands.

Related Publications

Visit our Technical Content Library at http://documentation.informationbuilders.com. You can also contact the Publications Order Department at (800) 969-4636.

Customer Support

Do you have questions about this product?

Join the Focal Point community. Focal Point is our online developer center and more than a message board. It is an interactive network of more than 3,000 developers from almost every profession and industry, collaborating on solutions and sharing tips and techniques. Access Focal Point at http://forums.informationbuilders.com/eve/forums.

You can also access support services electronically, 24 hours a day, with InfoResponse Online. InfoResponse Online is accessible through our website, http://www.informationbuilders.com. It connects you to the tracking system and known-problem database at the Information Builders support center. Registered users can open, update, and view the status of cases in the tracking system and read descriptions of reported software issues. New users can register immediately for this service. The technical support section of www.informationbuilders.com also provides usage techniques, diagnostic tips, and answers to frequently asked questions.

Call Information Builders Customer Support Services (CSS) at (800) 736-6130 or (212) 736-6130. Customer Support Consultants are available Monday through Friday between 8:00 a.m. and 8:00 p.m. EST to address all your questions. Information Builders consultants can also give you general guidance regarding product capabilities. Please be ready to provide your six-digit site code number (xxxx.xx) when you call.

To learn about the full range of available support services, ask your Information Builders representative about InfoResponse Online, or call (800) 969-INFO.

Information You Should Have

To help our consultants answer your questions effectively, be prepared to provide the following information when you call:

User Feedback

In an effort to produce effective documentation, the Technical Content Management staff welcomes your opinions regarding this document. You can contact us through our website http://documentation.informationbuilders.com/connections.asp.

Thank you, in advance, for your comments.

Information Builders Consulting and Training

Interested in training? Information Builders Education Department offers a wide variety of training courses for this and other Information Builders products.

For information on course descriptions, locations, and dates, or to register for classes, visit our website (http://education.informationbuilders.com) or call (800) 969-INFO to speak to an Education Representative.