Neoview Database Administrator's Guide (R2.2)

Glossary
business
intelligence (BI)
A type of enterprise decision-support system (DSS).
data source The data a user wants to access and the associated operating system, database management
system (DBMS), and network platform used to access the DBMS. To manage ODBC client access
to data in a database appliance, you can add, configure, and delete ODBC data sources on the
client workstation.
data warehouse A large database that stores all data for a company in a structured way.
data-load process A component of the Neoview loader. One or more data-load processes on the data source system
read SQL data and log load statistics and errors in log files. On the HP Neoview platform, one
or more data-load processes load (insert and update) SQL data into specified tables and log
load statistics and errors in log files.
database
administrator
(DBA)
The person who defines or manages a database or controls access to a database.
driver A software program that implements a connection to a particular database management system,
such as the HP Neoview platform.
extent A file attribute that sets the size of the extents (units of contiguous disk space) that are allocated
for a table, index, or a partition of a table or index.
gcmd The command line interface to the data-load process.
gelserver process The data-load process started by the Neoview loader.
GUI Graphical user interface.
index An alternate access path (alternate key) to a table that differs from the primary access path
(clustering key) defined for the table at creation time. An index, stored in a key-sequenced file,
includes columns for the clustering key and the alternate key.
Open Database
Connectivity
(ODBC)
An interface specification for an application programming interface (API) that defines a standard
set of routines that an ODBC application can use to access data in a data source.
schema A named collection of database objects (for example, tables, views, and indexes). Each database
object is described in only one schema, although an object can refer to objects described in other
schemas. A schema cannot contain other schemas. Each schema is described in a catalog. The
schema is the unit of ownership; all database objects in a schema are owned by the schema
owner.
table A logical representation of data in a database in which a set of records is represented as a
sequence of rows, and the set of fields common to all the records is represented as a series of
columns. The intersection of a row and column represents the data value of a particular field
in a particular record. As a database object, a table defines data in columns and defines the
physical characteristics of the table.
view A logical table that contains no data. A view is derived by projecting a subset of the columns,
restricting a subset of the rows, or both, from one or more base tables or other views.
wizard In an online, graphical user interface, a series of windows that guide a user through a task. For
example, the Create a Table wizard guides a user through the steps required to create a new
table in the Neoview platform.
149