HP Neoview Release 2.5 Software - Manual (Page 108)

MDAM MultiDimensional Access Method. An optimized scan method that provides improved
performance for queries that contain missing predicates on key columns.
menu bar A list of commands at the top of the main window. The menu bar commands are Workspace,
Edit, Tools, Display, Windows, and Help.
merge join A join method where both tables are required to be sorted on the join column. A buffer of rows
is read from the inner and outer tables, and a row from the outer table is used to match inner
table rows in a match-merge pattern.
NDCS (Neoview
Database
Connectivity
Service) The server component that enables connectivity from client applications to the Neoview SQL
database. The Neoview Database Connectivity Service consists of an association server (MXOAS
or MXAS2), a configuration server (MXOCFG), and NDCS SQL servers.
NDCS server A process that uses data sources to launch NDCS SQL servers to manage connections.
Neoview
platform A data warehousing platform that includes processors, storage, relational database software,
data services software, and professional services dedicated to supporting business intelligence
(BI) solutions.
nested join A join method that compares each row from the outer table with each row from the inner table
to find a match between the specified join columns from the two tables.
operator Represents an event in a query plan. Also called a node.
operator tree A structure that represents operators use in a query plan as nodes, with at most one parent
node for each node in the tree, and with only one root node.
optimizer A component of the SQL compiler that chooses query plans for retrieving data from a database.
parallelism The ability of the Neoview database to execute large queries in parallel, using multiple CPUs
simultaneously. Also, parallel execution in multiple disk process fragment instances, which is
characterized by no-wait communication (asynchronous access).
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.
platform user A person or program that has access to special tools used primarily for Neoview maintenance
and troubleshooting. A platform user has exactly one platform role (with a name of the form
HP.name, SUPER.name, or NEOVIEW.name), which determines the privileges that pertain to
the user. Platform users can also log on to database interfaces but have little or no access to
data. For example, users in the role SUPER.SERVICES have no access to customer data. Contrast
with
database user .
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.
remotely
authenticated
database user A database user whose credentials (name and password) are maintained and validated on an
external LDAP or Active Directory server. Such a user can log on only if the external directory
server is running. Remotely authenticated database users must be registered on the Neoview
platform and assigned Neoview database roles. Contrast with
locally authenticated database user .
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 .
role An authorization group. A role is a vehicle for assigning data-access privileges to user IDs.
Users are granted a role, and roles are granted privileges on database objects. In this way, all
108 Glossary