Neoview Database Administrator's Guide (R2.5)

Materialized Views
A materialized view is like a cache: a copy of data that can be accessed quickly. It is a named
specification of a result table that is stored in a regular table. You can then query this table
(materialized view) directly. For complete information about creating and performing other
actions on materialized views, see the Neoview SQL Reference Manual and the Neoview Command
Interface (NCI) Guide.
Materialized View Groups
When you create a materialized view, a materialized view group is created automatically. It has
the same name as the table that the materialized view references. You can also create a materialized
view group manually. For complete information about creating and performing other actions
on materialized view groups, see the Neoview SQL Reference Manual and the Neoview Command
Interface (NCI) Guide.
Triggers
A trigger is a mechanism that resides in the database and specifies that when a particular
action—an insert, delete, or update—occurs on a table, SQL should automatically perform one
or more additional actions. For complete information about creating and performing other actions
on triggers, see the Neoview SQL Reference Manual and the Neoview Command Interface (NCI) Guide.
Synonyms
A synonym is an alternate name that can replace multi-part or fully-qualified names for SQL
objects. You can refer to an object by its name or by the synonym. For complete information
about creating and performing other actions on synonyms, see the Neoview SQL Reference Manual
and the Neoview Command Interface (NCI) Guide.
Data Types
For details about data types supported on the Neoview platform, refer to the Neoview SQL
Reference Manual.
Stored Procedures in Java (SPJs)
The Neoview database supports stored procedures in Java (SPJs). A stored procedure is a type
of user-defined routine (UDR) that operates within a database server. For details about creating
and managing SPJs, see the Neoview Guide to Stored Procedures in Java.
Viewing System Events
If you are a user with administrative privileges, you can view dial-out and database events on
the Neoview platform by using HPDM. For more information about system events and viewing
system events, see the HPDM online help and the HP Database Manager (HPDM) User Guide. For
more information about messages, see the Neoview Messages Manual.
Loading and Extracting Data with Neoview Transporter
Neoview Transporter is an ETL (Extract/Transform/Load) tool that provides processes and
commands for loading data into your Neoview platform or extracting data from it. You can also
move data between HP Neoview and other platforms. For detailed information about Neoview
Transporter, see the Neoview Transporter User Guide.
Data Types 17