HP Neoview Release 2.4 Software - Manual (Page 90)

parallelism The ability of the Neoview database to execute large queries in parallel, using multiple CPUs
simultaneously.
partitioned
parallelism A feature of the Neoview database that provides the ability to divide the data to be processed
into partitions and work on each partition in parallel. Represented by the ESP_EXCHANGE
and SPLIT_TOP operators. If your query plan does not contain either of these operators, parallel
processing was not used in the plan.
pipelined
parallelism An inherent feature of the Neoview platform that interconnects all operators by pipes, with the
output of one operator being piped as input to the next operator.
plan fragment A portion of a query plan that executes within a single process such as the disk process, ESP,
or master executor.
query A request for data from the database; specifically, the execution of a Neoview SQL statement,
which requests columns and rows from one or more tables and views. In the context of the
Neoview optimizer, a query is a request for data access through an DML statement.
query plan An execution method, including the semantics and execution characteristics, for a single compiled
SQL statement.
replicate no
broadcast No source ESPs exist. The target ESPs independently read the data they need. See type 2 join.
replicate via
broadcast Each join process receives a complete copy of the inner table from a set of ESPs that broadcast
the inner table contents. See type 2 join.
SQL statement Any DML or DDL statement including, but not limited to SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, DROP, GRANT, and REVOKE.
token Additional information about an operator found in the Description column of the Explain
output.
type 1 join A parallel execution plan in which matching partitions exist in tables that are involved in a
plan.
type 2 join A parallel execution plan the optimizer achieves by using parallel access to the inner table. The
optimizer may choose this type of plan when the inner and outer tables do not match and
repartitioning is undesirable or not possible. Two forms of the type 2 join exist: replicate no
broadcast and replicate via broadcast.
workload A set of queries specific to a certain business function (or a set of business functions).
90 Glossary